search

mpeppler / DBD-Sybase

Sybase driver for perl's DBI module
8 stars 3 forks source link

Please set SYBASE in CONFIG, or set the $SYBASE environment variable at Makefile.PL #128

Open KES777 opened 1 year ago

KES777 commented 1 year ago

This is not clear which value I should setup into that variable? export SYSBASE=1?

# dpkg-query -L freetds-dev
/.
/usr
/usr/include
/usr/include/bkpublic.h
/usr/include/cspublic.h
/usr/include/cstypes.h
/usr/include/ctpublic.h
/usr/include/odbcss.h
/usr/include/sqldb.h
/usr/include/sqlfront.h
/usr/include/sybdb.h
/usr/include/syberror.h
/usr/include/sybfront.h
/usr/include/tds_sysdep_public.h
/usr/lib
/usr/lib/x86_64-linux-gnu
/usr/lib/x86_64-linux-gnu/libct.a
/usr/lib/x86_64-linux-gnu/libsybdb.a
/usr/share
/usr/share/doc
/usr/share/doc/freetds-dev
/usr/share/doc/freetds-dev/copyright
/usr/lib/x86_64-linux-gnu/libct.so
/usr/lib/x86_64-linux-gnu/libsybdb.so
/usr/share/doc/freetds-dev/changelog.Debian.gz
root@work:/usr# dpkg-query -L freetds-common
/.
/etc
/etc/freetds
/usr
/usr/share
/usr/share/doc
/usr/share/doc/freetds-common
/usr/share/doc/freetds-common/NEWS.md.gz
/usr/share/doc/freetds-common/README.Debian
/usr/share/doc/freetds-common/README.md
/usr/share/doc/freetds-common/TODO.Debian
/usr/share/doc/freetds-common/TODO.md.gz
/usr/share/doc/freetds-common/changelog.Debian.gz
/usr/share/doc/freetds-common/copyright
/usr/share/doc/freetds-common/examples
/usr/share/doc/freetds-common/examples/freetds.conf.pl
/usr/share/doc/freetds-common/examples/locales.conf
/usr/share/freetds
/usr/share/freetds/freetds.conf
/usr/share/man
/usr/share/man/man5
/usr/share/man/man5/freetds.conf.5.gz
/usr/share/doc/freetds-common/examples/freetds.conf
root@work:/usr# cat /usr/share/freetds
cat: /usr/share/freetds: Is a directory
root@work:/usr# cat /usr/share/freetd^C
root@work:/usr# dpkg-query -L libct4
/.
/usr
/usr/lib
/usr/lib/x86_64-linux-gnu
/usr/lib/x86_64-linux-gnu/libct.so.4.0.0
/usr/share
/usr/share/doc
/usr/share/doc/libct4
/usr/share/doc/libct4/changelog.Debian.gz
/usr/share/doc/libct4/copyright
/usr/lib/x86_64-linux-gnu/libct.so.4
root@work:/usr# dpkg-query -L  libsybdb5
/.
/usr
/usr/lib
/usr/lib/x86_64-linux-gnu
/usr/lib/x86_64-linux-gnu/libsybdb.so.5.1.0
/usr/share
/usr/share/doc
/usr/share/doc/libsybdb5
/usr/share/doc/libsybdb5/changelog.Debian.gz
/usr/share/doc/libsybdb5/copyright
/usr/lib/x86_64-linux-gnu/libsybdb.so.5
root@work:/usr# 
root@work:~/.cpanm/latest-build/DBD-Sybase-1.23# uname -r
6.2.5-060205-generic
root@work:~/.cpanm/latest-build/DBD-Sybase-1.23# uname -a
Linux work 6.2.5-060205-generic #202303110831 SMP PREEMPT_DYNAMIC Sat Mar 11 13:57:40 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
KES777 commented 1 year ago

this helped me: sudo SYBASE=/usr /home/kes/perl5/perlbrew/bin/cpanm DBD::Sybase Would be nice if module will auto detect it

mpeppler commented 1 year ago

Setting the SYBASE env variable depends on which client libraries you are building against (i.e. Sybase libraries, or freetds). And if FreeTDS, then we also depend on where this is installed (in the main /usr area, or under /usr/local, etc).

So trying to guess this is a bit tricky - in addition to which I've only used FreeTDS very occasionally...

KES777 commented 1 year ago

If implemented, it will be one case less to guess ;-)