there couple of related threads here, gist of attempt connect vertica r on opencpu , vrodbc is:
- i started rjdbc, works fine in rstudio (even server rstudio edition), opencpu/rapache doesn't it. rjava on opencpu
- i installed vrodbc package derivative of rodbc , queried vertica both cmd line using isql , rstudio server using dsn , odbcconnect('mydsnname') installing vrodbc
- when compile app code works on rstudio server connection error when trying run on opencpu (pulled console):
it works rstudio server
> vertica = odbcconnect("verticadsn") > data = sqlquery(vertica, query) > data tdidcount 1 3015 but not opencpu app created
//from console output [vrodbc] error: state 01000, code 0, message [unixodbc][driver manager]can't open lib '/opt/vertica/lib64/libverticaodbc.so.6.1.3' : file not found warning message: odbc connection failed [1] -1 i checked path , exist. found question says error caused dependency can't loaded libverticaodbc.so library tried follow steps see library might not have had permissions opencpu user no avail. can't open lib unixodbc
$ sudo su - opencpu $ ldd /opt/vertica/lib64/libverticaodbc.so.6.1.3 linux-vdso.so.1 => (0x00007fff5cd10000) libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f16a30cc000) libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f16a2eb1000) libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007f16a2c77000) libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f16a2a59000) libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f16a2755000) libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f16a244e000) libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f16a2238000) libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f16a1e73000) /lib64/ld-linux-x86-64.so.2 (0x00007f16a4854000) $ i'm close... close... can feel it... gotta shadowy environment variable or permissions fixed opencpu can correctly find odbc drivers , i'll have more r+webapp glory propelling me forward!
Comments
Post a Comment