Hi all,
I've tried to set up a ser-0.8.14 system to authenticate users from a MySQL database. I've read most of the documentation on iptel.org including all examples that I've found on this list.
After some major tweaking with the ser.cfg file, I cannot get ser to fetch information from the database. The database is up and running, and I get no errors from the db connection. SerWeb is also working fine, but it ends up with the telephone being rejected when trying to REGISTER with ser.
Is there some kind person that would like to share your ser.cfg ? I just need a working example to get the "register" method to fetch the username and password from the database.
Thanks! Johan
Hi, take a look here
http://lists.iptel.org/pipermail/serusers/2004-August/010353.html
There is my ser.cfg.
"Normal Users" and "NAT users" can REGISTER on a MYSQL DB.
I f the problem persist check that your DB server is well configured.
Regards, Charles
Johan Landerholm writes:
Hi all,
I've tried to set up a ser-0.8.14 system to authenticate users from a MySQL database. I've read most of the documentation on iptel.org including all examples that I've found on this list.
After some major tweaking with the ser.cfg file, I cannot get ser to fetch information from the database. The database is up and running, and I get no errors from the db connection. SerWeb is also working fine, but it ends up with the telephone being rejected when trying to REGISTER with ser.
Is there some kind person that would like to share your ser.cfg ? I just need a working example to get the "register" method to fetch the username and password from the database.
Thanks! Johan
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
PS : you should remove lines
loadmodule "/usr/local/lib/ser/modules/pdt.so"
modparam("pdt", "db_url", "sql://pdt:pdt_password at localhost/pdt") modparam("pdt", "db_table", "domains") modparam("pdt", "prefix", "2") modparam("pdt", "terminator",0) #modparam("pdt", "start_range", 200) #modparam("pdt", "hsize_2pow", 2)
prefix2domain();
This lines serve to configure pdt module wich can convert a sip adresse with prefix in a domain name (i.e. 23330456@domain.com -> 456@other_domain.com)
Charles