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