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.
Database /usr/share/astguiclient/AST_VDhopper.pl --debugX
Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba
10 posts
• Page 1 of 1
Database /usr/share/astguiclient/AST_VDhopper.pl --debugX
by Trying » Wed Jan 26, 2011 12:07 pm
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
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
by 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
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!)
by 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
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
by 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
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
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!)
by 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
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
by 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!! 
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
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
by 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!
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
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!)
by Trying » Sun Jan 30, 2011 1:53 am
Funny enough, almost everything you guys thought I screwed up eventually turns out to be bugs 
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
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
by 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
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
by 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]
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
10 posts
• Page 1 of 1
Return to ViciBox Server Install and Demo
Who is online
Users browsing this forum: No registered users and 61 guests