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:[email protected]] Sent: Mon 16/03/2009 14:26 To: [email protected] 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:ba...@localhost/sermyadmin" modparam("presence|presence_xml|group|permissions|auth_db|uri_db|usrloc", "db_url", "mysql://sermyadmin:ba...@localhost/sermyadmin") modparam("domain", "db_url", "mysql://sermyadmin:ba...@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:ba...@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".
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
