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

[garyjg]

Thanks...

 

[Joshua Parker Ruehlig]

Thanks...

so using "localhost" worked for me after a try or two. So i suggest you try that.

I'll definitely file a bug though, because owncloud 8.2 broke being able to specify anything but php's default file socket during the setup step.

 

[garyjg]

funny, I'm getting the same error:
Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: hostname nor servname provided, or not known

 

[garyjg]

Thanks Joshua,

This morning it seems to be working... strange, I only re-booted the server.

Thanks

 

[Joshua Parker Ruehlig]

Thanks Joshua,

This morning it seems to be working... strange, I only re-booted the server.

Thanks

glad you got it working. hopefully this can get cleared up and work consistently. here's the bug I posted
https://github.com/owncloud/core/issues/20210

 

[tamilmad]

"pkg install libreoffice4-4.3.7" should work, at least it does for me.

Thanks. It worked

 

[tamilmad]

1) I'm not sure why libreoffice isn't in the repo at the moment, I can confirm that it's not there for FreeBSD 9.3, but is there for my FreeBSD 10.1 server. You can always build it from ports if you like or find the package from another repo.

2) if you logged in, you missed the stop where you can put in the advanced settings.
Do this https://forums.freenas.org/index.ph...x-php-fpm-and-mysql.17786/page-35#post-237766

Thanks for your prompt reply. I followed the instructions and was able to setup everything. I had earlier included my domain in the config.php for access from the internet, which I had to do again.

Alternatively, I could have directly updated the config.php file itself with the dbname, db folder, user, password etc.,

Thanks once again for your hard work.

 

[Joshua Parker Ruehlig]

Thanks for your prompt reply. I followed the instructions and was able to setup everything. I had earlier included my domain in the config.php for access from the internet, which I had to do again.

Alternatively, I could have directly updated the config.php file itself with the dbname, db folder, user, password etc.,

Thanks once again for your hard work.

you can't just update your config.php to migrate from sqlite to mysql, theres a migration script you could have used though if you really needed to.

 

[tamilmad]

you can't just update your config.php to migrate from sqlite to mysql, theres a migration script you could have used though if you really needed to.

Good that I followed your instructions and not my thoughts. Thanks.

 

[Joshua Parker Ruehlig]

Good that I followed your instructions and not my thoughts. Thanks.

welcome. glad you got it all working

 

[garyjg]

hi Joshua, well it happen again... same msg after i logged out and tried logging back in.

 

[Joshua Parker Ruehlig]

hi Joshua, well it happen again... same msg after i logged out and tried logging back in.

what do you have in your config for database host? to help get this fixed please post on the github bug I linked too.

and why did you link to my profile?

 

[garyjg]

First of all I didn't realize that I linked to your profile... sorry about that.
I'm using owncloud for a database host

 

[garyjg]

sorry, I meant local as a database host as you said before

 

[garyjg]

this is the same error has before (Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'ocuser'@'localhost' (using password: YES))

 

[Joshua Parker Ruehlig]

this is the same error has before (Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'ocuser'@'localhost' (using password: YES))

maybe change your config.php database host value to "localhost:/tmp/mysql.sock"

 

[garyjg]

ok, I've tried that but I'm still getting the same error (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, I've tried that but I'm still getting the same error (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)

oh, I thought you already got past the admin setup part. using "localhost" is the workaround. if that doesn't work please contribute to the bug report I created. that is a better place to post to get this bug fixed than this thread.

 

[garyjg]

ok... thanks, I contribute to your bug report tonight.

 

[garyjg]

Hi Joshua,

when I ran owncloud/robots.txt it gave me back this? any clue what that means? thanks

User-agent: *
Disallow: /