[47960589014784][[SQLAllocHandle]][47960589014784]**** in PGAPI_AllocEnv ** [47960589014784]** exit PGAPI_AllocEnv: phenv = 0x2b9eb2040140 ** [47960589014784][[SQLSetEnvAttr]] att=200,3 [47960589014784][[SQLGetEnvAttr]] 200 [47960589014784][[SQLAllocHandle]][47960589014784]PGAPI_AllocConnect: entering... [47960589014784]**** PGAPI_AllocConnect: henv = 0x2b9eb2040140, conn = 0x2b9eb2146c00 [47960589014784]EN_add_connection: self = 0x2b9eb2040140, conn = 0x2b9eb2146c00 [47960589014784] added at 0, conn->henv = 0x2b9eb2040140, conns[0]->henv = 0x2b9eb2040140 [47960589014784][[SQLSetConnectAttr]] 103 [47960589014784]PGAPI_SetConnectAttr for 0x2b9eb2146c00: 103 0x8 [47960589014784]PGAPI_SetConnectOption: entering fOption = 103 vParam = 8 [47960589014784][[SQLSetConnectAttr]] 103 [47960589014784]PGAPI_SetConnectAttr for 0x2b9eb2146c00: 103 0x8 [47960589014784]PGAPI_SetConnectOption: entering fOption = 103 vParam = 8 [47960589014784][[SQLSetConnectAttr]] 115 [47960589014784]PGAPI_SetConnectAttr for 0x2b9eb2146c00: 115 (nil) [47960589014784]the application is unicode [47960589014784][SQLDriverConnectW][47960589014784]PGAPI_DriverConnect: entering... [47960589014784]**** PGAPI_DriverConnect: fDriverCompletion=0, connStrIn='Driver={PostgreSQL Unicode(x64)};Server=;Port=;Database=;UseDeclareFetch=1;Fetch=10000;Uid=;Pwd=;sslmode=verify-ca;sslrootcert=;debug=1;commlog=1' [47960589014784]CC_conninfo_init opt=2 [47960589014784]copy_globals driver=PostgreSQL Unicode socket_buffersize=4096 [47960589014784]our_connect_string = 'Driver={PostgreSQL Unicode(x64)};Server=;Port=;Database=;UseDeclareFetch=1;Fetch=10000;Uid=;Pwd=;sslmode=verify-ca;sslrootcert=;debug=1;commlog=1' [47960589014784]attribute = 'Driver', value = '{PostgreSQL Unicode(x64)}' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'Server', value = '' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'Port', value = '' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'Database', value = '' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'UseDeclareFetch', value = '1' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'Fetch', value = '10000' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'Uid', value = '' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'Pwd', value = 'password' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'sslmode', value = 'verify-ca' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'sslrootcert', value = '' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'debug', value = '1' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]attribute = 'commlog', value = '1' [47960589014784]copyAttributes: DSN='',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1) [47960589014784]getDSNinfo: DSN= overwrite=0 [47960589014784]our_connect_string = 'Driver={PostgreSQL Unicode(x64)};Server=;Port=;Database=;UseDeclareFetch=1;Fetch=10000;Uid=;Pwd=;sslmode=verify-ca;sslrootcert=;debug=1;commlog=1' [47960589014784]attribute = 'Driver', value = '{PostgreSQL Unicode(x64)}' [47960589014784]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'Server', value = '' [47960589014784]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'Port', value = '' [47960589014784]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'Database', value = '' [47960589014784]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'UseDeclareFetch', value = '1' [47960589014784]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=1;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'Fetch', value = '10000' [47960589014784]copyCommonAttributes: A7=10000;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=1;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'Uid', value = '' [47960589014784]copyCommonAttributes: A7=10000;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=1;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'Pwd', value = '' [47960589014784]copyCommonAttributes: A7=10000;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=1;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'sslmode', value = 'verify-ca' [47960589014784]copyCommonAttributes: A7=10000;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=1;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'sslrootcert', value = '' [47960589014784]copyCommonAttributes: A7=10000;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=1;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'debug', value = '1' [47960589014784]copyCommonAttributes: A7=10000;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=1;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]attribute = 'commlog', value = '1' [47960589014784]copyCommonAttributes: A7=10000;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=1;B4=0;B5=1;B6=1;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[47960589014784]calling getDSNdefaults [47960589014784]CC_connect: entering... [47960589014784]sslmode=verify-ca [47960589014784]LIBPQ_CC_connect: entering... [47960589014784]Driver Version='09.03.0400,Apr 5 2015' [47960589014784]LIBPQ_CC_connect: DSN = '', server = '', port = '', database = '', username = '', password='xxxxx' [47960589014784]connecting to the database using as the server [47960589014784]!!! usrname= server= [47960589014784]sizeof connectdb option = 164 [47960589014784]CC_error_statements: self=0x2b9eb2146c00 [47960589014784]CONN ERROR: func=LIBPQ_connect, desc='', errnum=101, errmsg='root certificate file "/home//.postgresql/root.crt" does not exist Either provide the file or change sslmode to disable server certificate verification. ' [47960589014784]Could not establish connection to the database; LIBPQ returned -> root certificate file "/home//.postgresql/root.crt" does not exist Either provide the file or change sslmode to disable server certificate verification. [47960589014784]SOCK_Destructor [47960589014784]CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum=101, errmsg='root certificate file "/home//.postgresql/root.crt" does not exist Either provide the file or change sslmode to disable server certificate verification. ' [47960589014784][SQLGetDiagRecW][47960589014784]PGAPI_GetDiagRec entering type=2 rec=1 [47960589014784]**** PGAPI_ConnectError: hdbc=0x2b9eb2146c00 <1026> [47960589014784]enter CC_get_error [47960589014784]enter CC_create_errormsg [47960589014784]msg = 'root certificate file "/home//.postgresql/root.crt" does not exist Either provide the file or change sslmode to disable server certificate verification. ' [47960589014784]exit CC_create_errormsg [47960589014784]exit CC_get_error [47960589014784]CC_get_error: status = 101, msg = #root certificate file "/home//.postgresql/root.crt" does not exist Either provide the file or change sslmode to disable server certificate verification. # [47960589014784] szSqlState = '08001',len=158, szError='root certificate file "/home//.postgresql/root.crt" does not exist Either provide the file or change sslmode to disable server certificate verification. '