UnixODBC
view release on metacpan or search on metacpan
# /usr/local/etc/init.d/unixodbc start
# /usr/local/etc/init.d/unixodbc stop
- Manual Installation
Install the bridge server manually with the following shell
commands.
$ su
# mkdir /usr/local/var/odbcbridge
# chown nobody /usr/local/var/odbcbridge
# cp bridge/odbcbridge.conf /usr/local/etc
# cp bridge/odbclogins /usr/local/etc
# chmod 0600 /usr/local/etc/odbclogins
# chown nobody /usr/local/etc/odbclogins
# mkdir /usr/local/etc/init.d
# cp bridge/unixodbc /usr/local/etc/init.d
# cp bridge/odbcbridge /usr/local/sbin
# chmod +x /usr/local/sbin/odbcbridge
If everything is installed correctly, you should be able
to start and stop the server by typing:
# /usr/local/etc/init.d/unixodbc start
# /usr/local/etc/init.d/unixodbc stop
Edit the path to the perl interpreter on the
first line of tables,cgi, datamanager.cgi,
odbclogin.cgi to the path of the actual perl
interpreter. The path should be either
/usr/local/bin/perl, /usr/bin/perl, or the output
of the shell command, "which perl."
# cd /usr/local/etc
# chmod 0600 odbclogins
# chown nobody odbclogins # Use the UID/GID of httpd.conf's,
# chgrp nobody odbclogins # "User," and, "Group," directives.
Edit each line of the file /usr/local/etc/odbclogins for
the login of each system that has a bridge server installed.
The format of each line is:
host::user::password
The user names and passwords need not be the same as those
used to log in to the DSN's. They simply need to allow the
bridge/unixodbc view on Meta::CPAN
BRIDGEUSER='nobody' ; export BRIDGEUSER
PIDFILE='/usr/local/var/odbcbridge/odbcbridge.pid' ; export PIDFILE
case "$1" in
start)
echo "Starting ODBC bridge... "
/usr/local/sbin/odbcbridge &
while [ ! -f $PIDFILE ]; do
sh -c true
done
chown $BRIDGEUSER $PIDFILE
exit 0
;;
stop)
echo "Stopping ODBC bridge... "
kill `cat $PIDFILE`
exit 0
;;
*)
echo "Usage: unixodbc {start|stop|}" >&2
exit 1
( run in 1.351 second using v1.01-cache-2.11-cpan-5511b514fd6 )