```Transform 'tap-stripe' is missing, trying to in...
# announcements
r
```Transform 'tap-stripe' is missing, trying to install it... Added transform 'tap-stripe' to your Meltano project. Added transform 'tap-stripe' to your dbt packages. Added transform 'tap-stripe' to your dbt_project.yml. Installed 'tap-stripe'. Running extract & load... No state was found, complete import. /var/meltano/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/psycopg2/__init__.py144 UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: http://initd.org/psycopg/docs/install.html#binary-install-from-pypi. """) INFO message='Request to Stripe api' method=get path=https://api.stripe.com/v1/accounts/acct_1AeqcFKE86kOXAn7 INFO METRIC: {"type": "timer", "metric": "http_request_duration", "value": 1.0218567848205566, "tags": {"endpoint": "accounts", "status": "succeeded"}} INFO message='Stripe API response' path=https://api.stripe.com/v1/accounts/acct_1AeqcFKE86kOXAn7 response_code=200 INFO Successfully connected to Stripe Account with display name
MetaGeek
INFO Started syncing stream charges INFO message='Request to Stripe api' method=get path=https://api.stripe.com/v1/charges?created[gte]=1577862000 Traceback (most recent call last): File "/var/meltano/project/.meltano/loaders/target-postgres/venv/bin/target-postgres", line 11, in <module> load_entry_point('target-postgres==1.1.3', 'console_scripts', 'target-postgres')() File "/var/meltano/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/__init__.py", line 138, in main state = persist_lines(config, input) File "/var/meltano/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/__init__.py", line 101, in persist_lines stream_to_sync[stream].create_schema_if_not_exists() File "/var/meltano/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/db_sync.py", line 297, in create_schema_if_not_exists (schema_name,) File "/var/meltano/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/db_sync.py", line 133, in query with self.open_connection() as connection: File "/var/meltano/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/db_sync.py", line 130, in open_connection return psycopg2.connect(conn_string) File "/var/meltano/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/psycopg2/__init__.py", line 130, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) 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? INFO METRIC: {"type": "timer", "metric": "http_request_duration", "value": 1.0993385314941406, "tags": {"endpoint": "charges", "status": "succeeded"}} INFO message='Stripe API response' path=https://api.stripe.com/v1/charges?created[gte]=1577862000 response_code=200 WARNING Removed 8 paths during transforms: application_fee_amount billing_details disputed payment_method payment_method_details receipt_url statement_descriptor_suffix transfer_data WARNING Removed paths list: ['application_fee_amount', 'billing_details', 'disputed', 'payment_method', 'payment_method_details', 'receipt_url', 'statement_descriptor_suffix', 'transfer_data'] INFO METRIC: {"type": "counter", "metric": "record_count", "value": 0, "tags": {"endpoint": "charges"}} INFO METRIC: {"type": "counter", "metric": "record_count", "value": 0, "tags": {"endpoint": "events"}} INFO METRIC: {"type": "counter", "metric": "record_count", "value": 0, "tags": {"endpoint": "customers"}} INFO METRIC: {"type": "counter", "metric": "record_count", "value": 0, "tags": {"endpoint": "plans"}} INFO METRIC: {"type": "counter", "metric": "record_…
y
Hi @rich_parker, 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?
Check my response on the following thread for mor info: https://meltano.slack.com/archives/CFG3C3C66/p1580306622004300
r
Hello @yannis_roussos, I set it up using Digital Ocean's Droplet. Not sure if you have done that or not but it was pretty much just fill in information and click next. Should I work with them?
y
@micael_bergeron maybe that means that there is an issue with Meltano's DigitalOcean 1-click app image? Maybe the Postgres does not start as expected?
m
We are using an external cluster, I'll take a look.
@rich_parker I'll talk with the team about that and look at options regarding the self-served DigitalOcean image. I can see you signed up for a hosted instance too, so I'll see what I can do to make it happen.
I created an issue to track the discussion: https://gitlab.com/meltano/meltano/issues/1654
cc @mehmet_can_yavuz
r
@micael_bergeron If I signed up for a hosted instance I did not do that on purpose. I was just trying to create a droplet to check out Meltano.
m
Alright, no worries we'll figure it out. I'll try to fix the setup flow ASAP so you can get up and running :)
r
@micael_bergeron I am wondering if you have an update for me on my issue #1654?