Error setting up mysql during install

Hi Daniel,

Thanks for the information. I had IT changed the setting and I seem to be getting past that error only to get a new error.

MySQL Error: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' - in database_functions.php on line 104 by mysqlStrictMode()

Thanks,

Kevin

Hi Kevin,

Due to its relative newness and low adoption rate, CMSB hasn't yet been officially tested in MySQL 8, which looks to be the cause of your error here. We will work on getting it patched for future releases, but in the meantime, you should be able to fix this by modifying the file "cmsb/lib/mysql_functions.php". Look in that file for a section that looks like this:

    if ($strictMode) { $sql_mode = "STRICT_ALL_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"; }
    else             { $sql_mode                   = "NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"; }

Remove the "NO_AUTO_CREATE_USER" portions so that it then looks like this:

    if ($strictMode) { $sql_mode = "STRICT_ALL_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"; }
    else             { $sql_mode                   = "NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"; }

Let me know if that does the trick, and I'll be happy to help sort out any further issues you have.

Thanks,

Getting closer :)

MySQL Error: Access denied for user 'skcadmin'@'%' (using password: YES)

Hey Kevin,

This sort of error usually points towards a configuration issue; since you appear to be able to connect to the DB, my first guess would be a permission issue. Double check that all of your database info is correct (hostname, database, user, password) and that the user has been granted full privileges to that database. If you are unable to resolve it, I would next recommend passing this error along to IT to see what they can do to help troubleshoot. More information on this error can be found here: https://dev.mysql.com/doc/refman/8.0/en/error-access-denied.html

Cheers,