1 *cdf0e10cSrcweir---------- Status ------------------------------------------------------------- 2 *cdf0e10cSrcweir 3 *cdf0e10cSrcweirThe code is on a PREVIEW level. PREVIEW means pre-alpha. 4 *cdf0e10cSrcweir 5 *cdf0e10cSrcweir---------- Requirements ------------------------------------------------------- 6 *cdf0e10cSrcweir 7 *cdf0e10cSrcweirThe MySQL driver for OpenOffice.org (MySQL Connector/OpenOffice.org - C/OOo) 8 *cdf0e10cSrcweirrequires two external libraries to be build: 9 *cdf0e10cSrcweir 10 *cdf0e10cSrcweir 1) The MySQL Client Library (libmysql) 11 *cdf0e10cSrcweir 2) The MySQL Connector/C++ Library (libmysqlcppcon) 12 *cdf0e10cSrcweir 13 *cdf0e10cSrcweirAt the time of writing neither of the two libraries are part of the CWS! 14 *cdf0e10cSrcweirBefore you can build the MySQL driver for OpenOffice.org you must install 15 *cdf0e10cSrcweirthe two required libraries on your system before you can compile the driver. 16 *cdf0e10cSrcweir 17 *cdf0e10cSrcweirYou need the two libraries because the MySQL driver for OpenOffice.org 18 *cdf0e10cSrcweirdoes not feature an implementation of the MySQL Client Server 19 *cdf0e10cSrcweircommunication protocol. The protocol implementation is part of the MySQL 20 *cdf0e10cSrcweirClient Library. And the SDBC(X) style OpenOffice.org driver is implemented as a 21 *cdf0e10cSrcweirwrapper of the MySQL Connector/C++ Library which implements a JDBC interface and 22 *cdf0e10cSrcweirin turn uses the C based MySQL Client Library. 23 *cdf0e10cSrcweir 24 *cdf0e10cSrcweir1) MySQL Client Library (libmysql) 25 *cdf0e10cSrcweir 26 *cdf0e10cSrcweirThe MySQL Client Library (libmysql) is part of the MySQL Server. You need to 27 *cdf0e10cSrcweirdownload and install the MySQL Server. Use a binary distribution of 28 *cdf0e10cSrcweirMySQL 5.0.x or MySQL 5.1.x. Check the MySQL manual for instructions, e.g. 29 *cdf0e10cSrcweirfor Unix: 30 *cdf0e10cSrcweir 31 *cdf0e10cSrcweir http://dev.mysql.com/doc/refman/5.1/en/installing-binary.html 32 *cdf0e10cSrcweir 33 *cdf0e10cSrcweirThe typical installation path of the libmysql.so on Unix is 34 *cdf0e10cSrcweir/usr/local/mysql/lib/mysql/ . 35 *cdf0e10cSrcweir 36 *cdf0e10cSrcweir2) MySQL Connector/C++ (libmysqlcppcon) 37 *cdf0e10cSrcweir 38 *cdf0e10cSrcweirDownload and install the latest version of the MySQL Connector/C++, see 39 *cdf0e10cSrcweirhttp://forge.mysql.com/wiki/Connector_C++ . Check out the source 40 *cdf0e10cSrcweirfrom the bzr repository. 41 *cdf0e10cSrcweir 42 *cdf0e10cSrcweir3) Tweaking library paths 43 *cdf0e10cSrcweir 44 *cdf0e10cSrcweirAt the time of writing you might have to *manually* tweak library paths and 45 *cdf0e10cSrcweirlibrary names by patching makefile.mk. This is a temporary hack. The makefile 46 *cdf0e10cSrcweirwill be improved later. 47 *cdf0e10cSrcweir 48 *cdf0e10cSrcweirHowever, for the moment check the makefile.mk if the compilation fails due to 49 *cdf0e10cSrcweir"missing" libraries (= libraries not found). For example, check the following 50 *cdf0e10cSrcweirsettings: 51 *cdf0e10cSrcweir 52 *cdf0e10cSrcweir MYSQL_INCDIR=/usr/local/include 53 *cdf0e10cSrcweir MYSQL_LIBDIR=/usr/local/lib 54 *cdf0e10cSrcweir [...] 55 *cdf0e10cSrcweir MYSQL_INCDIR=/usr/local/include 56 *cdf0e10cSrcweir MYSQL_LIBDIR=/usr/local/lib 57 *cdf0e10cSrcweir [...] 58 *cdf0e10cSrcweir MYSQL_INC=-I$(MYSQL_INCDIR) 59 *cdf0e10cSrcweir MYSQL_LIB=-L$(MYSQL_LIBDIR) -lmysqlclient -rdynamic -lz -lcrypt -lnsl -lm 60 *cdf0e10cSrcweir MYSQL_LIBFILE=$(MYSQL_LIBDIR)$/libmysqlclient.so.16 61 *cdf0e10cSrcweir MYSQL_CPPCONN_LIBFILE=$(MYSQL_LIBDIR)$/libmysqlcppconn.so 62 *cdf0e10cSrcweir [...] 63 *cdf0e10cSrcweir 64 *cdf0e10cSrcweirA common issue is libmysqlclient.so.15 vs. libmysqlclient.so.16 . 65 *cdf0e10cSrcweir 66