I'm trying to get nextcloud working as per the instructions provided here, but I'm running into an issue when trying to configure nextcloud for the first time through its webgui. Specifically, I put in the details of my MariaDB, however I get an error (taken from MariaDB logs)
2016-08-31 10:27:44 47012320705280 [Warning] IP address '172.17.42.1' could not be resolved: Name or service not known
2016-08-31 10:27:44 47012320705280 [Warning] Access denied for user 'root'@'172.17.42.1' (using password: YES)
which is strange considering that's not the ip address of my db, it should be 192.168.1.107:3306 (which is what I entered in the database host field). As far as I can tell my MariaDB docker is configured correctly, as I've made sure:
1. Installed MariaDB from linuxserver repo
2. Enabled binary logging
3. Provided a MYSQL_ROOT_PASSWORD
Any help with this would be greatly appreciated.
* Edit below *
Solved this problem after doing some reading up on MariaDB (noob here). Thought I'd post the solution in case someone else runs into the same problem.
From the Unraid command line entered the MariaDB container:
docker exec -it mariadb bash
Login (it should prompt you for root's password)
mysql -p
Since nextcloud (for whatever reason) was trying to connect from 172.17.42.1, I created a user from this host. I called the user nextcloud
CREATE USER 'nextcloud'@'172.17.42.1' IDENTIFIED BY 'password';
Grant the nextcloud user privileges equivalent to root
GRANT ALL PRIVILEGES ON *.* TO 'nextcloud'@'172.17.42.1' WITH GRANT OPTION;
Then all I had to do was change the username and password in the nextcloud gui and voila! it connected and created the nextcloud db.