Olá meu caro amigo @jaison-x encontrei um erro na importação das mensagens para o chatwoot poderia me ajudar a solucionar esse caso?
LOG ANTERIOR
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] provider found
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] provider found
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] create client to instance: setupautomatizado4
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] client created
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] format phone number
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] find contact in chatwoot
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] return contact
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] get inbox to instance: setupautomatizado4
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] get inbox to instance: setupautomatizado4
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] get client to instance: setupautomatizado4
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] get provider to instance: setupautomatizado4
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Finding chatwoot
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Getting instance name
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootRepository] [string] finding chatwoot
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootRepository] [string] finding chatwoot in db
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot account id: 1
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot token: HDM12121WEWEVkkBdZEb
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot url: https://chat.setupautomatizado.com.br
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot inbox name: setupautomatizado4
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot sign msg: true
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot sign delimiter: undefined
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot reopen conversation: true
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot conversation pending: false
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot import contacts: true
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot import messages: true
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [WAStartupService] [string] Chatwoot days limit import messages: 60
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] provider found
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] provider found
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] create client to instance: setupautomatizado4
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] client created
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 VERBOSE [ChatwootService] [string] find inboxes in chatwoot
ERROR
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 ERROR [ChatwootImport] [string] Error on get recent conversations: Error: The server does not support SSL connections
[Evolution API] v1.7.0 1 - Tue Mar 19 2024 18:08:41 ERROR [ChatwootService] [string] Error on update avatar in recent conversations: TypeError: Cannot read properties of undefined (reading 'map')
LOG ANTERIOR
ERROR
INSTANCIA CRIADA NO CHATWOOT
CURL USADA NA REQUEST
MEU .ENV DOCKER
Originally posted by @guilhermejansen in https://github.com/EvolutionAPI/evolution-api/issues/395#issuecomment-2008154804
RESOLVIDO!
Resolvido o problema de conexão com o postgres por conta do SSL !
Ponto de correção: ( ignorar o ssl "?sslmode=disable" )
CHATWOOT_MESSAGE_DELETE=true
CHATWOOT_IMPORT_DATABASE_CONNECTION_URI=postgresql://postgres:SENHA@IP:5432/chatwoot?sslmode=disable
CHATWOOT_IMPORT_DATABASE_PLACEHOLDER_MEDIA_MESSAGE=true