G
Database Security. Database Auditing. Database Caching. Database Masking. Get it nowGreenSQL does not wish to start
The problem is as follows:
i have compiled GreenSQL from sources, made everything as install.txt required, but greensql is not running. When i try to run greensql It responses this:
root@ams:~# /etc/init.d/greensql start
Starting SQL firewall: GreenSQL PID
.
I have found that script should create greensql pid-file in /var/run/greensql-fw.pid. It creates it, but it is empty. It is empty because "pidof" is unable to retrieve pid of greensql that is not running.
I am not competent much in bash, but I think that problem might be in /etc/init.d/greensql , at line 59 where "su" tries to start greensql from greensql user privileges.
To disprove that possibility that greensql is broken, i was able to run it manually from root. But it is not the solution, because it is unsafe.
Hope that i am on right way, but don't know where to move further.
PS: my OS is Slackware 12.1.
Comments
Try to run greensql database
Try to run greensql database firewall using the following command:
./greensql-fw -p /etc/greensqlIf it works properly and log file looks good (/var/log/greensql.log) you will have to alter greensql start up script to your needs. I will try to help you with that.
Yuli
Well, greensql-fw process
Well, greensql-fw process started, but as it runs as root, i can't say this is good solution. Moreover, it requires such manual actions like chmod'ing log-file, because php-wrontend is not able to read it, creating pid-file, and starting greensql.
I think that it could be better solution to start running greensql as root, and then it could drop it's own privileges via "setuid" system call.
Hello I just wanted to check
Hello
I just wanted to check that GreenSQL starts and works properly on your server. Now you need to create system user for greensql service and alter greensql start up script.
Take a look at the scripts directory and check the install.txt file.
Yuli