[Serusers] dbtext: table not loaded. example desired

[Cesc]

I would recommend you to use the serctl.dbtext script to generate the
files. It defines a standard order for the columns and their types,
which is needed if in the future you want to manage these files with
serctl.dbtext ... it is very static, but as i said, test tools are not
as powerful as sql ...

Cesc

On 7/29/05, Müller Thorsten <Thorsten.Mueller at vierling.de> wrote:
> Hi,
> 
> Thanks for your fast response!
> I read this readme file, but I'm stucked with it.
> 
> Which file or files do I need for dbtext authentication? Is there a special name necessary?
> 
> When I'm right I give the name in the ser.cfg with the following line
> 
>       if (!www_authorize("domain.com", "subscriber")) {
> 
> In my case "subscriber".
> And the directory where to find the file with the following line
> 
>         modparam("auth_db", "db_url","dbtext:///var/dbtext/ser")
> 
> in my case /var/dbtext/ser
> How can I use not plain password but encrypted ones and finally are three "x" enough for ha1 and ha1b
> or do I need to hash some values and write them down here?
> 
> Why does ser give me the reply "table not loaded", when these entries are correct meaning written after the README.
> How can I fill the "subscriber" file with users and passwords? Texteditor I think, because serctl is only for mysql.
> 
> Thanks
> 
> Thorsten Mueller
> 
> mt> -----Ursprüngliche Nachricht-----
> mt> Von: Daniel-Constantin Mierla [mailto:daniel at voice-system.ro]
> mt> Gesendet: Freitag, 29. Juli 2005 10:55
> mt> An: Müller Thorsten
> mt> Cc: serusers at lists.iptel.org
> mt> Betreff: Re: [Serusers] dbtext: table not loaded. example desired
> mt>
> mt>
> mt> Hello,
> mt>
> mt> On 07/29/05 11:16, Müller Thorsten wrote:
> mt>
> mt> > Hi all,
> mt> >
> mt> > I try to set up ser with dbtext as authentication basis.
> mt> I run in some
> mt> > problems because the database is not found:
> mt> > DBT:db_query: table not loaded.
> mt> >
> mt> > After some googling a found that Cesc
> mt> [cesc.santa at gmail.com] had also
> mt> > done some work with dbtext and mailed that to "serusers"
> mt> or "serdev"
> mt> > mailinglists
> mt> >
> mt> > In a mail from May and June 05 he told that he has
> mt> written a "serctl"
> mt> > for dbtext and a script to produce the necessary files.
> mt> >
> mt> > Has somebody got these things and can mail me these
> mt> files! I could not
> mt> > found them in the mailing history.
> mt> >
> mt> > Has somebody also dealed with dbtext and can give me some example
> mt> > files for ser.cfg and dbtext files for
> mt> "authentication/subscriber" and
> mt> > "location".
> mt> >
> mt> rhe readme file of dbtext module has some examples of table
> mt> structures
> mt> as well as a simple config file.
> mt>
> mt> http://cvs.berlios.de/cgi-bin/viewcvs.cgi/ser/sip_router/mod
> mt> ules/dbtext/README?rev=HEAD&content-type=text/vnd.viewcvs-markup
> mt>
> mt> Daniel
> mt>
> mt> > Thanks in advance
> mt> >
> mt> > Thorsten Mueller
> mt> >
> mt> > ser 0.8.14 cross-compiled for arm
> mt> > My ser.cfg:
> mt> > ####################################################
> mt> > ...
> mt> > # Added by mt for authentication with dbtext
> mt> > loadmodule "/usr/local/lib/ser/modules/auth.so"
> mt> > loadmodule "/usr/local/lib/ser/modules/auth_db.so"
> mt> > loadmodule "/usr/local/lib/ser/modules/dbtext.so"
> mt> >
> mt> > modparam("auth_db", "db_url","dbtext:///var/dbtext/ser")
> mt> >
> mt> > # -- auth params --
> mt> > modparam("auth_db", "calculate_ha1", 1)
> mt> > modparam("auth_db", "password_column", "password")
> mt> > modparam("auth_db", "user_column", "username")
> mt> > modparam("auth_db", "domain_column", "domain")
> mt> > ...
> mt> >
> mt> > if (uri==myself) {
> mt> >
> mt> >        if (method=="REGISTER") {
> mt> >
> mt> >              if (!www_authorize("domain.com", "subscriber")) {
> mt> >                www_challenge("domain.com", "0");
> mt> >                break;
> mt> >              };
> mt> >              save("location");
> mt> >              break;
> mt> >        }
> mt> > ...
> mt> > #####################################################
> mt> >
> mt> > I have a file in /var/dbtext/ser which is called "subscriber":
> mt> > #####################################################
> mt> > username(str) password(str) ha1(str) domain(str) ha1b(str)
> mt> > suser:supasswd:xxx:domain.com:xxx
> mt> > #####################################################
> mt> >
> mt> >-----------------------------------------------------------
> mt> -------------
> mt> >
> mt> >_______________________________________________
> mt> >Serusers mailing list
> mt> >serusers at lists.iptel.org
> mt> >http://lists.iptel.org/mailman/listinfo/serusers
> mt> >
> mt> >
> mt>
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>