[OpenSIPS-Users] Presence xml

[Saúl Ibarra Corretgé]

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