Apache httpd + FreeTDS hangs until restarted
Posted
by
Jordan Reiter
on Server Fault
See other posts from Server Fault
or by Jordan Reiter
Published on 2013-11-06T19:25:58Z
Indexed on
2013/11/06
21:56 UTC
Read the original article
Hit count: 192
Every so often requests to a Linux server (say, linux.example.org) where the web app (Django) pulls in data from a SQL Server database via FreeTDS will hang.
Requests on other servers pointing to the database still work, as do requests on linux.example.org that use local MySQL databases. Only the server plus FreeTDS appear to be affected.
Restarting httpd makes the database connections work correctly again.
What could cause this problem?
Using: Centos 5.9 freetds 0.91 Apache httpd 2.2.3
/etc/obdc.ini:
[DSN]
Description = SQL Server 2005
Driver = FreeTDS
;Database = dbname
Servername = SERVERNAME
;TDS_Version = 8.0
/etc/freetds.conf:
[SERVERNAME]
driver = /usr/lib64/libtdsodbc.so
host = db.example.org
port = 1433
tds version = 8.0
client charset = UTF-8
© Server Fault or respective owner