[OpenSIPS-Users] Error using MySQL with opensips

[anurag]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090703/63ac622f/attachment-0001.htm