Does Venbu actually work with ...

Join our new BDRSuite Community Forum and connect with fellow members for better collaboration and support!

Ask Your Question

Does Venbu actually work with Linux?

I have tried to get the Linux install working for about two days now.. 12.04 through 16.04 of Ubuntu server with no success. Either libraries are missing or I cant connect to the database once I manually get all the prerequisites installed (something the script should do). I also can only get that working under 14.04 of Ubuntu.

They say they support it but it would say its not very well, in addition I have emailed a couple of times with no reply.

Anyone have any luck using it under Linux?

Thanks!

edit retag flag offensive close merge delete

asked 2017-03-24 14:20:52 -0500

brianA932
1 ●2 ●2 ●2

1 reply

Re: Does Venbu actually work with Linux?

by ramalingam

After installation of the Linux OS new machine. The OS need to be updated once in order to get the latest linux packages. If the OS is not updated once with latest packages then libraries and unixODBC will not get installed properly. In order to resolve these library issues, please do follow the steps given in the knowledge base article link below.

Link : https://www.vembu.com/support/knowled...

Also you mentioned in your post that you are having some DB connect issue after sorting out the library issues

If You are facing any database connection error, you can compare SGConfiguration.conf file(available in BDR installation location) and /usr/local/etc/odbc.ini file entries are correctly matching.

<bdr_installation_path vembu="" vembubdr="">conf/SGConfiguration.conf

Commands :

odbcinst -j cat /usr/local/etc/odbc.ini

OutPut :

[PostGreDBConnection]

Description = Test to Postgres

Driver = /usr/local/lib/psqlodbcw.so

Servername = localhost

UserName =postgres

Password = admin

Port = 5432

Database=SGDatabase

UseServerSidePrepare=0

ByteaAsLongVarBinary=1

[ODBC] Pooling=yes

If you are still facing the DB connection error, then kindly update the error message that you getting in the forum thread for further discussion.

edit flag offensive delete

answered 2017-03-24 15:47:58 -0500

ramalingam
61 ●1

8 Comments

I will try this, these were the packages I was adding. If I use Ubuntu 16.04 will any changes need to me made?

brianA932 ( 2017-03-24 16:06:11 -0500 )edit

Reported issue wont occur in Ubuntu 16.04, if you face any issues in Ubuntu 16.04, Please contact our support (vembu-support@vembu.com) with the error message.

ramalingam ( 2017-03-24 16:57:47 -0500 )edit

I have tried it with 16.04.2 and will try again... are you saying that I can just install 16.04 and then Vembu? No package updated etc?

brianA932 ( 2017-03-24 17:58:47 -0500 )edit

SGDB1001:: Error while connecting to database '/home/vembubdr/Vembu/VembuBDR/data/sgserver.db' with error '01000 : Failed to connect to datasource: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/psqlodbcw.so' : file not found in database ::/home/vembubdr/Vembu/VembuBDR/data/sgserver.db')

brianA932 ( 2017-03-24 18:54:47 -0500 )edit

Thats the error I get after a fresh install of Ubuntu 16.04, and running the script... kind of frustrating...

brianA932 ( 2017-03-24 18:55:56 -0500 )edit

Can you share the output of "odbcinst -j /usr/local/etc/odbc.ini" and "isql -v PostGreDBConnection" to analyze this issue further

nagarajan ( 2017-03-24 22:22:39 -0500 )edit

In addition, can u send us the output of the following commands, locate locate libstdc++.so

ashar ( 2017-03-24 23:33:22 -0500 )edit

It seems, UnixODBC is already installed in your machine and when we type 'obdcinst -j' command, it looks like that system search the odbc.ini file inside the /etc location. And there is no content in the /etc/odbc.ini file. During Vembu BDR installation, we have created the odbc.ini file inside /usr/local/etc/ location. Since, /etc/odbc.ini file is empty, you faced the db connection issue in your machine. So we have created a soft link for odbc.ini in your machine by running the following command, ln -s /usr/local/etc/odbc.ini /etc/odbc.ini Now, Vembu BDR is running and the db connection issue resolved. We will handle this case in our installer in our next update v3.8.

Udhaya ( 2017-03-27 02:30:38 -0500 )edit