Evaluation of UNRAID - Unable to locate/set mariadb root password

[Johnny Stork]

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)

[Squid]

Probably best to ask @mgutt in the applicable support thread

[mgutt]

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...:

 

[ChatNoir]

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.

[Johnny Stork]

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 

 

[ChatNoir]

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 ?