Hi Leon, As far as I know, SerMyAdmin installs its own DB (including the tables for opensips). What I suspect is you installed a SerMyAdmin compatible with an older version of opensips than the one you have installed. That is why the DB (created by SerMyAdmin) is not compatible with OpenSIPS you are running.
Check on the SerMyAdmin to see what is the opensips version required for the SerMyAdmin you downloaded. Regards, Bogdan Leon Li wrote: > > 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 > > ------------------------------------------------------------------------ > > _______________________________________________ > 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
