[Serusers] dbtext: table not loaded. example desired

[Daniel-Constantin Mierla]

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 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".
>
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/README?rev=HEAD&content-type=text/vnd.viewcvs-markup

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 at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>  
>