I managed to solve the problem. MySQL works really well on latest git version of APE.
Den tisdagen den 28:e augusti 2012 kl. 18:13:17 UTC+2 skrev Lloyd Adler: > > Hi, > > I really need support from every single one here on ape-project who have a > complete and fully working APE server (with MySQL support). > > *The main problem begins where I would include the MySQLDemo.js ( > http://www.ape-project.org/wiki/index.php/Serverside_js_module_using_MySQL) > script in main.ape.js.* > > [root@server bin]# ./aped > _ ___ ___ > /_\ | _ \ __| > / _ \| _/ _| > /_/ \_\_| |___| > AJAX Push Engine > > Bind on port 6969 > > Version : 1.1.2-dev > Build : Aug 28 2012 18:00:34 > Author : Weelya ([email protected]) > > [Module] [spidermonkey] Loading module : Javascript embeded (0.01) - > Anthony Catel > [JS] Loading script ../scripts/test.js... > [JS] Loading script ../scripts/plugins/MySQL.js... > [JS] Loading script ../scripts/framework/mootools.js... > [JS] Loading script ../scripts/framework/Http.js... > [JS] Loading script ../scripts/framework/userslist.js... > [JS] Loading script ../scripts/utils/utils.js... > [JS] Loading script ../scripts/commands/proxy.js... > [JS] Loading script ../scripts/commands/inlinepush.js... > [JS] Loading script ../scripts/examples/nickname.js... > [JS] Loading script ../scripts/examples/move.js... > [JS] Loading script ../scripts/utils/checkTool.js... > ./aped: symbol lookup error: ../modules/lib/libmod_spidermonkey.so: > undefined symbol: scramble > > My server setup: > CentOS 6.3 (x86_64) (OpenVZ) > Kernel: 2.6.18-194.26.1.el5.028stab079.2 > MySQL 5.5.27 (Ver 14.14 Distrib 5.5.27, for Linux (x86_64) using readline > 5.1) > > Packages: > mysql.x86_64 5.5.27-1.el6.remi @remi > mysql++.x86_64 3.0.9-3.el6 @epel > mysql-connector-c++.x86_64 1.1.1-1.el6.remi @remi > mysql-connector-c++-devel.x86_64 1.1.1-1.el6.remi @remi > mysql-connector-odbc.x86_64 5.1.5r1144-7.el6 @base > mysql-devel.x86_64 5.5.27-1.el6.remi @remi > mysql-libs.x86_64 5.5.27-1.el6.remi @remi > mysql-server.x86_64 5.5.27-1.el6.remi @remi > > Development tools installed containing almost every package starting with > "lib". (Same as "build-essential" in Ubuntu"). > > *Mysql libraries installed*: *(I don't have any libmysqlclient version 15, > only 16 and 18).* > [root@server /]# cd /usr/lib64/mysql && ls -l > lrwxrwxrwx 1 root root 17 Aug 27 09:37 libmysqlclient_r.so -> > libmysqlclient.so > lrwxrwxrwx 1 root root 26 Jan 30 2012 libmysqlclient_r.so.16 -> > libmysqlclient_r.so.16.0.0 > -rwxr-xr-x 1 root root 2165216 Dec 23 2010 libmysqlclient_r.so.16.0.0 > lrwxrwxrwx 1 root root 20 Aug 27 09:37 libmysqlclient.so -> > libmysqlclient.so.18 > lrwxrwxrwx 1 root root 24 Jan 30 2012 libmysqlclient.so.16 -> > libmysqlclient.so.16.0.0 > -rwxr-xr-x 1 root root 2154232 Dec 23 2010 libmysqlclient.so.16.0.0 > lrwxrwxrwx 1 root root 24 Aug 24 00:22 libmysqlclient.so.18 -> > libmysqlclient.so.18.0.0 > -rwxr-xr-x 1 root root 2983360 Aug 3 09:28 libmysqlclient.so.18.0.0 > > Further on I checked out these topics: > > https://groups.google.com/forum/?fromgroups=#!topic/ape-project/v_tbyCNkC_M > https://github.com/APE-Project/APE_Server/wiki/CentOS-6-Dependencies > > Followed every single step in every installation guide found on google, > installed all necessary dependencies for APE in CentOS 6. Here's what I did > to install it: > > *1. Install dependencies for CentOS 6* > libstdc++-devel > gcc-c++ > zip > keyutils-libs-devel > libsepol-devel > libselinux-devel > libcom_err-devel > krb5-devel > openssl-devel > mysql-devel > > *2. Download APE* > https://github.com/APE-Project/APE_Server/tarball/master > > *3. Edit /modules/Makefile and replace line 7* > MYSQL_FLAGS = -L./deps/mysac/ -L/usr/lib64/mysql -I./deps/mysac/ -lmysac > -lmysqlclient_r > > [root@server APE_Server]# sh build.sh (shows missing lmysac and ljs_static) > [root@server APE_Server]# cd modules/deps/mysac && make > [root@server APE_Server]# cd deps/js/src && make > [root@server APE_Server]# sh build.sh (no errors or warnings) > > *4. Checking the libmod_spidermonkey dependencies* > [root@server APE_Server]# ldd modules/lib/libmod_spidermonkey.so > libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00002b9ae4a93000) > libmysqlclient.so.18 => /usr/lib64/mysql/libmysqlclient.so.18 > (0x00002b9ae4d99000) > libc.so.6 => /lib64/libc.so.6 (0x00002b9ae5276000) > libm.so.6 => /lib64/libm.so.6 (0x00002b9ae560a000) > /lib64/ld-linux-x86-64.so.2 (0x00002b9ae432f000) > libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00002b9ae588e000) > libpthread.so.0 => /lib64/libpthread.so.0 (0x00002b9ae5aa4000) > libz.so.1 => /lib64/libz.so.1 (0x00002b9ae5cc2000) > libssl.so.10 => /usr/lib64/libssl.so.10 (0x00002b9ae5ed8000) > libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x00002b9ae6133000) > libdl.so.2 => /lib64/libdl.so.2 (0x00002b9ae64ce000) > librt.so.1 => /lib64/librt.so.1 (0x00002b9ae66d2000) > libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 > (0x00002b9ae68da000) > libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00002b9ae6b1d000) > libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00002b9ae6dfc000) > libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00002b9ae7000000) > libkrb5support.so.0 => /lib64/libkrb5support.so.0 > (0x00002b9ae722d000) > libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00002b9ae7438000) > libresolv.so.2 => /lib64/libresolv.so.2 (0x00002b9ae763b000) > libselinux.so.1 => /lib64/libselinux.so.1 (0x00002b9ae7856000) > > What did I do wrong?? > -- You received this message because you are subscribed to the Google Groups "APE Project" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/ape-project?hl=en --- APE Project (Ajax Push Engine) Official website : http://www.ape-project.org/ Git Hub : http://github.com/APE-Project/
