Can't login to Admin [SOLVED]
Hi,
After complete setup 3.10 -stabe (993d8282e531d37e868f01c16add9363d92a0bb5
)
The login at https://HOST:8080/login/index.php
was redirected back to the login
After many hours of struggle,
It turns out the MySQL error was not forwarded to error_log,
Please kindly change the file : db_mysql.inc.php
at line : 230
if (!$this->_iQueryId) {
$this->_sqlerror('Abfrage fehlgeschlagen / MySQL Error: '. mysqli_error($this->_iConnId), 'SQL-Query = ' . $sQuery);
return false;
}
MySQL was passing me error :
The MySQL server is running with the --read-only option so it cannot execute this statement
This turns out to be relating to new feature introduced secure-file-priv
after 5.6.26 and we are running MySQL 5.7:
below option must be added to my.cnf
secure-file-priv = ""
and I had to revoke grant to make this work:
REVOKE ALL PRIVILEGES ON `dbispconfig`.* FROM 'ispconfig'@'localhost'; GRANT SELECT, INSERT, UPDATE, DELETE ON `dbispconfig`.* TO 'ispconfig'@'localhost';
Regards