Ir para o conteúdo

Erro de conexão banco de dados com Bitrix

0

Boa tarde a todos. Estou com um problema onde não consigo conectar meu banco de dados do Bitrix, eu utilizo uma ferramenta chamada EXTRATOR e está corretamente configurada, porém, dá erro de timeout ao tentar conexão com meu bando de dados no Lightsail. O banco é em postgree e preciso tentar resolver com ugerncia. Alguém pode me ajudar?

feita há 2 meses62 visualizações
1 Resposta
1

Based on your description, you're experiencing a timeout error when trying to connect to your PostgreSQL database on AWS Lightsail from an external tool called EXTRATOR. This is likely a security group configuration issue.

Here are some troubleshooting steps to resolve your connection timeout problem:

  1. Check your security group settings for the Lightsail instance. The most common reason for connection failures is that the security group associated with your database instance doesn't authorize connections from the device or EC2 instance where your application (EXTRATOR) is running.

  2. You need to update the security group with an inbound rule that allows access from the IP address where EXTRATOR is running. Make sure port 5432 (default PostgreSQL port) is open for your specific IP address.

  3. Verify that your database is using the standard PostgreSQL port (5432). If your company has firewall rules that block this port, you might need to reconfigure your database to use a different port.

  4. Ensure that your database credentials (username, password, database name) are correctly configured in the EXTRATOR tool.

  5. Check if your PostgreSQL database is configured to accept remote connections (check pg_hba.conf file settings if you have access).

If you continue to experience issues after checking these settings, you may need to contact AWS Support for further assistance with your specific Lightsail configuration.
Sources
Troubleshooting connections to your MariaDB DB instance - Amazon Relational Database Service

respondido há 2 meses

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.