<note warning> Внимание! Статья не завершена. </note> 

====== ZYCOO + MIKO panel ======
===== ZYCOO general information =====
=== packet management system: ===
apt-get/aptitude 
=== web server: ===
/usr/java/jdk/bin/java -Xms100m -Xmx128m -jar rest-server.jar 
=== Conﬁguration: ===
sudo apt-get install --reinstall insserv sysv-rc

==== Получаем root права в MySQL ====
  * /etc/init.d/mysql stop
  * mysqld_safe --skip-grant-tables &
  * mysql -uroot
  * IINSERT INTO mysql.user SET

	Host = 'localhost',
	User = 'root',
	Password = PASSWORD('123456'),
	Select_priv = 'Y',
	Insert_priv = 'Y',
	Update_priv = 'Y',
	Delete_priv = 'Y',
	Create_priv = 'Y',
	Drop_priv = 'Y',
	Reload_priv = 'Y',
	Shutdown_priv = 'Y',
	Process_priv = 'Y',
	File_priv = 'Y',
	Grant_priv = 'Y',
	References_priv = 'Y',
	Index_priv = 'Y',
	Alter_priv = 'Y',
	Show_db_priv = 'Y',
	Super_priv = 'Y',
	Create_tmp_table_priv = 'Y',
	Lock_tables_priv = 'Y',
	Execute_priv = 'Y',
	Repl_slave_priv = 'Y',
	Repl_client_priv = 'Y',
	Create_view_priv = 'Y',
	Show_view_priv = 'Y',
	Create_routine_priv = 'Y',
	Alter_routine_priv = 'Y',
	Create_user_priv = 'Y',
	Event_priv = 'Y',
	Trigger_priv = 'Y',
	Create_tablespace_priv = 'Y',
	ssl_type = '',
	ssl_cipher = '',
	x509_issuer = '',
	x509_subject = '',
	max_questions = 0,
	max_updates = 0,
	max_connections = 1000000,
	max_user_connections = 1000000
	;

  * service mysql stop
  * service mysql start 

==== NEVER aptitude update && aptitude upgrade ====
<note>
MIKO prerequirements:
  * PHP 5.3.10 / 7.0.22
  * Для PHP должен быть доступен модуль mysqli / mysql
  * MySQL mysql Ver 15.1 Distrib 10.0.31-MariaDB
  * Apache 2.4.18
  * unixODBC
  * SoX v14.4.0
  * GPL Ghostscript 9.10
  * spandsp
  * Asterisk 1.8+
</note> 


==== aptitude install sox spandsp ghostscript (others are already satisﬁed) ====
	cd /usr/src
	download - http://ﬁles.miko.ru/public.php?service=ﬁles&t=55589e8972a7d3d670a5efabff566cfc
	cd /usr/src/dialplan_miko_ajam;
	/usr/src/dialplan_miko_ajam
	sh install_scripts/create_db.sh root 123456
	
	apt-get install unixodbc unixodbc-dev libmyodbc 


=== Provisioning - works fine (yealink t41p tested) cfg folder - /pnpboot/phones
Setting up asterisk conf files according: ===

  * https://wiki.miko.ru/astpanel:dialplan_miko_ajam
  * https://wiki.miko.ru/astpanel:dialplan_miko_ajam:configs

===== AGI: =====
 
Во всех php-скриптах поменять $ini->read('/etc/asterisk/extensions.conf'); **на $ini->read('/etc/asterisk/extensions_custom.conf');** 

**1C_Download/Playback.php:** 

**alter table asteriskcdrdb.PT1C_cdr modify  column did varchar(200)  DEFAULT NULL; alter table** 

**asteriskcdrdb.PT1C_cdr modify  column recordingﬁle varchar(200)  DEFAULT NULL;** 

CREATE TRIGGER `recordingﬁle` AFTER INSERT ON `zycoo_coovox`.`t_call_log`          FOR EACH ROW          INSERT INTO `asteriskcdrdb`.`PT1C_cdr` ( id, calldate, clid, src, dst, dcontext, lastapp, lastdata, duration, billsec, disposition, channel, dstchannel, amaﬂags, accountcode, uniqueid, did, answer, end, recordingﬁle, linkedid)                                                 VALUES (NEW.id, NEW.start_time, NEW.caller_id, NEW.call_src, NEW.call_dest, NEW.dialplan_context, NEW.lastapp, NEW.lastdata, NEW.duration, NEW.bill_second, NEW.call_status, NEW.src_channel, NEW.dest_channel, NEW.ama_ﬂags, NEW.account_pin_code, NEW.uniqueid, NEW.trunk, NEW.answer_time, NEW.end_time, NEW.recording_ﬁlename, NEW.uniqueid );