@dlandon thank you for your prompt reply. i did follow the guide. Created the 99-.conf file but i kept getting an error saying it cant connect to mariadb
I created a linuxserver/mariadb to connect to it.
The question was more about do i have to create a separate network and use network_mode: network etc..
I just cant get it to work.
reason i want to try an external db, it's because i'm having problems with the internal db. First run it runs fine. Then overnight it crashes and cant connect. Did a bit of reading and I believe i tracked it to adding TZ in the docker as well as ensuring it's aligned in options>settings.
That seemed to fix it. But now i have another problem:
Aug 6 15:31:28 UNRAID web_php[2319]: ERR [SQL-ERR 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DESC limit 20' at line 1', statement was 'SELECT `Id`, `MonitorId`, `Name`, `Cause`, `Notes`, `StartTime`, date_format( StartTime, '%y/%m/%d %H:%i:%S' ) as StartTimeShort, `EndTime`, `Width`, `Height`, `Length`, `Frames`, `AlarmFrames`, `TotScore`, `AvgScore`, `MaxScore` FROM Events WHERE Events.MonitorId = :selector0 ORDER BY DESC limit 20' params:1]
Aug 6 15:31:28 UNRAID web_php[2319]: ERR [SQL-ERR dbFetchAll no result, statement was 'SELECT `Id`, `MonitorId`, `Name`, `Cause`, `Notes`, `StartTime`, date_format( StartTime, '%y/%m/%d %H:%i:%S' ) as StartTimeShort, `EndTime`, `Width`, `Height`, `Length`, `Frames`, `AlarmFrames`, `TotScore`, `AvgScore`, `MaxScore` FROM Events WHERE Events.MonitorId = :selector0 ORDER BY DESC limit 20'params: 1]
So when I open a monitor i cant see the events list under it. if i click on the events (number) it will take me to events and i can see it.
Not sure what's creating all that, but wanted to try external db.
I also tried running your .master image. Got it running, no apparent db problems, but couldnt define motion zones as i cant see them in the brower. it shows a blank screen.
Any guidance/suggestions are appreciated.