MySQL down on Absolut >1 day

[theroms]

[Fixed] MySQL down on Absolut >1 day

Hello, according to the account panel and my site error reporting, MySQL has been down on Absolut for more than one day long by now.
Can you please try to fix it or inform us if there's something going on ? Just telling everybody you're aware of the situation would be much appreciated.
Thanks

 

[TechAsh]

MySQL is not down.

The server status scripts sometimes report false downtime because the x10 Firewall is blocking it.

 

[theroms]

Oh I see, then, as I have not changed anything in my scripts, what could have changed ? I've read about a modification in the PHP settings (I have intermediate) but this shouldn't affect the mysql functions.
Can you confirm ?

 

[TechAsh]

Absolut MySQL is working fine for me, I'm using it now.

There is another user in IRC who is getting the same error as you, but they are on a different server.

 

[theroms]

Ok, thank you for the infos. Could you tell me if you're using "mysql_something" functions or "mysqli_something" (notice the "i"). This could be the issue : I'm using an old phpBB2 script with what seems to be a MySQL4 compatible script. Second point, I've not been using mysql_ versions of the functions for a long time on my tests servers at home, if I remember well, only mysqli_ versions work on newer MySQL versions.
Can you please confirm which version you use ? (to prevent me from rewriting to much code for nothing ...)
Thanks

Edit: Fixed
After the server moves around january, my DB url ended to be "localhost.x10hosting.com" which just makes no sense to me. But it worked like that for about 6 months. I believe setting it to just "localhost" at that time didn't work for me or I wouldn't have let that pass. Anyway, I don't remember. Setting it today to "localhost" works normally, as expected. May this help some others "having" SQL down.

Edit: (relative to next one)
Backup is now alright. FTP, HTTP working again.

Edit:
Reading others' posts, it seams "mysqli_" functions are also not working for them. By now, I'm trying to backup my site to host it at home until I can find a solution to host it on x10 again but I can't use FTP. It looks like I've been denied access :
I first downloaded a quarter of my files then I couldn't connect anymore (both FTP and HTTP). I reset my ADSL box (so I obtained a new IP) twice and was able to get to other quarters of my files. I now need approx the last quarter of my files but I won't have any new IP from my ISP so I can't hack around my IP being banned or so by x10. I believe IP is the issue there.
So far :
- I can't use your services (FTP, HTTP down for me, SQL not working for the account)
- You don't allow me to retrieve MY files (I feel like being stolen right now)
This is being way too annoying by now. Please do something or give me some feedback because I feel left alone with just no option to allow me to get it fixed by myself. I'm sort of hand-tied here and it doesn't feel good.
Thank you for your understanding.
(In any case I would sound rude, please understand this is not my native language, thus not my intent)

 

[Corey]

Hi, MySQL is NOT really off.

We support mysql_ on all the servers, and we are using MySQL 5.0. Some servers also support mysqli and all will in the next month.

Regarding FTP, in the settings of your FTP client it probably has multiple connections. Turn this OFF. FileZilla especially opens up over 100 connections causing our firewall to put a temporary ban on your IP.

-Corey