Install Nextcloud 13.0.0 on Fedora 27

JaredBusch

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:
mysql -e "UPDATE mysql.user SET Password=PASSWORD('vX41YtG&Z*^!I*DWVdv$D2k!') WHERE User='root';"

That is you changing the mysql root password. Well setting actually.

Donahue

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

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

care to elaborate?

DustinB3403

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

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

care to elaborate?

It didn't take the password.

JaredBusch

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"

This is you using an invalid character in a mysql password.

Donahue

@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:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.

what is the invalid character?

JaredBusch

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@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:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.
what is the invalid character?

The $ in a bash command with double quotes

DustinB3403

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@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:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.
what is the invalid character?

@JaredBusch is probably looking it up, but only numbers and letters are allowed here from what I can find.

JaredBusch

@DustinB3403 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 said in Install Nextcloud 13.0.0 on Fedora 27:
@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.
what is the invalid character?
@JaredBusch is probably looking it up, but only numbers and letters are allowed here from what I can find.

They can be complex, but you have risks of them being misinterpreted. Like bash reading it as a variable.

Donahue

@JaredBusch 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:
@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:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.
what is the invalid character?
@JaredBusch is probably looking it up, but only numbers and letters are allowed here from what I can find.
They can be complex, but you have risks of them being misinterpreted. Like bash reading it as a variable.

so stick with letters and numbers?

Donahue

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@JaredBusch 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:
@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:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.
what is the invalid character?
@JaredBusch is probably looking it up, but only numbers and letters are allowed here from what I can find.
They can be complex, but you have risks of them being misinterpreted. Like bash reading it as a variable.
so stick with letters and numbers?

Should I just start over? or can I overwrite these with new passwords?

JaredBusch

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@JaredBusch 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:
@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:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.
what is the invalid character?
@JaredBusch is probably looking it up, but only numbers and letters are allowed here from what I can find.
They can be complex, but you have risks of them being misinterpreted. Like bash reading it as a variable.
so stick with letters and numbers?

Pretty much always.

JaredBusch

@Donahue 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:
@DustinB3403 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 said in Install Nextcloud 13.0.0 on Fedora 27:
@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.
what is the invalid character?
@JaredBusch is probably looking it up, but only numbers and letters are allowed here from what I can find.
They can be complex, but you have risks of them being misinterpreted. Like bash reading it as a variable.
so stick with letters and numbers?
Should I just start over? or can I overwrite these with new passwords?

Your root password took, or so you stated.

So just update the ncuser password as @scottalanmiller noted.

Donahue

@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue 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:
@DustinB3403 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 said in Install Nextcloud 13.0.0 on Fedora 27:
@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.
what is the invalid character?
@JaredBusch is probably looking it up, but only numbers and letters are allowed here from what I can find.
They can be complex, but you have risks of them being misinterpreted. Like bash reading it as a variable.
so stick with letters and numbers?
Should I just start over? or can I overwrite these with new passwords?
Your root password took, or so you stated.

So just update the ncuser password as @scottalanmiller noted.

I dont think the root password took either, I think I misunderstood earlier.

black3dynamite

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@JaredBusch 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:
@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:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.
what is the invalid character?
@JaredBusch is probably looking it up, but only numbers and letters are allowed here from what I can find.
They can be complex, but you have risks of them being misinterpreted. Like bash reading it as a variable.
so stick with letters and numbers?

Use a password generator like https://passwordsgenerator.net/ and uncheck Include Symbols: .

Donahue

Yeah, I am using my password generator, I just didnt turn off symbols.

DustinB3403

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:
@Donahue 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:
@DustinB3403 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 said in Install Nextcloud 13.0.0 on Fedora 27:
@JaredBusch said in Install Nextcloud 13.0.0 on Fedora 27:
mysql -e "CREATE USER 'ncadmin'@'localhost' IDENTIFIED BY 'N@2$#sx67UkIZ^$xsInW0&7Z';"
This is you using an invalid character in a mysql password.
what is the invalid character?
@JaredBusch is probably looking it up, but only numbers and letters are allowed here from what I can find.
They can be complex, but you have risks of them being misinterpreted. Like bash reading it as a variable.
so stick with letters and numbers?
Should I just start over? or can I overwrite these with new passwords?
Your root password took, or so you stated.

So just update the ncuser password as @scottalanmiller noted.
I dont think the root password took either, I think I misunderstood earlier.

Well you said you can run mysql -u root -p and get logged into the mysql interface. . . so that would mean your ROOT password took.

Donahue

Does this show root? I just left the password blank.

DustinB3403

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

Does this show root? I just left the password blank.

So you didn't set a root password at all if where it says "Enter password:" you just tapped enter and were logged in.

That should be updated to be secured with a password.

Donahue

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue said in Install Nextcloud 13.0.0 on Fedora 27:

Does this show root? I just left the password blank.

So you didn't set a root password at all if where it says "Enter password:" you just tapped enter and were logged in.

That should be updated to be secured with a password.

correct. that makes me think it didnt take the password earlier, because of bad 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:

Does this show root? I just left the password blank.

So you didn't set a root password at all if where it says "Enter password:" you just tapped enter and were logged in.

That should be updated to be secured with a password.

correct. that makes me think it didnt take the password earlier, because of bad characters.

You would've set the password when you ran mysql_secure_installation