Failed to create MariaDb database aborting

[bolegmailru]

Failed to create MariaDb database aborting(

[raffskid]

Having the same issue. Here's what happens before it errors out. Let me know if you need the entire log file.

• iocage exec nextcloud chmod 777 /var/run/redis/redis.sock
• [ '' '==' true ]
• [ mariadb '=' mariadb ]
• iocage exec nextcloud mysql -u root -e 'CREATE DATABASE nextcloud;' jexec: execvp: mysql: No such file or directory Command: mysql -e CREATE DATABASE nextcloud; failed!
• echo 'Failed to create MariaDB database, aborting' Failed to create MariaDB database, aborting
• exit 1

[danb35]

I'm going to need a lot more information to have any idea what's going on. To name a few:

• Which version of TrueNAS are you using?
• Contents of your nextcloud-config file (be sure to redact any API keys)
• Any prior errors in the installation log (if you ran it using script nextcloud.log ./nextcloud-jail.sh as recommended, this would be saved in nextcloud.log; otherwise check your scrollback buffer). My suspicion is that mysql failed to install, and if that happened, you should see errors not too long after these lines:

• [ mariadb '=' mariadb ]
• iocage exec nextcloud pkg install -y mariadb106-server php82-pdo_mysql php82-mysqli

[MoritzSchrenk]

Not sure why you never got a response, but I just hit the same error. I don't see any signs of anything failing before then - the pkg install seems to have gone just fine.

• Version: TrueNAS-13.0-U6.1

nextcloud-config

 JAIL_IP="192.168.1.203"
 DEFAULT_GW_IP="192.168.1.1"
 POOL_PATH="/mnt/chanzelia/documents"
 TIME_ZONE="Europe/London"
 HOST_NAME="nextcloud.mydomain.com"
 STANDALONE_CERT=1
 CERT_EMAIL="<myemail>"
 COUNTRY_CODE="GBR

Here's what I'm seeing in the log

   + Starting services OK
   + Executing poststart OK
 + iocage exec nextcloud pw usermod www -G redis
 + iocage exec nextcloud chmod 777 /var/run/redis/redis.sock.
 + [ '' '==' true ]
 + [ mariadb '=' mariadb ]
 + iocage exec nextcloud mysql -u root -e 'CREATE DATABASE nextcloud;'
 ERROR 2002 (HY000): Can't connect to local server through socket '/var/run/mysq>
 Command: mysql -e CREATE DATABASE nextcloud; failed!
 + echo 'Failed to create MariaDB database, aborting'
 Failed to create MariaDB database, aborting
 + exit 1

There does not appear to be a file/dir called /var/run/mysq (or mysql)

[MoritzSchrenk]

My mistake - I messed up the capitalisation of my pool name. Installation went fine now.