Print

[ibpnyc]

ok here is my situation:

I downloaded coppermine 1.3 and uploaded it to my server.  I plugged in all the info in the install.php file and gettung the following error:

Could not create a mySQL connection, please check the SQL values entered
MySQL error was : Can't connect to MySQL server on 'localhost' (10061)

I spoke to a support rep from my host and he sent me the following:
David: The database information this page shows is correct (install.php). Also, the database is responding properly on the server.
David: The script does not appear to be connecting to the database server, however. Since the connection defaults to "localhost" when blank, this explains the error message.

I apoligize if this is already covered in a post but i searched and did not understand anything i was reading.  Please note that I am not database savy and any help would be greatly appreciated.

Thanks in advance
Lo

[kegobeer]

Post your server details (webserver OS, PHP version, MySQL version) and also post what you entered for the database information during the install process (of course, don't post your password).

[ibpnyc]

Post your server details (webserver OS, PHP version, MySQL version) and also post what you entered for the database information during the install process (of course, don't post your password).

Webserver OS: Professional - Windows
Username: ibpnyc
MySQL Hosta: mysql4.brinkster.com
MySQL Database Name: ibpnyc
MySQL Username: ibpnyc
MySQL table prefix: coppermine

PHP version: I downloaded 5.0.5 but not sure how to install, use or relevance of it
MySQL version: Also downloaded 5.0.12 but not sure how to install, use or relevance of it

I apoligize fo my ignorance with the PHP & MySQL.  Your assistance is highly appreciated.

[kegobeer]

Your webhost has php and MySQL installed - those were the versions I was asking for.  A simple phpinfo script will tell you that.  What is phpinfo?  Or you can ask your host.  You do not need to install either of those packages on your local computer.  So, your webhost is running Windows?  What version (Server 2003, Server 2000, etc)?  I would also assume that your webhost is using IIS6.  Is this correct?

Go to this message and follow the directions I posted.  Report your success or failure and the script's output.

[ibpnyc]

Your webhost has php and MySQL installed - those were the versions I was asking for.  A simple phpinfo script will tell you that.  What is phpinfo?  Or you can ask your host.  You do not need to install either of those packages on your local computer.  So, your webhost is running Windows?  What version (Server 2003, Server 2000, etc)?  I would also assume that your webhost is using IIS6.  Is this correct?

Go to this message and follow the directions I posted.  Report your success or failure and the script's output.

Here is the phpnfo link
http://ibpnyc.brinkster.net/phpinfo.php

Here is the testphp link
http://ibpnyc.brinkster.net/testphp.php

[kegobeer]

Uh, you need to put in your information.

Code: [Select]

$localhost = 'your host name';
$mysql_user = 'your mysql user name';
$mysql_password = 'your mysql password';
$mysql_database = 'your mysql database name';
You need to replace the generic placeholder info with your MySQL information.

Your host is also running a very old and potentially unsecure version of PHP.  At this point I recommend finding another host.

[ibpnyc]

here is a conversation regarding the IIS6 and windows info:

Chat InformationPlease wait for a site operator to respond.
Chat InformationYou are now chatting with 'Mike'
Mike: Thank you for contacting the support department. How may I help you?
ibpnyc: hello
ibpnyc: i got a question
ibpnyc: just wondering i my webhost running IIS6?
Mike: What is your Brinkster User Name?
ibpnyc: ibpnyc
ibpnyc: also can you tell me if my webhost is running on Windows and what version
ibpnyc: thanx
Mike: Your account is on IIS 6.0 and Windows 2003
Mike: Is there anything else I can help you with at this time?
ibpnyc: no
ibpnyc: thanks a lot

[kegobeer]

Ask them if they know they are running a very old version of PHP that has potential security risks.  They need to upgrade - this risk is well documented and you can find posts about it on our site, as well as plenty of other sites.

[ibpnyc]

Uh, you need to put in your information.

Code: [Select]

$localhost = 'your host name';
$mysql_user = 'your mysql user name';
$mysql_password = 'your mysql password';
$mysql_database = 'your mysql database name';
You need to replace the generic placeholder info with your MySQL information.

Your host is also running a very old and potentially unsecure version of PHP.  At this point I recommend finding another host.

it connected sucessfully and sorry for not filling in the blanks earlier
http://ibpnyc.brinkster.net/testphp.php

[ibpnyc]

Ask them if they know they are running a very old version of PHP that has potential security risks.  They need to upgrade - this risk is well documented and you can find posts about it on our site, as well as plenty of other sites.

is this something commonly done if asked for.  I guess what im asking is do you think they will update this?

[ibpnyc]

Ask them if they know they are running a very old version of PHP that has potential security risks.  They need to upgrade - this risk is well documented and you can find posts about it on our site, as well as plenty of other sites.

is this something commonly done if asked for.  I guess what im asking is do you think they will update this?

also they are asking me what version and I talking about and what version to upgrade to

[kegobeer]

So, if you put those exact same values in during the install process, it doesn't connect?

Regarding upgrades: that's entirely up to your host.  However, security issues are normally handled immediately.  My host upgraded within one day after PHP made the next version available.  Ask your host why they haven't upgraded to at least 4.3.11.

[ibpnyc]

this is the conversation regarding the PHP version

Chat InformationPlease wait for a site operator to respond.
Chat InformationYou are now chatting with 'Mike'
Mike: Thank you for contacting the support department. How may I help you?
ibpnyc: hello
ibpnyc: i was wondering if there is any posibility of upgrading the version of PHP. I've been advised that the current running version is very old and has potential security risk
Mike: What version are you referring to?
ibpnyc: it is currently PHP Version 4.3.6
ibpnyc: i was told that 4.3.11 is a more secure version
Mike: You can send that request to our administrators at Info@Brinkster.com I suggest that you insert a link to the "potential security risk" so that our administrators could review it as well.
ibpnyc: thanks

[ibpnyc]

So, if you put those exact same values in during the install process, it doesn't connect?

Regarding upgrades: that's entirely up to your host.  However, security issues are normally handled immediately.  My host upgraded within one day after PHP made the next version available.  Ask your host why they haven't upgraded to at least 4.3.11.

this is strange, now when I open the install.php file and click lets go there is no error, is this normal?

[kegobeer]

Geez.  A support tech that doesn't even know what version of PHP they are running, and an administrator that doesn't pay attention to security!  They are also running an old version of MySQL (3.23.49).  Unless you have a lot of money tied into this hosting company, I really do recommend looking around for a better host.

Getting back on topic - it's not normal for an error to come and go like that.  Perhaps there was actually something wrong and your host fixed it without telling you.

[ibpnyc]

ok after i click "let go" it stays on the install page.  According to the online manual im suppose to log in with the admin username but I have not seen this yet.  Also what do you recommend for a good host?

[kegobeer]

There are a lot of posts about install.php staying on the same page - but you need to be more specific about what is on the page (just a logo, the exact same page, etc).  Please scan/search this board for related topics.  There are also threads about good hosts on other boards in our forum.

[ibpnyc]

cool thanks for all you help.....