Install Nextcloud 13.0.0 on Fedora 27

DustinB3403

I think this is the correct syntax.

ALTER USER 'user'@'hostname' IDENTIFIED BY 'newPass';

scottalanmiller

Format...

UPDATE mysql.user SET Password=PASSWORD(‘text password’) WHERE user=”ncadmin” AND Host=”localhost”;

DustinB3403

@Donahue did you just take what @JaredBusch wrote and keyed in each line one by one? If so human error could have gotten you.

If you scripted it I don't see how you could be using the incorrect password.

Donahue

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue did you just take what @JaredBusch wrote and keyed in each line one by one? If so human error could have gotten you.

If you scripted it I don't see how you could be using the incorrect password.

I just copied and pasted the whole blocks, only changing ncuser, ncuserpassword, and somesecurepassword

DustinB3403

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue did you just take what @JaredBusch wrote and keyed in each line one by one? If so human error could have gotten you.

If you scripted it I don't see how you could be using the incorrect password.

I just copied and pasted the whole blocks, only changing ncuser, ncuserpassword, and somesecurepassword

Print the history from the machine and see if you are actually using the correct password.

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 did you just take what @JaredBusch wrote and keyed in each line one by one? If so human error could have gotten you.

If you scripted it I don't see how you could be using the incorrect password.

I just copied and pasted the whole blocks, only changing ncuser, ncuserpassword, and somesecurepassword

Print the history from the machine and see if you are actually using the correct password.

how do I do that? I cant see back that far. I am using powershell to connect

Donahue

@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 did you just take what @JaredBusch wrote and keyed in each line one by one? If so human error could have gotten you.

If you scripted it I don't see how you could be using the incorrect password.

I just copied and pasted the whole blocks, only changing ncuser, ncuserpassword, and somesecurepassword

Print the history from the machine and see if you are actually using the correct password.

how do I do that? I cant see back that far. I am using powershell to connect

could it be my password is too long, or uses special characters?

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 did you just take what @JaredBusch wrote and keyed in each line one by one? If so human error could have gotten you.

If you scripted it I don't see how you could be using the incorrect password.

I just copied and pasted the whole blocks, only changing ncuser, ncuserpassword, and somesecurepassword

Print the history from the machine and see if you are actually using the correct password.

how do I do that? I cant see back that far. I am using powershell to connect

Have you disconnected? If not just type "history"

DustinB3403

@Donahue 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:

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue did you just take what @JaredBusch wrote and keyed in each line one by one? If so human error could have gotten you.

If you scripted it I don't see how you could be using the incorrect password.

I just copied and pasted the whole blocks, only changing ncuser, ncuserpassword, and somesecurepassword

Print the history from the machine and see if you are actually using the correct password.

how do I do that? I cant see back that far. I am using powershell to connect

could it be my password is too long, or uses special characters?

Doubtful.

JaredBusch

@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 did you just take what @JaredBusch wrote and keyed in each line one by one? If so human error could have gotten you.

If you scripted it I don't see how you could be using the incorrect password.

I just copied and pasted the whole blocks, only changing ncuser, ncuserpassword, and somesecurepassword

Print the history from the machine and see if you are actually using the correct password.

Yup, scroll back (up arrow) or ctrl+R to search your history and see what you actually did.

My money is on bad character in password.

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:

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue did you just take what @JaredBusch wrote and keyed in each line one by one? If so human error could have gotten you.

If you scripted it I don't see how you could be using the incorrect password.

I just copied and pasted the whole blocks, only changing ncuser, ncuserpassword, and somesecurepassword

Print the history from the machine and see if you are actually using the correct password.

how do I do that? I cant see back that far. I am using powershell to connect

Have you disconnected? If not just type "history"

I already closed it, before you said it the first time.

JaredBusch

@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:

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue did you just take what @JaredBusch wrote and keyed in each line one by one? If so human error could have gotten you.

If you scripted it I don't see how you could be using the incorrect password.

I just copied and pasted the whole blocks, only changing ncuser, ncuserpassword, and somesecurepassword

Print the history from the machine and see if you are actually using the correct password.

how do I do that? I cant see back that far. I am using powershell to connect

Have you disconnected? If not just type "history"

I already closed it, before you said it the first time.

You can still hit up arrow and ctrl+r

Donahue

I still have the block text that I pasted in that has the password that was set initially, its not a bad password

JaredBusch

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

I still have the block text that I pasted in that has the password that was set initially, its not a bad password

Want to bet?

Donahue

@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

I still have the block text that I pasted in that has the password that was set initially, its not a bad password

Want to bet?

This is what I pasted in. Maybe I made a mistake somewhere?

#Create a database for nextcloud and a user to access it.
mysql -e "CREATE DATABASE nextcloud;"
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
mysql -e "GRANT ALL ON nextcloud.* TO 'ncadmin'@'localhost';"
mysql -e "FLUSH PRIVILEGES;"

#Secure mariadb. These commands do what mysql_secure_installation does interactively
mysql -e "UPDATE mysql.user SET Password=PASSWORD('vX41YtG&Z*^!I*DWVdv$D2k!') 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;"

JaredBusch

@Donahue Yup. bad password. Hell you are lucky your root password took.

Donahue

@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue Yup. bad password. Hell you are lucky your root password took.

I am not sure I actually changed the root on mysql, I might just have the root on fedora

JaredBusch

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue Yup. bad password. Hell you are lucky your root password took.

I am not sure I actually changed the root on mysql, I might just have the root on fedora

....................

Donahue

what did I do wrong? I still dont see the issue?

DustinB3403

@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue Yup. bad password. Hell you are lucky your root password took.

I am not sure I actually changed the root on mysql, I might just have the root on fedora

....................

The one password that matters wasn't changed.