GreenSQL

Hi

I extracted the following 2 main error lines from the build log.

main.cpp:22:19: error: event.h: No such file or directory In file included from config.hpp:16, from main.cpp:24:
patterns.hpp:12:18: error: pcre.h: No such file or directory


It shows a number of missing header files. In order to resolve this problem, you need to make sure that the following packages are installed:

• libevent and libevent-devel
• pcre and pcre-devel

After installing above packages you need to recompile the application.

Best regards
Yuli

I have installed both and now I only get this error: "../greensql-fw executable not found
" and I've followed the instructions to the 't'. And thank you for your help.
-Tyler

Hi

Before running the installation script, you need to compile the application.
You just need to run "make" command to compile the application.
Run it from the main archive directory.

Please tell me which redhat version if are using, I might compile rpm package for you.

Best regards,
Yuli

I've run make before and I get this, it used to be just a one line error, but seems I've really missed up somewhere. :-\
Linux version 2.6.9-023stab043.1-smp (gcc version 3.4.5 20051201 (Red Hat 3.4.5-2)

root@server [~/greensql-fw-0.8.2]# make
rm -rf greensql-fw src/greensql-fw
cd src; make; cp greensql-fw ../
make[1]: Entering directory `/root/greensql-fw-0.8.2/src'
g++ -g -Wno-deprecated -Wall -I/usr/include/mysql/ -I/usr/local/include/ -I/usr/local/include/mysql/ -c -o main.o main.cpp
main.cpp:22:19: error: event.h: No such file or directory
connection.hpp:29: error: field 'proxy_event' has incomplete type
connection.hpp:30: error: field 'client_event' has incomplete type
greensql.hpp:60: error: field 'serverEvent' has incomplete type
main.cpp: In function 'int main(int, char**)':
main.cpp:139: error: 'event_init' was not declared in this scope
main.cpp:141: error: aggregate 'event tEvent' has incomplete type and cannot be defined
main.cpp:142: error: invalid application of 'sizeof' to incomplete type 'event'
main.cpp:146: error: 'evtimer_set' was not declared in this scope
main.cpp:147: error: 'evtimer_add' was not declared in this scope
main.cpp:152: error: 'event_loop' was not declared in this scope
main.cpp: In function 'void clb_timeout(int, short int, void*)':
main.cpp:213: error: 'event_del' was not declared in this scope
main.cpp:221: error: 'evtimer_set' was not declared in this scope
main.cpp:222: error: 'evtimer_add' was not declared in this scope
make[1]: *** [main.o] Error 1
make[1]: Leaving directory `/root/greensql-fw-0.8.2/src'
cp: cannot stat `greensql-fw': No such file or directory
make: *** [greensql-fw] Error 1

It looks like libevent-devel package is still not installed.

Please check. You can do it as followed:

rpm -qi libevent-devel

Best regards,
yuli

Ok, first: for others that read this later; to install libevent-devel simply type this into your ssh: "yum -y install libevent-devel". It will do everything needed to install that. I got it to start I think, now for the console. I installed it by myself :) but cant login, i even went into the root phpmyadmin and changed the password, and yes it is a md5 pass just like the one that was there before. Tell me where to look or begin.

I suppose you have already installed configuration database used by GreenSQL.

There are a number of things for you to check:

First check greensql firewall log. It is located under the following path: /var/log/greensql.log. The first lines will shows you if greensql has connected to database. If you see any errors, please check greensql configuration file, especially db section (/etc/greensql/greensql.conf).

If you have any problem connecting to database from greensql-console, please check config.php file and ensure that it contains correct database settings.

I checked them first thing, i'm learning little by little here, it does establish the connection, but there are a few errors after that, besides the ones where i forget to put a g in grant i have no idea about the others. Error Log and i removed the passwords for security reasons.

It looks like greensql-fw is working correctly !!!
It had successfully connected to configuration db and opened MySQL proxy socket.

Do you have any problem with greensql-console ?
I think, everything should work.

I cant login to it, I went to the phpmyadmin as root and edited the users table to change the pass and it still wont let me login.

Please check if you use correct username and password.

By default it should be admin/pwd.
The password is not encoded using MD5. It is SHA1.

I think, this could be a reason of your problems.

BTW, you can always change default password from withing greensql-console itself.

Best regards,
Yuli

Wow, I feel dumb. It hashed a password in SHA1, and was able to login. Although there is an error at the top of the page: "Warning: Smarty error: unable to read resource: "test.conf" in /home/mygame/public_html/mylittle/libs/Smarty.class.php on line 1095"

Ops, I forger to commit this fix.

You just need to remove the first line from templates/index.tpl file.

Thanks for the report.

Your welcome, it looks like it is working, though I havnt got my database installed yet, but i'll do that and report back with any problems. Thank you for your help and a wonderful program yuli.
-Tyler

How exactly do we update greensql? Do we have to completely uninstall and then download the new release and install it?
-Tyler

If you need to update GreenSQL management console, you have just to backup config.php file. Remove application scripts and then unpack new application version. After that you just need to ensure that new config.php file is updated with your database settings.

In case of GreenSQL firewall you can just remove old package and install the new one. Pay attention that you backup /etc/greensql/greensql.conf file. You need to ensure that after instllation of the new package it has appropriate database configuration settings.

In the upcoming released GreenSQL configuration database might change. A special configuration script will be released to update database structure.

Best regards,
Yuli Stremovsky

Well, maybe starting over will do me some good as I dont think it is checking the the database i added. I'll uninstall everything and install it again, posting my problems for you all to help with as usual.

I had some issues with the makefile's default include directories with RHEL5 (assume 3/4 would have the same issue, along with other RH releases).

Had to remove the local dir from /usr/local/include, /usr/local/include/mysql, etc from the src Makefile. Afterwards the build ran fine.

Hi Tfryman

Can you please start a new thread and give more information about what you are trying to do.

Thanks,
Yuli