[OpenSIPS-Users] Opensips is not running

[J Santos]

All right guys, please desconsider my previous email.

 It was , of course, my fault, because since  I was not supplying the
password , so there was  no way to connect. Simple enough.

I have it running now.

Thank you all who tried to help me.

Jair Santos


 
 


> -----Original Message-----
> From: Wasin Thiengkunagrit [mailto:wasin.th at gmail.com] 
> Sent: Thursday, December 25, 2008 6:49 PM
> To: J Santos
> Cc: users at lists.opensips.org
> Subject: Re: [OpenSIPS-Users] Opensips is not running
> 
> 
> 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
> >>
> >>
> >
> >
> 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
> 
>