Support » Plugin: Secure DB Connection » WP-Config.php Variable Defs as compared to mysql command line args

  • Resolved michaelscotthoward

    (@michaelscotthoward)


    I can connect to my mysql & maria instances (yes either or) via CLIENT SSL CERTS: –ssl-ca=~../../myca.ca.pem –ssl-cert=client-cert.pem –ssl-key=client-key.pem (other commandline ARGs too naturally). I’ve set the wp-config.php but, it does not work…

    SO I KNOW SSL WORKS via mysql>status;
    8<— SNIP —>8
    SSL: Cipher in use is DHE-RSA-AES256-GCM-SHA384
    8<— SNIP —>8

    /** MYSQL_SSL_KEY [default: not set] */

    define(‘MYSQL_SSL_KEY’,’/FULLPATH/…client-key.pem’);

    /**The path name to the key file. (RSA Key) */

    /** MYSQL_SSL_CERT [default: not set] */

    define(‘MYSQL_SSL_CERT’,’/FULLPATH/…client-cert.pem’);

    /** The path name to the certificate file. */

    /** MYSQL_SSL_CA [default: not set] */

    define(‘MYSQL_SSL_CA’,ca.pem’);

    /** The path name to the certificate authority file. */

    /** MYSQL_SSL_CA_PATH [default: not set] */

    define(‘MYSQL_SSL_CA_PATH’,”/FULLPATH/CA/…’);

Viewing 2 replies - 1 through 2 (of 2 total)
  • AH, my problem was ORDER of the above defines!

    I moved then just after:

    define(‘DB_HOST’, ‘MYSQL_HOST:MYPORT,’);

    /** Stab at SSL */

    and BINGO! worked
    and worked with MARIADB version 10..

    Many thanks!

    Plugin Author hypertextranch

    (@hypertextranch)

    Glad to hear it worked, I’ve also updated the readme to make the options a bit clearer.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WP-Config.php Variable Defs as compared to mysql command line args’ is closed to new replies.