Flush Hosts - can i do that? where?

free web hosting
Free Web Hosting > Astahost > Hosted Members Support > cPanel

Flush Hosts - can i do that? where?

ruben
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

 

 

 


Reply

PureHeart
There's something wrong with Astahost's MySQL Service these days. You don't need to do anything. The problem itself will disappeared soon.

Reply

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

Reply

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

Reply

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

Reply

jipman
For some reason SSH requesting posts haven't been replied to for........ well.... a while sad.gif

Reply

ruben
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!

 

 

 


Reply

ruben
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

Reply


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.

Recent Queries:-
  1. flush host - 17.52 hr back. (1)
  2. flush hosts - 43.57 hr back. (1)
  3. flush hosts entries - 55.63 hr back. (1)
  4. mysqladmin flush hosts - 79.71 hr back. (1)
  5. how to flush host in php - 152.49 hr back. (1)
  6. flush-hosts - 41.22 hr back. (2)
  7. ssh flush-hosts command - 159.11 hr back. (1)
  8. flush-hosts command - 158.84 hr back. (2)
  9. mysqladmin flush-hosts 対象ホスト - 243.26 hr back. (1)
  10. mysqladmin flush-hosts - 9.51 hr back. (7)
  11. mysqladmin flush-host - 273.12 hr back. (1)
  12. what is flush hosts - 310.04 hr back. (1)
Similar Topics

Keywords : flush, hosts

  1. Web Hosting - Changing Hosts With Existing Domain Name
    changing hosts (1)
  2. Are Name Servers From Different Hosts Compatible?
    (2)
    Recently, I purchased managed DNS for my TLD (maxotek.net), just to see if I could manually get the
    IP address to point to the new Gamma server IP address. The Managed DNS feature requires that I
    change the Name servers to:- WHIZ.EARTH.ORDERBOX-DNS.COM WHIZ.MARS.ORDERBOX-DNS.COM
    WHIZ.MERCURY.ORDERBOX-DNS.COM WHIZ.VENUS.ORDERBOX-DNS.COM Being hosted at Asta, the name servers
    are required to point to:- NS.COMPUTINGHOST.COM NS2.COMPUTINGHOST.COM Because, there were many
    slots for the name servers I appended the former name servers to the list. My question is that, wil....
  3. Safari And Hosts File
    Overriding the file?? (8)
    I found this to be quite alarming when I found that sites I blocked using HOSTS were still
    accessible by Safari. My HOSTS file consists of many automatically added entries by Spybot S&D and
    SpywareBlaster and similar programs, but I also have some user added entries also. It is a 228KB
    file, and a small segment that I added looks like this: 127.0.0.1 myspace.com 127.0.0.1
    www.myspace.com 127.0.0.1 ca.myspace.com I found it to be inaccessible by all user accounts
    using Firefox, Internet Explorer, Opera and Flock. However, I tried accessing it using Safari an....
  4. Do You Remember Your Previous Web Hosts?
    A lot of sites disappearing? (9)
    You know what ? I'm happy ! Some of you think that it's normal to have their wesite hosted
    at Astahost since a long time, it seems normal. But it's not so obvious. A lot of free
    webservers were flying around here, who remembers them ? And a lot of them are already dead, just
    try to connect again : MY10GB.COM 1MAJORHOST.COM KINGOFHOSTS.COM 1GB.CC CTRLALTHOST.COM
    FR33HOST.NET HOZTIX.COM 9999mb.com 4thost.us.to They were promissing a lot of things, and
    they are gone, they simply could not survive. Big up, Asta !....
  5. One Of The Most Promising Hosts
    (6)
    Well so far from what I can tell this hosting site seems to be legit. I mean all I have found here
    so far is basically happy customers. Im very interested in getting my free hosting account up and
    runnning. Because if this place is what everyone has said so far then im in heaven .Lol. Well
    because every other so called "Free web host" have adds and spam on your account site. Well im glad
    to be a member here /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0"
    alt="biggrin.gif" /> . -Ghost-....
  6. Leanr How To Give Your Computer A Flush!
    DNS Flush (3)
    This is to quickly flush the DNS catche on your computer via command prompt (cmd-easy search for
    vista users). When you open up cmd make sure you are running it as an administratior and type the
    following in exactly as is!: ipconfig /flushdns You will see right below that (after you pres
    enter after that code) it will say something like it's completed. Now re-start your internet
    browser and delete all internet files cookies etc. etc. and then re-start again. You have now
    flushed your dns cache! Thanks, Mike....
  7. Book Sale For Charity
    Local Associated Bank hosts this book exchange (1)
    This is the first I have seen in my local city and it is ongoing. Most are just drives that have an
    ending, this one doesn't. The way it works is fairly simple really. The bank has a book cart
    and a table in its lobby as people enter through the main entrance. They can browse the books and
    put cash in for whatever they take. The cost is .50 cents for a paperback and $1.00 for a hard
    cover. Of course, if you don't have cash on you...you are at a bank. The exchange part is that
    they welcome donations of any kind of books as well as cash. These book donations....
  8. Apache Virtual Hosts
    (2)
    Hi, i want to use a Apache Web Server as a reverse proxy to a WebLogic Server App Server. How can I
    found information or samples to do this?....
  9. Why Dont A Lot Of Free-hosts Support PHP ?
    (4)
    Wow, i see alot of people DO NOT support php for free webhosting. does anyone know why?....
  10. What Are The Best Image Hosts Out There ?
    (20)
    Does someone know a good imagehost? I have tried photobucket, but it's filled so quick! And
    there isn't much bandwith for you. So, i am looking for a image host with enough space,
    unlimited or much bandwith. AND hotlinking, not that you show a thumbnail orso, just the iamge and
    that's that. Does someone know one? Greetz, Michiel....
  11. Ssh Access + Reload Privilege
    still need to flush hosts (0)
    Thanks for granting me access, m^e. I am in touch with Xisto-Support and they instructed me on how
    to flush the hosts. When I tried it, it didn't work, because I need the "reload-privilege" to
    execute the mysqladmin command. Could I get that too? Regards, Ruben....
  12. Ssh Access Request
    to flush hosts with mysqladmin (1)
    Hello, I would like to have SSH access to my account, so that I can execute the command "mysqladmin
    flush-hosts" that I need to execute in order for my website to work again. Thanks a lot. I would be
    happy too if you executed that command for me. regards, ruben....
  13. I Simply Love The Free Web-hosts And The Internet
    luv em (2)
    I've been with TONS of free web hosts, and most of them suck! I'm kinda picky, because I
    want my site to be cool! but one day i found the perfect host, Pengs, and they were SUPPOSED to
    send me an activation thing, but I'm still waiting...it's been 6 days...then i found THIS
    site! i luv it! THANK GOD FOR THE INTERNET!....
  14. The On Going Free Hosting List
    Post the free hosts you know and tell us (8)
    /biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif' /> Well there is a lot
    of free hosting webistes it the internet and id like to know alot of them . I also want to make a
    list of them here . So lets get started . http://www.hostultra.com - Unlimited Space - Unlimited
    Bandwidth - PHP - FTP - Online Control Panel - 1 Popup http://www.doteasy.com - 10 personalized
    email addresses - FreeSiteDesigner.com website design tool - 100MB of disk space - 1GB/month of data
    transfer - Free support http://www.afmu.com - No Ads, Banners or Pop Ups - 25....
  15. Suggest Free Php Host
    PHP HOsts (17)
    I wish to know if there are any free sites which offer free PHP and My SQL support .If you have any
    links relating to any free PHP and My SQL plans please reply here. I would like to use it for
    hosting a forum I am thinking to use phpbb2 for forum it needs support for PHP and My SQL, I would
    also like to know about what amount would I need for a PHPBB forum. Thank you....
  16. For Those Who Want A Message Board
    Reviews and experiences on forum hosts. (6)
    For Those Who Want A Message Board Reviews and experiences on forum hosts.
    ----------------------------------------------------------------------------------------------- By:
    Andy Lee Created: September 23, 2005 So you want to jump on the bandwagon and create a message
    board, eh? This is an article that details my hilarious adventures on forum hosts. Hopefully, this
    forum hosting guide will help you in your endeavors of running your very own forum-life of solitude.
    Disclaimer: Astahost is not responsible for your choices brought as a result of this guidance.
    Ezb....
  17. At One Point, I Thought All Free Web Hosts Sucked
    And I was an experienced webmaster... (4)
    Honestly, I've been cheated everywhere I went for a free web host. And by cheated, I mean being
    super long URL subdomains, disrespectul and angry staff members, frequent errors and the popular
    "COVER UP THEIR PAGES WITH ADS!!!" But never have I seen such crap than from
    http://www.fortunecity.com . Honestly, I believe that they were messing us up ON PURPOSE just so we
    would pay for a better version. The best free web hosts that I've seen besides Astahost are
    http://www.classicgaming.com - hosted by the GameSpy network http://www.rpgplanet.com - hosted by
    t....
  18. Surf With Less Ads
    windows hosts file (32)
    This is a little trick to surf with less ads. -Step one- Locate the hosts file:
    WinXP/2K =%SYSTEMDRIVE%\%windir%\SYSTEM32\DRIVERS\ETC Win 98\ME =%SYSTEMDRIVE%\%windir%\ There
    you'll see a file called 'hosts' . -Step two- Download the hosts file Now you can add
    hosts to the hosts file or simply download a complete hosts file. The above one is from
    http://www.mvps.org/ and it's a great one. If you want to add a site url, you can do this like
    this: CODE 127.0.0.1 www.domain.com -Step three- Understanding how this works. It fairly
    simple. What....
  19. Error 504 For Computing-hosts And My Website
    (0)
    i am using your sister/brother site computer-hosts as well as here, and have a strange problem! as
    far as know nothing has changed, but today i cannot access either my website or computer-hosts and
    get the following message with both. Any ideas? everythiing else on the internet works except my
    website and computer hosts page. Bit strange really. Is it the Avast virus checker? any ideas??
    remedies???? thanks chris The page cannot be displayed There is a problem with the page you are
    trying to reach and it cannot be displayed. Please try the following: * Click t....

    1. Looking for flush, hosts






*SIMILAR VIDEOS*
Searching Video's for flush, hosts
advertisement




Flush Hosts - can i do that? where?



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE