error docker about openchat HOT 12 CLOSED

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'openchat.chatbots' doesn't exist (Connection: mysql, SQL: select * from `chatbots` where `prompt_message` is null)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:793
    789▕         // If an exception occurs when attempting to run a query, we'll format the error
    790▕         // message to include the bindings with SQL, which will make this exception a
    791▕         // lot more helpful to the developer instead of just the database's errors.
    792▕         catch (Exception $e) {
  ➜ 793▕             throw new QueryException(
    794▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    795▕             );
    796▕         }
    797▕     }

  i   A table was not found: You might have forgotten to run your database migrations. 
      https://laravel.com/docs/master/migrations#running-migrations

      +11 vendor frames 

  12  app/Console/Commands/FillInitialPromptCommand.php:32
      Illuminate\Database\Eloquent\Builder::get()
      +12 vendor frames 

  25  artisan:37
      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

make: *** [install] Error 1

$ make install
\033[1m=== Putting the services down (if already running) ===\033[0m
docker-compose down --remove-orphans
[+] Running 5/5
 ✔ Container openchat-backend-server-1  Removed                                                                10.8s 
 ✔ Container openchat-redis-1           Removed                                                                 1.3s 
 ✔ Container openchat-llm-server-1      Removed                                                                 1.4s 
 ✔ Container openchat-mysql-1           Removed                                                                10.6s 
 ✔ Network openchat_openchat_network    Removed                                                                 0.5s 
\033[1m=== Setting up Docker environment ===\033[0m
\033[1m=== This will overwrite your .env files, you still have some time to abort ===\033[0m
\033[1m=== Copying .env files ===\033[0m
cp -n backend-server/.env.example backend-server/.env 2>/dev/null || true
cp common.env llm-server/.env 2>/dev/null || true
docker-compose build #--no-cache
[+] Building 2.0s (25/25) FINISHED                                                                                   
 => [llm-server internal] load build definition from Dockerfile                                                 0.0s
 => => transferring dockerfile: 436B                                                                            0.0s
 => [llm-server internal] load .dockerignore                                                                    0.0s
 => => transferring context: 2B                                                                                 0.0s
 => [llm-server internal] load metadata for docker.io/library/node:18                                           0.9s
 => [llm-server 1/6] FROM docker.io/library/node:18@sha256:19892542dd80e33aec50a51619ab36db0921de240c6a4ff6024  0.0s
 => [llm-server internal] load build context                                                                    0.0s
 => => transferring context: 1.25kB                                                                             0.0s
 => CACHED [llm-server 2/6] WORKDIR /usr/src/app                                                                0.0s
 => CACHED [llm-server 3/6] COPY package*.json yarn.lock ./                                                     0.0s
 => CACHED [llm-server 4/6] COPY .env .env                                                                      0.0s
 => CACHED [llm-server 5/6] RUN yarn install                                                                    0.0s
 => CACHED [llm-server 6/6] COPY . .                                                                            0.0s
 => [llm-server] exporting to image                                                                             0.0s
 => => exporting layers                                                                                         0.0s
 => => writing image sha256:e44e1069e7feed6254b8d3200fd77564845eea4acb368e0698ee128937a172fe                    0.0s
 => => naming to docker.io/library/openchat-llm-server                                                          0.0s
 => [backend-server internal] load build definition from Dockerfile                                             0.0s
 => => transferring dockerfile: 924B                                                                            0.0s
 => [backend-server internal] load .dockerignore                                                                0.0s
 => => transferring context: 2B                                                                                 0.0s
 => [backend-server internal] load metadata for docker.io/library/php:8.1-cli                                   0.8s
 => [backend-server 1/9] FROM docker.io/library/php:8.1-cli@sha256:7d41d8fdb6fd8ef5ab9e53df39894d88297b34615da  0.0s
 => [backend-server internal] load build context                                                                0.0s
 => => transferring context: 22.13kB                                                                            0.0s
 => CACHED [backend-server 2/9] RUN apt-get update && apt-get install -y     libpq-dev     libzip-dev     zip   0.0s
 => CACHED [backend-server 3/9] RUN docker-php-ext-install pdo pdo_mysql                                        0.0s
 => CACHED [backend-server 4/9] WORKDIR /var/www/html                                                           0.0s
 => CACHED [backend-server 5/9] COPY . .                                                                        0.0s
 => CACHED [backend-server 6/9] COPY .env .env                                                                  0.0s
 => CACHED [backend-server 7/9] RUN curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/loc  0.0s
 => CACHED [backend-server 8/9] RUN composer install --no-plugins --no-scripts                                  0.0s
 => CACHED [backend-server 9/9] RUN php artisan key:generate                                                    0.0s
 => [backend-server] exporting to image                                                                         0.0s
 => => exporting layers                                                                                         0.0s
 => => writing image sha256:74b8979b79801843e1008885d067355196b90e66b3b2fd3df58bd8ce5043e7bd                    0.0s
 => => naming to docker.io/library/openchat-backend-server                                                      0.0s
docker-compose up -d #--force-recreate
[+] Running 5/5
 ✔ Network openchat_openchat_network    Created                                                                 0.1s 
 ✔ Container openchat-redis-1           Started                                                                 0.7s 
 ✔ Container openchat-llm-server-1      Started                                                                 0.9s 
 ✔ Container openchat-mysql-1           Started                                                                 0.8s 
 ✔ Container openchat-backend-server-1  Started                                                                 1.0s 
\033[1m=== Waiting for services to start (~20 seconds) ===\033[0m
\033[1m=== Clearing backend server config cache ===\033[0m
docker-compose exec backend-server php artisan cache:clear

   INFO  Application cache cleared successfully.  

docker-compose exec backend-server php artisan config:cache

   INFO  Configuration cached successfully.  

\033[1m=== Run backend server migrations ===\033[0m
docker-compose exec backend-server php artisan migrate --seed

   Illuminate\Database\QueryException 

  SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select * from information_schema.tables where table_schema = openchat and table_name = migrations and table_type = 'BASE TABLE')

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:793
    789▕         // If an exception occurs when attempting to run a query, we'll format the error
    790▕         // message to include the bindings with SQL, which will make this exception a
    791▕         // lot more helpful to the developer instead of just the database's errors.
    792▕         catch (Exception $e) {
  ➜ 793▕             throw new QueryException(
    794▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    795▕             );
    796▕         }
    797▕     }

      +38 vendor frames 

  39  artisan:37
      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

make: *** [Makefile:35: install] Error 1

$ docker ps
CONTAINER ID   IMAGE                     COMMAND                  CREATED             STATUS             PORTS                                                  NAMES
f956be236619   openchat-backend-server   "docker-php-entrypoi…"   About an hour ago   Up About an hour   0.0.0.0:8000->8000/tcp, :::8000->8000/tcp              openchat-backend-server-1
533bcae666ba   redis:3.2                 "docker-entrypoint.s…"   About an hour ago   Up About an hour   0.0.0.0:6379->6379/tcp, :::6379->6379/tcp              openchat-redis-1
dad54b13e808   mysql:5.7                 "docker-entrypoint.s…"   About an hour ago   Up About an hour   33060/tcp, 0.0.0.0:3307->3306/tcp, :::3307->3306/tcp   openchat-mysql-1
bb80f38e3475   openchat-llm-server       "docker-entrypoint.s…"   About an hour ago   Up About an hour                                                          openchat-llm-server-1

$ make install          
\033[1m=== Putting the services down (if already running) ===\033[0m
#docker-compose down --remove-orphans
\033[1m=== Setting up Docker environment ===\033[0m
\033[1m=== This will overwrite your .env files, you still have some time to abort ===\033[0m
#@sleep 5
\033[1m=== Copying .env files ===\033[0m
#cp -n backend-server/.env.example backend-server/.env 2>/dev/null || true
#cp common.env llm-server/.env 2>/dev/null || true
#docker-compose build #--no-cache
#docker-compose up -d #--force-recreate
\033[1m=== Waiting for services to start (~20 seconds) ===\033[0m
#@sleep 20
\033[1m=== Clearing backend server config cache ===\033[0m
docker-compose exec backend-server php artisan cache:clear

   INFO  Application cache cleared successfully.  

docker-compose exec backend-server php artisan config:cache

   INFO  Configuration cached successfully.  

\033[1m=== Run backend server migrations ===\033[0m
docker-compose exec backend-server php artisan migrate --seed

   Illuminate\Database\QueryException 

  SQLSTATE[HY000] [1130] Host '172.18.0.5' is not allowed to connect to this MySQL server (Connection: mysql, SQL: select * from information_schema.tables where table_schema = openchat and table_name = migrations and table_type = 'BASE TABLE')

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:793
    789▕         // If an exception occurs when attempting to run a query, we'll format the error
    790▕         // message to include the bindings with SQL, which will make this exception a
    791▕         // lot more helpful to the developer instead of just the database's errors.
    792▕         catch (Exception $e) {
  ➜ 793▕             throw new QueryException(
    794▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    795▕             );
    796▕         }
    797▕     }

      +35 vendor frames 

  36  artisan:37
      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

make: *** [Makefile:35: install] Error 1