Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Failed to create MariaDb database aborting #204

Open
bolegmailru opened this issue Jul 15, 2023 · 4 comments
Open

Failed to create MariaDb database aborting #204

bolegmailru opened this issue Jul 15, 2023 · 4 comments
Labels
question Further information is requested

Comments

@bolegmailru
Copy link

Failed to create MariaDb database aborting(

@raffskid
Copy link

raffskid commented Feb 19, 2024

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
Copy link
Owner

danb35 commented Feb 20, 2024

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

@danb35 danb35 added the question Further information is requested label Feb 29, 2024
@MoritzSchrenk
Copy link

MoritzSchrenk commented Jun 5, 2024

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
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

4 participants