Forum Problems Installing LAMS: HTTP Status 404 - /lams/


 
You may request notification for HTTP Status 404 - /lams/.
Search: 

1: HTTP Status 404 - /lams/
By: Yan Xu
 08/20/09 08:42 AM
[ Reply | Forward ]
Hello!
My problem as follows:
HTTP Status 404 - /lams/
type Status report

message /lams/

description The requested resource (/lams/) is not available.

Apache Tomcat/5.5.9


I can access the Jboss and this is import-db.log:

import-db:
[sql] Executing file: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\3\dump.sql
[sql] Executing file: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\3\lams\update_lams_configuration.sql
[sql] 1665 of 1665 SQL statements executed successfully
[sql] Executing file: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\3\removeConfigs.sql
[sql] Failed to execute: rename table lams_qtz_blob_triggers to lams_qtz_BLOB_TRIGGERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_blob_triggers' already exists
[sql] Failed to execute: rename table lams_qtz_calendars to lams_qtz_CALENDARS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_calendars' already exists
[sql] Failed to execute: rename table lams_qtz_cron_triggers to lams_qtz_CRON_TRIGGERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_cron_triggers' already exists
[sql] Failed to execute: rename table lams_qtz_fired_triggers to lams_qtz_FIRED_TRIGGERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_fired_triggers' already exists
[sql] Failed to execute: rename table lams_qtz_job_details to lams_qtz_JOB_DETAILS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_job_details' already exists
[sql] Failed to execute: rename table lams_qtz_job_listeners to lams_qtz_JOB_LISTENERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_job_listeners' already exists
[sql] Failed to execute: rename table lams_qtz_locks to lams_qtz_LOCKS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_locks' already exists
[sql] Failed to execute: rename table lams_qtz_paused_trigger_grps to lams_qtz_PAUSED_TRIGGER_GRPS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_paused_trigger_grps' already exists
[sql] Failed to execute: rename table lams_qtz_scheduler_state to lams_qtz_SCHEDULER_STATE
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_scheduler_state' already exists
[sql] Failed to execute: rename table lams_qtz_simple_triggers to lams_qtz_SIMPLE_TRIGGERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_simple_triggers' already exists
[sql] Failed to execute: rename table lams_qtz_triggers to lams_qtz_TRIGGERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_triggers' already exists
[sql] Failed to execute: rename table lams_qtz_trigger_listeners to lams_qtz_TRIGGER_LISTENERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_trigger_listeners' already exists
[sql] 11 of 23 SQL statements executed successfully

BUILD SUCCESSFUL
Total time: 16 seconds


Help me ,please! Thank you very much!

Posted by Yan Xu

2: Re: HTTP Status 404 - /lams/
In response to 1 08/20/09 04:48 PM
[ Reply | Forward ]
Hi Yan,

Did you install using the windows or the unix installer.

Also, could you please attach the entire server.log which is located in /path/to/jboss-4.0.2/server/default/log

Thanks,

Luke

Posted by Luke Foxton

3: Re: Re: HTTP Status 404 - /lams/
By: Yan Xu
 In response to 2 08/20/09 06:32 PM
[ Reply | Forward ]
Hi,Luke!Thanks for your reply! I installed it using the windows sever 2003.

Posted by Yan Xu

4: Re: Re: Re: HTTP Status 404 - /lams/
In response to 3 08/20/09 06:34 PM
[ Reply | Forward ]
Yan,

Can you attach your server.log please.

It should be located in C:\lams\jboss-4.0.2\server\default\log

Luke

Posted by Luke Foxton

5: Re: Re: Re: Re: HTTP Status 404 - /lams/
By: Yan Xu
 In response to 4 08/20/09 06:49 PM
[ Reply | Forward ]
Oh,of course! Thank you!

Posted by Yan Xu

Attachments:
6: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
In response to 5 08/20/09 07:05 PM
[ Reply | Forward ]
Yan,

In the logs it is saying that something is already using port 4444. Do you already have something else running on the windows server that might be using this port?

Luke

Posted by Luke Foxton

7: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
By: Yan Xu
 In response to 6 08/20/09 07:12 PM
[ Reply | Forward ]
Hi,I used netstat -ano to detect the port,4444 isn't used!

Posted by Yan Xu

8: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
In response to 7 08/20/09 07:30 PM
[ Reply | Forward ]
Yan,

Do you have any other server technologies running like tomcat?

What other services is the server running?

Luke

Posted by Luke Foxton

9: Re: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
By: Yan Xu
 In response to 8 08/20/09 07:43 PM
[ Reply | Forward ]
Luke，
There are IIS and Apache .

Posted by Yan Xu

10: Re: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
By: Yan Xu
 In response to 8 08/20/09 08:06 PM
[ Reply | Forward ]
Luke,

Look back to the first http status 404, the problem is pointed out by Apache tomcat!
So ,there is tomcat on my sever!

Posted by Yan Xu

11: Re: Re: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
In response to 10 08/20/09 08:29 PM
[ Reply | Forward ]
Yan this could be caused by lams attmpting to start twice, a possible solution would be to restart the server and try starting lams again

Posted by Luke Foxton

12: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
By: Yan Xu
 In response to 11 08/20/09 08:31 PM
[ Reply | Forward ]
OK, I'll have a try! Thank you very much!

Posted by Yan Xu

13: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
By: Yan Xu
 In response to 11 08/20/09 08:33 PM
[ Reply | Forward ]
Sorry , Which do you mean :restart the lams sever or the windows sever?

Posted by Yan Xu

14: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
By: Yan Xu
 In response to 11 08/20/09 08:42 PM
[ Reply | Forward ]
I have restarted the lams sever for many times,but the problem is still exist!

Posted by Yan Xu

15: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
In response to 14 08/20/09 08:57 PM
[ Reply | Forward ]
Try reastartding windows

Posted by Luke Foxton

16: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
By: Yan Xu
 In response to 15 08/20/09 09:09 PM
[ Reply | Forward ]
I am so happy, we are successful!Thank you very much!Luke.
Could I consult you if I have another problem?
Best wishes! You are pretty!

Posted by Yan Xu

17: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
By: Yan Xu
 In response to 15 08/20/09 09:14 PM
[ Reply | Forward ]
But the user can not access through http://61.142.248.19:8180/lams/
Is it possibly caused by the Mysql setd as localhost not 61.142.248.19 while installing the lams?

Posted by Yan Xu

18: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: HTTP Status 404 - /lams/
In response to 17 08/20/09 10:56 PM
[ Reply | Forward ]
Hi Yan,

Is the lams serverURL in the configuration page set to
http://61.142.248.19:8180/lams/

You can set this by logging in as sysadmin, then go to sysadmin->Edit Configuration Settings. You will find an entry for "Server URL" make sure this is pointing to the right location.

As long as the mysql server is installed on the same server as lams, you can use localhost.

Luke

Posted by Luke Foxton

19: Re: HTTP Status 404 - /lams/
In response to 1 01/03/12 02:19 AM
[ Reply | Forward ]
hi all,
i'm new in LAMS and i got same message like Yan Xu.
i already try your solution but i still got the message.
this is my server.log file. First time i hope when i restart my machine i will get the same solution but i still get the message.
Hope somebody can help me please.

Posted by Eka Mustika Sari

Attachments:
20: Re: Re: HTTP Status 404 - /lams/
In response to 19 01/03/12 07:36 AM
[ Reply | Forward ]
HI Eka,

As per your log, your problem is that LAMS cannot connect to your Xampp MySQL. See:

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Access denied for user 'lams2'@'localhost' to database 'lams2')

As I mentioned early, try to uninstall LAMS first, do the changes require to get Xampp MySQL to work with LAMS installer and try to install it again.

I think that should work. Let us know otherwise.

Thanks,

Ernie

Posted by Ernie Ghiglione

21: Re: Re: Re: HTTP Status 404 - /lams/
In response to 20 01/04/12 01:07 AM
[ Reply | Forward ]
ya ernie..my problem is LAMS cannot connect to Xampp MySQL. and i already fix that. i choose wrong folder for mysql.

first time i use C:\xampp\mysql\bin and after that i change to C:\xampp\mysql\data

i try to figure out and last time i try to use C:\xampp\mysql\ and it works. the answer for all my issues is choose the right MYSQL folder.

thanks,

Eka

Posted by Eka Mustika Sari

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