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