[Serusers] dbtext: table not loaded. example desired

[Cesc]

Hi,

Indeed, i wrote that serctl.dbtext script ... 

I am attaching it. This is the version i sent some weeks ago, which
made its way into the Openser cvs ... i think it is available from
Openser cvs head, development version, 0.10.x ...

Anyway, read the script first, you need to set up a couple of
environment variables so it knows you want to run with dbtext, and
where to find/place the files. The help command will provide useful
...

There is also a create command, which dumps the basic structure for
the files. The rest, it is just like normal serctl parameters (or as
close as it can be ... text files and grep is not as powerful as
mysql).

Regards,

Cesc


On 7/29/05, Müller Thorsten <Thorsten.Mueller at vierling.de> 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". 
> 
> 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
> 
> 
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: serctl.dbtext.zip
Type: application/zip
Size: 8957 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050729/c2554449/attachment.zip>