[Serusers] dbtext: table not loaded. example desired

Müller Thorsten Thorsten.Mueller at vierling.de
Fri Jul 29 10:16:43 CEST 2005


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 at 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".

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
#####################################################

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050729/5ce1ff2d/attachment.htm>


More information about the sr-users mailing list