Well the mysql auth_plugin could be something other than mysql_native_password also in mysql-5.7. This error would occur anytime mysql was configured to use an auth_plugin that was not supported by php’s mysqli. Of course you won’t know this is the problem unless you hack the SuiteCRM code to expose the underlying mysql error. So yeah, would be good to expose technical error messages…especially during install since the installing user is presumably an “admin” and technical. At the very least they should end up in the logs.
The good news is that once I figured out this was the issue and changed the auth_plugin for that user, the install went without a hitch (mysql-8.0 on Ubuntu 20.04 LTS).
Logging in and everything looks fine so far other than the following message which could be related to mysql-8:
PHP message: PHP Notice: Array to string conversion in /opt/apps/suitecrm/include/database/DBManager.php on line 887
That code is:
$sql .= "*/\n";
$sql .= "/* VARDEF - $name - ROW";
foreach ($value as $rKey => $rValue) {
$sql .= "[$rKey] => '$rValue' "; // line 887
}
$sql .= "*/\n";
…php lang warning I think and not mysql-8 related.
I haven’t seen any recent progress in the ability to use MySQL 8. Current wisdom is that it’s not worth trying, creates multiple problems
As far as I read, it seems like the issue with mysql-8 was about new keywords/reserved words that were colliding with some Suite/Sugar naming conventions…but that was patched a couple minor versions ago (I linked to the issue/commit earlier).
The other issue I discovered is just that mysql-8 changed the default auth_plugin to one that mysqli doesn’t support. But that is a common DB edge-case and just not well handled by the SuiteCRM db code…and not specific to mysql-8.
Is there any documentation or github issue that lists current known problems with mysql-8 or is it mostly just that it is unknown whether there are other problems because no one has tried to use it yet? If there are a bunch of known issues, then good to know. If not, I am not particularly concerned now that the key/reserved word issue is resolved.
Thanks for all the help!