Skip to content

buildpack not working on heroku-22 stack #19

@JewlsIOB

Description

@JewlsIOB

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

  • Installing with different FREETDS_VERSION settings (and none at all)
  • with the main branch of this code, 1.1.2 and 1.1.1 versions, and same problem
  • On my local macbook, I can run the freetds tsql connection command to connect almost instantaneously to a variety of mssql databases (one on ec2 and two on azure), but the same command times out on heroku bash prompt:
~ $ tsql -H ***.rds.amazonaws.com -p 1433 -U *** -P ***
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
103Error 20002 (severity 9):
	Adaptive Server connection failed
Error 20002 (severity 9):
	Adaptive Server connection failed
There was a problem connecting to the server
  • I can ping the server from heroku bash:
~ $ nslookup <host1>.us-east-1.rds.amazonaws.com
Server:		<ip address>
Address:	<ip address>#53

Non-authoritative answer:
<host1>.rds.amazonaws.com	canonical name = <host name>.compute-1.amazonaws.com.
Name:	<host name>.compute-1.amazonaws.com
Address: <another ip address>

~ $ nc -zv <host1>us-east-1.rds.amazonaws.com 1433
Connection to <host1>.us-east-1.rds.amazonaws.com (<another ip address>) 1433 port [tcp/ms-sql-s] succeeded!

Any ideas would be greatly appreciated!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions