Home › Forums › General
 Database Security. Database Auditing. Database Caching. Database Masking. Get it now

Tables not found. ; ERROR 1064 (42000) at line 1

Posted February 16th, 2010 by Prometheus
in

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.

Is GreenSQL could work with IPV6? ›

Comments

Hello Prometheus The

On February 16th, 2010 yuli says:

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

On February 16th, 2010 Prometheus says:

Your advice worked. Thank you very much. The dash was definitely the problem in the username as also in the database name.

Back to top