Hello,
I am planning to install Moodle on this platform:
Windows 2003 Server - latest service pack
IIS 6
PHP 5
What I need to know is can I use SQLserver as the database or must I use MySQL? If I must use MySQL does anyone know if the two database programs can coexist?
Any help will be appreciated. Thanks. Bill
Hello Howard,
I use Moodle on a LAN as part of my training delivery. It is very popular with all my trainees, and I am now trying to convince my employers to allow me to run it from our server, so that course material is available to people when they have left the training centre.
Server administrators are very reluctant to install mysql because they say it may mess up their existing sql server. I have to make a case for putting up mysql.
Do they use different port numbers by default?
Can you offer any advice that would strengthen my hand as I make a case for mysql and Moodle? (they are using webct at the moment).
Matt,
There really isn't much to say... MySQL and Ms SQL will definitely co-exist on the same server. They use different TCP/IP ports (IIRC - Microsoft runs on 1443 and MySQL on 3306 by default). The fact that they are both databases is a red herring, they are just server applications and your system will already run multiple servers side-by-side quite happily.
Putting my subversive hat on, sometimes it's just easier to run your own machine. Hardware is cheap these days. Is your own Linux box under a desk somewhere a possibility? That's how we started way back when nobody was interested.
Otherwise I don't think I can add much more to what has already been said. There is a lot of supporting information in the docs Wiki. Have a look at...
The bottom line fore me though is that our staff and students love using it. It has been hassle free and easy. Q. "can we do X?", A. "yes you can!".
Hello Howard,
Thanks for getting back to me. I have set up a Moodle course in the training centre, but for the moment it is only available from my own windows machine and accessible from the LAN, not the web. Trainees and instructors alike have expressed great interest in it. More importantly, some who do not have much experience using computers are doing so now.
I actually started out the course in WebCT, but after 3 months and one cycle of research, turned to Moodle, which I have been using ever since. I just have to convince the powers that be that putting a MySQL server on our web server, then moving my course there, will do no harm to existing installations and services. I will use the information on MySQL and SQL coexisting, and try to convince them, or maybe my local server could somehow be pointed to from the web server, thus giving me web access. I will follow up the links you gave me.
If anyone else has anything else to offer, I would be glad to hear from them.
Regards to all,
Matt
Thanks Howard,
I've followed those links, and think I can now go and make a case. I'll post to this forum if successful!
Thanks to all for replying,
Matt
Bill
There is an article on Technet which covers the process in some detail for SQL Server 2000 (http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx).
However, look through the forums for code changes in moodle.
Generally, it seems to be a lot of work to get SQL Server to run with Moodle. MySQL can be made to be similar to SQL server. Just customise the install with InnoDB and OLTP. Remember also to download MySQL Administrator and tune the service and startup variables for the mysql-max-nt.exe binary. And don't forget to set the Key Buffer and Buffer Pool Size variables for you host (see the very good tuning chapter in the MySQL docs).
Ken
