Forum Problems Installing LAMS: CentOS Server SQL Exception


 
You may request notification for CentOS Server SQL Exception.
Search: 

1: CentOS Server SQL Exception
01/17/12 10:35 AM
[ Reply | Forward ]
Hello,

I am trying to install LAMS 2.3.5 in a CentOS Server.
Java and Jboss are correctly installed but I get an SQL Exception when I try to execute "lams2 start".

I am using a database from an old server, which was also with 2.3.5, but it was running Ubuntu.

I can acces to "mysql" with the user and password of the database that is configured to work with lams. I've checked that lams.properties and mysql-ds.xml are correct. show databases shows the correct database.

I attach the server.log

Thanks for your help

Posted by Jose C. Andreu

Attachments:
2: Re: CentOS Server SQL Exception
In response to 1 01/17/12 12:42 PM
[ Reply | Forward ]
Hi Jose,

This is your problem (from the logs):

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access denied for user 'user_lams'@'localhost' (using password: YES))

Have you created the user user_lams on MySQL?

Can you try to see if this works from the command link:

$ mysql -u user_lams -p -h localhost

Thanks

Ernie

Posted by Ernie Ghiglione

3: Re: Re: CentOS Server SQL Exception
In response to 2 01/23/12 01:57 AM
[ Reply | Forward ]
Thanks for your fast response.

I restarted the server and I saw it was an issue with mysqld service. Previously I had to reset the root password and it seems that it blocked the network remote access.

Thanks again.

Cheers,
Jose

Posted by Jose C. Andreu

Reply to first post on this page
Back to Problems Installing LAMS
.LRN Home