Database /usr/share/astguiclient/AST_VDhopper.pl --debugX

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

Database /usr/share/astguiclient/AST_VDhopper.pl --debugX

Postby Trying » Wed Jan 26, 2011 12:07 pm

Here is another interesting one. On my new 3.1.6 install, as listed below, I get no leads in hopper.

In the crontab of the Database server there is an entry:

### updater for VICIDIAL hopper
* * * * * /usr/share/astguiclient/AST_VDhopper.pl -q

However, if I run it manually I get the following error:

db1:~ # /usr/share/astguiclient/AST_VDhopper.pl -q
DBI connect('asterisk:localhost:3306','cron',...) failed: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) at /usr/share/astguiclient/AST_VDhopper.pl line 273
Couldn't connect to database: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) at /usr/share/astguiclient/AST_VDhopper.pl line 273.
You have new mail in /var/mail/root

Putting this entry in any of the Dialers' crontab works.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby williamconley » Wed Jan 26, 2011 2:27 pm

verify your cron user and its password in mysql also verify mysql running
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby Trying » Wed Jan 26, 2011 3:16 pm

The cron password is correct and mysql is running.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby williamconley » Wed Jan 26, 2011 3:59 pm

well ... if it tries to connect and fails and you try to connect but succeed ... there must be a difference in "how".

perhaps the astguiclient.conf file has localhost but needs your ip instead? perhaps 127.0.0.1? (although I don't recall bumping into this ... ?) but worth experimentation :)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby Trying » Wed Jan 26, 2011 4:04 pm

I will give it a go and report back, thank you!
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby Trying » Sat Jan 29, 2011 12:09 pm

You gotta be kidding me! Changing localhost to 127.0.0.1 solved both issues! Firstly the hopper script runs fine on the DB server. Secondly the call count is now showing in the live-report. Once again you came to the rescue.... thanks William!! :D
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby williamconley » Sat Jan 29, 2011 6:15 pm

lol. now i wanna know how you screwed ... oops, how it got messed up to begin with.

you GOTTA stop pushin' those buttons! :)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby Trying » Sun Jan 30, 2011 1:53 am

Funny enough, almost everything you guys thought I screwed up eventually turns out to be bugs :lol:
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby williamconley » Sun Jan 30, 2011 10:17 am

You keep findin ... we keep squishin.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

real time report

Postby xhunnn » Thu Aug 04, 2011 9:08 am

Sir trying,

how did you fix the calls today?



Vicibox Redux 3.1.9 | Admin VERSION: 2.4-322a BUILD: 110703-1400 | Agent VERSION: 2.4-333c BUILD: 110626-2234
Linux 2.6.34.8-0.2-pae #1 SMP | Perl v5.12.1 | Asterisk 1.4.39.1-vici | Mysql 14.14 Distrib 5.1.46 | PHP 5.3. [/img]
xhunnn
 
Posts: 42
Joined: Fri May 20, 2011 8:54 pm


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 115 guests