The database schema does not match SER version. You will need to recreate the database using ser_mysql.sh script bundled with the ser version you are using. I recommend to backup your data first.
Jan.
On 07-03 17:10, Daniel Poulsen wrote:
Hi;
I've noticed that if I disable contact storage mode ("usrloc", db_mode", 0), I can start SER just fine. Does anybody have any thoughts on that? This is a clean install of 0.9.0 with a config that worked just fine with 0.8.14.
Thanks again, Dan
On Fri, 4 Mar 2005 11:44:37 -0500, Daniel Poulsen dpoulsen@gmail.com wrote:
Hi,
I saw another serusers post on this, but didn't find an answer. I have a vanilla install of 0.9.0 on a freshly built debian box. When I run ser, I get:
Mar 4 11:34:52 sip-failover ser[5055]: Maxfwd module- initializing Mar 4 11:34:52 sip-failover ser[5055]: register_udomain(): Invalid table version (use ser_mysql.sh reinstall) Mar 4 11:34:52 sip-failover ser[5055]: domain_fixup(): Error while registering domain Mar 4 11:34:52 sip-failover ser[5055]: ERROR: fix_expr : fix_actions error
If I run ser_mysql.sh reinstall, I get different errors:
Mar 4 11:36:42 sip-failover ser[5102]: table_version(): Invalid number of rows received: 2, uri Mar 4 11:36:42 sip-failover ser[5102]: ERROR: uri_db:mod_init(): Error while querying table version Mar 4 11:36:42 sip-failover ser[5102]: init_mod(): Error while initializing module uri_db
As the previous poster defailed, the "invalid number" error occurs because the ser_mysql.sh script creates duplicate entries in the version table. The quesion is, what table version sill satisfy 'register_udomain()'?
Currently, I have:
mysql> select * from version; +-----------------------+---------------+ | table_name | table_version | +-----------------------+---------------+ | subscriber | 5 | | reserved | 1 | | phonebook | 1 | | pending | 4 | | missed_calls | 2 | | location | 6 | | grp | 2 | | event | 1 | | aliases | 6 | | active_sessions | 1 | | acc | 2 | | config | 1 | | silo | 3 | | realm | 1 | | domain | 1 | | uri | 1 | | server_monitoring | 1 | | server_monitoring_agg | 1 | | trusted | 1 | | usr_preferences | 1 | | preferences_types | 1 | | admin_privileges | 1 | | calls_forwarding | 1 | | speed_dial | 1 | +-----------------------+---------------+ 24 rows in set (0.00 sec)
Thank you for your time,
Dan Poulsen
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers