[OpenSIPS-Users] OpenSIPS 1.6.3 MySQL Issues

[Randall Degges]

Actually I didn't check that. Ill look into it now.

Thanks!
On Oct 20, 2010 1:21 AM, "Even André Fiskvik" <grevenx at me.com> wrote:
> 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:xxxx@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/users@lists.opensips.org/
>>
>> Thanks SO much for your time.
>>
>> -Randall
>>
>> --
>> Randall Degges
>> http://rdegges.com/
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20101020/59324c99/attachment.htm