Johnny Stork Posted September 11, 2021 Share Posted September 11, 2021 We are currently comparing UNRAID and TrueNAS and although we are close to going with the licensed version of UNRAID, I am having trouble locating or setting the mariadb docker container root password. The instructions in the container about looking for "GENERATED ROOT PASSWORD" in the logs turned up no such logs. Apparently the automated set root password is actually contained in a "template" file but I am not sure where to locate this. Please, I believe this is the last obstacle so we would really appreciate your support in this matter. From MariaDB Docker Container: "Root Password: This container creates by default a random root password on initial execution. Open Docker > MariaDB Icon > Logs > Scroll down to "GENERATED ROOT PASSWORD" to find it." Logs (no "GENERATED ROOT PASSWORD" 2021-09-11 13:44:17-07:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.4+maria~focal started. 2021-09-11 13:44:18 0 [Note] mysqld (server 10.6.4-MariaDB-1:10.6.4+maria~focal) starting as process 1 ... 2021-09-11 13:44:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-09-11 13:44:18 0 [Note] InnoDB: Number of pools: 1 2021-09-11 13:44:18 0 [Note] InnoDB: Using generic crc32 instructions 2021-09-11 13:44:18 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2021-09-11 13:44:18 0 [Note] InnoDB: Using Linux native AIO 2021-09-11 13:44:18 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2021-09-11 13:44:18 0 [Note] InnoDB: Completed initialization of buffer pool 2021-09-11 13:44:18 0 [Note] InnoDB: 128 rollback segments are active. 2021-09-11 13:44:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-09-11 13:44:18 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-09-11 13:44:18 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-09-11 13:44:18 0 [Note] InnoDB: 10.6.4 started; log sequence number 42209; transaction id 14 2021-09-11 13:44:18 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-09-11 13:44:18 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-09-11 13:44:18 0 [Note] InnoDB: Buffer pool(s) load completed at 210911 13:44:18 2021-09-11 13:44:18 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work. 2021-09-11 13:44:18 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-09-11 13:44:18 0 [Note] Server socket created on IP: '::'. 2021-09-11 13:44:18 0 [Warning] 'proxies_priv' entry '@% root@b10d706b3b17' ignored in --skip-name-resolve mode. 2021-09-11 13:44:18 0 [Note] mysqld: ready for connections. Version: '10.6.4-MariaDB-1:10.6.4+maria~focal' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2021-09-11 13:44:49 3 [Warning] Access denied for user 'jstork'@'172.17.0.4' (using password: YES) 2021-09-11 13:55:44 26 [Warning] Access denied for user 'root'@'172.17.0.4' (using password: YES) 2021-09-11 13:55:50 27 [Warning] Access denied for user 'root'@'172.17.0.4' (using password: NO) 2021-09-11 13:58:04 28 [Warning] Access denied for user 'UNKNOWN_USER'@'localhost' (using password: NO) 2021-09-11 13:58:16 29 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2021-09-11 13:58:33 30 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2021-09-11 14:03:08 32 [Warning] Access denied for user 'root'@'localhost' (using password: NO) Quote Link to comment
Squid Posted September 11, 2021 Share Posted September 11, 2021 Probably best to ask @mgutt in the applicable support thread Quote Link to comment
mgutt Posted September 11, 2021 Share Posted September 11, 2021 1 hour ago, Johnny Stork said: Logs (no "GENERATED ROOT PASSWORD" The root password is only visible on the very first start. You started the container twice or installed it again without removing the appdata folder of MariaDB. A) If you don't have any data in the db, then remove the container and use the appdata cleanup plugin to remove the mariadb appdata folder: Then install the container again and check the logs directly. The password will be visible: B) If you already have data in the db, then change your root password. The method is described here: https://forums.unraid.net/topic/110019-support-mariadb-official/?tab=comments#comment-1004285 Note: You get the best performance if you change the paths of your db to /mnt/cache...: 1 1 Quote Link to comment
ChatNoir Posted September 12, 2021 Share Posted September 12, 2021 9 hours ago, mgutt said: Note: You get the best performance if you change the paths of your db to /mnt/cache...: If you have a cache pool in addition to the Array and it is actually named cache. If not, on one or the other, we can advise. 1 Quote Link to comment
Johnny Stork Posted September 13, 2021 Author Share Posted September 13, 2021 Thank you both so much for your quick responses! So far I am THOROUGHLY impressed with Unraid, this rapid response to pre-sales questions and just have a few more things to configure and test. I have the mysql root access issue resolve but I am I am having some trouble with remote ssh access, but maybe I need to allow remote ssh logins in the sshd config? I am in the middle of some chemo and radiation treatments but should be able to return to my testing later in the week. I also need to swap the mothboard out for one with IOMMU to test a Plex VM with a GPU. Any heads-up if there would be a problem with Unraid restarting with a new motherboard and a current configuration? I am guessing I will lose any array's? And unfortunately I have 6 SMR drives so the resliver took days. Anyway, even if I need to start from scratch thats no problem. I was just too lazy to get around to that M swap until now. Cheers 1 Quote Link to comment
ChatNoir Posted September 13, 2021 Share Posted September 13, 2021 2 hours ago, Johnny Stork said: I also need to swap the mothboard out for one with IOMMU to test a Plex VM with a GPU Why not just use Plex as a Docker container ? That's what most people do and it can use a GPU. In that case, the GPU will be available to all dockers. 2 hours ago, Johnny Stork said: Any heads-up if there would be a problem with Unraid restarting with a new motherboard and a current configuration? I am guessing I will lose any array's? Should be fine. Unraid identifies disks by Serial Number. Unless you are using a RAID controller or an USB enclosure that messes with S/Ns, you should be fine. Of course, it is better to stop auto Array start up and know your disk assignement in this situation just to be on the safe side. Also note that any hardware passthrough will have to be potentially changed before VMs startup. 2 hours ago, Johnny Stork said: I have 6 SMR drives As you may know, those are not advised, especially for the Parity(s) disk(s). 2 hours ago, Johnny Stork said: I am I am having some trouble with remote ssh access, but maybe I need to allow remote ssh logins in the sshd config? Not an expert on this, so I'll let the guys answer this. To clarify, do you mean remote from access from your LAN to your server or outside of your LAN ? Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.