You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@tomcat.apache.org by Caroline Jen <ji...@yahoo.com> on 2003/10/09 02:07:07 UTC

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

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@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

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

Posted by Caroline Jen <ji...@yahoo.com>.

Tim, thanks for your help.  The server workes now.
--- Tim Funk <fu...@joedog.org> wrote:
> If your realm declaration is:
>  > <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" />
> 
> Then tomcat will try to connect to localhost for the
> database "authority" 
> with the user id and password being test. (If I read
> the props above 
> correctly). If that connection fails when the Realm
> is created (which is at 
> tomcat startup) - then tomcat will not startup.
> 
> -Tim
> 
> Caroline Jen wrote:
> 
> > Tim, sorry, I do not understand "Since you didn't 
> > replace your connection information with the dummy
> > JDBCRealm placeholder, the connection failed to
> the
> > database."  
> > 
> > Now, I am testing the Tomcat using the existing
> code
> > in the server.xml file by simply removing the
> > surroundinging <!--  and -->. (I understand what
> you
> > said about &amp;)
> > 
> > I could not start the Tomcat server.  
> > 
> > 1) I put <!-- and --> around the UserDababaseRealm
> as
> > shown below:
> >  
> > <!--
> > <Realm
> >
>
className="org.apache.catalina.realm.UserDatabaseRealm"
> >            debug="0"
> > resourceName="UserDatabase"/>
> > -->
> > 
> > 2) I removed the <!-- and --> around the JDBCRealm
> > for MySql (I do not insert any of my code, I
> simply
> > use the existing code in the server.xml).  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.
> > 
> > -Caroline
> > 
> > 
> 
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> 


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

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

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

Posted by Tim Funk <fu...@joedog.org>.

If your realm declaration is:
 > <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" />

Then tomcat will try to connect to localhost for the database "authority" 
with the user id and password being test. (If I read the props above 
correctly). If that connection fails when the Realm is created (which is at 
tomcat startup) - then tomcat will not startup.

-Tim

Caroline Jen wrote:

> Tim, sorry, I do not understand "Since you didn't 
> replace your connection information with the dummy
> JDBCRealm placeholder, the connection failed to the
> database."  
> 
> Now, I am testing the Tomcat using the existing code
> in the server.xml file by simply removing the
> surroundinging <!--  and -->. (I understand what you
> said about &amp;)
> 
> I could not start the Tomcat server.  
> 
> 1) I put <!-- and --> around the UserDababaseRealm as
> shown below:
>  
> <!--
> <Realm
> className="org.apache.catalina.realm.UserDatabaseRealm"
>            debug="0"
> resourceName="UserDatabase"/>
> -->
> 
> 2) I removed the <!-- and --> around the JDBCRealm
> for MySql (I do not insert any of my code, I simply
> use the existing code in the server.xml).  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.
> 
> -Caroline
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

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

Posted by Caroline Jen <ji...@yahoo.com>.

Tim, sorry, I do not understand "Since you didn't 
replace your connection information with the dummy
JDBCRealm placeholder, the connection failed to the
database."  

Now, I am testing the Tomcat using the existing code
in the server.xml file by simply removing the
surroundinging <!--  and -->. (I understand what you
said about &amp;)

I could not start the Tomcat server.  

1) I put <!-- and --> around the UserDababaseRealm as
shown below:
 
<!--
<Realm
className="org.apache.catalina.realm.UserDatabaseRealm"
           debug="0"
resourceName="UserDatabase"/>
-->

2) I removed the <!-- and --> around the JDBCRealm
for MySql (I do not insert any of my code, I simply
use the existing code in the server.xml).  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.

-Caroline


--- Tim Funk <fu...@joedog.org> wrote:
> 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&amp;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 <fu...@joedog.org> 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:
> tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> 


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

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

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

Posted by Tim Funk <fu...@joedog.org>.

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&amp;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 <fu...@joedog.org> 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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

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

Posted by Caroline Jen <ji...@yahoo.com>.

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 <fu...@joedog.org> 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:
> tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> 


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

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

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

Posted by Tim Funk <fu...@joedog.org>.

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@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org