photo / frontend

The official @github repository of the Trovebox frontend software. A photo sharing and photo management web interface for data stored "in the cloud" (i.e. Amazon S3, Rackspace CloudFiles, Google Storage).
https://trovebox.com
Apache License 2.0
1.37k stars 244 forks source link

Fixes broken installation script/Trovebox UI Setup issue which preven… #1577

Closed russmac closed 3 years ago

russmac commented 9 years ago

…ted installation/setup

The current sciprt does not touch the DB. The UI setup fails, As it attempts to access a user table while at the same time instructing you to create a blank DB. https://github.com/photo/frontend/issues/1572 The SQL is taken from https://github.com/photo/frontend/blob/master/src/configs/upgrade/db/mysql/mysql-base.php#L294-L303. The script will give you 3 chances to get your password right before providing instructions and SQL to the user on how to manually resolve the db schema issue once they have the password.

russmac commented 9 years ago

To confirm, I tested all conditions The worst possible outcome, You get reprompted for password twice because you chose a database that already exists (the error wont be squashed so you can see this) The instructions on failure also refer to this.

jmathai commented 9 years ago

Thanks for the PR. Would like to know why this is happening in the first place. One issue I noticed is that the user might select a prefix for the db tables and the setup script doesn't account for that. I left a comment on #1577.