I encountered this problem:

I followed the instructions on using the JDBCRealm
(http://jakarta.apache.org/tomcat/tomcat-4.1-doc/realm-howto.html).
I prepared userTable and userRoleTable tables.
However, I could not start the Tomcat server after I
inserted

[CODE]
<Realm className="org.apache.catalina.realm.JDBCRealm"
debug="99"
  driverName="com.mysql.jdbc.Driver"
 
connectionURL="jdbc:mysql://localhost:3306/artimus?user=javauser&password=javadude"
  userTable="members" userNameCol="user_name"
userCredCol="user_password"
  userRoleTable="user_roles"
roleNameCol="user_role"/>
[/CODE]

within the <Engine> tag in the
$CATALINA_HOME/conf/server.xml file.

I first inserted the aforementioned Realm within the
<context> tag in the $CATALINA_HOME/conf/server.xml
and I was unable to start the Tomcat server. I then
moved the Realm inside the <Engine> tag, but it did
not help.

By the way, do you think the user and password given
in the JDBCRealm are correct? I configured database
username and password for use by Tomcat in the
$CATALINA_HOME/conf/server.xml in the following way
and I have used this database many times without
problem.

[CODE]
    <DefaultContext>
     <Resource name="jdbc/MySQLDB" auth="Container"
    type="javax.sql.DataSource"/>
     <ResourceParams name="jdbc/MySQLDB">
           <parameter>
               <name>factory</name>
             
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
           </parameter>
    <parameter>
     <name>driverClassName</name>
     <value>com.mysql.jdbc.Driver</value>
    </parameter>
    <parameter>
       <name>url</name>
     
<value>jdbc:mysql://localhost:3306/artimus?autoReconnect=true</value>
    </parameter>
    <parameter>
       <name>username</name>
       <value>javauser</value>
    </parameter>
    <parameter>
       <name>password</name>
       <value>javadude</value>
    </parameter>
    <parameter>
       <name>maxActive</name>
       <value>20</value>
    </parameter>
    <parameter>
       <name>maxIdle</name>
       <value>30</value>
    </parameter>
    <parameter>
       <name>maxWait</name>
       <value>10000</value>
    </parameter>
           <parameter>
               <name>removeAbandoned</name>
               <value>true</value>
           </parameter>
           <parameter>
             
<name>removeAbandonedTimeout</name>
               <value>60</value>
           </parameter>
           <parameter>
               <name>logAbandoned</name>
               <value>true</value>
           </parameter>

        </ResourceParams>
 </DefaultContext>
[/CODE]


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)