Welcome Guest ( Log In | Register )



 
Reply to this topicStart new topic
> Flush Hosts, can i do that? where?
ruben
post Dec 14 2005, 11:36 AM
Post #1


Wheeeeeeee!
Group Icon

Group: Members
Posts: 245
Joined: 19-October 05
From: DG, Belgium
Member No.: 9,200



QUOTE
Warning: mysql_connect(): Host 'gamma.xisto.com' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/ruben/public_html/voc/de/database.php on line 2

I get this error when trying to access my database. Apparently my site caused connection errors.
I mailed to astahost support, but got no reply yet and I thought maybe it is possible to fix the problem myself, because I searched the internet and found that I have to access my site via SSH/telnet and use the command
CONSOLE
mysqladmin flush-hosts

but I actually have no idea of how to do that and if I can do that. I think I have to specially request SSH access but I was thinking there might be the possibility to do this kind of stuff with Cpanel or somehow differently.
When searching the Cpanel I found the message that I had to unclosed operations in MYsql. Don't know where the hell they come from. I don't know either what caused the connection errors.
Could someone please help me with this issue? It puts my whole website down and I don't even no what the problem was.
Would it solve my problem to request SSH access and then execute the command there?

thanks,
Ruben
Go to the top of the page
 
+Quote Post
PureHeart
post Dec 14 2005, 01:38 PM
Post #2


Premium Member
Group Icon

Group: Members
Posts: 209
Joined: 7-October 05
From: Đà Nẵng City - Việt Nam
Member No.: 8,966



There's something wrong with Astahost's MySQL Service these days. You don't need to do anything. The problem itself will disappeared soon.
Go to the top of the page
 
+Quote Post
ruben
post Dec 19 2005, 12:46 PM
Post #3


Wheeeeeeee!
Group Icon

Group: Members
Posts: 245
Joined: 19-October 05
From: DG, Belgium
Member No.: 9,200



Nup, doesn't. Anyone knows a fix for it?
Would the solution be to request SSH access. Who can give a little information on SSH? Just that much, so that I don't destroy anything and fix this issue..
Go to the top of the page
 
+Quote Post
PureHeart
post Dec 19 2005, 01:38 PM
Post #4


Premium Member
Group Icon

Group: Members
Posts: 209
Joined: 7-October 05
From: Đà Nẵng City - Việt Nam
Member No.: 8,966



OK, if so. You always can contact Astahost support team. Send an email to support@astahost.com and your problem will be solved quickly.

SSH, why do you need it?

Even when you have the SSH access, you still can't run the mysqladmin command.
Go to the top of the page
 
+Quote Post
saint-michael
post Dec 19 2005, 07:14 PM
Post #5


SM- the Man -The Myth - The Legend Himself
Group Icon

Group: Members
Posts: 457
Joined: 4-September 05
From: Drinking da rootbeers
Member No.: 8,313
myCENTs:72.48



well on top of mysqls you have to remeber other websites connect to it as well, so i would go through your logs to see who visits your site and mooches stuff off of it.
Go to the top of the page
 
+Quote Post
jipman
post Dec 19 2005, 08:00 PM
Post #6


Pretty please?
Group Icon

Group: Members
Posts: 733
Joined: 28-November 04
From: Holland
Member No.: 1,552



For some reason SSH requesting posts haven't been replied to for........ well.... a while sad.gif
Go to the top of the page
 
+Quote Post
ruben
post Dec 19 2005, 09:14 PM
Post #7


Wheeeeeeee!
Group Icon

Group: Members
Posts: 245
Joined: 19-October 05
From: DG, Belgium
Member No.: 9,200



Well, I submitted a ticket about this to xisto-support now, did this before, but due to my own idioty I think it never arrived. Plus the helpdesk was down an hour ago or something.
Saint-Michael: I don't actually believe that this is caused by a visitor mooching (can't be sure of course, but the website with database access is not very popular yet), but how could they cause connection errors?
Does anyone have real knowledge on why hosts get banned and how to prevent it?
I saw in a log file, that two operations were left open. As far as i know not by my bad coding practice, but I could be wrong needless to say..

Are you sure about the fact, that I wouldn't be able to access mysqladmin with SSH access? My Google searches told me differently and this is not exactly something, that affects all users (I mean if gamma.xisto.com was banned as access host for all users we would have a damn riot here ^^).

PureHeart, btw. you should not post Email-adresses in straight form, because this way they are left as prey to spambots. Maybe a mod could mask the address in your post.

Thanks a lot for all your help,
Ruben

Sorry for double-posting, but I wanted those who have the same problem to find help here.
So, I asked Xisto-Support to flush hosts for me, because (as PureHeart knew) I don't have the privileges for mysqladmin commands. They did, everything worked fine for a day, but on the next day I had the same problem again. Something in my website is causing this error and I have no idea what. I was told in support that I should close all connections (I checked and I think I do) and to use neat code. Well, no sooo neat, but it worked before and I don't remember any major changes.
Does anyone know, what else causes a host to get banned with MySQL?
And especially where I could find out what it was on my site? I verified that every MySQL connection is closed, there is no information in the error-log, so I guess that I'll have to search on. My next step is checking the statistics for pages that were called 10 times on the day of the downtime (because I was told that the mysql-banning borderline is 10 errors).
Please help!
Go to the top of the page
 
+Quote Post
ruben
post Jan 21 2006, 02:22 PM
Post #8


Wheeeeeeee!
Group Icon

Group: Members
Posts: 245
Joined: 19-October 05
From: DG, Belgium
Member No.: 9,200



Hello,
I'm writing again today, because the issue remains unresolved and I'm getting really desperate about this. I have been searching the internet and asking experts, but no one can provide me with possible reasons other than broken connections in the site (caused by mysql_pconnect and no close).
This is the Xisto Support-Document in which they generously helped me quite often, but they are growing tired of it of course and I still can't find the cause for my problem. As you can read in the support document, I tried deleting all my databases and making my mysql-sites inaccessible. I just checked if it worked on a 100% working file twice. First time it worked and few hours later it was broken again.
So unless there is something on my homepage that I don't know about (which I can't believe), then it must come from the outside somehow. I'm currently running my main MySQL-based page on another server, stable for two days now, so that I've reason to believe that the reason lies somewhere beyond my understanding.
Anyone here who has experienced similar or who has an idea, what might be causing this? Please right the support-document too, so that you know what I have been up to till now.

Thanks a lot, if anyone can help!
Ruben
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Surf With Less Ads(32)
  2. For Those Who Want A Message Board(6)
  3. Suggest Free Php Host(17)
  4. The On Going Free Hosting List(8)
  5. I Simply Love The Free Web-hosts And The Internet(2)
  6. Ssh Access Request(1)
  7. Ssh Access + Reload Privilege(0)
  8. What Are The Best Image Hosts Out There ?(20)
  9. Why Dont A Lot Of Free-hosts Support PHP ?(4)
  10. Apache Virtual Hosts(2)
  11. Book Sale For Charity(1)
  12. Leanr How To Give Your Computer A Flush!(3)
  13. One Of The Most Promising Hosts(6)
  14. Do You Remember Your Previous Web Hosts?(9)
  15. Safari And Hosts File(8)
  1. Are Name Servers From Different Hosts Compatible?(2)
  2. Web Hosting - Changing Hosts With Existing Domain Name(1)


 



- Lo-Fi Version Time is now: 2nd December 2008 - 09:58 PM