@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 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;"

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

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

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

@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

@scottalanmiller said in Install Nextcloud 13.0.0 on Fedora 27:

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

yes

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

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

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)

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

@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

@DustinB3403 said in Install Nextcloud 13.0.0 on Fedora 27:

@Donahue without having gone through this process myself, but based on the guide you changed the database credentials.

Not the login credentials.

Attempt the default username and password.

I have used both the ncuserpassword and the somesecurepassword, but all combinations did not work.

I am attempting to follow this to install nextcloud 15 on fedora 29. I get to the step where I change the db to mariadb, but it doesnt seem to want to let me. earlier in the process, I changed ncuser and ncuserpassword, but I cant get it to take them. Any suggestions?

If i do this, does gemequipment.com still resolve to the external site?

I am aware of this, I want it to be internal only for the time being, but still use the domain files.gemequipment.com