Install Nextcloud 13.0.0 on Fedora 27

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

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:

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

I didnt run that, I followed 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 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

I didnt run that, I followed the script.

hrm, yeah just looking. @JaredBusch is there a reason to not run mysql_secure_installation ?

Donahue

ok, I think I got the root password changed and the ncuser password changed. wish me luck

Donahue

nope. F it, I am going to just start over.

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

I didnt run that, I followed the script.

hrm, yeah just looking. @JaredBusch is there a reason to not run mysql_secure_installation ?

Because that is what those mysql -e commands do.

DustinB3403

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

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

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

I didnt run that, I followed the script.

hrm, yeah just looking. @JaredBusch is there a reason to not run mysql_secure_installation ?

Because that is what those mysql -e commands do.

Ah never knew that.

scottalanmiller

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

Yup, that's a general rule.

Donahue

@scottalanmiller 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?
Yup, that's a general rule.

where is this the general rule? Linux? databases?

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:
@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?
Yup, that's a general rule.
where is this the general rule? Linux? databases?

Anytime you are scripting passwords, automating passwords, or using passwords in systems you don't know exactly how everything between the keyboard and the final system are going to interpret special codes.

JaredBusch

@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:
@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?
Yup, that's a general rule.
where is this the general rule? Linux? databases?

I believe it was actually a requirement in the past. but no longer. I'd have to go search to find when they updated it.

Donahue

TIL, use simple passwords.