Skip to content

Instantly share code, notes, and snippets.

@Taubin
Created January 20, 2022 23:55
Show Gist options
  • Save Taubin/9cddcb1789362daf6c83fb659bc9985b to your computer and use it in GitHub Desktop.
Save Taubin/9cddcb1789362daf6c83fb659bc9985b to your computer and use it in GitHub Desktop.
Unraid + Mariadb + Bookstack
docker run -d --name='bookstack' --net='proxynet' -e TZ="Pacific/Auckland" -e HOST_OS="Unraid" -e HOST_HOSTNAME="myhost" -e HOST_CONTAINERNAME="bookstack" -e 'APP_URL'='http://192.168.0.10:6875' -e 'DB_HOST'='mariadb' -e 'DB_USERNAME'='bookstack' -e 'DB_PASSWORD'='notmypass' -e 'DB_DATABASE'='bookstack_db' -e 'PUID'='99' -e 'PGID'='100' -e 'UMASK'='022' -l net.unraid.docker.managed=dockerman -l net.unraid.docker.webui='http://[IP]:[PORT:80]' -l net.unraid.docker.icon='https://raw.githubusercontent.com/linuxserver/docker-templates/master/linuxserver.io/img/bookstack-logo.png' -p '6875:80/tcp' -v '/mnt/user/appdata/bookstack':'/config':'rw' 'lscr.io/linuxserver/bookstack' 
[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: 99
User gid: 100
-------------------------------------

[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...
New container detected. Setting up app folder and fixing permissions.
App Key found - setting variable for seds
/var/run/s6/etc/cont-init.d/50-config: line 97: warning: command substitution: ignored null byte in input
/var/run/s6/etc/cont-init.d/50-config: line 97: warning: command substitution: ignored null byte in input

Illuminate\Database\QueryException

SQLSTATE[HY000] [1044] Access denied for user 'bookstack'@'%' to database 'bookstack_db' (SQL: select * from information_schema.tables where table_schema = bookstack_db and table_name = migrations and table_type = 'BASE TABLE')

at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:703
699▕ // If an exception occurs when attempting to run a query, we'll format the error
700▕ // message to include the bindings with SQL, which will make this exception a
701▕ // lot more helpful to the developer instead of just the database's errors.
702▕ catch (Exception $e) {
➜ 703▕ throw new QueryException(
704▕ $query, $this->prepareBindings($bindings), $e
705▕ );
706▕ }
707▕ }

+33 vendor frames
34 /var/www/html/artisan:37
Illuminate\Foundation\Console\Kernel::handle()
[cont-init.d] 50-config: exited 0.
[cont-init.d] 90-custom-folders: executing...
[cont-init.d] 90-custom-folders: 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.
docker run -d --name='mariadb' --net='proxynet' -e TZ="Pacific/Auckland" -e HOST_OS="Unraid" -e HOST_HOSTNAME="myhost" -e HOST_CONTAINERNAME="mariadb" -e 'MYSQL_ROOT_PASSWORD'='notmyrealrootpass' -e 'MYSQL_DATABASE'='bookstack_db' -e 'MYSQL_USER'='bookstack' -e 'MYSQL_PASSWORD'='notmypass' -e 'REMOTE_SQL'='http://URL1/your.sql,https://URL2/your.sql' -e 'PUID'='99' -e 'PGID'='100' -e 'UMASK'='022' -l net.unraid.docker.managed=dockerman -l net.unraid.docker.webui='http://[IP]:[PORT:3306]' -l net.unraid.docker.icon='https://raw.githubusercontent.com/linuxserver/docker-templates/master/linuxserver.io/img/mariadb-logo.png' -p '3306:3306/tcp' -v '/mnt/user/appdata/mariadb':'/config':'rw' 'lscr.io/linuxserver/mariadb' 
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment