Database connection error PostgessDB

[GORAZIZYAN98]

Hi, guys, I have an issue with database cannot migrate database DB is Postgres the severless'yml

service: truescape-game-api provider: name: aws region: eu-central-1 runtime: provided environment: APP_STORAGE: '/tmp' APP_ENV: test APP_DEBUG: true # set to false when moving to production LOG_CHANNEL: stderr # this will send logs to CloudWatch automatically DB_CONNECTION: pgsql DB_HOST: PIPELINES_DB_HOST DB_PORT: 5432 DB_DATABASE: PIPELINES_DB_DATABASE DB_USERNAME: PIPELINES_DB_USERNAME DB_PASSWORD: PIPELINES_DB_PASSWORD vpc: securityGroupIds:

• sg-xxxxx subnetIds:
• subnet-xxxx

plugins:

• ./vendor/bref/bref package: exclude:
  • resources/lang/**
  • storage/**
  • node_modules/**
  • tests/** functions: website: handler: public/index.php timeout: 28 # in seconds (API Gateway has a timeout of 29 seconds) layers:
    • ${bref:layer.php-74-fpm} events:
    • http: 'ANY /'
    • http: 'ANY /{proxy+}' artisan: handler: artisan timeout: 120 # in seconds layers:
    • ${bref:layer.php-74-fpm}
    • ${bref:layer.console}

I have file in root. php/conf.d/php.ini -> ;extension=/opt/bref-extra/pgsql.so extension=pdo_pgsql

when run this command in bitbucket pipelines
vendor/bin/bref cli truescape-game-api-dev-artisan -- migrate --force I got error could not find driver (SQL: select * from information_schema.tables where t able_schema = public and table_name = migrations and table_type = 'BASE TAB LE') In Connector.php line 70: could not find driver

and when I run just php artisan migrate I got timeout error

P.S. all other artisan commands works but migration

[victormacko]

I'm not familiar with Postgres -- but the information_schema.tables is a MySQL one ... maybe check the environment vars are setup to use your postgres DB ... maybe your app is trying to connect to a MySQL DB?

[GORAZIZYAN98]

@victormacko I cat the .env all vars are there

[victormacko]

Dunno then ... maybe someone else has another idea ... you can always try the slack channel (see the 'community' page on the bref.sh site) for support too

[GORAZIZYAN98]

yes thanks

[mnapoli]

when run this command in bitbucket pipelines

This is related to BitBucket though.

and when I run just php artisan migrate

Where are you running this?

[GORAZIZYAN98]

both vendor/bin/bref cli truescape-game-api-dev-artisan -- migrate --force and php artisan migrate --force I run in piplines

[mnapoli]

In the artisan function, you used the ${bref:layer.php-74-fpm} layer: it should be ${bref:layer.php-74}.

[GORAZIZYAN98]

oh ! @mnapoli thx very much!