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é <[email protected]>
>
> 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
> [email protected]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> --
> rickygm
>
> http://gnuforever.homelinux.com
> _______________________________________________
> Users mailing list
> [email protected]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
--
Saúl Ibarra Corretgé
AG Projects
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
