In need of the experts' advise once again.
What: os-crowdsec installed and works like a charm w/ local SQLite db. When switching it out to an (external) postgresql on the local network, all hell breaks loose.
System Info:
- Opnsense 24.4_8-amd64
- FreeBSD 13.2-RELEASE-p11
- os-sec 1.07
postgresql config in crowdsec config.yaml
db_config:
type: pgx
user: <user>
password: <pwd>
host: <host_ip>
port: <host_port>
db_name: crowdsec
sslmode: prefer
max_open_conns: 100
decision_bulk_size: 2000
flush:
max_items: 10000
max_age: 90d
crowdsec service does not start after the change to config.yaml. It can't seem to connect to postgresql database. Database is verified to be up, and credentials work when using psql locally on db server and also remotely via another ubuntu machine.
[fbfdf7e6-bc7e-4543-b7bc-d7fadff59603] Script action stderr returned "b'{"level":"error","msg":"error while performing request: dial tcp <ip>:8080: i/o timeout; 4 retries left","time":"2024-06-19T01:39:21-07:00"}\n{"level":"error","msg":"error while performing request: dial tcp <ip>:8080: i/o timeout; 3 retries l'"