Форум

Всех приветствую! Версия 9.0.9. PHP 8.5.4. Все обновления установлены. Вот такая штука частенько в меню Confugure pool sites:
[CODE]PHP Warning: Failed loading Zend extension 'opcache.so' (tried: /usr/lib64/php/modules/opcache.so (/usr/lib64/php/modules/opcache.so: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/opcache.so.so (/usr/lib64/php/modules/opcache.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  Failed loading Zend extension 'opcache.so' (tried: /usr/lib64/php/modules/opcache.so (/usr/lib64/php/modules/opcache.so: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/opcache.so.so (/usr/lib64/php/modules/opcache.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  Failed loading Zend extension 'opcache.so' (tried: /usr/lib64/php/modules/opcache.so (/usr/lib64/php/modules/opcache.so: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/opcache.so.so (/usr/lib64/php/modules/opcache.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
[/CODE]

[QUOTE]Олег написал:
При установке на AlmaLinux 9 выходит ошибка

лог ошибки:
--2025-11-24 20:23:57--   [URL=https://repo.almalinux.org/almalinux/9/AppStream/x86_64/os/Packages/perl-DBD-MySQL-4.050-13.el9.x86_64.rpm]https://repo.almalinux.org/almalinux/9/AppStream/x86_64/os/Packages/perl-DBD-MySQL-4.050-13.el9.x86_...[/URL]
Resolving repo.almalinux.org (repo.almalinux.org)... 2a04:4e42:400::820, 2a04:4e42:600::820, 2a04:4e42::820, ...
Connecting to repo.almalinux.org (repo.almalinux.org)|2a04:4e42:400::820|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2025-11-24 20:23:57 ERROR 404: Not Found.

2025-11-24T20:23:57: 1607 : error:  [URL=https://repo.almalinux.org/almalinux/9/AppStream/x86_64/os/Packages/perl-DBD-MySQL-4.050-13.el9.x86_64.rpm]https://repo.almalinux.org/almalinux/9/AppStream/x86_64/os/Packages/perl-DBD-MySQL-4.050-13.el9.x86_...[/URL]
2025-11-24T20:23:57: 1607 : Log file path:  /tmp/bitrix-env-WowlG.log[/QUOTE]

Олег, на Oracle вроде без проблем поставил.

[QUOTE]Олег написал:
При установке на AlmaLinux 9 выходит ошибка

лог ошибки:
--2025-11-24 20:23:57--   [URL=https://repo.almalinux.org/almalinux/9/AppStream/x86_64/os/Packages/perl-DBD-MySQL-4.050-13.el9.x86_64.rpm]https://repo.almalinux.org/almalinux/9/AppStream/x86_64/os/Packages/perl-DBD-MySQL-4.050-13.el9.x86_...[/URL]
Resolving repo.almalinux.org (repo.almalinux.org)... 2a04:4e42:400::820, 2a04:4e42:600::820, 2a04:4e42::820, ...
Connecting to repo.almalinux.org (repo.almalinux.org)|2a04:4e42:400::820|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2025-11-24 20:23:57 ERROR 404: Not Found.

2025-11-24T20:23:57: 1607 : error:  [URL=https://repo.almalinux.org/almalinux/9/AppStream/x86_64/os/Packages/perl-DBD-MySQL-4.050-13.el9.x86_64.rpm]https://repo.almalinux.org/almalinux/9/AppStream/x86_64/os/Packages/perl-DBD-MySQL-4.050-13.el9.x86_...[/URL]
2025-11-24T20:23:57: 1607 : Log file path:  /tmp/bitrix-env-WowlG.log[/QUOTE]

Такая же беда. Пытался руками решить, но не помогает ничего.

[QUOTE]Алексей Шафранский написал:
Опять же, где детали? Тип сайта? Через меню создавался? Что в табличке mysql.user в колонке plugin? Что в логах?[/QUOTE]
Алексей, здравствуйте! Извиняюсь. Уточнения. AlmaLinux, обновление с версии 9.0.4 до 9.0.6. Все крайние обновления на CMS. PHP 8.3. Сайты через меню, многосайтовость.
После обновления в меню
[CODE]bx_upgrade_mysql84_6450476821 | 27/03/2025 09:30 | finished | play|complete[/CODE]
Лог error.log

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

2025-03-27T06:19:31.714159Z 0 [System] [MY-013172] [Server] Received SHUTDOWN fr om user <via user signal>. Shutting down mysqld (Version: 8.0.40-31). 2025-03-27T06:19:33.183845Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.40-31) Percona Server (GPL), Release 31, Revision 49317865. 2025-03-27T06:19:33.822251Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-32) starting as process 45711 2025-03-27T06:19:33.830564Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-03-27T06:19:34.214556Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-03-27T06:19:34.620178Z 4 [System] [MY-013381] [Server] Server upgrade from '80040' to '80041' started. 2025-03-27T06:19:42.445958Z 4 [System] [MY-013381] [Server] Server upgrade from '80040' to '80041' completed. 2025-03-27T06:19:42.588016Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-03-27T06:19:42.588035Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-03-27T06:19:42.598185Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock 2025-03-27T06:19:42.598218Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.41-32' socket: '/var/lib/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 32, Revision b8e378ec. 2025-03-27T06:19:43.740636Z 11 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2025-03-27T06:19:44.062291Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.41-32). 2025-03-27T06:19:46.554594Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-32) Percona Server (GPL), Release 32, Revision b8e378ec. 2025-03-27T06:19:47.173330Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-32) starting as process 46313 2025-03-27T06:19:47.176827Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-03-27T06:19:47.541185Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-03-27T06:19:47.723442Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-03-27T06:19:47.723460Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-03-27T06:19:47.742513Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock 2025-03-27T06:19:47.742552Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.41-32' socket: '/var/lib/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 32, Revision b8e378ec. 2025-03-27T06:20:01.394619Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2025-03-27T06:20:34.147671Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.41-32). 2025-03-27T06:20:35.251950Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-32) Percona Server (GPL), Release 32, Revision b8e378ec. 2025-03-27T06:20:35.940161Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-32) starting as process 83437 2025-03-27T06:20:35.944383Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-03-27T06:20:36.408996Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-03-27T06:20:36.643124Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-03-27T06:20:36.643142Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-03-27T06:20:36.673429Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.41-32' socket: '/var/lib/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 32, Revision b8e378ec. 2025-03-27T06:20:36.673666Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock 2025-03-27T06:20:38.215187Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2025-03-27T06:28:05.425858Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.41-32). 2025-03-27T06:28:06.357469Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-32) Percona Server (GPL), Release 32, Revision b8e378ec. 2025-03-27T06:28:18.616101Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-32) starting as process 1664 2025-03-27T06:28:18.627928Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-03-27T06:28:19.090025Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-03-27T06:28:19.284355Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-03-27T06:28:19.284373Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-03-27T06:28:19.314941Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock 2025-03-27T06:28:19.314975Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.41-32' socket: '/var/lib/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 32, Revision b8e378ec. 2025-03-27T06:28:42.029151Z 11 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2025-03-27T07:30:19.956743Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.41-32). 2025-03-27T07:30:21.730262Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-32) Percona Server (GPL), Release 32, Revision b8e378ec. 2025-03-27T07:30:42.333750Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2025-03-27T07:30:42.507667Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.4-4) starting as process 14735 2025-03-27T07:30:42.512400Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-03-27T07:30:43.106589Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-03-27T07:30:43.111910Z 1 [System] [MY-011090] [Server] Data dictionary upgrading from version '80023' to '80300'. 2025-03-27T07:30:43.542407Z 1 [System] [MY-013413] [Server] Data dictionary upgrade from version '80023' to '80300' completed. 2025-03-27T07:30:46.689191Z 4 [System] [MY-013381] [Server] Server upgrade from '80041' to '80404' started. 2025-03-27T07:30:53.195668Z 4 [System] [MY-013381] [Server] Server upgrade from '80041' to '80404' completed. 2025-03-27T07:30:53.330661Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-03-27T07:30:53.330680Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-03-27T07:30:53.340279Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock 2025-03-27T07:30:53.340304Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.4.4-4' socket: '/var/lib/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 4, Revision 844fde07.

SEL ECT User, Host, plugin FR OM mysql.user WH ERE User = 'userold';

Скрытый текст
+---------+-----------+-----------------------+    -> | User    | Host      | plugin                |    -> +---------+-----------+-----------------------+    -> | userold | %         | mysql_native_password |    -> | userold | localhost | mysql_native_password |    -> +---------+-----------+-----------------------+

Попробовал исправить, сайт заработал. Корректен ли такой подход?
[CODE]
ALTER USER 'userold'@'%' IDENTIFIED WITH caching_sha2_password BY 'new_password';
ALTER USER 'userold'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'new_password';
[/CODE]

[QUOTE]Алексей Шафранский написал:
Дополнение 3 к релизу VMBitrix 9.0.6:

С версии 9.0.6 по умолчанию плагином аутентификации для MySQL (Percona Server) будет caching_sha2_password.
Версия используемого Percona Server не важна, применяется как для 8.0.x, так и для 8.4.x.

Как было до версии 9.0.6:
сайт по умолчанию (default) использовал плагин caching_sha2_password
сайты, создаваемые из меню машины, типа ядро (kernel) или внешнее ядро (ext_kernel), использовали плагин mysql_native_password (ansible коллекция community.mysql)
задачи, связанные с работой с бд и запускаемые из меню машины, использовали плагин mysql_native_password (например, смена пароля пользователя root mysql)
Как стало с версии 9.0.6:
для всего, что перечислено выше, используется плагин caching_sha2_password
изменения применяются для создания сайта из меню машины (типа ядро или внешнее ядро)
и для смены пароля пользователя root mysql
Обновление на версию 9.0.6:
для сайтов типа ядро (kernel) или внешнее ядро (ext_kernel) изменит тип плагина на caching_sha2_password
перехеширует и обновит строку аутентификации (пароль бд) для каждого сайта
выполнит эту процедуру один раз
Так же исправили удаление сайта, имеющего бд: данные для базы, которые оставались в табличках mysql.db и mysql.user, теперь так же удаляются.[/QUOTE]
Здравствуйте! Попробовал на тестовом серваке обновиться. Вроде все прошло штатно. Стоят все крайние обновы.
[Bitrix\Main\DB\ConnectionException]
Mysql connect error [localhost]: (1524) Plugin 'mysql_native_password' is not loaded (400)

Установка на alma 9 прошла успешно. На php 8.4 ошибка в модуле Проверка сайта.

[QUOTE]Артем Иванов написал:
Установил 9.0.3 на чистый сервер. Добавил сайт. При добавлении второго:
Found MySQL service with empty root password: site.ru
You can fix this by using second item in the MySQL menu.
Хотя в файле .my.cnf пароль есть. Второй пункт не выполнился - ошибка. Помогло Update settings for all MySQL servers.[/QUOTE]
Второй замеченный трабл. Не выпустился сертификат lets. Выполнил Restore default certificate, далее Configure "Let's encrypt" certificate. Серт не встал, в выполненных задачах -  finished. В меню отображаются дефолтные сертификаты ssl/cert.pem и  ssl/cert.pem. С третьего раза по такому же сценарию все сработало.

Установил 9.0.3 на чистый сервер. Добавил сайт. При добавлении второго:
Found MySQL service with empty root password: site.ru
You can fix this by using second item in the MySQL menu.
Хотя в файле .my.cnf пароль есть. Второй пункт не выполнился - ошибка. Помогло Update settings for all MySQL servers.

Обновился на 9.0.1. Перезагрузился. Теперь в админку не попасть. Ошибка 502...

Дефолтный сайт был удален и создан новый по пути /home/bitrix/ext_www/site.ru

Собственно вот:
[CODE]Starting The Apache HTTP Server...
AH00548: NameVirtualHost has no effect and will be removed in the next release /etc/httpd/bx/conf/bx_apache_site_name_port.conf:4
AH00526: Syntax error on line 96 of /etc/httpd/conf/httpd.conf:
DocumentRoot '/home/bitrix/www' is not a directory, or is not readable
httpd.service: Main process exited, code=exited, status=1/FAILURE
httpd.service: Failed with result 'exit-code'.
Failed to start The Apache HTTP Server.[/CODE]

Собственно чтобы быстро пофиксить
/etc/httpd/conf/httpd.conf поправил строчку с [U]DocumentRoot "/home/bitrix/www" на DocumentRoot "/home/bitrix/ext_www"[/U]
Но, что то мне подсказывает, что так делать не стоит)

Всех приветствую!
Уже третья попытка установить.
Процесс виснет на Installing bitrix-env package. Please wait.
Ожидание на данном пункте больше часа.