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(a)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/REA…
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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers