ZoneMinder 1.36: setting up mount points

[fastzombies]

I had ZM working and needed to add mount points. The datapools are wide open with www owner and group. I moved the data and added the mount points. Now I get:

ZoneMinder Error​

Unable to connect to ZM db using dsn mysql:host=localhost;dbname=zm

SQLSTATE[HY000] [2002] No such file or directory

ZoneMinder will retry connection in 8 seconds.

My mount points are

My permissions look like

I would also like to mount the mysql db to an SSD pool but I docs and posts on that seem outdated, nothing matches what I see with 1.36. Any help is appreciated.

 

[fastzombies]

I uninstalled ZM and started over. This time I tried the following:

Source -> Destination
/mnt/zm-backup-pool/zoneminder/db-zm -> /mnt/home-ssd/iocage/jails/zoneminder/root/var/db/zoneminder

To do this I created the db-zm pool, gave it www owner and group. Then stop the ZM plugin and ssh into truenas console, then:

cd /mnt/zm-backup-pool/zoneminder/db-zm
mkdir events
mkdir images
chown www events
chown www images

cd /mnt/home-ssd/iocage/jails/zoneminder/root/var/db/zoneminder
rmdir events
rmdir images

Despite creating the pool with www:www the mkdir inherited root owner thus the chown. Now restart ZM plugin. So far it works. I would like to keep mysql stuff on an ssd pool mount point, but it is quite unclear where to do that. I'll experiment more another time.