Hosting Revive Database in a different server from the Application

[Maki]

I have been using revive ads server for over 2 years now and I use a MySQL database within the same server I host the revive application. Now the database is overloaded and I have successfully migrated the huge data to a more scalable database server which is different from where I host the files. I have tried to input all the details of the new database server on my '/var/domain.conf.php' file but I keep getting error connecting page once I reload the page.

How best can one edit the below with new database details. 

New database details (Database name: db-XXXXXXXXXXXX.a.db.ondigitalocean.com, Port: 25060, SSLmode: Required. I have a CA Certificate for the server as well)

[database]
type=mysqli
host=localhost
socket=
port=3306
username=****
password=*******
name=*****
persistent=
mysql4_compatibility=1
protocol=tcp
compress=
ssl=
capath=
ca=

[andrewatfornax]

11 hours ago, Maki said:

 I keep getting error connecting page once I reload the page.

... and what is that error?

[Maki]

6 hours ago, andrewatfornax said:

... and what is that error?

See screenshot below.

 

[andrewatfornax]

"PHP has not loaded the mysqli extension" - is that the one?

[Maki]

14 hours ago, andrewatfornax said:

"PHP has not loaded the mysqli extension" - is that the one?

I don't think that is the error because I have been using mysqli extension even in the old database.

 

What I need now is how to edit the database config file to connect to a database which is outside the application server because I tried connecting to a new database which is hosted separately and I got the above error page.

[andrewatfornax]

5 hours ago, Maki said:

I don't think that is the error

@Maki, mate, really?

There error is right there on the page, telling you what the software is having an issue with.

It might not make sense, but please, go back, take another look, and confirm your setup.