Connecting to remote Database

[skillspec (Beshel Ikwen)]

Hi Guys, I hope everyone is doing great today? This is my second day of trying my hands on Nextcloud, so far so good. However, I want to use my system in production hence I don’t want to have a single sever installation.
I have decided to do this simple architecture:

Haproxy - Load balancer

Application & Web servers

Databases - MYSQL

I have been able to install the MYSQL database for a master master replication and its working fine.
I have installed the Nextcloud but where I am stock is how to tell nextcloud that I am using an external database and where to configure the parameters to allow installation wizard pick up the database. I would appreciate any help I can get.

Thanks

[mrmarkuz (Markus Neuberger)]

Hi @skillspec,

did you install Nextcloud via Software Center? You may edit /usr/share/nextcloud/config/config.php to set db host and credentials, see Nextcloud docs.

Do you use Nethservers for your haproxy mysql replication scenario?

[alefattorini (Alessio Fattorini)]

Ehi Beshel welcome here! Did you try @mrmarkuz’s input? Any news?
Did you check this yet?

Sync multiple Nextcloud remote servers (master-master)

Hi, I’d appreciate some ideas on how to keep 2 remote Nextcloud servers in sync to build up a poor man’s HighAvailability. Mainly to sync Nexcloud files (2-way nearly-real-time sync), but calendar and contacts (thus the database) might step-in in the future. Scenario: A reserved domain name A couple road users (they can be either at Workplace, at Home or at another remote location) 2 remote servers (different hardware) ##Workplace neth1: one NethServer (LDAP, Nextcloud, etc.) shared folder…

[skillspec (Beshel Ikwen)]

I have been away and had very limited access to the internet hence I couldn’t reply.

This is the manual I used to build my nextcloud

Complete NC Installation on Debian 9 Stretch and manual update

However, I skipped the database part since I have already installed and clustered the MYSQL database.

I believe that since the database cluster is working very well the next step in my lap work is to install just one server of the nextcloud then connect to any of the database.
Once that is achieve then the next step which is pretty simple to to build a second nextlcoud server and cluster it using HAproxy.
At the moment when I run this command to finish the installation

sudo -u www-data php occ maintenance:install --database “mysql” --database-name “nextcloud” --database-user “nextcloud” --database-pass “YOURdbPASSWORD” --admin-user “ncadmin” --admin-pass “YOURadminPASSWORD”

its failing

[mrmarkuz (Markus Neuberger)]

Sorry, I don’t get where NethServer is in your scenario…with NethServer you are able to just install Nextcloud from Software Center, no need to setup manually.

Do you use Nethservers for your haproxy mysql replication scenario?

sudo -u www-data

On NethServer apache user is used instead of www-data so this may be the reason the command is not working. Do you get error messages on screen or in /var/log/messages?

What is the equivalent for 'www-data' for CentOs?

[skillspec (Beshel Ikwen)]

yes I got error message that looks like that