<!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><FONT face=Arial size=2>Sorry, where? ( I am novice )</FONT></DIV>
<DIV><FONT face=Arial size=2>My ser.cfg is:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT size=2>
<DIV><FONT face=Arial>#</FONT></DIV>
<DIV><FONT face=Arial># $Id: ser.cfg,v 1.25.2.1 2005/02/18 14:30:44 andrei Exp
$</FONT></DIV>
<DIV><FONT face=Arial>#</FONT></DIV>
<DIV><FONT face=Arial># simple quick-start config script</FONT></DIV>
<DIV><FONT face=Arial>#</FONT></DIV>
<DIV><FONT face=Arial># ----------- global configuration parameters
------------------------</FONT></DIV>
<DIV><FONT face=Arial>#debug=3 # debug level (cmd line:
-dddddddddd)</FONT></DIV>
<DIV><FONT face=Arial>#fork=yes</FONT></DIV>
<DIV><FONT face=Arial>#log_stderror=no # (cmd line: -E)</FONT></DIV>
<DIV><FONT face=Arial>/* Uncomment these lines to enter debugging mode</FONT>
</DIV>
<DIV><FONT face=Arial>fork=no</FONT></DIV>
<DIV><FONT face=Arial>log_stderror=yes</FONT></DIV>
<DIV><FONT face=Arial>*/</FONT></DIV>
<DIV><FONT face=Arial>check_via=no # (cmd. line: -v)</FONT></DIV>
<DIV><FONT face=Arial>dns=no # (cmd. line: -r)</FONT></DIV>
<DIV><FONT face=Arial>rev_dns=no # (cmd. line: -R)</FONT></DIV>
<DIV><FONT face=Arial>#port=5060</FONT></DIV>
<DIV><FONT face=Arial>#children=4</FONT></DIV>
<DIV><FONT face=Arial>fifo="/tmp/ser_fifo"</FONT></DIV>
<DIV><FONT face=Arial># ------------------ module loading
----------------------------------</FONT></DIV>
<DIV><FONT face=Arial># Uncomment this if you want to use SQL
database</FONT></DIV>
<DIV><FONT face=Arial>loadmodule
"/usr/local/lib/ser/modules/mysql.so"</FONT></DIV>
<DIV><FONT face=Arial>loadmodule "/usr/local/lib/ser/modules/sl.so"</FONT></DIV>
<DIV><FONT face=Arial>loadmodule "/usr/local/lib/ser/modules/tm.so"</FONT></DIV>
<DIV><FONT face=Arial>loadmodule "/usr/local/lib/ser/modules/rr.so"</FONT></DIV>
<DIV><FONT face=Arial>loadmodule
"/usr/local/lib/ser/modules/maxfwd.so"</FONT></DIV>
<DIV><FONT face=Arial>loadmodule
"/usr/local/lib/ser/modules/usrloc.so"</FONT></DIV>
<DIV><FONT face=Arial>loadmodule
"/usr/local/lib/ser/modules/registrar.so"</FONT></DIV>
<DIV><FONT face=Arial>loadmodule
"/usr/local/lib/ser/modules/textops.so"</FONT></DIV>
<DIV><FONT face=Arial># Uncomment this if you want digest
authentication</FONT></DIV>
<DIV><FONT face=Arial># mysql.so must be loaded !</FONT></DIV>
<DIV><FONT face=Arial>loadmodule
"/usr/local/lib/ser/modules/auth.so"</FONT></DIV>
<DIV><FONT face=Arial>loadmodule
"/usr/local/lib/ser/modules/auth_db.so"</FONT></DIV>
<DIV><FONT face=Arial># ----------------- setting module-specific parameters
---------------</FONT></DIV>
<DIV><FONT face=Arial># -- usrloc params --</FONT></DIV>
<DIV><FONT face=Arial>modparam("usrloc", "db_mode", 0)</FONT></DIV>
<DIV><FONT face=Arial># Uncomment this if you want to use SQL database</FONT>
</DIV>
<DIV><FONT face=Arial># for persistent storage and comment the previous
line</FONT></DIV>
<DIV><FONT face=Arial>modparam("usrloc", "db_mode", 2)</FONT></DIV>
<DIV><FONT face=Arial># -- auth params --</FONT></DIV>
<DIV><FONT face=Arial># Uncomment if you are using auth module</FONT></DIV>
<DIV><FONT face=Arial>#</FONT></DIV>
<DIV><FONT face=Arial>modparam("auth_db", "calculate_ha1", yes)</FONT></DIV>
<DIV><FONT face=Arial>#</FONT></DIV>
<DIV><FONT face=Arial># If you set "calculate_ha1" parameter to yes (which true
in this config),</FONT> </DIV>
<DIV><FONT face=Arial># uncomment also the following parameter)</FONT></DIV>
<DIV><FONT face=Arial>#</FONT></DIV>
<DIV><FONT face=Arial>modparam("auth_db", "password_column",
"password")</FONT></DIV>
<DIV><FONT face=Arial># -- rr params --</FONT></DIV>
<DIV><FONT face=Arial># add value to ;lr param to make some broken UAs
happy</FONT></DIV>
<DIV><FONT face=Arial>modparam("rr", "enable_full_lr", 1)</FONT></DIV>
<DIV><FONT face=Arial># ------------------------- request routing logic
-------------------</FONT></DIV>
<DIV><FONT face=Arial># main routing logic</FONT></DIV>
<DIV>
<P><FONT face=Arial></FONT> </P>
<P><FONT face=Arial><------------ CUT ------------------ ></FONT></P>
<P><FONT face=Arial></FONT> </P></FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=greger@teigre.com href="mailto:greger@teigre.com">Greger V.
Teigre</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=alberto.ipt@telefonica.net
href="mailto:alberto.ipt@telefonica.net">Alberto</A> ; <A
title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=dsirera@teching.net
href="mailto:dsirera@teching.net">Daniel Sirera</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 07, 2005 9:41
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Serusers] Compiling SER
0.9.3</DIV>
<DIV><BR></DIV>
<DIV>Change the path in ser.cfg.</DIV>
<DIV>g-)</DIV>
<DIV>---- Original Message ----<BR>From: Alberto<BR>To: Greger V. Teigre ; <A
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A><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 -L$(LOCALBASE)/lib/mysql<BR>>>
\<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
directory<BR>>>
../../Makefile.rules:80: res.d: No such file or
directory<BR>>>
../../Makefile.rules:80: row.d: No such file or
directory<BR>>>
../../Makefile.rules:80: utils.d: No such file or
directory<BR>>>
../../Makefile.rules:80: val.d: No such file or
directory<BR>>> 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></BLOCKQUOTE></BODY></HTML>