MySQL?

[graphix-invasion]

MySQL has been down for a while now. Any idea when it will be back up again? It seems like there is always something not working.

 

[Brandon]

I don't know why it is down; an administrator must bring it back up.

 

[Livewire]

Actually I got a question along these same lines - why does the account panel state MySQL is down when it clearly CAN'T be when it says it is?

My evidence as to why it can't be down? The news on my site, along with the affiliates and the forum - they're all running out of SQL and load just fine; if sql was down they wouldn't be loading.


Is that a glitch with the account panel or is it just a glitch with _my_ account panel?

 

[Brandon]

I dont know, it may be more security, if it can;t listen to the port, its offline.

 

[Bryon]

I restarted MySQL, post back if it's still not working right, or goes down again.

Livewire: It's probably a error with the function to check the service's status.

 

[graphix-invasion]

It's still down.

 

[Bryon]

What server are you on? MySQL is up and running on 66.232.109.231 and 66.232.119.248. I've restarted it on both servers also.

root@ciroc [~]# ps aux|grep mysql
root 16855 0.0 0.0 6004 1232 pts/1 S 23:10 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/ciroc.x10hosting.com.pid
mysql 16876 0.3 1.0 92244 15320 pts/1 Sl 23:10 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/ciroc.x10hosting.com.pid --skip-external-locking
root 16903 0.0 0.0 5620 644 pts/1 R+ 23:10 0:00 grep mysql

root@cossacks [/home/graphix]# ps aux|grep mysql
root 17707 0.0 0.0 3716 960 ? S 23:10 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/cossacks.x10hosting.com.pid
mysql 17728 2.2 2.6 111680 25396 ? Sl 23:10 0:04 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/cossacks.x10hosting.com.pid --skip-external-locking
root 18596 0.0 0.0 3968 660 pts/1 S+ 23:13 0:00 grep mysql

 

[graphix-invasion]

66.232.109.231

It doesn't work on my site, and according to the 'X10Hosting Services Up/Down' thread, MySQL isn't working at all.

 

[Livewire]

66.232.109.231

Mine's on 66.232.109.231 and it's working fine, just that the function to check if it's online or not ain't doing a dang thing :S

Now the question of the day: Where is your website, so I can see what (if anything) you mixed up with the connecting-to-sql part. Something tells me you're missing something, so here's a cheap checklist:

1) Do you have the connection string correct?
2) Did you remember to mysql_select_db BEFORE QUERYING, even if you only have 1 database?
3) Is your query formed properly to return data (as in, does the query itself have a typo/mistake)?

 

[dest581]

MySQL on the free server just isn't responding to outside requests. I tried testing using my own script on the sustained server, and it came back offline.

 

[t2t2t]

MySQL on the free server just isn't responding to outside requests. I tried testing using my own script on the sustained server, and it came back offline.

Sustained server != free server

I am in free server and MySQL is working better than HTTP

PS. Dest, in case if your requests are like mysql_connect, etc, then you must add sustained server ip to free server's ip's allowed to access:

You have to add your IP address to the allowed connections thing in cPanel.
Screeny:

Username: The username, like "tkd_USERNAME"
Password: the database password
Host: You're domain name
Port: Leave default
Database: The database, like "tkd_DATABASE"


Hope this helps

Cpanel -> MySQL databases -> Access Hosts (pretty bottom, above phpMyAdmin link) -> Add there your IP (don't know? Click Here)

 

[dest581]

I was doing the same thing the official status page does.

 

[Brandon]

The Status Site is fixed: http://status.x10hosting.com/status.php

I am currently updating the status page {with the images}

 

[dest581]

Offtopicish, but how did you fix it?

 

[Brandon]

Pings localhost {If it can't ping localhost, we can't connect anway}

 

[graphix-invasion]

I'll check it again once the HTTP is back up.
Edit:
It's working now. Thanks!