Plugin not connecting to db -Confirmed Logins work

  • Resolved masterfugazi

    (@masterfugazi)


    3 years, 10 months ago

    Hello,

    I’m trying to use your plugin but not matter what login creds I provide the plugin doesn’t connect to the db, I’ve been able to login with the same creds using MySQL Workbench, and connect to the db via ssh, but when I enter them into the plugin it doesn’t connect, I’ve also whitelisted my IP, and my server IP address, any info you could provide for troubleshooting this would be greatly appreciated.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Kerfred

    (@kerfred)

    If Magento and WordPress are not installed on the same host, you can do this:

    • export the Magento database to a SQL file (with phpMyAdmin for example)
    • import this SQL file on the same database as WordPress
    • run the migration by using WordPress database credentials (host, user, password, database) instead of the Magento ones in the plugin settings. You can find the WordPress credentials in the wp-config.php file.
    Thread Starter masterfugazi

    (@masterfugazi)

    That was quick, thanks for the prompt reply!

    Do they 100% have to be in the same database? -What about if both dbs are on the same server but separate databases? -The Magento db file is sooo big, would hate to do that but I guess I have no choice.

    Plugin Author Kerfred

    (@kerfred)

    It also works if the database is not the same but on the same server as the WordPress database.

    Thread Starter masterfugazi

    (@masterfugazi)

    Well, that’s where I’m at but no matter what I do it doesn’t work…

    Is the “Magento table prefix” field required for the plugin to connect?

    -Trying the initial recommendation again.

    Does the plugin have any caching or need to be refreshed at all?

    Plugin Author Kerfred

    (@kerfred)

    No caching.
    The Magento prefix may be empty.
    Which message do you get exactly in the log?

    Thread Starter masterfugazi

    (@masterfugazi)

    `=== START test_database 2021-05-28 13:19:40 ===
    [ERROR] Couldn’t connect to the Magento database. Please check your parameters. And be sure the WordPress server can access the Magento database.

    SQLSTATE[HY000] [1045] Access denied for user ‘ussaws_db’@’localhost’ (using password: YES)’

    Here’s the latest error log I get, but I’m not sure how I would get this if my IP has been whitelisted…and it’s the same creds the site uses.

    Plugin Author Kerfred

    (@kerfred)

    Are both the Magento and the WordPress databases on the same server?
    If yes, please double check the hostname, user and password.
    This error message says that either the hostname or user or password is wrong.

    Thread Starter masterfugazi

    (@masterfugazi)

    Good news, I was able to get a successful connection, after I imported the Magento db into the same db as my WP site. -When I tried this before it didn’t seem to work, thanks for being responsive, super helpful! -I think we’re going to end up needing the pro version so it’s good to know you guys are on the ball with responding!

    • This reply was modified 3 years, 10 months ago by masterfugazi.
    Plugin Author Kerfred

    (@kerfred)

    Great. Good news.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Plugin not connecting to db -Confirmed Logins work’ is closed to new replies.