[OpenSIPS-Users] Presence xml

[troxlinux]

if I disabled module presence_xml opensips running fine

#loadmodule "presence_xml.so"
modparam("presence", "db_url","mysql://root:xxxxx@localhost/opensips")
modparam("presence", "server_address", "sip:sa at 172.16.8.48:5060")
#modparam("presence_xml", "db_url") # CUSTOMIZE ME
#modparam("presence_xml", "force_active", 1)

but , error persists in the log when open softphone

opensips[5719]: ERROR:presence:handle_publish: Missing or unsupported event
header field value
Aug 28 14:15:13 sipia /sbin/opensips[5719]: ERROR:presence:handle_publish:
#011event=[presence]

I think that disabled presence_xml.so





2013/8/28 troxlinux <xserverlinux at gmail.com>

> Saul, change the user en opensips ,  now I'm using the mysql root, and the error
> message changes
>
> Aug 28 13:44:13 sipia /sbin/opensips[5081]: ERROR:presence_xml:mod_init:
> Can't bind xcap
> Aug 28 13:44:13 sipia /sbin/opensips[5081]: ERROR:core:init_mod: failed to
> initialize module presence_xml
> Aug 28 13:44:13 sipia /sbin/opensips[5081]: ERROR:core:main: error while
> initializing modules
>
>
>
> 2013/8/28 Saúl Ibarra Corretgé <saul at ag-projects.com>
>
>>
>> On Aug 28, 2013, at 6:21 PM, troxlinux wrote:
>>
>> > saul my connection to mysql works perfect with the root user, and the
>> user OpenSIPS bd,
>> >
>> > mysqld (pid 2411) is running...
>> >
>>
>> So, does "mysql -uossips -pxxx -hlocalhost opensips" work?
>>
>> >
>> > line 87 and 88
>> >
>> > modparam("presence", "db_url","mysql://ossips:xxx@localhost/opensips")
>> > modparam("presence", "server_address", "sip:172.x.x.x:5060")
>> >
>>
>> These look fine, did you load the db_mysql beforehand?
>>
>> >
>> >
>> >
>> >
>> > 2013/8/28 Saúl Ibarra Corretgé <saul at ag-projects.com>
>> >
>> > On Aug 28, 2013, at 6:05 PM, troxlinux wrote:
>> >
>> > >
>> > > look there :
>> > >
>> > > 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)
>> > > Aug 28 09:54:41 sipia /sbin/opensips[27216]:
>> ERROR:db_mysql:db_mysql_new_connection: initial connect failed
>> > > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:core:db_do_init:
>> could not add connection to the pool
>> > > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:presence:mod_init:
>> connecting to database failed
>> > > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:core:init_mod:
>> failed to initialize module presence
>> > > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:core:main: error
>> while initializing modules
>> > >
>> > > the user is correct to connect to mysql , my attention this message
>> > >
>> >
>> > Your DB connection seems to be wrong.
>> >
>> > > Aug 28 09:54:41 sipia /sbin/opensips[27216]: ERROR:core:init_mod:
>> failed to initialize module presence
>> > > le /etc/opensips/opensips.cfg, line 87, column 16-17: syntax error
>> > > 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
>> > > Aug 28 08:39:17 sipia opensips: CRITICAL:core:yyerror: parse error in
>> config file /etc/opensips/opensips.cfg, line 88, column 1-9:
>> > >
>> >
>> > Well, what do you have on those lines? (87 and 88)
>> >
>> > --
>> > Saúl Ibarra Corretgé
>> > AG Projects
>> >
>> >
>> >
>> >
>> > _______________________________________________
>> > Users mailing list
>> > Users at lists.opensips.org
>> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> >
>> >
>> >
>> > --
>> > rickygm
>> >
>> > http://gnuforever.homelinux.com
>> > _______________________________________________
>> > Users mailing list
>> > Users at lists.opensips.org
>> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>> --
>> Saúl Ibarra Corretgé
>> AG Projects
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>
>
>
> --
> rickygm
>
> http://gnuforever.homelinux.com
>



-- 
rickygm

http://gnuforever.homelinux.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130828/8bdc5bd0/attachment.htm>