[Serusers] Compiling SER 0.9.3

[Samuel Osorio Calvo]

Hi all,
I think the problem is not loading mysql SER module but to find the mysqlclient library. 
There are two possibilities:
1)Add the directory where your library is to the library environmental path (I think it was LD_LIB_PATH  or LD_RUN_PATH)
#export LD_RUN_PATH=$LD_RUN_PATH:/usr/local/mysql/lib/mysql/
2)Add a link in a well-known directory where libraries can be found, such as /usr/lib or /usr/local/lib to your library placed in /usr/local/mysql/lib/mysql/.


Hope it helps,
Samuel.


Unclassified.
>>> "Greger V. Teigre" <greger at teigre.com> 09/07/05 09:41AM >>>
Change the path in ser.cfg.
g-)
---- Original Message ----
From: Alberto
To: Greger V. Teigre ; serusers at lists.iptel.org 
Cc: Daniel Sirera
Sent: Wednesday, September 07, 2005 09:32 AM
Subject: Re: [Serusers] Compiling SER 0.9.3

> Hi,
> I did it!!!!!!!!
> I compiled the MySQL source. The problem was of directories.
> 
> BUT, ( always there are a BUT )
> 
> When run the SER I get the next error:
> 
>         ser: ERROR: load_module: could not open module
> </usr/local/lib/ser/modules/mysql.so>: Shared 
>         object "libmysqlclient.so.14" not found, required by
> "mysql.so" 
> 
> when I execute "locate libmysqlclient.so.14" I get:
>         /usr/local/mysql/lib/mysql/libmysqlclient.so.14
> 
> I have read whom there is to make a LINK to libmysqlclient.so.14, but
> not where nor like doing it. 
> 
> Thanks,
> 
> 
> ----- Original Message -----
> From: Greger V. Teigre
> To: Alberto ; serusers at lists.iptel.org 
> Cc: Daniel Sirera
> Sent: Tuesday, September 06, 2005 1:14 PM
> Subject: Re: [Serusers] Compiling SER 0.9.3
> 
> 
> mysql/mysql.h: No such file or directory
> The mysql-devel package is probably not installed.
> g-)
> 
> ---- Original Message ----
> From: Alberto
> To: serusers at lists.iptel.org 
> Cc: Daniel Sirera
> Sent: Tuesday, September 06, 2005 12:16 PM
> Subject: [Serusers] Compiling SER 0.9.3
> 
>> Hi,
>> 
>> This is my first message. I have a server with FreeBSD 5.3 and MySQL
>> 4.1.13
>> and I would like to install SER-0.9.3 (with sql support).
>> 
>> I'd downloaded the package " ser-0.9.3.GettingStarted.1.2.tar " from
>> www.onSIP.org.
>> 
>> Before compiling, I'd edited the next files:
>> 
>> Makefile file (  /usr/src/ser-0.9.3 )
>> ========================
>> 
>>        exclude_modules?=                       cpl ext extcmd \
>>                                                            postgres
>> snmp \
>>                                                            im \
>>                                                            jabber
>> mysql \
>>                                                            cpl-c \
>> 
>> auth_radius group_radius uri_radius avp_radius \
>>                                                            pa
>> 
>>     I'VE REMOVE THE REFERENCE TO mysql
>> 
>> 
>> Makefile file ( /usr/src/ser-0.9.3 )
>> ========================
>> 
>>     # mysql.h locations (freebsd,openbsd  solaris)
>>     DEFS +=-I$(LOCALBASE)/include -I$(LOCALBASE)/include/mysql \
>>                 -I$(LOCALBASE)/mysql/include \
>>                 -I/usr/local/mysql/include \    #
>> <----------------------------------------- ADDED BY ME
>>                 -I/usr/include/mysql
>> 
>> 
>>     # libmysqlclient locations on RH/Suse, Solaris /OpenBSD, FreeBSD
>>     # (Debian does the right thing and puts it in /usr/lib)
>>     LIBS=-L/usr/lib/mysql -L$(LOCALBASE)/lib -L$(LOCALBASE)/lib/mysql
>> \
>>                 -L$(LOCALBASE)/mysql/lib/mysql/ \
>>                 -L$(LOCALBASE)/mysql/lib \
>>                 -L/usr/local/mysql/lib \      #
>> <----------------------------------------- ADDED BY ME
>>                 -L/usr/lib64/mysql \
>>                 -lmysqlclient -lz
>> 
>> 
>> 
>> I execute the next command for compile: " gmake all " and I get the
>> next errors:
>> 
>>           <--------- cut ---------->
>>         ................................
>>           gmake[1]: Entering directory
>> `/usr/src/ser-0.9.3/modules/mysql'
>>         ../../Makefile.rules:80: db_con.d: No such file or directory
>>         ../../Makefile.rules:80: db_mod.d: No such file or directory
>>         ../../Makefile.rules:80: dbase.d: No such file or directory
>>         ../../Makefile.rules:80: my_con.d: No such file or directory
>>         ../../Makefile.rules:80: my_id.d: No such file or directory
>>         ../../Makefile.rules:80: my_pool.d: No such file or directory
>>         ../../Makefile.rules:80: res.d: No such file or directory
>>         ../../Makefile.rules:80: row.d: No such file or directory
>>         ../../Makefile.rules:80: utils.d: No such file or directory
>>         ../../Makefile.rules:80: val.d: No such file or directory
>>         In file included from val.c:35:
>>         val.h:31:25: mysql/mysql.h: No such file or directory
>>         row.c:33:25: mysql/mysql.h: No such file or directory
>>         res.c:31:25: mysql/mysql.h: No such file or directory
>>         In file included from my_pool.h:32,
>>                          from my_pool.c:31:
>>         my_con.h:33:25: mysql/mysql.h: No such file or directory
>>         In file included from my_con.c:31:
>>         my_con.h:33:25: mysql/mysql.h: No such file or directory
>>         dbase.c:34:25: mysql/mysql.h: No such file or directory
>>         ......................
>>         <--------- cut ---------->
>> 
>> 
>> 
>> Some idea? I not that but to prove. ( HELP!!! )
>> 
>> Thanks for your time and apologies by my english.

Samuel Osorio Calvo
Phone: (+31) 35 5248126

THALES Communications
P.O. Box 88, 1270 AB  Huizen, The Netherlands
Bestevaer 46, 1271 ZA  Huizen, The Netherlands

Unclassified