ports/80452: port databases/py-mssql does not build

[Uwe Laverenz]

>Number:         80452
>Category:       ports
>Synopsis:       port databases/py-mssql does not build
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Fri Apr 29 10:30:01 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     Uwe Laverenz
>Release:        5.4-STABLE / RELENG_5
>Organization:
>Environment:
FreeBSD animal.molkerei-ammerland.de 5.4-STABLE FreeBSD 5.4-STABLE #1: Wed Apr 27 12:02:58 CEST 2005     laverenz at animal.molkerei-ammerland.de:/usr/obj/usr/src/sys/ANIMAL  i386
>Description:
The port databases/py-mssql does not build. It needs the include file "dblib.h", which does not exist (anymore). I guess this include file was provided by a previous version of freetds or freetds-msdblib.
>How-To-Repeat:
# cd /usr/ports/databases/py-mssql
# make
===>  Building for py24-mssql-0.6.0_1
running build
running build_py
running build_ext
building '_mssql' extension
cc -fno-strict-aliasing -DNDEBUG -O -pipe -DTHREAD_STACK_SIZE=0x20000 -O -pipe -fPIC -I/usr/include -I/usr/local/include -I/usr/include/freetds -I/usr/local/include/freetds -I/usr/local/include/python2.4 -c mssqldbmodule.c -o build/temp.freebsd-5.4-STABLE-i386-2.4/mssqldbmodule.o
mssqldbmodule.c:23:73: dblib.h: No such file or directory
mssqldbmodule.c: In function `_mssql_connect':
mssqldbmodule.c:206: error: dereferencing pointer to incomplete type
mssqldbmodule.c: In function `GetRow':
mssqldbmodule.c:771: error: structure has no member named `dateyear'
mssqldbmodule.c:772: error: structure has no member named `datemonth'
mssqldbmodule.c:773: error: structure has no member named `datedmonth'
mssqldbmodule.c:774: error: structure has no member named `datehour'
mssqldbmodule.c:775: error: structure has no member named `dateminute'
mssqldbmodule.c:776: error: structure has no member named `datesecond'
error: command 'cc' failed with exit status 1
*** Error code 1

Stop in /usr/ports/databases/py-mssql.

>Fix:
Sorry, I have no clue how this an be fixed. The package can be installed with "pkg_add -r py-mssql", but does not work. Scripts exit with:

ImportError: Shared object "libsybdb.so.4" not found, required by "_mssql.so"
>Release-Note:
>Audit-Trail:
>Unformatted: