mirror of
https://github.com/cloudpanel-io/cloudpanel-ce.git
synced 2026-04-05 20:31:58 +02:00
Authentication issue with Mariadb #377
Assignees
MrUnknownDE
Clear assignees
MrUnknownDE
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github/cloudpanel-ce#377
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @bitwanderer on 7/9/2023
CloudPanel version(s) affected
2.3.1
Description
Looking at mysql status , I (and others) are seeing this error message:
Jul 09 11:24:41 systemd[1]: Starting MariaDB 10.11.4 database server...
Jul 09 11:24:41 mariadbd[1061189]: 2023-07-09 11:24:41 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 65535)
Jul 09 11:24:41 systemd[1]: Started MariaDB 10.11.4 database server.
Jul 09 11:24:41 /etc/mysql/debian-start[1061205]: Upgrading MySQL tables if necessary.
Jul 09 11:24:42 /etc/mysql/debian-start[1061208]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
Jul 09 11:24:42 /etc/mysql/debian-start[1061208]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Jul 09 11:24:42 /etc/mysql/debian-start[1061208]: FATAL ERROR: Upgrade failed
Jul 09 11:24:42 /etc/mysql/debian-start[1061214]: Checking for insecure root accounts.
Jul 09 11:24:42 debian-start[1061217]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
The error log shows:
2023-07-09 11:24:41 0 [Note] Starting MariaDB 10.11.4-MariaDB-1:10.11.4+maria
deb11 source revision 4e2b93dffef2414a11ca5edc8d215f57ee5010e5 as process 1061189deb11' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution2023-07-09 11:24:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-07-09 11:24:41 0 [Note] InnoDB: Number of transaction pools: 1
2023-07-09 11:24:41 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-07-09 11:24:41 0 [Note] InnoDB: Using liburing
2023-07-09 11:24:41 0 [Note] InnoDB: Initializing buffer pool, total size = 512.000MiB, chunk size = 8.000MiB
2023-07-09 11:24:41 0 [Note] InnoDB: Completed initialization of buffer pool
2023-07-09 11:24:41 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2023-07-09 11:24:41 0 [Note] InnoDB: 128 rollback segments are active.
2023-07-09 11:24:41 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-07-09 11:24:41 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-07-09 11:24:41 0 [Note] InnoDB: log sequence number 4994431194; transaction id 1248213
2023-07-09 11:24:41 0 [Note] InnoDB: Loading buffer pool(s) from /home/mysql/ib_buffer_pool
2023-07-09 11:24:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-07-09 11:24:41 0 [Warning] 'innodb-buffer-pool-instances' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2023-07-09 11:24:41 0 [Warning] 'innodb-thread-concurrency' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2023-07-09 11:24:41 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-07-09 11:24:41 0 [Note] Server socket created on IP: '::'.
2023-07-09 11:24:41 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '10.11.4-MariaDB-1:10.11.4+maria
2023-07-09 11:24:42 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
How to reproduce
Restart mysql and you will see the error reproduced.
Possible Solution
No response
Additional Context
No response