Have you verified wether your OpenSIPS install works when starting it manually after boot? If it's just an issue on boot, I suspect that the boot process starts OpenSIPS before starting up the MySQL server.
You might want to google on how to set the start-up order of services on Ubuntu. Best regards, Even André On 20. okt. 2010, at 10.06, Randall Degges wrote: > Hi everyone, > > This is my first post on the mailing list. > > I'm currently walking through a new OpenSIPS 1.6.3 install on a ubuntu-server > 10.04 (64-bit) box. I've purchased Flavio's book (OpenSIPS 1.6) from PacktPub > which I was originally following, but it seemed to have some incomplete > installation instructions, so I've been using a variety of sources (which > I've cited at the end of this email). > > My problem is: I can't get OpenSIPS to start at boot because some part of my > MySQL configuration is messed up. Below are links to the appropriate error > messages, as well as configuration files, so that you can get a sense of what > I'm trying to do here. Also, just as additional information: I'm running > MySQL on localhost (the same server that is running OpenSIPS), and I > eventually plan to add in radius support for call accounting purposes. > > My error messages from /var/log/syslog: http://pastie.org/1234861 > My /etc/init.d/opensips file: http://pastie.org/1234862 > My /etc/default/opensips file: http://pastie.org/1234863 > My /etc/opensips/opensips.cfg file: http://pastie.org/1234864 > My /etc/opensips/opensipsctlrc file: http://pastie.org/1234869 > > The main error (if you don't want to look through the entire startup log) is: > > Oct 20 07:55:09 OS01 /sbin/opensips[2372]: DBG:db_mysql:db_mysql_connect: > opening connection: mysql://xxxx:x...@localhost/opensips > Oct 20 07:55:09 OS01 /sbin/opensips[2372]: ERROR:db_mysql:db_mysql_connect: > driver error(2002): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) > Oct 20 07:55:09 OS01 /sbin/opensips[2372]: > ERROR:db_mysql:db_mysql_new_connection: initial connect failed > Oct 20 07:55:09 OS01 /sbin/opensips[2372]: ERROR:core:db_do_init: could not > add connection to the pool > Oct 20 07:55:09 OS01 /sbin/opensips[2372]: ERROR:usrloc:register_udomain: > failed to open database connection > Oct 20 07:55:09 OS01 /sbin/opensips[2372]: ERROR:registrar:domain_fixup: > failed to register domain > Oct 20 07:55:09 OS01 /sbin/opensips[2372]: ERROR:core:fix_actions: fixing > failed (code=-1) at cfg line 330 > Oct 20 07:55:09 OS01 /sbin/opensips[2372]: CRITICAL:core:fix_expr: > fix_actions error > Oct 20 07:55:09 OS01 /sbin/opensips[2372]: ERROR:core:main: failed to fix > configuration with err code -1 > > I've already created the appropriate database (opensips) using the command: > 'opensipsdbctl create', which I'm assuming set the proper permissions and > user passwords for the users 'opensips' and 'opensipsro'. > > As another quick bit of debugging information, here is the following MySQL > statement ran on my database: > > mysql> SELECT user, host FROM mysql.user; > +------------------+-----------+ > | user | host | > +------------------+-----------+ > | root | 127.0.0.1 | > | debian-sys-maint | localhost | > | opensips | localhost | > | opensipsro | localhost | > | root | localhost | > +------------------+-----------+ > 5 rows in set (0.00 sec) > > I'm at a loss of what to do to get OpenSIPS to connect to MySQL. I've read > through both the official book by Flavio, as well as numerous guides on the > websites, and on VoIP-info, but I've still had no luck. > > If anyone can give me some advice or point out a mistake I've made, I'd be > extremely grateful! > > Here are some of the references I've used to help me configure my system so > far: > > http://www.amazon.com/Building-Telephony-Systems-OpenSIPS-1-6/dp/1849510741/ref=sr_1_1?ie=UTF8&qid=1287561923&sr=8-1 > http://www.voip-info.org/wiki/view/Opensips+Installation,+How+to. > http://www.mail-archive.com/[email protected]/ > > Thanks SO much for your time. > > -Randall > > -- > Randall Degges > http://rdegges.com/ > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
