Urtzi Exactly what error message are you getting in the tomcat logs ?
David Urtzi Larrazabal wrote: > >My situation is: > -Tomcat running as tomcat user. > -JDBC connection thought a mysql user with a especific privileges in a >database. > >then why ? > >If I run tomcat as root the connection to mysql can be done. > >If I run tomact as tomcat user the connection to mysql can't be done. > > > >-----Original Message----- >From: Capr1ce [mailto:[EMAIL PROTECTED]] >Sent: viernes 16 de agosto de 2002 13:17 >To: Tomcat Users List >Subject: RE: Run Tomcat as tomcat user > > > >Nearly... > >The mysql user can be called anything you want. >I usually have a user set up in MySql specifically for Java called >'javaUser'. I give them select, insert, delete and update privileges. > >The UNIX mysql user is very separate than the mysql users. You shouldn't >need to do anything with the UNIX mysql user. I believe this is used by >mysql so it can the correct privileges to read and write the databases. >Users for mysql are so you can set up who is allowd to connect to the mysql >and what they can do when they connect. ie. can they create databases, >update databases, which databases they can update etc. > > >At 01:02 PM 16/08/2002 +0200, you wrote: > > > >>Let me Understand, >> >>To run tomcat as tomcat user and be able to connect to mysql thought JDBC >>I need: >> >> >>On my unix machine have a user named tomcat which runs tomcat. >>On mysql have other user named tomcat. >>And the connection thought JDBC must be done with the user and password >>created in mysql. >> >>-----Original Message----- >>From: Capr1ce [mailto:[EMAIL PROTECTED]] >>Sent: viernes 16 de agosto de 2002 12:57 >>To: Tomcat Users List >>Subject: RE: Run Tomcat as tomcat user >> >> >> >>No they don't need to have the same password. >>When your JSP/Java code connects to the MySql database using JDBC, you >>should use the mysql user to connect. >> >> >>At 12:48 PM 16/08/2002 +0200, you wrote: >> >> >>>�the unix tomcat user and the mysql tomcat user must have the same password? >>> >>>-----Original Message----- >>>From: Capr1ce [mailto:[EMAIL PROTECTED]] >>>Sent: viernes 16 de agosto de 2002 12:40 >>>To: Tomcat Users List >>>Subject: RE: Run Tomcat as tomcat user >>> >>> >>> >>>A password is not necessary, but certainly recommended. >>> >>>See these sections of the mysql documentation: >>>http://www.mysql.com/doc/en/GRANT.html >>>http://www.mysql.com/doc/en/Adding_users.html >>> >>> >>>At 12:31 PM 16/08/2002 +0200, you wrote: >>> >>> >>>>Hi Andy ! >>>> >>>>Thanks for your response. >>>> >>>>I have created a user named tomcat in mysql and I have granted acccess >>>>but...I haven't created any password for this user, is necesary a >>>> >>>> >>password?? >> >> >>>>Urtzi >>>> >>>>-----Original Message----- >>>>From: Andy Eastham [mailto:[EMAIL PROTECTED]] >>>>Sent: viernes 16 de agosto de 2002 12:25 >>>>To: Tomcat Users List >>>>Subject: RE: Run Tomcat as tomcat user >>>> >>>> >>>>Urtzi, >>>> >>>>You need to grant access to the tomcat user. See the section in the GRANT >>>>command in the mysql manual (available online at the www.mysql.com site). >>>>By default, root can connect without a password, but other users need >>>> >>>> >>to be >> >> >>>>granted access. >>>> >>>>You'll need to execute something like: >>>>GRANT ALL PRIVILEGES on *.* to nobody@yourhostname identified by >>>>'nobodyspassword'; >>>> >>>>The password is not the unix password - its mysql specific and set by this >>>>command. >>>> >>>>I recommend you read up to make sure you're only grant what you need - >>>> >>>> >>after >> >> >>>>all there's no point running as nobody if it can do everything root can... >>>> >>>>Test it by doing >>>>su - nobody >>>>then check that you can connect with the password you've set. >>>> >>>>Andy >>>> >>>> >>>> >>>>>-----Original Message----- >>>>>From: Urtzi Larrazabal [mailto:[EMAIL PROTECTED]] >>>>>Sent: 16 August 2002 11:04 >>>>>To: [EMAIL PROTECTED] >>>>>Subject: Run Tomcat as tomcat user >>>>> >>>>> >>>>> >>>>>Hi ! >>>>> >>>>>I am trying to run tomcat as tomcat user. When I start it, it >>>>>seems to start without any problem. I execute some jsp and it >>>>>works fine but when I execute a page tha require to connect to >>>>>mysql database it cant't connect to the database and an empty log >>>>>named something like DCB_1029483253596.log is generated. Running >>>>>tomcat as root I haven't any problem. >>>>> >>>>>�any idea? >>>>> >>>>>Regards, >>>>> >>>>>Urtzi. >>>>> >>>>> >>>>>-- >>>>>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]> >> >> >>>-- >>>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]> > >-- >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]>
