Forum Problems Installing LAMS: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: NOTICEBOARD

By: Fiona Malikoff

[ Reply | Forward ]

Odd.

I hope its not a xampp thing.

Can you try going to a command line (ie do Run, cmd) and
enter the command:

C:\xampp\xampp\mysqlbin\mysql.exe -ulams2 -p

It should then prompt you for the password. Enter the password,  and press return. It should then give you a prompt like

mysql>

Does this work?

Fiona

Posted by Fiona Malikoff

By: Anders Berggren

[ Reply | Forward ]

Yes.
Here's what I get:

"Welcome to the MySQL monitor.
Commands end with ; or \g.

Your MySQL connection ID is 150 to server version: 5.0.21-community-nt
Type 'help;' or 'h' for help. Type '\c' to clear the buffer.

mysql>"

Anders

Posted by Anders Berggren

By: Jun-Dir Liew

[ Reply | Forward ]

> Can't read from C:\xampp\xampp\mysql\lams2 database

It doesn't say anything is wrong with the mysql authentication, it just can't read the database. Does the directory C:\xampp\xampp\mysql\lams2 exist? Do you have any other instances of MySQL installed?

We could go back and forth trying different things to find out what the problem is, so I think the easiest thing to do at this point would be to uninstall and reinstall LAMS, then install the language pack. We'll try to test more with packages like xampp for the next language pack, as they seem quite popular...

Posted by Jun-Dir Liew

By: Anders Berggren

[ Reply | Forward ]

1. The correct search path is actually:
C:\xampp\xampp\mysql\data\lams2

2. Yes, there seems to be another MySQL instance
bundled with an application not related to XAMPP.
I can't see any LAMS2 files there.

I'll try a re-install of LAMS like you say.
Thanks

Posted by Anders Berggren

By: Fiona Malikoff

[ Reply | Forward ]

Anders,

I've finally found out what is stopping the language pack running.

When you installed LAMS, did it come up with a message that it couldn't find MySQL? If so, you would have been asked to find the directory that contains MYSQL. I suspect that when the directory was selected, it appeared as "C:\xampp\xampp\mysql".

Now, when the language pack runs, it tries to call the mysql program by taking that string and appending "bin\mysql.exe". BUT then the path comes out as "C:\xampp\xampp\mysqlbin\mysql.exe" and it should be "C:\xampp\xampp\mysql\bin\mysql.exe". Note the \ between mysql and bin!

I've raised a problem report about this, and it will be fixed in the next language pack, which will be released on February 9th. So you have four choices:

(1) Wait till February 9th and the noticeboard problem requiring the language pack fix will be fixed.

(2) Download the manual language pack and install it manually (which requires copying files and running a sql script). The manual pack is available from http://wiki.lamsfoundation.org/display/lams/Downloads

(3) Uninstall LAMS and reinstall it, but when it asks for the MySQL directory, make sure the directory path is "C:\xampp\xampp\mysql\" ie it has the trailing "\".

(4) Edit an entry in your Windows registry. If you know how to make a change in your Windows registry, then you need to find the LAMSv2 entry for "dir_mysql" and change "C:\xampp\xampp\mysql" to "C:\xampp\xampp\mysql\".

I'm not going to tell you how to change the registry - if you don't know how to modify the registry then I would suggest doing (1), (2) or (3).

I've also found where xampp puts the my.ini file. In my installation, it created it in c:\windows. However it wasn't created automatically, I had to go into the XAMPP control panel and then click the "Admin" button next to MySql. This runs WinMySQLadmin, which appears as a traffic light in the icon bar on the bottom of the screen (near the clock). I went into the my.ini take and created it that way. Then you can make the changes given on:

http://wiki.lamsfoundation.org/display/lamsdocs/Installing+MySQL+on+Windows+for+LAMS

Now to see if I can reproduce your problem starting lessons!

Fiona

Posted by Fiona Malikoff

By: Anders Berggren

[ Reply | Forward ]

Hi Fiona,

Thanks a million for your continued
attention to this and for explaining
it very thoroughly. Following alternative 3
I later managed to install the lang
pack with a smile. I also changed the
my.ini-file the way that you suggested.
There were a number of radiobuttons which
I assumed referred to various sections
in the mysqld file?

Cheers, Anders

Posted by Anders Berggren

By: Fiona Malikoff

[ Reply | Forward ]

Anders,

How is your installation going? Is noticeboard working?

As for the radiobuttons - I think they refer to different versions of mysql but I can't work it out, so I just leave the radio buttons set to whatever it defaulted to.

Has the reinstall fixed the problems with starting a lesson?

Regards,

Fiona

Posted by Fiona Malikoff

By: Anders Berggren

[ Reply | Forward ]

Hi,
Sigh... Running only LAMS v2 I can create
a sequence and save it.

After that I can preview it. But - when
returning to the "Welcome"-page there is
no "Add lesson"-link... My guess is that the
lams2 database is still playing hide and seek
in XAMPP. The actual path to it is:
xampp/mysql/data/lams2

The problem in the LAMS/Moodle integration remains.

Cheers, Anders

Posted by Anders Berggren

By: Fiona Malikoff

[ Reply | Forward ]

Anders,

I'm starting to think that it isn't the location of the database. I have a Moodle/LAMS integration working using XAMPP on a PC, and I'm pretty sure its data files are in the same place.

You will get the "Add lesson" on the main page if you have the Monitor role for the group. You need the Author role to create a sequence and run preview but the Monitor role to run a lesson.

Can you log into LAMS as sysadmin, and then select the"Group Mgt" link. This should bring up the "Manage Groups" page. Click on your group name and then the "Manage Users" screen. This should list all the users in this group and their roles. I've attached a sample screen dump.

Could you tell me which roles your user has?

Fiona

Posted by Fiona Malikoff

By: Fiona Malikoff

[ Reply | Forward ]

Might help if I remember to attach the screenshot!

Posted by Fiona Malikoff

By: Anders Berggren

[ Reply | Forward ]

The problem is I have
a foot in my mouth :-I.
I thought I could do
anything as a 'sysadmin'
but I had to assign new roles first.
Then most of the doors opened

I had one problem opening Notebook
as a Learner. See attached error report.

In Moodle the problem of starting
a lesson remains. Nor can I set
a starting date.
Cheers, Anders

Posted by Anders Berggren

By: Anders Berggren

[ Reply | Forward ]

I discovered that my mdl_user
had a limited role. I saw this
when logging in to LAMS v2
separately. I assigned all
possible roles to this user
but still nothing happens...

Posted by Anders Berggren

By: Fiona Malikoff

[ Reply | Forward ]

Anders,

The roles that the user gets in LAMS is indirectly based on what privileges the user has in Moodle.

By assigning all possible roles to the user in LAMS you have made sure that the problem with creating a lesson isn't a LAMS security problem and that was a very good thing to try.

I'm trying to work out what to ask you to do next.

What roles/privileges does your user have in Moodle?

My test user in Moodle has Adminstrator, Course Creator, Teacher and Student. But I think you only need Teacher and Student - I'm pretty sure I don't have Administrator rights on the http://moodle.lamscommunity.org/ website.

I do very little with Moodle, so please forgive me if I get the wrong names for things in Moodle.

Fiona

Posted by Fiona Malikoff

By: Anders Berggren

[ Reply | Forward ]

I am admin in my Moodle instance.
Admin has all the rights in all
the other roles and more. Your
Moodle names are correct. Teachers
can have editing rights or not though.
It's also so that on course level e.g.
as an editing teacher you can rename
teacher/student to whatever you prefer.
With the new (1.7) expanded roles system
you can construct the roles you need
from top level to the minutest detail
on the bottom level in a very flexible
XML-tree manner.

Posted by Anders Berggren