Fwd: [Serusers] using dbtext module for authentication

[Jan Janak]

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 <yizheng at sbcglobal.net>
> Subject: [Serusers] using dbtext module for authentication
> To: serusers at 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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers


> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers