Page 1 of 1

agc MySQL connect ERROR

PostPosted: Wed Oct 14, 2009 5:12 pm
by gerdaniels
My Agents are experiencing a continuous but randomized MySQL connect ERROR
Can't connect to localhost MySQL server through socket.
Can any one tell me what or where to look the cause of this so to fix it... I'm loosing credibility because of this.

hi

PostPosted: Wed Oct 14, 2009 8:55 pm
by eliasferreyra
OS?
mysql version?
astguicleint version?

PostPosted: Wed Oct 14, 2009 10:07 pm
by okli
To add:
Loadavg when this happens?
Multi/Single server?
Number of agents?

Do read the pinned threads when posting to a forum, it's for everyone's convenience:
http://www.vicidial.org/VICIDIALforum/v ... .php?t=443

PostPosted: Thu Oct 15, 2009 8:50 am
by gerdaniels
Its a Single server
HP Proliant ML150 G5, 4 GB RAM, 2 CUad Core Processors, 3 SATA HD( 1 for /, 1 for /var/mysql/, 1 for /var/log)
with Linux 2.6.27.12-170.2.5.fc10.x86_64
running Mysql 5.0.67

Im using asterisk 1.2.31.1
libpri 1.2.8
zaptel 1.2.27
astguiclient 2.0.5b0.5

I have multiple outbound campaigns with 27 agents
(Zap channel 1)
By now just one Closer campaign with 5 agents
(Zap channel 2)
15 Administrative Sip Phones
(Zap channel 3)

PostPosted: Thu Oct 15, 2009 10:59 am
by okli
Compare /etc/mysql/my.cnf with this one:

http://download.vicidial.com/ubuntu/ubuntu-my-vici.cnf

Pay attention to :

skip-external-locking
skip-name-resolve