Help please!

[terryp3]

I've uploaded, CHMODed and when I run instal I get this error : mySQL could not locate a database called 'gwlan01_copper' please check the value entered for this

The values entered are : MySQL Host  localhost
(localhost is usually OK)   
MySQL Database Name    gwlan01_copper
MySQL Username    gwlan01_terry

I've set the db up thus : Users in copper
gwlan01_terry (Privileges: ALL PRIVILEGES)

Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:gwlan01_copper:localhost","gwlan01_terry","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "gwlan01_terry", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("gwlan01_copper"); 

So I don't know why it isn't finding it? Could be I'm a dummy and missing the obvious, in which case could you point me in the right direction?
Many thanks.

[kegobeer]

Did you use your control panel or phpmyadmin to create the db gwlan01_copper?

[terryp3]

I used the control panel. Does it make a difference kegobeer? I'll try using PHPMyadmin see what happens.

[terryp3]

I've set it up using phpmyadmin thus : Database gwlan01_coppermine running on localhost
Database gwlan01_coppermine has been created.

SQL-query : [Edit] [Create PHP Code]
CREATE DATABASE `gwlan01_coppermine` ;

but I'm still getting the same error trying to instal. I tried changing the name to coppermine as above and changing it in the instal fields but still can't find it?

[kegobeer]

Can you pm me your control panel url, login and password?  I'd like to take a look at your setup.

[terryp3]

PM sent.

[kegobeer]

Where's your coppermine installation?  I can't seem to find it.

[terryp3]

http://www.turkeyvilla.com/coppermine/install.php
Installed in www/coppermine.
I may try a completely new instal file by file as I'm running with 56k and a drunk slug moves faster. :-\\

[Joachim Müller]

- please allow some time before kegobeer will answer, he's currently away from his pc and can't look into this -

Thought I'd let you know...

Joachim

[terryp3]

Thanks Joachim, no problem. I have been known to be a patient lady, rarely, but known. 

[kegobeer]

Why doesn't /coppermine show up in your control panel?  If I connect via FTP it is visible.

I uploaded a small script to connect to the db, and it works.  However, coppermine can't connect for some reason.

[kegobeer]

I'm stumped.  A simple php script that connects to your database works fine, but the Coppermine script can't make any connections at all.  Anyone have an idea here?  Maybe a permission thing that the host needs to straighten out?

[terryp3]

Kegobeer, I've found out our hosts are changing servers and can only assume that has something to do with it. I'll see if I can connect coppermine and the db in a couple of days allowing it time to complete, though the fact that you can get another script to connect has me wondering.
It could be something silly like the instal files are sitting on one server while the db's have been transferred?
I'll keep you posted which ever way, and thanks for your help, just glad to know it isn't something inane I've done.

[terryp3]

Kegobeer, have you had any other thoughts on this? I've tried re uploading but I'm still getting the same thing?

[kegobeer]

I noticed that I could see your coppermine directory if I use a FTP program, but if I log into your CP I couldn't see the directory at all.  This might have something to do with it but I'm not sure.  Ask your host about that, see if they have an explanation.

[terryp3]

I will, it's somewhere to start, thanks kegobeer.