vicidial.org

by **skshabbir** » Wed Jan 16, 2013 6:50 am

Hello i am new to vicidial

i have installed the latest version of vicibox 4.0.1 64bit and i have clustered like

1 Database/web combo
1 Telephony server
1 Acchive server

all are in same subnet but when i trying to add archive server after installing the database its gave me error [DBD::mysql::st execute failed you have an error in your sql syntax;]

how can i put the recording on windows ftp server or shall i use the archive server
please help i am stuck

by **DomeDan** » Wed Jan 16, 2013 7:36 am

does it look like this http://www.vicidial.org/VICIDIALforum/v ... =8&t=25948 ?
please post all the output from the script when it fails and post the settings you select

by **skshabbir** » Wed Jan 16, 2013 9:16 am

redirecting to systemctl
insserv: Note: sysvinit service apache2 is shadowed by systemd apache2.service,
Forwarding request to '/bin/systemctl --root / enable apache2.service'.
insserv: Forward service request to systemctl returned error status : 256
redirecting to systemctl
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 '' at line 1 at /usr/local/bin/vicibox-install line 443, <STDIN> line 13.
/tmp/rootcron: No such file or directory

i am unable to setup archive server so that when i am trying to install telephony server its say no archive server found

by **DomeDan** » Wed Jan 16, 2013 9:58 am

Please post all options you selected when running vicibox-install!
and post all output vicibox-install because I suspect there might be more errors earlier in the execution.

I just took a look in /usr/local/bin/vicibox-install (build 120923-1118) and row 441 seams to be missing the ending ) in " VALUES ( ... ) "
try to add that directly after '$TELarchiveurl' so it looks like this:
'$TELarchiveurl');";
I will send a message to matt about this this bug

by **skshabbir** » Wed Jan 16, 2013 12:09 pm

ViciBox v.4.0 Installer

The installer will ask questions based upon the role that this server is
to provide for the ViciBox Call Center Suite. You should have the database
and optionally archive servers setup prior to installing any other servers.
The installer will not run without there being a configured database! If this
server is to be the database then it must be installed before the archive server
Verify that all servers are connected to the same network and have connectivity
to each other before continuing. This installer will be destructive to the the
server if it is run.

Do you want to continue with the ViciBox install? [y/N] : y

Do you want to enable expert installation? [y/N] : N

The Internal IP address found was 192.168.x.x
Do you want to use this IP address for ViciDial? [Y/n] : Y

Will this server be used as the Database? [y/N] : N

Please input the master database IP address () : 192.168.x.x
Do you want to connect using the default ViciDial DB settings? [Y/n] : Y

Will this server be used as a Web server? [y/N] : N

Will this server be used as a Telephony server? [y/N] : N

Will this server be used as an Archive server? [y/N] : y
Archive server IP (192.168.x.x) :
Archive URL (192.168.x.x/archive/) :

Do you want to disable the built-in firewall? [y/N] : y

--- ViciBox v.4.0 Install Summary ---

Expert : No
Legacy : No
Database : No
Web : No
Telephony: No
Archive : Yes
Firewall : Disabled

--- Configuration Information ---
- Database -
SVN Rev : 1915
IP Addr : 192.168.x.x
Name : asterisk
User : cron
Password : 1234
Cust User: custom
Cust Pass: custom1234
Port : 3306

Please verify the above information before continuing!
Do you want to continue the installation? [y/N] :

by **williamconley** » Wed Jan 16, 2013 1:28 pm

Green? Really? LOL (I prefer "Code")

You can use any ftp server you wish. It does not need to be a "Vicidial" ftp server. Modify /etc/astguiclient.conf to suit your needs on each dialer sending calls.

but: You will want the ftp server files to land in a web directory for web access. And that web URL will need to be part of your /etc/astguiclient.conf file settings for ftp service.

by **skshabbir** » Thu Jan 17, 2013 3:32 am

i am new to vicidial please tell how will i modify /etc/astguiclient.conf

by **williamconley** » Thu Jan 17, 2013 7:42 pm

by using a program called "nano".

nano /etc/astguiclient.conf

If unsure how to use nano:

man nano

Why do you want to modify the file?

by **skshabbir** » Fri Jan 18, 2013 4:09 am

thanks alot i want to modify because i am unable to cluster the acrhive server. i have install database and telephony server both are in cluster except archive server

by **skshabbir** » Fri Jan 18, 2013 4:12 am

Code: Select all: # /etc/astguiclient.conf - configuration elements for the astguiclient/vicidial$ # this is the astguiclient configuration file # all comments will be lost if you run install.pl again # Paths used by astGUIclient PATHhome => /usr/share/astguiclient PATHlogs => /var/log/astguiclient PATHagi => /var/lib/asterisk/agi-bin PATHweb => /srv/www/htdocs PATHsounds => /var/lib/asterisk/sounds PATHmonitor => /var/spool/asterisk/monitor PATHDONEmonitor => /var/spool/asterisk/monitorDONE # The IP address of this machine VARserver_ip => 192.168.1.3 # Database connection information VARDB_server => 192.168.1.2 VARDB_database => asterisk

by **skshabbir** » Fri Jan 18, 2013 6:45 am

well i got the same error if try to install database and archive on the same system.

Code: Select all: redirecting to systemctl insserv: Note: sysvinit service apache2 is shadowed by systemd apache2.service, Forwarding request to '/bin/systemctl --root / enable apache2.service'. insserv: Forward service request to systemctl returned error status : 256 redirecting to systemctl 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 '' at line 1 at /usr/local/bin/vicibox-install line 443, <STDIN> line 13. /tmp/rootcron: No such file or directory

by **williamconley** » Sat Jan 19, 2013 10:15 pm

i believe that is the same error mentioned in another post that states the mysql query is fixed in Vicibox 4.0.2 (ie: burn the next .iso!)

by **skshabbir** » Sun Jan 20, 2013 12:24 am

thanks i installed 4.0.2 and error is gone..

by **skshabbir** » Wed Jan 23, 2013 1:22 am

I have just setup everything but i am unable to make outbound calls Carrrier settings are

register => 05XXXX:XXXXX4264@202.XX.X.X

[testcarrier]
disallow=all
allow=ulaw
type=friend
username=05XXXXX
secret=XXXXX4264
host=202.XXXXX
dtmfmode=rfc2833
context=trunkinbound

exten => _91.,1,AGI(agi://127.0.0.1:4577/call_log)
exten => _91.,2,Dial(${TESTSIPTRUNK}/${EXTEN:2},,tTor)
exten => _91.,3,Hangup

asterik version: 1.4.44
Vicibox: 4.0.2
VERSION: 2.6-392a
BUILD: 130102-1135

by **williamconley** » Mon Jan 28, 2013 7:39 pm

Show command line output from an attempted outbound dial.

Does your carrier expect NXXNXXXXXX (10 digit us number) or 1NXXNXXXXXX (with a dial cod of 1 in front). If they expect the "1" you need to change "EXTEN:2" to "EXTEN:1" to leave the 1 in front of the dialed number (still removing the 9, which is merely the dial Prefix from the campaign, used to choose the carrier, which is why it is still discarded to avoid sending to the carrier as part of the phone).

Also: you should not use "_91.," you should use something more like "_91NXXNXXXXXX.," (US calls) or "_91XXXXXXXXXX" (10 digit calls preceded by 91).

by **skshabbir** » Mon Feb 11, 2013 4:04 am

thanks william but now i am facing another situation i have uploaded the leads whenever i try to loged in it says there is no leads in this hopper.

by **williamconley** » Mon Feb 11, 2013 3:40 pm

Likely you did not wait the required 60 seconds before the login attempt or your leads did not upload properly or you have omitted them with campaign settings (call times, filter ...).

Also, you should have created a new post as this is not related to clustering. And be sure to post your system specs from now on (it helps get you valid responses, among other things).

by **skshabbir** » Tue Feb 12, 2013 7:02 am

I have install the vicibox Express mode and after configuring everything (user, sip and campaign) when i have uploaded the lead in the campaign and when i logging in as a agent it says there is no leads in this hopper.

please help me i got stuck

by **williamconley** » Tue Feb 12, 2013 1:58 pm

how many leads are in the list?

by **skshabbir** » Wed Feb 13, 2013 3:48 pm

thanks i got resolve the previous issue now i am facing calls are coming very slow when i check in asterisk i got the following

Code: Select all: == Parsing '/etc/asterisk/manager.conf': [Feb 14 02:14:36] Found == Manager 'sendcron' logged on from 127.0.0.1 -- Executing [91441482640261@default:1] AGI("Local/91441482640261@default-94d2,2", "agi://127.0.0.1:4577/call_log") in new stack -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0 -- Executing [91441482640261@default:2] Dial("Local/91441482640261@default-94d2,2", "SIP/testcarrier/441482640261||To") in new stack -- Called testcarrier/441482640261 -- SIP/testcarrier-00000029 is ringing == Parsing '/etc/asterisk/manager.conf': [Feb 14 02:14:56] Found == Manager 'sendcron' logged on from 127.0.0.1 -- Executing [9144129733916@default:1] AGI("Local/9144129733916@default-dce0,2", "agi://127.0.0.1:4577/call_log") in new stack -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0 -- Executing [9144129733916@default:2] Dial("Local/9144129733916@default-dce0,2", "SIP/testcarrier/44129733916||To") in new stack -- Called testcarrier/44129733916 -- SIP/testcarrier-0000002a is ringing == Parsing '/etc/asterisk/manager.conf': [Feb 14 02:15:01] Found == Manager 'sendcron' logged on from 127.0.0.1 == Parsing '/etc/asterisk/manager.conf': [Feb 14 02:15:01] Found == Manager 'sendcron' logged off from 127.0.0.1 == Manager 'sendcron' logged off from 127.0.0.1 == Parsing '/etc/asterisk/manager.conf': [Feb 14 02:15:04] Found == Manager 'sendcron' logged on from 127.0.0.1 -- Executing [91441316654837@default:1] AGI("Local/91441316654837@default-9c28,2", "agi://127.0.0.1:4577/call_log") in new stack -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0 -- Executing [91441316654837@default:2] Dial("Local/91441316654837@default-9c28,2", "SIP/testcarrier/441316654837||To") in new stack -- Called testcarrier/441316654837 == Parsing '/etc/asterisk/manager.conf': [Feb 14 02:15:06] Found == Manager 'sendcron' logged on from 127.0.0.1 == Manager 'sendcron' logged off from 127.0.0.1 -- SIP/testcarrier-0000002b is ringing -- SIP/testcarrier-0000002a answered Local/9144129733916@default-dce0,2 > Channel Local/9144129733916@default-dce0,1 was answered. -- Executing [8368@default:1] Playback("Local/9144129733916@default-dce0,1", "sip-silence") in new stack -- <Local/9144129733916@default-dce0,1> Playing 'sip-silence' (language 'en') WARNING[11488]: file.c:1297 waitstream_core: Unexpected control subclass '-1' -- Executing [8368@default:2] AGI("Local/9144129733916@default-dce0,1", "agi://127.0.0.1:4577/call_log") in new stack -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0 -- Executing [8368@default:3] AGI("Local/9144129733916@default-dce0,1", "agi-VDAD_ALL_outbound.agi|NORMAL-----LB") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_outbound.agi -- AGI Script agi-VDAD_ALL_outbound.agi completed, returning 0 -- Executing [8368@default:4] AGI("Local/9144129733916@default-dce0,1", "agi-VDAD_ALL_outbound.agi|NORMAL-----LB") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_outbound.agi == Manager 'sendcron' logged off from 127.0.0.1 -- AGI Script agi-VDAD_ALL_outbound.agi completed, returning 0 -- Executing [8368@default:5] Hangup("Local/9144129733916@default-dce0,1", "") in new stack == Spawn extension (default, 8368, 5) exited non-zero on 'Local/9144129733916@default-dce0,1' -- Executing [h@default:1] DeadAGI("Local/9144129733916@default-dce0,1", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16---------------") in new stack -- SIP/testcarrier-0000002b answered Local/91441316654837@default-9c28,2 > Channel Local/91441316654837@default-9c28,1 was answered. -- Executing [8368@default:1] Playback("Local/91441316654837@default-9c28,1", "sip-silence") in new stack -- <Local/91441316654837@default-9c28,1> Playing 'sip-silence' (language 'en') WARNING[11497]: file.c:1297 waitstream_core: Unexpected control subclass '-1' -- Executing [8368@default:2] AGI("Local/91441316654837@default-9c28,1", "agi://127.0.0.1:4577/call_log") in new stack -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0 -- Executing [8368@default:3] AGI("Local/91441316654837@default-9c28,1", "agi-VDAD_ALL_outbound.agi|NORMAL-----LB") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_outbound.agi -- Executing [h@default:1] DeadAGI("Local/9144129733916@default-dce0,2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----19-----4") in new stack -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----19-----4 completed, returning 0 == Spawn extension (default, 9144129733916, 2) exited non-zero on 'Local/9144129733916@default-dce0,2' -- AGI Script agi-VDAD_ALL_outbound.agi completed, returning 0 -- Executing [8368@default:4] AGI("Local/91441316654837@default-9c28,1", "agi-VDAD_ALL_outbound.agi|NORMAL-----LB") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_outbound.agi == Manager 'sendcron' logged off from 127.0.0.1 -- AGI Script agi-VDAD_ALL_outbound.agi completed, returning 0 -- Executing [8368@default:5] Hangup("Local/91441316654837@default-9c28,1", "") in new stack == Spawn extension (default, 8368, 5) exited non-zero on 'Local/91441316654837@default-9c28,1' -- Executing [h@default:1] DeadAGI("Local/91441316654837@default-9c28,1", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16---------------") in new stack -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16--------------- completed, returning 0 -- Executing [h@default:1] DeadAGI("Local/91441316654837@default-9c28,2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----14-----3") in new stack -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----14-----3 completed, returning 0 == Spawn extension (default, 91441316654837, 2) exited non-zero on 'Local/91441316654837@default-9c28,2'

[modified by williamconley for legibility]

by **williamconley** » Wed Feb 13, 2013 4:51 pm

Slow is subjective and could mean you have one agent and get one call every 8 minutes or you have 37 agents and they have to wait more than 8 seconds between calls.

Perhaps you could be more descriptive. LOL

It likely, however, relates to your Campaign settings. For instance: If your hopper is set at "1", the campaign will never be able to call more than 1 call per minute. If your dial ratio is set to "1", the system will dial one channel per agent (and if that one call does not answer, you'll wait for another call to generate while sitting there without a prospect).

So this could well be a simple training issue.

by **skshabbir** » Sun Feb 17, 2013 11:08 am

thanks william

well i want to know how to get all box file of a selective call disposal like(SURMD=Survey made) because i used to download by search number in ftp.

by **williamconley** » Sun Feb 17, 2013 1:21 pm

There is a script in /usr/share/astguiclient/ designed to transfer only SALE dispos to an FTP service. Look around and you'll find it. Execute with "--help" for options. It's designed to gather all sales daily for export.

by **skshabbir** » Thu Sep 26, 2013 2:03 pm

I have installed vicibox 5.0.3 express mode everything works fine but outbound dialling is not working.
I m also running an outdated version of ViCIDIALnow and outbound calling is working fine with the below configuration

here is my dial plan

Code: Select all: register => naxxx:XXXX@203.xxx.xx.xx [testcarrier] disallow=all allow=ulaw type=friend fromuser=naxxxx username=naxxxx secret=SaXXXX host=203.XXX.XX.XX dtmfmode=rfc2833 context=trunkinbound exten => _81,1,AGI(agi://127.0.0.1:4577/call_log) exten => _81,2,Dial(${TESTSIPTRUNK}/${EXTEN:2},,To) exten => _81,3,Hangup

by **williamconley** » Thu Sep 26, 2013 11:00 pm

1) Welcome to the Party! 8-)

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) You omitted your "Globals string" and your dialplan was obviously not cut/pasted properly as it would not work with what you have posted.

4) Your description of "not working" is not particularly detailed. Perhaps you could post a CLI example of a "not working" call attempt?

by **skshabbir** » Fri Sep 27, 2013 12:15 pm

Sorry i am new here i have installed vicibox 5.0.3 single server express mode
and i didn't miss anything in the previous post the sip configuration working fine on Older Version Vicidialnow 1.3
this is the result of CLI

Code: Select all: WARNING[2056]: chan_sip.c:3983 retrans_pkt: Retransmission timeout reached on transmission 72e05a1a3a9acb78039503514b329964@203.XX.XX.XXX:5060 for seqno 102 (Critical Request) -- See https://wiki.asterisk.org/wiki/displa/AST/SIP+Retransmissions Packet timed out after 6399ms with no response [Sep 28 03:50:19] WARNING[2056]: chan_sip.c:4012 retrans_pkt: Hanging up call 72 e05a1a3a9acb78039503514b329964@203.XX.XX.XXX:5060 - no reply to our critical packet (see https://wiki.asterisk.org/wiki/display/AST/SIP+Retransmissions). [Sep 28 03:50:19] == Everyone is busy/congested at this time (1:0/0/1) [Sep 28 03:50:19] -- Executing [8118012770351@default:3] Hangup("Local/8118012770351@default-00000000;2", "") in new stack [Sep 28 03:50:19] == Spawn extension (default, 8118012770351, 3) exited non-zero on 'Local/8118012770351@default-00000000;2' [Sep 28 03:50:19] -- Executing [h@default:1] AGI("Local/8118012770351@default-00000000;2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----18-----CHANUNAVAIL----------") in new stack [Sep 28 03:50:20] WARNING[2056]: chan_sip.c:3983 retrans_pkt: Retransmission timeout reached on transmission 43f6222f1a3d5a363595c47c54f714aa@203.XX.XX.XXX:5060 for seqno 102 (Critical Request) -- See https://wiki.asterisk.org/wiki/display/AST/SIP+Retransmissions

by **skshabbir** » Wed Oct 02, 2013 10:08 am

Hi William Please help i already posted what you have told me...please its really urgent

by **DomeDan** » Thu Oct 03, 2013 3:38 am

I guess the "carrier" 203.X.X.X is your vicidialnow server (you should hide your ip and disable access from the internet to your servers)
Have you setup vicidialnow to act as a trunk?

enable sip debug and take a look at your config

Why don't you use the carrier you use on the vicidialnow server?

by **skshabbir** » Thu Oct 03, 2013 12:08 pm

thanks for you information how do you know ip i didn't mention here and 203.X.X.X is my Carrier address and vicidialNow is my old server and i am creating a new Vicibox sever and both server are behind a router and NAT and i opened port 80 and 22 for outside access .and everything is fine but i am unable to make any outbound call on vicibox server. and i have already mentioned abobe the CLI report.

please reply me quicky

by **DomeDan** » Fri Oct 04, 2013 5:08 am

The ip is in your CLI output.

change the new server to use the same carrier as the old vicidialnow server uses

by **skshabbir** » Fri Oct 04, 2013 9:32 am

yes i did it on new server but still calls not connecting same error as i mentioned above. i have been spending hours and hours on this but still no fix.

by **DomeDan** » Mon Oct 07, 2013 2:45 am

Try the other carrier and post the the output from the CLI,
see it you can catch the lines when it tries to register the carrier

by **skshabbir** » Wed Nov 20, 2013 10:37 am

by **williamconley** » Wed Nov 20, 2013 9:54 pm

Max ratio level is modified in Admin->System Settings.

There's a lot of other stuff in there, too. But only make ONE change at a time and be sure you didn't break anything after each change! 8-)

(Not suggesting you'd break anything ... but ... LOL).

vicidial.org

vicibox clustering

vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

No leads in this Hopper

Re: vicibox clustering

Asterisk Issue

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Vicibox 5.0.3

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Re: vicibox clustering

Who is online