24 Jan
2006
24 Jan
'06
5:22 p.m.
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(a)sbcglobal.net>
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