![]() ![]() UPDATE: So I thought I fixed it, but it looks like it just stopped reporting, again… exact same error as above (minus date/time), so I’ll try to remove the custom UI code in the next few days to see if that helps. Looking into how to remove this as I think it’s unnecessary due to Lovelace, but haven’t figured out how to specifically remove it yet. ![]() It seems like this one is related to CustomUI. Any ideas what’s going on with my instance? It basically makes the logbook useless as it stops updating after a period of time and the graphs become static.Įrror executing query: (_mysql_exceptions.DataError) (1406, “Data too long for column ‘event_data’ at row 1”) (Background on this error at: ) I’m researching what I can, but don’t know enough about MySQL yet to know how to fix. However, it appears to only work for me for a few moments and then the graphs go static and I start seeing various errors in my logs. It connected immediately upon reboot and performance was significantly better. jar from the ssh client but i think i should first make the jar file executable and i still didnt figure it out. Was experiencing issues with the native recorder performance in Docker on Synology, so followed this guide to spin up a MySQL container. for a Synology NAS DS118 i want to run a jar file and im looking for a way to hibernate the program on the synology so that it executes automatically, can anyone help i have tried to run the. I have some useful mysql commands in my HA cheatsheet that you may find useful. Add the following to the config (where 192.168.2.113 is the IP address of my NAS):ĭb_url: mysql://hass: /homeassistant?charset=utf8.Run, the command and make sure that the container is up and running.ĭocker run -net=host -restart=always -name mysql -d -v /volume1/docker/mysql/data:/var/lib/mysql -e 'DB_USER=hass' -e 'DB_PASS=12345' -e 'DB_NAME=homeassistant' sameersbn/mysql:latest Make sure that the folder /volume1/docker/mysql/data exists (create one, if it does not).After you login as admin, you may have to run sudo su if you keep getting permission errors. SSH into Synology NAS and pull the image using docker pull sameersbn/mysql:latest.After lot of failed attempts, I was finally able to setup MySQL in a Docker container on my NAS (thanks to Here are the steps that I followed (I am sure these steps should work on other hardware, but YMMV): I just started with Docker on my Synology NAS and quickly realized the value of Docker. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |