• Resolved pointpubmedia

    (@pointpubmedia)


    Hello,

    When using hyperdb, we got a lot of

    Oct  5 13:57:59 vMariaDB01 mariadbd[1770838]: 2022-10-05 13:57:59 3683932 [Warning] Aborted connection 3683932 to db: 'unconnected' user: 'unauthenticated' host: 'x.x.x.x' (Got an error reading communication packets)
    Oct  5 13:57:59 vMariaDB01 mariadbd[1770838]: 2022-10-05 13:57:59 3683932 [Warning] Aborted connection 3683932 to db: 'unconnected' user: 'unauthenticated' host: 'x.x.x.x' (This connection closed normally without authentication)
    Oct  5 13:58:00 vMariaDB01 mariadbd[1770838]: 2022-10-05 13:58:00 3683936 [Warning] Aborted connection 3683936 to db: 'unconnected' user: 'unauthenticated' host: 'x.x.x.x' (Got an error reading communication packets)
    Oct  5 13:58:00 vMariaDB01 mariadbd[1770838]: 2022-10-05 13:58:00 3683936 [Warning] Aborted connection 3683936 to db: 'unconnected' user: 'unauthenticated' host: 'x.x.x.x' (This connection closed normally without authentication)
    Oct  5 13:58:12 vMariaDB01 mariadbd[1770838]: 2022-10-05 13:58:12 3683974 [Warning] Aborted connection 3683974 to db: 'unconnected' user: 'unauthenticated' host: 'x.x.x.x' (Got an error reading communication packets)
    Oct  5 13:58:12 vMariaDB01 mariadbd[1770838]: 2022-10-05 13:58:12 3683974 [Warning] Aborted connection 3683974 to db: 'unconnected' user: 'unauthenticated' host: 'x.x.x.x' (This connection closed normally without authentication)
    Oct  5 13:58:12 vMariaDB01 mariadbd[1770838]: 2022-10-05 13:58:12 3683977 [Warning] Aborted connection 3683977 to db: 'unconnected' user: 'unauthenticated' host: 'x.x.x.x' (Got an error reading communication packets)
    Oct  5 13:58:12 vMariaDB01 mariadbd[1770838]: 2022-10-05 13:58:12 3683977 [Warning] Aborted connection 3683977 to db: 'unconnected' user: 'unauthenticated' host: 'x.x.x.x' (This connection closed normally without authentication)

    Using this config:

    <?php
    /**
     * Register the primary server to HyperDB
     */
    
    $wpdb->add_database( array(
            'host'     => DB_HOST,
            'user'     => DB_USER,
            'password' => DB_PASSWORD,
            'name'     => DB_NAME,
            'write'    => 1, // primary server takes write queries
            'read'     => 1, // ... and read queries
    ) );
    
    /**
     * Register replica database server if it's available in this environment
     */
    
    $wpdb->add_database(array(
            'host'     => DB_HOST . ':' . '3307',
            'user'     => DB_USER,
            'password' => DB_PASSWORD,
            'name'     => DB_NAME,
            'write'    => 0, // replica doesn't take write queries
            'read'     => 1, // ... but it does take read queries
    ));
    
    // That's it!

    Maybe our config is missing something…

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘db: ‘unconnected’’ is closed to new replies.