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@teigre.com 09/07/05 09:41AM >>>

Change the path in ser.cfg. g-) ---- Original Message ---- From: Alberto To: Greger V. Teigre ; serusers@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@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@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