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


 
Search: 

7: Re: Re: Re: LAMS 2.0.2 is out!
In response to 6 03/25/07 04:06 AM
[ 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

Attachments:
8: Re: Re: Re: Re: LAMS 2.0.2 is out!
In response to 7 03/25/07 04:26 PM
[ 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

9: Re: Re: Re: Re: Re: LAMS 2.0.2 is out!
In response to 8 03/25/07 04:35 PM
[ 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

10: Re: Re: Re: Re: Re: Re: LAMS 2.0.2 is out!
In response to 9 03/26/07 12:35 PM
[ 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

11: Re: Re: Re: Re: Re: Re: Re: LAMS 2.0.2 is out!
In response to 10 03/26/07 06:30 PM
[ 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

12: Re: Re: Re: Re: Re: Re: Re: Re: LAMS 2.0.2 is out!
In response to 11 03/26/07 11:54 PM
[ 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

Attachments:
13: Re: Re: Re: Re: Re: Re: Re: Re: Re: LAMS 2.0.2 is out!
In response to 12 03/27/07 04:36 AM
[ 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

14: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: LAMS 2.0.2 is out!
In response to 13 03/29/07 07:34 AM
[ 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

15: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: LAMS 2.0.2 is out!
In response to 14 03/29/07 05:07 PM
[ Reply | Forward ]
So we now have a self-healing computer. Well and truly in the twilight zone! <grin>

Fiona

Posted by Fiona Malikoff

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum