frappe-mariadb.yaml

config:
  cloud-init.user-data: |
    #cloud-config
    apt:
      sources:
        yarn:
          source: "deb https://dl.yarnpkg.com/debian/ stable main"
          keyid: 23E7166788B63E1E

    # Update apt database on first boot (run 'apt-get update').
    # Note, if packages are given, or package_upgrade is true, then
    # update will be done independent of this setting.
    # Default: false
    package_update: true

    # Upgrade the instance on first boot
    # Default: false
    package_upgrade: true

    # Install additional packages on first boot
    # Default: none
    # if packages are specified, then package_update will be set to true
    # packages may be supplied as a single package name or as a list
    # with the format [<package>, <version>] wherein the specific
    # package version will be installed.
    packages:
     - git 
     - tmux
     - htop
     - nload
     - iotop
     - ripgrep
     - python3-dev
     - python3-pip
     - python3-venv
     - redis-server
     - nodejs
     - yarn
     - xvfb
     - libfontconfig
     - wkhtmltopdf
     - curl
     - systemd-cron
     - mariadb-server
     - mariadb-client
    write_files:
      - path: /etc/mysql/conf.d/frappe.conf
        owner: root:root
        permission: 0o644
        defer: true
        content: |
          [mysqld]
          character-set-client-handshake = FALSE
          character-set-server = utf8mb4
          collation-server = utf8mb4_unicode_ci
          [mysql]
          default-character-set = utf8mb4
    users:
      - name: frappe
        shell: /bin/bash
        sudo: ALL=(ALL) NOPASSWD:ALL
    runcmd:
      - [ pip3, install, frappe-bench, --break-system-packages ]
      - [ cd, /home/frappe ]
      - [ bench, init, frappe-bench, --version, version-15 ] 
      - [ chown, -R, frappe:frappe, /home/frappe ]

description: "Frappe MariaDB"
devices: 
  eth0:
    name: eth0
    network: incusbr0
    type: nic
  root:
    path: /
    pool: default
    type: disk
  home:
    path: /home
    source: home-disk
    pool: zfspool
    type: disk
  mariadb:
    path: /var/lib/mysql
    source: mariadb-disk
    pool: zfspool
    type: disk
name: frappe-mariadb
used_by: []
project: default