Installation issue - changing mySQL host

[JonR]

Hey peeps,

I've installed many copies of coppermine before and never had any issues, great piece of software.

Whilst trying to install this new installation, i need the program to connect to a sql database on a separate server.
However, no matter what i type in the sql host box, it still tries to connect to localhost (=the server name)

The includes/config.inc.php file has the correct settings, same as the sample config,
does anybody have any idea what im doing wrong or where the script is grabbing this info from?

thanks,
jon

[Joachim Müller]

Please post a link to your coppermine gallery and paste the data from config.inc.php into your posting (with your mysql username and password replaced by asterisks).

[JonR]

<?php
// Coppermine configuration file
// MySQL configuration
$CONFIG['dbserver'] =                         'mysql1.ukisp.com';        // Your database server
$CONFIG['dbuser'] =                         '*****';        // Your mysql username
$CONFIG['dbpass'] =                         '**********';                // Your mysql password
$CONFIG['dbname'] =                         'fastgam_images';        // Your mysql database name

// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg133_';
?>

However, whenever running the install, the script reports that it is unable to connect to:
Access denied for user: '*****@unix1.ukisp.com'

Its not like the config is being overwritten or anything either, ive checked it after the error, and it still says mysql1.ukisp.com

Ive re-downloaded the script and re-uploaded it as well, only to have the same issue.

[Joachim Müller]

Well, if the message is "access denied", then coppermine tries to connect to the remote mysql database you specified, but it is not allowed to do so. Most webhosts don't allow remote access to the database, both for security reasons as well as to avoid various sites that don't have a mySQL account to share one common mySQL database for budget reasons. Here's what you have to do: contact the webhost your mySQl database runs on and ask them if you're allowed to access it from another domain. If they say "no", then you simply can't use the remote mySQL database, you have to get one on the server that is suppossed to run coppermine. If the webhost says that it's suppossed to work, then check if you have actually set the proper username and password of the mySQL user. If this doesn't help, create a small script that checks the mySQL connection, as suggested here
Please post your results.

[JonR]

hi gaugau,

thanks for the reply!

the webhost stores the mysql databases on a separate server to the web site.
the site is on unix1.ukisp.com
the database is on mysql1.ukisp.com

i have other database scripts running on the site, connecting to the same database server.

its obviously me doing something wrong, not the script or the webhost.
i think ill just have to keep looking into it!

cheers for the help again tho, ill post back when i have it working and what i was doing wrong!

[kegobeer]

Access denied usually means the username/password isn't correct for that database.  Did you create a user that has access to your database?