lanager icon indicating copy to clipboard operation
lanager copied to clipboard
verified publisher icon zeropingheroes

[Bug] DB initialisation fails after last update

Open 0xmex opened this issue 1 year ago • 0 comments

Docker image information

[root@monkey lanager-docker-compose]# docker images zeropingheroes/lanager
REPOSITORY               TAG       IMAGE ID       CREATED        SIZE
zeropingheroes/lanager   stable    dc7f2484bf51   4 months ago   198MB
[root@monkey lanager-docker-compose]#

[root@monkey lanager-docker-compose]# docker ps --filter name=lanager
CONTAINER ID   IMAGE                           COMMAND                  CREATED          STATUS                    PORTS                                       NAMES
4086981dccab   mcuadros/ofelia:latest          "/usr/bin/ofelia dae…"   17 minutes ago   Up 17 minutes                                                         lanager-scheduler
fdb7eb189c47   zeropingheroes/lanager:stable   "/usr/bin/supervisor…"   17 minutes ago   Up 17 minutes (healthy)   0.0.0.0:8080->8080/tcp, :::8080->8080/tcp   lanager
924384879afc   mysql:8                         "docker-entrypoint.s…"   17 minutes ago   Up 17 minutes                                                         lanager-db
[root@monkey lanager-docker-compose]#

Bug description After setting up LANager via Portainer I tried to set up the database with the script. This causes the db/command to fail. This also occurs when the commands are sent manually (with the lanager docker name of course). In my .env file both CACHE entries are standard like this:

CACHE_STORE=file
CACHE_PREFIX=

MEMCACHED_HOST=127.0.0.1

docker exec -it lanager php artisan migrate:fresh --force

[2025-01-08 12:11:45] production.ERROR: Please provide a valid cache path. {"exception":"[object] (InvalidArgumentException(code: 0): Please provide a valid cache path. at /var/www/lanager/vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:67)
[stacktrace]
#0 /var/www/lanager/vendor/laravel/framework/src/Illuminate/View/ViewServiceProvider.php(97): Illuminate\\View\\Compilers\\Compiler->__construct()
#1 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(931): Illuminate\\View\\ViewServiceProvider->Illuminate\\View\\{closure}()
#2 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(815): Illuminate\\Container\\Container->build()
#3 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1046): Illuminate\\Container\\Container->resolve()
#4 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(751): Illuminate\\Foundation\\Application->resolve()
#5 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1028): Illuminate\\Container\\Container->make()
#6 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(1570): Illuminate\\Foundation\\Application->make()
#7 /var/www/lanager/vendor/graham-campbell/markdown/src/MarkdownServiceProvider.php(136): Illuminate\\Container\\Container->offsetGet()
#8 /var/www/lanager/vendor/graham-campbell/markdown/src/MarkdownServiceProvider.php(53): GrahamCampbell\\Markdown\\MarkdownServiceProvider->enableBladeDirective()
#9 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): GrahamCampbell\\Markdown\\MarkdownServiceProvider->boot()
#10 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#12 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#13 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()
#14 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1119): Illuminate\\Container\\Container->call()
#15 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1100): Illuminate\\Foundation\\Application->bootProvider()
#16 [internal function]: Illuminate\\Foundation\\Application->Illuminate\\Foundation\\{closure}()
#17 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1099): array_walk()
#18 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\\Foundation\\Application->boot()
#19 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(316): Illuminate\\Foundation\\Bootstrap\\BootProviders->bootstrap()
#20 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(473): Illuminate\\Foundation\\Application->bootstrapWith()
#21 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(195): Illuminate\\Foundation\\Console\\Kernel->bootstrap()
#22 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()
#23 /var/www/lanager/artisan(13): Illuminate\\Foundation\\Application->handleCommand()
#24 {main}
"}

   InvalidArgumentException

  Please provide a valid cache path.

  at vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:67
     63▕         $shouldCache = true,
     64▕         $compiledExtension = 'php')
     65▕     {
     66▕         if (! $cachePath) {
  ➜  67▕             throw new InvalidArgumentException('Please provide a valid cache path.');
     68▕         }
     69▕
     70▕         $this->files = $files;
     71▕         $this->cachePath = $cachePath;

      +16 vendor frames

  17  [internal]:0
      Illuminate\Foundation\Application::Illuminate\Foundation\{closure}()
      +6 vendor frames

  24  artisan:13
      Illuminate\Foundation\Application::handleCommand()

docker exec -it lanager php artisan db:seed --force --class=Database\\Seeders\\DatabaseSeeder

[2025-01-08 12:17:48] production.ERROR: Please provide a valid cache path. {"exception":"[object] (InvalidArgumentException(code: 0): Please provide a valid cache path. at /var/www/lanager/vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:67)
[stacktrace]
#0 /var/www/lanager/vendor/laravel/framework/src/Illuminate/View/ViewServiceProvider.php(97): Illuminate\\View\\Compilers\\Compiler->__construct()
#1 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(931): Illuminate\\View\\ViewServiceProvider->Illuminate\\View\\{closure}()
#2 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(815): Illuminate\\Container\\Container->build()
#3 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1046): Illuminate\\Container\\Container->resolve()
#4 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(751): Illuminate\\Foundation\\Application->resolve()
#5 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1028): Illuminate\\Container\\Container->make()
#6 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(1570): Illuminate\\Foundation\\Application->make()
#7 /var/www/lanager/vendor/graham-campbell/markdown/src/MarkdownServiceProvider.php(136): Illuminate\\Container\\Container->offsetGet()
#8 /var/www/lanager/vendor/graham-campbell/markdown/src/MarkdownServiceProvider.php(53): GrahamCampbell\\Markdown\\MarkdownServiceProvider->enableBladeDirective()
#9 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): GrahamCampbell\\Markdown\\MarkdownServiceProvider->boot()
#10 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#12 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#13 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()
#14 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1119): Illuminate\\Container\\Container->call()
#15 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1100): Illuminate\\Foundation\\Application->bootProvider()
#16 [internal function]: Illuminate\\Foundation\\Application->Illuminate\\Foundation\\{closure}()
#17 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1099): array_walk()
#18 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\\Foundation\\Application->boot()
#19 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(316): Illuminate\\Foundation\\Bootstrap\\BootProviders->bootstrap()
#20 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(473): Illuminate\\Foundation\\Application->bootstrapWith()
#21 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(195): Illuminate\\Foundation\\Console\\Kernel->bootstrap()
#22 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()
#23 /var/www/lanager/artisan(13): Illuminate\\Foundation\\Application->handleCommand()
#24 {main}
"}

   InvalidArgumentException

  Please provide a valid cache path.

  at vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:67
     63▕         $shouldCache = true,
     64▕         $compiledExtension = 'php')
     65▕     {
     66▕         if (! $cachePath) {
  ➜  67▕             throw new InvalidArgumentException('Please provide a valid cache path.');
     68▕         }
     69▕
     70▕         $this->files = $files;
     71▕         $this->cachePath = $cachePath;

      +16 vendor frames

  17  [internal]:0
      Illuminate\Foundation\Application::Illuminate\Foundation\{closure}()
      +6 vendor frames

  24  artisan:13
      Illuminate\Foundation\Application::handleCommand()

docker exec -it lanager php artisan lanager:import-steam-apps-csv

[2025-01-08 12:18:03] production.ERROR: Please provide a valid cache path. {"exception":"[object] (InvalidArgumentException(code: 0): Please provide a valid cache path. at /var/www/lanager/vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:67)
[stacktrace]
#0 /var/www/lanager/vendor/laravel/framework/src/Illuminate/View/ViewServiceProvider.php(97): Illuminate\\View\\Compilers\\Compiler->__construct()
#1 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(931): Illuminate\\View\\ViewServiceProvider->Illuminate\\View\\{closure}()
#2 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(815): Illuminate\\Container\\Container->build()
#3 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1046): Illuminate\\Container\\Container->resolve()
#4 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(751): Illuminate\\Foundation\\Application->resolve()
#5 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1028): Illuminate\\Container\\Container->make()
#6 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(1570): Illuminate\\Foundation\\Application->make()
#7 /var/www/lanager/vendor/graham-campbell/markdown/src/MarkdownServiceProvider.php(136): Illuminate\\Container\\Container->offsetGet()
#8 /var/www/lanager/vendor/graham-campbell/markdown/src/MarkdownServiceProvider.php(53): GrahamCampbell\\Markdown\\MarkdownServiceProvider->enableBladeDirective()
#9 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): GrahamCampbell\\Markdown\\MarkdownServiceProvider->boot()
#10 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#12 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#13 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()
#14 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1119): Illuminate\\Container\\Container->call()
#15 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1100): Illuminate\\Foundation\\Application->bootProvider()
#16 [internal function]: Illuminate\\Foundation\\Application->Illuminate\\Foundation\\{closure}()
#17 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1099): array_walk()
#18 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\\Foundation\\Application->boot()
#19 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(316): Illuminate\\Foundation\\Bootstrap\\BootProviders->bootstrap()
#20 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(473): Illuminate\\Foundation\\Application->bootstrapWith()
#21 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(195): Illuminate\\Foundation\\Console\\Kernel->bootstrap()
#22 /var/www/lanager/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()
#23 /var/www/lanager/artisan(13): Illuminate\\Foundation\\Application->handleCommand()
#24 {main}
"}

   InvalidArgumentException

  Please provide a valid cache path.

  at vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:67
     63▕         $shouldCache = true,
     64▕         $compiledExtension = 'php')
     65▕     {
     66▕         if (! $cachePath) {
  ➜  67▕             throw new InvalidArgumentException('Please provide a valid cache path.');
     68▕         }
     69▕
     70▕         $this->files = $files;
     71▕         $this->cachePath = $cachePath;

      +16 vendor frames

  17  [internal]:0
      Illuminate\Foundation\Application::Illuminate\Foundation\{closure}()
      +6 vendor frames

  24  artisan:13
      Illuminate\Foundation\Application::handleCommand()

Folder structure is like this after docker container start:

[root@monkey db-data]# ls -lah
total 110M
drwxr-xr-x. 8 systemd-coredump root  4.0K Jan  8 12:25  .
drwxr-xr-x. 3 root             root  4.0K Jan  8 12:25  ..
-rw-r-----. 1 systemd-coredump input 1.9K Jan  8 12:25  4c2fb4f50a7d.err
-rw-r-----. 1 systemd-coredump input   56 Jan  8 12:25  auto.cnf
-rw-r-----. 1 systemd-coredump input 2.9M Jan  8 12:25  binlog.000001
-rw-r-----. 1 systemd-coredump input  158 Jan  8 12:25  binlog.000002
-rw-r-----. 1 systemd-coredump input   32 Jan  8 12:25  binlog.index
-rw-------. 1 systemd-coredump input 1.7K Jan  8 12:25  ca-key.pem
-rw-r--r--. 1 systemd-coredump input 1.1K Jan  8 12:25  ca.pem
-rw-r--r--. 1 systemd-coredump input 1.1K Jan  8 12:25  client-cert.pem
-rw-------. 1 systemd-coredump input 1.7K Jan  8 12:25  client-key.pem
-rw-r-----. 1 systemd-coredump input 6.0M Jan  8 12:27 '#ib_16384_0.dblwr'
-rw-r-----. 1 systemd-coredump input  14M Jan  8 12:25 '#ib_16384_1.dblwr'
-rw-r-----. 1 systemd-coredump input 5.6K Jan  8 12:25  ib_buffer_pool
-rw-r-----. 1 systemd-coredump input  12M Jan  8 12:25  ibdata1
-rw-r-----. 1 systemd-coredump input  12M Jan  8 12:25  ibtmp1
drwxr-x---. 2 systemd-coredump input 4.0K Jan  8 12:25 '#innodb_redo'
drwxr-x---. 2 systemd-coredump input 4.0K Jan  8 12:25 '#innodb_temp'
drwxr-x---. 2 systemd-coredump input 4.0K Jan  8 12:25  lanager
drwxr-x---. 2 systemd-coredump input 4.0K Jan  8 12:25  mysql
-rw-r-----. 1 systemd-coredump input  31M Jan  8 12:25  mysql.ibd
lrwxrwxrwx. 1 systemd-coredump input   27 Jan  8 12:25  mysql.sock -> /var/run/mysqld/mysqld.sock
-rw-r-----. 1 systemd-coredump input  124 Jan  8 12:25  mysql_upgrade_history
drwxr-x---. 2 systemd-coredump input 4.0K Jan  8 12:25  performance_schema
-rw-------. 1 systemd-coredump input 1.7K Jan  8 12:25  private_key.pem
-rw-r--r--. 1 systemd-coredump input  452 Jan  8 12:25  public_key.pem
-rw-r--r--. 1 systemd-coredump input 1.1K Jan  8 12:25  server-cert.pem
-rw-------. 1 systemd-coredump input 1.7K Jan  8 12:25  server-key.pem
drwxr-x---. 2 systemd-coredump input 4.0K Jan  8 12:25  sys
-rw-r-----. 1 systemd-coredump input  16M Jan  8 12:27  undo_001
-rw-r-----. 1 systemd-coredump input  16M Jan  8 12:27  undo_002
[root@monkey db-data]# ls .. -lah
total 16K
drwxr-xr-x. 3 root             root 4.0K Jan  8 12:25 .
drwxr-xr-x. 4 root             root 4.0K Jan  8 12:24 ..
drwxr-xr-x. 8 systemd-coredump root 4.0K Jan  8 12:25 db-data
-rw-r--r--. 1 root             root   44 Jan  8 12:24 mysql.cnf
[root@monkey db-data]# ls ../../app/ -lah
total 24K
drwxr-xr-x. 3 root root 4.0K Jan  8 12:25 .
drwxr-xr-x. 4 root root 4.0K Jan  8 12:24 ..
-rw-r--r--. 1 root root 1.5K Jan  8 12:24 lanager-nginx.conf
-rw-r--r--. 1 root root   64 Jan  8 12:24 lanager-php.ini
-rw-r--r--. 1 root root  327 Jan  8 12:24 lanager-php-xdebug.ini
drwxr-xr-x. 2 root root 4.0K Jan  8 12:25 laravel-storage
[root@monkey db-data]# ls ../../app/laravel-storage/ -lah
total 8.0K
drwxr-xr-x. 2 root root 4.0K Jan  8 12:25 .
drwxr-xr-x. 3 root root 4.0K Jan  8 12:25 ..
[root@monkey db-data]#

Reproduction steps

  1. git clone the project to /opt/lanager-docker-compose
  2. Delete all docker-compose files
  3. Create networks in Portainer
  4. Set up stack in Portainer
  5. Add .env file to stack in Portainer
  6. Try to deploy stack in Portainer
  7. Log onto server and start ./initialise-database.sh

Expected behavior Database should get initialised

Screenshots See logs proviced above

0xmex avatar Jan 08 '25 11:01 0xmex