agc MySQL connect ERROR

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

agc MySQL connect ERROR

Postby gerdaniels » Wed Oct 14, 2009 5:12 pm

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.
gerdaniels
 
Posts: 10
Joined: Mon Apr 30, 2007 10:58 am
Location: Guatemala

hi

Postby eliasferreyra » Wed Oct 14, 2009 8:55 pm

OS?
mysql version?
astguicleint version?
“Better to remain silent and be thought a fool than to speak out and remove all doubt.”
-Abraham Lincoln
eliasferreyra
 
Posts: 367
Joined: Wed Jul 18, 2007 3:27 pm

Postby okli » Wed Oct 14, 2009 10:07 pm

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
okli
 
Posts: 671
Joined: Mon Oct 01, 2007 5:09 pm

Postby gerdaniels » Thu Oct 15, 2009 8:50 am

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)
gerdaniels
 
Posts: 10
Joined: Mon Apr 30, 2007 10:58 am
Location: Guatemala

Postby okli » Thu Oct 15, 2009 10:59 am

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
okli
 
Posts: 671
Joined: Mon Oct 01, 2007 5:09 pm


Return to Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 84 guests