Forum LAMS for Tech-Heads - General Forum: LAMS 2.0.2 is out!

By: Anders Berggren

[ Reply | Forward ]

Yiiphee! Up and running LAMS itself again.

Problems with Moodle Integration though

Trying to create a LAMS v2 activity I get this:

soapenv:Server.userException: java.rmi.RemoteException: Fail to fetch user data from external server:moodle - Unexpected return HTTP Status:404; nested exception is: org.lamsfoundation.lams.integration.UserInfoFetchException: Fail to fetch user data from external server:moodle - Unexpected return HTTP Status:404

Posted by Anders Berggren

By: Anders Berggren

[ Reply | Forward ]

Popup page message when trying to create
a LAMS v2 activity:

"HTTP Status 502 - Login Failed - failed to fetch user info from the third party server

type Status report

message Login Failed - failed to fetch user info from the third party server

description This server received an invalid response from a server it consulted when acting as a proxy or gateway (Login Failed - failed to fetch user info from the third party server).
Apache Tomcat/5.5.9"

Address found in lams.log and tested:
http://localhost/mod/lamstwo/userinfo.php?un=iktpeda&ts=1174665656984&hs=764ab0ac000ad9e8b6e6dddbaa11bd7a8dacb865

Result (Sorry about the Swedish ):
"Objektet hittas ej! (not found)
Den efterfrågade adressen hittades inte på denna server. Om du skrev in adressen manuellt så kontrollera din stavning och försök igen.

Om du tror att detta beror på ett serverfel, vänligen kontakta webbansvarig.

Error 404
localhost
03/23/07 17:09:28
Apache/2.2.2 (Win32) DAV/2 mod_ssl/2.2.2 OpenSSL/0.9.8b mod_autoindex_color PHP/5.1.4"

Zipped log-files attached.

Cheers, Anders

Posted by Anders Berggren

By: Anders Berggren

[ Reply | Forward ]

I changed the URL to info on users to:
http://localhost/moodle/mod/lamstwo/userinfo.php?un=%username%&ts=%timestamp%&hs=%hash%

by adding 'moodle'.

Some mysterious stuff occurred
but finally I got the LAMS/Moodle
to function, so far so good. I haven't
tried everything yet.

Bowing, enjoying
Anders

Posted by Anders Berggren

By: Anders Berggren

[ Reply | Forward ]

Back on square one.
Unable to reach the login page.
This happened without me changing
anything. Uninstalling and re-
installing won't help.

Posted by Anders Berggren

By: Fiona Malikoff

[ Reply | Forward ]

Anders,

I assume that you mean you can't log into LAMS directly?

Back to square one with the questions then:

* If you look in the lams2 database, are you back to only 7 tables?

* If you http://<servername>:8080/ do you get the JBoss screen?

* Can you access LAMS from Moodle?

* Could you post the LAMS logs? Send me the same two you attached to your earlier post plus the system.log from the same directory.

Fiona

Posted by Fiona Malikoff

By: Anders Berggren

[ Reply | Forward ]

Hi,

Didn't mean to ruin your weekend...

I am experimenting with the path to
mysql with or without trailing '\'

A. answers relating to alternative with '\':

* 7 tables in lams2, yes.
On the second install I only got 5 tables...
* Yes, I do get the JBoss screen with http://localhost:8080/
* No, I can't access LAMS from Moodle

The log files relating to this alternative are marked with an 'A'.

B. answers relating to alternative without '\':
* 3 tables in lams2
* No, I don't get the JBoss screen http://localhost:8080/
* No, The first time I can't access the server on
address http://localhost:8080/ from Moodle

The second time I got this:

" HTTP Status 404 - /lams/LoginRequest
type Status report
message /lams/LoginRequest
description The requested resource (/lams/LoginRequest) is
not available.
Apache Tomcat/5.5.9"

The log files relating to this alternative are marked with a 'B'.

Cheers, Anders

Posted by Anders Berggren

By: Fiona Malikoff

[ Reply | Forward ]

Anders,

The problem is definitely the database. Looking at the logs, LAMS won't start up as there are tables missing.  There should be 139 tables!

I'm running XAMPP on my PC and so I have to select the mysql directory manually too. I just select the directory - I don't add the trailing '\' anymore as Luke has changed the code so that it is added automatically.

I think you need to uninstall LAMS, make sure the lams2 database is deleted and then re-install. Send me the log from the install (ie copy the text from the window you get when you click the Show Details button).

Something very weird is going on with the database and it sounds like every time you do an install, the problem is getting worse - so make sure the lams2 database is deleted before you run the installer.

Fiona

Posted by Fiona Malikoff

By: Fiona Malikoff

[ Reply | Forward ]

One more thing - as soon as the install is complete, can you look at the database and check the number of tables straight away.

Just in case it is something that happens AFTER the installation that is wrecking the database - given that you did get it working briefly for a while, there may be a database problem while LAMS is running.

So if you install and you get the right number of tables then can you set it up to work with Moodle, but check back to the database every so often. Then if it suddenly drops back to 7 tables, can you try to work out what you might have been doing when it went wrong?

I'm just trying to work out what is happening when the database goes wrong. That might tell us which bit of the system has the problem.

I will talk to the team about what you could look for in the MySQL logs.

Fiona

Hint: If you do "show tables" on the lams2 database it should give you the list of all the tables and the count of the tables. That saves you trying to count.

Something like this:

fiona-malikoffs-computer:~ fiona$ mysql -u lamss -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use lams;
Database changed
mysql> show tables;
+--------------------------------+
| Tables_in_lams                |
+--------------------------------+
| lams_activity_category        |
| lams_activity_learners        |
| lams_auth_method_type          |
| lams_authentication_method    |
| lams_configuration            |
| lams_copy_type                |
| lams_cr_credential            |
| lams_cr_node                  |
.....
| tl_lavote11_content            |
| tl_lavote11_nomination_content |
| tl_lavote11_session            |
| tl_lavote11_uploadedfile      |
| tl_lavote11_usr                |
| tl_lavote11_usr_attempt        |
+--------------------------------+
139 rows in set (0.00 sec)

Posted by Fiona Malikoff

By: Anders Berggren

[ Reply | Forward ]

Hi Fiona,
For a while I could set lams2(139)
but then I had to take measures against
other sources of instability on this
testing computer. And now that this is
fixed I am back with 3,5 or seven tables
when the install is finished.

Cheers, Anders

Posted by Anders Berggren

By: Fiona Malikoff

[ Reply | Forward ]

Anders,

If I understand you correctly, you installed LAMS2 and there were 139 tables. Then you did some other work on the PC and then there were only a few tables in the lams2 database. Is that correct?

What is the other instability on the computer? Is it database related at all?

Could you have a look in your mysql directory and see if you can find the .err file for your computer and post it here? It will be called something like <xampp>\mysql\data\<computername>.err.

Finally, could also attach your c:\windows\my.ini file, if one exists.

Fiona

Posted by Fiona Malikoff

By: Anders Berggren

[ Reply | Forward ]

The name of the culprit is http://www.copernic.com/
DesktopSearch. All kinds of problems appeared, if
any of those were database related, I really don't
know. I downloaded an update and then all the
instability vanished and I was back with my
general LAMS problems.

Posted by Anders Berggren

By: Fiona Malikoff

[ Reply | Forward ]

Anders,

Hmm, I wouldn't have thought that copernic would have done any damage, but I can rule it out.

I am baffled. I've looked at the log and while there are a couple of thread errors, there is nothing obvious.

At this point, I don't have a clue what is getting rid of the tables in the database.

Fiona

Posted by Fiona Malikoff

By: Anders Berggren

[ Reply | Forward ]

Now you'll be even more baffled.
Don't ask me what I did or what
happened, the important thing is
that now (for the moment?) everything
seems to work as it should. Computers...

Posted by Anders Berggren

By: Fiona Malikoff

[ Reply | Forward ]

So we now have a self-healing computer. Well and truly in the twilight zone! <grin>

Fiona

Posted by Fiona Malikoff