DietPi-Software | AUTO_Global_Password= not being used as MySQL login password for SQL DB generation #666

Closed
LexiconCode opened this Issue Dec 26, 2016 · 5 comments

Projects

None yet

2 participants

@LexiconCode
LexiconCode commented Dec 26, 2016 edited

When installing Nextcloud via dietpi.txt utilizing the global password setting causes a bug. When viewing the web interface for the first time with Nextcloud where you would use admin and the global password Nextcloud asks for the database to be set up. This should already be done and is not included in the instructions on dietpi.com to do so.
I followed the instructions using a password for the global password that excludes the following characters "$

An example of the password I used
45nau@55q3J%44^ayr6#354hyt5n^oy2.Nnim^ByZhy

Backend: Nginx
Device: Odroid XU4

@Fourdee
Owner
Fourdee commented Dec 26, 2016 edited

@LexiconCode

Thanks for report 👍, i'll take a look

Linked for reference: #647 (comment)

45nau@55q3J%44^ayr6#354hyt5n^oy2.Nnim^ByZhy

I think some of these may be breaking the string sent to command line and sql DB generation func (https://github.com/Fourdee/DietPi/blob/master/dietpi/func/create_mysql_db#L34), and/or, we need to string $DATABASE_PW lemme test.

@Fourdee Fourdee added this to the v141 milestone Dec 26, 2016
@Fourdee Fourdee added the bug label Dec 28, 2016
@Fourdee
Owner
Fourdee commented Dec 28, 2016 edited

@LexiconCode

Turns out, this effects all programs with SQL DB generation, when a custom password is used. Lets gets this fixed.

@Fourdee Fourdee added a commit that referenced this issue Dec 28, 2016
@Fourdee v141
+ Use global_pw for MySQL root pw, when creating MySQL DB's:
#666
7a15c90
@Fourdee Fourdee changed the title from DietPi-Software | Nextcloud requires database set up when using dietpi.txt global password to DietPi-Software | AUTO_Global_Password= not being applied as root password for SQL DB generation Dec 28, 2016
@Fourdee Fourdee changed the title from DietPi-Software | AUTO_Global_Password= not being applied as root password for SQL DB generation to DietPi-Software | AUTO_Global_Password= not being used as MySQL login password for SQL DB generation Dec 28, 2016
@Fourdee
Owner
Fourdee commented Dec 28, 2016

Tested with password provided by @LexiconCode:

  • 🈯️
root@DietPi:~# cat /DietPi/dietpi.txt | grep Global
#Global Password to be applied for the system
AUTO_Global_Password=45nau@55q3J%44^ayr6#354hyt5n^oy2.Nnim^ByZhy
dietpi-software install 114
[Info] Creating MySql DB for nextcloud

 [Ok] Create database nextcloud | Completed

Nextcloud is not installed - only a limited number of commands are available
Nextcloud was successfully installed

Completed. Fixed for v141.

@Fourdee Fourdee closed this Dec 28, 2016
@LexiconCode

Originally what password was being used? or did the DB Set up fail?

@Fourdee
Owner
Fourdee commented Dec 28, 2016 edited

@LexiconCode

Originally what password was being used? or did the DB Set up fail?

DB creation was set to use dietpi as the MySQL root account, instead of AUTO_Global_Password=. Which was incorrect.

@Fourdee Fourdee referenced this issue Dec 31, 2016
Merged

v141 #682

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment