mysql01 is not working for me

[mindrage]

what happened yesterday? My site is down all day today and no pages dealing with mysql database works!! Everything was fine yesterday and days before. But nothing is working now. And I didnt change anything.

Anyone else have this problem? I have submitted ticket to Support.

[mindrage]

Tech said nothing was wrong with mysql01.powweb.com. I could connect through my Windows client (MySQL Control Center) and everything looks okay. But when I tried connecting through web, nothing works. And before, everything was fine. My blog, guestbooks, etc.. everything was working fine as of 2 days ago. Now none of those pages work.

The thing that bugs me about Powweb is that in the past, I always send something to them about something not working. They somehow fix it... and sends me an email saying they couldnt find anything wrong. They never admit anything was screwed up in the first place.. which bothers the heck out of me.

[James]

Thats interesting, we do not allow remote access to our mysql servers anymore... you should not be able to connect with your window's client.

mysql01 does not appear to have been down anytime recently...

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2166097 to server version: 4.0.16-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> status;
--------------
mysql Ver 11.18 Distrib 3.23.58, for portbld-freebsd4.9 (i386)

Connection id: 2166097
Current database:
Current user: root@localhost
Current pager: stdout
Using outfile: ''
Server version: 4.0.16-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 4 days 32 min 16 sec

Threads: 10 Questions: 53534323 Slow queries: 179 Opens: 737455 Flush tables: 97 Open tables: 5960 Queries per second avg: 154.040
--------------

[RocketJeff]

Originally posted by James
Thats interesting, we do not allow remote access to our mysql servers anymore... you should not be able to connect with your window's client.
If you look at recent posts in the forum, there are plenty of poeple connecting with off-site software like mySQL-Front.

Just to test this, I just connected successfully to mysql04 with no problems with mySQL-Front.

You might want to talk with the techs again - it looks like there still isn't effective communication between Powweb employees.

[[GT]-Reliant]

I am having mysql02 problems with my site also. It cannot connect to mysql02

www.goldentriad.com/forum

[James]

The server is running nicely...

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4433315 to server version: 4.0.16-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> status;
--------------
mysql Ver 11.18 Distrib 3.23.58, for portbld-freebsd4.9 (i386)

Connection id: 4433315
Current database:
Current user: root@localhost
Current pager: stdout
Using outfile: ''
Server version: 4.0.16-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 7 days 20 hours 9 min 42 sec

Threads: 9 Questions: 73629091 Slow queries: 563 Opens: 1362434 Flush tables: 190 Open tables: 1997 Queries per second avg: 108.697
--------------

What error message if any are you receiving?

[[GT]-Reliant]

James i dont know if you were talking about 01 or 02 but this is the error i recive when i try to access my site.

we use mysql02

www.goldentriad.net/forum

Warning: mysql_connect(): Can't connect to MySQL server on 'mysql02.powweb.com' (60) in /www/e/echung2/htdocs/forum/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /www/e/echung2/htdocs/forum/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /www/e/echung2/htdocs/forum/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database



Everything was running fine untill about friday when this happend

Thanks

[James]

That was mysql02. And nothing has changed since Friday.

The second and third php error messages are only because you didn't get connected. Have you verified your username and password?

[Flisher]

Hi,
working for the guy who posted mysl02 problem, here are all the test I made: (another thread)

Volountary error made from my own computer connecting with a php file from apache

*bad database name:
Unable to select database

*bad database host:
Warning: mysql_connect(): Access denied for user: 'flisher@modemcable220.69-131-66.mc.videotron.ca' (Using password: YES) in d:\web\apache group\apache\htdocs\test.php on line 2
Cannot connect 2.

*bad username:
Warning: mysql_connect(): Access denied for user: 'flisher2@modemcable220.69-131-66.mc.videotron.ca' (Using password: YES) in d:\web\apache group\apache\htdocs\test.php on line 2
Cannot connect 2.

*bad password:

Warning: mysql_connect(): Access denied for user: 'flisher@modemcable220.69-131-66.mc.videotron.ca' (Using password: YES) in d:\web\apache group\apache\htdocs\test.php on line 2
Cannot connect 2.

now, if i block from my firwall:
Warning: mysql_connect(): Can't connect to MySQL server on 'mysql02.powweb.com' (10061) in d:\web\apache group\apache\htdocs\test.php on line 2
Cannot connect 2.

Notice that last test give the same error than the webpage.
if I run the same php file without error from my computer, but from your webserver, it say it can't connect.

Since i read somewhere i should'nt be able to connect from the outside, and you where renumbering, my main guess is that there is a firewall or mysql server rule messed somewhere.

Since the problem seem to be existing for many people that doesn't changed anything on their website for different webserver(read other forum), my guess is there is really a problem that you won't be able to see connecting from your helpdesk pc...

[mindrage]

Everything is working again... After several days of nothing working. But what is exasperating is that POWWEB tech keep insisting nothing ever went wrong. Even now, the last email said mySQL was working fine and told me to get support from the forums and that Powweb wasnt responsible for mySQL issues.

[mindrage]

Same issue as this thread... This thread (http://forum.powweb.com/showthread.php?s=&threadid=29359) .

Anyways, resetting the server solved the issue. So there was an issue. But Support kept insisting there was no issue and told me Powweb is not responsible for mySQL issues. Anyways, I am just glad it finally got fixed for everyone. Still not happy Support told me to look in the forums instead of investigating this issue.

[James]

We are working hard to improve our Customer support, however, in the "support" of our support department, they receive hundreds of people insisting that we have something wrong when in fact it is something the customer has done or is not doing right, and a lot of people do not provide enough details about problems for there to really be an investigation. I get forwarded messages to investigate and help fix all the time, and 8 out of 10 times I have to reply to the customer first asking for more information.

Most likely they heard "mysql01 is down", and they looked and saw that is was up and running fine, which in all honesty it was.

[mindrage]

Hi James,

Yes, I could tell you are trying your best to help customers on this forum. So I am grateful we have your presence here. It really helps to know at least someone is listening and willing to investigate a little further.

Actually, I went into details about the issue and even sending a screenshot of the error message. But honestly, I dont know anything about mySQL to understand what the cause is. As a customer, I dont know how servers are set up or any of the technical details. Other than it is not working. But I do understand your point.

Again, thanks for your help in getting us back up again.