New subject: Fwd: [Serusers] using dbtext module for authentication

24 Jan 2006

It seems that you do not have "version" table. that table contains
version of each table in your database, this is used for sanity
checking.

You can take a look into ser_mysql.sh and copy the contents of version
table from corresponding sql table.

  Jan.

On 20-01-2006 16:08, Yi Zheng wrote:
...
  Hi,

   I have the following authentication related stuff in my ser.cfg file. However ser
server failed to start with the following messages logged. I have a directory
/root/dbtext/ser to store tables (such as subscriber). What could be wrong? Thanks,

   log messages
   --------------------
   Jan 20 13:44:08 my ./ser[4424]: table_version(): Error in db_query 
 Jan 20 13:44:08 my ./ser[4424]: authdb_fixup: Error while querying table
  version 
 Jan 20 13:44:08 my ./ser[4424]: ERROR: fix_expr : fix_actions error 

   My ser.cfg
   ---------------
   loadmodule
"/home/ser/presence/ser-0.10.99-dev30-tm-timers-pa-3/lib/ser/modules/dbtext.so"
 loadmodule
"/home/ser/presence/ser-0.10.99-dev30-tm-timers-pa-3/lib/ser/modules/auth.so"
 loadmodule
"/home/ser/presence/ser-0.10.99-dev30-tm-timers-pa-3/lib/ser/modules/auth_db.so"

   # -- auth params --
 # Uncomment if you are using auth module
 #
 modparam("auth_db", "calculate_ha1", yes)
 #
 # If you set "calculate_ha1" parameter to yes (which true in this config),
 # uncomment also the following parameter)
 #
 modparam("auth_db", "password_column", "password")
   # -- rr params --
 # add value to ;lr param to make some broken UAs happy
 modparam("rr", "enable_full_lr", 1)
   modparam("usrloc", "db_mode", 0)
 modparam("pa", "use_db", 0)
 modparam("auth_db", "db_url", "dbtext:///root/dbtext/ser")

 /root/dbtext/ser/subscriber
   -------------------------------------
   username(str) password(str) ha1(str) domain(str) ha1b(str)
 suser:supasswd:xxx:iptel.org:xxx
 test:test123::my.cisco.com::

 Note: forwarded message attached. 
...
  Date: Fri, 20 Jan 2006 11:36:18 -0800 (PST)
 From: Yi Zheng &lt;yizheng(a)sbcglobal.net&gt;
 Subject: [Serusers] using dbtext module for authentication
 To: serusers(a)lists.iptel.org

 Hi,

   I don't have enough space for MySql and hence want to try to use a plain text file
(dbtext module) for authentication purpose. Just wondering whether it works properly with
SER and what are the limitations besides limited space. Thanks,

   - ming  
...
  _______________________________________________
 Serusers mailing list
 serusers(a)lists.iptel.org
 http://lists.iptel.org/mailman/listinfo/serusers 

...
  _______________________________________________
 Serusers mailing list
 serusers(a)lists.iptel.org
 http://lists.iptel.org/mailman/listinfo/serusers 

Re: Fwd: [Serusers] using dbtext module for authentication