How do I use a JDBC Realm with Tomcat and MySQL?
Author: Deron Eriksson
Description: This Tomcat tutorial describes how to configure Tomcat to use a JDBC Realm with MySQL for container-managed security.
Tutorial created using: Windows XP || JDK 1.5.0_09 || Eclipse Web Tools Platform 2.0 (Eclipse 3.3.0) || Tomcat 5.5.20
(Continued from page 2)
In a browser, I'll attempt to hit the test servletW via http://localhost:8080/tomcat-demo/test. Since we're using Basic authentication and this is a protected resource, a pop-up window appears asking for a name and password.
I'll try entering an invalid name and password. This doesn't work.
I'll enter a good name and password. In our tomcat_realm databaseW, we created a user called 'deron' with a password of 'deronpass'. The 'deron' user has the roles of 'dude' and 'manager'. Since our web.xmlW specifies that a user with the role of 'dude' is required, 'deron'/'deronpass' should work.
The user name and password is authenticated, and we are granted access to the test servlet.