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=tetamp;password=test
Hope it helps...
--David
On Tuesday 05 March 2002 02:17 pm,
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
John,
Also make sure that the JAR file containing the JDBC driver referenced by
the driverName attribute is placed in Tomcat's CLASSPATH. If you are using
the JDBC-ODBC bridge, the driver is already in Tomcat's CLASSPATH.
Micael
At 02:11 PM 3/5/02 -0500, you wrote:
Hello. I would like to be
Also, John,
Normally you would want to use three tables:
user table (with user_name and user_pass columns)
create table users
{
user_name VARCHAR(15) not null primary key,
user_pass VARCHAR(15) not null
};
roles table (with role_name column)
create table roles
{
role_name VARCHAR(15)
Apress publishing company has a book that deals with this topic called Apache
Jakarta-Tomcat (I forget the authors name but if you go to Amazon.com you will find
it). Basically you define your mySQL schema into the Realm section for your virtual
server. Then you comment out the MemoryRealm,