Package: sqsh
Followup-For: Bug #650005
I have a similar condition. After upgrade to 2.1.7-1 my cron jobs that
use sqsh end up failing with either (usually):
Open Client Message
Layer 0, Origin 0, Severity 78, Number 35
Adaptive Server connection timed out
or (rarely):
Open Client Message
Layer 0, Origin 0, Severity 78, Number 41
Unable to connect: Adaptive Server is unavailable or does not exist
After I downgrade to 2.1-9 (with all dependencies staying at the same
versions), everything works ok.
But what is more interesting is that when I run my scripts not from cron
but by hand, they work OK. If I change the scripts so they not call sqsh
directly but via strace(1), they work OK. If I even add "shopt -s -o
xtrace" at the beginning of the script, sqsh runs fine.
The apropriate line in my scripts looks like this:
sqsh -S DALET_DSN -D dalet -H pierwsza -J iso_2 -U sa /usr/local/dalet/sql.sh
-m bcp -P password -i $QUERYFILE | sed
's/^\([^|]\+\)|\([^|]\+\)|\([^|]\+\)/\1:\2:\3/' > /home/log/`date +%Y%m%d`.log
And the DSN entry from freetds.conf:
[DALET_DSN]
host = IP
port = 5000
tds version = 6.0
nt domain = DOMAIN
I'm connecting to Sybase ASE 11.9.2 server. Timeouts are set to 10 in
the config file (I assume it's expressed in seconds).
-- System Information:
Debian Release: wheezy/sid
APT prefers testing
APT policy: (500, 'testing'), (500, 'stable'), (500, 'oldstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-5-686 (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=pl_PL (charmap=ISO-8859-2)
Shell: /bin/sh linked to /bin/bash
Versions of packages sqsh depends on:
ii lesstif2 1:0.95.2-1
ii libc6 2.13-21
ii libct4 0.91-1
ii libncurses5 5.9-4
ii libreadline6 6.2-7
ii libx11-6 2:1.4.4-4
ii libxext6 2:1.3.0-3
ii libxt6 1:1.1.1-2
sqsh recommends no packages.
sqsh suggests no packages.
-- debconf-show failed
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
