Forum Problems Installing LAMS: Re: Re: Re: jboss failing to connect to mysql

By: Matt Richardson

[ Reply | Forward ]

Hi Ernie,

Thanks for the quick response. MySQL is running and I can connect to it using the credentials in the mysql-ds.xml file with

mysql -u lams -p

and the database shows up when I do a 'show databases;'

MySQL was installed before LAMS and it is listening on localhost:3306. LAMS was running fine, apart from the no sysadmin login issue, before I did the password change in the table and restarted the service.

Posted by Matt Richardson

By: Ernie Ghiglione

[ Reply | Forward ]

So just to confirm, from the shell you are able to connect to the mysql lams database using the exact settings as you have in the mysql-ds.xml file?

And you haven't attempted a reinstall, correct?

Posted by Ernie Ghiglione

By: Matt Richardson

[ Reply | Forward ]

Correct. I can connect from the shell using the account and password specified in the mysql-ds.xml file. I have not attempted a reinstall.

Posted by Matt Richardson

By: Matt Richardson

[ Reply | Forward ]

Wow, I don't know how that worked, but it was my hosts.allow file. That server has been powered down and restarted without me having to change any settings in hosts.allow, but I just added ALL: localhost myserver.edu to the allow file and now LAMS starts up fine and my new sysadmin password works. Sorry for the waste of bandwidth. I really appreciate the help and the quick response. Gives me a good feeling about working with this community.

Posted by Matt Richardson

By: Ernie Ghiglione

[ Reply | Forward ]

Glad that you figured it out because I was running out of ideas!

Thanks

Ernie

Posted by Ernie Ghiglione