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

By: Matt Richardson

[ Reply | Forward ]

In the lams_user table.

update lams_user set password="" where login="sysadmin";

Which was dumb, I should have checked the forum first to see that it should have been 'password=sha1('password')'. I did copy the hash before making the update statement, then when I ran into the first 404 I ran the update statement again to reinsert the hashed password. Restarting LAMS still gave the 404 and the error that was in the attached log, so then I finally got half a brain and searched the forums to find the correct way to reset the sysadmin password in the table. No joy, still a 404/service not available and the error repeated in server.log.

Posted by Matt Richardson

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Matt,

LAMS can't seem to get a connection to MySQL. I would assume that MySQL is running, isn't it? Also, did you have MySQL installed before you installed LAMS?

Could it be that MySQL is running on a different port?

Thanks,

Ernie

Posted by Ernie Ghiglione

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