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

Back to Problems Installing LAMS
	Search:

	5: Re: Re: Re: Re: jboss failing to connect to mysql By: Matt Richardson	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 By: Ernie Ghiglione	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 By: Matt Richardson	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 By: Matt Richardson	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 By: Ernie Ghiglione	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