ports/113538: databases/unixODBC fails to copy required INI files for MySQL ODBC (creates useless empty INI files) - needed for OpenOffice

[User1001]

>Number:         113538
>Category:       ports
>Synopsis:       databases/unixODBC fails to copy required INI files for MySQL ODBC (creates useless empty INI files) - needed for OpenOffice
>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:   Sun Jun 10 18:30:04 GMT 2007
>Closed-Date:
>Last-Modified:
>Originator:     User1001
>Release:        FreeBSD 6.2-STABLE i386
>Organization:
>Environment:


System: FreeBSD 6.2-STABLE #5: Sat May 12 09:17:19 CDT 2007

unixODBC-2.2.12

mysql-administrator-1.1.10 Powerful visual administration console for MySQL environmen
mysql-client-5.1.15 Multithreaded SQL database (client)
mysql-connector-java-5.0.5 MySQL Connector/J: JDBC interface for MySQL
mysql-connector-odbc-unixodbc-mysql51-3.51.12_1 ODBC driver for MySQL51 / unixodbc
mysql-query-browser-1.1.18 A database querying tool for MySQL servers
mysql-scripts-5.1.19 Multithreaded SQL database (scripts)
mysql-server-5.1.15 Multithreaded SQL database (server)
p5-DBD-mysql51-4.003 MySQL 5.1 driver for the Perl5 Database Interface (DBI)


openoffice.org-2.2.0 Integrated wordprocessor/dbase/spreadsheet/drawing/chart/br


>Description:


Installing unixODBC "as is" creates two empty INI files in /usr/local/etc,

Makefile:       -touch $(DESTDIR)${sysconfdir}/odbcinst.ini
Makefile:       -touch $(DESTDIR)${sysconfdir}/odbc.ini

In order to use ODBC with OpenOffice/MySQL ODBC, proper INI files are required. While the MySQL DRIVER is not built, the requisite INI files for MySQL DO exist in /Drivers/MySQL

./Drivers/MySQL/iodbc.ini
./Drivers/MySQL/odbc.ini

I am not sure what to do about the unixODBC/Makefile which creates the empty INI files, which are really useless as is. Perhaps the Makefile should be patched to NOT create the empty INI files, but I will leave that decision up to somebody else.

With the appropriate MySQL ODBC INI files in place, access to and use of MySQL databases from OpenOffice-2 works.



>How-To-Repeat:


make install


>Fix:


--- pkg-message begins here ---
-----------------------------------------------
If installing for MySQL, then copy (or move)
the "/usr/local/etc/odbc.ini.user" file to
your HOME directory as ".odbc.ini", and modify
to define specific MySQL database(s).
-----------------------------------------------
--- pkg-message ends here ---


--- patch.Makefile begins here ---
--- Makefile.orig	Wed Dec 20 21:53:53 2006
+++ Makefile	Sun Jun 10 13:07:01 2007
@@ -56,5 +56,10 @@
 	@${CHOWN} -R ${SHAREOWN}:${SHAREGRP} ${DOCSDIR}
 .endif
 .endif
+.if defined(WITH_MYSQL)
+	@${CP} -p ${WRKSRC}/Drivers/MySQL/iodbc.ini ${PREFIX}/etc/odbc.ini.user
+	@${CP} -p ${WRKSRC}/Drivers/MySQL/odbc.ini ${PREFIX}/etc/odbc.ini
+	@${ECHO} pkg-message
+.endif
 
 .include <bsd.port.mk>
--- patch.Makefile ends here ---



>Release-Note:
>Audit-Trail:
>Unformatted: