GreenSQLTables not found. ; ERROR 1064 (42000) at line 1
Hello @ All
The installation and everything went right, but after adapting the config.php file I got this message:
Tables not found. Please ensure that configuration database was created while installing greensql-fw package.
I reconfigured the package with all thinkable of possibilities, but nothing. But I oticed this line in the console, after reconfiguring:
Database type: mysql
Dropping database...
Database "greensql-fw" dropped
Creating database greensql-fw...
Setting User greensql-fw_user privileges...
ERROR 1064 (42000) at line 1: 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 '-fw.* TO 'greensql-fw_user'@'localhost' IDENTIFIED BY 'foobar'' at line 1
Failed to grant permissions
run dpkg-reconfigure greensql-fw to change the settings
Any ideas?
Thank you.
Hello Prometheus
The installation script might have a problem with a database and username written with the dash and / or with an underscore. We never tested this. Please use simple database name and username and try to reconfigure.
Best regards,
Yuli
Your advice worked. Thank you very much. The dash was definitely the problem in the username as also in the database name.