Error installing Nextcloud with MariaDB

[DMills]

I'm trying to install Nextcloud and use MariaDB with it, but have hit an issue. I have linuxserver's MariaDB container installed and running fine. I'm trying to install and configure the nextcloud nextcloud container, but when I set everything up on the first page of the WebUI and click Finish setup, after a few seconds I get this error:

 

Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No route to host

 

I have confirmed the address and port are exactly what is being reported by the MariaDB container, which is also the IP of the Unraid server, so I'm not sure why I thinks there is no route to host. Any ideas? Let me know if you need any configs or logs or whatever.

[trurl]

Are you following the SpaceInvader One video?

 

[DMills]

5 minutes ago, trurl said:

Are you following the SpaceInvader One video?

 

Yes, I tried that one already, it actually timed out with a 504 error I might just go back to that one and try again.

[RedZephon]

I am having the same issue. At first I was trying a different guide and experienced the same issue as DMills, then I tried following the video above but when I get to the bash it says my password is incorrect even though its not.

[alturismo]

in case u have NC on a custom network and mariadb on host, did u enable the feature in docker settings so they can reach each other ?

and also allowed ip range for nextcloud user ...

[DMills]

I actually hadn't got to the LetsEncrypt/Reverse Proxy video before stopping due to this issue, so they were both on the host network. I'm going to wipe everything and try again from scratch. I know it's something I am doing wrong or forgetting to do, but it's also sometimes confusing when the videos are made on older versions of Unraid as well as the containers, some things just don't match or make sense anymore. But without the videos I'd be just floundering around in the dark, so I am still very thankful for them!

[rojarrolla]

Hi, I'm having something similar.

 

The problem happens when installing Mariadb, It is like there is no software available to download.

 

I get this info:

 

 

I have glass dhcp installed and I kind of think that I have installed it for that docker, but it does not appear on my dockers:

 

 

Could it be because the array is running?

 

I am attaching a copy of my diagnostics file.

 

Thanks!

 

 

Update July 18th 2020

 

It turned out that my ethernet settings had only my router as DNS server, there is nothing wrong to have your router (or gateway) acting as your DNS, however in this case the IP addresses were not being resolved.

 

I had to stop the array  and then changed the NIC settings adding some DNS servers (ie. 8.8.8.8) and now it is working.

 

C' ya!

 

 

tower-diagnostics-20200716-0917.zip

Edited July 19, 2020 by rojarrolla
Solution found

[AceRimmer]

On 6/3/2020 at 7:13 AM, alturismo said:

in case u have NC on a custom network and mariadb on host, did u enable the feature in docker settings so they can reach each other ?

and also allowed ip range for nextcloud user ...

That has been driving me around the bend for weeks. Thank you!

[matt-uk]

@DMills did you ever sort this?

[DMills]

On 3/13/2022 at 10:29 PM, matt-uk said:

@DMills did you ever sort this?

For that specific version of Nextcloud no, but using a more recent version did let me get past the errors I was encountering before.

[Barnoe]

I realised early on that Spaceinvaders video doesn't use the official Nextcloud or MariaDB apps which is different to setup.
the differences are slight, but enough to make things difficult.
Spaceinvaders version doesnt include.

in MariaDB settings
To clear the random password generator

to drop down and show more setting to add your root password
in the setting you can create your database name and password

 

this means you have no need for the console commands SpaceInvader does.

He also doesn't explain you need to stop your array while you edit the setting.... dockers (advanced view)..... Host access to custom networks:  ENABLE

 

Once you do that above your off and running

 

Now no offence to Space Invader one, his tutorials are brilliant and we all thank him for them.

but in this case the temptation people have when they see OFFICIAL on an app sends them on a different path when following his videos

[DMills]

Just tried again to install Nextcloud on my new server, no matter whether I choose, MariaDB or Sqlite, I get the dreaded 504 timeout error every time. I'm officially giving up on Nextcloud.

[guruleenyc]

For any of my peers banging their head against the wall with this error during install: "nextcloud MySQL username and/or password not valid" , following these steps resolved the issue for me:

https://www.thesmarthomebook.com/2022/12/03/unraid-set-up-nextcloud-with-mariadb/

[sonic_reaction]

I had the same issue. For me I couldn't have the user called "nextcloud" which was the same name as the database. I changed it to "nextcloud_user" and it worked.

[SomeUNRAIDguy]

On 12/21/2022 at 3:27 PM, sonic_reaction said:

I had the same issue. For me I couldn't have the user called "nextcloud" which was the same name as the database. I changed it to "nextcloud_user" and it worked.

OMG yes. Thank you

[mavec]

I was able to fix this error by changing "localhost:3306" to the actual IP address of the server on my network. So for me it was "192.168.1.11:3306"