loadmodule "/usr/local/lib/ser/modules/mysql.so"
---- Original Message ----
From: Alberto
To: Greger V. Teigre ;
serusers@lists.iptel.org
Cc: Daniel Sirera
Sent: Wednesday, September 07, 2005
10:00 AM
Subject: Re: [Serusers] Compiling SER 0.9.3
> Sorry,
where? ( I am novice )
> My ser.cfg is:
>
> #
> # $Id:
ser.cfg,v 1.25.2.1 2005/02/18 14:30:44 andrei Exp $
> #
> # simple
quick-start config script
> #
> # ----------- global configuration
parameters ------------------------
> #debug=3 # debug level (cmd line:
-dddddddddd)
> #fork=yes
> #log_stderror=no # (cmd line: -E)
>
/* Uncomment these lines to enter debugging mode
> fork=no
>
log_stderror=yes
> */
> check_via=no # (cmd. line: -v)
>
dns=no # (cmd. line: -r)
> rev_dns=no # (cmd. line: -R)
>
#port=5060
> #children=4
> fifo="/tmp/ser_fifo"
> #
------------------ module loading ----------------------------------
> #
Uncomment this if you want to use SQL database
> loadmodule
"/usr/local/lib/ser/modules/mysql.so"
> loadmodule
"/usr/local/lib/ser/modules/sl.so"
> loadmodule
"/usr/local/lib/ser/modules/tm.so"
> loadmodule
"/usr/local/lib/ser/modules/rr.so"
> loadmodule
"/usr/local/lib/ser/modules/maxfwd.so"
> loadmodule
"/usr/local/lib/ser/modules/usrloc.so"
> loadmodule
"/usr/local/lib/ser/modules/registrar.so"
> loadmodule
"/usr/local/lib/ser/modules/textops.so"
> # Uncomment this if you want
digest authentication
> # mysql.so must be loaded !
> loadmodule
"/usr/local/lib/ser/modules/auth.so"
> loadmodule
"/usr/local/lib/ser/modules/auth_db.so"
> # ----------------- setting
module-specific parameters ---------------
> # -- usrloc params --
>
modparam("usrloc", "db_mode", 0)
> # Uncomment this if you want to use SQL
database
> # for persistent storage and comment the previous line
>
modparam("usrloc", "db_mode", 2)
> # -- auth params --
> # Uncomment
if you are using auth module
> #
> modparam("auth_db",
"calculate_ha1", yes)
> #
> # If you set "calculate_ha1" parameter
to yes (which true in this
> config), # uncomment also the following
parameter)
> #
> modparam("auth_db", "password_column",
"password")
> # -- rr params --
> # add value to ;lr param to make
some broken UAs happy
> modparam("rr", "enable_full_lr", 1)
> #
------------------------- request routing logic -------------------
> #
main routing logic
>
> <------------ CUT ------------------
>
>
> ----- Original Message -----
> From: Greger V.
Teigre
> To: Alberto ; serusers@lists.iptel.org
> Cc: Daniel
Sirera
> Sent: Wednesday, September 07, 2005 9:41 AM
> Subject: Re:
[Serusers] Compiling SER 0.9.3
>
>
> 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.