I'm at wits end, I have absolutely no clue how to proceed from here, and I've scoured the internet for any solutions to my problems. The problem has evolved over the course of several weeks now, so the problem that you see here comes from a streak of other problems.
What I am trying to achieve is to set up an vRODBC connection between R and Vertica. Eventually we want to load data into a Vertica DB and then query on it from R in order to analyse or predict or do stuff in general.
The problem however is quite simple, I just cannot achieve the connection. It has thrown several errors at me for a while now, but at this point we've landed on the following message:
Code: Select all
bbubuntuuser@BBVertica-Master:~$ isql -v VerticaDSN
[08001][unixODBC][Vertica][ODBC] (10380) Unable to establish a connection with data source. Missing settings: {[Database] [ServerName]}
[ISQL]ERROR: Could not SQLConnect
Code: Select all
echo $VERTICAINI
/etc/vertica.ini
echo $ODBCINI
/etc/odbc.ini
echo $LD_LIBRARY_PATH
/opt/vertica/lib:/usr/lib:/usr/local/lib
First /etc/odbc.ini:
Code: Select all
[ODBC Data Sources]
VerticaDSN = "vmart"
[VerticaDSN]
Description = VerticaDSN
Driver = /opt/vertica/lib64/libverticaodbc.so
Database = vmart
Servername = 10.0.0.4
UserName = dbadmin
Password = <omitted>
Port = 5433
ConnSettings =
Locale = en_US
[Driver]
DriverManagerEncoding = UTF-32
ODBCInstLib = /usr/lib/x86_64-linux-gnu/libodbcinst.so
ErrorMessagesPath = /opt/vertica/lib64
LogLevel = 5
LogPath = /tmp
Code: Select all
[Driver]
DriverManagerEncoding = UTF-32
ODBCInstLib = /usr/lib/x86_64-linux-gnu/libodbcinst.so
ErrorMessagesPath = /opt/vertica/lib64
LogLevel = 5
LogPath = /tmp
The log is also very descriptive:
Code: Select all
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: in: DSN:VerticaDSN, type 0
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out BackupServerNode
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out ColumnsAsChar
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out ConnectionLoadBalance
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out ConnSettings
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out Database
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out DirectBatchInsert
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out DriverStringConversions
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out Label
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out Locale
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out Port
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out PreferredAddressFamily
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out PWD
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out ResultBufferSize
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out ServerName
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out SSLCertFile
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out SSLKeyFile
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out SSLMode
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out TransactionIsolation
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: out UID
Feb 15 15:54:56 INFO 2752448320 VConnection::UpdateConnectionSettings: type 0, value: ?
Feb 15 15:54:56 ERROR 2752448320 Connection::SQLConnectW: [Vertica][ODBC] (10380) Unable to establish a connection with data source. Missing settings: {[Database] [ServerName]}