[MacPorts] #19425: Add libdbi port
#19425: Add libdbi port ---------------------------+------------------------------------------------ Reporter: mta@… | Owner: macports-tickets@… Type: enhancement | Status: new Priority: Normal | Milestone: Port Submissions Component: ports | Version: 1.7.1 Keywords: | Port: libdbi ---------------------------+------------------------------------------------ I wanted to build GnuCash with the database backend which requires libdbi. I couldn't find a port for this so I created one. Actually I created two, one for libdbi and one for its drivers. The libdbi-drivers port has a variant for each of the drivers that I thought might be useful. The only one I've tested much is mysql. -- Ticket URL: <http://trac.macports.org/ticket/19425> MacPorts <http://www.macports.org/> Ports system for Mac OS
#19425: Add libdbi port ---------------------------+------------------------------------------------ Reporter: mta@… | Owner: macports-tickets@… Type: enhancement | Status: new Priority: Normal | Milestone: Port Submissions Component: ports | Version: 1.7.1 Keywords: | Port: libdbi libdbi-drivers ---------------------------+------------------------------------------------ Changes (by blb@…): * port: libdbi => libdbi libdbi-drivers Comment: libdbi added in r50096, thanks; two changes made to the port: - removed {{{:libdbi}}} from master_sites since the port's name is the default - used obfuscated form of maintainers libdbi-drivers needs some changes first: - don't hardcode /opt/local, use ${prefix} instead - the database variants will need to have a dependency on the proper database, and they should be named for the version to use; for example, instead of postgresql call it postgresql83 and add the following to it: {{{ depends_lib-append port:postgresql83 }}} then do the same for the other variants. - since building the port without any variants selected causes this to install nothing, which would causes issues and confusion, you should select a default if none is selected; I suggest sqlite3 since it's lightweight, so added the following: {{{ if {![variant_isset mysql5] && ![variant_isset postgresql83] && ![variant_isset sqlite] && ![variant_isset sqlite3]} { default_variants +sqlite3 } }}} Obviously add other variants you add if you want to also have support for other databases. - There is no port for msql currently, so that should be removed -- Ticket URL: <http://trac.macports.org/ticket/19425#comment:1> MacPorts <http://www.macports.org/> Ports system for Mac OS
#19425: Add libdbi port ----------------------------------+----------------------------------------- Reporter: mta@… | Owner: macports-tickets@… Type: submission | Status: new Priority: Normal | Component: ports Version: 1.7.1 | Keywords: Port: libdbi libdbi-drivers | ----------------------------------+----------------------------------------- Comment(by mta@…): Replying to [comment:1 blb@…]:
libdbi-drivers needs some changes first:
I submitted a new version of this port which I think fixed these problems, but it hasn't been committed yet. Are there further problems that I need to fix? -- Ticket URL: <http://trac.macports.org/ticket/19425#comment:4> MacPorts <http://www.macports.org/> Ports system for Mac OS
#19425: Add libdbi port ---------------------------+------------------------------------------------ Reporter: mta@… | Owner: macports-tickets@… Type: submission | Status: new Priority: Normal | Milestone: Component: ports | Version: 1.7.1 Keywords: | Port: libdbi libdbi-drivers ---------------------------+------------------------------------------------ Comment(by blb@…): +sqlite3 looks good, but trying +postgresql83 appears to need to be told how to find the headers: {{{ /usr/bin/gcc-4.0 -DHAVE_CONFIG_H -I. -I. -I../.. -I../.. -I../../include -I/mp/include -I/mp/include -I/mp/include -O20 -D__NO_MATH_INLINES -fsigned-char -MT dbd_pgsql.lo -MD -MP -MF .deps/dbd_pgsql.Tpo -c dbd_pgsql.c -fno-common -DPIC -o .libs/dbd_pgsql.o dbd_pgsql.c:56:22: error: libpq-fe.h: No such file or directory dbd_pgsql.c: In function '_dbd_real_connect': dbd_pgsql.c:156: error: 'PGconn' undeclared (first use in this function) dbd_pgsql.c:156: error: (Each undeclared identifier is reported only once dbd_pgsql.c:156: error: for each function it appears in.) dbd_pgsql.c:156: error: 'pgconn' undeclared (first use in this function) dbd_pgsql.c:217: error: 'CONNECTION_BAD' undeclared (first use in this function) ... }}} Similar issue with +mysql5: {{{ /usr/bin/gcc-4.0 -DHAVE_CONFIG_H -I. -I. -I../.. -I../.. -I../../include -I/mp/include -I/mp/include -I/mp/include -O20 -D__NO_MATH_INLINES -fsigned-char -MT dbd_mysql.lo -MD -MP -MF .deps/dbd_mysql.Tpo -c dbd_mysql.c -fno-common -DPIC -o .libs/dbd_mysql.o dbd_mysql.c:54:25: error: mysql/mysql.h: No such file or directory dbd_mysql.c:111: error: syntax error before '*' token dbd_mysql.c: In function 'dbd_connect': dbd_mysql.c:134: error: 'MYSQL' undeclared (first use in this function) dbd_mysql.c:134: error: (Each undeclared identifier is reported only once dbd_mysql.c:134: error: for each function it appears in.) dbd_mysql.c:134: error: 'mycon' undeclared (first use in this function) dbd_mysql.c:149: error: 'CLIENT_COMPRESS' undeclared (first use in this function) }}} -- Ticket URL: <http://trac.macports.org/ticket/19425#comment:5> MacPorts <http://www.macports.org/> Ports system for Mac OS
#19425: Add libdbi port ---------------------------+------------------------------------------------ Reporter: mta@… | Owner: macports-tickets@… Type: submission | Status: new Priority: Normal | Milestone: Component: ports | Version: 1.7.1 Keywords: | Port: libdbi libdbi-drivers ---------------------------+------------------------------------------------ Comment(by mta@…): I just attached a new Portfile that I think fixes the libdbi-driver problems. I also attached a new Portfile and associated patch file for libdbi since I discovered an endian bug in it today. I'm still running on a PPC machine and libdbi didn't return integer values correctly on that architecture. Both of these new Portfiles have a +debug variant that builds the library with debug symbols. If you don't like that, you can remove it. I find it useful for finding problems like this one. -- Ticket URL: <http://trac.macports.org/ticket/19425#comment:6> MacPorts <http://www.macports.org/> Ports system for Mac OS
#19425: Add libdbi port ---------------------------+------------------------------------------------ Reporter: mta@… | Owner: macports-tickets@… Type: submission | Status: new Priority: Normal | Milestone: Component: ports | Version: 1.7.1 Keywords: | Port: libdbi libdbi-drivers ---------------------------+------------------------------------------------ Comment(by mta@…): I just replaced the patch which fixes the endian problem in libdbi. The libdbi driver API supports 3 byte integers which are a rather unusual data type and my patch didn't handle them consistently with the rest of the code. -- Ticket URL: <http://trac.macports.org/ticket/19425#comment:7> MacPorts <http://www.macports.org/> Ports system for Mac OS
#19425: Add libdbi port ------------------------------------+--------------------------------------- Reporter: mta@… | Owner: macports-tickets@… Type: submission | Status: closed Priority: Normal | Milestone: Component: ports | Version: 1.7.1 Resolution: fixed | Keywords: Port: libdbi libdbi-drivers | ------------------------------------+--------------------------------------- Changes (by blb@…): * status: new => closed * resolution: => fixed Comment: libdbi updated in r52205, with a bump in revision since it modifies what is installed. libdbi-drivers added in r52206, thanks. -- Ticket URL: <http://trac.macports.org/ticket/19425#comment:8> MacPorts <http://www.macports.org/> Ports system for Mac OS
#19425: Add libdbi port ------------------------------------+--------------------------------------- Reporter: mta@… | Owner: macports-tickets@… Type: submission | Status: reopened Priority: Normal | Milestone: Component: ports | Version: 1.7.1 Resolution: | Keywords: Port: libdbi libdbi-drivers | ------------------------------------+--------------------------------------- Changes (by snc@…): * status: closed => reopened * resolution: fixed => Comment: Reopening to track the MySQL dependency's need to be fixed (should use path: instead of port:). -- Ticket URL: <http://trac.macports.org/ticket/19425#comment:9> MacPorts <http://www.macports.org/> Ports system for Mac OS
#19425: Add libdbi port -----------------------------+---------------------------------------------- Reporter: mta@… | Owner: snc@… Type: submission | Status: new Priority: Normal | Milestone: Component: ports | Version: 1.7.1 Resolution: | Keywords: Port: libdbi-drivers | -----------------------------+---------------------------------------------- Changes (by snc@…): * owner: macports-tickets@… => snc@… * status: reopened => new * port: libdbi libdbi-drivers => libdbi-drivers -- Ticket URL: <http://trac.macports.org/ticket/19425#comment:10> MacPorts <http://www.macports.org/> Ports system for Mac OS
#19425: Add libdbi port -----------------------------+---------------------------------------------- Reporter: mta@… | Owner: snc@… Type: submission | Status: closed Priority: Normal | Milestone: Component: ports | Version: 1.7.1 Resolution: fixed | Keywords: Port: libdbi-drivers | -----------------------------+---------------------------------------------- Changes (by ryandesign@…): * status: new => closed * resolution: => fixed Comment: Replying to [comment:9 snc@…]:
Reopening to track the MySQL dependency's need to be fixed (should use path: instead of port:). Done in r52353.
-- Ticket URL: <http://trac.macports.org/ticket/19425#comment:11> MacPorts <http://www.macports.org/> Ports system for Mac OS
participants (1)
-
MacPorts