<!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.2523" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2>I am running SER and MYSQL on Solaris 8 and have
the latest package of both running. Ser will run fine as standalone
without any connection to MYSQL, but as soona s I try to connect it with MYSQL I
get an error. I have it pasted here and after is my config
file:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>bash-2.03# ser<BR> 0(9289) loading module
/usr/local/lib/ser/modules/mysql.so<BR> 0(9289) loading module
/usr/local/lib/ser/modules/sl.so<BR> 0(9289) loading module
/usr/local/lib/ser/modules/tm.so<BR> 0(9289) loading module
/usr/local/lib/ser/modules/rr.so<BR> 0(9289) loading module
/usr/local/lib/ser/modules/maxfwd.so<BR> 0(9289) loading module
/usr/local/lib/ser/modules/usrloc.so<BR> 0(9289) loading module
/usr/local/lib/ser/modules/registrar.so<BR> 0(9289) loading module
/usr/local/lib/ser/modules/auth.so<BR> 0(9289) loading module
/usr/local/lib/ser/modules/auth_db.so<BR> 0(9289) set_mod_param_regex:
usrloc matches module usrloc<BR> 0(9289) set_mod_param_regex: found
<db_mode> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]<BR> 0(9289) set_mod_param_regex:
auth_db matches module auth_db<BR> 0(9289) set_mod_param_regex: found
<password_column> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]<BR> 0(9289) set_mod_param_regex: rr
matches module rr<BR> 0(9289) set_mod_param_regex: found
<enable_full_lr> in module rr
[/usr/local/lib/ser/modules/rr.so]<BR> 0(9289) find_export: found
<mf_process_maxfwd_header> in module maxfwd_module
[/usr/local/lib/ser/modules/maxfwd.so]<BR> 0(9289) find_export: found
<sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]<BR> 0(9289) parse error (79,16-23):
syntax error<BR> 0(9289) parse error (79,16-23): equal/!= operator
expected<BR> 0(9289) find_export: found <sl_send_reply> in module
sl_module [/usr/local/lib/ser/modules/sl.so]<BR> 0(9289) find_export: found
<record_route> in module rr
[/usr/local/lib/ser/modules/rr.so]<BR> 0(9289) find_export: found
<loose_route> in module rr
[/usr/local/lib/ser/modules/rr.so]<BR> 0(9289) find_export: found
<t_relay> in module tm [/usr/local/lib/ser/modules/tm.so]<BR> 0(9289)
find_export: found <save> in module registrar
[/usr/local/lib/ser/modules/registrar.so]<BR> 0(9289) find_export: found
<lookup> in module registrar
[/usr/local/lib/ser/modules/registrar.so]<BR> 0(9289) find_export: found
<sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]<BR> 0(9289) find_export: found
<t_relay> in module tm [/usr/local/lib/ser/modules/tm.so]<BR> 0(9289)
find_export: found <sl_reply_error> in module sl_module
[/usr/local/lib/ser/modules/sl.so]<BR>ERROR: bad config file (2
errors)<BR> 0(9289) DEBUG: tm_shutdown : start<BR> 0(9289) DEBUG:
tm_shutdown : empting hash table<BR> 0(9289) DEBUG: tm_shutdown: releasing
timers<BR> 0(9289) DEBUG: tm_shutdown : removing
semaphores<BR> 0(9289) DEBUG: tm_shutdown : done<BR> 0(9289)
shm_mem_destroy<BR> 0(9289) destroying the shared memory lock</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>--------------- CONFIG FILE
----------------------------------</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>#<BR># $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15
andrei Exp $<BR>#<BR># simple quick-start config script<BR>#</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># ----------- global configuration parameters
------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>debug=33 # debug level
(cmd line: -dddddddddd)<BR>#fork=yes<BR>log_stderror=yes # (cmd line:
-E)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>/* Uncomment these lines to enter debugging
mode<BR>debug=7<BR>fork=no<BR>log_stderror=yes<BR>*/</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>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"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># ------------------ module loading
----------------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># Uncomment this if you want to use SQL
database<BR>loadmodule "/usr/local/lib/ser/modules/mysql.so"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>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"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># 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"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># ----------------- setting module-specific
parameters ---------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># -- usrloc params --</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>#modparam("usrloc", "db_mode",
0)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># Uncomment this if you want to use SQL
database<BR># for persistent storage and comment the previous
line<BR>modparam("usrloc", "db_mode", 2)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># -- auth params --<BR># Uncomment if you are using
auth module</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>#modparam("auth_db", "calculate_ha1",
yes)<BR>#<BR># If you set "calculate_ha1" parameter to yes (which true in this
config),<BR># uncomment also the following
parameter)<BR>#<BR>modparam("auth_db", "password_column",
"password")</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># -- rr params --<BR># add value to ;lr param to
make some broken UAs happy<BR>modparam("rr", "enable_full_lr", 1)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># ------------------------- request routing
logic -------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># main routing logic</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>route{</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> # initial sanity checks -- messages
with<BR> # max_forwards==0, or excessively long requests<BR> if
(!mf_process_maxfwd_header("10")) {<BR> sl_send_reply("483","Too Many
Hops");<BR> break;<BR> };<BR> if ( msg:len max_len )
{<BR> sl_send_reply("513", "Message too
big");<BR> break;<BR> };</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> # we record-route all messages -- to make
sure that<BR> # subsequent messages will go through our proxy;
that's<BR> # particularly good if upstream and downstream
entities<BR> # use different transport
protocol<BR> record_route();<BR> # loose-route processing<BR> if
(loose_route()) {<BR> t_relay();<BR> break;<BR> };</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> # if the request is for other domain use
UsrLoc<BR> # (in case, it does not work, use the following
command<BR> # with proper names and addresses in it)<BR> if
(uri==myself) {</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> if (method=="REGISTER") {</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># Uncomment this if you want to use digest
authentication<BR># if (!www_authorize("iptel.org", "subscriber")) {<BR>#
www_challenge("iptel.org", "0");<BR># break;<BR># };</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2> save("location");<BR> break;<BR> };</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> # native SIP destinations are handled using
our USRLOC DB<BR> if (!lookup("location")) {<BR> sl_send_reply("404",
"Not Found");<BR> break;<BR> };<BR> };<BR> # forward to
current uri now; use stateful forwarding; that<BR> # works reliably even if
we forward from TCP to UDP<BR> if (!t_relay())
{<BR> sl_reply_error();<BR> };</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>}</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Best regards,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Axel</FONT></DIV></BODY></HTML>