Trouble with APP_KEY env variable

[thesebastianf]

Hey
I am struggling getting this to run.
All services are up but I get a 500 Server Error in Chrome

any hints would be very welcome

[thesebastianf]

networks:
  investbrain-network:
    driver: bridge
services:
  app:
    image: investbrainapp/investbrain:latest
    container_name: investbrain-app
    restart: unless-stopped
    tty: true
    ports:
      - 3003:80
    environment:
      # You can either use these properties OR an .env file. Do not use both!
      APP_KEY: keywashere
      AI_CHAT_ENABLED: true
      OPENAI_API_KEY: keywashere
      OPENAI_ORGANIZATION: Personal
      MARKET_DATA_PROVIDER: yahoo
      #ALPHAVANTAGE_API_KEY:
      #FINNHUB_API_KEY:
      MARKET_DATA_REFRESH: 30
      #DAILY_CHANGE_TIME:
      APP_URL: http://localhost:3003
      ASSET_URL: http://localhost:3003
      DB_CONNECTION: mysql
      DB_HOST: investbrain-mysql
      DB_PORT: 3306
      DB_DATABASE: investbrain
      DB_USERNAME: investbrain
      DB_PASSWORD: inv3stbrainp
      SESSION_DRIVER: redis
      QUEUE_CONNECTION: redis
      CACHE_STORE: redis
      REDIS_HOST: investbrain-redis
    volumes:
      - /home/user/DATA/docker/data/investbrain:/var/app/storage # You can use a volume... 
      # - /path/to/storage:/var/app/storage:delegated # ...or you can use a path on host      
    depends_on:
      - mysql
      - redis
    networks:
      - investbrain-network
  redis:
    image: redis:alpine
    container_name: investbrain-redis
    restart: unless-stopped
    tty: true
    command:
      - --loglevel warning
    volumes:
      - /home/user/DATA/docker/data/investbrain/redis:/data
    networks:
      - investbrain-network
  mysql:
    image: mysql:8.0
    container_name: investbrain-mysql
    restart: unless-stopped
    environment:
      MYSQL_DATABASE: investbrain
      MYSQL_USER: investbrain
      MYSQL_PASSWORD: inv3stbrainp
      MYSQL_ROOT_PASSWORD: inv3stbrainp
    command:
      - --cte-max-recursion-depth=25000
    volumes:
      - /home/user/DATA/docker/data/investbrain/mysql:/var/lib/mysql
    networks:
      - investbrain-network
volumes:
  investbrain-storage:
  investbrain-redis:
  investbrain-mysql:

[thesebastianf]

investbrain-app    | 
investbrain-app    |    INFO  Preparing database.  
investbrain-app    | 
investbrain-app    |   Creating migration table ..................................... 164.30ms DONE
investbrain-app    | 
investbrain-app    |    INFO  Running migrations.  
investbrain-app    | 
investbrain-app    |   0001_01_01_000000_create_users_table ......................... 241.01ms DONE
investbrain-app    |   0001_01_01_000002_create_failed_jobs_table .................... 26.51ms DONE
investbrain-app    |   2021_01_30_102537_create_portfolios_table ..................... 19.46ms DONE
investbrain-app    |   2021_01_30_112537_create_portfolio_users_table ............... 101.43ms DONE
investbrain-app    |   2021_02_25_041221_create_market_data_table Imported 34999 market data items successfully!
investbrain-app    | ......................... 1s DONE
investbrain-app    |   2021_02_25_041227_create_daily_change_table ................... 89.92ms DONE
investbrain-app    |   2021_02_25_041236_create_dividends_table ...................... 21.62ms DONE
investbrain-app    |   2021_02_25_041246_create_splits_table ......................... 17.00ms DONE
investbrain-app    |   2021_02_25_041257_create_transactions_table ................... 51.76ms DONE
investbrain-app    |   2021_09_06_014744_create_holdings_table ....................... 53.28ms DONE
investbrain-app    |   2024_07_30_012529_add_two_factor_columns_to_users_table ....... 92.77ms DONE
investbrain-app    |   2024_07_30_012537_create_personal_access_tokens_table ......... 49.24ms DONE
investbrain-app    |   2024_10_18_000001_add_reinvestment_columns .................... 67.01ms DONE
investbrain-app    |   2024_10_19_155635_create_connected_accounts_table ............ 116.89ms DONE
investbrain-app    |   2024_10_23_000001_create_import_jobs_table .................... 59.22ms DONE
investbrain-app    |   2024_10_30_000001_create_ai_chats_table ....................... 64.94ms DONE
investbrain-app    |   2024_11_05_000001_add_user_admin_column ....................... 31.41ms DONE
investbrain-app    | 
investbrain-app    | ====================== Spinning up Supervisor daemon...  ====================== 
investbrain-app    | 
investbrain-app    | 2025-03-16 11:52:32,448 INFO Set uid to user 0 succeeded
investbrain-app    | 2025-03-16 11:52:32,452 INFO supervisord started with pid 1
investbrain-app    | 2025-03-16 11:52:33,453 INFO spawned: 'nginx' with pid 20
investbrain-app    | 2025-03-16 11:52:33,455 INFO spawned: 'php' with pid 21
investbrain-app    | 2025-03-16 11:52:33,457 INFO spawned: 'queue-worker_00' with pid 22
investbrain-app    | 2025-03-16 11:52:33,458 INFO spawned: 'queue-worker_01' with pid 23
investbrain-app    | 2025-03-16 11:52:33,459 INFO spawned: 'scheduler' with pid 24
investbrain-app    | 2025-03-16 11:52:34,559 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app    | 2025-03-16 11:52:34,561 INFO success: php entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app    | 2025-03-16 11:52:34,561 INFO success: queue-worker_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app    | 2025-03-16 11:52:34,561 INFO success: queue-worker_01 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app    | 2025-03-16 11:52:34,561 INFO success: scheduler entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

[gmensching]

Hey I am struggling getting this to run. All services are up but I get a 500 Server Error in Chrome

any hints would be very welcome

I tried installing this for the first time yesterday and am having the same issue trying to get it running from scratch.

[thesebastianf]

since I run it on a server .. I changed localhost to the actual IP of der host where docker is running..
still Error 500

[thesebastianf]

in the log I see:

[2025-03-16 14:32:15] production.ERROR: SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select exists (select 1 from information_schema.tables where table_schema = 'investbrain' and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 2002): SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select exists (select 1 from information_schema.tables where table_schema = 'investbrain' and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`) at /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
[stacktrace]
#0 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(979): Illuminate\\Database\\Connection->runQueryCallback('select exists (...', Array, Object(Closure))
#1 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(958): Illuminate\\Database\\Connection->tryAgainIfCausedByLostConnection(Object(Illuminate\\Database\\QueryException), 'select exists (...', Array, Object(Closure))
#2 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(781): Illuminate\\Database\\Connection->handleQueryException(Object(Illuminate\\Database\\QueryException), 'select exists (...', Array, Object(Closure))
#3 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run('select exists (...', Array, Object(Closure))
#4 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(344): Illuminate\\Database\\Connection->select('select exists (...', Array, true)
#5 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Illuminate\\Database\\Connection->selectOne('select exists (...', Array, true)
#6 /var/app/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(45): Illuminate\\Database\\Connection->scalar('select exists (...')
#7 /var/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php(184): Illuminate\\Database\\Schema\\MySqlBuilder->hasTable('migrations')
#8 /var/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(742): Illuminate\\Database\\Migrations\\DatabaseMigrationRepository->repositoryExists()
#9 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(165): Illuminate\\Database\\Migrations\\Migrator->repositoryExists()
#10 /var/app/vendor/laravel/framework/src/Illuminate/Support/helpers.php(338): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}(1)
#11 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(165): retry(1, Object(Closure), 0, Object(Closure))
#12 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(141): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->repositoryExists()
#13 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(111): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->prepareDatabase()
#14 /var/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#15 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\\Database\\Migrations\\Migrator->usingConnection(NULL, Object(Closure))
#16 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#17 /var/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#18 /var/app/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#19 /var/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#20 /var/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#21 /var/app/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#22 /var/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call(Array)
#23 /var/app/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#24 /var/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#25 /var/app/vendor/symfony/console/Application.php(1094): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#26 /var/app/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#27 /var/app/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#28 /var/app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#29 /var/app/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#30 /var/app/artisan(13): Illuminate\\Foundation\\Application->handleCommand(Object(Symfony\\Component\\Console\\Input\\ArgvInput))
#31 {main}

[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:66)
[stacktrace]
#0 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(66): PDO->__construct('mysql:host=inve...', 'investbrain', Object(SensitiveParameterValue), Array)
#1 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(85): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=inve...', 'investbrain', Object(SensitiveParameterValue), Array)
#2 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(48): Illuminate\\Database\\Connectors\\Connector->tryAgainIfCausedByLostConnection(Object(PDOException), 'mysql:host=inve...', 'investbrain', Object(SensitiveParameterValue), Array)
#3 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=inve...', Array, Array)
#4 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(185): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)
#5 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()
#6 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1231): call_user_func(Object(Closure))
#7 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1267): Illuminate\\Database\\Connection->getPdo()
#8 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(512): Illuminate\\Database\\Connection->getReadPdo()
#9 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): Illuminate\\Database\\Connection->getPdoForSelect(true)
#10 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select exists (...', Array)
#11 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(979): Illuminate\\Database\\Connection->runQueryCallback('select exists (...', Array, Object(Closure))
#12 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(958): Illuminate\\Database\\Connection->tryAgainIfCausedByLostConnection(Object(Illuminate\\Database\\QueryException), 'select exists (...', Array, Object(Closure))
#13 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(781): Illuminate\\Database\\Connection->handleQueryException(Object(Illuminate\\Database\\QueryException), 'select exists (...', Array, Object(Closure))
#14 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run('select exists (...', Array, Object(Closure))
#15 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(344): Illuminate\\Database\\Connection->select('select exists (...', Array, true)
#16 /var/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Illuminate\\Database\\Connection->selectOne('select exists (...', Array, true)
#17 /var/app/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(45): Illuminate\\Database\\Connection->scalar('select exists (...')
#18 /var/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php(184): Illuminate\\Database\\Schema\\MySqlBuilder->hasTable('migrations')
#19 /var/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(742): Illuminate\\Database\\Migrations\\DatabaseMigrationRepository->repositoryExists()
#20 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(165): Illuminate\\Database\\Migrations\\Migrator->repositoryExists()
#21 /var/app/vendor/laravel/framework/src/Illuminate/Support/helpers.php(338): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}(1)
#22 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(165): retry(1, Object(Closure), 0, Object(Closure))
#23 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(141): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->repositoryExists()
#24 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(111): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->prepareDatabase()
#25 /var/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#26 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\\Database\\Migrations\\Migrator->usingConnection(NULL, Object(Closure))
#27 /var/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#28 /var/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#29 /var/app/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#30 /var/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#31 /var/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#32 /var/app/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#33 /var/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call(Array)
#34 /var/app/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#35 /var/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#36 /var/app/vendor/symfony/console/Application.php(1094): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#37 /var/app/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#38 /var/app/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#39 /var/app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#40 /var/app/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#41 /var/app/artisan(13): Illuminate\\Foundation\\Application->handleCommand(Object(Symfony\\Component\\Console\\Input\\ArgvInput))
#42 {main}
"} 

[thesebastianf]

also tried the sqlite version: #51

same error 500

[hackeresq]

Hi these logs look similar to the issue the folks in #51 were having. Specifically, this part:

SQLSTATE[HY000] [2002] Connection refused

Couple troubleshooting steps would be helpful.

1. What are you using the manage the containers? That screenshot doesn't look like the normal Docker Desktop client.

2. Would be interested to see logs from the MySQL container. Can you share the output of:

docker logs investbrain-mysql

3. And also try verifying what port MySQL might be trying to use (or not)?

docker ps | grep investbrain-mysql

4. Separately, can you try using these DB_HOST values and restart the stack?

DB_HOST=host.docker.internal  # If using Mac/Windows
DB_HOST=127.0.0.1  # If MySQL is running on the host machine

[hackeresq]

The image scaling thing is because the ASSET_URL env needs to be set to a reachable URL. (See #7)

I'm planning to mess around with DockGe. Hoping to reproduce your issue.

[gmensching]

The image scaling thing is because the ASSET_URL env needs to be set to a reachable URL. (See #7)

I'm planning to mess around with DockGe. Hoping to reproduce your issue.

I'm having the same exact issue. I'm not using DockGe. Just command line. I'll try an unmodified compose and see if that works.

[hackeresq]

Which issue? The scaling issue? That should be resolved with the ASSET_URL

For the docker issue, seems a common thread is making changes to the compose file.

Curious what did you change?

[gmensching]

Which issue? The scaling issue? That should be resolved with the ASSET_URL

For the docker issue, seems a common thread is making changes to the compose file.

Curious what did you change?

Yes I'm getting the 500 Server Error. I also just mapped my storage.

[thesebastianf]

can confirm .. once you map volumes to customs paths ... see my first post with compose yaml .. you get the 500 error

[Githero12-svg]

@thesebastianf @hackeresq @dataoscar @gmensching please send me the dockerfile for this project as i want to contribute to this project

[thesebastianf]

No you understood this wrong.

Did you Test this with 1 device? So docker Host for the Container and accessing the Webpage on the Same device?
Or 2 devices.... Running the Container on a separate docker Host Server and accessing the Webpage from another device Like your Laptop?

[Githero12-svg]

Sometimes the chart shows up and sometimes it doesn't. Can you please tell me what's happening

[thesebastianf]

well see post no1 of this thread
its not about a chart or something ... ANYthing is a 500 error with custom path in volumes .. even the launch page.
this is also confirmed above from another user.

[MRobi1]

I'm getting the 500 errors using volumes, no custom path. But I also had to use sqlite to get the app running. I'm going to test with the above compose.

[Githero12-svg]

@thesebastianf please help me with the charts and why it doesn't load some time?
What could be the possible reason for chart not loading. Please help 🙏🙏🥛

[MRobi1]

Just started doing some initial testing with this and also getting the 500 error. Registered new user, 500 error. Added a new transaction, 500 error. But even with the 500 error coming up, things are still working. The user was created. The transaction was logged.

[hackeresq]

Can you try flipping `APP_DEBUG` to true in your env?

…

On Sat, Mar 29, 2025 at 7:35 AM Mike ***@***.***> wrote: Just started doing some initial testing with this and also getting the 500 error. Registered new user, 500 error. Added a new transaction, 500 error. But even with the 500 error coming up, things are still working. The user was created. The transaction was logged. — Reply to this email directly, view it on GitHub <#74 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AD63TF6EWKBN3XWLXKESZET2W2HSTAVCNFSM6AAAAABZDRSZNWVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTENRWGE4TCNI> . You are receiving this because you were mentioned.Message ID: ***@***.*** com>

-- Corey

[MRobi1]

Can you try flipping APP_DEBUG to true in your env?

Finally getting around to trying this again. I can get arond the no database connection by switching to sqlite. But then get the 500 error.
Flipping APP_DEBUG to true, when I visit the URL I get this.

App Logs:

investbrain-app  | 
investbrain-app  |   ********************************************************************************
investbrain-app  |   *  III   N   N  V   V  EEEEE  SSSS  TTTTT  BBBBB   RRRR    AAAAA  III   N   N  *
investbrain-app  |   *   I    NN  N  V   V  E      S       T    B    B  R   R   A   A   I    NN  N  *
investbrain-app  |   *   I    N N N  V   V  EEEE   SSSS    T    BBBBB   RRRR    AAAAA   I    N N N  *
investbrain-app  |   *   I    N  NN  V   V  E          S   T    B    B  R  R    A   A   I    N  NN  *
investbrain-app  |   *  III   N   N   VVV   EEEEE  SSSS    T    BBBBB   R   R   A   A  III   N   N  *
investbrain-app  |   ********************************************************************************
investbrain-app  |   
investbrain-app  | ====================== Validating environment...  ====================== 
investbrain-app  | 
investbrain-app  |  > Storage directory scaffolding is OK... 
investbrain-app  | 
investbrain-app  |  > Permissions are OK... 
investbrain-app  | 
investbrain-app  |  > APP_KEY is OK... 
investbrain-app  | 
investbrain-app  | ====================== Running migrations...  ====================== 
investbrain-app  | 
investbrain-app  |    INFO  Nothing to migrate.  
investbrain-app  | 
investbrain-app  | ====================== Spinning up Supervisor daemon...  ====================== 
investbrain-app  | 
investbrain-app  | 2025-05-25 20:12:26,922 INFO Set uid to user 0 succeeded
investbrain-app  | 2025-05-25 20:12:26,927 INFO supervisord started with pid 1
investbrain-app  | 2025-05-25 20:12:27,930 INFO spawned: 'nginx' with pid 16
investbrain-app  | 2025-05-25 20:12:27,932 INFO spawned: 'php' with pid 17
investbrain-app  | 2025-05-25 20:12:27,933 INFO spawned: 'queue-worker_00' with pid 18
investbrain-app  | 2025-05-25 20:12:27,935 INFO spawned: 'queue-worker_01' with pid 19
investbrain-app  | 2025-05-25 20:12:27,937 INFO spawned: 'scheduler' with pid 20
investbrain-app  | 2025-05-25 20:12:29,086 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app  | 2025-05-25 20:12:29,086 INFO success: php entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app  | 2025-05-25 20:12:29,086 INFO success: queue-worker_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app  | 2025-05-25 20:12:29,086 INFO success: queue-worker_01 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app  | 2025-05-25 20:12:29,086 INFO success: scheduler entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app  |    INFO  No scheduled commands are ready to run.  
investbrain-app  | 
investbrain-app  |    INFO  No scheduled commands are ready to run.  
investbrain-app  | 
investbrain-app  |    INFO  No scheduled commands are ready to run.  
investbrain-app  | 
investbrain-app  |    INFO  No scheduled commands are ready to run.  
investbrain-app  | 

Compose File:

---
name: investbrain
networks:
  investbrain-network:
    driver: bridge
services:
  app:
    image: investbrainapp/investbrain:latest
    container_name: investbrain-app
    restart: unless-stopped
    tty: true
    ports:
      - 8000:80
    environment: # You can either use these properties OR an .env file. Do not use both!
      APP_KEY: APPKEYHERE
      APP_PORT: 8000
      APP_URL: "http://192.X.XX.XX:8000"
      ASSET_URL: "http://192.X.XX.XX:8000"
      APP_DEBUG: true
      MARKET_DATA_PROVIDER: yahoo
      MARKET_DATA_REFRESH: 15
      DAILY_CHANGE_TIME: "17:00"
      APP_TIMEZONE: America/Halifax
      DB_CONNECTION: sqlite
      DB_DATABASE: /var/app/storage/app/investbrain.sqlite
      # DB_CONNECTION: mysql
      # DB_HOST: investbrain-mysql
      # DB_PORT: 3306
      # DB_DATABASE: investbrain
      # DB_USERNAME: investbrain
      # DB_PASSWORD: investbrain
      SESSION_DRIVER: redis
      QUEUE_CONNECTION: redis
      CACHE_STORE: redis
      REDIS_HOST: investbrain-redis
      REGISTRATION_ENABLED: true
    volumes:
      - investbrain-storage:/var/app/storage # You can use a volume... 
      # - /root/investbrain/storage:/var/app/storage # You can use a volume... 
    depends_on:
      - redis
    networks:
      - investbrain-network

  redis:
    image: redis:alpine
    container_name: investbrain-redis
    restart: unless-stopped
    tty: true
    command:
      - --loglevel warning
    volumes:
      - investbrain-redis:/data
      # - /root/investbrain/data:/data
    networks:
      - investbrain-network

  mysql:
      image: mariadb:10.6
      container_name: investbrain-mysql
      restart: unless-stopped
      environment:
        MYSQL_DATABASE: ${DB_DATABASE:-investbrain}
        MYSQL_USER: ${DB_USERNAME:-investbrain}
        MYSQL_PASSWORD: ${DB_PASSWORD:-investbrain}
        MYSQL_ROOT_PASSWORD: ${DB_PASSWORD:-investbrain}
      volumes:
        - investbrain-mysql:/var/lib/mysql
        -# /root/investbrain/mysql:/var/lib/mysql
      networks:
        - investbrain-network

volumes:
  investbrain-storage:
  investbrain-redis:
  investbrain-mysql:

NOTE Tried switching database to mariadb as indicated here: https://github.com/orgs/investbrainapp/discussions/62#discussioncomment-12888705
But did not solve the Waiting for database error.

[Githero12-svg]

Has it run migration. Please check. Please connect to MySQL database inside the container from your host

…

On Sun, 30 Mar 2025, 01:26 hackerESQ, ***@***.***> wrote: Can you try flipping `APP_DEBUG` to true in your env? On Sat, Mar 29, 2025 at 7:35 AM Mike ***@***.***> wrote: > Just started doing some initial testing with this and also getting the 500 > error. Registered new user, 500 error. Added a new transaction, 500 error. > But even with the 500 error coming up, things are still working. The user > was created. The transaction was logged. > > — > Reply to this email directly, view it on GitHub > < #74 (comment)>, > or unsubscribe > < https://github.com/notifications/unsubscribe-auth/AD63TF6EWKBN3XWLXKESZET2W2HSTAVCNFSM6AAAAABZDRSZNWVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTENRWGE4TCNI> > . > You are receiving this because you were mentioned.Message ID: > ***@***.*** > com> > -- Corey — Reply to this email directly, view it on GitHub <#74 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BPBZW3XJ7N7UXMWUA2FZYPT2W33GLAVCNFSM6AAAAABZDRSZNWVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTENRWGQYDEMY> . You are receiving this because you commented.Message ID: ***@***.*** com>

[Githero12-svg]

Migration task should be part of composer.yml and it needs to depend on MySQL. Please check if all the tables are created in my my SQL database. Make sure database migration are run

…

On Sun, 30 Mar 2025, 06:17 Ddd Dd, ***@***.***> wrote: Has it run migration. Please check. Please connect to MySQL database inside the container from your host On Sun, 30 Mar 2025, 01:26 hackerESQ, ***@***.***> wrote: > Can you try flipping `APP_DEBUG` to true in your env? > > On Sat, Mar 29, 2025 at 7:35 AM Mike ***@***.***> wrote: > > > Just started doing some initial testing with this and also getting the > 500 > > error. Registered new user, 500 error. Added a new transaction, 500 > error. > > But even with the 500 error coming up, things are still working. The > user > > was created. The transaction was logged. > > > > — > > Reply to this email directly, view it on GitHub > > < > #74 (comment)>, > > > or unsubscribe > > < > https://github.com/notifications/unsubscribe-auth/AD63TF6EWKBN3XWLXKESZET2W2HSTAVCNFSM6AAAAABZDRSZNWVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTENRWGE4TCNI> > > > . > > You are receiving this because you were mentioned.Message ID: > > ***@***.*** > > com> > > > > > -- > Corey > > — > Reply to this email directly, view it on GitHub > <#74 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/BPBZW3XJ7N7UXMWUA2FZYPT2W33GLAVCNFSM6AAAAABZDRSZNWVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTENRWGQYDEMY> > . > You are receiving this because you commented.Message ID: > ***@***.*** > com> >

[Githero12-svg]

@MRobi1 i got it working on docker container and also on desktop pc. We can have Skype call and I'll be glad to help you.

[thesebastianf]

1 i got it working on docker container and also on desktop pc. We can have Skype call and I'll be glad to help you.

can you share your docker yaml for this? Your docker host is another server on not running on your actual machine (client) right?
Thank you

[myllo]

Please - anyone with a separate server or homelab - post your docker-compose,yaml, if it works.
I also get only error 500 and seem to have exactly the same problem(s?) as thesebastianf.

[hackeresq]

There is a chance that the initial market data seeder is causing your containers to run out of memory (which would also explain the lack of logs). This has happened a few times to me on tiny VPS services I tested.

I'm working on making the initial market data seed an "option" that can be disabled. Would be interested to see whether that helps here.

[thesebastianf]

investbrain-app    | 
investbrain-app    |    INFO  Nothing to migrate.  
investbrain-app    | 
investbrain-app    | ====================== Spinning up Supervisor daemon...  ====================== 
investbrain-app    | 
investbrain-app    | 2025-05-12 18:10:50,684 INFO Set uid to user 0 succeeded
investbrain-app    | 2025-05-12 18:10:50,688 INFO supervisord started with pid 1
investbrain-app    | 2025-05-12 18:10:51,690 INFO spawned: 'nginx' with pid 22
investbrain-app    | 2025-05-12 18:10:51,692 INFO spawned: 'php' with pid 23
investbrain-app    | 2025-05-12 18:10:51,694 INFO spawned: 'queue-worker_00' with pid 24
investbrain-app    | 2025-05-12 18:10:51,695 INFO spawned: 'queue-worker_01' with pid 25
investbrain-app    | 2025-05-12 18:10:51,696 INFO spawned: 'scheduler' with pid 26
investbrain-app    | 2025-05-12 18:10:52,858 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app    | 2025-05-12 18:10:52,859 INFO success: php entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app    | 2025-05-12 18:10:52,859 INFO success: queue-worker_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app    | 2025-05-12 18:10:52,859 INFO success: queue-worker_01 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app    | 2025-05-12 18:10:52,859 INFO success: scheduler entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
investbrain-app    |   2025-05-12 18:11:00 Running ['artisan' refresh:market-data] .. 208.78ms DONE
investbrain-app    |   ⇂ Refresh market data from market data provider  
investbrain-app    | 

[thesebastianf]

@hackeresq will test a new image asap once avail

[MRobi1]

I'm in!! Seeing the error I posted above was what pointed me in the right direction.
I was setting my own APP_KEY value which was a random string and even though the logs were saying "> APP_KEY is OK... " it was not.

I wiped everything. Started over. This time without the APP_KEY variable set. Ran the container, checked the logs, and used the generated base_64 app key. Restarted the container and got the login screen. Was able to create a user and register and get to the main screen.

Hope this helps others.

[hackeresq]

App key now gets set automatically! No need to manually add. Marking this discussion as closed.