I installed moodle on a server, and all worked well. Now my district will not allow me to run web services off of it. They want me to make it an sql server only, with the php package on the regular district web server.
I copied all the php files over to the new web server, and have tried to alter the config.php file to map to the sql server.
$CFG->dbtype = 'mysql'; // mysql or postgres7 (for now)
$CFG->dbhost = 'moodle'; // eg localhost or db.isp.com //
$CFG->dbname = 'moodle'; // database name, eg moodle
$CFG->dbuser = ''; // your database username
$CFG->dbpass = ''; // your database password
Obviously I don't know what I am doing. The warning page comes up saying that moodle couldn't connect to the database.
The username and password are correct, and privileges set on the database. I gave all privileges to the username, just to make sure.
I have tried the ip address in the place of host name. This does not work either. On the LAN, I just type in http://moodle and it pulls it up fine.
Any suggestions?