Cannot Activate

  • Hi support, I have just installed rootspersona and tried to activate it. The activation fails with the following:
    Warning: mysqli::__construct(): (HY000/2002): Connection refused in /volume1/web/wordpress/wp-content/plugins/rootspersona/php/dao/sql/class-RP-Connection-Factory.php on line 16 Connect Error (2002) Connection refused

    My server is my own Synology NAS, WordPress is using PHP 7.3 and MariaDB 10.

    From the 2012 video by Ed, rootspersona looks like what I’m after.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter grahamh63

    (@grahamh63)

    Bump
    Anything?

    Plugin Author ed4becky

    (@ed4becky)

    Sorry, I thought I had responded from my email account.

    Rootspersona needs the database connection broken up into host and port. A lot of current configurations combine them.

    Check your wp-config.php file

    This will be fixed in a future version.

    Thread Starter grahamh63

    (@grahamh63)

    Thanks Ed,

    This is what it was:
    /** MySQL hostname */
    define( ‘DB_HOST’, ‘localhost:/run/mysqld/mysqld10.sock’ );

    This is what I changed it to:
    /** MySQL hostname */
    define( ‘DB_HOST’, ‘localhost:3307’ );

    Now I get an “Error establishing a database connection” error trying to load WordPress.

    I’m not technical enough for this problem, but I did check phpMyAdmin and there are no rootspersona talbes there.

    Next step?

    Thread Starter grahamh63

    (@grahamh63)

    Hi Ed, is there nothing I can do to get the rootspersona plugin working?

    Plugin Author ed4becky

    (@ed4becky)

    do you define the host and port as a single variable? the current version expects them as separate variables

    Thread Starter grahamh63

    (@grahamh63)

    Not sure, this is what it is in the wp-config.php file:

    /** MySQL hostname */
    define( ‘DB_HOST’, ‘localhost:/run/mysqld/mysqld10.sock’ );

    The way I read that is a single variable – ‘localhost:/run/mysqld/mysqld10.sock’
    “localhost” – for the host, and
    “/run/mysqld/mysqld10.sock” for the port

    But as I say, I’m not technical enough in this area.

    Plugin Author ed4becky

    (@ed4becky)

    OK, red herring, the HOST and PORT do NOT have to be split up anymore.

    I’ve not seen /run/mysqld/mysqld10.sock as a port before…

    This should have worked: define( ‘DB_HOST’, ‘localhost:3307’ );

    Unless the port on your database instance is NOT 3307

    Try: 127.0.0.1:3307

    Thread Starter grahamh63

    (@grahamh63)

    Thanks Ed,

    I decided to go with the Gedshow plugin. It installed first time and activated straight away.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Cannot Activate’ is closed to new replies.