Hello,
On 07/29/05 11:16, Müller Thorsten wrote:
Hi all,
I try to set up ser with dbtext as authentication basis. I run in some problems because the database is not found: DBT:db_query: table not loaded.
After some googling a found that Cesc [cesc.santa@gmail.com] had also done some work with dbtext and mailed that to "serusers" or "serdev" mailinglists
In a mail from May and June 05 he told that he has written a "serctl" for dbtext and a script to produce the necessary files.
Has somebody got these things and can mail me these files! I could not found them in the mailing history.
Has somebody also dealed with dbtext and can give me some example files for ser.cfg and dbtext files for "authentication/subscriber" and "location".
rhe readme file of dbtext module has some examples of table structures as well as a simple config file.
http://cvs.berlios.de/cgi-bin/viewcvs.cgi/ser/sip_router/modules/dbtext/READ...
Daniel
Thanks in advance
Thorsten Mueller
ser 0.8.14 cross-compiled for arm My ser.cfg: #################################################### ... # Added by mt for authentication with dbtext loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_db.so" loadmodule "/usr/local/lib/ser/modules/dbtext.so"
modparam("auth_db", "db_url","dbtext:///var/dbtext/ser")
# -- auth params -- modparam("auth_db", "calculate_ha1", 1) modparam("auth_db", "password_column", "password") modparam("auth_db", "user_column", "username") modparam("auth_db", "domain_column", "domain") ...
if (uri==myself) {
if (method=="REGISTER") { if (!www_authorize("domain.com", "subscriber")) { www_challenge("domain.com", "0"); break; }; save("location"); break; }... #####################################################
I have a file in /var/dbtext/ser which is called "subscriber": ##################################################### username(str) password(str) ha1(str) domain(str) ha1b(str) suser:supasswd:xxx:domain.com:xxx #####################################################
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers