[OpenSIPS-Users] Error using MySQL with opensips

[Uwe Kastens]

Hi,

Maybe you have forgotten to create the tables for opensips?
 opensipsdbctl create <db name or db_path, optional> .....(creates a new
database)

opensips is missing the version table
BR

Uwe


anurag schrieb:
> 
> 
> Hi,
> 
>  
> 
> I’m new to OpenSIPs. I want to use OpenSIPs as Presence server.
> 
>  
> 
> I’ve compiled OpenSIPs (1.5.1) for presence server and installed it
> 
> on Linux. Also, I’ve enabled presence parameters in config file with
> 
> mysql database.
> 
>  
> 
> My DB details are: User-> opensips
> 
>                                       Passwd->opensipsrw
> 
>                                       DBname->test
> 
>  
> 
> While initializing opensips in this config I’m getting following error:
> 
>  
> 
> Jul  2 03:00:43 [16521] DBG:db_mysql:db_mysql_new_connection: server
> version is 5.0.46-enterprise-log
> 
> Jul  2 03:00:43 [16521] ERROR:db_mysql:db_mysql_submit_query: driver
> error on query: Table 'test.version' doesn't exist
> 
> Jul  2 03:00:43 [16521] ERROR:core:db_do_query: error while submitting
> query
> 
> Jul  2 03:00:43 [16521] ERROR:core:db_table_version: error in db_query
> 
> Jul  2 03:00:43 [16521] ERROR:core:db_check_table_version: querying
> version for table presentity
> 
> Jul  2 03:00:43 [16521] ERROR:presence:mod_init: error during table
> version check
> 
> Jul  2 03:00:43 [16521] ERROR:core:init_mod: failed to initialize module
> presence
> 
> Jul  2 03:00:43 [16521] ERROR:core:main: error while initializing modules
> 
> Jul  2 03:00:43 [16521] DBG:presence_xml:destroy: start
> 
>  
> 
> Here is my config (from opensips.cfg):
> 
>  
> 
> # ----- presence params -----
> 
> /* uncomment the following lines if you want to enable presence */
> 
> #modparam("presence|presence_xml", "db_url",
> "mysql://opensips:opensipsrw@192.168.8.76/opensips")
> 
> modparam("presence|presence_xml", "db_url",
> "mysql://opensips:opensipsrw@192.168.8.76/test")
> 
> modparam("presence_xml", "force_active", 1)
> 
> modparam("presence", "server_address", "sip:192.168.8.83:6060")
> 
>  
> 
> Pls help!
> 
>  
> 
> Thanx in advance,
> 
> Anurag
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users


-- 

kiste lat: 54.322684, lon: 10.13586