Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Not able to access RDS postgresql DB from streamsets

Hi,

I have installed streamsets (version 2.4.1.0)in AWS EC2 instance and PostgreSQL(10.4) in AWS RDS. Also configured JDBC drivers required for postgresql in below path and set environment variable. --> /opt/sdc-extras/streamsets-datacollector-jdbc-lib/lib/ --> gave all permission to the jar file --> And added below in $SDC_CONF/sdc-security.policy file

// user-defined external directory grant codebase "file:///opt/sdc-extras/-" { permission java.security.AllPermission; };

i used below format for jdbc connection string jdbc:postgresql://[HOSTNAME]:[PORT]/[DBNAME]

I am able to access PostgreSQL using other tool like PGadmin but getting below error when i tried to connect using JDBC producer stage/JDBC consumer stage from streamsets

"JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: The connection attempt failed"

Not able to access RDS postgresql DB from streamsets

Hi,

I have installed streamsets (version 2.4.1.0)in AWS EC2 instance and PostgreSQL(10.4) in AWS RDS. Also configured JDBC drivers required for postgresql in below path and set environment variable. --> /opt/sdc-extras/streamsets-datacollector-jdbc-lib/lib/ --> variable.

  • /opt/sdc-extras/streamsets-datacollector-jdbc-lib/lib/
  • gave all permission to the jar file --> file
  • And added below in $SDC_CONF/sdc-security.policy file

    // user-defined external directory grant codebase "file:///opt/sdc-extras/-" { permission java.security.AllPermission; };

i used below format for jdbc connection string jdbc:postgresql://[HOSTNAME]:[PORT]/[DBNAME]string

jdbc:postgresql://[HOSTNAME]:[PORT]/[DBNAME]

I am able to access PostgreSQL using other tool like PGadmin but getting below error when i tried to connect using JDBC producer stage/JDBC consumer stage from streamsets

"JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: 
JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: 
Exception during pool initialization: The connection attempt failed"

failed"

Not able to access RDS postgresql DB from streamsets

Hi,

I have installed streamsets (version 2.4.1.0)in AWS EC2 instance and PostgreSQL(10.4) in AWS RDS. Also configured JDBC drivers required for postgresql in below path and set environment variable.

  • /opt/sdc-extras/streamsets-datacollector-jdbc-lib/lib/
  • gave all permission to the jar file
  • And added below in $SDC_CONF/sdc-security.policy file

    // user-defined external directory grant codebase "file:///opt/sdc-extras/-" { permission java.security.AllPermission; };

i I used below format for jdbc connection stringstring:

jdbc:postgresql://[HOSTNAME]:[PORT]/[DBNAME]

I am able to access PostgreSQL using other tool like PGadmin but getting below error when i tried to connect using JDBC producer stage/JDBC consumer stage from streamsets

"JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: 
JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: 
Exception during pool initialization: The connection attempt failed"

Not able to access RDS postgresql DB from streamsets

Hi,

I have installed streamsets (version 2.4.1.0)in AWS EC2 instance and PostgreSQL(10.4) in AWS RDS. Also configured JDBC drivers required for postgresql in below path and set environment variable.

  • /opt/sdc-extras/streamsets-datacollector-jdbc-lib/lib/
  • gave all permission to the jar file
  • And added below in $SDC_CONF/sdc-security.policy file

    // user-defined external directory
    grant codebase "file:///opt/sdc-extras/-" {
      permission java.security.AllPermission;
    };

    };

I used below format for jdbc connection string:

jdbc:postgresql://[HOSTNAME]:[PORT]/[DBNAME]

I am able to access PostgreSQL using other tool like PGadmin but getting below error when i tried to connect using JDBC producer stage/JDBC consumer stage from streamsets

"JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: 
JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: 
Exception during pool initialization: The connection attempt failed"

Not able to access RDS postgresql DB from streamsets

Hi,

I have installed streamsets (version 2.4.1.0)in 2.4.1.0) in AWS EC2 instance and PostgreSQL(10.4) in AWS RDS. Also configured JDBC drivers required for postgresql in below path and set environment variable.

  • /opt/sdc-extras/streamsets-datacollector-jdbc-lib/lib/
  • gave all permission to the jar file
  • And added below in $SDC_CONF/sdc-security.policy file

    // user-defined external directory
    grant codebase "file:///opt/sdc-extras/-" {
      permission java.security.AllPermission;
    };
    

I used below format for jdbc connection string:

jdbc:postgresql://[HOSTNAME]:[PORT]/[DBNAME]

I am able to access PostgreSQL using other tool like PGadmin but getting below error when i tried to connect using JDBC producer stage/JDBC consumer stage from streamsets

"JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: 
JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: 
Exception during pool initialization: The connection attempt failed"