Кабинет на отдельном сервере

Это старая версия документа!

Сервер с установленными nginx, php версии 7.2 / 7.3 и ioncube:

nginx php php-fpm php-bcmath php-cli php-common php-devel php-embedded php-gd php-curl php-imap php-mbstring php-mysql php-pdo php-process php-pspell php-recode php-snmp php-soap php-xml php-xmlrpc php-pear

Скачайте основные файлы ЛК:
для платной версии:

wget http://pay.update.lkv2.mikbill.pro/stat.tar.gz

для бесплатной версии:

wget http://free.update.lkv2.mikbill.pro/stat.tar.gz

и распакуйте в директории /var/www/mikbill

Перенести файлы и каталоги с биллинга:

stat/app/etc/config.xml
stat/app/log/log.txt
stat/app/views/error.html
stat/app/views/scripts/index/index.phtml
stat/data/template/olson/customtpls/*
stat/sys/files/*
stat/sys/scripts/*

В /var/www/mikbill/stat на новом сервере, конфиг nginx и php-fpm можно взять с основного сервера.

Для соединения с основной базой, нужно создать внешнего пользователя в mysql:
В консоли базы данных выполнить

CREATE USER remote_stat@REMOTE_IP IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
GRANT SELECT, EXECUTE ON mikbill.* TO remote_stat@REMOTE_IP REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
GRANT SELECT, INSERT ON mikbill.logs_auth_cabinet TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE, DELETE ON mikbill.users TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE, DELETE ON mikbill.usersfreeze TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, DELETE ON mikbill.ip_pools_pool_use TO remote_stat@REMOTE_IP;
GRANT SELECT, DELETE ON mikbill.usersblok TO remote_stat@REMOTE_IP;
GRANT SELECT, DELETE ON mikbill.usersdel TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE ON mikbill.tickets_tickets TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE ON mikbill.tickets_messages TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE ON mikbill.tickets_notes TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT ON mikbill.tickets_logs TO remote_stat@REMOTE_IP;
GRANT SELECT (`stuffid`, `login`) ON `mikbill`.`stuff_personal` TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE ON mikbill.bugh_uslugi_stat TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT ON mikbill.bugh_plategi_stat TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT ON mikbill.bugh_plategi_info TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT ON mikbill.bugh_perevod_stat TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE ON mikbill.bugh_cards_log TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT ON mikbill.mod_cards_errors TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE ON mikbill.mod_cards_cards TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT ON mikbill.sms_logs TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT ON mikbill.queue_messages TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT ON mikbill.logs TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE ON mikbill.dev_fields TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE, DELETE ON mikbill.services_users_pairs TO remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.event_system TO remote_stat@REMOTE_IP;
GRANT SELECT, UPDATE ON mikbill.radacctbras TO remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_liqpay TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT ON mikbill.dev_user TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, DELETE ON mikbill.ip_real TO remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_liqpay to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_onpay to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_pscb to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paymaster to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_robokassa to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_stripe to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_wqiwiru to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paypal to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paykeeper to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_ukrpays to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_yandex to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_yandex_money to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_uniteller to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_portmone to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_ipay to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_sberbankru_mrch to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_fondy to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_simplepay to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_cloudpayments to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_isbank to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_tinkoff to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_alfabankru to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_privat to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_privat24 to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paysoft to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_ckassa to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_payme to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paymo to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_easypay to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_click to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paysera to remote_stat@REMOTE_IP;
FLUSH PRIVILEGES;

База должна быть доступна с нового сервера
REMOTE_IP - IP адрес сервера с новым кабинетом
remote_stat - логин нового пользователя
PASSWORD - пароль нового пользователя

Данные нужно указать в stat/app/etc/config.xml

Скачать в /var/mikbill/updates/stat
Для бесплатной версии php 7.2 / 7.3 - http://free.update.lkv2.mikbill.pro/stat_update.sh
Для платной версии php 7.2 / 7.3 - http://pay.update.lkv2.mikbill.pro/stat_update.sh

Добавить в cron по желанию

2021-06-04: добавлены права:

GRANT SELECT, INSERT ON mikbill.bugh_plategi_info TO remote_stat@REMOTE_IP;

2021-04-15: добавлены права:

GRANT SELECT, INSERT ON mikbill.logs_auth_cabinet TO remote_stat@REMOTE_IP;

2021-02-15: добавлены права:

GRANT SELECT, INSERT, DELETE ON mikbill.ip_pools_pool_use TO remote_stat@REMOTE_IP;

2021-01-25: добавлены права:

GRANT SELECT, INSERT, DELETE ON mikbill.ip_real TO remote_stat@REMOTE_IP;

2020-12-30: добавлен UPDATE для прав:

GRANT SELECT, INSERT, UPDATE ON mikbill.bugh_cards_log TO remote_stat@REMOTE_IP;

2020-12-28: добавлены права

GRANT SELECT (`stuffid`, `login`) ON `mikbill`.`stuff_personal` TO remote_stat@REMOTE_IP;

2020-12-17: добавлены права

GRANT INSERT ON mikbill.addons_liqpay to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_onpay to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_pscb to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paymaster to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_robokassa to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_stripe to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_wqiwiru to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paypal to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paykeeper to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_ukrpays to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_yandex to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_yandex_money to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_uniteller to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_portmone to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_ipay to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_sberbankru_mrch to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_fondy to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_simplepay to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_cloudpayments to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_isbank to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_tinkoff to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_alfabankru to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_privat to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_privat24 to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paysoft to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_ckassa to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_payme to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paymo to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_easypay to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_click to remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_paysera to remote_stat@REMOTE_IP;

2020-09-16: добавлены права

GRANT SELECT, INSERT ON mikbill.dev_user TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE ON mikbill.tickets_notes TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT ON mikbill.bugh_perevod_stat TO remote_stat@REMOTE_IP;

2020-09-10: добавлены права

GRANT INSERT ON mikbill.event_system TO remote_stat@REMOTE_IP;
GRANT SELECT, UPDATE ON mikbill.radacctbras TO remote_stat@REMOTE_IP;
GRANT INSERT ON mikbill.addons_liqpay TO remote_stat@REMOTE_IP;

2020-08-26: добавлены права

GRANT SELECT, INSERT, UPDATE, DELETE ON mikbill.services_users_pairs TO remote_stat@REMOTE_IP;

2020-08-20: добавлены права

GRANT SELECT, DELETE ON mikbill.usersblok TO remote_stat@REMOTE_IP;
GRANT SELECT, DELETE ON mikbill.usersdel TO remote_stat@REMOTE_IP;

2020-09-11: добавлены права

GRANT SELECT, INSERT, UPDATE, DELETE ON mikbill.tickets_notes TO remote_stat@REMOTE_IP;
GRANT SELECT, INSERT, UPDATE, DELETE ON mikbill.addons_pscb TO remote_stat@REMOTE_IP; (если используется платежная система на протоколе ПСКБ)

Кабинет на отдельном сервере

Требования

Установка

backend и frontend

Перенос шаблона и доп. файлов

Пользователь mysql

Updater

Change log

MikBiLL