Install Nextcloud 13.0.0 on Fedora 27

Donahue

@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:

Create the Nextcloud database and then secure the mariadb install.
Change ncuser, ncuserpassword, and somesecurepassword to something private.
#Create a database for nextcloud and a user to access it.
mysql -e "CREATE DATABASE nextcloud;"
mysql -e "CREATE USER 'ncuser'@'localhost' IDENTIFIED BY 'ncuserpassword';"
mysql -e "GRANT ALL ON nextcloud.* TO 'ncuser'@'localhost';"
mysql -e "FLUSH PRIVILEGES;"

#Secure mariadb. These commands do what mysql_secure_installation does interactively
mysql -e "UPDATE mysql.user SET Password=PASSWORD('somesecurepassword') WHERE User='root';"
mysql -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');"
mysql -e "DELETE FROM mysql.user WHERE User='';"
mysql -e "DROP DATABASE test;"
mysql -e "FLUSH PRIVILEGES;"

Doesn't this step set the mysql password, as somesecurepassword?

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

Test with the command line utility to ensure that MariaDB is set up properly before you try to test it with the actual app.

The CLI tool is called simply mysql
mysql nextcloud -uncadmin -p

if so, then it fails at this step

scottalanmiller

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

ncuserpassword

No, it sets it as...

ncuserpassword

scottalanmiller

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

somesecurepassword

Is what it sets for the root user, which you are not using any longer.

Donahue

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

ncuserpassword

No, it sets it as...

ncuserpassword

still fails. I try both nsuserpassword and somesecurepassword, and both fail

DustinB3403

@Donahue are you attempting to login as ncuser or ncuser@localhost with ncuserpassword as the password?

scottalanmiller

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

ncuserpassword

No, it sets it as...

ncuserpassword

still fails. I try both nsuserpassword and somesecurepassword, and both fail

Then that is the issue, basic username / password issues with the database. No issue with NextCloud yet, as NC has to use a working username / password to use the database. So make a new database user first, and test it, then when it works, then move on to configuring NC.

Donahue

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue are you attempting to login as ncuser or ncuser@localhost with ncuserpassword as the password?

ncuser

scottalanmiller

Jared's example is with ncuser. But you are trying to use ncadmin. Did you change Jared's script, or is that a typo?

Donahue

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

Jared's example is with ncuser. But you are trying to use ncadmin. Did you change Jared's script, or is that a typo?

I changed the script

DustinB3403

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue are you attempting to login as ncuser or ncuser@localhost with ncuserpassword as the password?

ncuser

Try the long-name.

scottalanmiller

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

Jared's example is with ncuser. But you are trying to use ncadmin. Did you change Jared's script, or is that a typo?

I changed the script

Then you need to consistently use the change. -uncuser not -uncadmin since ncuser doesn't exist in your system.

DustinB3403

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

Jared's example is with ncuser. But you are trying to use ncadmin. Did you change Jared's script, or is that a typo?

I changed the script

try the long-name as ncadmin@localhost

Donahue

no go. ncuser does not exist, I am just using here as a reference to that place in the script where I changed it (following the tutorial)

Donahue

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

Jared's example is with ncuser. But you are trying to use ncadmin. Did you change Jared's script, or is that a typo?

I changed the script

try the long-name as ncadmin@localhost

that doesnt work as far as I can tell.

DustinB3403

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

Jared's example is with ncuser. But you are trying to use ncadmin. Did you change Jared's script, or is that a typo?

I changed the script

try the long-name as ncadmin@localhost

that doesnt work as far as I can tell.

Directly from the CLI to login to the database? If it doesn't work then your database permissions may be messed up.

Donahue

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

Jared's example is with ncuser. But you are trying to use ncadmin. Did you change Jared's script, or is that a typo?

I changed the script

try the long-name as ncadmin@localhost

that doesnt work as far as I can tell.

Directly from the CLI to login to the database? If it doesn't work then your database permissions may be messed up.

correct. How do I reset it?

DustinB3403

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

Jared's example is with ncuser. But you are trying to use ncadmin. Did you change Jared's script, or is that a typo?

I changed the script

try the long-name as ncadmin@localhost

that doesnt work as far as I can tell.

Directly from the CLI to login to the database? If it doesn't work then your database permissions may be messed up.

correct. How do I reset it?

Paging @scottalanmiller would it be better to check (and write) the permissions on mysql here or to create a new DB?

DustinB3403

@Donahue run

mysql
SHOW GRANTS FOR 'user'@'locahost';

If your user isn't listed as having any access then you need to give that user access. If they have access, then something else is messed up.

Donahue

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue run

mysql
SHOW GRANTS FOR 'user'@'locahost';

If your user isn't listed as having any access then you need to give that user access. If they have access, then something else is messed up.

that shows my user in there with all privileges.

scottalanmiller

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

no go. ncuser does not exist, I am just using here as a reference to that place in the script where I changed it (following the tutorial)

Can you log in as the root user?