webinoly -verify [Error] Database conection failed.

Question

Hi!

I'm getting this error in webinoly -verify

External DB credentials found!
============================================
    [Error]  Database conection failed.
============================================

Everything works fine, WordPress and phpmyadmin can connect to the external server without problems. In the Webinoly config file, I'm using the same user, password, host, and port that wordpress uses in config.php.

So I don't know what could be the cause for webinoly not being able to connect to the DB.

Best regards.

Comments

Ok. If everything is working fine, so there's nothing to worry about. Maybe it's just a bug.

Can you tell us how you are entering your DB credentials? Are these credentials saved in the Webinoly conf file or you entered them via the command line?

Can you please run this command using the site (example.com) that is connected to this external DB: sudo site example.com -info

Let me know if it fails!

---

This is the info of my site:

Type: WordPress
Status: Enabled
SSL: Let's Encrypt
Access Logs: false
Force Redirect: off
Size: 3.8G
External DB credentials found!
External DB credentials found!
Site XXXX.XXX is the main site in a WP Multisite Network!

Cache: true
Multisite: subdirectory
WP Auth: true
Debug: true

Database: 172.16.XX.XXX:3306
DB Name: wordpress
DB User: XXXXXX
DB Prefix: wp_
Blog ID: 1

I put in the database credentials by manually editing the Webinoly config file:

# Saved External DB Credentials to use instead of localhost
# Values: <access-data>
# Default: <empty>
# Note: (server-reset not needed)
# Note: https://webinoly.com/documentation/sites/#externaldb
###########################
external-dbh:172.16.XX.XXX
external-dbx:3306
external-dbu:XXXXXXX user
external-dbp:XXXXXXX pass

---

So, it's failing only when "verify" and not with "info". That's weird!

Can you please paste here the complete output of the "verify" command?

---

Verifying integrity of the entire Webinoly system...
(1) Webinoly Integrity Test successful!
(2) NGINX Verification Test successful!
(3) PHP Verification Test successful!
(4) MySQL Verification Test successful!
(5) Service Status Verification Test successful!
(6) Operating System Verification Test successful!
(7) Additional Tools Verification Test successful!
(8) Permissions Verification Test successful!
External DB credentials found!
============================================
    [Error]  Database conection failed.
============================================

(9) Sites Verification Test successful!

Integrity test successfully passed!!!

---

Ok. Thanks!

At first sight, it seems it could be a bug introduced in our last release. I was moving some code related to how we check the MySQL connection.

Next week I will try to reproduce this issue and I will keep you posted here.

Thanks!

---

Sorry, I can't reproduce this issue!

I tried different cases with no success, all of them using external DB:

• If no credentials are saved in config file, then when verify is running it prompts and asks for the credentials.
• If credentials are saved, then it runs as expected.
• If wrong credentials are saved, the error is displayed and then it prompts and asks to enter the credentials.

So I was not able to reproduce the behavior you are describing. If you can debug it and provide more details will be very helpful.

Regards.