MKII

sudo apt install snapd
sudo snap install lxd
#make pool

geek@bast:~$ sudo zfs create tank/vm
geek@bast:~$ sudo zfs create tank/vm/lxd

#make storage volume for mssql

sudo zfs create -s -V 20G -o volblocksize=4k tank/vm/disks/bitwardendb
sudo mkfs.ext4 /dev/zvol/tank/vm/disks/bitwardendb
#init lxd
lxd init

#output of lxd init. Make sure its been sucessfully configured - ya, the last two lines were garbled.

Do you want to configure a new storage pool (yes/no) [default=yes]?
Name of the new storage pool [default=default]:
Name of the storage backend to use (dir, btrfs, ceph, lvm, zfs) [default=zfs]:
Create a new ZFS pool (yes/no) [default=yes]? no
Name of the existing ZFS pool or dataset: tank/vm/lxd
Would you like LXD to be available over the network (yes/no) [default=no]?
Would you like stale cached images to be updated automatically (yes/no) [default=yes]?
Would you like to create a new network bridge (yes/no) [default=yes]?
What should the new bridge be called [default=lxdbr0]?
What IPv4 address should be used (CIDR subnet notation, âautoânoneâ
                                                                   What IPv6 address should be used (CIDR subnet notation, âautoânoneâ
                                                                                                                                      LXD has been successfully configured.

#make container:run container
lxc launch ubuntu:x bitwarden
#Get information on bitwarden

lxc config show containername
Get hostid from volatile.last_state.idmap
#set permissions for storage volume - ugh
#On host
sudo mkdir /mnt/tmp
sudo mount  /dev/zvol/tank/vm/disks/bitwardendb  /mnt/tmp
chown -R 1000000:1000000 /mnt/tmp/
#add the storage volume to the VM
sudo lxc config device add bitwarden bitwardendb disk path=/var/opt/mssql source=/dev/zvol/tank/vm/disks/bitwardendb

lxc exec bitwarden bash

#mssql install - cause bleh, this is hard and 99% of the difficulty is due to this bloody thing.
apt update, apt upgrade (needed new gnutls for reasons)
install SQL Server as per https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu