[OpenSIPS-Users] Can't run Opensips after install SerMyAdmin

[Bogdan-Andrei Iancu]

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:xxxx@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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>