[How-To] ownCloud using NGINX, PHP-FPM, and MySQL

[Joshua Parker Ruehlig]

Thank you sir, I'll try that right now...

I kept going and I'm stuck on the last 3 steps, I don't see where those options are on the 'Frondend" tab....

View attachment 9091 View attachment 9092

EDIT +++++++++++++++++++++++++++++++++++++

So there is a "Template" tab, that had the the frontend and bacnend temapltes for Startcom SSL...so I used that and i can see those options, however after selecting the Created CAs, i get the following errors...

Errors found while starting haproxy
[ALERT] 297/205335 (98765) : parsing [/var/etc/haproxy_test/haproxy.cfg:10] : 'bind 73.237.25.197:443' : unable to load SSL private key from PEM file '/var/etc/haproxy_test/HAProxy_stats_ssl_frontend.pem'.
[ALERT] 297/205335 (98765) : Error(s) found in configuration file : /var/etc/haproxy_test/haproxy.cfg
[ALERT] 297/205335 (98765) : Proxy 'HAProxy_stats_ssl_frontend': no SSL certificate specified for bind '73.237.25.197:443' at [/var/etc/haproxy_test/haproxy.cfg:10] (use 'crt').
[ALERT] 297/205335 (98765) : Fatal errors found in configuration.

Any help, or guide where to start looking would be appreciated

Here's the bottom of my frontend tab

 

[Maturola]

Here's the bottom of my frontend tab

Thank you, I tried everything and I cannot saved the changes.

It seen to be an issue with binding the public IP with port 443. If I remove port 443 from the frontend it let me saved the changes.

I think I'm just going to give up on HAproxy and try to configure the SSL at Owncloud ...

 

[Joshua Parker Ruehlig]

Thank you, I tried everything and I cannot saved the changes.

It seen to be an issue with binding the public IP with port 443. If I remove port 443 from the frontend it let me saved the changes.

I think I'm just going to give up on HAproxy and try to configure the SSL at Owncloud ...

is pfsense running on 443? 'sockstat | grep 443' would show if something else is binding to that socket.

 

[Maturola]

is pfsense running on 443? 'sockstat | grep 443' would show if something else is binding to that socket.

I don't think it is, but it is possible. I'll check

 

[Maturola]

I checked, pfsense was running on 443, however i still get same error even after changing the port for webconfigurator =(

 

[Joshua Parker Ruehlig]

I checked, pfsense was running on 443, however i still get same error even after changing the port for webconfigurator =(

did you check sockstat on pfsense?

if you still want to get this working you could ask on the pfsense forum, the dev for the HAProxy plugin (PiBa) is very resposive.

 

[Maturola]

did you check sockstat on pfsense?

if you still want to get this working you could ask on the pfsense forum, the dev for the HAProxy plugin (PiBa) is very resposive.

Yes, I ran Sockstat, nothing comes back for 443 ..

I think its something wrong with the SSL, most likely a "operators" error. .... no big deal i'll try configuring it on owncloud itself see if that works .

Thanks

 

[Joshua Parker Ruehlig]

Yes, I ran Sockstat, nothing comes back for 443 ..

I think its something wrong with the SSL, most likely a "operators" error. .... no big deal i'll try configuring it on owncloud itself see if that works .

Thanks

no prob, yeah it's tricky to get the certs setup right. goodluck.

 

[Maturola]

no prob, yeah it's tricky to get the certs setup right. goodluck.

Yeah, No matter what port i put in there, it give me same error. Not its not related to the actual port number

 

[Joshua Parker Ruehlig]

I wonder if it's because you didn't check the (SSL Offloading) on the frontend tab. noticed mine is checked.

 

[Maturola]

I wonder if it's because you didn't check the (SSL Offloading) on the frontend tab. noticed mine is checked.

That's why i didn't have those additional options, once check those other options appears (the OCSP and Advanced SSl options), but it doesn't let me save it

 

[Maturola]

is this what your CAs looks like?

 

[Joshua Parker Ruehlig]

is this what your CAs looks like?

View attachment 9109

yeah. I also noticed a "recalculate certificate" button on haproxys main page. might be needed to link the CA and your cert.

 

[Maturola]

ownCloud WebUI (http://jailip/owncloud)
Advanced

• Data folder = /mnt/files
• Configure the database = MySQL/MariaDB
• Database user = ocuser
• Database password = ocpass
• Database name = owncloud
• Database host = localhost:/tmp/mysql.sock

Console in jail's userland

Show : Replace the relevant lines in /usr/local/www/owncloud/config/config.php

Code:

'memcache.local' => '\OC\Memcache\APCu',

So back to the real theme of the threat........

I followed the step by step and I'm stuck on this section the WebUI of owncloud, it seen like it is still running Sqlite3.

After all the steps, when i went to the webui - http://<Jail IP>/owncloud all it asked me was to setup my user name and password and no "advanced' option anywhere.

what am I missing?

 

[Joshua Parker Ruehlig]

So back to the real theme of the threat........

I followed the step by step and I'm stuck on this section the WebUI of owncloud, it seen like it is still running Sqlite3.

After all the steps, when i went to the webui - http://<Jail IP>/owncloud all it asked me was to setup my user name and password and no "advanced' option anywhere.

what am I missing?

did you already enter those in? if so then it already set things up with sqlite.

there should be a small arrow that you press and gives you the advanced options below the username/password. including the dstadirectory and database info.

here's a random picture I found showing the setup screen

https://www.howtoforge.com/images/owncloud_5.0_nginx_debian_wheezy_ubuntu_13.10/1.png

 

[Maturola]

did you already enter those in? if so then it already set things up with sqlite.

there should be a small arrow that you press and gives you the advanced options below the username/password. including the dstadirectory and database info.

No, this was a brand new jail, and first time ever I went to the wedUI...for some reason it seen like it was already there. Not idea =( I;m having such a bad luck with all this setup

 

[Joshua Parker Ruehlig]

No, this was a brand new jail, and first time ever I went to the wedUI...for some reason it seen like it was already there. Not idea =( I;m having such a bad luck with all this setup

what was already there? if you already passed this step you can just run the below and do it again

Code:

rm -r /usr/local/www/owncloud/data/* /usr/local/www/owncloud/config/config.php

 

[Maturola]

what was already there? if you already passed this step you can just run the below and do it again

Code:

rm -r /usr/local/www/owncloud/data/* /usr/local/www/owncloud/config/config.php

ok let me try that...

 

[Maturola]

what was already there? if you already passed this step you can just run the below and do it again

Code:

rm -r /usr/local/www/owncloud/data/* /usr/local/www/owncloud/config/config.php

Ok that allow me move one step forward...however i;m getting the follwing error once i click "Finish Setup"

Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] Can't assign requested address

 

[Joshua Parker Ruehlig]

Ok that allow me move one step forward...however i;m getting the follwing error once i click "Finish Setup"

Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] Can't assign requested address

others have reported a similar issue with OC8.2. I believe it's a bug with the database host parsing. try using "localhost"