Problem to update to MySQL8.0

[mibert]

Hi there,

I am facing a problem to update my Revive Installation.
I want to update from Revive Adserver v5.5.0 running on MySQL 5.5.60-0+deb7u1. to version 5.5.2 with a MySQL8.0 database on my PHP 8.2.18 server.

I copied the files according to your instruction and also successfully copied the SQL data from 5.7 to 8.0 database.

When starting the update, I am getting following Error:

Previous version - 1 error

• Errors were found when detecting previous installations of Revive Adserver
• MDB2 Error: unknown error

Check name	Current value	Status
application - Openads configuration file detected - Could not connect to the database : dbs12898176	NOT OK

 

However, I am sure that my config file entries are correct:
[database]
type=mysqli
host=db501xx1XXX.hosting-data.io
port=3306
username=dbu14XX115
password="MXXXxxxxxxxxxxxxxX"
name=dbs12XXX176
persistent=
mysql4_compatibility=0
protocol=unix
compress=
ssl=
capath=
ca=
socket=

Any help to fix this issue would be most appreciated.

Best regards

Michael

[mibert]

Finally found out, how to fix this issue:

Changed in config files
host=dbxxxxxx.hosting-data.io   to    host="dbxxxxxx.hosting-data.io"

Changed in config files
protocol=unix to  protocol=tcp

Best regards

Michael