<div dir="ltr"><div>if I disabled module presence_xml opensips running fine <br><br>#loadmodule "presence_xml.so"<br>modparam("presence", "db_url","mysql://root:xxxxx@localhost/opensips")<br>
modparam("presence", "server_address", "<a href="http://sip:sa@172.16.8.48:5060">sip:sa@172.16.8.48:5060</a>")<br>#modparam("presence_xml", "db_url") # CUSTOMIZE ME<br>#modparam("presence_xml", "force_active", 1)<br>
<br></div>but , error <span id="result_box" class="" lang="en"><span class="">persists in the </span></span>log when open softphone<br><br>opensips[5719]: ERROR:presence:handle_publish: Missing or unsupported event header field value<br>
Aug 28 14:15:13 sipia /sbin/opensips[5719]: ERROR:presence:handle_publish: #011event=[presence]<br><br><span id="result_box" class="" lang="en"><span class="">I think</span> <span class="">that disabled</span> <span class="">presence_xml</span></span>.so<br>
<br><div><br><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/8/28 troxlinux <span dir="ltr"><<a href="mailto:xserverlinux@gmail.com" target="_blank">xserverlinux@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Saul, change the user en opensips , <span lang="en"><span>now I'm</span> <span>using the</span> <span>mysql root</span><span>,</span> <span>and</span> <span>the</span> <span>error message changes<br>
<br>Aug 28 13:44:13 sipia /sbin/opensips[5081]: ERROR:presence_xml:mod_init: Can't bind xcap<br>Aug 28 13:44:13 sipia /sbin/opensips[5081]: ERROR:core:init_mod: failed to initialize module presence_xml<br>Aug 28 13:44:13 sipia /sbin/opensips[5081]: ERROR:core:main: error while initializing modules<br>
<br></span></span></div><div class="gmail_extra"><div><div class="h5"><br><br><div class="gmail_quote">2013/8/28 Saúl Ibarra Corretgé <span dir="ltr"><<a href="mailto:saul@ag-projects.com" target="_blank">saul@ag-projects.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><br>
On Aug 28, 2013, at 6:21 PM, troxlinux wrote:<br>
<br>
> saul my connection to mysql works perfect with the root user, and the user OpenSIPS bd,<br>
><br>
> mysqld (pid 2411) is running...<br>
><br>
<br>
</div>So, does "mysql -uossips -pxxx -hlocalhost opensips" work?<br>
<div><br>
><br>
> line 87 and 88<br>
><br>
> modparam("presence", "db_url","mysql://ossips:xxx@localhost/opensips")<br>
> modparam("presence", "server_address", "sip:172.x.x.x:5060")<br>
><br>
<br>
</div>These look fine, did you load the db_mysql beforehand?<br>
<div><div><br>
><br>
><br>
><br>
><br>
> 2013/8/28 Saúl Ibarra Corretgé <<a href="mailto:saul@ag-projects.com" target="_blank">saul@ag-projects.com</a>><br>
><br>
> On Aug 28, 2013, at 6:05 PM, troxlinux wrote:<br>
><br>
> ><br>
> > look there :<br>
> ><br>
> > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:db_mysql:db_mysql_connect: driver error(1045): Access denied for user ''ossips@'localhost' (using password: YES)<br>
> > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:db_mysql:db_mysql_new_connection: initial connect failed<br>
> > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:core:db_do_init: could not add connection to the pool<br>
> > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:presence:mod_init: connecting to database failed<br>
> > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:core:init_mod: failed to initialize module presence<br>
> > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:core:main: error while initializing modules<br>
> ><br>
> > the user is correct to connect to mysql , my attention this message<br>
> ><br>
><br>
> Your DB connection seems to be wrong.<br>
><br>
> > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:core:init_mod: failed to initialize module presence<br>
> > le /etc/opensips/opensips.cfg, line 87, column 16-17: syntax error<br>
> > Aug 28 08:39:17 sipia opensips: CRITICAL:core:yyerror: parse error in config file /etc/opensips/opensips.cfg, line 87, column 16-17: Invalid arguments<br>
> > Aug 28 08:39:17 sipia opensips: CRITICAL:core:yyerror: parse error in config file /etc/opensips/opensips.cfg, line 88, column 1-9:<br>
> ><br>
><br>
> Well, what do you have on those lines? (87 and 88)<br>
><br>
> --<br>
> Saúl Ibarra Corretgé<br>
> AG Projects<br>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
><br>
><br>
> --<br>
> rickygm<br>
><br>
> <a href="http://gnuforever.homelinux.com" target="_blank">http://gnuforever.homelinux.com</a><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
--<br>
Saúl Ibarra Corretgé<br>
AG Projects<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div><span class="HOEnZb"><font color="#888888">-- <br>rickygm<br><br><a href="http://gnuforever.homelinux.com" target="_blank">http://gnuforever.homelinux.com</a>
</font></span></div>
</blockquote></div><br><br clear="all"><br>-- <br>rickygm<br><br><a href="http://gnuforever.homelinux.com">http://gnuforever.homelinux.com</a>
</div>