[OpenSIPS-Users] database sermyadmin+opensips

[Flávio Eduardo de Andrade]

Hi Ricky, 
 
It is an old definition in the presence tables. Delete the presence related tables and recreate them with the mysql scripts in the opensips source code. /scripts/mysql/.... It is fixed in the newest version. 
 
Flavio

________________________________

From: troxlinux [mailto:xserverlinux at gmail.com]
Sent: Mon 16/03/2009 14:26
To: users at lists.opensips.org
Cc: Flávio Eduardo de Andrade
Subject: database sermyadmin+opensips



Hi list, I have problems annexing the sermyadmin database with
opensips, I show them my configuration with opensips to see where I
have the error:

#DEFAULT_DB_URL="mysql://sermyadmin:baco2@localhost/sermyadmin"
modparam("presence|presence_xml|group|permissions|auth_db|uri_db|usrloc",
"db_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")
modparam("domain", "db_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")
modparam("domain", "db_mode", 1)
modparam("auth_db", "password_column", "ha1")
modparam("auth_db", "password_column_2", "ha1b")
modparam("presence_xml", "force_active", 1)
modparam("presence", "max_expires", 3600)
modparam("presence", "server_address", "sip:192.168.10.3:5060")
modparam("permissions", "db_mode", 1)
modparam("permissions", "trusted_table", "trusted")
modparam("group", "group_column", "grp")
modparam("avpops", "avp_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")
modparam("avpops", "avp_table", "usr_preferences")


opensipsctrlrc

DBNAME=sermyadmin

# database path used by dbtext or db_berkeley
# DB_PATH="/usr/local/etc/opensips/dbtext"

## database read/write user

DBRWUSER=sermyadmin

## password for database read/write user
DBRWPW="baco2"

## database read only user
DBROUSER=sermyadmin

## password for database read only user
DBROPW=baco2


log openser

Mar 16 11:02:47 twoxserver /sbin/opensips[9238]:
ERROR:core:db_check_table_version: invalid version 1 for table
watchers found, expected 3
Mar 16 11:02:47 twoxserver /sbin/opensips[9238]:
ERROR:presence:mod_init: error during table version check
Mar 16 11:02:47 twoxserver /sbin/opensips[9238]: ERROR:core:init_mod:
failed to initialize module presence
Mar 16 11:02:47 twoxserver /sbin/opensips[9238]: ERROR:core:main:
error while initializing modules

some idea where my error can be?

regardss

--
rickygm

http://gnuforever.homelinux.com <http://gnuforever.homelinux.com/> 




"Vai contratar um canal E1 ou SIP? Além de oferecermos o melhor preço, na contratação de um canal E1 ou SIP GVT você recebe um desconto no projeto que pode chegar a até 50%". Consulte-nos sobre a viabilidade técnica e econômica".

"Vai contratar um canal de dados? Além de oferecermos o melhor preço, na contratação de um canal de dados corporativo GVT você recebe um desconto no projeto que pode chegar a até 50%". Consulte-nos sobre a viabilidade técnica e econômica".
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090316/01a16c33/attachment.htm