FreeBSD, Unable to complete Nexcloud install, Nexcloud error while trying to create admin user

Hi everyone,

I am exploring FreeBSD because I would like to use it for hosting Nextcloud. I would like to use FreeBSD instead of Linux because I don’t fully trust ZFS on Linux. After going through a number of how-tos I was able to get Nextcloud up on a Fedora 31 VM. I also managed to install Nextcloud a FreeBSD 12 VM by installing apache, mysql and php https://www.digitalocean.com/community/tutorials/how-to-install-an-apache-mysql-and-php-famp-stack-on-freebsd-12-0 and then just pkg install nexcloud. I am currently able to get to the nextcloud setup page by going to http://localhost/nextcloud. I am not able to complete the installation, however because I receive the following error:

Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2054] The server requested authentication method unkown to the client.

I found some threads on the nextcloud forum that recommend using 127.0.0.1:3007 or :3006 but that did not get me any further.

What am I missing here? Is this a permissions issue for php? Can anyone please help?

Did you setup a database account (& database) for nextcloud? Did you configure nextcloud to use that database & account?

Hi @candybar, sorry for the late response. I did setup a database and a database account but I am not able to get nextcloud to use that database with that account. That is were the configuration process fails.