Just a note about the connection URL. MySQL requires an amperstand between the user and password parameters. So a correct URL (encoded for XML) will be:
connectionURL="jdbc:mysql://localhost/tomcatusers?user=tet&password=test" Hope it helps... --David On Tuesday 05 March 2002 02:17 pm, you wrote: > Hi, John, > > You need to switch your security realm from Memory Realm to > JdbcRealm. Then you need to reconfigure the > <TOMCAT_HOME>/conf/server.xml. Comment <Realm > className="org.apache.catalina.realm.MemoryRealm" /> out! Then set up your > MySql as follows: > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > driverName="org.gjt.mm.mysql.Driver" > connectionURL="jdbc:mysql://localhost/tomcatusers?user=tet;password=test" > userTable="users" userNameCol="user_name" userCredCol="user_pass" > userRoleTable="user_roles" roleNameCol="role_name" /> > > Okay dokay? > > Micael > > At 02:11 PM 3/5/02 -0500, you wrote: > >Hello. I would like to be able to use a MySQL table for my user > >authentication instead of the unencryptable tomcat-users.xml. I have > >looked for this documentation, but have yet to find it. Anyone have > >ideas/knowledge they care to impart? > > > >John Hollingsworth > > > > > >-- > >To unsubscribe: <mailto:[EMAIL PROTECTED]> > >For additional commands: <mailto:[EMAIL PROTECTED]> > >Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
