AW: [Serusers] dbtext: table not loaded. example desired

[Müller Thorsten]

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>