greensql-fw doesn't start |

Database Security. Database Auditing. Database Caching. Database Masking. Get it now

greensql-fw doesn't start

Posted April 9th, 2009 by doal6472

hi,

i am trying to test your product on a CentOs 5.2 i386 server. mySQL is working fine on this machine.

i have installed the rpm provided for centos without any problematic issue.

script shell greensql-createdb.sh is working fine and the database green db exists.

a connection by mysql --user=green --host=127.0.0.1 --database=greendb --protocol=TCP --port=3606 -p
works fine too.

but service greendb-fw start failed with Access denied for user 'green'@'localhost' (using password: YES)

i tried to make a grant insert,update,create,delete on greendb.* to 'green'@'127.0.0.1' identified by 'password' ;

error persist ....

i tried greensql-fw -p /etc/greensql : error 'Failed to connect to db storage'

some help please ?

On April 9th, 2009 yuli says:

It looks very strange. Try to flush mysql users. Can you paste the [database] section of the /etc/greensql/greensql.conf file ?

Thanks,
Yuli

On April 10th, 2009 doal6472 says:

OK, my database section in greensql.conf

cat /etc/greensql/greensql.conf
# Uncomment the following line if you want to change any setting.

[database]
dbhost=127.0.0.1
dbname=greendb
dbuser=green
dbpass=xxxxx (here is the real password, not xxxxx)
# dbport=3306

to test, i have turned off selinux and iptables, problem remains the same.

thanks for your help.

On April 10th, 2009 yuli says:

It looks something strange. In the examples you posted the port value are different:

connection by mysql --user=green --host=127.0.0.1 --database=greendb --protocol=TCP --port=3606 -p works fine too.

While in your configuration file you have the following line:
# dbport=3306

If you use port other than 3306 to access MySQL server, uncomment the above line and change it accordingly.

Best regards,
Yuli