rails-sqlserver / heroku-buildpack-freetds

This is a Heroku buildpack for vendoring the FreeTDS binaries into your project.
MIT License
10 stars 31 forks source link

buildpack not working on heroku-22 stack #19

Closed JewlsIOB closed 1 year ago

JewlsIOB commented 1 year ago

I believe there is some configuration problem with this heroku buildpack and the heroku-22 stack. Here are a few things I have tried:

Non-authoritative answer:

.rds.amazonaws.com canonical name = .compute-1.amazonaws.com. Name: .compute-1.amazonaws.com Address: ~ $ nc -zv us-east-1.rds.amazonaws.com 1433 Connection to .us-east-1.rds.amazonaws.com () 1433 port [tcp/ms-sql-s] succeeded! ``` Any ideas would be greatly appreciated!
JewlsIOB commented 1 year ago

For some more information, here is FreeTDS version local and remote. I did no special "configuration" file settings other than setting the TDS_VERSION to 7.3 when installing the buildpack on heroku.

# LOCAL:
$ tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v1.3.13
             freetds.conf directory: /opt/homebrew/etc
     MS db-lib source compatibility: no
        Sybase binary compatibility: yes
                      Thread safety: yes
                      iconv library: yes
                        TDS version: 7.3
                              iODBC: no
                           unixodbc: yes
              SSPI "trusted" logins: no
                           Kerberos: yes
                            OpenSSL: yes
                             GnuTLS: no
                               MARS: yes

# Heroku:
$ heroku run bash -a <app>
Running bash on ⬢ <app>.. up, run.4557 (Hobby)
~ $ tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v1.3.13
             freetds.conf directory: /app/freetds/etc
     MS db-lib source compatibility: no
        Sybase binary compatibility: no
                      Thread safety: yes
                      iconv library: yes
                        TDS version: 7.3
                              iODBC: no
                           unixodbc: no
              SSPI "trusted" logins: no
                           Kerberos: no
                            OpenSSL: yes
                             GnuTLS: no
                               MARS: yes