I'm getting this error for facebook ads connection
# announcements
m
I'm getting this error for facebook ads connection
b
Hi @mehmet_can_yavuz! Is this a local installation or a hosted solution?
m
Hosted solution on digitalocean
I installed from digitalocean marketplace today
y
Hey @mehmet_can_yavuz, You have not set your postgres credentials properly:
Copy code
psycopg2.OperationalError: could not connect to server: Connection refused
	Is the server running on host "localhost" (127.0.0.1) and accepting
	TCP/IP connections on port 5502?
When working with the Facebook Ads Extractor and Postgres, you have to at least set the following env variables in your
.env
file:
Copy code
export PG_DATABASE=
export PG_PASSWORD=
export PG_USERNAME=
export PG_ADDRESS=
export PG_PORT=

export TAP_FACEBOOK_ACCOUNT_ID="XXXX"
export TAP_FACEBOOK_ACCESS_TOKEN="XXXX"
For completeness: if you are running everything on the CLI, without using Meltano UI, you also need those:
Copy code
export TAP_FACEBOOK_START_DATE="2019-12-09T00:00:00Z"
export TAP_FACEBOOK_END_DATE="2019-12-19T00:00:00Z"