Forum Problems Installing LAMS: Moodle and LAMS on same machine - MySQL error - just need a pointer


 
You may request notification for Moodle and LAMS on same machine - MySQL error - just need a pointer.
Search: 

1: Moodle and LAMS on same machine - MySQL error - just need a pointer
12/10/07 11:44 AM
[ Reply | Forward ]
I'm not sure why this info is so hard to find. I've scoured the LAMS and Moodle sites respectively - including the forums - and followed the threads as much as I could. I installed Moodle 1.9 and then LAMS 2.0.3 on my Windows XP box just to do a demo test. I had Moodle working and happy, then installed LAMS. I logged into LAMS just fine and configured it, but when I went back to open Moodle, I get the following error Can't start server: Bind on TCP/IP port: No such file or directory 071210 12:29:05 [ERROR] Do you already have another mysqld server running on port: 3306 ? I found posts where others ran into the same problem - I'm guessing since LAMS and Moodle are using MySQL and I had to set a password for LAMS and not for the XAMP install package of Moodle, that broke Moodle. What I cannot seem to find for the life of me is the fix!? and, of course, I'm asking myself why this wasn't mentioned in the instructions for the LAMS/Moodle integration - it just says, "this example they are on the same server (my local PC) but that was only because it is easy for me to create a screenshot on my own PC." I would have LOVED a little link there to something that showed me how to set that up. ;-) If anyone has any advice, a link... anything, I'd be greatly appreciative. Thanks in advance.

Posted by Joy Green

2: Re: Moodle and LAMS on same machine - MySQL error - just need a pointer
In response to 1 12/10/07 07:12 PM
[ Reply | Forward ]
Joy,

I haven't got this documented on the LAMS wiki as I haven't encountered the problem before. I don't follow the Moodle forums closely so I hadn't picked up the problem being reported there.

I'm not quite sure what's happened here. Did you install another copy of MySQL when you installed LAMS? The LAMS installer doesn't actually install MySQL, it uses whatever version of MySQL you point it to.

When you installed LAMS it should have asked you for the root password for MySQL and a LAMS password. It then uses the root password that you supply to create a new user in MYSQL for LAMS and gives it the LAMS password and creates a new database for LAMS. So it shouldn't change any of your existing passwords or disrupted your Moodle database.

One catch with the installer is that the installer can't automatically find the MySQL directory in the XAMP installation. It relies on the MySQL setting in the registry to tell it where MySQL is. MySQL as installed by the MySQL installer sets the registry setting, but XAMP doesn't (or at least hasn't in the past). So you have to select the MySQL directory manually.

I have run the installer on a PC running an older version of Moodle and one of the XAMP flavours many times without this problem so I'm trying to work out what you and I have done differently!

Can I also check which pages on our wiki that you found. Did you find the Moodle page (http://wiki.lamsfoundation.org/display/lams/Moodle) and the Windows Installer page (http://wiki.lamsfoundation.org/display/lamsdocs/Windows+Installer+Help). Its not a criticism if you didn't - I just want to know so that if didn't find both, then I need to put in some extra links so that people can find both.

Fiona

Posted by Fiona Malikoff

3: Re: Moodle and LAMS on same machine - MySQL error - just need a pointer
In response to 1 08/10/08 02:46 AM
[ Reply | Forward ]
Hi,

I found this
http://www.fixya.com/support/t840251-mysql_error_messeage

It's quite useful for MySQL problems.

Check it out.

Posted by judE bini

Reply to first post on this page
Back to Problems Installing LAMS