Re: Could Not Start The Tomcat Server After Commenting Out Realm in the server.xml For Using JDBCRealm

[Tim Funk]

Tomcat won't start up if the Realm can't start up. Since you didn't replace 
your connection information with the dummy JDBCRealm placeholder, the 
connection failed to the database.

As for the &, in your connection string in your older email had:
connectionURL="jdbc:mysql://localhost:3306/artimus?user=javauser&password=javadude"
Which should be:
connectionURL="jdbc:mysql://localhost:3306/artimus?user=javauser&password=javadude"
-Tim

Caroline Jen wrote:

Thanks for your reply.  I tried the following:

1) I put <!-- and --> around the UserDababaseRealm
shown below:
<!--
<Realm
className="org.apache.catalina.realm.UserDatabaseRealm"
                 debug="0"
resourceName="UserDatabase"/>
-->
2) I removed the <!-- and --> around the JDBCRealm for
MySql (I did not insert any of my code, I simply use
the existing code in the server.xml) and I do not see
any & in that section of code.  See below:
<Realm 
className="org.apache.catalina.realm.JDBCRealm"
debug="99"
  driverName="org.gjt.mm.mysql.Driver"
  connectionURL="jdbc:mysql://localhost/authority"
  connectionName="test" connectionPassword="test"
  userTable="users" userNameCol="user_name" 
                     userCredCol="user_pass"
  userRoleTable="user_roles" roleNameCol="role_name"
/>

I saved the file and I could not start the Tomcat
server.
I then reverted everything back, the Tomcat server
works as normal.  Wondering what is going on?
-Caroline
--- Tim Funk <[EMAIL PROTECTED]> wrote:
1) For simplicity, did you coment out the
UserDatabaseRealm when placing your 
JDBCRealm at the same level?

2) Make sure the & are encoded as &amp; Otherwise -
you xml document is not 
valid.

-Tim

Caroline Jen wrote:


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.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]