SelfhostedPro / selfhosted_templates

Portainer templates for selfhosted services
GNU General Public License v3.0
1.24k stars 238 forks source link

[BUG] #169

Closed fhmbrg closed 4 years ago

fhmbrg commented 4 years ago

Describe the bug After deploying the stack I tried to open the Bookstack URL (192.168.143.30:6875, but all I get is an empty page.

To Reproduce Steps to reproduce the behavior:

  1. Name: Bookstack
  2. PUID: 1000
  3. PGID: 115
  4. TZ: Europe/Berlin
  5. DATABASE_PASSWORD: my_super_secret_db_pw
  6. MYSQL_ROOT_PASSWORD: my_super_secret_root_pw
  7. PORT: 6875
  8. Hit the "Deploy the stack" button

Expected behavior I expected to be able to open the URL 192.168.143.30:6875 and login with the default credentials (admin@admin.com / password)

Screenshots I think there is no need to put a screenshot of a blank/empty webpage in here ;-)

Portainer Logs (bookstack container) [s6-init] making user provided files available at /var/run/s6/etc...exited 0. [s6-init] ensuring user provided files have correct perms...exited 0. [fix-attrs.d] applying ownership & permissions fixes... [fix-attrs.d] done. [cont-init.d] executing container initialization scripts... [cont-init.d] 01-envfile: executing... [cont-init.d] 01-envfile: exited 0. [cont-init.d] 10-adduser: executing...


      _         ()
     | |  ___   _    __
     | | / __| | |  /  \ 
     | | \__ \ | | | () |
     |_| |___/ |_|  \__/

Brought to you by linuxserver.io


To support LSIO projects visit: https://www.linuxserver.io/donate/


GID/UID

User uid: 1000 User gid: 115


[cont-init.d] 10-adduser: exited 0. [cont-init.d] 20-config: executing... [cont-init.d] 20-config: exited 0. [cont-init.d] 30-keygen: executing... using keys found in /config/keys [cont-init.d] 30-keygen: exited 0. [cont-init.d] 50-config: executing... App Key found - setting variable for seds Running config - db_user set /var/run/s6/etc/cont-init.d/50-config: line 67: warning: command substitution: ignored null byte in input /var/run/s6/etc/cont-init.d/50-config: line 67: warning: command substitution: ignored null byte in input Illuminate\Database\QueryException : SQLSTATE[HY000] [1045] Access denied for user 'bookstack'@'bookstack.bookstack_default' (using password: NO) (SQL: select * from information_schema.tables where table_schema = bookstackapp and table_name = migrations and table_type = 'BASE TABLE') at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669 665| // If an exception occurs when attempting to run a query, we'll format the error 666| // message to include the bindings with SQL, which will make this exception a 667| // lot more helpful to the developer instead of just the database's errors. 668| catch (Exception $e) {

669| throw new QueryException( 670| $query, $this->prepareBindings($bindings), $e 671| ); 672| } 673|

Exception trace:

1 Doctrine\DBAL\Driver\PDOException::("SQLSTATE[HY000] [1045] Access denied for user 'bookstack'@'bookstack.bookstack_default' (using password: NO)") /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:31

2 PDOException::("SQLSTATE[HY000] [1045] Access denied for user 'bookstack'@'bookstack.bookstack_default' (using password: NO)") /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:27

Please use the argument -v to see more details.

[cont-init.d] 50-config: exited 0. cont-init.d] 99-custom-files: executing... [custom-init] no custom files found exiting... [cont-init.d] 99-custom-files: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done.

Portainer Logs (Bookstack_db container) [s6-init] making user provided files available at /var/run/s6/etc...exited 0. [s6-init] ensuring user provided files have correct perms...exited 0. [fix-attrs.d] applying ownership & permissions fixes... [fix-attrs.d] done. [cont-init.d] executing container initialization scripts... [cont-init.d] 01-envfile: executing... [cont-init.d] 01-envfile: exited 0. [cont-init.d] 10-adduser: executing...


      _         ()
     | |  ___   _    __
     | | / __| | |  /  \ 
     | | \__ \ | | | () |
     |_| |___/ |_|  \__/

Brought to you by linuxserver.io


To support LSIO projects visit: https://www.linuxserver.io/donate/

GID/UID

User uid: 1000 User gid: 115

[cont-init.d] 10-adduser: exited 0. [cont-init.d] 30-config: executing... [cont-init.d] 30-config: exited 0. [cont-init.d] 40-initialise-db: executing... [cont-init.d] 40-initialise-db: exited 0. [cont-init.d] 99-custom-scripts: executing... [custom-init] no custom files found exiting... [cont-init.d] 99-custom-scripts: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. 200724 16:56:58 mysqld_safe Logging to syslog. 200724 16:56:58 mysqld_safe Starting mysqld daemon with databases from /config/databases

fhmbrg commented 4 years ago

Problem solved!

Removed the containers and remaining Bookstack data from the host and reinstalled using different passwords. Maybe some of the characters of my initial passwords solved the problem.