I haven t been able to find any guides specific to running F

Question

I haven t been able to find any guides specific to running Fleet in Unraid Seems like it would be pretty straight forward I m actually pretty new to using dockers and I ve only been using Unraid for a couple of months Here s my current docker setup Fleet is failing here `ts=2021 11 10T17 57 37 435547058Z mysql= could not connect to db dial tcp 127 0 0 1 3306 connect connection refused sleeping 14s ` `Failed to start initializing datastore dial tcp 127 0 0 1 3306 connect connection refused`

Zach Zeid · Answer

I should learn to read

Zach Zeid · Answer

doesn t look like your networking is squared away how are you defining the mysql database connection in fleet

Bryan · Answer

exactly slightly smiling face I m not sure how to define those settings

Bryan · Answer

`ts=2021 11 10T19 34 26 036154553Z mysql= could not connect to db Error 1045 Access denied for user fleet 172 17 0 1 using password NO sleeping 8s `

zwass · Answer

< Bryan> have you configured the mysql parameters

Bryan · Answer

making progress slightly smiling face where is this config stored

zwass · Answer

The top of that linked doc provides that information slightly smiling face

Bryan · Answer

I sent env variables in docker settings seems to take it when I dump config but the logs are still erroring out when I start the docker

zwass · Answer

Does that DB user need a password

Bryan · Answer

it s blank now but when the docker starts it s trying to connect to 172 17 0 1 fleet instead of 172 17 0 2 mysql

zwass · Answer

In this screenshot <https osquery slack com archives C01DXJL16D8 p1636574926105500 thread ts=1636570775 103300 amp cid=C01DXJL16D8> it looks like it s configured for the correct IP Do you still get an error about the other IP

Bryan · Answer

when I start the docker I get the errors highlighted in pink when I log into the console of the docker and run fleet config dump it shows the correct IP

Bryan · Answer

if I try running with CLI flags it s still trying to connect to the wrong host

zwass · Answer

172 17 0 3 is the IP of the server that is trying to initiate the connection so I don t think it s trying to connect to the wrong host You d be getting a different error like `could not connect to db dial tcp ` if it was trying to connect to a host where the MySQL server is not running

zwass · Answer

Can you try connecting via the MySQL CLI to ensure that the user has the appropriate permissions

zwass · Answer

<https www linuxcloudvps com blog how to fix access denied errors in mysql > might help

Bryan · Answer

Thank you < zwass> I slept on it and revisited the mysql permissions I had created the fleet user under localhost instead of 172 17 0 1 one step further now

Bryan · Answer

When I try to start the docker it fails immediately and I see this in the logs now I m not sure how to run the prepare db command

Bryan · Answer

I added fleet prepare db under Post Arguments I can t tell if it s running but the container doesn t stop now

Bryan · Answer

heart eyes

Martavis Parker · Answer

Awesome I was going ask what you were seeing slightly smiling face

Bryan · Answer

this is where I m currently at So looks like I need to set up my certs

zwass · Answer

Yep or you can terminate TLS with a load balancer or proxy and have Fleet just serve HTTP Either way works

Bryan · Answer

ok slightly smiling face getting closer but stuck again Is there an administration page for Fleet that s supposed to load at 8080 or do I need the separate UI docker for that

zwass · Answer

Yeah you should now have the dashboard on port 8080

Bryan · Answer

Woo Thanks Everyone for the help Looks like I may need to put together a guide for anyone else planning to use Unraid D

zwass · Answer

That would be awesome We d happily promote anything you put together on our socials slightly smiling face