Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter bluethundr

    (@bluethundr)

    whoa!! no replies in a couple weeks? Just because my site is a little weird? LOL

    Thread Starter bluethundr

    (@bluethundr)

    Does anyone have any ideas? Been 5 days since my last post.

    Thanks

    Thread Starter bluethundr

    (@bluethundr)

    Hi,

    The site is here:

    http://dev.jokefire.com/

    And the back end that I’m trying to get to work is here:

    http://dev.jokefire.com/wp-admin

    Thanks,
    Tim

    Thread Starter bluethundr

    (@bluethundr)

    Also, I’ve upgraded to the latest version (4.6.1) with no change in result. The error remains.

    Thanks

    Thread Starter bluethundr

    (@bluethundr)

    I actually made some progress on this. The problem was SSL. Once I I took the SSL requirement out of the picture for the user everything worked. The test php script and the wordpress site both. I stumbled getting the mediawiki to connect via SSL. Once I found the setting $wgDBssl = true; for media wiki it just worked.

    For my wordpress site, I found the setting define(‘DB_SSL’, true);. I set that up in wp-config.php. However for some reason that wasn’t the silver bullet that the mediawiki SSL database setting was ( $wgDBssl = true; ). I can understand why my little test script couldn’t work with an SSL user. But do you have any idea why that wordpress setting won’t allow the site to connect to the DB?

    Thread Starter bluethundr

    (@bluethundr)

    Also, I created a basic php script to see if it could connect to the database

    <?php
    $link = mysql_connect('db.example.com', 'admin_ssl', 'secret');
    if (!$link) {
    die('Could not connect: ' . mysql_error());
    }
    echo 'Connected successfully';
    mysql_close($link);
    ?>

    And to my surprise it can’t connect!

    php testconnect.php
    Could not connect: Access denied for user 'admin_ssl'@'ec2-54-86-143-49.compute-1.amazonaws.com' (using password: YES)

    Why am I surprised that it can’t? Because again 1) the wiki can connect to the database no problem. And 2) I can connect to the db on the command line using the same credentials:

    #mysql -uadmin_ssl -p$DB_PASS -h db.example.com -e "use jokefire; show tables" | head -5
    Tables_in_jokefire
    wp_bp_activity
    wp_bp_activity_meta
    wp_bp_chat_channel_users
    wp_bp_chat_channels

    My API Client version is:

    Client API version mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $

    Hope this helps narrow down the problem. Thanks!

Viewing 6 replies - 1 through 6 (of 6 total)