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:opensip...@192.168.8.76/opensips") > > modparam("presence|presence_xml", "db_url", > "mysql://opensips:opensip...@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@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- kiste lat: 54.322684, lon: 10.13586 _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users