Jump to content

Problem to update to MySQL8.0


Recommended Posts

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
  1. - Openads configuration file detected
  2. - 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

Link to comment
Share on other sites

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

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...