Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Tomcat Users »

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

Caroline Jen

2003-10-08

Replies:

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 <funkman@(protected):
> 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:
> tomcat-user-unsubscribe@(protected)
> For additional commands, e-mail:
> tomcat-user-help@(protected)
>


__________________________________
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)


©2008 junlu.com - Jax Systems, LLC, U.S.A.