<!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.2800.1479" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I am trying to setup ser to use a posgresql
databse. Everythig is ok until i try to register to SIP server with SjPhone when
i get the following errors:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>PG[129] connect_db Error while parsing it
Register<BR>PG[488] begin_transaction no connection, FATAL -3!<BR>get_ha1():
Error while querying database</FONT></DIV>
<DIV><FONT face=Arial size=2><BR> Any ideeas ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>This is my ser.cfg</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=3 # debug level
(cmd line: -dddddddddd)<BR>#fork=yes<BR>#log_stderror=no # (cmd line:
-E)</FONT></DIV>
<DIV> </DIV><FONT face=Arial size=2>
<DIV><BR># Uncomment these lines to enter debugging mode
<BR>#debug=3<BR>fork=no<BR>log_stderror=no<BR>listen=193.***.***.***</DIV>
<DIV> </DIV>
<DIV>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>alias=test.ro</DIV>
<DIV> </DIV>
<DIV># ------------------ module loading
----------------------------------</DIV>
<DIV> </DIV>
<DIV># Uncomment this if you want to use SQL database<BR>loadmodule
"/usr/local/lib/ser/modules/postgres.so"</DIV>
<DIV> </DIV>
<DIV>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"</DIV>
<DIV> </DIV>
<DIV># 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"</DIV>
<DIV> </DIV>
<DIV># ----------------- setting module-specific parameters
---------------</DIV>
<DIV> </DIV>
<DIV># -- usrloc params --</DIV>
<DIV> </DIV>
<DIV>#modparam("usrloc", "db_mode", 0)</DIV>
<DIV> </DIV>
<DIV># Uncomment this if you want to use SQL database <BR># for persistent
storage and comment the previous line<BR>modparam("usrloc", "db_mode", 0)</DIV>
<DIV> </DIV>
<DIV># -- 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 config), <BR># uncomment
also the following parameter)<BR>#<BR>modparam("auth_db", "password_column",
"password")</DIV>
<DIV> </DIV>
<DIV>modparam ("auth_db","db_url",
"sql://blahblah:blahblah@localhost:5432/ser")</DIV>
<DIV> </DIV>
<DIV># -- rr params --<BR># add value to ;lr param to make some broken UAs
happy<BR>modparam("rr", "enable_full_lr", 1)</DIV>
<DIV> </DIV>
<DIV># ------------------------- request routing logic
-------------------</DIV>
<DIV> </DIV>
<DIV># main routing logic</DIV>
<DIV> </DIV>
<DIV>route{</DIV>
<DIV> </DIV>
<DIV> # 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> };</DIV>
<DIV> </DIV>
<DIV> # 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> };</DIV>
<DIV> </DIV>
<DIV> # 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=~test.ro) {<BR> log
(1,"Cerere pt test.ro\n");<BR> if (method=="REGISTER")
{<BR> log (1,"Am primit Register\n");<BR># Uncomment this if you want
to use digest authentication<BR> if (!www_authorize("test.ro",
"subscriber")) {<BR> www_challenge("test.ro",
"0");<BR> break;<BR> };</DIV>
<DIV> </DIV>
<DIV> save("location");<BR> log (1,"User
Existent\n");<BR> break;<BR> };<BR> #
native SIP destinations are handled using our USRLOC DB<BR> if
(!lookup("location")) {<BR> sl_send_reply("404", "Not
Found");<BR> log (1,"User
Inexistent\n");<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> };</DIV>
<DIV> </DIV>
<DIV>}</DIV>
<DIV> </DIV>
<DIV></FONT> </DIV></BODY></HTML>