VICIDIAL not attempting calls in auto dial mode

[prateek]

hello
we are using VICIDIAL it is working fine in one to one mode
but in auto dial vicidal is not even attempting to make a call
my asterisk version is 1.2.12.1
vicidial 1.2.0.1
Linux distro FC4


--
> Channel SIP/3003-090449b8 was answered.
-- Executing MeetMe("SIP/3003-090449b8", "8600051") in new stack
== Parsing '/etc/asterisk/meetme.conf': Found
-- Created MeetMe conference 1023 for conference '8600051'
-- Playing 'conf-onlyperson' (language 'en')
== Manager 'sendcron' logged off from 127.0.0.1

it just stop after this

my screen output is this please help what may be the issue please help
us on this

[root@phone /]# screen -r
There are several suitable screens on:
22781.ASTsend (Dead ???)
28125..phone (Detached)
15204..phone (Dead ???)
28141.ASTVDauto (Detached)
17745.ASTVDadapt (Detached)
7045.ASTsend (Dead ???)
14927..phone (Dead ???)
Remove dead screens with 'screen -wipe'.
Type "screen [-d] -r [pid.]tty.host" to resume one of them.
You have new mail in /var/spool/mail/root

[mflorell]

Check that your manager.conf file is properly configured as per the SCRATCH_INSTALL

[prateek]

thanks for your prompt reply

i checked my settings for manager.conf it seems to be exactly according to scract install




[general]
enabled = yes
port = 5038
bindaddr = 0.0.0.0
[cron]
secret = 1234
read = system,call,log,verbose,command,agent,user
write = system,call,log,verbose,command,agent,user
[updatecron]
secret = 1234
read = command
write = command
[listencron]
secret = 1234
read = system,call,log,verbose,command,agent,user
write = command
[sendcron]
secret = 1234
read = command
write = system,call,log,verbose,command,agent,user
~







here is the log from asterisk -vvvvvgc

> Channel SIP/3003-0a12bba8 was answered.
== Manager 'sendcron' logged off from 127.0.0.1
-- Executing MeetMe("SIP/3003-0a12bba8", "8600051") in new stack
== Parsing '/etc/asterisk/meetme.conf': Found
-- Created MeetMe conference 1023 for conference '8600051'
-- Playing 'conf-onlyperson' (language 'en')
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1
Nov 1 02:57:04 WARNING[12666]: app_meetme.c:1541 conf_run: Unable to write fram e to channel: Success
-- Hungup 'Zap/pseudo-1232762967'
== Spawn extension (default, 8600051, 1) exited non-zero on 'SIP/3003-0a12bba8 '
-- Executing DeadAGI("SIP/3003-0a12bba8", "call_log.agi|h") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/call_log.agi
-- AGI Script call_log.agi completed, returning 0
-- Executing DeadAGI("SIP/3003-0a12bba8", "VD_hangup.agi|PRI-----NODEBUG---- -16---------------") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi
-- AGI Script VD_hangup.agi completed, returning 0
-- Executing AGI("SIP/3003-0a12bba8", "call_log.agi|919868050145") in new st ack
-- Launched AGI Script /var/lib/asterisk/agi-bin/call_log.agi
-- AGI Script call_log.agi completed, returning 0
-- Executing Dial("SIP/3003-0a12bba8", "Zap/g2/19868050145||tTo") in new sta ck
Nov 1 02:57:06 NOTICE[12753]: app_dial.c:1056 dial_exec_full: Unable to create channel of type 'Zap' (cause 0 - Unknown)
== Everyone is busy/congested at this time (1:0/0/1)
-- Executing Hangup("SIP/3003-0a12bba8", "") in new stack
== Spawn extension (default, 919868050145, 3) exited non-zero on 'SIP/3003-0a1 2bba8'
-- Executing DeadAGI("SIP/3003-0a12bba8", "call_log.agi|h") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/call_log.agi
-- AGI Script call_log.agi completed, returning 0
-- Executing DeadAGI("SIP/3003-0a12bba8", "VD_hangup.agi|PRI-----NODEBUG---- -16-----CHANUNAVAIL----------") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi
-- AGI Script VD_hangup.agi completed, returning 0
== Manager 'sendcron' logged off from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
> Channel SIP/3003-0a128d58 was answered.
-- Executing MeetMe("SIP/3003-0a128d58", "8600051") in new stack
== Parsing '/etc/asterisk/meetme.conf': Found
-- Created MeetMe conference 1023 for conference '8600051'
-- Playing 'conf-onlyperson' (language 'en')
== Manager 'sendcron' logged off from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1

[mflorell]

"Unable to create channel of type 'Zap'" means that something is configured wrong. What kind of trunks are you using?

What is the output of /usr/share/astguiclient/AST_update.pl --debug

is there anything in root's mailbox on your VICIDIAL server

[prateek]

the correct output for my asterisk VICIDIAL is sorry for giving wrong output

== Manager 'updatecron' logged on from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
> Channel SIP/3003-09b64d10 was answered.
== Manager 'sendcron' logged off from 127.0.0.1
-- Executing MeetMe("SIP/3003-09b64d10", "8600051") in new stack
== Parsing '/etc/asterisk/meetme.conf': Found
-- Created MeetMe conference 1023 for conference '8600051'
-- Playing 'conf-onlyperson' (language 'en')
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1


i checked my screen -r it is giving
[root@phone bin]# screen -r
There are several suitable screens on:
2376.ASTVDremote (Detached)
2275.asterisk (Detached)
2368.ASTVDadapt (Detached)
2356.ASTsend (Detached)
2380.ASTupdate (Detached)
2334.ASTlisten (Detached)
Type "screen [-d] -r [pid.]tty.host" to resume one of them.
You have new mail in /var/spool/mail/root
[root@phone bin]#

i think my AST_VDautodial is not working and when i treid to run this script manualy

the current path of my script is

/usr/src/astguiclient/bin






[root@phone bin]# perl AST_VDauto_dial.pl --debug
TIME DEBUG: ||0| GMT: 19:18
2006-11-01 19:18:19|LOGGED INTO MYSQL SERVER ON 1 CONNECTION||
TIME DEBUG: -5|-5|0| GMT: 00:18
2006-11-01 19:18:19|LIVE AGENTS LOGGED IN: 1|
2006-11-01 19:18:19|CLOSER 203.122.26.232: agents: 1 dial_level: 0|
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) or (campaign_id='CLOSER' and call_type='OUT') ) and server_ip='203.122.26.232' at line 1 at AST_VDauto_dial.pl line 388.
executing: SELECT count(*) FROM vicidial_auto_calls where ( (call_type='IN' and campaign_id IN()) or (campaign_id='CLOSER' and call_type='OUT') ) and server_ip='203.122.26.232' and status IN('SENT','RINGING','LIVE','XFER','CLOSER'); You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) or (campaign_id='CLOSER' and call_type='OUT') ) and server_ip='203.122.26.232' at line 1 at AST_VDauto_dial.pl line 388.
[root@phone bin]#


please help me on this