postgresq connexion error
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
postgresq connexion error
Hi
"php": "^7.3|^8.0",
"aimeos/ai-cms-grapesjs": "dev-master",
"aimeos/aimeos-laravel": "dev-master",
DB: Postgresql.
i use the same configuration (.env and shop.php) in the local version and hosted version.
One DB Postgresql 9.6 in Virtual server used .
when I use the local version (from 127.0.0.1) and DB in vitual server, everything is fine but when I use the same DB in web version it displays this message to me.
"php": "^7.3|^8.0",
"aimeos/ai-cms-grapesjs": "dev-master",
"aimeos/aimeos-laravel": "dev-master",
DB: Postgresql.
i use the same configuration (.env and shop.php) in the local version and hosted version.
One DB Postgresql 9.6 in Virtual server used .
when I use the local version (from 127.0.0.1) and DB in vitual server, everything is fine but when I use the same DB in web version it displays this message to me.
Code: Select all
SQLSTATE[08006] [7] could not connect to server: Connection refused Is the server running on host "xxx.10.137.xx" and accepting TCP/IP connections on port 5432? (SQL: select * from "sessions" where "id" = ToOd40DSTQi4x9dotDXXAi4d7Ss3fAlRMJpED3pd limit 1)
Re: postgresq connexion error
The database connection details including the credentials are different on the hosted server for sure.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: postgresq connexion error
Thank you for the reply.
I use GIT including .env.
File: .gitignore
In my post:
In the hosting terminal:
and i tested
I believe the configuration data is the same
Thank you
I use GIT including .env.
File: .gitignore
Code: Select all
/node_modules
/public/hot
/public/storage
/ext/devoext/vendor
/storage/*.key
/vendor
.env.backup
.phpunit.result.cache
docker-compose.override.yml
Homestead.json
Homestead.yaml
npm-debug.log
yarn-error.log
Code: Select all
git push origin master
Code: Select all
git checkout -f
git pull origin master
php artisan config:cache ;php artisan cache:clear ; php artisan aimeos:clear;php ./artisan view:clear ;php ./artisan route:clear
I believe the configuration data is the same
Thank you
Re: postgresq connexion error
Hi,
Now I can say that (in hosted mode) the connection to a postgresql database is only done through port 5432, even we change the port in .env and shop.php. it does not accept ports other than 5432 (if the website is hosted).
but in local mode works perfectly.
i only changed the server port and .env and shop.php to 5432.
but I don't want to use this default port
thank you
Now I can say that (in hosted mode) the connection to a postgresql database is only done through port 5432, even we change the port in .env and shop.php. it does not accept ports other than 5432 (if the website is hosted).
but in local mode works perfectly.
i only changed the server port and .env and shop.php to 5432.
but I don't want to use this default port
thank you