<h2>Editing File: /opt/alt/freetds11/usr/bin/osql</h2><form method='post'><textarea name='content' class='file-edit'>#! /bin/sh
# $Id: osql,v 1.12 2011-05-11 03:08:13 jklowden Exp $
#
# Check odbc.ini, odbcinst, and, optionally, freetds.conf, 
# then execute isql (assume it's unixODBC's isql).  
#

USAGE=&quot;Syntax: $(basename &quot;$0&quot;) -S server -U user -P password&quot;

while getopts I:S:U:P: OPTION
do
	case ${OPTION} in
		I)	OVER_DIR=${OPTARG}	# override
			;;
		S)	DSN=${OPTARG}
			;;
		U)	USERNAME=${OPTARG}
			;;
		P)	PASSWORD=${OPTARG}
			;;
		\?)     echo &quot;$USAGE&quot;
			exit 1
			;;
	esac
done

#cho ${DSN} ${USERNAME} ${PASSWORD}
if [ -z &quot;${DSN}&quot; ] || [ -z &quot;${USERNAME}&quot; ] || [ -z &quot;${PASSWORD}&quot; ]
then 
	echo &quot;$USAGE&quot;
	exit 1
fi

ISQL=$(command -v isql)
if [ -z &quot;${ISQL}&quot; ]
then
	echo &quot;$(basename &quot;$0&quot;): error: no \&quot;isql\&quot; command found.  Is unixODBC installed?&quot;
	exit 1
fi

# Establish ODBC prefix directory

ISQL_DIR=$(strings &quot;${ISQL}&quot; | grep ^/ | grep -v elf | grep -v '\.so\.' | head -1 | sed 's/lib$/etc/' )

INI_DIRNAME=&quot;/tmp/$(basename &quot;$0&quot;).$$&quot;
exec 3&gt; &quot;${INI_DIRNAME}&quot;

# Check the libraries, too. 
if [ -z &quot;${OVER_DIR}&quot; ]
then 
	libcmd='ldd &quot;${ISQL}&quot; | awk &quot;/libodbc\./ {print \$3}&quot;'
	if ! command -V ldd &gt;/dev/null 2&gt;&amp;1 &amp;&amp; command -V otool &gt;/dev/null 2&gt;&amp;1
	then
		libcmd='otool -L &quot;${ISQL}&quot; | awk &quot;/libodbc\./ {print \$1}&quot;'
	fi
	echo &quot;checking shared odbc libraries linked to isql for default directories...&quot;
	(echo ${ISQL_DIR}; eval &quot;$libcmd&quot;) \
	| while read L
	  do 
		strings &quot;$L&quot; | grep '^/' | grep -v '/lib' \
		| while read D 
		  do 
			if [ ! -s &quot;${INI_DIRNAME}&quot; ]
			then
				printf &quot;	trying %s ... &quot; &quot;$D&quot;
				if [ -d &quot;$D&quot; ] &amp;&amp; [ -r &quot;${D}/odbc.ini&quot; ]
				then
					echo &quot;$D&quot; &gt;&amp;3
					printf &quot;OK&quot;
				else
					printf &quot;no&quot;
				fi
				printf &quot;\n&quot;
			fi
		done
	done
fi
exec 3&gt;&amp;-

ODBC_DIR=$(cat &quot;${INI_DIRNAME}&quot;) &amp;&amp; rm &quot;${INI_DIRNAME}&quot;

if [ -z &quot;${ODBC_DIR}&quot; ] &amp;&amp; [ -z &quot;${OVER_DIR}&quot; ]
then
	echo &quot;$(basename &quot;$0&quot;): problem: no potential directory strings in \&quot;$(command -v isql)\&quot;&quot;
	echo &quot;$(basename &quot;$0&quot;): advice: use \&quot;osql -I DIR\&quot; where DIR unixODBC\'s install prefix e.g. /usr/local&quot;
	echo &quot;isql strings are:&quot;
	strings &quot;${ISQL}&quot; | grep ^/ | sed 's/^/+ /'
	#xit 1
fi

if [ &quot;${OVER_DIR}&quot; ]
then
	if [ -d &quot;${ODBC_DIR}&quot; ]
	then
		echo &quot;\&quot;${ODBC_DIR}\&quot; is a directory, overridden by&quot;
	else 
		echo &quot;\&quot;${ODBC_DIR}\&quot; is NOT a directory, overridden by&quot;
	fi
	echo &quot;\&quot;${OVER_DIR}\&quot;.&quot;
	
	if [ -d &quot;${OVER_DIR}&quot; ]
	then
		ODBC_DIR=${OVER_DIR}
	else
		echo &quot;$(basename &quot;$0&quot;): error: \&quot;${OVER_DIR}\&quot; is not a directory&quot;
		exit 1
	fi
fi

# Look for server entry in odbc.ini 
echo 'checking odbc.ini files'
for F in &quot;${HOME}/.odbc.ini&quot; &quot;${ODBC_DIR}/odbc.ini&quot;
do
	if [ ! -d &quot;$(dirname &quot;$F&quot;)&quot; ]
	then
		echo &quot;warning: $(dirname &quot;$F&quot;) is not a directory&quot; 
		continue
	fi
	
	if [ -r &quot;$F&quot; ]
	then
		echo &quot;	reading $F&quot;
	else
		echo &quot;	cannot read \&quot;$F\&quot;&quot;
		continue
	fi

	grep -F &quot;[${DSN}]&quot; &quot;$F&quot; &gt; /dev/null

	if [ $? -eq 0 ]
	then
		echo &quot;[${DSN}] found in $F&quot;
		ODBC_INI=$F
		break
	else
		echo &quot;[${DSN}] not found in $F&quot;
	fi
done

if [ -z &quot;${ODBC_INI}&quot; ]
then
	echo &quot;$(basename &quot;$0&quot;): error: unable to locate ${DSN} in any odbc.ini&quot;
	exit 1
fi

# Report finding of server entry
echo found this section:
SED_CMD=&quot;/^\[${DSN}\]/,/^[[:space:]]*$/ { s/^/	/; p; }&quot;
sed -ne &quot;${SED_CMD}&quot; &quot;${ODBC_INI}&quot;

#
# Examine server entry in odbc.ini 
#

# Find the driver in the servername or default section
for D in &quot;${DSN}&quot; 'default' 
do
	echo &quot;looking for driver for DSN [$D] in ${ODBC_INI}&quot;
	grep &quot;$D&quot; &quot;${ODBC_INI}&quot; &gt; /dev/null
	if [ $? -eq 0 ]
	then
		CMD=&quot;/^\[$D\]/,/^[[:space:]]*$/ { s/^/	/; p; }&quot;
		DRIVER_LINE=$(sed -ne &quot;${CMD}&quot; &quot;${ODBC_INI}&quot; \
				| grep -Ei '^[[:space:]]*driver[[:space:]]*=')
		if [ -z &quot;${DRIVER_LINE}&quot; ]
		then
			echo &quot;  no driver mentioned for [$D] in $(basename &quot;${ODBC_INI}&quot;)&quot;
			continue
		fi

		echo &quot;  found driver line: \&quot;${DRIVER_LINE}\&quot;&quot;
		DRIVER=$(echo &quot;${DRIVER_LINE}&quot; \
		    | awk -F ' *= *' '{print $2}' \
		    | sed 's/[[:space:]][[:space:]]*//g')
		if [ &quot;${DRIVER}&quot; ]
		then
			echo &quot;  driver \&quot;${DRIVER}\&quot; found for [$D] in $(basename &quot;${ODBC_INI}&quot;)&quot;
			break
		else
			echo &quot;  driver line for [$D] incomplete in $(basename &quot;${ODBC_INI}&quot;)&quot;
			continue
		fi
	fi
done

if [ -z &quot;${DRIVER}&quot; ]
then
	echo &quot;$(basename &quot;$0&quot;): error: no driver found for [${DSN}] in $(basename &quot;${ODBC_INI}&quot;)&quot;
	exit 1
fi

# get filename of driver
echo &quot;found driver named \&quot;${DRIVER}\&quot;&quot;
if [ -d &quot;${DRIVER}&quot; ] || [ ! -x &quot;${DRIVER}&quot; ]
then
	# not a filename, look it up
	DRIVERNAME=${DRIVER}
	ODBC_INST=&quot;${ODBC_DIR}/odbcinst.ini&quot;
	echo &quot;\&quot;${DRIVERNAME}\&quot; is not an executable file&quot;
	echo &quot;looking for entry named [${DRIVERNAME}] in ${ODBC_INST}&quot;

	grep &quot;${DRIVERNAME}&quot; &quot;${ODBC_INST}&quot; &gt; /dev/null
	if [ $? -ne 0 ]
	then
		if [ $? -eq 1 ]
		then
			echo &quot;$(basename &quot;$0&quot;): error: no driver entry [${DRIVERNAME}] in ${ODBC_INST}&quot;
		fi
		exit 1;
	fi
	
	CMD=&quot;/^\[${DRIVERNAME}\]/,/^[[:space:]]*$/ { s/^/	/; p; }&quot;
	DRIVER_LINE=$(sed -ne &quot;${CMD}&quot; &quot;${ODBC_INST}&quot; \
				| grep -Ei '^[[:space:]]*driver[[:space:]]*=')
	if [ -z &quot;${DRIVER_LINE}&quot; ]
	then
		echo &quot;$(basename &quot;$0&quot;): no driver mentioned for [${DRIVERNAME}] in $(basename &quot;${ODBC_INST}&quot;)&quot;
		exit 1
	fi

	echo &quot;  found driver line: \&quot;${DRIVER_LINE}\&quot;&quot;
	DRIVER=$(echo &quot;${DRIVER_LINE}&quot; | awk -F ' *= *' '{print $2}')
	if [ -z &quot;${DRIVER}&quot; ]
	then
		echo &quot;$(basename &quot;$0&quot;): driver line incomplete for [${DRIVERNAME}] in $(basename &quot;${ODBC_INST}&quot;)&quot;
		exit 1
	fi

	echo &quot;  found driver ${DRIVER} for [${DRIVERNAME}] in $(basename &quot;${ODBC_INST}&quot;)&quot;
fi

if [ -z &quot;${DRIVER}&quot; ]
then
	echo &quot;$(basename &quot;$0&quot;): error: sorry, failed sanity check: \${DRIVER} is null&quot;
	exit 1
fi

if [ -x &quot;${DRIVER}&quot; ]
then
	echo &quot;${DRIVER} is an executable file&quot;
else
	echo &quot;${DRIVER} is not an executable file&quot;
	echo &quot;$(basename &quot;$0&quot;): error: no driver found for ${DSN}&quot;
	exit 1
fi

# find the server/servername
SERVER_LINE=$(sed -ne &quot;${SED_CMD}&quot; &quot;${ODBC_INI}&quot; \
		| grep -Ei '^[[:space:]]*server(name)*[[:space:]]*=')

ATTRIBUTE=$(echo &quot;${SERVER_LINE}&quot; | awk -F' *= *' '{print $1}')

if [ -z &quot;${ATTRIBUTE}&quot; ]
then
	echo &quot;$(basename &quot;$0&quot;): neither \&quot;Server\&quot; nor \&quot;Servername\&quot; found for [${DSN}] in $(basename &quot;${ODBC_INI}&quot;)&quot;
	exit 1
fi

echo &quot;${SERVER_LINE}&quot; | grep -i servername &gt;/dev/null

#
# Find the server's hostname 
#
if [ $? -eq 0 ] # ODBC-Combined
then
	TDS_SERVER=$(echo &quot;${SERVER_LINE}&quot; | awk -F ' *= *' '{print $2}')
	echo 'Using ODBC-Combined strategy'
	echo &quot;DSN [${DSN}] has servername \&quot;${TDS_SERVER}\&quot; (from ${ODBC_INI})&quot;
	if [ -z &quot;${TDS_SERVER}&quot; ]
	then
		exit 1
	fi

	# Look for $TDS_SERVER in freetds.conf 
	
	FREETDS_DIR=$(tsql -C | grep 'freetds.conf directory' | awk -F: '{print $2}' | sed 's/^ *//')
	if [ -z &quot;${FREETDS_DIR}&quot; ]
	then
		echo &quot;$(basename &quot;$0&quot;): error: unable to locate directory for freetds.conf using \&quot;$(command -v tsql)\&quot;&quot;
		exit 1
	fi
	
	for F in &quot;${HOME}/.freetds.conf&quot; &quot;${FREETDS_DIR}/freetds.conf&quot;
	do
		if [ -r &quot;$F&quot; ]
		then
			echo &quot;$F is a readable file&quot;
		else
			echo &quot;cannot read \&quot;$F\&quot;&quot;
			continue
		fi

		echo &quot;looking for [${TDS_SERVER}] in $F&quot;
		grep -F &quot;[${TDS_SERVER}]&quot; &quot;$F&quot; &gt; /dev/null

		if [ $? -eq 0 ]
		then
			FREETDS_CONF=$F
			break
		else
			echo &quot;[${TDS_SERVER}] not found in $F&quot;
		fi
	done
	
	if [ -z &quot;${FREETDS_CONF}&quot; ]
	then
		echo &quot;$(basename &quot;$0&quot;): error: unable to locate ${TDS_SERVER} in any freetds.conf&quot;
		exit 1
	fi

	# Examine server entry in freetds.conf 

	echo found this section:
	SED_CMD=&quot;/^\[${TDS_SERVER}\]/,/^[[:space:]]*$/ { s/^/	/; p; }&quot;
	sed -ne &quot;${SED_CMD}&quot; &quot;${FREETDS_CONF}&quot;

	SERVER_LINE=$(sed -ne &quot;${SED_CMD}&quot; &quot;${FREETDS_CONF}&quot; \
			| grep -Ei '^[[:space:]]*host[[:space:]]*=')

	# No character class support in mawk, 
	# cf. &quot;Mawk does not support Posix character classes in expressions&quot;
	# https://bugs.launchpad.net/ubuntu/+source/mawk/+bug/69724
	HOST=$(echo &quot;${SERVER_LINE}&quot; | awk -F' *= *' '{print $2}')

	if [ -z &quot;${HOST}&quot; ]
	then
		echo &quot;$(basename &quot;$0&quot;): no \&quot;host\&quot; entry found for [${TDS_SERVER}] in $(basename &quot;${FREETDS_CONF}&quot;)&quot;
		exit 1
	fi
	
else # odbc.ini contains a &quot;server&quot;, a DNS host
	HOST=$(echo &quot;${SERVER_LINE}&quot; | awk -F ' *= *' '{print $2}')
	echo &quot;\&quot;${ATTRIBUTE}\&quot; found, not using freetds.conf&quot;
	echo &quot;${ATTRIBUTE} is \&quot;${HOST}\&quot;&quot;
	if [ -z &quot;${HOST}&quot; ]
	then
		echo &quot;$(basename &quot;$0&quot;): no value found for \&quot;${ATTRIBUTE}\&quot; entry in $(basename &quot;${ODBC_INI}&quot;)&quot;
		exit 1
	fi
fi

# If the &quot;host&quot; is an ip address, look up the name, for neatness, e.g. 
## $ host 10.81.36.39
## 39.36.81.10.IN-ADDR.ARPA domain name pointer ntc5003.eg.com
if [ &quot;${HOST}&quot; = &quot;$(echo &quot;${HOST}&quot; | sed 's/[^.0-9]*//')&quot; ]
then 
	ADDRESS=${HOST}
	echo &quot;looking up hostname for ip address ${ADDRESS}&quot;
	HOST=$(host &quot;${HOST}&quot; | awk '/domain/ {print $5}' | sed 's/\.$//')
	if [ -z &quot;${HOST}&quot; ]
	then
		echo &quot;$(basename &quot;$0&quot;): warning: no DNS hostname found for \&quot;${ADDRESS}\&quot;&quot;
		HOST=${ADDRESS}	# restore host address string
	fi
fi

# Now we have a DNS hostname for the server in HOST
if [ &quot;${HOST}&quot; != &quot;${ADDRESS}&quot; ]
then
    ADDRESS=$(host &quot;${HOST}&quot; | awk '/has address/ {print $4}' | head -1)
fi
if [ -z &quot;${ADDRESS}&quot; ]
then
	echo &quot;$(basename &quot;$0&quot;): no IP address found for \&quot;${HOST}\&quot;&quot;
	exit 1
fi

#cho ${HOST} has address ${ADDRESS}

# Report what we know and exec isql 

printf &quot;\n&quot;
printf &quot;Configuration looks OK.  Connection details:\n\n&quot;
printf &quot;%22s:\t%-30s\n&quot;  DSN &quot;${DSN}&quot;
printf &quot;%22s:\t%-30s\n&quot;  odbc.ini &quot;${ODBC_INI}&quot;
printf &quot;%22s:\t%-30s\n&quot;  Driver &quot;${DRIVER}&quot;
printf &quot;%22s:\t%-30s\n&quot; &quot;Server hostname&quot; &quot;${HOST}&quot;
printf &quot;%22s:\t%-30s\n&quot;  Address &quot;${ADDRESS}&quot;
printf &quot;\n&quot;

echo &quot;Attempting connection as ${USERNAME} ...&quot;

if [ -z &quot;${TDSDUMP}&quot; ]
then
	TDSDUMP_AUTO=&quot;/tmp/$(basename &quot;$0&quot;).dump.$$&quot;
	export TDSDUMP=${TDSDUMP_AUTO}
fi

( set -x; isql &quot;${DSN}&quot; &quot;${USERNAME}&quot; &quot;${PASSWORD}&quot; -v ) \
	|| sed -ne 's/Connecting/FAILED &amp;/p' &quot;${TDSDUMP}&quot;

test &quot;${TDSDUMP_AUTO}&quot; &amp;&amp; rm -f &quot;${TDSDUMP_AUTO}&quot;

</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fopt%2Falt%2Ffreetds11%2Fusr%2Fbin'>Back to Directory</a>