<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.6944.0">
<TITLE>dbtext: table not loaded. example desired</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi all,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I try to set up ser with dbtext as authentication basis. I run in some problems because the database is not found:</FONT>
<BR><FONT SIZE=2 FACE="Arial">DBT:db_query: table not loaded.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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</FONT></P>
<P><FONT SIZE=2 FACE="Arial">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.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Has somebody got these things and can mail me these files! I could not found them in the mailing history.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Has somebody also dealed with dbtext and can give me some example files for ser.cfg and dbtext files for "authentication/subscriber" and "location".</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Thanks in advance</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thorsten Mueller</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">ser 0.8.14 cross-compiled for arm</FONT>
<BR><FONT SIZE=2 FACE="Arial">My ser.cfg:</FONT>
<BR><FONT SIZE=2 FACE="Arial">####################################################</FONT>
<BR><FONT SIZE=2 FACE="Arial">...</FONT>
<BR><FONT SIZE=2 FACE="Arial"># Added by mt for authentication with dbtext</FONT>
<BR><FONT SIZE=2 FACE="Arial">loadmodule "/usr/local/lib/ser/modules/auth.so"</FONT>
<BR><FONT SIZE=2 FACE="Arial">loadmodule "/usr/local/lib/ser/modules/auth_db.so"</FONT>
<BR><FONT SIZE=2 FACE="Arial">loadmodule "/usr/local/lib/ser/modules/dbtext.so"</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">modparam("auth_db", "db_url","dbtext:///var/dbtext/ser")</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"># -- auth params --</FONT>
<BR><FONT SIZE=2 FACE="Arial">modparam("auth_db", "calculate_ha1", 1)</FONT>
<BR><FONT SIZE=2 FACE="Arial">modparam("auth_db", "password_column", "password")</FONT>
<BR><FONT SIZE=2 FACE="Arial">modparam("auth_db", "user_column", "username")</FONT>
<BR><FONT SIZE=2 FACE="Arial">modparam("auth_db", "domain_column", "domain")</FONT>
<BR><FONT SIZE=2 FACE="Arial">...</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">if (uri==myself) {</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"> if (method=="REGISTER") {</FONT>
<BR>
<BR><FONT SIZE=2 FACE="Arial"> if (!www_authorize("domain.com", "subscriber")) {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> www_challenge("domain.com", "0");</FONT>
<BR><FONT SIZE=2 FACE="Arial"> break;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> };</FONT>
<BR><FONT SIZE=2 FACE="Arial"> save("location");</FONT>
<BR><FONT SIZE=2 FACE="Arial"> break;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> } </FONT>
<BR><FONT SIZE=2 FACE="Arial">...</FONT>
<BR><FONT SIZE=2 FACE="Arial">#####################################################</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I have a file in /var/dbtext/ser which is called "subscriber":</FONT>
<BR><FONT SIZE=2 FACE="Arial">#####################################################</FONT>
<BR><FONT SIZE=2 FACE="Arial">username(str) password(str) ha1(str) domain(str) ha1b(str)</FONT>
<BR><FONT SIZE=2 FACE="Arial">suser:supasswd:xxx:domain.com:xxx</FONT>
<BR><FONT SIZE=2 FACE="Arial">#####################################################</FONT>
</P>
</BODY>
</HTML>