ODP: Tomcat and mySQL
ok, now i know what's happening, looking at the process list i can see that upon startup tomcat logs as specified by connectionUser/Password strings from server.xml files. but then for no apparent reason it tries to reconnect as nobody without providing passwd. how can i fix that? vVolf > -Oryginalna wiadomość- > Od: Cato, Christopher [mailto:[EMAIL PROTECTED]] > Wysłano: 28 lutego 2001 17:56 > Do: '[EMAIL PROTECTED]' > Temat: RE: Tomcat and mySQL > > > Add ;autoreconnect=true to the db connect string. > > > -Original Message- > > From: Herchel Wojciech [mailto:[EMAIL PROTECTED]] > > Sent: den 28 februari 2001 17:32 > > To: 'Tomcat' > > Subject: Tomcat and mySQL > > > > > > Hi! > > > > I'm using JDBCRealm authorisation. > > How can I force mySQL not to close the connection Tomcat > > opened upon startup > > (to database where users, roles, user_roles tables are stored)? > > i assume mySQL's variable wait_timeout is responsible for > > closing inactive > > connections. the default is 28800 secs, will changing it to > > zero do the > > trick? or else? anyone? > > > > regards, > > > > vVolf > > > > > - > > 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]
ODP: Tomcat and mySQL
ok, i've checked tomcat logs - it tries to reconnect, but then it reports: There was a SQLException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) why does tomcat log as 'nobody'? although in server.xml there is a different connectionUser specified. how can i make it to use original connection user and passwd? vVolf > -Oryginalna wiadomość- > Od: Cato, Christopher [mailto:[EMAIL PROTECTED]] > Wysłano: 28 lutego 2001 17:56 > Do: '[EMAIL PROTECTED]' > Temat: RE: Tomcat and mySQL > > > Add ;autoreconnect=true to the db connect string. > > > -Original Message- > > From: Herchel Wojciech [mailto:[EMAIL PROTECTED]] > > Sent: den 28 februari 2001 17:32 > > To: 'Tomcat' > > Subject: Tomcat and mySQL > > > > > > Hi! > > > > I'm using JDBCRealm authorisation. > > How can I force mySQL not to close the connection Tomcat > > opened upon startup > > (to database where users, roles, user_roles tables are stored)? > > i assume mySQL's variable wait_timeout is responsible for > > closing inactive > > connections. the default is 28800 secs, will changing it to > > zero do the > > trick? or else? anyone? > > > > regards, > > > > vVolf > > > > > - > > 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]