Forum Problems Installing LAMS: jboss failing to connect to mysql

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Matt,

Where did you change the password? Did you modify the mysql-ds.xml file?

Thanks,

Ernie

Posted by Ernie Ghiglione

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

By: Eka Mustika Sari

[ Reply | Forward ]

hi all, i had the same problem and until now i can not figure it out. and i searched the forums for others with the same issue. I don't know when must i put my question, i hope this is the right forum.

Here's the environment: LAMS 2.3.5 from window i use xampp for windows version 1.7.3

here my attachment server.log

Posted by Eka Mustika Sari

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Eka,

Please refrain from posting several times, as it creates more confusion. See my replies to your messages:

http://lamscommunity.org/dotlrn/clubs/educationalcommunity/gettingstarted/forums//message-view?message_id=1360970
http://lamscommunity.org/dotlrn/clubs/technicalcommunity/forums//message-view?message_id=1360984

Thanks,

ernie

Posted by Ernie Ghiglione