[Serusers] Ser MySQL User Auth

Daniel-Constantin Mierla Daniel-Constantin.Mierla at fokus.fraunhofer.de
Fri Dec 10 11:10:55 CET 2004


On 12/09/04 20:42, Felipe Martins wrote:

>Hi everybody,
>
>	At this moment I have ser configured (remember, i'm very new to ser and sip servers), MySQL server is running with all his and ser tables created. I've added some users to the tables by typing
>
># serctl add testuser 1234 testuser at sipproxy.mundivox.com
>
>After that, I put two sip routers to auth at my sipserer. They've manage to auth at it but with any password. I looked for the mysql auth configuration at 'ser's admin guide' and 'ser.cfg' adn discovered that for this auth support I must configure the line above at ser.cfg: 
>
>modparam("usrloc", "db_url", "sql://ser:<password>@localhost/ser")
>
>So my line became: 
>
>modparam("usrloc", "/usr/local/mysql/data/ser", "sql://ser:heslo@localhost/ser")
>  
>
"db_url" is the name of the parameter to set for "usrloc" module, it is 
not the path where the ser database is located on your file system. The 
line should be:

modparam("usrloc", "db_url", "sql://ser:heslo@localhost/ser")

If you use CVS head version, change "sql://" in "mysql://".

Daniel

>
>But it returns the following Error Message: 
>
>ERROR: bad config file (3 errors)
>
>When I comment this line, ser server runs OK. 
>
>What am I doing wrong ?
>What is usrloc ?
>
>
>
>  
>




More information about the sr-users mailing list