<HTML dir=ltr><HEAD><TITLE>database sermyadmin+opensips</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6001.18203" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText41996 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi Ricky, </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>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. </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Flavio</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> troxlinux [mailto:xserverlinux@gmail.com]<BR><B>Sent:</B> Mon 16/03/2009 14:26<BR><B>To:</B> users@lists.opensips.org<BR><B>Cc:</B> Flávio Eduardo de Andrade<BR><B>Subject:</B> database sermyadmin+opensips<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Hi list, I have problems annexing the sermyadmin database with<BR>opensips, I show them my configuration with opensips to see where I<BR>have the error:<BR><BR>#DEFAULT_DB_URL="mysql://sermyadmin:baco2@localhost/sermyadmin"<BR>modparam("presence|presence_xml|group|permissions|auth_db|uri_db|usrloc",<BR>"db_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")<BR>modparam("domain", "db_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")<BR>modparam("domain", "db_mode", 1)<BR>modparam("auth_db", "password_column", "ha1")<BR>modparam("auth_db", "password_column_2", "ha1b")<BR>modparam("presence_xml", "force_active", 1)<BR>modparam("presence", "max_expires", 3600)<BR>modparam("presence", "server_address", "sip:192.168.10.3:5060")<BR>modparam("permissions", "db_mode", 1)<BR>modparam("permissions", "trusted_table", "trusted")<BR>modparam("group", "group_column", "grp")<BR>modparam("avpops", "avp_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")<BR>modparam("avpops", "avp_table", "usr_preferences")<BR><BR><BR>opensipsctrlrc<BR><BR>DBNAME=sermyadmin<BR><BR># database path used by dbtext or db_berkeley<BR># DB_PATH="/usr/local/etc/opensips/dbtext"<BR><BR>## database read/write user<BR><BR>DBRWUSER=sermyadmin<BR><BR>## password for database read/write user<BR>DBRWPW="baco2"<BR><BR>## database read only user<BR>DBROUSER=sermyadmin<BR><BR>## password for database read only user<BR>DBROPW=baco2<BR><BR><BR>log openser<BR><BR>Mar 16 11:02:47 twoxserver /sbin/opensips[9238]:<BR>ERROR:core:db_check_table_version: invalid version 1 for table<BR>watchers found, expected 3<BR>Mar 16 11:02:47 twoxserver /sbin/opensips[9238]:<BR>ERROR:presence:mod_init: error during table version check<BR>Mar 16 11:02:47 twoxserver /sbin/opensips[9238]: ERROR:core:init_mod:<BR>failed to initialize module presence<BR>Mar 16 11:02:47 twoxserver /sbin/opensips[9238]: ERROR:core:main:<BR>error while initializing modules<BR><BR>some idea where my error can be?<BR><BR>regardss<BR><BR>--<BR>rickygm<BR><BR><A href="http://gnuforever.homelinux.com/">http://gnuforever.homelinux.com</A><BR></FONT></P></DIV>
<DIV><P><HR>
"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".<BR>
<BR>
"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".
</P></DIV>
</BODY></HTML>