greensql-fw doesn't start

3 replies

Thu, 04/09/2009 - 14:46

doal6472

Joined: 04/09/2009

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 ?

Thu, 04/09/2009 - 21:06

yuli

Joined: 01/30/2008

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

Thanks,
Yuli

Fri, 04/10/2009 - 06:35

doal6472

Joined: 04/09/2009

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.

Fri, 04/10/2009 - 22:14

yuli

Joined: 01/30/2008

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

GreenSQL