MySql - Need Help

[madebyflash]

I have my website, and i need it to work so that when i run installer.php it will connect to my mysql database.

The code of the mysql file is this. I have put in bold the bit that i need to edit.

<?php

// Config vars - absolutely needed before anything really happens.

// The local path on your server of script directory, INCLUDING THE TRAILING SLASH.
// This should be something like /home/yourdir/public_html/ or C:/Domains/YourGameSite.com/
$cfg['instdir'] = '/local-path/';
// The Internet URL of script, INCLUDING THE TRAILING SLASH.
// This should be something like http://www.example.com/
$cfg['baseurl'] = 'http://www.sitename.com/path/';
// Your MySQL database information information
$cfg['sqluser'] = 'DB-user';
$cfg['sqlpass'] = 'DB-pass';
$cfg['sqldb'] = 'DB-name';
$cfg['sqlhost'] = 'localhost';
// The title of your homepage. The global site title can be changed in the admin area.
$cfg['pagetitle'] = 'Online Games';
///////////////////////////////////

// This should really not be changed unless suggested by support staff.

$cfg['debug'] = "";

?>

I dont know what any of the top bit means, can someone please tell me what to put in there.

I also need to input the sqluser, sqlpass, sqldb and sqlhost

Obviously i know the username and password, but i dont know what to put into the other ones.

[Victor01469]

Hello,

sqlhost is: mysql
sqldb: 9543_name-goes-here
sqluser: 9543_name-goes-here
sqlpass: password for database, not account

Make sure you are entering the information you created here: http://account.ulmb.com/mysql/ - It should provide you with all the information you need!

Good luck! Let us know if this isn't working for you.

[madebyflash]

Yer, it works, i ran the installer, it found the database, but when i try to go to the main page, or log into the insites admin panel it shows me this:

Warning: include() [function.include]: URL file-access is disabled in the server configuration in /hosted/subs/ulmb.com/f/l/flashsquares/public_html/index.php on line 125

Warning: include(http://flashsquares.ulmb.com/hosted/subs/ulmb.com/f/l/flashsquares/public_html/plugins/site/themes/awesome/index.php) [function.include]: failed to open stream: no suitable wrapper could be found in /hosted/subs/ulmb.com/f/l/flashsquares/public_html/index.php on line 125

Warning: include() [function.include]: Failed opening 'http://flashsquares.ulmb.com/hosted/subs/ulmb.com/f/l/flashsquares/public_html/plugins/site/themes/awesome/index.php' for inclusion (include_path='.:/usr/local/share/pear') in /hosted/subs/ulmb.com/f/l/flashsquares/public_html/index.php on line 125

What do i do now?

[Victor01469]

Please copy/paste the fixed configuration file, after it was edited. Erase any passwords from the file.

We will need to make some changes to it, so that your script will work.

[madebyflash]

Do you mean this?


<?php

// Config vars - absolutely needed before anything really happens.

// The local path on your server of script directory, INCLUDING THE TRAILING SLASH.
// This should be something like /home/yourdir/public_html/ or C:/Domains/YourGameSite.com/
$cfg['instdir'] = 'http://flashsquares.ulmb.com/hosted/subs/ulmb.com/f/l/flashsquares/public_html/';
// The Internet URL of script, INCLUDING THE TRAILING SLASH.
// This should be something like http://www.example.com/
$cfg['baseurl'] = 'http://flashsquares.ulmb.com/';
// Your MySQL database information information
$cfg['sqluser'] = '9543_flashsqu';
$cfg['sqlpass'] = 'iputthepasshere';
$cfg['sqldb'] = '9543_flashsqu';
$cfg['sqlhost'] = 'mysql';
// The title of your homepage. The global site title can be changed in the admin area.
$cfg['pagetitle'] = 'Online Games';
///////////////////////////////////

// This should really not be changed unless suggested by support staff.

$cfg['debug'] = "";

?>

[Victor01469]

Ok, now change it to this:

<?php

// Config vars - absolutely needed before anything really happens.

// The local path on your server of script directory, INCLUDING THE TRAILING SLASH.
// This should be something like /home/yourdir/public_html/ or C:/Domains/YourGameSite.com/
$cfg['instdir'] = '/hosted/subs/ulmb.com/f/l/flashsquares/public_html/';
// The Internet URL of script, INCLUDING THE TRAILING SLASH.
// This should be something like http://www.example.com/
$cfg['baseurl'] = 'http://flashsquares.ulmb.com/';
// Your MySQL database information information
$cfg['sqluser'] = '9543_flashsqu';
$cfg['sqlpass'] = 'iputthepasshere';
$cfg['sqldb'] = '9543_flashsqu';
$cfg['sqlhost'] = 'mysql';
// The title of your homepage. The global site title can be changed in the admin area.
$cfg['pagetitle'] = 'Online Games';
///////////////////////////////////

// This should really not be changed unless suggested by support staff.

$cfg['debug'] = "";

?>

Once you copy/paste this in, you should be all set. Let me know how it turns out. Be sure to change your pass!

The original problem was in the local path. I fixed it for you.

[madebyflash]

OMG!!! i <3 you!!! yep, it works. Thanks for your help.