[Mahara-contributors] [Bug 1885589] Re: MySQL Error when upgrading from 18.04.02 to 19.04+
Greetings again from Germany, After doing the above mentioned and updating our Mahara to 20.04 we did another Database dump. This time there were no more "hardcoded" entries in the DB-Dump. Regards, 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: Won't Fix 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 : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1885589] Re: MySQL Error when upgrading from 18.04.02 to 19.04+
** Changed in: mahara Status: New => Won't Fix -- 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: Won't Fix 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 : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1885589] Re: MySQL Error when upgrading from 18.04.02 to 19.04+
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 : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1885589] Re: MySQL Error when upgrading from 18.04.02 to 19.04+
Hi Philippe, It looks like this error could be related to MySQL configuration. A quick search online shows that the "definer error" might be due to MySQL trying to update the DB or create an object under a DB user that doesn't exist. This can happen for example when you are trying to migrate your DB to another site. Is it's a new install please make sure you've granted the correct privileges to the user. According to the following post, it might be related to the problem you're having: https://stackoverflow.com/questions/38361787/error-1449-the-user- specified-as-a-definer-rootlocalhost-does-not-exis -- 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 : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1885589] Re: MySQL Error when upgrading from 18.04.02 to 19.04+
This is a site where Mahara is in a sub directory. -- 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 : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1885589] Re: MySQL Error when upgrading from 18.04.02 to 19.04+
** Summary changed: - MySQL Error when upgrading from 18.04.02 to 19.04 + MySQL Error when upgrading from 18.04.02 to 19.04+ -- 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 : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp