topic Re: Lost Database Access -URGENT in Archive

Lost Database Access -URGENT

brainychat — Fri, 07 Oct 2011 16:17:44 GMT

After the lengthy server downtime 06/10/2011 I've since discovered that my page can no longer access the MySQL database. After checking phpMyAdmin I noticed that the Database User, previously "blahblah@web170c30.carrierzone.com" had been changed to a bare IP address beginning blahblah@69.49. However, when changing the user name in my access program to the login displayed by phpMyAdmin, the program still cannot connect to the database.

I will continue to investigate, but would be grateful if I could be pointed at any BT announcements which explain these changes and how long they are likely to continue. Thanks.

Re: Lost Database Access -URGENT

brainychat — Sun, 09 Oct 2011 18:29:58 GMT

I have found the answer, thanks to my running a different site using phpMyAdmin by a different provider.

When first setting up my database access it took a while to realise I had then to include the whole of the user as displayed on the phpMyAdmin dashboard page, including "@web170c30.carrier....", the part that I noted above was replaced by a bare IP address.

This is what has changed - because the @server is an IP address, now you have to EXCLUDE that part from the database username. So now a connection to the database goes

$db='main_my_domain_co_uk';
$dbh='sql5c30a.carrierzone.com';
$dbu='bchat99965'
/* REMOVED $dbu='bchat99965@web170c30.carrierzone.com'; */
$dbp='mydbpass';
mysql_connect($dbh,$dbu,$dbp);

Hope other site runners with this problem have found this useful.

Re: Lost Database Access -URGENT

Frankproperty — Tue, 11 Oct 2011 18:01:28 GMT

Our site was also knocked out by this update and it took an hour to get it back up and running.

Is there any email list that we can subscribe to in order to get service updates when BT are making such changes to the Databases, or other technical issues?