[OpenSIPS-Users] Presence xml

[troxlinux]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130828/ed425b63/attachment-0001.htm>