Jump to content
Froxlor Forum

bimmer

Members
  • Content Count

    11
  • Joined

  • Last visited

Everything posted by bimmer

  1. bimmer

    froxlor latest - mysql 8 support

    Hi All, I just upgraded my server to mysql 8 with froxlor 0.9.38.7. It threw a couple mysql error during database creation so I decided to upgrade froxlor. However after the upgrade I can't even reach the login page due to a database error. Is it possible that froxlor latest is not compatible with mysql 8?? Or am I missing something? Thanks a lot!
  2. bimmer

    froxlor latest - mysql 8 support

    cool, it works! Thanks a lot mate!
  3. bimmer

    froxlor latest - mysql 8 support

    yeah, I fixed this but I still have a db error but can't figure out what's missing.. A database error occurred SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PASSWORD('yoQhkgclUs')' at line 1 code: $stmt = Database::prepare(" CREATE USER '" . $username . "'@'" . $access_host . "' IDENTIFIED BY 'password' ");
  4. bimmer

    froxlor latest - mysql 8 support

    doesn't contain anything special but I checked your code if user and host is connected with a dot and it seems it doesn't work with mysql 8: root@localhost [(none)]> CREATE USER 'somebody'.'localhost' IDENTIFIED BY 'PASSWORD'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.'localhost' IDENTIFIED BY 'PASSWORD'' at line 1 root@localhost [(none)]> CREATE USER 'somebody'@'localhost' IDENTIFIED BY 'PASSWORD'; Query OK, 0 rows affected (0.02 sec)
  5. bimmer

    froxlor latest - mysql 8 support

    Now I tried to select all lines and inserted in a new file, named it as class.DbManagerMySQL.php and tried again. The error is the same: A database error occurred SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.'127.0.0.1' IDENTIFIED BY 'password'' at line 1 Maybe there is a different way to create user in Mysql 8?
  6. bimmer

    froxlor latest - mysql 8 support

    well I deleted these lines and inserted again, now I have a different error A database error occurred SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`127.0.0.1` IDENTIFIED BY 'password'' at line 1
  7. bimmer

    froxlor latest - mysql 8 support

    did it, this error occured: Parse error: syntax error, unexpected '"host"' (T_CONSTANT_ENCAPSED_STRING), expecting ')' in /vhosts/ssl/lib/classes/database/manager/class.DbManagerMySQL.php on line 81
  8. bimmer

    froxlor latest - mysql 8 support

    sorry, forgot to mention, no git installed, production server
  9. bimmer

    froxlor latest - mysql 8 support

    patch < db.patch Hmm... Looks like a unified diff to me... The text leading up to this was: -------------------------- | -------------------------- File to patch: lib/classes/database/manager/class.DbManagerMySQL.php Patching file lib/classes/database/manager/class.DbManagerMySQL.php using Plan A... Hunk #1 failed at 66. 1 out of 1 hunks failed--saving rejects to lib/classes/database/manager/class.DbManagerMySQL.php.rej done
  10. bimmer

    froxlor latest - mysql 8 support

    thanks, removing it solved the problem. However with the old and the new version when I try to create a new database for a user this error occurs: A database error occurred SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'password'' at line 2
  11. bimmer

    froxlor latest - mysql 8 support

    here you are: A database error occurred SQLSTATE[42000] [1231] Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
×