Posted:
Tue Nov 16, 2010 2:27 amby Op3r
use cron and 1234 for password on the mysql
then add the entries for conferences.
Here's what I use.
Change the ip and the phones when adding additional servers.
INSERT INTO servers (server_id,server_description,server_ip,active,asterisk_version)values('Asterisk3','Asterisk 3 server', '10.10.10.22','Y','1.2.30.2');
INSERT INTO server_updater SET server_ip='10.10.10.22', last_update='';
INSERT INTO conferences values('8600001','10.10.10.22','');
INSERT INTO conferences values('8600002','10.10.10.22','');
INSERT INTO conferences values('8600003','10.10.10.22','');
INSERT INTO conferences values('8600004','10.10.10.22','');
INSERT INTO conferences values('8600005','10.10.10.22','');
INSERT INTO conferences values('8600006','10.10.10.22','');
INSERT INTO conferences values('8600007','10.10.10.22','');
INSERT INTO conferences values('8600008','10.10.10.22','');
INSERT INTO conferences values('8600009','10.10.10.22','');
INSERT INTO conferences values('8600010','10.10.10.22','');
INSERT INTO conferences values('8600011','10.10.10.22','');
INSERT INTO conferences values('8600012','10.10.10.22','');
INSERT INTO conferences values('8600013','10.10.10.22','');
INSERT INTO conferences values('8600014','10.10.10.22','');
INSERT INTO conferences values('8600015','10.10.10.22','');
INSERT INTO conferences values('8600016','10.10.10.22','');
INSERT INTO conferences values('8600017','10.10.10.22','');
INSERT INTO conferences values('8600018','10.10.10.22','');
INSERT INTO conferences values('8600019','10.10.10.22','');
INSERT INTO conferences values('8600020','10.10.10.22','');
INSERT INTO conferences values('8600021','10.10.10.22','');
INSERT INTO conferences values('8600022','10.10.10.22','');
INSERT INTO conferences values('8600023','10.10.10.22','');
INSERT INTO conferences values('8600024','10.10.10.22','');
INSERT INTO conferences values('8600025','10.10.10.22','');
INSERT INTO conferences values('8600026','10.10.10.22','');
INSERT INTO conferences values('8600027','10.10.10.22','');
INSERT INTO conferences values('8600028','10.10.10.22','');
INSERT INTO conferences values('8600029','10.10.10.22','');
INSERT INTO conferences values('8600030','10.10.10.22','');
INSERT INTO conferences values('8600031','10.10.10.22','');
INSERT INTO conferences values('8600032','10.10.10.22','');
INSERT INTO conferences values('8600033','10.10.10.22','');
INSERT INTO conferences values('8600034','10.10.10.22','');
INSERT INTO conferences values('8600035','10.10.10.22','');
INSERT INTO conferences values('8600036','10.10.10.22','');
INSERT INTO conferences values('8600037','10.10.10.22','');
INSERT INTO conferences values('8600038','10.10.10.22','');
INSERT INTO conferences values('8600039','10.10.10.22','');
INSERT INTO conferences values('8600040','10.10.10.22','');
INSERT INTO conferences values('8600041','10.10.10.22','');
INSERT INTO conferences values('8600042','10.10.10.22','');
INSERT INTO conferences values('8600043','10.10.10.22','');
INSERT INTO conferences values('8600044','10.10.10.22','');
INSERT INTO conferences values('8600045','10.10.10.22','');
INSERT INTO conferences values('8600046','10.10.10.22','');
INSERT INTO conferences values('8600047','10.10.10.22','');
INSERT INTO conferences values('8600048','10.10.10.22','');
INSERT INTO conferences values('8600049','10.10.10.22','');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600051','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600052','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600053','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600054','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600055','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600056','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600057','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600058','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600059','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600060','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600061','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600062','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600063','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600064','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600065','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600066','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600067','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600068','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600069','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600070','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600071','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600072','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600073','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600074','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600075','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600076','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600077','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600078','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600079','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600080','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600081','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600082','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600083','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600084','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600085','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600086','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600087','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600088','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600089','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600090','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600091','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600092','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600093','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600094','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600095','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600096','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600097','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600098','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600099','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600100','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600101','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600102','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600103','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600104','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600105','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600106','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600107','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600108','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600109','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600110','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600111','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600112','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600113','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600114','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600115','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600116','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600117','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600118','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600119','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600120','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600121','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600122','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600123','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600124','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600125','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600126','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600127','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600128','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600129','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600130','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600131','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600132','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600133','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600134','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600135','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600136','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600137','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600138','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600139','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600140','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600141','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600142','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600143','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600144','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600145','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600146','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600147','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600148','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600149','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600150','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600151','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600152','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600153','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600154','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600155','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600156','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600157','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600158','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600159','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600160','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600161','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600162','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600163','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600164','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600165','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600166','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600167','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600168','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600169','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600170','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600171','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600172','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600173','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600174','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600175','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600176','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600177','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600178','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600179','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600180','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600181','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600182','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600183','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600184','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600185','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600186','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600187','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600188','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600189','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600190','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600191','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600192','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600193','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600194','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600195','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600196','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600197','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600198','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600199','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600200','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600201','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600202','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600203','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600204','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600205','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600206','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600207','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600208','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600209','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600210','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600211','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600212','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600213','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600214','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600215','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600216','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600217','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600218','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600219','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600220','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600221','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600222','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600223','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600224','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600225','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600226','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600227','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600228','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600229','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600230','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600231','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600232','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600233','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600234','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600235','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600236','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600237','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600238','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600239','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600240','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600241','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600242','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600243','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600244','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600245','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600246','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600247','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600248','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600249','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600250','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600251','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600252','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600253','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600254','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600255','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600256','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600257','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600258','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600259','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600260','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600261','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600262','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600263','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600264','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600265','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600266','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600267','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600268','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600269','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600270','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600271','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600272','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600273','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600274','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600275','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600276','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600277','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600278','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600279','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600280','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600281','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600282','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600283','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600284','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600285','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600286','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600287','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600288','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600289','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600290','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600291','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600292','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600293','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600294','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600295','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600296','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600297','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600298','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600299','10.10.10.22');
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.22','300','test','ACTIVE','Y','CCagent','station 200','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('cc301','301','301','10.10.10.22','301','test','ACTIVE','Y','CCagent','station 201','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('cc302','302','302','10.10.10.22','302','test','ACTIVE','Y','CCagent','station 202','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('cc303','303','303','10.10.10.22','303','test','ACTIVE','Y','CCagent','station 203','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('cc304','304','304','10.10.10.22','304','test','ACTIVE','Y','CCagent','station 204','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('cc305','305','305','10.10.10.22','305','test','ACTIVE','Y','CCagent','station 205','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('cc306','306','306','10.10.10.22','306','test','ACTIVE','Y','CCagent','station 206','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('cc307','307','307','10.10.10.22','307','test','ACTIVE','Y','CCagent','station 207','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('cc308','308','308','10.10.10.22','308','test','ACTIVE','Y','CCagent','station 208','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('cc309','309','309','10.10.10.22','309','test','ACTIVE','Y','CCagent','station 209','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('cc310','310','310','10.10.10.22','310','test','ACTIVE','Y','CCagent','station 210','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('cc311','311','311','10.10.10.22','311','test','ACTIVE','Y','CCagent','station 211','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('cc312','312','312','10.10.10.22','312','test','ACTIVE','Y','CCagent','station 212','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('cc313','313','313','10.10.10.22','313','test','ACTIVE','Y','CCagent','station 213','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('cc314','314','314','10.10.10.22','314','test','ACTIVE','Y','CCagent','station 214','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('cc315','315','315','10.10.10.22','315','test','ACTIVE','Y','CCagent','station 215','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('cc316','316','316','10.10.10.22','316','test','ACTIVE','Y','CCagent','station 216','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('cc317','317','317','10.10.10.22','317','test','ACTIVE','Y','CCagent','station 217','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('cc318','318','318','10.10.10.22','318','test','ACTIVE','Y','CCagent','station 218','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('cc319','319','319','10.10.10.22','319','test','ACTIVE','Y','CCagent','station 219','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('cc320','320','320','10.10.10.22','320','test','ACTIVE','Y','CCagent','station 220','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('cc321','321','321','10.10.10.22','321','test','ACTIVE','Y','CCagent','station 221','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('cc322','322','322','10.10.10.22','322','test','ACTIVE','Y','CCagent','station 222','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('cc323','323','323','10.10.10.22','323','test','ACTIVE','Y','CCagent','station 223','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('cc324','324','324','10.10.10.22','324','test','ACTIVE','Y','CCagent','station 224','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('cc325','325','325','10.10.10.22','325','test','ACTIVE','Y','CCagent','station 225','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('cc326','326','326','10.10.10.22','326','test','ACTIVE','Y','CCagent','station 226','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('cc327','327','327','10.10.10.22','327','test','ACTIVE','Y','CCagent','station 227','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('cc328','328','328','10.10.10.22','328','test','ACTIVE','Y','CCagent','station 228','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('cc329','329','329','10.10.10.22','329','test','ACTIVE','Y','CCagent','station 229','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('cc330','330','330','10.10.10.22','330','test','ACTIVE','Y','CCagent','station 230','SIP','-5','0000000000');
I updated the DB schema and then tried to add the dialers manually but it does not accept the default MySQL password when I want to add phones and conferences: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) - During the installation I went with the default username and password.