[opencms-dev] can't start opencms after mysql password change

[mwpowell at adelphia.net]

All,

This has something to do with the way in which I am starting tomcat. I can sucessfully start tomcat and opencms when I start tomcat from a command line using the startup.sh script. 

However, when using an automated init.d script to startup tomcat it fails. I'm confused about this because this was working flawlessly in the past.  However, I recently changed the password to the root user on the linux box as well (I'm using Fedora Core 4). 

The init.d script uses the following command to start tomcat....

daemon su -c /usr/local/jakarta-tomcat-4.1.31/bin/startup.sh tomcat


Does anyone have any experience with this issue?


Mike



---- mwpowell at adelphia.net wrote: 
> I can connect via the client, but tomcat still dies when it tries to connect. 
> 
> When I look at the user table in mysql, the user id that I am trying to use has the proper host, password and userid. Any ideas?
> 
> Mike
> 
> 
> ---- Joe Desbonnet <jdesbonnet at gmail.com> wrote: 
> > Remember to restart OpenCms. Also make sure your username  and host is
> > correct also.
> > 
> > One way to test the host/username/password combination is to try the
> > command line mysql client from the computer that runs OpenCms:
> > 
> > mysql --host=(myhost) --username=(myusername) --password=(mypassword) opencms
> > 
> > (substitute myhost, myusername and mypassword for appropriate values).
> > 
> > If that command fails then you need to re-configure your MySQL.
> > 
> > Joe.
> > 
> > 
> > On 4/11/06, mwpowell at adelphia.net <mwpowell at adelphia.net> wrote:
> > > Dmitry,
> > >
> > > Thank you for your prompt reply. However, I've changed the password in the opencms.properties file and I am still getting the same results.
> > >
> > > Are there any additional locations where the password needs to be changed?
> > >
> > >
> > > Mike
> > >
> > > ---- Dmitry Lihachev <lda at tusur.ru> wrote:
> > > > Hello. 11.04.2006 11:11 You wrote:
> > > > > All,
> > > > >
> > > > > After changing the root password to my mysql database, I can no longer connect
> > > > > to opencms. The logs show that the mysql connection is being denied by the mysql
> > > > > database when tomcat starts up, but I do not know where to change the password
> > > > > for the opencms connection. Essentially, tomcat is failing to startup because of
> > > > > the opencms database connection error.
> > > > >
> > > > > My setup uses a database connection for other tomcat applications which are
> > > > > specified in the server.xml and web.xml files for tomcat, but I don't know where
> > > > > the opencms specific configuration is located.
> > > > >
> > > > > Does anyone know the location of the database connection configuration for
> > > > > opencms? I'm using:
> > > > >
> > > > > Tomcat 4.1.31
> > > > > MySQL 4.1
> > > > > OpenCMS 6.0.2
> > > > >
> > > > > Mike
> > > > >
> > > > > _______________________________________________
> > > > > This mail is sent to you from the opencms-dev mailing list
> > > > > To change your list options, or to unsubscribe from the list, please visit
> > > > > http://lists.opencms.org/mailman/listinfo/opencms-dev
> > > > >
> > > > You can find database configuration properties in
> > > > ${OpenCmsRoot}/WEB-INF/conf/opencms.properties
> > > > properties are named like db.pool.default.*
> > > > --
> > > > WBR, Dmitry Lihachev
> > > > icq uin: 120606300
> > > > http://knigi.tomsk.ru
> > > >
> > > >
> > > > _______________________________________________
> > > > This mail is sent to you from the opencms-dev mailing list
> > > > To change your list options, or to unsubscribe from the list, please visit
> > > > http://lists.opencms.org/mailman/listinfo/opencms-dev
> > >
> > >
> > > _______________________________________________
> > > This mail is sent to you from the opencms-dev mailing list
> > > To change your list options, or to unsubscribe from the list, please visit
> > > http://lists.opencms.org/mailman/listinfo/opencms-dev
> > >
> > 
> > _______________________________________________
> > This mail is sent to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please visit
> > http://lists.opencms.org/mailman/listinfo/opencms-dev
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev