Just an update
After many versions found the following to work
Download Mariadb via portainer
Set Manual port publishing, host=3306, Container=3306 TCP
ENV - Set MYSQL_ROOT_HOST, can be % but I used 192.168.100.% to sort of limit access
Found out my Heidi SQL client would always get rejected, not sure why, maybe a firewall rule but could not find any, anyway it got uninstalled and I used DBeaver - Now every thing works
Leigh
Hello
Running OMV 5 (5.6.2-1 (Usul)) and trying to get Mariadb running.
Can assess and create local databases with the docker console but never remotely so can anyone please give me some pointers
Info
Installed Mariadb via Portainer and via docker run and linuxserver/mariadb version via a Portainer and docker run
Latest install is linuxserver/mariadb
From OMV console (Putty) Docker shows 172.17.04 ip address
docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' SQL
172.17.0.4
mysql -h 172.17.0.4 -u root
ERROR 2002 (HY000): Can't connect to MySQL server on '172.17.0.4' (115)
mysql -h 172.17.0.4 -p 3306 --protocol=TCP -u root
Enter password:
ERROR 2002 (HY000): Can't connect to MySQL server on '172.17.0.4' (115)
mysql -h 172.17.0.4 -p 49170 --protocol=TCP -u root
Enter password:
ERROR 2002 (HY000): Can't connect to MySQL server on '172.17.0.4' (115)
Portainer shows port mapping
PORT CONFIGURATION
0.0.0.0:49170 3306/tcp
A Zenmap scan from my PC gave the following – Docker random port 49170 but No SQL port 3306
49170/tcp open mysql
MySQL 5.5.5-10.4.18-MariaDB-1:10.4.18+maria~bionic-log
mysql-info:
Protocol: 10
Version: 5.5.5-10.4.18-MariaDB-1:10.4.18+maria~bionic-log
My /etc/mysql.my.conf has
[mysqld]
#
# * Basic Settings
#
user = abc
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /config/databases
tmpdir = /tmp
lc_messages_dir = /usr/share/mysql
lc_messages = en_US
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#;bind-address = 127.0.0.1
#
Tried
bind-address = 0.0.0.0
bind-address=127.0.0.1
bind address=192.168.100.2 – The OMV5 server
bind address=192.168.100.101 – My pc that’s got HeidiSQL client
skip-networking
Skip-bind-address
None work
docker inspect SQL shows the following (yep its long)
Not sure if the
"PortBindings": {
"3306/tcp": [
{
"HostIp": "",
"HostPort": ""
}
Is an indication that something is not correct
[
{
"Id": "87b5b2cec7aabe2fcd4181c461e41a7c4478dc27a627790817aaea34375d9ce9",
"Created": "2021-03-14T16:12:04.406609979Z",
"Path": "/init",
"Args": [],
"State": {
"Status": "running",
"Running": true,
"Paused": false,
"Restarting": false,
"OOMKilled": false,
"Dead": false,
"Pid": 22514,
"ExitCode": 0,
"Error": "",
"StartedAt": "2021-03-14T16:25:36.805041135Z",
"FinishedAt": "2021-03-14T16:25:35.76662759Z"
},
"Image": "sha256:30260c3493b20f12b50a5fb4adfe0832f8463a0df3317a4bd6ec4bb31302939b",
"ResolvConfPath": "/srv/dev-disk-by-label-1tb/docker/containers/87b5b2cec7aabe2fcd4181c461e41a7c4478dc27a627790817aaea34375d9ce9/resolv.conf",
"HostnamePath": "/srv/dev-disk-by-label-1tb/docker/containers/87b5b2cec7aabe2fcd4181c461e41a7c4478dc27a627790817aaea34375d9ce9/hostname",
"HostsPath": "/srv/dev-disk-by-label-1tb/docker/containers/87b5b2cec7aabe2fcd4181c461e41a7c4478dc27a627790817aaea34375d9ce9/hosts",
"LogPath": "/srv/dev-disk-by-label-1tb/docker/containers/87b5b2cec7aabe2fcd4181c461e41a7c4478dc27a627790817aaea34375d9ce9/87b5b2cec7aabe2fcd4181c461e41a7c4478dc27a627790817aaea34375d9ce9-json.log",
"Name": "/SQL",
"RestartCount": 0,
"Driver": "overlay2",
"Platform": "linux",
"MountLabel": "",
"ProcessLabel": "",
"AppArmorProfile": "docker-default",
"ExecIDs": null,
"HostConfig": {
"Binds": [],
"ContainerIDFile": "",
"LogConfig": {
"Type": "json-file",
"Config": {}
},
"NetworkMode": "bridge",
"PortBindings": {
"3306/tcp": [
{
"HostIp": "",
"HostPort": ""
}
]
},
"RestartPolicy": {
"Name": "no",
"MaximumRetryCount": 0
},
"AutoRemove": false,
"VolumeDriver": "",
"VolumesFrom": null,
"CapAdd": [
"AUDIT_WRITE",
"CHOWN",
"DAC_OVERRIDE",
"FOWNER",
"FSETID",
"KILL",
"MKNOD",
"NET_BIND_SERVICE",
"NET_RAW",
"SETFCAP",
"SETGID",
"SETPCAP",
"SETUID",
"SYS_CHROOT"
],
"CapDrop": [
"AUDIT_CONTROL",
"BLOCK_SUSPEND",
"DAC_READ_SEARCH",
"IPC_LOCK",
"IPC_OWNER",
"LEASE",
"LINUX_IMMUTABLE",
"MAC_ADMIN",
"MAC_OVERRIDE",
"NET_ADMIN",
"NET_BROADCAST",
"SYSLOG",
"SYS_ADMIN",
"SYS_BOOT",
"SYS_MODULE",
"SYS_NICE",
"SYS_PACCT",
"SYS_PTRACE",
"SYS_RAWIO",
"SYS_RESOURCE",
"SYS_TIME",
"SYS_TTY_CONFIG",
"WAKE_ALARM"
],
"CgroupnsMode": "host",
"Dns": [],
"DnsOptions": null,
"DnsSearch": null,
"ExtraHosts": [],
"GroupAdd": null,
"IpcMode": "private",
"Cgroup": "",
"Links": null,
"OomScoreAdj": 0,
"PidMode": "",
"Privileged": false,
"PublishAllPorts": false,
"ReadonlyRootfs": false,
"SecurityOpt": null,
"UTSMode": "",
"UsernsMode": "",
"ShmSize": 67108864,
"Runtime": "runc",
"ConsoleSize": [
0,
0
],
"Isolation": "",
"CpuShares": 0,
"Memory": 0,
"NanoCpus": 0,
"CgroupParent": "",
"BlkioWeight": 0,
"BlkioWeightDevice": null,
"BlkioDeviceReadBps": null,
"BlkioDeviceWriteBps": null,
"BlkioDeviceReadIOps": null,
"BlkioDeviceWriteIOps": null,
"CpuPeriod": 0,
"CpuQuota": 0,
"CpuRealtimePeriod": 0,
"CpuRealtimeRuntime": 0,
"CpusetCpus": "",
"CpusetMems": "",
"Devices": [],
"DeviceCgroupRules": null,
"DeviceRequests": null,
"KernelMemory": 0,
"KernelMemoryTCP": 0,
"MemoryReservation": 0,
"MemorySwap": 0,
"MemorySwappiness": null,
"OomKillDisable": false,
"PidsLimit": null,
"Ulimits": null,
"CpuCount": 0,
"CpuPercent": 0,
"IOMaximumIOps": 0,
"IOMaximumBandwidth": 0,
"MaskedPaths": [
"/proc/asound",
"/proc/acpi",
"/proc/kcore",
"/proc/keys",
"/proc/latency_stats",
"/proc/timer_list",
"/proc/timer_stats",
"/proc/sched_debug",
"/proc/scsi",
"/sys/firmware"
],
"ReadonlyPaths": [
"/proc/bus",
"/proc/fs",
"/proc/irq",
"/proc/sys",
"/proc/sysrq-trigger"
],
"Init": false
},
"GraphDriver": {
"Data": {
"LowerDir": "/srv/dev-disk-by-label-1tb/docker/overlay2/6f1f409d3733e58a71ee05acb1446adfc7062be909ebd0d966495bff3c6932a9-init/diff:/srv/dev-disk-by-label-1tb/docker/overlay2/50826618e95ff4e5ea1873ad665a30f4071010d026ea18668fa0e07a592d708a/diff:/srv/dev-disk-by-label-1tb/docker/overlay2/087d24525044e08753d4605bb0a937ed68b187874f14ff00edbc67230a1414ac/diff:/srv/dev-disk-by-label-1tb/docker/overlay2/7f0512c6ff488b3654ffa1ff18ed840478d4afdd772ca18756d9e63d525c63aa/diff:/srv/dev-disk-by-label-1tb/docker/overlay2/cb9a7189b972ec91fcc12d8e6a581474122eca105502ae6c655d00c09c329000/diff:/srv/dev-disk-by-label-1tb/docker/overlay2/91065e8252e07af39756816d7b0c5f5b7297f30919072515a0774e3d51c7c7f0/diff:/srv/dev-disk-by-label-1tb/docker/overlay2/c37fef0614f3af029b5dda6edb0de540433e28178a91237656363b63e82f544b/diff:/srv/dev-disk-by-label-1tb/docker/overlay2/666a02d9747e5e5f191eac5ff911be7d6902959b98fe0055a404551e1cfd99ab/diff:/srv/dev-disk-by-label-1tb/docker/overlay2/aca299c49b7607f20ac3b1bccb61c36e4c6642e52823363c2c115e7050999ab3/diff:/srv/dev-disk-by-label-1tb/docker/overlay2/6e157a41ec35c9769c9bd690e510f8ecb327fb264450f06383f82974d18829c7/diff",
"MergedDir": "/srv/dev-disk-by-label-1tb/docker/overlay2/6f1f409d3733e58a71ee05acb1446adfc7062be909ebd0d966495bff3c6932a9/merged",
"UpperDir": "/srv/dev-disk-by-label-1tb/docker/overlay2/6f1f409d3733e58a71ee05acb1446adfc7062be909ebd0d966495bff3c6932a9/diff",
"WorkDir": "/srv/dev-disk-by-label-1tb/docker/overlay2/6f1f409d3733e58a71ee05acb1446adfc7062be909ebd0d966495bff3c6932a9/work"
},
"Name": "overlay2"
},
"Mounts": [
{
"Type": "volume",
"Name": "f40a04d32f73474623ede81ed54aa5082ddc5318e91f68457b69b95b83d8d924",
"Source": "/srv/dev-disk-by-label-1tb/docker/volumes/f40a04d32f73474623ede81ed54aa5082ddc5318e91f68457b69b95b83d8d924/_data",
"Destination": "/config",
"Driver": "local",
"Mode": "",
"RW": true,
"Propagation": ""
}
],
"Config": {
"Hostname": "87b5b2cec7aa",
"Domainname": "",
"User": "",
"AttachStdin": false,
"AttachStdout": false,
"AttachStderr": false,
"ExposedPorts": {
"3306/tcp": {}
},
"Tty": false,
"OpenStdin": false,
"StdinOnce": false,
"Env": [
"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"HOME=/root",
"LANGUAGE=en_US.UTF-8",
"LANG=en_US.UTF-8",
"TERM=xterm",
"MYSQL_DIR=/config",
"DATADIR=/config/databases"
],
"Cmd": null,
"Image": "linuxserver/mariadb:latest",
"Volumes": {
"/config": {}
},
"WorkingDir": "",
"Entrypoint": [
"/init"
],
"OnBuild": null,
"Labels": {
"build_version": "Linuxserver.io version:- 110.4.18mariabionic-ls14 Build-date:- 2021-03-13T05:54:30+00:00",
"maintainer": "thelamer"
}
},
"NetworkSettings": {
"Bridge": "",
"SandboxID": "dc68a7eec76f6a5c7ff9fd20e4a3f58e739beb67250a00241c912d24cd22dc00",
"HairpinMode": false,
"LinkLocalIPv6Address": "",
"LinkLocalIPv6PrefixLen": 0,
"Ports": {
"3306/tcp": [
{
"HostIp": "0.0.0.0",
"HostPort": "49170"
}
]
},
"SandboxKey": "/var/run/docker/netns/dc68a7eec76f",
"SecondaryIPAddresses": null,
"SecondaryIPv6Addresses": null,
"EndpointID": "5f2c07413aade2d434e128a4af1193b8e8825b0c6ba677126c7a4f16f3986cc2",
"Gateway": "172.17.0.1",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"IPAddress": "172.17.0.4",
"IPPrefixLen": 16,
"IPv6Gateway": "",
"MacAddress": "02:42:ac:11:00:04",
"Networks": {
"bridge": {
"IPAMConfig": {},
"Links": null,
"Aliases": null,
"NetworkID": "ded98a63eb7b6400dcb08f8721dce9ae1973e53e7ea591cdda2f44b13d9d3d81",
"EndpointID": "5f2c07413aade2d434e128a4af1193b8e8825b0c6ba677126c7a4f16f3986cc2",
"Gateway": "172.17.0.1",
"IPAddress": "172.17.0.4",
"IPPrefixLen": 16,
"IPv6Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"MacAddress": "02:42:ac:11:00:04",
"DriverOpts": null
}
}
}
}
]
I can get home assistant installed fine but I'd like to install hass.io, is this possible?
I've seen a number of Ubuntu docker installs on the web but none for openmed shot.
Leigh
Thanks - will do
Hmm - turns out that the SD card reader is faulty 
For some reason I tried the sd card in a SD/USB adapter, plugged it into the USB port and 4GB Ext4 partition was view able.
So deleted the 11GB Unknown one, ran resize2fs as above, reboot and now have 15GB partition.
So the one last question, whats the /etc/cron.daily/log2ram: actually do ?
"sending incremental file list" from where ?
Is it moving files from SD card to RAM every time ?
Leigh
Hi tkaiser
First - sorry for not replying so soon, work load has been hectic and first time to look at this
Tried the above resize and it did not work - tried 3 or 4 time with reboots between.
So put the card in a Linux laptop (Mint 17) and disk utility shows 2 partitions, both Unknown type !
First is 4GB in size the other 11GB and 310mb at the end free.
So what should the partitions be EXT3,EXT4, ?
Also tried dd command to make an image and get IO errors at around 105MB
Card in the odroid appear to boot fine with no fsck errors
Before I wipe the card clean and do a fresh install - any ideas ?
Machine Info - ARMBIAN 5.31 stable Debian GNU/Linux 8 (jessie) 4.9.56-odroidxu4
HI
I'm getting messages saying the rootfs is full
EG.
Resource limit matched Service rootfs
Date:Tue, 07 Nov 2017 07:55:55
Action:alert
Host:odroidxu4
Description: space usage 85.1% matches resource limit [space usage>85.0%]
Your faithful employee,
Monit
and
Resource limit succeeded Service rootfs
Date:Tue, 07 Nov 2017 08:01:31
Action:alert
Host:odroidxu4
Description: filesystem resources succeeded
Your faithful employee,
Monit
Now I think the log2ram maybe be the problem - get these every day, varying is size
I'm not sure if the logs get written to the flash drive first and then moved to ram, which would defeat the whole "not writing to flash"
EG
/etc/cron.daily/log2ram:
sending incremental file list
./
auth.log
auth.log.1
auth.log.2.gz
auth.log.3.gz
auth.log.4.gz
daemon.log
daemon.log.1
daemon.log.2.gz
daemon.log.3.gz
daemon.log.4.gz
debug
debug.1
debug.2.gz
debug.3.gz
debug.4.gz
kern.log
kern.log.1
kern.log.2.gz
kern.log.3.gz
kern.log.4.gz
mail.info
mail.info.1
mail.info.2.gz
mail.info.3.gz
mail.info.4.gz
mail.log
mail.log.1
mail.log.2.gz
mail.log.3.gz
mail.log.4.gz
messages
messages.1
messages.2.gz
messages.3.gz
messages.4.gz
php5-fpm.log
php5-fpm.log.1
php5-fpm.log.10.gz
php5-fpm.log.11.gz
php5-fpm.log.12.gz
php5-fpm.log.2.gz
php5-fpm.log.3.gz
php5-fpm.log.4.gz
php5-fpm.log.5.gz
php5-fpm.log.6.gz
php5-fpm.log.7.gz
php5-fpm.log.8.gz
php5-fpm.log.9.gz
rsync.log
rsync.log.1.gz
rsync.log.2.gz
rsync.log.3.gz
rsync.log.4.gz
syslog
syslog.1
syslog.2.gz
syslog.3.gz
syslog.4.gz
syslog.5.gz
syslog.6.gz
syslog.7.gz
urbackup.log
urbackup.log.1.gz
urbackup.log.2.gz
urbackup.log.3.gz
urbackup.log.4.gz
urbackup.log.5.gz
urbackup.log.6.gz
urbackup.log.7.gz
urbackup.log.8.gz
urbackup.log.9.gz
user.log
user.log.1
user.log.2.gz
user.log.3.gz
user.log.4.gz
cron-apt/
cron-apt/log
cron-apt/log.1.gz
cron-apt/log.2.gz
cron-apt/log.3.gz
cron-apt/log.4.gz
nginx/
nginx/openmediavault-webgui_access.log
nginx/openmediavault-webgui_access.log.1
nginx/openmediavault-webgui_access.log.10.gz
nginx/openmediavault-webgui_access.log.11.gz
nginx/openmediavault-webgui_access.log.12.gz
nginx/openmediavault-webgui_access.log.13.gz
nginx/openmediavault-webgui_access.log.14.gz
nginx/openmediavault-webgui_access.log.2.gz
nginx/openmediavault-webgui_access.log.3.gz
nginx/openmediavault-webgui_access.log.4.gz
nginx/openmediavault-webgui_access.log.5.gz
nginx/openmediavault-webgui_access.log.6.gz
nginx/openmediavault-webgui_access.log.7.gz
nginx/openmediavault-webgui_access.log.8.gz
nginx/openmediavault-webgui_access.log.9.gz
proftpd/
proftpd/proftpd.log
proftpd/proftpd.log.1
proftpd/proftpd.log.2.gz
proftpd/proftpd.log.3.gz
proftpd/proftpd.log.4.gz
proftpd/proftpd.log.5.gz
proftpd/proftpd.log.6.gz
proftpd/proftpd.log.7.gz
samba/
samba/log.nmbd
samba/log.nmbd.1.gz
samba/log.nmbd.2.gz
samba/log.nmbd.3.gz
samba/log.nmbd.4.gz
samba/log.nmbd.5.gz
samba/log.nmbd.6.gz
samba/log.nmbd.7.gz
samba/log.smbd
samba/log.smbd.1.gz
samba/log.smbd.2.gz
samba/log.smbd.3.gz
samba/log.smbd.4.gz
samba/log.smbd.5.gz
samba/log.smbd.6.gz
samba/log.smbd.7.gz
unattended-upgrades/unattended-upgrades.log
sent 8,242,848 bytesreceived 2,356 bytes1,268,492.92 bytes/sec total size is 9,150,972speedup is 1.11
Disk space report below
Welcome to ARMBIAN 5.31 stable Debian GNU/Linux 8 (jessie) 4.9.56-odroidxu4
System load: 0.23 0.25 0.22 Up time: 1 day
Memory usage: 10 % of 1993MB IP: 192.168.1.231
CPU temp: 61°C
Usage of /: 84% of 3.7G storage/: 1% of 917G
[ 0 security updates available, 2 updates total: apt upgrade ]
Last check: 2017-11-07 00:00
[ General system configuration: armbian-config ]
Last login: Fri Nov 3 09:18:01 2017
root@odroidxu4:~# df -h
Filesystem Size Used Avail Use% Mounted on
udev 10M 0 10M 0% /dev
tmpfs 399M 17M 382M 5% /run
/dev/mmcblk1p1 3.7G 3.0G 608M 84% /
tmpfs 997M 0 997M 0% /dev/shm
tmpfs 5.0M 4.0K 5.0M 1% /run/lock
tmpfs 997M 0 997M 0% /sys/fs/cgroup
tmpfs 997M 0 997M 0% /tmp
/dev/sda1 917G 72M 871G 1% /srv/dev-disk-by-label-1TB
/dev/sdb1 3.6T 2.5T 1.1T 70% /srv/dev-disk-by-label-Tank4Gb
folder2ram 997M 8.2M 989M 1% /var/log
folder2ram 997M 0 997M 0% /var/tmp
folder2ram 997M 324K 997M 1% /var/lib/openmediavault/rrd
folder2ram 997M 1.4M 996M 1% /var/spool
folder2ram 997M 14M 984M 2% /var/lib/rrdcached
folder2ram 997M 8.0K 997M 1% /var/lib/monit
folder2ram 997M 4.0K 997M 1% /var/lib/php5
folder2ram 997M 0 997M 0% /var/lib/netatalk/CNID
folder2ram 997M 464K 997M 1% /var/cache/samba
tmpfs 200M 0 200M 0% /run/user/0
Any thoughts on whats going wrong, do I need to increase the root / partition, its on a 16GB micro SD card.
Thanks
Leigh
I've installed 3.0.76 on a Odroid X4 and it work great, so thanks guys/gals for the excellent work 
Now I'd like to use the power button on the board to "gracefully" shutdown the system down.
Under power management, I've set the power button to shutdown (Monitoring is running) but this does not appear to work.
Is this a known feature of the Ordroid version ?
Is there a script that can be run ?
The reason I'd like the power down function is that we get a lot of lightning storms (over 25 year) so when one is around, everything electrical gets unplugged - quickly as possible. I have some equipment connected to UPS units but still want to shutdown/disconnect where possible.
I've used Raspberry PI's in the pass and had a number of corrupt SD cards due to just unplugging, so don't want to do that with the Ordroid
Thanks
Leigh
Thanks for the link subzero79
Reading through they "Experts" are still not sure but I can understand that spin down, parking heads can be stressful to a drive.
My main concern was in buying a NAS drive that designed to run 27/7 and spinning it down (Powered will be 24/7) was a bad thing.
Are Blue/Green drives designed to be spun down "more" that the red NAS ???
May just get RED's as they should be more robust and not spin them down
Leigh
Thinking about getting a couple of WD Red NAS 4TB drives, one going to be used on a X86 system which will be up 24/7 (Home office/Media Files)
The Second one will be a on a Odroid XU4 as a backup - This drive will be spun down most of the time as backups will be done once a day.
Question is, as the RED's are designed to be 24/7 drives, is it bad to keep spinning them down/up, if so should I get a desktop (Blue/Green) version instead.
Comments/Suggestions please
Leigh
As a newbie I thought I'd make this observation - Installed 3.0.63 image onto a Raspberry Pi 2 and then upgraded to 3.0.75.1
When adding a user in the webgui you see 4 fields - username, long name, email and password.
Now for a while I could not add a user, after filling in the details, selecting save did nothing - tried many times
The reason I could not add a user was due to the other fields of the "add user" window not being completed. 
I know there's a scroll bar at the side but I think it might be a idea to either increase the initial window to 5 lines so that the confirm password line can be seen or that the window automatically scrolls to the missing date required line.
In my case the confirm password was highlighted by a red boarder but is was hidden.
Obvious now but its a possible newbie trap
P.S. Also another observation - moving the mouse to the add users scroll bar (Right) around 25% on the left side the mouse pointer stays as a pointer but the rest of the scroll bar makes the pointer change to a resize cursor - Looks like the right hand edge resize area also covers 3/4 the scroll bar - I'm using Firefox Browser - Linux and Windows versions.
Maybe you guys know this already 
Leigh
