Join GitHub today
GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together.
Sign upSSL Config conflicts with secondary database #1133
Comments
|
Hi @sheik-syed! You can see a description of options for PgSQLDriver on the following links: https://node-postgres.com/features/ssl |
Yes. But i want to disable ssl configuration in index.js file. .env file configuration(see above) conflicts with index.js db connection. I see the below error for the above config. secondary doesnt enabled ssl. I want to disable from config. how can i do that? error |
|
You can disable SSL just set the value as const server = new CubejsServer({
externalDbType: 'postgres',
externalDriverFactory: () => new PgSQLDriver({
...,
ssl: false
})
});Your first error no related SSL. Which version cube.js you used? Could you please provide SQL query for CREATE TABLE? |
I am using two db both are Postgres. The first one is configured in .env and it is enabled SSL (called primary db). The second one is used for storing aggregation and disabled SSL on this (called secondary db).
Primary db configured in .env
.env
CUBEJS_DB_HOST=33.aaa.xx.yyy
CUBEJS_DB_NAME=sb_analytics
CUBEJS_DB_USER=system_sbs
CUBEJS_DB_PASS=password
CUBEJS_WEB_SOCKETS=true
CUBEJS_DB_TYPE=postgres
CUBEJS_DB_SSL=true
CUBEJS_DB_SSL_REJECT_UNAUTHORIZED=false
CUBEJS_API_SECRET=d0af34c14086b2fc4911b244dadc224211c9f78a0c29422666408f8ddc04fd44512793bfaad45845d75412da594969360f6f0b578f1bb714bb768912d5863f45
Secondary db configuration configured in index.js
index.js
const CubejsServer = require("@cubejs-backend/server");
const PgSQLDriver = require('@cubejs-backend/postgres-driver');
const server = new CubejsServer({
externalDbType: 'postgres',
externalDriverFactory: () => new PgSQLDriver({
host: 'localhost',
database: 'cube2',
user: 'postgres',
password: 'postgress',
port: '5432',
ssl: false(i am not sure this once is correct or not)
})
});
Schema:
cube(
QueryLogs, {sql:
SELECT * FROM public.query_logs,joins: {
},
measures: {
count: {
type:
count,drillMembers: [collectionName, customerId, createdDate]
}
},
dimensions: {
collectionName: {
sql:
collection_name,type:
string},
customerId: {
sql:
customer_id,type:
string},
ip: {
sql:
ip,type:
string},
query: {
sql:
query,type:
string},
createdDate: {
sql:
created_date,type:
time}
},
preAggregations: {
custQueryCount: {
type:
rollup,measureReferences: [QueryLogs.count],
timeDimensionReference: QueryLogs.createdDate,
granularity:
month,external: true
}
}
});
===========================================================
I am facing below error while cube-js trying to create a table on secondary db.
Error while querying: ab90fae9-94cb-4da9-821d-a8c790bdb65a-span-1 (3809ms)
{
"processingId": 1,
"queueSize": 1,
"queryKey": [
[
"CREATE TABLE stb_pre_aggregations.query_logs_cust_query_count AS SELECT\n date_trunc('month', ("query_logs".created_date::timestamptz AT TIME ZONE 'UTC')) "query_logs__created_date_month", count(*) "query_logs__count"\n FROM\n public.query_logs AS "query_logs"\n GROUP BY 1",
[]
],
[
[
{
"max": "2020-09-08T10:31:43.644"
}
]
]
],
"queuePrefix": "SQL_PRE_AGGREGATIONS_STANDALONE_default",
"timeInQueue": 0
}
error: at or near "if": syntax error: unimplemented: this syntax
at Parser.parseErrorMessage (/Users/sheik/SSS/cube-js/testme/test7/node_modules/pg-protocol/dist/parser.js:278:15)
at Parser.handlePacket (/Users/sheik/SSS/cube-js/testme/test7/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/Users/sheik/SSS/cube-js/testme/test7/node_modules/pg-protocol/dist/parser.js:39:38)
at TLSSocket.stream.on (/Users/sheik/SSS/cube-js/testme/test7/node_modules/pg-protocol/dist/index.js:8:42)
at emitOne (events.js:116:13)
at TLSSocket.emit (events.js:211:7)
at addChunk (_stream_readable.js:263:12)
at readableAddChunk (_stream_readable.js:250:11)
at TLSSocket.Readable.push (_stream_readable.js:208:10)
at TLSWrap.onread (net.js:597:20)
===========================================================
Primary db ssl configuration conflicts with secondary db.
what are the configurations used for disabling SSL in index.js file (externalDriverFactory)