Forum LAMS Lounge Forum: Re: Re: sysadmin login problem

By: Jun-Dir Liew

[ Reply | Forward ]

Hi,

You can try setting the password for sysadmin in the database:

At the command line, bring up your mysql client
shell> mysql lams2 -u lamsuser -plamsdemo

Then at the mysql prompt, execute this line of SQL:
mysql> update lams_user set password=sha1('newpassword') where login='sysadmin';

Then try to login using the login 'sysadmin' and your new password.

If that doesn't work, probably something else is wrong - would be helpful to look at the log files under /path/to/jboss-4.0.2/server/default/log/.

Thanks,

Posted by Jun-Dir Liew

By: sener eski

[ Reply | Forward ]

I tried to update the password as you said. But it was impossible. So I'm sending the log file content.

This is my log file :

Can we find the error from the codes here.

Thanks in advance.


path/to/jboss-4.0.2/server/default/log/localhost_access_log.2008-03-26.log

XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams//www/news.html HTTP/1.1" 200 1817
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams/ HTTP/1.1" 200 6721
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams/css/defaultHTML.css HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams/includes/javascript/flash_detect.js HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams/includes/javascript/browser_detect.js HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams/includes/javascript/sha1.js HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams/images/css/diagonal_bg.gif HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams/images/css/top_bg.jpg HTTP/1.1" 304 -
XXX.XXX.XXX.XXX- - [26/Mar/2008:16:36:38 +0200] "GET /lams/images/css/body_bg.jpg HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams/images/css/lams_login_bar.jpg HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams/images/css/btn_off.gif HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams/images/css/footer_bg.jpg HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:38 +0200] "GET /lams//images/css/lams_login.gif HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:50 +0200] "GET /lams/images/css/btn_over.gif HTTP/1.1" 304 -
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:50 +0200] "GET /lams//www/news.html HTTP/1.1" 200 1817
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:50 +0200] "POST /lams/j_security_check HTTP/1.1" 200 6846
XXX.XXX.XXX.XXX - - [26/Mar/2008:16:36:50 +0200] "GET /lams/images/css/warning.gif HTTP/1.1" 304 -

Posted by sener eski

By: Jun-Dir Liew

[ Reply | Forward ]

This file doesn't say much other than that the login didn't work. If there's a problem, the lams.log and server.log files may have more information. They're in the same directory.

What was the problem with updating the password? If the problem is that the password was changed and you've forgotten it, you'll need to reset it, unless you have another user with the sysadmin role.

Posted by Jun-Dir Liew

By: sener eski

[ Reply | Forward ]

username and password is true. no problem.
phpmyadmin : lams2 database, lams_user table first record is:
1 sysadmin a159b7ae81ba3552af61e9731b20870515944538 The System Administrator NULL........




my log files:

http://www.lamscommunity.org/dotlrn/file-storage/view/dotlrn_fs_577748_root_folder/logs.txt

problem is different.!!!

Posted by sener eski

By: Fiona Malikoff

[ Reply | Forward ]

Could you please get the lams.log and server.log and zip them up and then attach them? That is, the full logs not just the part with the error.

The error in your logs.txt is being generated by the JBoss software, rather than LAMS itself, so I am hoping that something else further up in the logs will tell us what is configured wrong.

Fiona

Posted by Fiona Malikoff

By: sener eski

[ Reply | Forward ]

hi,

my log files :

http://www.lamscommunity.org/dotlrn/file-storage/view/dotlrn_fs_577748_root_folder/logs.zip

Thanks,

Posted by sener eski

By: Fiona Malikoff

[ Reply | Forward ]

Thanks for the logs - I still can't work out what has gone wrong.

Could you try zipping up ALL the log files in <jboss>/server/default/log and send them to us? What I really need is the messages from when the server starts up, and they must be in an older log file.

Fiona

Posted by Fiona Malikoff