RE: [Serusers] Working ser.cfg with mySQL authentication

Thanks Leon - that seem to have fixed that problem. Graham Lewis -----Original Message----- From: Leon Sun [mailto:leon.sun@keywestcommunications.com] Sent: 27 April 2005 20:11 To: info(a)beeplove.com; Graham Lewis; serusers(a)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(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of m36828253-1(a)imap.1and1.com Sent: April 27, 2005 10:02 AM To: graham.lewis(a)spitfire.co.uk; serusers(a)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(a)imap.1and1.com [mailto:m36828253-1@imap.1and1.com] Sent: 27 April 2005 17:36 To: Graham Lewis; serusers(a)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(a)spitfire.co.uk Date: Wed, 27 Apr 2005 17:20:15 +0100 To: serusers(a)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(a)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(a)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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers