Hi Cecilia, Kristina and the Mahara Team.
Thanks for the hint, but it didn't resolve our problem.
What we did:
Complete new Web and Db Server (with new IP's)
Dump the old mysql DB with locked-tables and complete-inserts.
Restore the DB on the new Db Server and grant the privileges from webserver to
DB.
Start the update and it failed with the same error as previously mentioned.
The analysis showed the following:
There are some "hardcoded" entries in the DB-Dump with the old IP
address.
Example:
/*!50003 CREATE*/ /*!50017 DEFINER="xxx_user"@"xxx.xxx.xxx.60"*/ /*!50003
TRIGGER "search_elasticsearch_view_artefact_delete" BEFORE delete ON
"view_artefact"
FOR EACH ROW CALL
"search_elasticsearch_queue2_trigger"('view_artefact', 'delete', OLD.artefact,
null) */;;
where xxx.xxx.xxx.60 is the ip of the old webserver.
After changing the ip to the new ip of the webserver xxx.xxx.xxx.106 and
then restore the dump , we can update from 18.04.2 to 18.10 and to
20.04.
Perhaps this issue is related to elasticsearch.
Thank you very much and have a nice day
Regards from Germany
Jochen and Philippe
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask
on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1885589
Title:
MySQL Error when upgrading from 18.04.02 to 19.04+
Status in Mahara:
New
Bug description:
Greetings from Germany,
While trying to upgrade Mahara from 18.04.02 to 19.04 we've encountered
following problem with our MySQL Server:
Failed to get a recordset: mysqli error:[1449: The user specified as a
definer ($mysqluser@$mysqlhost) does not exist]
This problem seems to occur regardless of what version we try to
upgrade to (tried with 18.10, 19.04, 19.10, 20.04).
Philippe
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1885589/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
