InvoicePlane configure database install cannot connect

Hi Guys so I read and read and read… I am lost without a paddle. I had a server and lost all my data all my invoices everything… So I got a new server, and installing this for the first time on it. I was able to get through setup… and the part where I cannot get past is (Failure
Cannot connect to the database server with the provided database information. Please check the credentials and try again. )

hostname: localhost
port: 3306
username: invoicead
password: damnimdumb
database: invoicepl

cannot get this to go through no matter what. in phpmyadmin there is a user called invoicead (global priveleges set to all in myphpadmin) and there is also a blank db created called invoicepl.

running apache http server 2.4
php 5.6
myphpadmin 4.66

Any ideas why its not connecting?. Much appreciated…

Please check if other apps like wordpress can connect to your database server. If not, it’s the database server or the credentials.

I think I might have found out what is causing the issue however im not sure if there is a way to make it work… so for some reason synology made myphpadmin dependant on mariadb 10. Now I had both 5 and 10 installed because on the new server it first said it wanted version 5. then i loaded 10 trying to be all cool and hip. I some how remembered maybe they are conflicting since its a fork of mysql… it kind of explains why i cant find the damn httpd or anything to do with mysql. so now i removed all the packages myphpadmin and mariadb 10 and 5… now when i want to install myphpadmin its stating it wants mariadb 10 as the dependency not 5 from before…I have an odd feeling everything will work with version 5 if i can get myphpadmin to use that instead of 10… :frowning: so bummed i really used this software for some time now… being serverless sucks!!! and anything webserver related does not work i cant install any other web related script or server. invoiceplane invoice pro crm etc… :frowning: i thought it was my stupidity surfacing but now i realize its this mariadb handicapping me from being able to do anything…

Oke, strange story you have (and hard to read :stuck_out_tongue:)

Anyway, there shouldn’t be any significant difference between MySQL 5 and MariaDB10, they both work the same.
MariaDB has some extra functionality, but the basic MySQL functions work the same, especially the ones IP is using.

Maybe your MariaDB settings are wrong? Or your user permissions aren’t copied to MariaDB, causing the install to fail?

hi, see thats the thing by default mariadb is broken because there is 2 versions and its forcing 10 to be default. Nothing sees mysql. I dont know what I can do to make mysql visable or mariadb to work with other services.

in my case, i have to replace ‘localhost’ with loopback ip ‘’

Hey. Im having the same problem as him but i can connect to my remote Db. Invoiceplane Just wont let me.

Recent versions of mysql do not let you connect by default from external sources (localhost - is the default.

You need to configure mysql to allow connections from outside the server. To do this you will have to edit your mysql server configuration file and bind the external address to the server, then restart the server. Your database administrator should be able to assist with this.

1 Like

I had an issue when migrating from MariaDB5 to MariaDB10 which is similar to the OP problem.
So this reply is for anyone who might be struggling with this.

Using Invoiceplane and MariaDB on a Synology (no Docker involved here), I solved the issue when migrating from MariaDB5 to MariaDB10 (since Synology DSM7 only supports MariaDB10). The post from crafter got me on my way.

  • install MariaDB10
  • export the databases from MariaDB5 and import them in MariaDB10 (can be easily done in Phpmyadmin)
  • stop and uninstall the MariaDB5 package (keep the databases, just in case)
  • SSH into your Synology: ssh <username>@<IP> -p <port_if_different_than_22>
  • Go to the MariaDB10 config folder: cd /var/packages/MariaDB10/etc
  • Temporary change permissions: sudo chmod 777 synology.cnf
  • Edit: vi synology.cnf
  • Change to the following:
  • Change the permissions back: sudo chmod 644 synology.cnf
  • Restart mariaDB package

Make sure the port of MariaDB10 is the same as the MariaDB port you configured in invoiceplane, so there is no need for setting up invoiceplane again.

These links as reference:

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.