[OpenSIPS-Users] Opensips is not running

[Jeff Pyle]

The database username and password is set for each relevant module in
opensips.cfg.  To the best of my knowledge the opensipsctldb file is only
used for operations initiated with opensipsctl.

Your syslog output shows "core", and I'm not sure exactly how the core
connects to the db.  But, the answer may lie on line 250 of your
opensips.cfg file.


- Jeff



On 12/25/08 1:35 PM, "J Santos" <jsantos5954 at gmail.com> wrote:

> 
> I think I 've found the origin of the problem but still don't know how to
> fix it.
> 
> I've found the following entries on /var/log/messages
> 
> Dec 25 10:25:19 localhost /sbin/opensips[6700]:
> ERROR:db_mysql:db_mysql_new_connection: driver error: Access denied for user
> 'opensipsro'@'localhost' (using password: YES)
> Dec 25 10:25:19 localhost /sbin/opensips[6700]: ERROR:core:db_do_init: could
> not add connection to the pool
> Dec 25 10:25:19 localhost /sbin/opensips[6700]: ERROR:auth_db:auth_fixup:
> unable to open database connection
> Dec 25 10:25:19 localhost /sbin/opensips[6700]: ERROR:core:fix_actions:
> fixing failed (code=-1) at cfg line 250
> Dec 25 10:25:19 localhost /sbin/opensips[6700]: CRITICAL:core:fix_expr:
> fix_actions error
> Dec 25 10:25:19 localhost /sbin/opensips[6700]: ERROR:core:main: failed to
> fix configuration with err code -1
> 
> So it is complaining about a non existent db user or wrong password.
> 
> When I was  first installing opensips I created this username "opensipsro" .
> Later I decided to change the username and have made the properly replaces
> on  DBRWUSER and DBROUSER in the opensipsctlrc file.
> 
> So it looks like this username is still around. I searched all files on
> /etc/opensips and in the db tables themselves but couldn't find where this
> username is. It should be somewhere but where ?
> 
> I reinstalled opensips, dropped the db and recreated it but couldn't get rid
> of the username. 
> 
> Any clue ?
> 
> Thanks
> 
> J Santos
>