<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>loadmodule "/usr/local/lib/ser/modules/mysql.so"</DIV>
<DIV> </DIV>
<DIV>---- Original Message ----<BR>From: Alberto<BR>To: Greger V. Teigre ;
serusers@lists.iptel.org<BR>Cc: Daniel Sirera<BR>Sent: Wednesday, September 07, 2005
10:00 AM<BR>Subject: Re: [Serusers] Compiling SER 0.9.3<BR><BR>> Sorry,
where? ( I am novice )<BR>> My ser.cfg is:<BR>> <BR>> #<BR>> # $Id:
ser.cfg,v 1.25.2.1 2005/02/18 14:30:44 andrei Exp $<BR>> #<BR>> # simple
quick-start config script<BR>> #<BR>> # ----------- global configuration
parameters ------------------------<BR>> #debug=3 # debug level (cmd line:
-dddddddddd)<BR>> #fork=yes<BR>> #log_stderror=no # (cmd line: -E)<BR>>
/* Uncomment these lines to enter debugging mode<BR>> fork=no<BR>>
log_stderror=yes<BR>> */<BR>> check_via=no # (cmd. line: -v)<BR>>
dns=no # (cmd. line: -r)<BR>> rev_dns=no # (cmd. line: -R)<BR>>
#port=5060<BR>> #children=4<BR>> fifo="/tmp/ser_fifo"<BR>> #
------------------ module loading ----------------------------------<BR>> #
Uncomment this if you want to use SQL database<BR>> loadmodule
"/usr/local/lib/ser/modules/mysql.so"<BR>> loadmodule
"/usr/local/lib/ser/modules/sl.so"<BR>> loadmodule
"/usr/local/lib/ser/modules/tm.so"<BR>> loadmodule
"/usr/local/lib/ser/modules/rr.so"<BR>> loadmodule
"/usr/local/lib/ser/modules/maxfwd.so"<BR>> loadmodule
"/usr/local/lib/ser/modules/usrloc.so"<BR>> loadmodule
"/usr/local/lib/ser/modules/registrar.so"<BR>> loadmodule
"/usr/local/lib/ser/modules/textops.so"<BR>> # Uncomment this if you want
digest authentication<BR>> # mysql.so must be loaded !<BR>> loadmodule
"/usr/local/lib/ser/modules/auth.so"<BR>> loadmodule
"/usr/local/lib/ser/modules/auth_db.so"<BR>> # ----------------- setting
module-specific parameters ---------------<BR>> # -- usrloc params --<BR>>
modparam("usrloc", "db_mode", 0)<BR>> # Uncomment this if you want to use SQL
database<BR>> # for persistent storage and comment the previous line<BR>>
modparam("usrloc", "db_mode", 2)<BR>> # -- auth params --<BR>> # Uncomment
if you are using auth module<BR>> #<BR>> modparam("auth_db",
"calculate_ha1", yes)<BR>> #<BR>> # If you set "calculate_ha1" parameter
to yes (which true in this<BR>> config), # uncomment also the following
parameter)<BR>> #<BR>> modparam("auth_db", "password_column",
"password")<BR>> # -- rr params --<BR>> # add value to ;lr param to make
some broken UAs happy<BR>> modparam("rr", "enable_full_lr", 1)<BR>> #
------------------------- request routing logic -------------------<BR>> #
main routing logic<BR>> <BR>> <------------ CUT ------------------
><BR>> <BR>> ----- Original Message -----<BR>> From: Greger V.
Teigre<BR>> To: Alberto ; serusers@lists.iptel.org<BR>> Cc: Daniel
Sirera<BR>> Sent: Wednesday, September 07, 2005 9:41 AM<BR>> Subject: Re:
[Serusers] Compiling SER 0.9.3<BR>> <BR>> <BR>> Change the path in
ser.cfg.<BR>> g-)<BR>> ---- Original Message ----<BR>> From:
Alberto<BR>> To: Greger V. Teigre ; serusers@lists.iptel.org<BR>> Cc: Daniel
Sirera<BR>> Sent: Wednesday, September 07, 2005 09:32 AM<BR>> Subject: Re:
[Serusers] Compiling SER 0.9.3<BR>> <BR>>> Hi,<BR>>> I did
it!!!!!!!!<BR>>> I compiled the MySQL source. The problem was of
directories.<BR>>> <BR>>> BUT, ( always there are a BUT
)<BR>>> <BR>>> When run the SER I get the next error:<BR>>>
<BR>>> ser: ERROR:
load_module: could not open module<BR>>>
</usr/local/lib/ser/modules/mysql.so>:
Shared<BR>>> object
"libmysqlclient.so.14" not found, required by<BR>>> "mysql.so"<BR>>>
<BR>>> when I execute "locate libmysqlclient.so.14" I
get:<BR>>>
/usr/local/mysql/lib/mysql/libmysqlclient.so.14<BR>>> <BR>>> I have
read whom there is to make a LINK to libmysqlclient.so.14, but<BR>>> not
where nor like doing it.<BR>>> <BR>>> Thanks,<BR>>>
<BR>>> <BR>>> ----- Original Message -----<BR>>> From: Greger
V. Teigre<BR>>> To: Alberto ; serusers@lists.iptel.org<BR>>> Cc: Daniel
Sirera<BR>>> Sent: Tuesday, September 06, 2005 1:14 PM<BR>>>
Subject: Re: [Serusers] Compiling SER 0.9.3<BR>>> <BR>>>
<BR>>> mysql/mysql.h: No such file or directory<BR>>> The
mysql-devel package is probably not installed.<BR>>> g-)<BR>>>
<BR>>> ---- Original Message ----<BR>>> From: Alberto<BR>>>
To: serusers@lists.iptel.org<BR>>> Cc: Daniel Sirera<BR>>> Sent: Tuesday,
September 06, 2005 12:16 PM<BR>>> Subject: [Serusers] Compiling SER
0.9.3<BR>>> <BR>>>> Hi,<BR>>>> <BR>>>> This is
my first message. I have a server with FreeBSD 5.3 and MySQL<BR>>>>
4.1.13<BR>>>> and I would like to install SER-0.9.3 (with sql
support).<BR>>>> <BR>>>> I'd downloaded the package "
ser-0.9.3.GettingStarted.1.2.tar " from<BR>>>>
www.onSIP.org.<BR>>>> <BR>>>> Before compiling, I'd edited the
next files:<BR>>>> <BR>>>> Makefile file (
/usr/src/ser-0.9.3 )<BR>>>> ========================<BR>>>>
<BR>>>>
exclude_modules?=
cpl ext extcmd
\<BR>>>>
postgres<BR>>>> snmp
\<BR>>>>
im
\<BR>>>>
jabber<BR>>>> mysql
\<BR>>>>
cpl-c \<BR>>>> <BR>>>> auth_radius group_radius uri_radius
avp_radius
\<BR>>>>
pa<BR>>>> <BR>>>> I'VE REMOVE THE
REFERENCE TO mysql<BR>>>> <BR>>>> <BR>>>> Makefile
file ( /usr/src/ser-0.9.3 )<BR>>>>
========================<BR>>>>
<BR>>>> # mysql.h locations
(freebsd,openbsd solaris)<BR>>>> DEFS
+=-I$(LOCALBASE)/include -I$(LOCALBASE)/include/mysql
\<BR>>>>
-I$(LOCALBASE)/mysql/include
\<BR>>>>
-I/usr/local/mysql/include \ #<BR>>>>
<----------------------------------------- ADDED BY
ME<BR>>>>
-I/usr/include/mysql<BR>>>> <BR>>>>
<BR>>>> # libmysqlclient locations on RH/Suse,
Solaris /OpenBSD, FreeBSD<BR>>>> # (Debian does
the right thing and puts it in /usr/lib)<BR>>>>
LIBS=-L/usr/lib/mysql -L$(LOCALBASE)/lib<BR>>>>
-L$(LOCALBASE)/lib/mysql
\<BR>>>>
-L$(LOCALBASE)/mysql/lib/mysql/
\<BR>>>>
-L$(LOCALBASE)/mysql/lib
\<BR>>>>
-L/usr/local/mysql/lib \ #<BR>>>>
<----------------------------------------- ADDED BY
ME<BR>>>>
-L/usr/lib64/mysql
\<BR>>>>
-lmysqlclient -lz<BR>>>> <BR>>>> <BR>>>>
<BR>>>> I execute the next command for compile: " gmake all " and I get
the<BR>>>> next errors:<BR>>>>
<BR>>>>
<--------- cut
----------><BR>>>>
................................<BR>>>>
gmake[1]: Entering directory<BR>>>>
`/usr/src/ser-0.9.3/modules/mysql'<BR>>>>
../../Makefile.rules:80: db_con.d: No such file or
directory<BR>>>>
../../Makefile.rules:80: db_mod.d: No such file or
directory<BR>>>>
../../Makefile.rules:80: dbase.d: No such file or
directory<BR>>>>
../../Makefile.rules:80: my_con.d: No such file or
directory<BR>>>>
../../Makefile.rules:80: my_id.d: No such file or
directory<BR>>>>
../../Makefile.rules:80: my_pool.d: No such file
or<BR>>>> directory
../../Makefile.rules:80: res.d: No such file
or<BR>>>> directory
../../Makefile.rules:80: row.d: No such file
or<BR>>>> directory
../../Makefile.rules:80: utils.d: No such file
or<BR>>>> directory
../../Makefile.rules:80: val.d: No such file
or<BR>>>> directory In
file included from
val.c:35:<BR>>>>
val.h:31:25: mysql/mysql.h: No such file or
directory<BR>>>>
row.c:33:25: mysql/mysql.h: No such file or
directory<BR>>>>
res.c:31:25: mysql/mysql.h: No such file or
directory<BR>>>> In
file included from
my_pool.h:32,<BR>>>>
from
my_pool.c:31:<BR>>>>
my_con.h:33:25: mysql/mysql.h: No such file or
directory<BR>>>> In
file included from
my_con.c:31:<BR>>>>
my_con.h:33:25: mysql/mysql.h: No such file or
directory<BR>>>>
dbase.c:34:25: mysql/mysql.h: No such file or
directory<BR>>>>
......................<BR>>>>
<--------- cut ----------><BR>>>> <BR>>>>
<BR>>>> <BR>>>> Some idea? I not that but to prove. ( HELP!!!
)<BR>>>> <BR>>>> Thanks for your time and apologies by my
english.</DIV></BODY></HTML>