help with basic authentication

[Stephen Huey]

I'm not the original developer who set this up, but I'm told we had to do it this way because our main database where most of the data for our web app would not authenticate with Tomcat, so they set up a MySQL database on the webserver whose only reason for existence is to authenticate the users. Now we have an updated version of the main database we use (which we connect to over ODBC, not JDBC--yeah, don't ask), and so we're curious as to whether or not we might now be able to authenticate with this updated database instead of still having to rely on this second MySQL database.

I'm not really familiar with how to change this part of our web.xml, though:

  <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="org.gjt.mm.mysql.Driver" connectionURL="jdbc:mysql://127.0.0.1/usersdb" connectionName="WebUser" connectionPassword="WebAppPass" userTable="users" userNameCol="Username" userCredCol="Password" userRoleTable="roles" roleNameCol="Role" /> 

Any ideas? Since there's no JDBC driver for our main database, I'm thinking we can't even use that JDBCRealm stuff anymore, and wondering if we might have to convert from basic authentication to form-based authentication. Thanks a bunch for any suggestions!

[somkiat puisungnoen]

<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
[B] driverName="sun.jdbc.odbc.JdbcOdbcDriver" 
connectionURL="jdbc:odbc:usersdb" 
[/B]
connectionName="WebUser" connectionPassword="WebAppPass" userTable="users" userNameCol="Username" userCredCol="Password" userRoleTable="roles" roleNameCol="Role" /> 

This will help you.
[ September 16, 2004: Message edited by: Somkiat Puisungnoen ]

[Carl Sampson]

You could use the Jdbc-Odbc Bridge-

The driverName is sun.jdbc.odbc.JdbcOdbcDriver
The URL would look something like jdbc dbc:<connection name>