mirror of
https://github.com/konstruktoid/hardening.git
synced 2026-04-26 17:25:52 +03:00
[GH-ISSUE #479] Install mysql server got error #84
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
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 @IronT3cH on GitHub (Aug 13, 2024).
Original GitHub issue: https://github.com/konstruktoid/hardening/issues/479
Originally assigned to: @konstruktoid on GitHub.
After hardening, I want to install mysql and got error like this.
/var/log/mysql/error.log
2024-08-13T03:12:54.342091Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.39-0ubuntu0.22.04.1) initializing of server in progress as process 595909
2024-08-13T03:12:54.474163Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-13T03:12:54.482777Z 1 [ERROR] [MY-012576] [InnoDB] Unable to create temporary file inside "/tmp/user/0"; errno: 13
2024-08-13T03:12:54.482821Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2024-08-13T03:12:54.482995Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-13T03:12:54.483021Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2024-08-13T03:12:54.483038Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-13T03:12:54.483548Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39-0ubuntu0.22.04.1) (Ubuntu).
2024-08-13T03:12:54.737550Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39-0ubuntu0.22.04.1) starting as process 595917
2024-08-13T03:12:54.771210Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-08-13T03:12:54.771315Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-13T03:12:54.771347Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-13T03:12:54.775154Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39-0ubuntu0.22.04.1) (Ubuntu).
2024-08-13T03:29:20.109671Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39-0ubuntu0.22.04.1) starting as process 2995
2024-08-13T03:29:20.130016Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-08-13T03:29:20.130120Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-13T03:29:20.130139Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-13T03:29:20.131949Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39-0ubuntu0.22.04.1) (Ubuntu).
It's from journalctl
It's from installation
It goes smoothly on not hardening endpoint.
I have couple hardening endpoint with same error like case above.
Please advice,
Thank you.
@konstruktoid commented on GitHub (Aug 13, 2024):
Most likely caused by
libpam-tmpdir, but does/tmp/user/0exist and have the correct permissions?@IronT3cH commented on GitHub (Aug 13, 2024):
Thank you dude, I change the permission to 760, it was installed smoothly.
I think we can close this one.