[solved] "Unable to connect to database" error during install

Neil Girardi

Joined: 2009-07-22
Posts: 64

Posted: Thu, 2009-09-17 16:31

I just installed g2.3 onto a new hosting package from Pair Hosting. I uploaded the 2.3 full install zip and unzipped it in the command line (go me! are you proud of me?). I created a new MySQL database in the Pair control panel. Everytime I try to connect to the database on STEP 5 it says unable to connect , followed by a more detailed error message:

Warning: mysqli_real_connect() [function.mysqli-real-connect]: (HY000/2005): Unknown MySQL server host 'db48a.pair.com ' (1) in /usr/www/users/neilcnd/gallery2/lib/adodb/drivers/adodb-mysqli.inc.php on line 109
Could't connect :
db48a.pair.com : Unknown MySQL server host 'db48a.pair.com ' (1)

I was just on the phone with a tech from Pair who verified that I had the correct DB Host name, DB name, and DB password.

I just don't seem to have good luck with gallery...

Anyone have any ideas?

Thanks!!!

Please fill out the following form and take a look at the linked pages. The more information you supply, the better we can help you. Remove this FAQ information from your post before submitting.

FAQ:
- How do I install Gallery 2?
http://codex.gallery2.org/index.php/Gallery2:How_do_I_Install_Gallery2
- How can I find a solution for my problem?
Visit http://codex.gallery2.org for: Frequently Asked Questions, Debugging Instructions, Known Issues and much more
Also try your luck with the advanced search function of this website
- What are the installation requirements for Gallery 2?
http://codex.gallery2.org/index.php/Gallery2:Installation_Requirements
- What information is required when asking for help in the forums?
http://codex.gallery2.org/index.php/Gallery2:faq#What_information_is_required_when_I_ask_for_help_in_the_forums.3F
- You can copy and paste a lot of the required information from "Site Admin" -> "Maintenance" -> "System Information" if your G2 is up and running.

Gallery version (not just "2"):
PHP version (e.g. 5.1.6):
PHPInfo Link (see FAQ):
Webserver (e.g. Apache 1.3.33):
Database (e.g. MySql 5.0.32):
Activated toolkits (e.g. NetPbm, GD):
Operating system (e.g. Linux):
Browser (e.g. Firefox 2.0):

Neil Girardi

www.CenterfoldNextDoor.com

nivekiam

Joined: 2002-12-10
Posts: 16503

Posted: Thu, 2009-09-17 17:40

That's really odd, I've installed G2 dozens of times at Pair.

First I would try a different MySQL option. I'm not sure which one you selected. If you still have problems you can PM me and I can help dig into this further. I'm very familiar and comfortable with Pair's setup and environment having been a customer there for 6-1/2 years
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

nivekiam

Joined: 2002-12-10
Posts: 16503

Posted: Thu, 2009-09-17 18:53

Just replied to you (twice). Looks like Pair has resolved what ever was going on.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

Neil Girardi

Joined: 2009-07-22
Posts: 64

Posted: Tue, 2009-09-22 03:32

This is solved thanks to the help of nivekiam and Pair.com's support team.

Thank you!

Neil Girardi

www.CenterfoldNextDoor.com

Neil Girardi Joined: 2009-07-22 Posts: 64	Posted: Thu, 2009-09-17 16:31
	I just installed g2.3 onto a new hosting package from Pair Hosting. I uploaded the 2.3 full install zip and unzipped it in the command line (go me! are you proud of me?). I created a new MySQL database in the Pair control panel. Everytime I try to connect to the database on STEP 5 it says unable to connect , followed by a more detailed error message: Warning: mysqli_real_connect() [function.mysqli-real-connect]: (HY000/2005): Unknown MySQL server host 'db48a.pair.com ' (1) in /usr/www/users/neilcnd/gallery2/lib/adodb/drivers/adodb-mysqli.inc.php on line 109 Could't connect : db48a.pair.com : Unknown MySQL server host 'db48a.pair.com ' (1) I was just on the phone with a tech from Pair who verified that I had the correct DB Host name, DB name, and DB password. I just don't seem to have good luck with gallery... Anyone have any ideas? Thanks!!! Please fill out the following form and take a look at the linked pages. The more information you supply, the better we can help you. Remove this FAQ information from your post before submitting. FAQ: - How do I install Gallery 2? http://codex.gallery2.org/index.php/Gallery2:How_do_I_Install_Gallery2 - How can I find a solution for my problem? Visit http://codex.gallery2.org for: Frequently Asked Questions, Debugging Instructions, Known Issues and much more Also try your luck with the advanced search function of this website - What are the installation requirements for Gallery 2? http://codex.gallery2.org/index.php/Gallery2:Installation_Requirements - What information is required when asking for help in the forums? http://codex.gallery2.org/index.php/Gallery2:faq#What_information_is_required_when_I_ask_for_help_in_the_forums.3F - You can copy and paste a lot of the required information from "Site Admin" -> "Maintenance" -> "System Information" if your G2 is up and running. Gallery version (not just "2"): PHP version (e.g. 5.1.6): PHPInfo Link (see FAQ): Webserver (e.g. Apache 1.3.33): Database (e.g. MySql 5.0.32): Activated toolkits (e.g. NetPbm, GD): Operating system (e.g. Linux): Browser (e.g. Firefox 2.0): Neil Girardi www.CenterfoldNextDoor.com
	XUser login Username: * Password: * Create new account Request new password
nivekiam Joined: 2002-12-10 Posts: 16503	Posted: Thu, 2009-09-17 17:40
	That's really odd, I've installed G2 dozens of times at Pair. First I would try a different MySQL option. I'm not sure which one you selected. If you still have problems you can PM me and I can help dig into this further. I'm very familiar and comfortable with Pair's setup and environment having been a customer there for 6-1/2 years ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

nivekiam Joined: 2002-12-10 Posts: 16503	Posted: Thu, 2009-09-17 18:53
	Just replied to you (twice). Looks like Pair has resolved what ever was going on. ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

Neil Girardi Joined: 2009-07-22 Posts: 64	Posted: Tue, 2009-09-22 03:32
	This is solved thanks to the help of nivekiam and Pair.com's support team. Thank you! Neil Girardi www.CenterfoldNextDoor.com

[solved] "Unable to connect to database" error during install

XUser login