[Serusers] Working ser.cfg with mySQL authentication

[Graham Lewis]

Thanks Leon - that seem to have fixed that problem.

Graham Lewis

-----Original Message-----
From: Leon Sun [mailto:leon.sun at keywestcommunications.com]
Sent: 27 April 2005 20:11
To: info at beeplove.com; Graham Lewis; serusers at lists.iptel.org
Subject: RE: [Serusers] Working ser.cfg with mySQL authentication


Delete 
modparam("auth_db|usrloc", "db_url", "mysql://ser:heslo@localhost/ser")

from your cfg. 

In my cfg(0.8.14), I never used it and it works.

-----Original Message-----
From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] On
Behalf Of m36828253-1 at imap.1and1.com
Sent: April 27, 2005 10:02 AM
To: graham.lewis at spitfire.co.uk; serusers at lists.iptel.org
Subject: RE: [Serusers] Working ser.cfg with mySQL authentication

According to error log, you should have syntax error in here:
fifo_db_url="mysql://ser:heslo@localhost/ser"

loadmodule "/usr/local/lib/ser/modules/mysql.so"


but these two lines looks good to me.
Are you sure, ser -E is using this configuration file?
why dont you try with -f switch, like ser -E -f /etc/ser/ser.cfg, assuming
your ser configuration file located at /et/ser/ser.cfg.


Thanks,
Mohammad



Here is the start of the ser.cfg that shows errors:

dns=no
rev_dns=no

fifo="/tmp/ser_fifo"
fifo_db_url="mysql://ser:heslo@localhost/ser"

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/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
modparam("auth_db|usrloc", "db_url", "mysql://ser:heslo@localhost/ser")
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("usrloc", "db_mode", 2)
modparam("rr", "enable_full_lr", 1)

route {

        # -----------------------------------------------------------------
        # Sanity Check Section
        # -----------------------------------------------------------------
 

# ser -E
 0(50633) parse error (5,1-12): syntax error
 0(50633) parse error (5,12-13): unknown config variable
 0(50633) parse error (7,1-11):
ERROR: bad config file (3 errors)


-----Original Message-----
From: m36828253-1 at imap.1and1.com [mailto:m36828253-1 at imap.1and1.com]
Sent: 27 April 2005 17:36
To: Graham Lewis; serusers at lists.iptel.org
Subject: RE: [Serusers] Working ser.cfg with mySQL authentication



HI Graham,

This log says, there have syntax error in your configuration file.
Why don't you post first 10/15 lines of you configuration file.

Thanks,
Mohammad



Original Message:
-----------------
From: Graham Lewis graham.lewis at spitfire.co.uk
Date: Wed, 27 Apr 2005 17:20:15 +0100
To: serusers at lists.iptel.org
Subject: [Serusers] Working ser.cfg with mySQL authentication


Does anyone have a working example of ser.cfg with mySQL authentication
they can share please.

I have version 03a of the Onsip "SER Getting Started" documentation but the
example given results is errors:

# ser
 0(49443) parse error (8,1-12): syntax error
 0(49443) parse error (8,12-13): unknown config variable
 0(49443) parse error (10,1-11):
ERROR: bad config file (3 errors)
#

I think the Onsip doc. authors acknowledge this but have not updated the
doc. yet.



Graham Lewis

_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .


_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .


_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers