Внимание!
Эта wiki об устаревших версиях
Документация к актуальной версии интеграции 1С и телефонии доступна по ссылке

Инструменты пользователя

Инструменты сайта


astpanel:ats:zycoo
Внимание! Статья не завершена.

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

Configuration:

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

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+

aptitude install sox spandsp ghostscript (others are already satisfied)

cd /usr/src
download - http://files.miko.ru/public.php?service=files&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: ===

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 recordingfile varchar(200)  DEFAULT NULL;

CREATE TRIGGER `recordingfile` 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, amaflags, accountcode, uniqueid, did, answer, end, recordingfile, 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_flags, NEW.account_pin_code, NEW.uniqueid, NEW.trunk, NEW.answer_time, NEW.end_time, NEW.recording_filename, NEW.uniqueid );

astpanel/ats/zycoo.txt · Последние изменения: 2018/02/12 14:50 — icvet