LINUX.ORG.RU

Сообщения sdllll

 

Защита от зажатия F5

Форум — Admin

Nginx и PHP-FPM Подскажите как реализовать защиту от зажатия клавишы F5

С одного IP могут работать до 100 пользователей

 

sdllll
()
39 комментариев

Ошибка 502 Nginx + PHP8.1-FPM

Форум — Admin

Прошу помощи обитателей форума. Регулярно падает ошибка 502 ничего с ней не могу поделать. параметры пула изменялись в различные стороны, но это ничего не меняет

1GB 1CPU

pm = dynamic
pm.start_servers = 4
pm.min_spare_servers = 2
pm.max_spare_servers = 4
pm.max_children = 1000
pm.process_idle_timeout = 10s;

[25-May-2023 12:46:12] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 32 children, there are 0 idle, and 28 total children

Перемещено hobbit из general

 

sdllll
()
11 комментариев

Как переписать deprecated function create_function?

Форум — Development

PHP Fatal error: Uncaught Error: Call to undefined function create_function() in

usort ($result, create_function ('$ret,$ret2', '
        return $ret[\'is_folder\']
        ? ($ret2[\'is_folder\'] == 1 ? strcasecmp($ret[\'name\'], $ret2[\'name\']) : -1)
        : ($ret2[\'is_folder\'] == 1 ? 1 : (
            strcasecmp($ret[\'name\'], $ret2[\'name\'])
        ));
    '));

 

sdllll
()
4 комментария

Upgrade error from mysql 5.7 to 8.0

Форум — General

Добрый день, после обновления mysql до 8 версии получаю ошибку «Data Dictionary initialization failed», подскажите куда копать.


2023-02-19T05:53:41.159497Z 0 [Note] Giving 0 client threads a chance to die gracefully
2023-02-19T05:53:41.160145Z 0 [Note] Shutting down slave threads
2023-02-19T05:53:41.160194Z 0 [Note] Forcefully disconnecting 0 remaining clients
2023-02-19T05:53:41.160246Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2023-02-19T05:53:41.160536Z 0 [Note] Binlog end
2023-02-19T05:53:41.164577Z 0 [Note] Shutting down plugin 'ngram'
2023-02-19T05:53:41.164626Z 0 [Note] Shutting down plugin 'partition'
2023-02-19T05:53:41.164642Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2023-02-19T05:53:41.164662Z 0 [Note] Shutting down plugin 'ARCHIVE'
2023-02-19T05:53:41.164671Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-02-19T05:53:41.164780Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2023-02-19T05:53:41.164800Z 0 [Note] Shutting down plugin 'MyISAM'
2023-02-19T05:53:41.164836Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2023-02-19T05:53:41.164860Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-02-19T05:53:41.164868Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-02-19T05:53:41.164875Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-02-19T05:53:41.164882Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-02-19T05:53:41.164912Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-02-19T05:53:41.164919Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-02-19T05:53:41.164926Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-02-19T05:53:41.164932Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-02-19T05:53:41.164938Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-02-19T05:53:41.164945Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-02-19T05:53:41.164951Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-02-19T05:53:41.164962Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-02-19T05:53:41.164969Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-02-19T05:53:41.164975Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-02-19T05:53:41.164981Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-02-19T05:53:41.164987Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2023-02-19T05:53:41.164994Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2023-02-19T05:53:41.165000Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-02-19T05:53:41.165006Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-02-19T05:53:41.165013Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-02-19T05:53:41.165019Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-02-19T05:53:41.165025Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-02-19T05:53:41.165032Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-02-19T05:53:41.165038Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-02-19T05:53:41.165050Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-02-19T05:53:41.165057Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2023-02-19T05:53:41.165063Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-02-19T05:53:41.165069Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-02-19T05:53:41.165075Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2023-02-19T05:53:41.165082Z 0 [Note] Shutting down plugin 'InnoDB'
2023-02-19T05:53:41.165352Z 0 [Note] InnoDB: FTS optimize thread exiting.
2023-02-19T05:53:41.165918Z 0 [Note] InnoDB: Starting shutdown...
2023-02-19T05:53:41.266561Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2023-02-19T05:53:41.273273Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 230219  8:53:41
2023-02-19T05:53:43.171301Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2108508925731
2023-02-19T05:53:43.171468Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-02-19T05:53:43.171484Z 0 [Note] Shutting down plugin 'MEMORY'
2023-02-19T05:53:43.171496Z 0 [Note] Shutting down plugin 'CSV'
2023-02-19T05:53:43.171509Z 0 [Note] Shutting down plugin 'sha256_password'
2023-02-19T05:53:43.171513Z 0 [Note] Shutting down plugin 'mysql_native_password'
2023-02-19T05:53:43.171767Z 0 [Note] Shutting down plugin 'binlog'
2023-02-19T05:53:43.172659Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2023-02-19T05:53:53.356024Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2023-02-19T05:53:53.359967Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 3442
2023-02-19T05:53:53.360016Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/usr/share/mysql/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2023-02-19T05:53:53.373509Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2023-02-19T05:53:53.373649Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-02-19T05:53:54.394452Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2023-02-19T05:53:54.394497Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2023-02-19T05:53:54.394507Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './db_test/#sql-ib1541-3515854875.ibd' OS error: 71
2023-02-19T05:53:54.394534Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `db_test/#sql-ib1541-3515854875` because it could not be opened.
2023-02-19T05:53:54.394581Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2023-02-19T05:53:54.394602Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2023-02-19T05:53:54.394609Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './db_test/#sql-ib2013-4209265673.ibd' OS error: 71
2023-02-19T05:53:54.394616Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `db_test/#sql-ib2013-4209265673` because it could not be opened.
2023-02-19T05:53:54.431356Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-02-19T05:53:54.978103Z 1 [ERROR] [MY-011006] [Server] Got error 197 from SE while migrating tablespaces.
2023-02-19T05:53:54.986095Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-02-19T05:53:54.986155Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-19T05:53:56.443408Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32)  MySQL Community Server - GPL.
2023-02-19T05:53:57.272837Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2023-02-19T05:53:57.275141Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 3563
2023-02-19T05:53:57.275195Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/usr/share/mysql/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2023-02-19T05:53:57.285273Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2023-02-19T05:53:57.285882Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-02-19T05:53:58.330105Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2023-02-19T05:53:58.330164Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2023-02-19T05:53:58.330183Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './db_test/#sql-ib1541-3515854875.ibd' OS error: 71
2023-02-19T05:53:58.330202Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `db_test/#sql-ib1541-3515854875` because it could not be opened.
2023-02-19T05:53:58.330297Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2023-02-19T05:53:58.330316Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2023-02-19T05:53:58.330335Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './db_test/#sql-ib2013-4209265673.ibd' OS error: 71
2023-02-19T05:53:58.330350Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `db_test/#sql-ib2013-4209265673` because it could not be opened.
2023-02-19T05:53:58.371234Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-02-19T05:53:58.893662Z 1 [ERROR] [MY-011006] [Server] Got error 197 from SE while migrating tablespaces.
2023-02-19T05:53:58.900710Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-02-19T05:53:58.900740Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-19T05:54:00.340820Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32)  MySQL Community Server - GPL.
2023-02-19T05:56:45.153863Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2023-02-19T05:56:45.157418Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 4257
2023-02-19T05:56:45.157513Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/usr/share/mysql/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.

 

sdllll
()
24 комментария

Ошибка 0x800B0109 при установке сертификата

Форум — General

Добрый день,

Ошибка 0x800B0109: Цепочка сертификатов обработана правильно, но обработка прервана на корневом сертификате, у которого отсутствует отношение доверия с поставщиком доверия.

подскажите как исправить, после обновления сертификата ФНС появилась такая ошибка, был установлен корневой сертификат ФНС и списки отзывов.


wget -P CAs $(/opt/cprocsp/bin/amd64/certmgr -list -store uMy | awk '/CA cert URL/ { print $5 }')
for cert in $(ls -1 CAs/*.crt); do sudo /opt/cprocsp/bin/amd64/certmgr -inst -store mRoot -file $cert; done

for cert in $(ls -1 CAs/*.crt); do cp $cert /usr/local/share/ca-certificates/; done
sudo update-ca-certificates -v

не помогает

 ,

sdllll
()
1 комментарий

Распиновка IP камеры Carcam 4667VP

Форум — General

Помогите определить распиновку IP камеры, кабель пришлось отрезать На фото витая пара и контакты IP камеры

https://ibb.co/523LnB3 https://ibb.co/1JqRD91

 

sdllll
()
4 комментария

RSS подписка на новые темы