This is a fresh installation. I used sermyadmin-install v1.2.6 from their website. This created a new database.
How can we upgrade the tables? Regards, Leon -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Saúl Ibarra Sent: Friday, 14 August 2009 4:35 PM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Can't run Opensips after install SerMyAdmin Have you upgraded from any previous release? The error is telling you that the subscriber table is version 6, but version 7 is needed... You may need to upgrade your tables. 2009/8/14, Leon Li <[email protected]>: > Hi, > > > > After I installed SerMyAdmin with provided install.sh, the web interface > is ok and user insertion is fine. However, opensips can't run and got > following errors from debug. > > > > Aug 13 18:39:21 [3716] DBG:db_mysql:db_mysql_connect: opening > connection: mysql://xxxx:x...@localhost/sermyadmin > > Aug 13 18:39:21 [3716] DBG:db_mysql:db_mysql_connect: connection type is > Localhost via UNIX socket > > Aug 13 18:39:21 [3716] DBG:db_mysql:db_mysql_connect: protocol version > is 10 > > Aug 13 18:39:21 [3716] DBG:db_mysql:db_mysql_connect: server version is > 5.0.51a-24+lenny1 > > Aug 13 18:39:21 [3716] DBG:core:db_do_query: SYNC-DBG - SELECT > successfully executed! > > Aug 13 18:39:21 [3716] DBG:core:db_new_result: allocate 28 bytes for > result set at 0x8193510 > > Aug 13 18:39:21 [3716] DBG:db_mysql:db_mysql_get_columns: 1 columns > returned from the query > > Aug 13 18:39:21 [3716] DBG:core:db_allocate_columns: allocate 16 bytes > for result columns at 0x8193548 > > Aug 13 18:39:21 [3716] DBG:db_mysql:db_mysql_get_columns: > RES_NAMES(0x819354c)[0]=[table_version] > > Aug 13 18:39:21 [3716] DBG:db_mysql:db_mysql_get_columns: use DB_INT > result type > > Aug 13 18:39:21 [3716] DBG:core:db_allocate_rows: allocate 28 bytes for > result rows and values at 0x8193560 > > Aug 13 18:39:21 [3716] DBG:db_mysql:db_mysql_str2val: converting INT [6] > > Aug 13 18:39:21 [3716] DBG:core:db_free_columns: freeing result columns > at 0x8193548 > > Aug 13 18:39:21 [3716] DBG:core:db_free_rows: freeing 1 rows > > Aug 13 18:39:21 [3716] DBG:core:db_free_row: freeing row values at > 0x8193568 > > Aug 13 18:39:21 [3716] DBG:core:db_free_rows: freeing rows at 0x8193560 > > Aug 13 18:39:21 [3716] DBG:core:db_free_result: freeing result set at > 0x8193510 > > Aug 13 18:39:21 [3716] DBG:core:db_free_result: SYNC-DBG - freeing > result! > > Aug 13 18:39:21 [3716] ERROR:core:db_check_table_version: invalid > version 6 for table subscriber found, expected 7 > > Aug 13 18:39:21 [3716] ERROR:auth_db:auth_fixup: error during table > version check. > > Aug 13 18:39:21 [3716] DBG:core:pool_remove: removing connection from > the pool > > Aug 13 18:39:21 [3716] ERROR:core:fix_actions: fixing failed (code=-1) > at cfg line 263 > > Aug 13 18:39:21 [3716] CRITICAL:core:fix_expr: fix_actions error > > Aug 13 18:39:21 [3716] ERROR:core:main: failed to fix configuration with > err code -1 > > > > I am user opensips 1.5.2. Please assist. > > > > Thanks > > Leon > > > > > > -- Enviado desde mi dispositivo móvil /Saúl http://www.saghul.net | http://www.sipdoc.net _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
