[FEATURE] Add native support MYSQL8

invoiceninja / dockerfiles

Docker files for Invoice Ninja

https://hub.docker.com/r/invoiceninja/invoiceninja

GNU General Public License v2.0

399 stars 263 forks source link

[FEATURE] Add native support MYSQL8 #462

Closed Psycho0verload closed 1 year ago

Psycho0verload commented 1 year ago

After a feedback from Flightkick in #455 I have looked into the native support of MYSQL8 again and tested it successful.

Tested:

Still works with MYSQL5
Update from MYSQL5 to MYSQL8 worked without errors

turbo124 commented 1 year ago

@lwj5

Does this look ok?

lwj5 commented 1 year ago

@Psycho0verload do you know what’s the error message when you encountered this? And which version of IN were you using?

It seems that from php 7.2.4 onwards, caching sha2 has been added to mysqlnd. Right now the containers are using php 8.1

In any case I’ll try it out tmr.

Psycho0verload commented 1 year ago

I tested it and interestingly I got the error that the sha2 module is missing. I do not have the exact error message at hand because I am not sitting at the notebook.

It printed in the error message that it would like to have the sha2 module in the path of mariadb. We get the needed module with the installed package.

lwj5 commented 1 year ago

Tried it out and works, this is required even with later PHP versions