I guess my problem could be related to mysql. I'm new to that to.
I'm using a gui for mysql.
In the server.xml file I listed the User and the password. The user has
privileges to the database.
I have a different user for JDBCStore and one for JDBCRealm.
<Context path="/library2" docBase="library2" debug="0" reloadable="true">
<Manager className="org.apache.catalina.session.PersistentManager"
debug="0"
saveOnRestart="true"
maxActiveSessions="50"
minIdleSwap="-1"
maxIdleSwap="-1"
maxIdleBackup="-1">
<Store
className="org.apache.catalina.session.JDBCStore"
driverName="org.gjt.mm.mysql.Driver"
connectionURL="jdbc:mysql://localhost/tomcatsessions?user=SessionTracking;pa
ssword=tracking"
sessionTable="sessions"
sessionIdCol="id"
sessionDataCol="data"
sessionValidCol="valid"
sessionMaxInactiveCol="maxinactive"
sessionLastAccessedCol="lastaccess"
checkInterval="60"
debug="99" />
</Manager>
</Context>
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="org.gjt.mm.mysql.Driver"
connectionURL="jdbc:mysql://localhost/tomcatusers"
connectionName="LibraryManager"
connectionPassword="home7lib8"
userTable="users" userNameCol="user_name" userCredCol="user_pass"
userRoleTable="users_roles" roleNameCol="role_name" />
-----Original Message-----
From: The Kelley's [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 8:47 AM
To: Tomcat Users List
Subject: RE: Please recommend book or Other Help
I used the connectionname and connectionpassword too. It did work... Until I
added JDBCStore for session tracking. Then I got a Java:IOException Stream
closed.
Have you tried the JDBCStore?
Tim
-----Original Message-----
From: Eddie Bush [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 12:23 PM
To: Tomcat Users List
Subject: Re: Please recommend book or Other Help
What is your problem with the JDBCRealm? I have that going fine. One
thing to note, you probably don't want to append your username/password
to the url. Instead, use connectionName and connectionPassword to
specify them. That was the only real issue I faced in getting it to work.
Regards,
Eddie
The Kelley's wrote:
>I'm having problems with JDBCRealms and JDBCStore in Tomcat.
>They seem buggy to me. Any expert help would be great.
>I good book would be even better.
>I already have James Goodwill's "Apache Jakarta Tomcat" book
>
>Thanks
>Tim
>
>
>--
>To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
>For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
