aws / amazon-redshift-odbc-driver

Apache License 2.0
18 stars 7 forks source link

Compile for debian #8

Open mrtristan opened 1 year ago

mrtristan commented 1 year ago

Is it intentional that there is not a Debian release? The previous closed source version supported debian and RPM releases. This is blocking us from moving to this new release.

https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html image

EDIT:

for others in this boat, here are the important bits to get it working using the existing release: https://gist.github.com/mrtristan/ad7a637c9b00c1960ba78d1193c47955

vahid110 commented 1 year ago

@mrtristan thank you for your question and comment. We are working on providing debian distribution of this ODBC. Kindly stay tuned.

mrtristan commented 1 year ago

@vahid110 thanks - do you have a high level estimate on timeline? would you say it's days, weeks, or months away?

vahid110 commented 1 year ago

@mrtristan This is still in our todo list. We'll try to provide this from the next one or two release.

mrtristan commented 1 year ago

@vahid110 i appreciate it. we were actually facing a number of (seemingly random) crashes when running a dotnet app in docker that we could not track down. we finally found that it was always immediately prior to redshift interactions. our runtime is debian so i was stuck with 1.x

I installed the rpm version of 2.x using https://wiki.debian.org/Alien and the crashes have stopped but i'd like to be running a directly supported release

EzrealJ commented 12 months ago

@vahid110 Hello, I am also following the progress of this matter😁

EzrealJ commented 12 months ago

And. For ARM?

vahid110 commented 9 months ago

Hi @EzrealJ I apologize for my delay in response. I will put this as a priority : rpm(for arm) and debian package. We'll have to prepare some pipeline infra internally and release after testing

mrtristan commented 5 months ago

@vahid110 any update available?

rokclimb15 commented 2 months ago

I have a mostly working build for Ubuntu which should work on Debian as well. There are some missing libs being passed into ld so I get linker errors. Could use a little help fixing that. This issue is also a blocker, but I patched it in my local version: https://github.com/aws/amazon-redshift-odbc-driver/issues/27

mrtristan commented 2 months ago

@vahid110 any chance that @rokclimb15's efforts will help move this along?

idanbenyehoshua commented 1 month ago

I'm facing with that same issue. .net 8 app with 1.x odbc driver but with tiny memory leak. @mrtristan I try to work also with Alien but getting several error in the docker stage. This is my docker for 1.x version (that work without Alien of course)

FROM mcr.microsoft.com/dotnet/aspnet:8 WORKDIR /app

COPY ./out . COPY ./AmazonRedshiftODBC-64-bit-1.5.16.1019-1.x86_64.deb ./ run apt-get update run apt-get install -y unixodbc run apt-get update run apt install ./AmazonRedshiftODBC-64-bit-1.5.16.1019-1.x86_64.deb env ODBCINI=/etc/odbc.ini env AMAZONREDSHIFTODBCINI=/etc/amazon.redshiftodbc.ini env ODBCSYSINI=/etc

env LD_DEBUG=libs

RUN cp /opt/amazon/redshiftodbc/Setup/odbc.ini /etc/odbc.ini #./out/odbc/odbc.ini /etc/odbc.ini RUN cp /opt/amazon/redshiftodbc/Setup/odbcinst.ini /etc/odbcinst.ini #./out/odbc/odbcinst.ini /etc/odbcinst.ini RUN cp /opt/amazon/redshiftodbc/lib/64/amazon.redshiftodbc.ini /etc/amazon.redshiftodbc.ini #./out/odbc/amazon.redshiftodbc.ini /etc/amazon.redshiftodbc.ini ENTRYPOINT ["dotnet", "MyAppApp.dll"]

Can you please share with me how did you manage work with 2.x with Alien and deb (if you have dockerfile it will be great).

mrtristan commented 1 month ago

@idanbenyehoshua here's the important bits to get it working: https://gist.github.com/mrtristan/ad7a637c9b00c1960ba78d1193c47955

idonca commented 2 weeks ago

hello, any news regarding the arm64 version?