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


 
Search: 

2: Re: jboss failing to connect to mysql
In response to 1 03/03/11 05:19 PM
[ Reply | Forward ]
Hi Matt,

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

Thanks,

Ernie

Posted by Ernie Ghiglione

3: Re: Re: jboss failing to connect to mysql
In response to 2 03/04/11 10:29 AM
[ 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

4: Re: Re: Re: jboss failing to connect to mysql
In response to 3 03/04/11 10:55 AM
[ 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

5: Re: Re: Re: Re: jboss failing to connect to mysql
In response to 4 03/04/11 11:05 AM
[ 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

6: Re: Re: Re: Re: Re: jboss failing to connect to mysql
In response to 5 03/04/11 11:22 AM
[ 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

7: Re: Re: Re: Re: Re: Re: jboss failing to connect to mysql
In response to 6 03/04/11 11:41 AM
[ 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

8: Re: Re: Re: Re: Re: Re: Re: jboss failing to connect to mysql
In response to 7 03/04/11 11:48 AM
[ 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

9: Re: Re: Re: Re: Re: Re: Re: Re: jboss failing to connect to mysql
In response to 8 03/04/11 12:47 PM
[ Reply | Forward ]
:-)

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

Thanks

Ernie

Posted by Ernie Ghiglione

Reply to first post on this page
Back to Problems Installing LAMS