Hi,
Thanks for replying.
However I am using DBTEXT instead of MySQL database so how does the version info apply to the dbtext tables?
Also I am looking at scripts/mysql/ser_mysql.sh and I did not see version info is generated. Please be more specific.
Thanks,
- ming
Jan Janak jan@iptel.org wrote: 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 Subject: [Serusers] using dbtext module for authentication To: serusers@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers