[Solved] Error 1129 Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

X`Ray · May 30, 2010

Hi there,

Can't connect to mysql database!
Error 1129 Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

I got a problem with my ajax chat prototype, it tells me that my host were blocked because of 2 many mysql requests, so i tell you first how it works:

You see every 30 and 10 seconds two javascript functions will be loaded by the page

var x = window.setInterval("loadChat()", 30000);
var x = window.setInterval("onlineChat()", 10000);

The 3 functions collect some information needed for the query by this page.

There is a 3rd function which does this, its triggered by the send button.

function loadChat() {
    id = document.getElementById("id").value;
    XMLqueryA('displaybox','chat.display.php','?id='+id);
}

function onlineChat() {
    XMLqueryB('onlinebox','chat.online.php','');
}

function writeChat() {
    id = document.getElementById("id").value;
    pass = document.getElementById("pass").value;
    text = document.getElementById("text").value;

    XMLquery('info','chat.write.php','?id='+id+'&pass='+pass+'&text='+text);

    document.getElementById("text").value = "";
    XMLqueryA('displaybox','chat.display.php','?id='+id);
}

Thats the example for one xmlhttprequest, so it starts to load a page and the responed text will set into the html page. The sql queries are:

function loadChat();
1. get the last 10 entries
2. update user last change of the current user

function onlineChat();
1. get all users, sort them by last change, and color them by the time difference

function writeChat();
1.check if user and password match
2.insert the text, the current time and the userid

try {
    // Mozilla, Opera, Safari sowie Internet Explorer (ab v7)
    xmlHttp = new XMLHttpRequest();
} catch(e) {
     try {
            // MS Internet Explorer (ab v6)
             xmlHttp  = new ActiveXObject("Microsoft.XMLHTTP");
    } catch(e) {
        try {
            // MS Internet Explorer (ab v5)
            xmlHttp  = new ActiveXObject("Msxml2.XMLHTTP");
        } catch(e) {
            xmlHttp  = null;
        }
    }
}

function XMLquery(target, source, parameters) {
    if(xmlHttp) {
        xmlHttp.open('GET', 'layout/'+source+parameters, true);
        xmlHttp.onreadystatechange = function () {
            if (xmlHttp.readyState == 4) {
                  document.getElementById(target).innerHTML = xmlHttp.responseText;
            }
        };
        xmlHttp.send(null);
    }
}

So that means, there are 12 automatically sql request per user in one minute, and at the moment there are only 1 up to 2 users.

At my point of view, thats not a big amount of sql requests. So is there a possible solution to avoid this error message and to use this page unchanged?

If its not possible from your side, I'm willing to lower the refresh rate, but please unlock my host. I need that for a project at school and personal learning studies.

Thanks,

X`Ray

Wizard · May 30, 2010

This support request is being escalated to our root admin.

X`Ray · May 30, 2010

I see thats not only the many connections its about some errors, the script worked since the 24.05 and i only get 1 error back, that was while trying to write with another id or an wrong password.

It could be that i didn't rechange the userid and the password didn't matched. But the thing is, you can see the only one check of the userid and password is when i wrote a message, which will activate by clicking a button and i didn't do that. Then the loadchat only need a id to update the last change, so the fake id i used existed in the database and it doesn't displayed me an error either, so i think we can ignore this too. The onlinechat() function only requests the users and don't need any id or password. So i think there is another problem.

If you want you can take a look at the sources in the backup file. The 3 chat scripts are placed with the suffix "chat." in the layout folder.

Please Note, that are only prototypes, so they are not documented nor written in a good coding guideline.

Ashoat · May 30, 2010

Unfortunately, I don't have time to read your code. I've flushed the blocked host list. However, you didn't get blocked in the first place for too many MySQL requests; you got blocked for too many MySQL errors.

Try to see if you can figure out what the issue is.

X`Ray · May 30, 2010

ok, i have added to all the queries a mysql error logging to file,

so all 10 seconds i can see the last mysql error in a file.

so if there are any problems, we will see.

And thanks for flushing

<?php 
require_once("FileAdapter.php");
?>

<?php
class Logging {
    private $myFile;
    private $arr = array();
    
    public function __construct($file) {
        $this->file = $file;
        $this->myFile = new base_FileAdapter($file);
    }
    
    public function log($no,$error,$ip) {
        if($no != 0) {
            echo("Error({$no})");
            array_push($this->arr, $ip . " <" . date("Y-m-d, g:i:s a") . "> MySQLerror(" . $no . "): " . $error);
        }
    }

    public function write() {
        if (count($this->arr) > 0) {
            $this->myFile->appendFile($this->arr);
        }
        $this->myFile->closeFile();
    }
}

Ashoat · June 1, 2010

No problem

X`Ray · June 2, 2010

Ok, i have improved the script and removed all "or die()" requests. so it will save all errors and at least only run without mysql error. So i can catch now all errors

Die momentane Liste sieht so aus:

79.xxx.xxx.xxx <2010-06-01, 8:51:35 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 8:51:35 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 9:17:00 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 9:17:00 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 9:26:10 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 9:26:10 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 9:32:30 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 9:32:30 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 9:33:00 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 9:33:00 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 9:36:11 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-01, 9:36:11 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-01, 9:50:40 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 9:50:40 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 10:19:20 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-01, 10:19:20 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-01, 10:30:13 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-01, 10:30:13 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-01, 10:40:10 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 10:40:10 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 10:41:40 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 10:41:40 pm> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-01, 10:59:30 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-01, 10:59:30 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-01, 11:28:20 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-01, 11:28:20 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 12:11:50 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 12:11:50 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 1:09:36 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 1:09:36 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 2:39:36 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 2:39:36 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 2:45:40 am> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 2:45:40 am> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 3:25:36 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:25:36 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:25:46 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:25:46 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:25:56 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:25:56 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:06 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:06 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:06 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:06 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:16 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:16 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:26 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:26 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:36 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:36 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:36 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 3:26:36 am> MySQLerror(2003): Can't connect to MySQL server on '***************.heliohost.org' (4)
79.xxx.xxx.xxx <2010-06-02, 1:30:39 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:30:39 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:30:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:30:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:30:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:30:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:30:59 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:30:59 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:51:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:51:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:51:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:51:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:52:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:52:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:52:39 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:52:39 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:52:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:52:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:52:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:52:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:52:59 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:52:59 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:54:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:54:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:54:39 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:54:39 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:54:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:54:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:54:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:54:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:54:59 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:54:59 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:55:09 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:55:09 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:55:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:55:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:55:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:55:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:55:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:55:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:55:59 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:55:59 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:56:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:56:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:56:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 1:56:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 3:30:09 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:09 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:10 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:10 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:19 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:19 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:29 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:29 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:40 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:40 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:42 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:42 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:49 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:49 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:59 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:30:59 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:31:09 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:31:09 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:31:09 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:31:09 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:31:19 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:31:19 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:31:29 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:31:29 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:31:39 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:31:39 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:31:41 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:31:41 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:31:49 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:31:49 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:31:59 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:31:59 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:32:09 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:32:09 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:32:09 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:32:09 pm> MySQLerror(1040): Too many connections
79.xxx.xxx.xxx <2010-06-02, 3:32:19 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:32:19 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:32:41 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:32:41 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 3:49:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 3:49:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 3:49:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 3:49:49 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 3:50:39 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 3:50:39 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0

i hope that helps

//Edit:

79.xxx.xxx.xxx <2010-06-02, 3:31:19 pm> MySQLerror(1040): Too many connections

Could it be that no using of mysql_close() cause this error, im a real idiot. I didn't noticed that

I edit that an then we could look forward.

X`Ray · June 2, 2010

Ok, finally it is at the same point like the last time . so i please you again to flush me, thank u.

I definitly added this at the end of all files at 4:33pm:

<?
    mysql_close($link);
    $log->log(mysql_errno(),mysql_error(),getenv('REMOTE_ADDR'));
    $log->write();
?>

I got a theoretic about this cause:

The first script interval is 10 seconds and the second script interval is 30 seconds, so there will be 2 connections at all 30 seconds, that could be a problem if there are only 1 connection allowed, but I see this problem doesn't cause every 30 seconds, take a look at the log. If that is the problem, I have to add a delay at one of the two scripts.

Otherwise mysql says there could be other serverside problems, see this link:

http://dev.mysql.com/doc/refman/5.1/en/err...connection.html

I' m sure there could be other problems

79.xxx.xxx.xxx <2010-06-02, 10:04:18 pm> MySQLerror(1129): Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
79.xxx.xxx.xxx <2010-06-02, 10:04:27 pm> MySQLerror(1129): Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

79.xxx.xxx.xxx <2010-06-02, 4:57:49 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:57:49 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:57:49 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:57:59 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:57:59 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:57:59 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:10 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:10 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:10 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:10 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:10 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:10 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:19 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:19 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:19 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:30 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:30 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:30 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:39 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:39 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:39 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:40 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:40 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 4:58:40 pm> MySQLerror(1203): User xray_****** already has more than 'max_user_connections' active connections
79.xxx.xxx.xxx <2010-06-02, 5:17:50 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:17:50 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:17:50 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:17:50 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:17:50 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:17:50 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:35:31 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:35:31 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:35:31 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:36:59 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:37:00 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:37:00 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:49:30 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:49:30 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:49:30 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:51:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:51:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:51:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:52:00 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:52:00 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 5:52:00 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 6:53:06 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 6:53:06 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 6:53:06 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 6:53:15 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 6:53:15 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 6:53:15 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 6:53:15 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 6:53:15 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 6:53:15 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 7:14:55 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 7:14:55 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 7:14:55 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 7:15:06 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 7:15:06 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 7:15:06 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 7:19:06 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 104
79.xxx.xxx.xxx <2010-06-02, 7:19:06 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 104
79.xxx.xxx.xxx <2010-06-02, 7:19:06 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 104
79.xxx.xxx.xxx <2010-06-02, 8:30:08 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:30:08 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:30:08 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:30:40 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:30:40 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:30:40 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:30:48 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:30:48 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:30:48 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:08 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:08 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:08 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:13 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:13 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:13 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:21 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:21 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:21 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:33 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:33 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:33 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:38 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:38 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:31:38 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:04 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:04 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:04 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:07 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:07 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:07 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:17 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:17 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:17 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:24 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:24 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:24 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:28 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:28 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:32:28 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:20 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:20 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:20 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:31 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:31 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:31 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:48 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:48 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:48 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:54 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:54 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:54 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:58 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:58 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:33:58 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:08 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:08 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:08 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:14 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:14 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:14 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:19 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:29 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:35 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:35 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:35 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:38 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:38 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:38 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:48 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:48 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:48 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:55 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:55 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:55 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:57 pm> MySQLerror(1129): Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
79.xxx.xxx.xxx <2010-06-02, 8:34:57 pm> MySQLerror(1129): Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
79.xxx.xxx.xxx <2010-06-02, 8:34:57 pm> MySQLerror(1129): Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
79.xxx.xxx.xxx <2010-06-02, 8:34:58 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:58 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:34:58 pm> MySQLerror(2013): Lost connection to MySQL server at 'reading authorization packet', system error: 0
79.xxx.xxx.xxx <2010-06-02, 8:35:04 pm> MySQLerror(1129): Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
79.xxx.xxx.xxx <2010-06-02, 8:35:04 pm> MySQLerror(1129): Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
79.xxx.xxx.xxx <2010-06-02, 8:35:04 pm> MySQLerror(1129): Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
...

At this point the last error appears again and again.

Ashoat · June 2, 2010

I don't speak, read, or understand German (or whatever language that is). This is an English-language forum.

X`Ray · June 2, 2010

I have edited the post, so i hope its good enough English to read is.

and sorry about the German posts

Ashoat · June 3, 2010

Flushed hosts again...

Are you sure you're providing the right credentials every time you log in?

X`Ray · June 3, 2010

    @$link = mysql_connect("webshard.heliohost.org","xray_root","*************");
    $log->log(mysql_errno(),mysql_error(),getenv('REMOTE_ADDR'));
    @mysql_select_db("xray_schule",$link);
    $log->log(mysql_errno(),mysql_error(),getenv('REMOTE_ADDR'));

yeah I'm sure thats right, i use this above to connect to server in every script which needs a database connection.

The thing is, if you take a look at the last log, the errors didn't follow any regular repeats. I can tell you i was always online on this site, so that means the automatically loading works just fine, every 10 seconds 2 requests and every 30 seconds 4 requests with a maximum of 2 connections.

I think the errors are detailed enough to take a look in google, the problem is I doesn't know the server enough to make any references, what the cause could be. but i think another one should test the same scenario and another like this, because it seem that no one have the same problems with the sql connection? Thats another interesting thing.

If this problem would be everyones problem, i think there are further possibilities to resolve this.

Any other ideas?

P.S. I will put the chat on ice till there is a solution or an idea whats the cause of this problem. I'm at the point to give it up.

//Edit, i got another idea:

There is a possibility that netcup.de got problems during the remote connect from therse host to yours. So i think i should test this script now on your webserver. let us see what happens. If its just all fine within the next week, i think there is a problem with the remote host or the connection between this 2 hosts.

Isn't that an idea?

//Edit:

Ok, i changed "webshard.heliohost.org" to "localhost" and it works.

Ashoat · June 3, 2010

Sorry, but I'm not performing any code reviews for you.

Hope it works out!

[Solved] Error 1129 Host 'w5205.netcup.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites