vicidial.org

Posted: **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.

Posted: **Wed Jan 26, 2011 2:27 pm**

verify your cron user and its password in mysql also verify mysql running

Posted: **Wed Jan 26, 2011 3:16 pm**

The cron password is correct and mysql is running.

Posted: **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

Posted: **Wed Jan 26, 2011 4:04 pm**

I will give it a go and report back, thank you!

Posted: **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!!

Posted: **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!

Posted: **Sun Jan 30, 2011 1:53 am**

Funny enough, almost everything you guys thought I screwed up eventually turns out to be bugs :lol:

Posted: **Sun Jan 30, 2011 10:17 am**

You keep findin ... we keep squishin.

Posted: **Thu Aug 04, 2011 9:08 am**

vicidial.org

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

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

real time report