Forum Problems Installing LAMS: lams 2.2 can't start

By: Jun-Dir Liew

[ Reply | Forward ]

LAMS can't find your database called 'lams2' - can you check that you can login to MySQL with the username and password in your lams.properties, and that you can see the 'lams2' database?

Posted by Jun-Dir Liew

By: Nikos Dovros

[ Reply | Forward ]

Jun-Dir thank you for your reply.
Actually lams2 database has been created. As for the username and password I changed them to the root password but lams didn't start.
In server.log there is a line
"...
--- MBeans waiting for other MBeans ---
ObjectName: jboss.web.deployment:war=lams-admin.war,id=1845789335
State: FAILED
Reason: org.jboss.deployment.DeploymentException: URL file:/usr/local/jboss-4.0.2/server/default/tmp/deploy/tmp4767997518654417467lams-admin.war/ deployment failed

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.web.deployment:war=lams-admin.war,id=1845789335
State: FAILED
Reason: org.jboss.deployment.DeploymentException: URL file:/usr/local/jboss-4.0.2/server/default/tmp/deploy/tmp4767997518654417467lams-admin.war/ deployment failed
..."
I think that the problem is there, but I don't know how to overcome it.

Posted by Nikos Dovros

By: Jun-Dir Liew

[ Reply | Forward ]

That's the jboss deployer saying it couldn't deploy the lams webapps. It's only the tail end of a cascade of errors, because jboss can't find the data source that it's looking for. Do you have a mysql-ds.xml in /path/to/jboss/server/default/deploy/mysql-ds.xml? That's the file where you can check your database settings.

Here's the original error in server.log:

[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Unknown database 'lams2')

Posted by Jun-Dir Liew

By: Nikos Dovros

[ Reply | Forward ]

lams db has 202 tables and username, password accessible.
mysql-ds.xml exists in folder jboss-4.0.2/server.default/deploy
I have installed lampp server. Could this be a problem?
Yet, I have installed lams 2.2 in windows vista at my laptop and on centos 5.2 on a desktop, both on xampp and lampp server, respectively and they work fine.
I think I'm at a dead end!

Posted by Nikos Dovros

By: Nikos Dovros

[ Reply | Forward ]

I did a fresh installation and lams 2.2 started. I think the problem was on the privillages at mysql. I gave all privillages to lams db user. But now I have another problem.
web page doesn't display images and additional objects.
my website is http://elearning.agogiygeias.gr:8080/lams
Any suggestions why?

Posted by Nikos Dovros

By: Nikos Dovros

[ Reply | Forward ]

I managed to find the solution to the problem. In lams.properties at
SERVER_URL=http://localhost:8080/lams/ I entered
SERVER_URL=http://my-ip:8080/lams/
and objects display fine. Allas, problems seem to be endless.
When I enter to the author environment nothing is displayed.
at the status bar i can see "transfer data from my-ip..." but nothing happens!
Please help!!!

Posted by Nikos Dovros

By: Ernie Ghiglione

[ Reply | Forward ]

Nikos,

Login into LAMS as sysadmin, go to the sysadmin menu, then click on "Edit Configuration settings" and change the server URL to http://my-ip:8080/lams/

Click on Save, and that should fix it.

Thanks,

Ernie

Posted by Ernie Ghiglione

By: Nikos Dovros

[ Reply | Forward ]

Thank you Ernie, I have already fixed this problem. I changed lams.properties
I entered "SERVER_URL=http://elearning.agogiygeias.gr:8080/lams/" instead of my-ip.

Posted by Nikos Dovros