[cobalt-users] JSP, Servlets and Connections to a mysql-database, SocketPermissions

["CMO - Thorsten Mitschele" <mitschele@xxxxxx>]

We have had problems with security while trying to connect to a
mysql-database on an external database server.

If we tried to connect locally from a RaQ4i to our DB-Server everything
worked fine.. Errors occur if we then tried to connect through a JSP.

The Things we than changed to get everything working was changing the
permissions in the tomcat.policy. But the file was overwritten by a
cobalt-script.

So we did the changes directly in the scripts:

We have installed the MySQL-Driver in
/usr/java/jakarta-tomcat-3.2.1/lib

And put a line in

/usr/java/jakarta-tomcat-3.2.1/bin/cobalt_config.pl

print NEW_POLICY "  permission java.net.SocketPermission \"*:3306\",
\"listen,connect\";\n";

After doing thei sthe tomcat.policy file gets written right by the
cobalt_config.pl-Script and everything works fine.

Maybe this is interesting for someone here :-)


Mit freundlichen Grüßen,

Thorsten Norman Mitschele
Geschäftsführer

----------------------------------------------
CMO Internet Dienstleistungen GmbH
Postfach 13 35          72577 Dettingen / Erms
Tel: 07123 / 72 67-0    Fax: 07123 / 72 67-150
e-Mail: info@xxxxxx     Web: http://www.cmo.de