EDIT: Ignore below. The issue was related to my stored release of freebsd having the wrong permissions set in the /tmp directory.
----
Has something gone awry with Nextcloud and freenas? I've tried using both the plugin and the script linked above for Nextcloud 15 and I keep hitting this error when trying to connect to the mysql database
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2 "No such file or directory")
same error when typing "mysql" from within the jail
trying to start mysql-server leads to a long pause and it doesn't appear to start.
output of nextcloud.err:
Code:
190131 22:06:47 mysqld_safe mysqld from pid file /var/db/mysql/nextcloud.pid ended
190131 22:15:36 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2019-01-31 22:15:36 34420645888 [Warning] option 'table_open_cache': unsigned value 4 adjusted to 10
2019-01-31 22:15:36 34420645888 [Warning] option 'table_open_cache': unsigned value 4 adjusted to 10
2019-01-31 22:15:36 34420645888 [Note] /usr/local/libexec/mysqld (mysqld 10.1.37-MariaDB) starting as process 60693 ...
2019-01-31 22:15:36 34420645888 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small b$
2019-01-31 22:15:36 34420645888 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-01-31 22:15:36 34420645888 [Note] InnoDB: The InnoDB memory heap is disabled
2019-01-31 22:15:36 34420645888 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-31 22:15:36 34420645888 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-01-31 22:15:36 34420645888 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-01-31 22:15:36 34420645888 [Note] InnoDB: Using SSE crc32 instructions
2019-01-31 22:15:36 34420645888 [ERROR] mysqld: Can't create/write to file '/tmp/ibEk7z1j' (Errcode: 13 "Permission denied")
2019-01-31 22:15:36 803a16000 InnoDB: Error: unable to create temporary file; errno: 13
2019-01-31 22:15:36 34420645888 [ERROR] Plugin 'InnoDB' init function returned error.
2019-01-31 22:15:36 34420645888 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-01-31 22:15:36 34420645888 [Note] Plugin 'FEEDBACK' is disabled.
2019-01-31 22:15:36 34420645888 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-01-31 22:15:36 34420645888 [ERROR] Aborting
/tmp permissions are 777