Re: Info on connections using mysql
here is what I did 1. grap the mm.mysql jdbc driver ( check www.mysql.com ) 2. untar the file to eg /usr/local/mm.mysql 3. in your tomcat.sh file, add classpath to include the mysql jar ( ie export CLASSPATH=/usr/local/mm.mysql/mysql.jar:$CLASSPATH ). 4. write your code and use it. I didn't put the mysql.jar in the WEB-INF since I have multiple instance of Tomcat running. So, add a classpath in tomcat.sh can let all Tomcat instance use the mysql jdbc driver Andrew Burrows To: <[EMAIL PROTECTED]> Subject: Re: Info on connections using mysql 01/10/2001 09:33 PM Please respond to tomcat-user 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
Re: Info on connections using mysql
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]
Re: Info on connections using mysql
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]
Re: Info on connections using mysql
I recently downloaded a binary pre-compiled version of mod_jk from http://jakarta.apache.org, and I use it to put tomcat to work easily (well, relatively, because I'm a newbie and do stupid errors). Without compiling anything. Orestes. Glen Campbell wrote: > > 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] begin:vcard n:Mas i Casals;Orestes tel;fax:+34.93.401.72.00 tel;work:+34.93.401.70.72 x-mozilla-html:TRUE org:Universitat Politècnica de Catalunya;TSC version:2.1 email;internet:[EMAIL PROTECTED] title:Dr. adr;quoted-printable:;;Campus Nord - UPC=0D=0Ac/Gran Capit=E0 s/n=0D=0AM=F2dul D4;BARCELONA;;08034;Spain x-mozilla-cpt:;0 fn:Orestes Mas i Casals end:vcard - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
Re: Info on connections using mysql
Nay... you can build mod_jk with a bin distribution. I did so myself. I setup my system with the bin dists of both apache and tomcat. I also switched from mod_jserv to mod_jk without trouble. This is after compiling mod_jk by the way. Here is what I did in my expereience... I had mod_jserv linked into apache by including the auto generated conf by tomcat. I couldn't find the .so for mod_jk anywhere. Finally I found a reference at the end of the mod_jk and apache integration instructions page saying it had to be compiled. It appears it was added later. I barely saw it. I found instructions on compiling the mod_jk.so file using axps(spelling?) program that is part of the apache package. As I said, this was all with the bin dists. I then put it into the libexec directory and included the mod_jk auto generated conf. It worked form then on... By the way, I think there was a post not long ago saying bin dists of mod_jk were finally being put up. I may be wrong. There was at least a message linking a page with the rpms which were generated by a good samaritan... ~Rob Glen Campbell wrote: > > 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] -- ___ Robert Wohleb Web Applications Development Manager Parafoil Software, Inc. ___ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
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]
Info on connections using mysql
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]
