Is mysql02 down?

[Maverick]

Would it be too much to ask what the staus of this server is, or is it being worked on at all?

[alphadesk]

Can you login to OPS and click the sql tab?

Does your msql info show ... db name, db server etc.

If so this info is pulling from mysql02 and is up.

Try it now and tell us what you get, because mysql02 has defintely not been down for 3 days and I don't think it is down now.

[Maverick]

Not sure what your asking, I went there and all i see is the users for the database, no info, nothing saying anything about server info.

I can't access the database with any front, nor is there any server found at that location

[alphadesk]

You don't see this something like this with a table below that list the users.

Your mySQL database XXXXX is hosted on PowWeb's server mysqlXX.powweb.com run mysqld version 4.0.16-log. Your database users and privileges are shown below. All changes are made in real time.

msql02 is up .....

[Maverick]

Okay, looks like the server is running, but I think there is a problem with the routing from the website (server) to the database server :(

[snowmaker]

Originally posted by Maverick
Okay, looks like the server is running, but I think there is a problem with the routing from my website (server) to the database server :(

how does one fix that?

-b

[James]

The server has not even been restarted in days... its running great:

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 are you getting?

[Maverick]

yes, the server is running, but from the website server(andromeda.powweb.com), it can't connect to the database at mysql02.powweb.com

[Flisher]

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

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...

[snowmaker]

Originally posted by James
What error message are you getting?

well, i can connect to my db with mysql-front, but a script i have that uses my db, and my mysqladmin script, will not.

the error message from the gigs list (http://somdcomputerguy.com/gigslist/index.php) script:

Can't connect to MySQL server on 'mysql02.powweb.com' (60)

the error message from mysqladmin:

#2003 - Can't connect to MySQL server on 'mysql02.powweb.com' (60)

-b

[actionsnaps]

I will second the fact that there IS a problem...

[tbonekkt]

I'm connecting successfully to my database on mysql02 from www08 - so the server is definitely not down.

actionsnaps - mysql issues and FTP issues are not related.

[actionsnaps]

I did not know that, but there WAS something wrong on YOUR end. I am now able to access my files on your server. It concerns me that that this happened and there does not seem to be an answer for it?

[tbonekkt]

Clarification: Mods are customers just like you. We're not PowWeb employees.

[Flisher]

Problem is at least from andromeda.powweb.com server.

running a simple phpgile that only do a mysqlconnect and a mysqldbconnect work from my computer, putting online on andromeda say it can't connect.

read the error message, mysql is made very clear. "Can't Connect" message is tcp/ip no connection. Then it can be for a few reason: invalid host, invalid ip, target not existing...

Sicne you are renumbering... it can be a rule forgotted somewhere, or an hardcoded host. but the problem can't be a user/password, since mysql is "intelligent" and would return an invalid user...

[Maverick]

I am really not liking the way this problem is being handled, it is easy to blame all the users, but you should at least send a tech to check this out....

[stevel]

Report it to PowWeb support.

[James]

It appears there was a problem with the routing tables on andromeda. I was not able to ping the mysql server though it is up. I was able to from the rest of our machines. I have rebooted the server and am able to connect now.

If you are on another server other than andromeda and are still having problems, please let us know what hostname you are on.

[[GT]-Reliant]

James i am back up and good to go.

Thanks

[[GT]-Reliant]

This morning our website went down. www.goldentriad.net
It was fixed this morning, refer to this thread.
http://forum.powweb.com/showthread.php?s=&threadid=29405

Now we are not able to connect to mysql02 just like last night
www.goldentriad.net/forum

Thanks

[mindrage]

Yeah.. :(

MySQL is not working again from andromeda. Was working fine this morning... then kaput..

Scott

[[GT]-Reliant]

It's back up again.

[andycc.net]

Sounds like the same sort of problem we're having on mysql04, although it does seem a bit more stable tonight than it did lastnight.

Refer to post 'mysql04 problems?' in this board for the problems we've had.