vicidial.org

ronaldmedina74 · Joined: 01 Aug 2009 Posts: 11

Hello Guys Smile

I read about the load_balancing docs so far so good i manage to
install it and tring hard to understand it.

2 server running vicidial

heres my few question ---

1. in the load balancing I dont how if which mysql server to use since
i have both mysql running on both server and there no information on the docs about the mysql setting in /etc/astguiclient.conf

2. If i have 50 agent how will i make the 25 agent login to the other server ? since i have 2 vicidial admin ?

3. How is campiagn being balance ?

3. on the phones setting I notice there is a server ip to connect to asterisk ?

thanks guys, I need help!

okli · Joined: 01 Oct 2007 Posts: 490

ronaldmedina74 · Joined: 01 Aug 2009 Posts: 11

thanks for the answer, Sorry I still have some questions..

Server 1: 192.168.10.1
Server 2: 192.168.10.2

1.
since I have 2 vicidial server and followed the load_balance manual what I need to do now is turn of server 2 mysql and modify server 2 /etc/astguiclient.conf to point its mysql database to server 1,
So agent will now login on server1 192.168.10.1/agc/vicidial.php

2.
Do i need to add a server entry on the vicidial admin(192.168.10.1) for the server 2(192.168.10.2) entry ? cause on the my server1 I have a server entry for server 1.

3.
and since I have 50 agents and what the 25 agent to use the server 2, I will modify in the vicidial admin phone settings server_ip to server 2 (192.168.10.2) ?

4.
Is this settings applicable on manual dialing ?

thanks very very much!

okli · Joined: 01 Oct 2007 Posts: 490

1) yes
2) yes
3) That's bad planning and misunderstanding of load balance purpose, which is to separate MySQL and Apache from asterisk and Vicidial perl scripts.
What are specifications of server 1 and server 2?
To achieve better performance you will need to be logging lets say 5-10 agents on server 1 and the rest on server 2, if both servers are powerful enough to hold that load.
You need to keep the load on the MySQL server low, at the same time not overloading server 2, so you will need to play a bit how many agents on which server to log. In any case, the one with MySQL should have way less agents logged.
The proper solution for 50 agents would be with 3 machines- 2 asterisk/vicidial and 1 only MySQL/Apache, which should be the most powerful one.
4) Not quite sure if manual calls can be balanced, but they do not create such load anyway, if that's the issue

ronaldmedina74 · Joined: 01 Aug 2009 Posts: 11

many thanks okli !

ON my number 3 question is that a yes ? if that is a yes then the admin->phone->server_ip is the one who control which asterisk server to use.

Your Right, I have 2 Identical specs on the 2 servers, will move the apache and mysql to server 3 then modify /etc/astguiclient.conf on server 1 to use server 4 mysql.

Is there something to check on NTP settings for the 3 servers in order for them to synchronize ?

thanks okli ....

okli · Joined: 01 Oct 2007 Posts: 490

ykhan · Joined: 08 Jun 2006 Posts: 350

I don't mean to hijack this thread, but since my issue is similar I figured this may be good place to post.

I have followed the Load Balancing text file to setup a multiserver system. Here is the setup

Server 1
VicidialNOW 1.2 CE
Vicidial 2.0.5
IP: 192.168.2.1
Vicidial+Asterisk+MySQL+Apache+FTP

Server2
VicidialNOW 1.2 CE
Vicidial 2.0.5
IP: 192.168.2.2
Vicidial+Asterisk+MySQL+Apache+FTP

Since DB information is not detailed in the text file, I wanted to get some clarification on this. I have the two servers registering with each other with IAX. I have also added an entry in Server1 for Server2. I have also amended the astguiclient.conf file in Server2 to use the DB in Server1 (this is the step I am not too sure about). Also I am getting the following error for DB connections:

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

Use this SQL statement to add the 2nd server:

-------------------------------

INSERT INTO servers (server_id,server_description,server_ip,active,asterisk_version)values('TESTast','Test install of Asterisk server', '10.10.10.15','Y','1.4.21.2');

INSERT INTO server_updater SET server_ip='10.10.10.15', last_update='';
INSERT INTO conferences values('8600001','10.10.10.15','');
INSERT INTO conferences values('8600002','10.10.10.15','');
INSERT INTO conferences values('8600003','10.10.10.15','');
INSERT INTO conferences values('8600004','10.10.10.15','');
INSERT INTO conferences values('8600005','10.10.10.15','');
INSERT INTO conferences values('8600006','10.10.10.15','');
INSERT INTO conferences values('8600007','10.10.10.15','');
INSERT INTO conferences values('8600008','10.10.10.15','');
INSERT INTO conferences values('8600009','10.10.10.15','');
INSERT INTO conferences values('8600010','10.10.10.15','');
INSERT INTO conferences values('8600011','10.10.10.15','');
INSERT INTO conferences values('8600012','10.10.10.15','');
INSERT INTO conferences values('8600013','10.10.10.15','');
INSERT INTO conferences values('8600014','10.10.10.15','');
INSERT INTO conferences values('8600015','10.10.10.15','');
INSERT INTO conferences values('8600016','10.10.10.15','');
INSERT INTO conferences values('8600017','10.10.10.15','');
INSERT INTO conferences values('8600018','10.10.10.15','');
INSERT INTO conferences values('8600019','10.10.10.15','');
INSERT INTO conferences values('8600020','10.10.10.15','');
INSERT INTO conferences values('8600021','10.10.10.15','');
INSERT INTO conferences values('8600022','10.10.10.15','');
INSERT INTO conferences values('8600023','10.10.10.15','');
INSERT INTO conferences values('8600024','10.10.10.15','');
INSERT INTO conferences values('8600025','10.10.10.15','');
INSERT INTO conferences values('8600026','10.10.10.15','');
INSERT INTO conferences values('8600027','10.10.10.15','');
INSERT INTO conferences values('8600028','10.10.10.15','');
INSERT INTO conferences values('8600029','10.10.10.15','');
INSERT INTO conferences values('8600030','10.10.10.15','');
INSERT INTO conferences values('8600031','10.10.10.15','');
INSERT INTO conferences values('8600032','10.10.10.15','');
INSERT INTO conferences values('8600033','10.10.10.15','');
INSERT INTO conferences values('8600034','10.10.10.15','');
INSERT INTO conferences values('8600035','10.10.10.15','');
INSERT INTO conferences values('8600036','10.10.10.15','');
INSERT INTO conferences values('8600037','10.10.10.15','');
INSERT INTO conferences values('8600038','10.10.10.15','');
INSERT INTO conferences values('8600039','10.10.10.15','');
INSERT INTO conferences values('8600040','10.10.10.15','');
INSERT INTO conferences values('8600041','10.10.10.15','');
INSERT INTO conferences values('8600042','10.10.10.15','');
INSERT INTO conferences values('8600043','10.10.10.15','');
INSERT INTO conferences values('8600044','10.10.10.15','');
INSERT INTO conferences values('8600045','10.10.10.15','');
INSERT INTO conferences values('8600046','10.10.10.15','');
INSERT INTO conferences values('8600047','10.10.10.15','');
INSERT INTO conferences values('8600048','10.10.10.15','');
INSERT INTO conferences values('8600049','10.10.10.15','');

INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600051','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600052','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600053','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600054','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600055','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600056','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600057','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600058','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600059','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600060','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600061','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600062','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600063','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600064','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600065','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600066','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600067','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600068','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600069','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600070','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600071','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600072','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600073','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600074','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600075','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600076','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600077','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600078','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600079','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600080','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600081','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600082','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600083','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600084','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600085','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600086','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600087','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600088','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600089','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600090','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600091','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600092','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600093','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600094','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600095','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600096','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600097','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600098','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600099','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600100','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600101','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600102','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600103','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600104','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600105','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600106','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600107','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600108','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600109','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600110','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600111','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600112','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600113','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600114','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600115','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600116','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600117','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600118','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600119','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600120','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600121','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600122','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600123','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600124','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600125','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600126','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600127','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600128','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600129','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600130','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600131','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600132','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600133','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600134','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600135','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600136','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600137','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600138','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600139','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600140','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600141','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600142','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600143','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600144','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600145','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600146','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600147','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600148','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600149','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600150','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600151','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600152','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600153','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600154','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600155','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600156','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600157','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600158','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600159','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600160','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600161','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600162','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600163','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600164','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600165','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600166','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600167','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600168','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600169','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600170','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600171','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600172','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600173','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600174','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600175','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600176','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600177','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600178','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600179','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600180','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600181','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600182','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600183','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600184','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600185','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600186','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600187','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600188','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600189','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600190','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600191','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600192','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600193','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600194','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600195','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600196','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600197','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600198','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600199','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600200','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600201','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600202','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600203','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600204','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600205','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600206','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600207','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600208','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600209','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600210','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600211','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600212','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600213','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600214','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600215','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600216','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600217','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600218','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600219','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600220','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600221','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600222','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600223','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600224','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600225','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600226','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600227','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600228','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600229','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600230','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600231','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600232','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600233','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600234','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600235','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600236','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600237','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600238','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600239','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600240','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600241','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600242','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600243','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600244','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600245','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600246','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600247','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600248','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600249','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600250','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600251','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600252','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600253','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600254','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600255','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600256','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600257','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600258','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600259','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600260','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600261','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600262','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600263','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600264','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600265','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600266','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600267','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600268','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600269','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600270','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600271','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600272','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600273','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600274','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600275','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600276','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600277','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600278','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600279','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600280','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600281','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600282','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600283','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600284','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600285','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600286','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600287','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600288','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600289','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600290','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600291','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600292','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600293','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600294','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600295','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600296','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600297','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600298','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600299','10.10.10.15');

---------------------------------------------------------------

Then after that you can do a /usr/share/astguiclient/ADMIN_update_server_ip.pl

And set the ip to your 2nd servers ip address

ykhan · Joined: 08 Jun 2006 Posts: 350

Thanks for the details.

I have one VoIP carrier, so do I create an entry for the same carrier on both servers?
_________________
Yousaf Khan
For installation and Support.
VoIP to North America from $0.009/min
Phone: +1 (647) 891-5426
Email: ykhan@duologuecommunications.com

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

yes you need to install the voip carrier settings on both asterisk / vicidial servers

ykhan · Joined: 08 Jun 2006 Posts: 350

I keep getting the following error for MySQL connections from 192.168.2.2 to 192.168.2.1:

Op3r · Joined: 08 Jun 2006 Posts: 1262 Location: Manila

if you have bothered to take a look at the error it means that it cant connect to the mysql server.

What to do in this case:

Check network connect

Check if mysql is running on that server

Check credentials

check firewall
_________________
VICIDIALNOW - http://www.vicidialnow.org | Philippine Call Center Outsourcing

ykhan · Joined: 08 Jun 2006 Posts: 350

Thanks Op3r, I did figure that MySQL could not connect when I read "Can't connect to MySQL server on '192.168.2.1'". I have checked the following as recommended:

Check network connect
No Issues found. Network is up.

Check if mysql is running on that server
Yes, MYSQL is running on 192.168.2.1

Check credentials
I have allowed 192.168.2.2 to connect using cron and 1234, therefore the error is not related to authentication.

check firewall
No firewall.
_________________
Yousaf Khan
For installation and Support.
VoIP to North America from $0.009/min
Phone: +1 (647) 891-5426
Email: ykhan@duologuecommunications.com

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

can you login via mysql console via the other server which is 192.168.2.2, you can do this by typing

mysql -u cron -p -h 192.168.2.1

if you cant connect from it, check if the firewall is enabled, you can also type this in your mysql server to verify its running the service:

netstat -naptu | grep 3306

ruben23 · Posted: Wed Nov 18, 2009 12:55 am Post subject:

@ boy bawang:

hi, i have issues also with load balance setup, but im just curious with your suggestion on this:

For those who are confused on which server the agents can log in, it can be 25 on the first server and 25 on the other server, you just need to disable the duplicate extensions, like for example if you want to use cc100 to cc125 in server 1, you just need to disable cc126 down to cc150, and on server 2 you need to disable cc100 to cc125.

coz what i did was i make cc100 for server1 and i also make cc100 for server2, i duplicated all the phone extensions on both servers....
How to properly setup it...? coz with my server2 phone extensions i cant login--->no ring back on login and meetme conference not found..

should you procedure will correct it..? Thanks
_________________
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.2.0-234
BUILD: 100116-0718
Dahdi 2.2.0.2
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

Again heres a simple example:

Asterisk/Vicidial Server 1 use cc100 to cc125 phone extensions, disable or delete the other extensions

Asterisk/ Vicidial Server2 use cc126 to cc150 phone extensions, disable or delete the other extensions

Put the voip carrier settings on both servers

Then adjust the load balance percentage on both servers in the admin interface.

For inbound you can set the settings to LB which is load balanced so when a call comes in the it will hunt for agents on both servers.

ykhan · Joined: 08 Jun 2006 Posts: 350

Here is my confusion on what has been given:

Boybawang said

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

server 1 and server 2 have different sip.conf and extensions.conf which are not database related

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

This part of /etc/astguiclient.conf should be pointed to your central mysql server

# Database connection information
VARDB_server => ip.address.of.your.mysql.server
VARDB_database => asterisk
VARDB_user => cron
VARDB_pass => 1234
VARDB_port => 3306

ykhan · Joined: 08 Jun 2006 Posts: 350

Ok, so the carrier details on Server2 will be setup in sip.conf NOT Admin>Carriers?

And the Server1 and Server2 entries will only be on Server1 (since this is where the database wil be)?

Really appreciate all your help.
_________________
Yousaf Khan
For installation and Support.
VoIP to North America from $0.009/min
Phone: +1 (647) 891-5426
Email: ykhan@duologuecommunications.com

ykhan · Joined: 08 Jun 2006 Posts: 350

In terms of Vicidial Conferences, can I just point anything above 8600152 to Server2? i.e. should all vicidial conferences point to the same server or shoudl the conferences be split between the two servers?
_________________
Yousaf Khan
For installation and Support.
VoIP to North America from $0.009/min
Phone: +1 (647) 891-5426
Email: ykhan@duologuecommunications.com

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

all vicidial conferences should be the same for both servers, they will be distinguished by the servers ip address, please refer to the SQL statement I posted recentlyy

ruben23 · Posted: Thu Nov 19, 2009 5:27 pm Post subject:

@boy bawang:

You mean by all vicidial conferences should be the same for both servers, they will be distinguished by the servers ip address,

it is generated automatically or do i need to manually add up it onto my vicidial admin page- just like what i have done with Server 2- i add up manually...
_________________
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.2.0-234
BUILD: 100116-0718
Dahdi 2.2.0.2
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...

Op3r · Joined: 08 Jun 2006 Posts: 1262 Location: Manila

@ruben

Yes you should put the same conferences.

Yes you have to put it manually.
_________________
VICIDIALNOW - http://www.vicidialnow.org | Philippine Call Center Outsourcing

ykhan · Joined: 08 Jun 2006 Posts: 350

I have followed the instructions and can now login agents on both servers. One thing though, that I can login using a phone registerd on Server2 from Server1 IP address as well. Should we continue this practice since it does not seem to be affecting the away calls are thrown for login?
_________________
Yousaf Khan
For installation and Support.
VoIP to North America from $0.009/min
Phone: +1 (647) 891-5426
Email: ykhan@duologuecommunications.com

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

Use this SQL for reference when installing another additional server:

INSERT INTO servers (server_id,server_description,server_ip,active,asterisk_version)values('TESTast','Test install of Asterisk server', '10.10.10.15','Y','1.2.26.2');

INSERT INTO server_updater SET server_ip='10.10.10.15', last_update='';

INSERT INTO conferences values('8600001','10.10.10.15','');
INSERT INTO conferences values('8600002','10.10.10.15','');
INSERT INTO conferences values('8600003','10.10.10.15','');
INSERT INTO conferences values('8600004','10.10.10.15','');
INSERT INTO conferences values('8600005','10.10.10.15','');
INSERT INTO conferences values('8600006','10.10.10.15','');
INSERT INTO conferences values('8600007','10.10.10.15','');
INSERT INTO conferences values('8600008','10.10.10.15','');
INSERT INTO conferences values('8600009','10.10.10.15','');
INSERT INTO conferences values('8600010','10.10.10.15','');
INSERT INTO conferences values('8600011','10.10.10.15','');
INSERT INTO conferences values('8600012','10.10.10.15','');
INSERT INTO conferences values('8600013','10.10.10.15','');
INSERT INTO conferences values('8600014','10.10.10.15','');
INSERT INTO conferences values('8600015','10.10.10.15','');
INSERT INTO conferences values('8600016','10.10.10.15','');
INSERT INTO conferences values('8600017','10.10.10.15','');
INSERT INTO conferences values('8600018','10.10.10.15','');
INSERT INTO conferences values('8600019','10.10.10.15','');
INSERT INTO conferences values('8600020','10.10.10.15','');
INSERT INTO conferences values('8600021','10.10.10.15','');
INSERT INTO conferences values('8600022','10.10.10.15','');
INSERT INTO conferences values('8600023','10.10.10.15','');
INSERT INTO conferences values('8600024','10.10.10.15','');
INSERT INTO conferences values('8600025','10.10.10.15','');
INSERT INTO conferences values('8600026','10.10.10.15','');
INSERT INTO conferences values('8600027','10.10.10.15','');
INSERT INTO conferences values('8600028','10.10.10.15','');
INSERT INTO conferences values('8600029','10.10.10.15','');
INSERT INTO conferences values('8600030','10.10.10.15','');
INSERT INTO conferences values('8600031','10.10.10.15','');
INSERT INTO conferences values('8600032','10.10.10.15','');
INSERT INTO conferences values('8600033','10.10.10.15','');
INSERT INTO conferences values('8600034','10.10.10.15','');
INSERT INTO conferences values('8600035','10.10.10.15','');
INSERT INTO conferences values('8600036','10.10.10.15','');
INSERT INTO conferences values('8600037','10.10.10.15','');
INSERT INTO conferences values('8600038','10.10.10.15','');
INSERT INTO conferences values('8600039','10.10.10.15','');
INSERT INTO conferences values('8600040','10.10.10.15','');
INSERT INTO conferences values('8600041','10.10.10.15','');
INSERT INTO conferences values('8600042','10.10.10.15','');
INSERT INTO conferences values('8600043','10.10.10.15','');
INSERT INTO conferences values('8600044','10.10.10.15','');
INSERT INTO conferences values('8600045','10.10.10.15','');
INSERT INTO conferences values('8600046','10.10.10.15','');
INSERT INTO conferences values('8600047','10.10.10.15','');
INSERT INTO conferences values('8600048','10.10.10.15','');
INSERT INTO conferences values('8600049','10.10.10.15','');

INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600051','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600052','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600053','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600054','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600055','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600056','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600057','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600058','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600059','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600060','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600061','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600062','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600063','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600064','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600065','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600066','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600067','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600068','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600069','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600070','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600071','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600072','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600073','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600074','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600075','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600076','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600077','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600078','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600079','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600080','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600081','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600082','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600083','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600084','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600085','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600086','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600087','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600088','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600089','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600090','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600091','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600092','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600093','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600094','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600095','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600096','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600097','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600098','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600099','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600100','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600101','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600102','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600103','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600104','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600105','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600106','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600107','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600108','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600109','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600110','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600111','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600112','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600113','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600114','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600115','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600116','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600117','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600118','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600119','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600120','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600121','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600122','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600123','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600124','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600125','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600126','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600127','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600128','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600129','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600130','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600131','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600132','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600133','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600134','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600135','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600136','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600137','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600138','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600139','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600140','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600141','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600142','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600143','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600144','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600145','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600146','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600147','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600148','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600149','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600150','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600151','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600152','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600153','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600154','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600155','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600156','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600157','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600158','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600159','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600160','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600161','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600162','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600163','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600164','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600165','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600166','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600167','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600168','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600169','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600170','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600171','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600172','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600173','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600174','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600175','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600176','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600177','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600178','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600179','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600180','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600181','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600182','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600183','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600184','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600185','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600186','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600187','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600188','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600189','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600190','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600191','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600192','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600193','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600194','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600195','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600196','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600197','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600198','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600199','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600200','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600201','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600202','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600203','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600204','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600205','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600206','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600207','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600208','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600209','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600210','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600211','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600212','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600213','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600214','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600215','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600216','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600217','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600218','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600219','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600220','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600221','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600222','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600223','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600224','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600225','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600226','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600227','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600228','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600229','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600230','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600231','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600232','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600233','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600234','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600235','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600236','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600237','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600238','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600239','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600240','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600241','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600242','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600243','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600244','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600245','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600246','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600247','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600248','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600249','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600250','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600251','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600252','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600253','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600254','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600255','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600256','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600257','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600258','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600259','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600260','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600261','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600262','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600263','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600264','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600265','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600266','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600267','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600268','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600269','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600270','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600271','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600272','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600273','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600274','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600275','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600276','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600277','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600278','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600279','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600280','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600281','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600282','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600283','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600284','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600285','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600286','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600287','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600288','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600289','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600290','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600291','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600292','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600293','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600294','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600295','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600296','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600297','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600298','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600299','10.10.10.15');

INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc100','100','100','10.10.10.15','100','test','ACTIVE','Y','CCagent','station 100','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc101','101','101','10.10.10.15','101','test','ACTIVE','Y','CCagent','station 101','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc102','102','102','10.10.10.15','102','test','ACTIVE','Y','CCagent','station 102','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc103','103','103','10.10.10.15','103','test','ACTIVE','Y','CCagent','station 103','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc104','104','104','10.10.10.15','104','test','ACTIVE','Y','CCagent','station 104','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc105','105','105','10.10.10.15','105','test','ACTIVE','Y','CCagent','station 105','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc106','106','106','10.10.10.15','106','test','ACTIVE','Y','CCagent','station 106','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc107','107','107','10.10.10.15','107','test','ACTIVE','Y','CCagent','station 107','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc108','108','108','10.10.10.15','108','test','ACTIVE','Y','CCagent','station 108','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc109','109','109','10.10.10.15','109','test','ACTIVE','Y','CCagent','station 109','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc110','110','110','10.10.10.15','110','test','ACTIVE','Y','CCagent','station 110','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc111','111','111','10.10.10.15','111','test','ACTIVE','Y','CCagent','station 111','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc112','112','112','10.10.10.15','112','test','ACTIVE','Y','CCagent','station 112','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc113','113','113','10.10.10.15','113','test','ACTIVE','Y','CCagent','station 113','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc114','114','114','10.10.10.15','114','test','ACTIVE','Y','CCagent','station 114','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc115','115','115','10.10.10.15','115','test','ACTIVE','Y','CCagent','station 115','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc116','116','116','10.10.10.15','116','test','ACTIVE','Y','CCagent','station 116','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc117','117','117','10.10.10.15','117','test','ACTIVE','Y','CCagent','station 117','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc118','118','118','10.10.10.15','118','test','ACTIVE','Y','CCagent','station 118','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc119','119','119','10.10.10.15','119','test','ACTIVE','Y','CCagent','station 119','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc120','120','120','10.10.10.15','120','test','ACTIVE','Y','CCagent','station 120','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc121','121','121','10.10.10.15','121','test','ACTIVE','Y','CCagent','station 121','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc122','122','122','10.10.10.15','122','test','ACTIVE','Y','CCagent','station 122','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc123','123','123','10.10.10.15','123','test','ACTIVE','Y','CCagent','station 123','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc124','124','124','10.10.10.15','124','test','ACTIVE','Y','CCagent','station 124','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc125','125','125','10.10.10.15','125','test','ACTIVE','Y','CCagent','station 125','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc126','126','126','10.10.10.15','126','test','ACTIVE','Y','CCagent','station 126','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc127','127','127','10.10.10.15','127','test','ACTIVE','Y','CCagent','station 127','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc128','128','128','10.10.10.15','128','test','ACTIVE','Y','CCagent','station 128','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc129','129','129','10.10.10.15','129','test','ACTIVE','Y','CCagent','station 129','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc130','130','130','10.10.10.15','130','test','ACTIVE','Y','CCagent','station 130','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc131','131','131','10.10.10.15','131','test','ACTIVE','Y','CCagent','station 131','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc132','132','132','10.10.10.15','132','test','ACTIVE','Y','CCagent','station 132','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc133','133','133','10.10.10.15','133','test','ACTIVE','Y','CCagent','station 133','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc134','134','134','10.10.10.15','134','test','ACTIVE','Y','CCagent','station 134','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc135','135','135','10.10.10.15','135','test','ACTIVE','Y','CCagent','station 135','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc136','136','136','10.10.10.15','136','test','ACTIVE','Y','CCagent','station 136','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc137','137','137','10.10.10.15','137','test','ACTIVE','Y','CCagent','station 137','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc138','138','138','10.10.10.15','138','test','ACTIVE','Y','CCagent','station 138','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc139','139','139','10.10.10.15','139','test','ACTIVE','Y','CCagent','station 139','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc140','140','140','10.10.10.15','140','test','ACTIVE','Y','CCagent','station 140','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc141','141','141','10.10.10.15','141','test','ACTIVE','Y','CCagent','station 141','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc142','142','142','10.10.10.15','142','test','ACTIVE','Y','CCagent','station 142','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc143','143','143','10.10.10.15','143','test','ACTIVE','Y','CCagent','station 143','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc144','144','144','10.10.10.15','144','test','ACTIVE','Y','CCagent','station 144','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc145','145','145','10.10.10.15','145','test','ACTIVE','Y','CCagent','station 145','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc146','146','146','10.10.10.15','146','test','ACTIVE','Y','CCagent','station 146','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc147','147','147','10.10.10.15','147','test','ACTIVE','Y','CCagent','station 147','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc148','148','148','10.10.10.15','148','test','ACTIVE','Y','CCagent','station 148','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc149','149','149','10.10.10.15','149','test','ACTIVE','Y','CCagent','station 149','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc150','150','150','10.10.10.15','150','test','ACTIVE','Y','CCagent','station 150','SIP','-5','0000000000');

INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc300','300','300','10.10.10.15','300','test','ACTIVE','Y','CCagent','station 300','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc301','301','301','10.10.10.15','301','test','ACTIVE','Y','CCagent','station 301','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc302','302','302','10.10.10.15','302','test','ACTIVE','Y','CCagent','station 302','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc303','303','303','10.10.10.15','303','test','ACTIVE','Y','CCagent','station 303','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc304','304','304','10.10.10.15','304','test','ACTIVE','Y','CCagent','station 304','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc305','305','305','10.10.10.15','305','test','ACTIVE','Y','CCagent','station 305','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc306','306','306','10.10.10.15','306','test','ACTIVE','Y','CCagent','station 306','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc307','307','307','10.10.10.15','307','test','ACTIVE','Y','CCagent','station 307','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc308','308','308','10.10.10.15','308','test','ACTIVE','Y','CCagent','station 308','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc309','309','309','10.10.10.15','309','test','ACTIVE','Y','CCagent','station 309','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc310','310','310','10.10.10.15','310','test','ACTIVE','Y','CCagent','station 310','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc311','311','311','10.10.10.15','311','test','ACTIVE','Y','CCagent','station 311','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc312','312','312','10.10.10.15','312','test','ACTIVE','Y','CCagent','station 312','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc313','313','313','10.10.10.15','313','test','ACTIVE','Y','CCagent','station 313','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc314','314','314','10.10.10.15','314','test','ACTIVE','Y','CCagent','station 314','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc315','315','315','10.10.10.15','315','test','ACTIVE','Y','CCagent','station 315','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc316','316','316','10.10.10.15','316','test','ACTIVE','Y','CCagent','station 316','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc317','317','317','10.10.10.15','317','test','ACTIVE','Y','CCagent','station 317','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc318','318','318','10.10.10.15','318','test','ACTIVE','Y','CCagent','station 318','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc319','319','319','10.10.10.15','319','test','ACTIVE','Y','CCagent','station 319','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc320','320','320','10.10.10.15','320','test','ACTIVE','Y','CCagent','station 320','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc321','321','321','10.10.10.15','321','test','ACTIVE','Y','CCagent','station 321','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc322','322','322','10.10.10.15','322','test','ACTIVE','Y','CCagent','station 322','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc323','323','323','10.10.10.15','323','test','ACTIVE','Y','CCagent','station 323','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc324','324','324','10.10.10.15','324','test','ACTIVE','Y','CCagent','station 324','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc325','325','325','10.10.10.15','325','test','ACTIVE','Y','CCagent','station 325','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc326','326','326','10.10.10.15','326','test','ACTIVE','Y','CCagent','station 326','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc327','327','327','10.10.10.15','327','test','ACTIVE','Y','CCagent','station 327','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc328','328','328','10.10.10.15','328','test','ACTIVE','Y','CCagent','station 328','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc329','329','329','10.10.10.15','329','test','ACTIVE','Y','CCagent','station 329','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc330','330','330','10.10.10.15','330','test','ACTIVE','Y','CCagent','station 330','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc331','331','331','10.10.10.15','331','test','ACTIVE','Y','CCagent','station 331','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc332','332','332','10.10.10.15','332','test','ACTIVE','Y','CCagent','station 332','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc333','333','333','10.10.10.15','333','test','ACTIVE','Y','CCagent','station 333','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc334','334','334','10.10.10.15','334','test','ACTIVE','Y','CCagent','station 334','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc335','335','335','10.10.10.15','335','test','ACTIVE','Y','CCagent','station 335','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc336','336','336','10.10.10.15','336','test','ACTIVE','Y','CCagent','station 336','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc337','337','337','10.10.10.15','337','test','ACTIVE','Y','CCagent','station 337','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc338','338','338','10.10.10.15','338','test','ACTIVE','Y','CCagent','station 338','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc339','339','339','10.10.10.15','339','test','ACTIVE','Y','CCagent','station 339','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc340','340','340','10.10.10.15','340','test','ACTIVE','Y','CCagent','station 340','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc341','341','341','10.10.10.15','341','test','ACTIVE','Y','CCagent','station 341','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc342','342','342','10.10.10.15','342','test','ACTIVE','Y','CCagent','station 342','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc343','343','343','10.10.10.15','343','test','ACTIVE','Y','CCagent','station 343','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc344','344','344','10.10.10.15','344','test','ACTIVE','Y','CCagent','station 344','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc345','345','345','10.10.10.15','345','test','ACTIVE','Y','CCagent','station 345','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc346','346','346','10.10.10.15','346','test','ACTIVE','Y','CCagent','station 346','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc347','347','347','10.10.10.15','347','test','ACTIVE','Y','CCagent','station 347','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc348','348','348','10.10.10.15','348','test','ACTIVE','Y','CCagent','station 348','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc349','349','349','10.10.10.15','349','test','ACTIVE','Y','CCagent','station 349','IAX2','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc350','350','350','10.10.10.15','350','test','ACTIVE','Y','CCagent','station 350','IAX2','-5','0000000000');

*PS: If you take a look at /astguiclient/extras directory you will find alot of interesting scripts that will help you learn more about setting up multi server.

Be sure to update 10.10.10.15 with your IP address. I will be having a moodle session on this, will only be limiting it to 10 online students.

ruben23 · Posted: Fri Nov 20, 2009 4:53 pm Post subject:

@boybawang:

Yes i have check already the mysql server with phpmyadmin----> i have details of the meetme conference of my server 2 asterisk/vicidial---> problem is when logging in the phone extensions made for server 2, i get conference 8600051 not found....on the asterisk CLI;

and also the phone extension is not duplicated to the server 1. where could be the issue.. Sad

_________________
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.2.0-234
BUILD: 100116-0718
Dahdi 2.2.0.2
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

make sure its already written in the dialplan which is sip-vicidial.conf & extensions-vicidial.conf try checking it there if your phone and meetme entries are there for server 2. Try doing a Rebuild Conf files

ruben23 · Posted: Wed Nov 25, 2009 11:06 pm Post subject:

Rebuild conf means..?

i should run again the agc setup (perl install.pl) for trunk..? or add the sql statement you mention above...? Sad

_________________
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.2.0-234
BUILD: 100116-0718
Dahdi 2.2.0.2
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

rebuild conf means going to the admin webinterface then servers then set REBUILD CONF to Y or Yes
_________________
Linux + Asterisk + Vicidial + A2billing + FreePbx + Quemetrics + Vtiger Integration + Custom Vicidial Development
Rates are 50% off all the other consultants rates
24/7 Paid Vicidial Support Services
24/7 Vicidial/Asterisk Training Services

ruben23 · Posted: Fri Nov 27, 2009 9:30 am Post subject:

yes i tried the rebuild still when i tried to login using the phone extension of my server2 i got this:

-- Executing [55558600051@default:1] MeetMeAdmin("Local/55558600051@default-5072,2", "8600051|K") in new stack
[Nov 27 01:20:19] WARNING[6833]: app_meetme.c:2821 admin_exec: Conference number '8600051' not found!
[Nov 27 01:20:19] -- Executing [55558600051@default:2] Hangup("Local/55558600051@default-5072,2", "") in new stack
[Nov 27 01:20:19] == Spawn extension (default, 55558600051, 2) exited non-zero on 'Local/55558600051@default-5072,2'
[Nov 27 01:20:19] -- Executing [h@default:1] DeadAGI("Local/55558600051@default-5072,2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16---------------") in new stack
[Nov 27 01:20:19] -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----

should i manually input the mysql statement you have given on my databased server by

login as root then use asterisk databsed then input the statement then update the asterisk ip address on server2.
_________________
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.2.0-234
BUILD: 100116-0718
Dahdi 2.2.0.2
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...

boybawang · Joined: 14 Nov 2009 Posts: 315 Location: Philippines

yes
_________________
Linux + Asterisk + Vicidial + A2billing + FreePbx + Quemetrics + Vtiger Integration + Custom Vicidial Development
Rates are 50% off all the other consultants rates
24/7 Paid Vicidial Support Services
24/7 Vicidial/Asterisk Training Services

ykhan · Joined: 08 Jun 2006 Posts: 350

I have setup two load balanced servers:

Vicidial1 (VicidialNOW 1.2 CE,Vicidial VERSION: 2.0.5-173
BUILD: 90320-0424)
Vicidial2 (VicidialNOW 1.2 CE,Vicidial VERSION: 2.0.5-173
BUILD: 90320-0424)

All dialing from Vicidial1 is ok, and we can successfully make calls from Vicidial2 (manually from Xlite).

When an agent logs into Vicidial2 server (i.e. the phone is registered to Vicidial2), calls are not getting connected. Dialer dials the calls, but when answered, Vicidial cannot transfer to the agent.

Following is the CLI:

voipclear · Joined: 04 Apr 2009 Posts: 8

Paste the first part of your extensions.conf (Up to '; # timeout invalid rules
' section), extensions-vicidial.conf, iax.conf, and iax-vicidial.conf for both servers.

Based on this:

-- Called Vicidial1:test@203.XXX.XXX.14:4569/8600054
-- IAX2/Vicidial1-10047 is circuit-busy
Feb 8 17:55:48 WARNING[18283]: chan_iax2.c:7435 socket_read: Call rejected by 203.XXX.XXX.14: No authority found

I'd say it'll be easy to fix. Just need to find the error in asterisk config file.

ykhan · Joined: 08 Jun 2006 Posts: 350

I have noticed that this issue seems to be creeping up only for UK numbers. I tried it with North American numbers and the dialer dials out ok and connects calls as well. Following is the requested config information.

VICIDIAL1 (203.XXX.XXX.14)

Extensions.conf

ykhan · Joined: 08 Jun 2006 Posts: 350

ISSUE RESOLVED:

The issue was with the following lines in extensions.conf of both servers: