Hi Lloyd,
I'm trying to install ape and mysql, i've downloaded the source
from https://github.com/APE-Project/APE_Server/archive/master.zip , server
info:
[root@prov-test04 ape]# ldd modules/lib/libmod_spidermonkey.so
linux-vdso.so.1 => (0x00007fff74bc1000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007fbba1ac9000)
libmysqlclient.so.18 => /usr/lib64/mysql/libmysqlclient.so.18
(0x00007fbba15eb000)
libc.so.6 => /lib64/libc.so.6 (0x00007fbba1258000)
libm.so.6 => /lib64/libm.so.6 (0x00007fbba0fd4000)
/lib64/ld-linux-x86-64.so.2 (0x00007fbba2311000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fbba0dbe000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fbba0ba0000)
libz.so.1 => /lib64/libz.so.1 (0x00007fbba098a000)
libssl.so.10 => /usr/lib64/libssl.so.10 (0x00007fbba072f000)
libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x00007fbba0394000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fbba0190000)
librt.so.1 => /lib64/librt.so.1 (0x00007fbb9ff88000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2
(0x00007fbb9fd45000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007fbb9fa66000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007fbb9f862000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007fbb9f635000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0
(0x00007fbb9f42a000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007fbb9f227000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fbb9f00c000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007fbb9eded000)
[root@prov-test04 ape]# rpm -qa | grep mysql
mysql-5.5.28-3.el6.remi.x86_64
mysql-server-5.5.28-3.el6.remi.x86_64
compat-mysql51-5.1.54-1.el6.remi.x86_64
mysql-devel-5.5.28-3.el6.remi.x86_64
libdbi-dbd-mysql-0.8.3-5.1.el6.x86_64
mysql-libs-5.5.28-3.el6.remi.x86_64
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
php-mysql-5.3.18-1.el6.remi.x86_64
How did you manage to get it to work?
thanks!
On Saturday, September 1, 2012 10:26:26 PM UTC+3, Lloyd Adler wrote:
>
> 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] <javascript:>)
>>
>> [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/
