[Asterisk-Users] vicidial and mysql ........help

[mattf]

Hello,

First, there is a mailing list for the astGUIclient suite:
https://lists.sourceforge.net/lists/listinfo/astguiclient-users

As for your problem, If you have everything set up correctly you should just
be able to run the AST_VDhopper.pl script from your Asterisk server to fill
your lead hopper. Make sure you have the dialing restrictions in the
campaign screen set to 24 hours for testing and the dial level set to 1 or
higher and the hopper level to 1 or greater.

If you are still having problems, send the output of the AST_VDhopper script
to the astguiclient-users list and you'll get some help.

MATT---

-----Original Message-----
From: Hussain Umair [mailto:devil_dance at hotmail.com]
Sent: Friday, February 04, 2005 4:45 PM
To: asterisk-users at lists.digium.com
Subject: [Asterisk-Users] vicidial and mysql ........help


hi all.....well ive installed each and everything according to the scratch 
installation but the problem is when i try to login a user through 
vicidialgui application it gives an error that there are 0 leads in the 
hopper to dial....well im pasting the result of a few queries .....plz if 
any one can do help me out ....
this is what the error looks like...

SELECT count(*) FROM vicidial_hopper where campaign_id = '13' and 
status='READY';
0 - leads left to call in hopper
so the login fails..............


but these queries at the mysql cmd line tell me i got 7 leads in the 
database

select * from vicidial_list;
7 rows in set (0.00 sec)


but when i use count it gives this
mysql>select count(1) from vicidial_hopper;
+----------+
| count(1) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql> select status,count(1) from vicidial_hopper group by status;
Empty set (0.00 sec)

mysql> select campaign_id from vicidial_hopper group by campaign_id;
Empty set (0.00 sec)


please any ideas or help woud be greatly appreciated....im kinda lost in 
this mysql lala land cant figure out whats going on.....help me out here 
guys ....thankss

kurt...
Network Engineer plus Asterisk Newbie u can say....

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users