create-dockerfile.sh

docker create \
  --name=lychee \
  -v ~/.config/lychee/conf:/conf \
  -v ~/lychee-uploads:/uploads \
  -v ~/.config/lychee/sym:/sym \
  -v ~/Pictures:/imagelib \
  -e PUID=1000 \
  -e PGID=1000 \
  -e PHP_TZ=Europe/Berlin \
  -e DB_CONNECTION=mysql \
  -e DB_HOST=127.0.0.1 \
  -e DB_PORT=3306 \
  -e DB_DATABASE=lychee \
  -e DB_USERNAME=lychee \
  -e DB_PASSWORD=lychee_pw \
  -p 90:80 \
  --network=host \
  lycheeorg/lychee:v4.0.6

run-output

λ ~/ docker start -i lychee

-------------------------------------
  _               _                
 | |   _   _  ___| |__   ___  ___  
 | |  | | | |/ __|  _ \ / _ \/ _ \ 
 | |__| |_| | (__| | | |  __/  __/ 
 |_____\__, |\___|_| |_|\___|\___| 
 | |   |___/ _ __ __ ___   _____| |
 | |   / _' | '__/ _' \ \ / / _ \ |
 | |__| (_| | | | (_| |\ V /  __/ |
 |_____\__,_|_|  \__,_| \_/ \___|_|

-------------------------------------
Lychee Version: 4.0.6 (release)
Lychee Commit:  0e3289c
https://github.com/LycheeOrg/Lychee/commit/0e3289c295f731030d999c76c807619b0e1886d9
-------------------------------------
**** Make sure the /conf and /uploads folders exist ****
**** Create the symbolic link for the /uploads folder ****
**** Create the symbolic link for the /sym folder ****
**** Create the symbolic link to the old Lychee-Laravel folder ****
**** Copy the .env to /conf ****
**** Inject .env values ****
**** Generate the key (to make sure that cookies cannot be decrypted etc) ****
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > Command Canceled!
**** Migrate the database ****
Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table (0.06 seconds)
Migrating: 2018_08_03_110935_create_albums_table
Migrated:  2018_08_03_110935_create_albums_table (0.22 seconds)
Migrating: 2018_08_03_110936_create_photos_table
Migrated:  2018_08_03_110936_create_photos_table (0.23 seconds)
Migrating: 2018_08_03_110942_create_configs_table
Migrated:  2018_08_03_110942_create_configs_table (0.04 seconds)
Migrating: 2018_08_03_111324_create_logs_table
Migrated:  2018_08_03_111324_create_logs_table (0.03 seconds)
Migrating: 2018_08_10_134924_move_settings
Migrated:  2018_08_10_134924_move_settings (0.01 seconds)
Migrating: 2018_08_15_102039_move_albums
Migrated:  2018_08_15_102039_move_albums (0.01 seconds)
Migrating: 2018_08_15_103716_move_photos
Migrated:  2018_08_15_103716_move_photos (0.01 seconds)
Migrating: 2018_10_30_135411_sharing
Migrated:  2018_10_30_135411_sharing (0.38 seconds)
Migrating: 2019_02_21_114356_create_pages_table
Migrated:  2019_02_21_114356_create_pages_table (0.04 seconds)
Migrating: 2019_02_21_114408_create_page_contents_table
Migrated:  2019_02_21_114408_create_page_contents_table (0.18 seconds)
Migrating: 2019_06_21_180451_create_sym_links_table
Migrated:  2019_06_21_180451_create_sym_links_table (0.03 seconds)
Migrating: 2019_09_28_171753_config_fix
Migrated:  2019_09_28_171753_config_fix (0.9 seconds)
Migrating: 2019_09_28_190822_photos_fix

In AbstractMySQLDriver.php line 106:
                                                                               
  An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_  
  TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS  
   `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME A  
  S CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS  
   WHERE TABLE_SCHEMA = 'lychee' AND TABLE_NAME = 'photos' ORDER BY ORDINAL_P  
  OSITION ASC':                                                                
                                                                               
  SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_307  
  _0.MAI' (Errcode: 13 "Permission denied")                                    
                                                                               

In PDOConnection.php line 83:
                                                                               
  SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_307  
  _0.MAI' (Errcode: 13 "Permission denied")                                    
                                                                               

In PDOConnection.php line 78:
                                                                               
  SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_307  
  _0.MAI' (Errcode: 13 "Permission denied")                                    
                                                                               

**** Create user and use PUID/PGID ****
 	User UID :	1000
 	User GID :	1000
**** Set Permissions ****
**** Setup complete, starting the server. ****