Database Connection Issue: DB_HOST, ipower

Resolved tylerstyle
(@tylerstyle)

16 years, 1 month ago

To the good folks in wordpress land…my wish for all of you is that you never have to deal with ipower!

I have a question. I am trying to install wordpress in a directory called blog. The db connection errors out.

I sent the following note to ipower (as well as a 2 hour phone converation, and a chat, in which they told me someone would get back to me with the proper information in 1 hour–2 days ago!)

Need the DB_HOST value for ipower DB mysql connection.

Hi, I am manually installing WordPress. It uses a database connection. The DB_HOST value of “localhost” does not work…nor does the one provided to me by the chat support. The value of that was…thisishowyoudoit.ipowermysql.com.

I have a test page here: http://www.thisishowyoudoit.com/testdb.php

And this is the one that is not working for WordPress: http://thisishowyoudoit.com/blog/wp-admin/install.php

Please provide me with the proper connection information for the DB_HOST value.

Thank you.

…Well, as I mentioned, that was 2 days and 4 hours of chats and phone calls for this one piece of information. I think my first blog will be about my ipower experience.

I’m excited to get my blog going. Does anybody know the proper db_host value for ipower?

Thanks in advance for your help,
Richard

Viewing 11 replies - 1 through 11 (of 11 total)

Moderator Samuel Wood (Otto)
(@otto42)

WordPress.org Admin

16 years, 1 month ago

Looking around on Google, I see that that is at least sorta correct. ipower does indeed use loginname.ipowersql.com as their database host names. However, “loginname” might not be your site name, but might be your username with ipower. Some people say it’s their “account login name on iPowerWeb” if that has any meaning to you. But on other sites, it says that on “VDeck 3.0” they are using “DOMAINNAME.ipowermysql.com”, which sorta backs up what they told you.

Thread Starter tylerstyle
(@tylerstyle)

16 years, 1 month ago

Otto, thanks for you response. Since they’ve done this “upgrade” to vdeck and their entire backend, ipower has had many problems. It’s amazing with 700,000 customers that they cannot answer a simple question like this.

Anyway, I have tried both both domain name and username to no avail (also tried names from sql admin tool and ip address and nothing).

Maybe I’m caught in some sort of unknown upgrade state.

If anybody out there has any other information that could help, that would be great.

Somebody must have done a manual installation of WordPress on ipower’s new platform. Where are you??? 🙂

Thanks all in advance.

–Richard

MichaelH
(@michaelh)

16 years, 1 month ago

With vdeck, when you create a MySQL database, it shows the server/host at the bottom of the box that shows the database/database user/privleges.

Also, sometimes you can click on the Administration link for that database and in phpMyAdmin you can see the server name at the top of the screen.

silverbrown
(@silverbrown)

16 years, 1 month ago

Ok! I think we are in the same boat………

Here is my code that no longer works since they migrated to the new server.

<?
$username=”*********WORKS********”;
$password=”*******WORKS*********”;
$database=”gatekeep_media”;

mysql_connect(gatekeep.accountsupportmysql.com,$username,$password);
@mysql_select_db($database) or die( “

<B>Error: IP recorded and time-stamped”);

$query=”SELECT * FROM PICS ORDER BY TITLE”;
$result=mysql_query($query);
$num=mysql_numrows($result);
?>

Thread Starter tylerstyle
(@tylerstyle)

16 years, 1 month ago

Michael, thank you for the information. This is the same name provided by ipower web that is not working.

Still trying to get a hold of ipower. Well, I can actually get a hold of someone but NOBODY is able to help.

I have even told them that they could erase all my databases and start from scratch. Just demonstrate to me that you can create and connect to a database and I’ll take it from there.

And…nothing. They have not been able to do that.

silverbrown
(@silverbrown)

16 years, 1 month ago

I just put in a ticket as well……..

It might have to do with the upgrade in mysql or php.

silverbrown
(@silverbrown)

16 years, 1 month ago

The resolved my issue. referenced a variable in the mysql_connect string.

Thread Starter tylerstyle
(@tylerstyle)

16 years, 1 month ago

Thank you all for your help with this issue. It seems that iPower may have resolved it on the backend…even though they never responded to my ticket.

Resolution: The db_host value that they original said now works.

Thanks again for the responses,
Richard

PS: Now I am getting a CGI error so I might have to post again 🙂

magicnewswire
(@magicnewswire)

16 years, 1 month ago

Just got off of the phone with reseller support. They are in the process of migrating my account to the new platform. According to the agent with whom I spoke, and who appeared rather knowledgeable, the wp-config.php file value for “localhost” no longer works and should be changed to:

accountusername.accountsupportmysql.com

I’ll followup once my migration is complete and advise as to the outcome.

bostonband
(@bostonband)

15 years, 5 months ago

Hi, I am an ipower customer at http://www.bostonweddingband.com. This may work. Open your wp-config page in a text editor, find

define(‘DB_HOST’, ‘localhost’);

replace localhost with youripowerusername.ipowermysql.com

It worked for me http://www.bostonweddingband.com/blog/ but now I receive another error message when I try to reach the /blog/wp-login.php page that reads.

CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers.

One door opens…another door closes apparently.

Samuel B
(@samboll)

15 years, 5 months ago

@bostonband
http://wordpress.org/support/topic/181351?replies=1
review this