Invoice Ninja Install fails

Self-Hosted | v5
1

During installation it keeps flopping out

Using Php 8.0
Invoice Ninja 5 latest

php8.0 /var/www/invoiceninja/artisan key:generate -seed - to run

Response:
In Connection.php line 712:

SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report
to the developers (SQL: select * from information_schema.tables where table_sch
ema = pagindb and table_name = accounts and table_type = ‘BASE TABLE’)

In Connector.php line 70:

SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report
to the developers

In Connector.php line 70:

PDO::__construct(): Server sent charset (0) unknown to the client. Please, repor
t to the developers

Ran following:
php artisan optimize
php artisan migrate
php artisan config:cache

Mysql - set from utf8 to the one that uses both
ALTER DATABASE pagindb CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

All to no avail.

Have 2 CT’s running
one hosting MariaDB latest
one hosting invoice ninja

Have installed mysql client on both - can log in remotely.

Still getting this issue.

Have noticed the php package for driver issue - is listed as 8.3 under etc folder.

Any assistance would be great.

2

Hi,

Which web server are you using?

3

setting up to use apache according to guide

4

You may want to try with Nginx.

@david have you seen this error before?

5

do you have an official guide for installation ?

6
7

I am running into this error on my Debian host with the latest IN docker containers. The container images were upgraded and now fail to start with same error. Confirmed on multiple servers. Any known fix?

These are the relevant container images:

REPOSITORY                  TAG       IMAGE ID       CREATED        SIZE
invoiceninja/invoiceninja   latest    6e69cd95b3ba   2 days ago     1.76GB
mariadb                     latest    d344f866f140   17 hours ago   405MB
nginx                       alpine    6913ed9ec8d0   6 days ago     42.6MB

IN container logs:

In Connection.php line 829:
                                                                               
  SQLSTATE[HY000] [2054] Server sent charset (0) unknown to the client. Pleas  
  e, report to the developers (Connection: mysql, SQL: select table_name as `  
  name`, (data_length + index_length) as `size`, table_comment as `comment`,   
  engine as `engine`, table_collation as `collation` from information_schema.  
  tables where table_schema = 'ninja' and table_type in ('BASE TABLE', 'SYSTE  
  M VERSIONED') order by table_name)                                           
                                                                               

In Connector.php line 65:
                                                                               
  SQLSTATE[HY000] [2054] Server sent charset (0) unknown to the client. Pleas  
  e, report to the developers
9

Are you using the standard docker file, in particular are you using MySQL or MariaDB?

10

Pinning mariadb to major version 10 fixed it. So basically replaced mariadb:latest with mariadb:10 for the image specification.

11

Glad to hear it, thanks for the update!

cc @david