I am using mySql for both tomcat jdbc realms and general web app use. I
have a copy of the mysql_comp.jar file in the lib directory of tomcat. I
tried placing the source there without luck. The jar worked like a charm
though. The mysql_comp.jar file was in the copy of mysql that I
downloaded from a link on the jakarta tomcat site.
For general DB stuff I followed the JDBC tutorials and a tutorial on
using mySql with JDBC. It covered the proper connection string, etc...
As for the realms, I uncommented the sample entry in the server.xml file
and changed the conenction string, etc to what was appropriate. I then
copied the web.xml file from the examples/WEB-INF/ dir into the WEB-INF
dir in my apps root dir. I have my root dir under /home/httpd/custdb/
with a sym link for it in the tomcat/webapps/ dir. This works like a
charm for me. Just remember to comment the simpleRealms part when
setting up a JDBCrealm. The log will show it was authed, but the browser
will say otherwise if you leave the simpleRealm entry active.
~Rob
Andrew Burrows wrote:
>
> Sounds like you may have to wait for the next full moon as I have already
> done + I used 7 virgins and had to kill 3 young lambs.
>
> Anyway tomcat and apache are working fine but i am still trying to come to
> grips with how the connect works through to mysql.
>
> Dose it use the drive setup in WEB-INF and do i need to install the driver
> some were on the system.
>
> The system i am working on is.
> Linux don't know i think version 7 red hat
> Apache 1.3.9
> tomcat 1.3
> mysql good question
>
> > From: Glen Campbell <[EMAIL PROTECTED]>
> > Reply-To: [EMAIL PROTECTED]
> > Date: Wed, 10 Jan 2001 21:21:16 -0800
> > To: <[EMAIL PROTECTED]>
> > Subject: Re: Info on connections using mysql
> >
> > On 1/10/01 8:49 PM, "Andrew Burrows" <[EMAIL PROTECTED]> casually stated:
> >
> >> Hi All tomcat people,
> >> Could someone point me in the right direction to find info on using mysql in
> >> conjunction with tomcat/apache.
> >>
> >> Thanks
> >>
> >> [EMAIL PROTECTED]
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: [EMAIL PROTECTED]
> >> For additional commands, email: [EMAIL PROTECTED]
> >>
> >>
> > Hi - I'm doing that sort of thing myself. I'm running Linux (redhat 7) with
> > Apache 1.4 and Tomcat 3.2.1. I've gotten Tomcat running standalone, and I'm
> > about to start work on integrating it with Apache. All the documentation
> > says to use mod_jserv to handle this, but many people on the list have
> > suggested that mod_jk is easier to configure. I believe mod_jserv is pretty
> > easy, too, except you have to wait for the next full moon and the procedure
> > seems to require three virgins for some reason. Mod_jk is not available
> > standalone anywhere, as far as I can tell; you have to download the Tomcat
> > sources and build it from that. I'll let you know how my adventures proceed.
> >
> > Glen
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, email: [EMAIL PROTECTED]
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
--
_______________________________________
Robert Wohleb
Web Applications Development Manager
Parafoil Software, Inc.
_______________________________________
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
