Skip to content

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