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