[OpenSIPS-Users] database sermyadmin+opensips

troxlinux xserverlinux at gmail.com
Mon Mar 16 18:26:46 CET 2009


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



More information about the Users mailing list