sickprodigy/home-server
1
0
Fork 0
Code Issues 15 Pull Requests Packages Projects Releases Wiki Activity

mariadb ; setup and tested #6

New Issue
Closed
opened 2023-10-26 23:45:33 -04:00 by sickprodigy · 2 comments
sickprodigy commented 2023-10-26 23:45:33 -04:00
Owner
Copy Link

Figure out why mariadb/mysql db is having issues. Get it setup, and test.

Figure out why mariadb/mysql db is having issues. Get it setup, and test.
sickprodigy commented 2023-11-12 17:54:16 -05:00
Author
Owner
Copy Link
2023-11-12T16:26:10.411578168Z [migrations] started
2023-11-12T16:26:10.411605615Z [migrations] no migrations found
2023-11-12T16:26:10.463938098Z ───────────────────────────────────────
2023-11-12T16:26:10.463952728Z 
2023-11-12T16:26:10.463956338Z       ██╗     ███████╗██╗ ██████╗ 
2023-11-12T16:26:10.463959711Z       ██║     ██╔════╝██║██╔═══██╗
2023-11-12T16:26:10.463962849Z       ██║     ███████╗██║██║   ██║
2023-11-12T16:26:10.463965975Z       ██║     ╚════██║██║██║   ██║
2023-11-12T16:26:10.463969048Z       ███████╗███████║██║╚██████╔╝
2023-11-12T16:26:10.463972174Z       ╚══════╝╚══════╝╚═╝ ╚═════╝ 
2023-11-12T16:26:10.463975319Z 
2023-11-12T16:26:10.463978236Z    Brought to you by linuxserver.io
2023-11-12T16:26:10.463981218Z ───────────────────────────────────────
2023-11-12T16:26:10.464127411Z 
2023-11-12T16:26:10.464138651Z To support LSIO projects visit:
2023-11-12T16:26:10.464144647Z https://www.linuxserver.io/donate/
2023-11-12T16:26:10.464148936Z 
2023-11-12T16:26:10.464153212Z ───────────────────────────────────────
2023-11-12T16:26:10.464157781Z GID/UID
2023-11-12T16:26:10.464162012Z ───────────────────────────────────────
2023-11-12T16:26:10.466178192Z 
2023-11-12T16:26:10.466187753Z User UID:    1000
2023-11-12T16:26:10.466191225Z User GID:    1003
2023-11-12T16:26:10.466194255Z ───────────────────────────────────────
2023-11-12T16:26:10.466197780Z 
2023-11-12T16:26:10.495370853Z Setting Up Initial Databases
2023-11-12T16:26:10.514024022Z chown: cannot access '/auth_pam_tool_dir/auth_pam_tool': No such file or directory
2023-11-12T16:26:10.514102265Z Couldn't set an owner to '/auth_pam_tool_dir/auth_pam_tool'.
2023-11-12T16:26:10.514112016Z It must be root, the PAM authentication plugin doesn't work otherwise..
2023-11-12T16:26:10.514117625Z 
2023-11-12T16:26:10.514837756Z chown: cannot access '/auth_pam_tool_dir': No such file or directory
2023-11-12T16:26:10.515000335Z Cannot change ownership of the '/auth_pam_tool_dir' directory
2023-11-12T16:26:10.515008048Z to the 'abc' user. Check that you have the necessary permissions and try again.
2023-11-12T16:26:10.515020354Z 
2023-11-12T16:26:10.515147310Z Installing MariaDB/MySQL system tables in '/config/databases' ...
2023-11-12T16:26:10.694341961Z 2023-11-12 16:26:10 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2023-11-12T16:26:13.428349300Z OK
2023-11-12T16:26:13.428496175Z 
2023-11-12T16:26:13.428502355Z To start mariadbd at boot time you have to copy
2023-11-12T16:26:13.428508464Z support-files/mariadb.service to the right place for your system
2023-11-12T16:26:13.428511668Z 
2023-11-12T16:26:13.428514636Z 
2023-11-12T16:26:13.428517577Z PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
2023-11-12T16:26:13.428520756Z To do so, start the server, then issue the following command:
2023-11-12T16:26:13.428523755Z 
2023-11-12T16:26:13.428526653Z '/usr/bin/mariadb-secure-installation'
2023-11-12T16:26:13.428529602Z 
2023-11-12T16:26:13.428532506Z which will also give you the option of removing the test
2023-11-12T16:26:13.428535484Z databases and anonymous user created by default.  This is
2023-11-12T16:26:13.428538469Z strongly recommended for production servers.
2023-11-12T16:26:13.428541422Z 
2023-11-12T16:26:13.428544360Z See the MariaDB Knowledgebase at https://mariadb.com/kb
2023-11-12T16:26:13.428547367Z 
2023-11-12T16:26:13.428552385Z You can start the MariaDB daemon with:
2023-11-12T16:26:13.428555964Z cd '/usr' ; /usr/bin/mariadb-safe --datadir='/config/databases'
2023-11-12T16:26:13.428560521Z 
2023-11-12T16:26:13.428564623Z You can test the MariaDB daemon with mysql-test-run.pl
2023-11-12T16:26:13.428567677Z cd '/usr/mysql-test' ; perl mariadb-test-run.pl
2023-11-12T16:26:13.428570632Z 
2023-11-12T16:26:13.428573806Z Please report any problems at https://mariadb.org/jira
2023-11-12T16:26:13.428576790Z 
2023-11-12T16:26:13.428579721Z The latest information about MariaDB is available at https://mariadb.org/.
2023-11-12T16:26:13.428582724Z 
2023-11-12T16:26:13.428585634Z Consider joining MariaDB's strong and vibrant community:
2023-11-12T16:26:13.428588622Z https://mariadb.org/get-involved/
2023-11-12T16:26:13.428591569Z 
2023-11-12T16:26:13.452313967Z 2023-11-12 16:26:13 0 [Note] Starting MariaDB 10.11.5-MariaDB-log source revision 7875294b6b74b53dd3aaa723e6cc103d2bb47b2c as process 195
2023-11-12T16:26:13.465400279Z 2023-11-12 16:26:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2023-11-12T16:26:13.466832321Z 2023-11-12 16:26:13 0 [Note] InnoDB: Number of transaction pools: 1
2023-11-12T16:26:13.466846649Z 2023-11-12 16:26:13 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-11-12T16:26:13.466861591Z 2023-11-12 16:26:13 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-11-12T16:26:13.510729832Z 2023-11-12 16:26:13 0 [Note] InnoDB: Using Linux native AIO
2023-11-12T16:26:13.511029717Z 2023-11-12 16:26:13 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB
2023-11-12T16:26:13.513024307Z 2023-11-12 16:26:13 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-12T16:26:13.524704897Z 2023-11-12 16:26:13 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2023-11-12T16:26:13.526436873Z 2023-11-12 16:26:13 0 [Note] InnoDB: End of log at LSN=46556
2023-11-12T16:26:13.539502976Z 2023-11-12 16:26:13 0 [Note] InnoDB: 128 rollback segments are active.
2023-11-12T16:26:13.539851978Z 2023-11-12 16:26:13 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-11-12T16:26:13.539885955Z 2023-11-12 16:26:13 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-11-12T16:26:13.540986712Z 2023-11-12 16:26:13 0 [Note] InnoDB: log sequence number 46556; transaction id 14
2023-11-12T16:26:13.541039488Z 2023-11-12 16:26:13 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool
2023-11-12T16:26:13.541087627Z 2023-11-12 16:26:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-12T16:26:13.544277321Z 2023-11-12 16:26:13 0 [Note] InnoDB: Buffer pool(s) load completed at 231112 16:26:13
2023-11-12T16:26:13.557862900Z 2023-11-12 16:26:13 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-11-12T16:26:13.557873143Z 2023-11-12 16:26:13 0 [Note] Server socket created on IP: '::'.
2023-11-12T16:26:13.584871092Z 2023-11-12 16:26:13 0 [Note] mariadbd: ready for connections.
2023-11-12T16:26:13.584884975Z Version: '10.11.5-MariaDB-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Alpine Linux
2023-11-12T16:26:15.447245608Z 2023-11-12 16:26:15 0 [Note] mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
2023-11-12T16:26:15.447366605Z 2023-11-12 16:26:15 0 [Note] InnoDB: FTS optimize thread exiting.
2023-11-12T16:26:15.463507781Z 2023-11-12 16:26:15 0 [Note] InnoDB: Starting shutdown...
2023-11-12T16:26:15.463542807Z 2023-11-12 16:26:15 0 [Note] InnoDB: Dumping buffer pool(s) to /config/databases/ib_buffer_pool
2023-11-12T16:26:15.463716832Z 2023-11-12 16:26:15 0 [Note] InnoDB: Buffer pool(s) dump completed at 231112 16:26:15
2023-11-12T16:26:15.724792164Z 2023-11-12 16:26:15 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-11-12T16:26:15.724805793Z 2023-11-12 16:26:15 0 [Note] InnoDB: Shutdown completed; log sequence number 46556; transaction id 16
2023-11-12T16:26:15.733262676Z 2023-11-12 16:26:15 0 [Note] mariadbd: Shutdown complete
2023-11-12T16:26:15.733273251Z 
2023-11-12T16:26:16.447971612Z Database Setup Completed
2023-11-12T16:26:16.466169719Z [custom-init] No custom files found, skipping...
2023-11-12T16:26:16.522245180Z 231112 16:26:16 mysqld_safe Logging to '/config/databases/9a32e8cce91c.err'.
2023-11-12T16:26:16.536446921Z 231112 16:26:16 mysqld_safe Starting mariadbd daemon with databases from /config/databases
2023-11-12T16:26:17.508809126Z [ls.io-init] done.
``` 2023-11-12T16:26:10.411578168Z [migrations] started 2023-11-12T16:26:10.411605615Z [migrations] no migrations found 2023-11-12T16:26:10.463938098Z ─────────────────────────────────────── 2023-11-12T16:26:10.463952728Z 2023-11-12T16:26:10.463956338Z ██╗ ███████╗██╗ ██████╗ 2023-11-12T16:26:10.463959711Z ██║ ██╔════╝██║██╔═══██╗ 2023-11-12T16:26:10.463962849Z ██║ ███████╗██║██║ ██║ 2023-11-12T16:26:10.463965975Z ██║ ╚════██║██║██║ ██║ 2023-11-12T16:26:10.463969048Z ███████╗███████║██║╚██████╔╝ 2023-11-12T16:26:10.463972174Z ╚══════╝╚══════╝╚═╝ ╚═════╝ 2023-11-12T16:26:10.463975319Z 2023-11-12T16:26:10.463978236Z Brought to you by linuxserver.io 2023-11-12T16:26:10.463981218Z ─────────────────────────────────────── 2023-11-12T16:26:10.464127411Z 2023-11-12T16:26:10.464138651Z To support LSIO projects visit: 2023-11-12T16:26:10.464144647Z https://www.linuxserver.io/donate/ 2023-11-12T16:26:10.464148936Z 2023-11-12T16:26:10.464153212Z ─────────────────────────────────────── 2023-11-12T16:26:10.464157781Z GID/UID 2023-11-12T16:26:10.464162012Z ─────────────────────────────────────── 2023-11-12T16:26:10.466178192Z 2023-11-12T16:26:10.466187753Z User UID: 1000 2023-11-12T16:26:10.466191225Z User GID: 1003 2023-11-12T16:26:10.466194255Z ─────────────────────────────────────── 2023-11-12T16:26:10.466197780Z 2023-11-12T16:26:10.495370853Z Setting Up Initial Databases 2023-11-12T16:26:10.514024022Z chown: cannot access '/auth_pam_tool_dir/auth_pam_tool': No such file or directory 2023-11-12T16:26:10.514102265Z Couldn't set an owner to '/auth_pam_tool_dir/auth_pam_tool'. 2023-11-12T16:26:10.514112016Z It must be root, the PAM authentication plugin doesn't work otherwise.. 2023-11-12T16:26:10.514117625Z 2023-11-12T16:26:10.514837756Z chown: cannot access '/auth_pam_tool_dir': No such file or directory 2023-11-12T16:26:10.515000335Z Cannot change ownership of the '/auth_pam_tool_dir' directory 2023-11-12T16:26:10.515008048Z to the 'abc' user. Check that you have the necessary permissions and try again. 2023-11-12T16:26:10.515020354Z 2023-11-12T16:26:10.515147310Z Installing MariaDB/MySQL system tables in '/config/databases' ... 2023-11-12T16:26:10.694341961Z 2023-11-12 16:26:10 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory") 2023-11-12T16:26:13.428349300Z OK 2023-11-12T16:26:13.428496175Z 2023-11-12T16:26:13.428502355Z To start mariadbd at boot time you have to copy 2023-11-12T16:26:13.428508464Z support-files/mariadb.service to the right place for your system 2023-11-12T16:26:13.428511668Z 2023-11-12T16:26:13.428514636Z 2023-11-12T16:26:13.428517577Z PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! 2023-11-12T16:26:13.428520756Z To do so, start the server, then issue the following command: 2023-11-12T16:26:13.428523755Z 2023-11-12T16:26:13.428526653Z '/usr/bin/mariadb-secure-installation' 2023-11-12T16:26:13.428529602Z 2023-11-12T16:26:13.428532506Z which will also give you the option of removing the test 2023-11-12T16:26:13.428535484Z databases and anonymous user created by default. This is 2023-11-12T16:26:13.428538469Z strongly recommended for production servers. 2023-11-12T16:26:13.428541422Z 2023-11-12T16:26:13.428544360Z See the MariaDB Knowledgebase at https://mariadb.com/kb 2023-11-12T16:26:13.428547367Z 2023-11-12T16:26:13.428552385Z You can start the MariaDB daemon with: 2023-11-12T16:26:13.428555964Z cd '/usr' ; /usr/bin/mariadb-safe --datadir='/config/databases' 2023-11-12T16:26:13.428560521Z 2023-11-12T16:26:13.428564623Z You can test the MariaDB daemon with mysql-test-run.pl 2023-11-12T16:26:13.428567677Z cd '/usr/mysql-test' ; perl mariadb-test-run.pl 2023-11-12T16:26:13.428570632Z 2023-11-12T16:26:13.428573806Z Please report any problems at https://mariadb.org/jira 2023-11-12T16:26:13.428576790Z 2023-11-12T16:26:13.428579721Z The latest information about MariaDB is available at https://mariadb.org/. 2023-11-12T16:26:13.428582724Z 2023-11-12T16:26:13.428585634Z Consider joining MariaDB's strong and vibrant community: 2023-11-12T16:26:13.428588622Z https://mariadb.org/get-involved/ 2023-11-12T16:26:13.428591569Z 2023-11-12T16:26:13.452313967Z 2023-11-12 16:26:13 0 [Note] Starting MariaDB 10.11.5-MariaDB-log source revision 7875294b6b74b53dd3aaa723e6cc103d2bb47b2c as process 195 2023-11-12T16:26:13.465400279Z 2023-11-12 16:26:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2023-11-12T16:26:13.466832321Z 2023-11-12 16:26:13 0 [Note] InnoDB: Number of transaction pools: 1 2023-11-12T16:26:13.466846649Z 2023-11-12 16:26:13 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-11-12T16:26:13.466861591Z 2023-11-12 16:26:13 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) 2023-11-12T16:26:13.510729832Z 2023-11-12 16:26:13 0 [Note] InnoDB: Using Linux native AIO 2023-11-12T16:26:13.511029717Z 2023-11-12 16:26:13 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB 2023-11-12T16:26:13.513024307Z 2023-11-12 16:26:13 0 [Note] InnoDB: Completed initialization of buffer pool 2023-11-12T16:26:13.524704897Z 2023-11-12 16:26:13 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) 2023-11-12T16:26:13.526436873Z 2023-11-12 16:26:13 0 [Note] InnoDB: End of log at LSN=46556 2023-11-12T16:26:13.539502976Z 2023-11-12 16:26:13 0 [Note] InnoDB: 128 rollback segments are active. 2023-11-12T16:26:13.539851978Z 2023-11-12 16:26:13 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2023-11-12T16:26:13.539885955Z 2023-11-12 16:26:13 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2023-11-12T16:26:13.540986712Z 2023-11-12 16:26:13 0 [Note] InnoDB: log sequence number 46556; transaction id 14 2023-11-12T16:26:13.541039488Z 2023-11-12 16:26:13 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool 2023-11-12T16:26:13.541087627Z 2023-11-12 16:26:13 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-11-12T16:26:13.544277321Z 2023-11-12 16:26:13 0 [Note] InnoDB: Buffer pool(s) load completed at 231112 16:26:13 2023-11-12T16:26:13.557862900Z 2023-11-12 16:26:13 0 [Note] Server socket created on IP: '0.0.0.0'. 2023-11-12T16:26:13.557873143Z 2023-11-12 16:26:13 0 [Note] Server socket created on IP: '::'. 2023-11-12T16:26:13.584871092Z 2023-11-12 16:26:13 0 [Note] mariadbd: ready for connections. 2023-11-12T16:26:13.584884975Z Version: '10.11.5-MariaDB-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Alpine Linux 2023-11-12T16:26:15.447245608Z 2023-11-12 16:26:15 0 [Note] mariadbd (initiated by: root[root] @ localhost []): Normal shutdown 2023-11-12T16:26:15.447366605Z 2023-11-12 16:26:15 0 [Note] InnoDB: FTS optimize thread exiting. 2023-11-12T16:26:15.463507781Z 2023-11-12 16:26:15 0 [Note] InnoDB: Starting shutdown... 2023-11-12T16:26:15.463542807Z 2023-11-12 16:26:15 0 [Note] InnoDB: Dumping buffer pool(s) to /config/databases/ib_buffer_pool 2023-11-12T16:26:15.463716832Z 2023-11-12 16:26:15 0 [Note] InnoDB: Buffer pool(s) dump completed at 231112 16:26:15 2023-11-12T16:26:15.724792164Z 2023-11-12 16:26:15 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" 2023-11-12T16:26:15.724805793Z 2023-11-12 16:26:15 0 [Note] InnoDB: Shutdown completed; log sequence number 46556; transaction id 16 2023-11-12T16:26:15.733262676Z 2023-11-12 16:26:15 0 [Note] mariadbd: Shutdown complete 2023-11-12T16:26:15.733273251Z 2023-11-12T16:26:16.447971612Z Database Setup Completed 2023-11-12T16:26:16.466169719Z [custom-init] No custom files found, skipping... 2023-11-12T16:26:16.522245180Z 231112 16:26:16 mysqld_safe Logging to '/config/databases/9a32e8cce91c.err'. 2023-11-12T16:26:16.536446921Z 231112 16:26:16 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2023-11-12T16:26:17.508809126Z [ls.io-init] done. ```
sickprodigy commented 2023-11-12 17:57:50 -05:00
Author
Owner
Copy Link

had to delete /var/lib/docker/network/files/local-kv.db because phantom network

Rebuilt networking in docker.

Seems to be working now not sure.

had to delete /var/lib/docker/network/files/local-kv.db because phantom network Rebuilt networking in docker. Seems to be working now not sure.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Compat/Breaking
Breaking change that won't be backward compatible
 Kind/Bug
Something is not working
 Kind/Documentation
Documentation changes
 Kind/Enhancement
Improve existing functionality
 Kind/Feature
New functionality
 Kind/Security
This is security issue
 Kind/Testing
Issue or pull request related to testing
Priority
Critical
The priority is critical
Priority
High
The priority is high
Priority
Low
The priority is low
Priority
Medium
The priority is medium
Reviewed
Confirmed
Issue has been confirmed
Reviewed
Duplicate
This issue or pull request already exists
Reviewed
Invalid
Invalid issue
Reviewed
Won't Fix
This issue won't be fixed
Status
Abandoned
Somebody has started to work on this but abandoned work
Status
Blocked
Something is blocking this issue or pull request
Status
Need More Info
Feedback is required to reproduce issue or to continue work
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
sickprodigy
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: sickprodigy/home-server#6
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?