Connect to database

Hi Emma,

Is your remote connection listed on the settings page? Please follow these steps to check:
– Click on the Settings menu
– Click menu item WP Data Access
– Check item remote database connections

Best regards,
Peter

Hi Emma,

I did some further research on this topic and it looks like there is bug.

When you start entering a new remote database connection, column “Database name” show the prefix “rdb:”. You need to add a name after this prefix, for example “rdb:my_remote_database”. The remote connection will be stored as “rdb:my_remote_database”. If you leave column “Database name” exmpty, the remote database is not stored. I will fixed this issue in the next release.

Please let me know if this helps.

Best regards,
Peter

I have the same issue. Connect test passes however, even if I populate the database name and click on Save, the remote database does not get added to the database pulldown.

Preparing connection…
Establishing connection…
Connection established…
Counting tables…
Found 43 tables on remote host…

Remote database connection valid

Hi earcilla,

What happens when you press the save button? Is the page refreshed? Do you get an error? Do you get more info if you turn on WordPress debug mode?

I have a number of installations but I cannot reproduce the error, so I need as much detailed information as you can supply. Thanks!

Best regards,
Peter

Hi,

I uploaded a patch which I hope solves the problem. You need to delete the plugin and then reinstall it.

If you have stored any projects, publications, settings, etc, make sure you’re not losing your work! Before you delete the plugin:
– Go to the Settings menu
– Click submenu WP Data Access
– Click tab Uninstall
– Uncheck both checkboxes

Please let me know if this solves the issue. Thanks!

Best regards,
Peter

Hello Peter,

I just uninstalled and reinstalled the plugging. The problem is solved, I added my database without problem.

Thank you very much for the quick solution. It’s very much appreciated !

Best regards ??

Thank you for your reply Emma! ?? Good to hear it works!

Best regards,
Peter

Hello Peter,

First of all, thank you for developing the WP Table Access plugin.
It was exact what I was looking for.

I faced a problem to connect a remote mysql database.
The plugin shows:
Found 46 tables on remote host… (what is correct!)
Remote database connection valid

But by “Save” it gives a failure:

Oncaught Error: Call to undefined function WPDataAccess\Connection\openssl_encrypt() in /usr/local/www/apache24/data/xxxxxx/wp-content/plugins/wp-data-access/WPDataAccess/Connection/WPDADB.php:61 Stack trace: #0
WPDADB.php(107)
WPDADB.php(165)
(xxxxxx = WP name on our FreeBSD server)

Seems to have missing keys? Maybe the “Secret key and IV”?
Could not find any info about this. Any clue how to solve this?

Best regards,
Andre van Amerongen (Groningen ?? )

Hi Andre,

I guess you are connecting to your WordPress database through SSL? Is that correct?

The plugin uses the WordPress wpdb class. If you connect through SSL, you need to have a key for every host. The WordPress wpdb class uses one globally defined key for all connections. Knew this was comming! ?? Have to find a solution for this issue…

Best regards,
Peter (Arnhem ??)

Hi Peter,

Thx for the quick response. Actually the WP version is installed on the same IP address as the mysql-server. So internal I don’t use SSL.

External the WP version use https connections with valid SSL keys handled and updated by “letsencrypt”.

Anyway seems that you are pointing to which location I have to look. I will search and if I find a workaround I will let you know.
For sure more people will face the same issue.

Best regards,
Andre

Ps. an impressive plugin what seems to be well developed!!

Hi Peter,

Found the problem and hereby the solution for other users.

“OpenSSL support” was disabled. Check https://www.yourwebsite.com/index.php
index.php file:
<?php
phpinfo();
?>

For FreeBSD users, this is the solution:
/usr/ports/security/php72-openssl make install clean

service apache24 restart

Problem solved!

For LINUX users probably comparable

Best regards,
Andre

Hi Andre,

Great you solved it! ??

Thank you very much for sharing it. I added a link to your message on the plugin website. Hope this helps other users as well.

Have a nice weekend!

Best regards,
Peter