Разработчикам

VMBitrix 9.0.0

RSS

VMBitrix 9.0.0

Алексей Шафранский

Администратор

Сообщений: 1137 Баллов: 219 Регистрация: 28.07.2008

#526

13.05.2025 00:17:47

Цитата
написал: Установил с нуля веб-окружение 9.0.6 на CentOs Stream 9 c MySQL версии 8.0.Сайты не устанавливал.Пытаюсь обновить MySQL до версии 8.4 - выдается ошибка в логах:

Не повторяется(

Скрытый текст

*** bx_upgrade_mysql84_8767801057]# cat status

PLAY [bitrix-hosts] ************************************************************

TASK [Gathering Facts] *********************************************************
ok: [server1]

TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/inc_vars.yml for server1

TASK [mysql : include variables from mysql group] ******************************
ok: [server1]

TASK [mysql : include variables from web group] ********************************
ok: [server1]

TASK [mysql : include variables from temporary config] *************************
ok: [server1]

TASK [mysql : additional gathering facts] **************************************
ok: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : set_fact] ********************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
skipping: [server1]

TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/roles/mysql/tasks/upgrade_mysql_from80_to84.yml for server1

TASK [mysql : update system] ***************************************************
ok: [server1]

TASK [mysql : touch my.cnf before commit] **************************************
changed: [server1]

TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/roles/mysql/tasks/common-etckeeper.yml for server1

TASK [mysql : wait for absent lockfile] ****************************************
skipping: [server1]

TASK [mysql : create lockfile] *************************************************
skipping: [server1]

TASK [mysql : create time mark] ************************************************
skipping: [server1]

TASK [mysql : create touch file] ***********************************************
skipping: [server1]

TASK [mysql : check if directores in /etc contains uncommitted changes] ********
skipping: [server1]

TASK [mysql : commit changes by etckeeper] *************************************
skipping: [server1]

TASK [mysql : delete touch file] ***********************************************
skipping: [server1]

TASK [mysql : delete lockfile] *************************************************
skipping: [server1]

TASK [mysql : clear packagelist lockfile] **************************************
changed: [server1]

TASK [mysql : wait for absent lockfile] ****************************************
ok: [server1]

TASK [mysql : create lockfile] *************************************************
changed: [server1]

TASK [mysql : count commit date] ***********************************************
changed: [server1]

TASK [mysql : commit changes by etckeeper] *************************************
changed: [server1]

TASK [mysql : delete lockfile] *************************************************
changed: [server1]

TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/roles/mysql/tasks/sites-gathering_facts-not_mandatory.yml for server1

TASK [mysql : set_fact] ********************************************************
ok: [server1]

TASK [mysql : gathering facts about installed sites] ***************************
changed: [server1]

TASK [mysql : set_fact] ********************************************************
ok: [server1]

TASK [mysql : create variable bx_sites_info] ***********************************
ok: [server1]

TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/roles/mysql/tasks/backup_dbs.yml for server1

TASK [mysql : backup folders] **************************************************
changed: [server1] => (item=/home/bitrix/backup)
changed: [server1] => (item=/home/bitrix/backup/archive)

TASK [mysql : create backup] ***************************************************
changed: [server1] => (item={'CronService': {}, 'ModuleCluster': '', 'BackupWeekDay': '', 'DocumentRoot': '/home/bitrix/www', 'ApacheConfNTLM': '', 'HTTPS': 'disable', 'error': 0, 'CompositeExcludeParams': [], 'SiteCsync2': 'default', 'NginxHTTPConfig': 's1.conf', 'proxy_ignore_client_abort': 'off', 'phpSessionDir': '/tmp/php_sessions/www', 'phpMsmtpAccount': 'default', 'DBType': 'mysql', 'CompositeNginxID': '02', 'DBLogin': 'bitrix0', 'BackupDay': '', 'NTLM_use_ntlm': 'N', 'DBHost': 'localhost', 'SiteShort': 'default', 'CompositeMemcachedHost': '', 'SiteStatus': 'not_installed', 'module_transformercontroller': 'not_installed', 'BackupCronFile': '', 'NginxType': 'single', 'NginxHTTPSConfig': 'ssl.s1.conf', 'ModuleScale': '', 'SphinxConnection': '', 'ApacheConfScale': '/etc/httpd/bx-scale/conf/default.conf', 'SiteKernelDir': '', 'SMTPUser': None, 'NginxHTTPDir': '/etc/nginx/bx/site_avaliable', 'NginxHTTPSFullPath': '/etc/nginx/bx/site_avaliable/ssl.s1.conf', 'CronTask': 'enable', 'CompositeDomains': [], 'HTTPSCert': '/etc/nginx/ssl/cert.pem', 'nginx_bx_temp_config': '/etc/nginx/bx/site_settings/default/bx_temp.conf', 'CompositeStatus': 'disable', 'nginx_custom_settings': 'on', 'NTLM_bitrixvm_auth_support': 'N', 'NginxHTTPEDir': '/etc/nginx/bx/site_enabled', 'DBConn': 'Y', 'nginx_custom_settings_directory': '/etc/nginx/bx/site_settings/default', 'SMTPPassword': '***************', 'HTTPSCertType': 'general', 'CompositeMemcachedPort': '', 'SphinxIndexName': '', 'BackupMinute': '', 'module_cluster': 'not_installed', 'message': '', 'CompositeStorage': '', 'SMTPTLS': 'off', 'dbconn_BX_TEMPORARY_FILES_DIRECTORY': '/home/bitrix/.bx_temp/sitemanager/', 'SiteKernelDB': '', 'DBPassword': '***************', 'config_file': 'dbconn', 'NginxPort': 80, 'module_scale': 'not_installed', 'SiteInstall': 'kernel', 'EmailAccount': None, 'BackupHour': '', 'BackupMonth': '', 'CompositeError': '', 'SiteCharset': 'utf8mb4', 'EmailAddress': None, 'BackupVersion': '', 'ApacheConf': '/etc/httpd/bx/conf/default.conf', 'HTTPSCertChain': '', 'HTTPSConf': '/etc/nginx/bx/conf/ssl.conf', 'SMTPPort': None, 'BackupFolder': '', 'SMTPHost': None, 'CompositeNginxMap': '', 'ServerName': 'server1', 'module_transformer': 'not_installed', 'DBName': 'sitemanager', 'HTTPSPriv': '/etc/nginx/ssl/cert.pem', 'BackupTask': 'disable', 'CompositeIncludeUri': [], 'nginx_bx_temp_files': 'on', 'SiteName': 'default', 'CronFile': '/etc/crontab', 'CompositeExcludeUri': [], 'phpUploadDir': '/tmp/php_upload/www', 'CompositeNginx': 'disable'})

TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/roles/mysql/tasks/shutdown_mysqld.yml for server1

TASK [mysql : configure mysql shutdown] ****************************************
changed: [server1]

TASK [mysql : shutdown mysql on CentOS6] ***************************************
skipping: [server1]

TASK [mysql : shutdown mysql on CentOS7] ***************************************
skipping: [server1]

TASK [mysql : shutdown mysql] **************************************************
changed: [server1]

TASK [mysql : wait mysql shutdown] *********************************************
ok: [server1]

TASK [mysql : Check if initd script exists] ************************************
skipping: [server1]

TASK [mysql : Failed when initd file is not exists] ****************************
skipping: [server1]

TASK [mysql : try stop it another way if the previous command did not succeed] ***
skipping: [server1]

TASK [mysql : delete old packages] *********************************************
changed: [server1]

TASK [mysql : disable percona 80 repository] ***********************************
changed: [server1]

TASK [mysql : enable percona 84 repository] ************************************
changed: [server1]

TASK [mysql : install percona-server] ******************************************
changed: [server1]

TASK [mysql : gathering facts] *************************************************
ok: [server1]

TASK [mysql : performance options] *********************************************
ok: [server1]

TASK [mysql : create additional service config] ********************************
ok: [server1]

TASK [mysql : copy service config] *********************************************
ok: [server1]

TASK [mysql : reload systmd configuration] *************************************
changed: [server1]

TASK [mysql : remove my.cnf.rpmsave file] **************************************
changed: [server1]

TASK [mysql : restore my.cnf] **************************************************
changed: [server1]

TASK [mysql : restore bvat.cnf] ************************************************
changed: [server1]

TASK [mysql : start mysql service] *********************************************
changed: [server1]

TASK [mysql : update system] ***************************************************
changed: [server1]

PLAY [bitrix-hosts] ************************************************************

TASK [Gathering Facts] *********************************************************
ok: [server1]

TASK [cleaner : get file list] *************************************************
ok: [server1]

TASK [cleaner : delete files] **************************************************

PLAY RECAP *********************************************************************
server1 : ok=45 changed=22 unreachable=0 failed=0 skipped=25 rescued=0 ignored=0

Алексей Шафранский

Администратор

Сообщений: 1137 Баллов: 219 Регистрация: 28.07.2008

#527

13.05.2025 11:47:44

Цитата

написал:
не устанавливается sphinx, постоянно ошибка при установке через BitrixVM, ругается на конфиг.Скрытый текстcat sphinx_8082568303/statusPLAY [bitrix-hosts] ************************************************************TASK [Gathering Facts] *********************************************************ok: [relay]TASK [sphinx : include_tasks] **************************************************included: /etc/ansible/inc_vars.yml for relayTASK [sphinx : include variables from mysql group] *****************************ok: [relay]TASK [sphinx : include variables from web group] *******************************ok: [relay]TASK [sphinx : include variables from temporary config] ************************ok: [relay]TASK [sphinx : include_tasks] **************************************************included: /etc/ansible/roles/sphinx/tasks/sphinx.yml for relayTASK [sphinx : gathering facts about installed sites] **************************changed: [relay]TASK [sphinx : create variable bx_sites_info] **********************************ok: [relay]TASK [sphinx : include_tasks] **************************************************included: /etc/ansible/roles/sphinx/tasks/install.yml for relayTASK [sphinx : install software] ***********************************************skipping: [relay]TASK [sphinx : install software] ***********************************************ok: [relay]TASK [sphinx : gathering facts] ************************************************ok: [relay]TASK [sphinx : create config directories] **************************************ok: [relay] => (item=/etc/sphinx)ok: [relay] => (item=/etc/sphinx/bx)ok: [relay] => (item=/etc/sphinx/bx/search_index)ok: [relay] => (item=/etc/sphinx/bx/dicts)TASK [sphinx : install dictionaries] *******************************************ok: [relay] => (item=de.pak)ok: [relay] => (item=en.pak)ok: [relay] => (item=ru.pak)TASK [sphinx : create main config] *********************************************changed: [relay]TASK [sphinx : enable searchd service] *****************************************fatal: [relay]: FAILED! => {"changed": false, "msg": "Unable to start service searchd: Job for searchd.service failed because the control process exited with error code.\nSee \"systemctl status searchd.service\" and \"journalctl -xeu searchd.service\" for details.\n"}PLAY RECAP *********************************************************************relay : ok=14 changed=2 unreachable=0 failed=1 skipped=1 rescued=0 ignored=0Скрытый текст # systemctl status searchd.service****FATAL: failed to parse config file '/etc/sphinx/sphinx.conf'Copyright © 2001-2016, Andrew AksyonoffCopyright © 2008-2016, Sphinx Technologies Inc ( http://sphinxsearch.com )ERROR: error executing '/usr/bin/php' status = 255 in /etc/sphinx/sphinx.conf line 1 col 1.searchd.service: Control process exited, code=exited, status=1/FAILUREsearchd.service: Failed with result 'exit-code'.Failed to start Sphinx - SQL Full Text Search Engine.Ansible и VMBitrix 9.0.6 создает такой конфигСкрытый текст#!/usr/bin/php# Ansible managed# Minimal Sphinx configuration for Bitrix## Include site search db index testrt{ type = rt rt_mem_limit = 128M path = /var/lib/sphinx/testrt rt_field = title rt_field = content rt_attr_uint = gid}searchd{ listen = 9312 listen = 9306:mysql41 log = /var/log/sphinx/searchd.log query_log = /var/log/sphinx/query.log pid_file = /var/run/sphinx/searchd.pid binlog_path = /var/lib/sphinx read_timeout = 5 max_children = 30 max_matches = 1000 seamless_rotate = 1 preopen_indexes = 1 unlink_old = 1 workers = threads # for RT to work binlog_max_log_size = 512M # 2 - flush every transaction, sync every second. Good performance, and every committed transaction is guaranteed to be saved in case of daemon crash. # 1 - flush and sync every transaction. Worst performance, but every committed transaction data is guaranteed to be saved binlog_flush = 2 rt_flush_period = 3600}# 22indexer{ lemmatizer_cache = 128M}common{ lemmatizer_base = /usr/share/sphinx/dicts}Ansible и сценарий установки не создает походу конфиг верно.Bitrix virtual appliance version 9.0.6PHP Version 8.2.28OS: AlmaLinux release 9.5 (Teal Serval)

Не повторяется.
Версии ОС и ПО те же самые. Роль отработала, конфиг на месте, сервис жив. Что нужно сделать чтобы повторить?

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

Заглянувший

Сообщений: 1 Регистрация: 01.03.2022

#528

13.05.2025 14:41:51

Алексей Шафранский,

Цитата
написал: Не повторяется.Версии ОС и ПО те же самые. Роль отработала, конфиг на месте, сервис жив. Что нужно сделать чтобы повторить?

Добрый день! Тоже такая ситуация с sphinx, при миграции с BitrixVM 7 на BitrixVM 9.0.6 sphinx не запускается, ошибка конфига sphinx.conf . Поставил чистую тестовую CRM там роль отработала без ошибок. Перенес с чистой CRM sphinx.conf в рабочую роль не отработала.

Код

searchd.service - Sphinx - SQL Full Text Search Engine
     Loaded: loaded (/usr/lib/systemd/system/searchd.service; enabled; preset: disabled)
     Active: failed (Result: exit-code) since Tue 2025-05-13 10:54:59 MSK; 3h 45min ago
    Process: 58177 ExecStart=/usr/bin/searchd --config /etc/sphinx/sphinx.conf (code=exited, status=1/FAILURE)
        CPU: 107ms
May 13 10:54:59 bitrix24box searchd[58178]: PHP Fatal error:  Failed opening required '/home/bitrix/www/bitrix/modules/security/tools/start.php' (include_path='.:/usr/share/pear:/usr/share/php') in Unknown on l>
May 13 10:54:59 bitrix24box searchd[58179]: PHP Fatal error:  Failed opening required '/home/bitrix/www/bitrix/modules/security/tools/start.php' (include_path='.:/usr/share/pear:/usr/share/php') in Unknown on l>
May 13 10:54:59 bitrix24box searchd[58177]: [Tue May 13 10:54:59.266 2025] [58177] FATAL: failed to parse config file '/etc/sphinx/sphinx.conf'
May 13 10:54:59 bitrix24box searchd[58177]: Sphinx 2.2.11-id64-release (95ae9a6)
May 13 10:54:59 bitrix24box searchd[58177]: Copyright (c) 2001-2016, Andrew Aksyonoff
May 13 10:54:59 bitrix24box searchd[58177]: Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
May 13 10:54:59 bitrix24box searchd[58177]: ERROR: error executing '/usr/bin/php' status = 255 in /etc/sphinx/sphinx.conf line 1 col 1.
May 13 10:54:59 bitrix24box systemd[1]: searchd.service: Control process exited, code=exited, status=1/FAILURE
May 13 10:54:59 bitrix24box systemd[1]: searchd.service: Failed with result 'exit-code'.
May 13 10:54:59 bitrix24box systemd[1]: Failed to start Sphinx - SQL Full Text Search Engine.

OC Rocky Linux 9.5

Алексей Шафранский

Администратор

Сообщений: 1137 Баллов: 219 Регистрация: 28.07.2008

#529

13.05.2025 22:58:27

Цитата
написал: sphinx не запускается, ошибка конфига sphinx.conf . Поставил чистую тестовую CRM там роль отработала без ошибок. Перенес с чистой CRM sphinx.conf в рабочую роль не отработала.

Поясните про crm я не понял)
И зачем sphinx.conf файл переносить? Для чего? Его роль сама создаст при запуске.
Распишите весь сценарий по шагам, особенно про conf файл что с ним делаете и зачем.

Алексей Шафранский

Администратор

Сообщений: 1137 Баллов: 219 Регистрация: 28.07.2008

#530

14.05.2025 12:58:19

Олег Максимов, Дмитрий Васильев,
настройку auto_prepend_file уберите из .ini файла php
и пропишите её в .htaccess файл каждого сайта
учтите что путь для каждого сайта будет свой, пример для сайта по умолчанию:

Код
php_value auto_prepend_file "/home/bitrix/www/bitrix/modules/security/tools/start.php"

После запустите создание роли sphinx через меню машины.

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

Постоянный посетитель

Сообщений: 118 Баллов: 23 Регистрация: 04.05.2006

#531

23.05.2025 22:08:23

Приветствую!

Установил с нуля веб-окружение 9.0.6 на CentOs Stream 9 на VPS Timeweb'а.
Стал отлаживать производительность MySQL - из коробки не работал скачанный скрипт mysqltuner.pl.

[CODE]
# perl mysqltuner.pl Can't locate diagnostics.pm in @INC (you may need to install the diagnostics module) (@INC contains: /usr/local/lib64/perl5/5.32 /usr/local/share/perl5/5.32 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at mysqltuner.pl line 46. BEGIN failed--compilation aborted at mysqltuner.pl line 46.
[/CODE]

Решение
Понадобилась дополнительная установка модуля perl — diagnostics.pm.

C наилучшими пожеланиями,
Владимир.

Пользователь 3699828 Заглянувший Сообщений: 4 Регистрация: 15.11.2019	#532 29.05.2025 11:51:56 Подскажите, в 7vm была настройка мониторинга vm пусть и внутренняя, но была. В 9 планируется добавлять мониторинг? Или может есть где то статейка , как прикрутить нормально тот же прометей или zabbix в 9VM , желательно без пересборки nginx ) ?

VMBitrix 9.0.0

Продукты

Управление сайтом

Битрикс24

Интернет-магазин + CRM

Решения

Для интернет-магазинов

Каталог готовых решений

Внедрение

Выбрать партнера

Проверить партнера

Стать партнером