全球主机交流论坛

标题: cyberpanel使用官方的数据库优化命令进行优化后面版直接500 [打印本页]

作者: songliannv 时间: 2022-5-20 11:23
标题: cyberpanel使用官方的数据库优化命令进行优化后面版直接500
cyberpanel使用官方的数据库优化命令进行优化后面版直接500，手动改回又可以用了，请问是什么原因？

优化后报错
** (pkttyagent:1941): WARNING **: 23:16:56.677: Unable to register authentication agent: GDBus.Error

rg.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject
Error registering authentication agent: GDBus.Error

rg.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject (polkit-error-quark, 0)
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

手工改回后
** (pkttyagent:21000): WARNING **: 23:19:17.473: Unable to register authentication agent: GDBus.Error

rg.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject
Error registering authentication agent: GDBus.Error

rg.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject (polkit-error-quark, 0)

谁帮忙看看怎么解决，谢谢

作者: kydtf 时间: 2022-5-20 11:30
使用命令

groupadd -g 23 nohidproc
usermod -a -G nohidproc polkitd
mount -o remount,rw,hidepid=2,gid=nohidproc /proc
systemctl restart polkit

复制代码

作者: songliannv 时间: 2022-5-20 11:53

kydtf 发表于 2022-5-20 11:30
使用命令

不行，还是500，输完命令后
** (pkttyagent:22743): WARNING **: 23:47:29.050: Unable to register authentication agent: GDBus.Error

rg.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject

用service mysqld restart，重启数据库
Redirecting to /bin/systemctl restart mysqld.service
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

cyberpanel 真难用- -

作者: songliannv 时间: 2022-5-20 11:55
官方提供的优化数据
[mysqld]

# GENERAL #
user                         = mysql
default-storage-engine       = InnoDB
#socket                      = /var/lib/mysql/mysql.sock
#pid-file                      = /var/lib/mysql/mysqld.pid

# MyISAM #
# key-buffer-size             = 32M
# myisam-recover                = FORCE,BACKUP

# SAFETY #
max-allowed-packet          = 16M
max-connect-errors          = 1000000
sql-mode                      = NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
sysdate-is-now                = 1
innodb-strict-mode          = 1

# DATA STORAGE #
datadir                      = /var/lib/mysql

# SERVER ID #
server-id                   = 677161

# CACHES AND LIMITS #
max-connections             = 500
tmp-table-size                = 32M
max-heap-table-size          = 32M
query-cache-type             = 0
query-cache-size             = 0
thread-cache-size             = 50
open-files-limit             = 65535
table-definition-cache       = 1024
table-open-cache             = 2048

# INNODB #
innodb-flush-method          = O_DIRECT
innodb-log-files-in-group    = 2
innodb-log-file-size          = 128M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table       = 1
innodb-buffer-pool-size       = 1228M

# LOGGING #
log-error                   = /var/lib/mysql/mysqld.log
slow-query-log                = 1
slow-query-log-file          = /var/lib/mysql/mysqld-slow.log
log-queries-not-using-indexes  = OFF
long_query_time             = 30

[mysqldump]
max-allowed-packet          = 16M

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/

作者: songliannv 时间: 2022-5-20 11:57
原始的数据
#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d

欢迎光临全球主机交流论坛 (https://hostloc.gdisk.cf/)