[OpenSIPS-Users] Opensips is not running

[Wasin Thiengkunagrit]

Dear J,
 The problem seems to come from the connection between OpenSIPs and Database.
Please check your opensips.cfg some modules may trying to connect to database,
check the "modparam("[modulename]", "db_url",
"mysql://[username]:[password]@localhost:mysql/opensips")

 - The [modulename] is the name of modules that is trying to connect
to database. They may be "acc", "auth_db", "presence", etc...
 - The [username] and [password] is your username and password that
you use to connect to mysql.
   You can try this command in bash $mysql -u [username] -p [password]
and see if you can connect to mysql.

Cheers!
Killy



2008/12/26 J Santos <jsantos5954 at gmail.com>:
>
> 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
>
>
>
>
>
>> -----Original Message-----
>> From: Wasin Thiengkunagrit [mailto:wasin.th at gmail.com]
>> Sent: Wednesday, December 24, 2008 7:22 PM
>> To: J Santos
>> Cc: users at lists.opensips.org
>> Subject: Re: [OpenSIPS-Users] Opensips is not running
>>
>>
>> Dear J Santos
>>
>>   You may need to investigate what happen with OpenSIPs may
>> be the configuration was wrong. Try to look at the file
>> "/var/log/syslog" after you start the OpenSIPs by
>> "/etc/init.d/opensips start". Keep scrolling to end of that
>> file and look at the OpenSIPs tag it may show the problems.
>>
>> Cheers, Killy
>>
>>
>>
>>
>> 2008/12/25 J Santos <jsantos5954 at gmail.com>:
>> > Hello,
>> >
>> >
>> > I successfully installed opensips is a CentOS 64 bits. I
>> borrowed the
>> > init script from Fedora changing only the oser=/sbin/opensips.
>> >
>> > I've made small changes to the opensips.cfg  to enable mysql.
>> >
>> > When I
>> >
>> > /etc/init.d/opensips start
>> > Starting opensips:                                         [  OK  ]
>> >
>> > But if I
>> >
>> >  /etc/init.d/opensips stop
>> > Stopping opensips:                                         [FAILED]
>> > or
>> >
>> >  ps ax | grep opensips
>> >  8133 pts/3    S+     0:00 grep opensips
>> > When I
>> >
>> >  opensipsctl start
>> >
>> > INFO: Starting OpenSIPS :
>> >
>> > ERROR: PID file /var/run/opensips.pid does not exist --
>> OpenSIPS start
>> > failed There is no log file on var/log.
>> >
>> > How can I check what's wrong ?
>> >
>> > thanks
>> >
>> > J Santos
>> >
>> >
>> >
>> >
>> >
>> >
>> > _______________________________________________
>> > Users mailing list
>> > Users at lists.opensips.org
>> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> >
>> >
>> No virus found in this incoming message.
>> Checked by AVG - http://www.avg.com
>> Version: 8.0.176 / Virus Database: 270.10.0/1864 - Release
>> Date: 12/25/2008 9:40 AM
>>
>>
>
>