MySQL Error With DB Vicidial

[aleyva]

Hello,
Sometimes I can see this message at GUI Agent and Admin :

MySQL connect ERROR: Cannot assign requested address

What does it mean this messages? At Gui Admin I need to refresh for continue.

Regards,

AL

-----------------
Vicibox with Vicidial VERSION: 2.8-408a BUILD: 130711-2208.
Vicidial Server (DB Server, WebServer, Vicidial Asterisk)
3 Server Asterisk configure like DIALERS with E1 Pri, with Sangoma Cards

[williamconley]

Never seen that message before.

How did you install your systems? What .iso or installation instructions were used? It is likely an installation issue ... so installation method is quite important.

[aleyva]

It was installed of a ISO, after that was updated from SVN to VERSION: 2.8-408a.
DB Server version: 5.5.28-log Source distribution

[williamconley]

LOL. OK, let's be clear: I asked for the name of the .iso installer and you said "intalled of a ISO" which is clearly NOT the name of the installer ISO.

So we'll try again: Please post the name of the .iso CD from which you installed Vicidial OR the information from the SSH splash screen when you log in (as this often contains installation information, especially in Vicibox).

Possibilities include the most likely Vicibox (with a version, since you DID list Vicibox in your signature ...), but also: GoAutoDial (with a version) VicidialNOW (with a version) ...

Of course, you can also check your logs for apache (/var/log/apache) and mysql (/var/log/mysql but the name varies with different installers at this point) to see if there is a hint in the error.

You could also post what you are attempting to do when this error occurs. And perhaps post your web page source code when it happens with a few lines above the error from the source code, which may give a hint as to what portion of the code was executing when this error occurred.

[aleyva]

Ok, from ssh login i can see - ViciBox Redux v.4.0.2 released.
In apache errror log i found too many line like:

mysql_connect(): [2002] Cannot assign requested address (trying to connect via tcp://[IPDB]:3306) in /srv/www/htdocs/agc/dbconnect.php on line 48, referer: xhtp://[IPWWWW]/agc/vicidial.php

[williamconley]

excellent post. great improvement. unfortunately, i've never seen this error.

perhaps you could post the content of line 48 of /srv/www/htdocs/agc/dbconnect.php in case that has at least a hint of what was expected to happen.

does this happen during heavy usage, or a certain time every day or ...?

[aleyva]

I found this:

http://redis4you.com/articles.php?id=01 ... tion+issue

I apply

Code: Select all

echo 1 > /proc/sys/net/ipv4/tcp_tw_recycle
echo 1 > /proc/sys/net/ipv4/tcp_tw_reuse

In my DB Server and Web Server and Its Works!!

[williamconley]

Now THAT is an excellent post. Good googling!

[amjohnson]

I am having similar issues to this as well just ran that command and added it to /etc/rc.d/boot.local .... Agents are at lunch hopefully once they get back on it goes copmletely away as well..

[williamconley]

I am having similar issues to this as well just ran that command and added it to /etc/rc.d/boot.local .... Agents are at lunch hopefully once they get back on it goes copmletely away as well..

I wish you luck and hope it fixes your problem.

You are having similar issues ... you see "MySQL connect ERROR: Cannot assign requested address" in the admin or agent interface? I've never heard of it and now there are two of you? Or were you speaking figuratively ...?