Owncloud raspberry pi cloud server help

[Agena_]

https://pimylifeup.com/raspberry-pi-owncloud/

 

Hi, im using this tutorial to create a owncloud server on my raspberry pi 3+

 

The last step is to login to owncloud, i did that. Wrote everything correctly. 

 

 

For the databse host i tried 'localhost' and '127.0.0.1'. still same error on top

 

If i do 'localhost: 0000' (with my port number) it gives a different error 'Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory'

 

Can somebody help please?

[Agena_]

i then found this random code line online about a issue

mysql:localhost;dbname=AppDatabase

and it says  i have a error in my SQL syntax.  line 10 in the image. I have no clue what this means and how to fix it. Anybody know?

[steelo]

9 minutes ago, Agena_ said:

i then found this random code line online about a issue

mysql:localhost;dbname=AppDatabase

and it says  i have a error in my SQL syntax.  line 10 in the image. I have no clue what this means and how to fix it. Anybody know?

I'm not an expert in this area, but aren't you supposed to replace 'localhost' with the servers ip and AppDatabase with the db name? I could be way off here, but that's my guess.

[Master Disaster]

Always stick to using 127.0.0.1 over localhost, these should be totally interchangeable however Linux likes to assume localhost will be a socket connection and if you don't have a socket configured it will fail, using 127.0.0.1 will ensure it connects.

 

You likely messed something up on the permissions or misspelled a name somewhere. I strongly advise installing PHPMyAdmin for a nice GUI management interface, it makes configuring mySQL/MariaDB MUCH easier.

 

Heres a live demo - https://demo.phpmyadmin.net/master-config/

 

Are the webserver and DB server both running on the Ras Pi? If not then you'll need to change the hostname variable for the user account to 192.168.% to allow external connections (obvs change it to 10.0.% if that's what you're using).

 

Edit - also its 127.0.0.1:3306 and not 127.0.0.1: 3306 as the screenshot implies, that must be a typo in OwnCloud.