Forum LAMS for Tech-Heads - General Forum: Re: Re: Re: Re: Re: Re: Re: Re: Requested resource not available

By: Anders Berggren

[ Reply | Forward ]

Hi Fiona,
I don't know if there should be
a slash after the path to 'mysql'
or not. We added that when installing
2.0.

I've attached the installation log.
Seems OK to me.

Anders

Posted by Anders Berggren

By: Fiona Malikoff

[ Reply | Forward ]

Anders,

The error is this bit:

import-db:
      [sql] Executing file: C:\DOCUME~1\ANDERS~1\LOKALA~1\Temp\dump.sql
      [sql] Failed to execute:    /*!40000 ALTER TABLE `lams_auth_method_type` DISABLE KEYS */

BUILD FAILED
C:\DOCUME~1\ANDERS~1\LOKALA~1\Temp\build.xml:95: java.sql.SQLException: Table 'lams_auth_method_type' is read only

But why mysql thinks this table is read only I have no idea.

I assume you are trying to do a fresh install - not upgrade from a previous version. If you are trying to do a fresh install, can you MySQL client and delete the lams2 database manually before running the install.

We are still finalising the 2.0.2 installer so wait till that one is ready (real soon now!)

I'm not sure how you can drop a database in WinMySQLadmin - I've never managed to get it working properly since I reinstalled XAMPP on my PC.

To do it via the command line version you should be able to go to the command line and do the following, replacing "c:\Program Files\xampp\mysql" with your path to mysql:

C:\Documents and Settings\Administrator>"c:\Program Files\xampp\mysql\bin\mysql" -ulams2 -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 234
Server version: 5.0.33 Source distribution

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

mysql> drop database lams2;
Query OK, 139 rows affected (5.00 sec)

mysql> exit
Bye



The number of rows bit will be different if you have only 7 tables!

Fiona

Posted by Fiona Malikoff

By: Anders Berggren

[ Reply | Forward ]

Hi Fiona,
I upgraded to both JDK 1.6.0 and LAMS 2.0.2.
Then I finally got the URL to user info right
in 'Maintain integrated servers' after changing it to:

"http://localhost/moodle/mod/lamstwo/userinfo.php?un=%username%&ts=%timestamp%&hs=%hash%"

by adding 'moodle' according to instructions you had
given to another user in another discussion.

For the moment everything that I have done
seems to function even if some mysterious
stuff interferes temporarily.

Anders

Posted by Anders Berggren