Tedros
Postgre db ECONNRESET
I have been using a postgres db in my deployments for quite some time. I setup a new one today and it constantly is giving the ECONNRESET error when acessing from Dbgate and from code which is throwing errrors in my platform. It works after trying again but why is the connnection failing? Seems like the server it's on is failing to keep connections open because it's the exact same db config, literally a clone of the other one. the only difference is that it's using "monrail.proxy.rlwy" and the functioning postgres db from earlier is on roundhouse.proxy.rlwy".
13 replies
ODBC driver install on Server
Hi! to connect to a sql database iv'e hosted, the machine my project is running on requires the shared object file libodbc.so.2 when installing ODBC driver. Below are the steps i did to ensure everything worked fine on my local machine, how can I do this on the machine my code is hosted on in railway? is there a way to specify the actual download file and run the commands needed? It's really important that I can get these installed on the railway server, any help at all would be really appreciated. I understand there are limitations, but there has to be a way to get this to work right?
Download ODBC Driver for SQL Server FOR SERVER TO RUN IN DJANGO
https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver16
Command:
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
HOMEBREW_ACCEPT_EULA=Y brew install msodbcsql18 mssql-tools18
May need:
sudo ln -s /usr/local/etc/odbcinst.ini /etc/odbcinst.ini sudo ln -s /usr/local/etc/odbc.ini /etc/odbc.ini
54 replies