Configuring MySQL using ODBC and Mac App Store versions of NeoOffice

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 04:09, 28 March 2015 (edit)
( | contribs)
m (Configuring MySQL using ODBC and NeoOffice Secure Edition moved to Configuring MySQL using ODBC and Mac App Store versions of NeoOffice)
← Previous diff
Revision as of 04:03, 2 July 2015 (edit) (undo)
( | contribs)
(Move alert box to top of article)
Next diff →
(2 intermediate revisions not shown.)
Line 1: Line 1:
-While NeoOffice 2013 and higher - also known as NeoOffice Secure Edition - cannot use JDBC drivers, NeoOffice Secure Edition can connect to MySQL servers using ODBC.+{{alertbox2|'''Base users:''' if you use Base, we recommend that you use [http://www.neooffice.org/neojava/download.php NeoOffice 3.4.1]. The Base features in Mac App Store versions of NeoOffice are much more limited than in NeoOffice 3.4.1.}}
-Please note that you must use the steps listed below to use MySQL's ODBC driver in NeoOffice Secure Edition. These special steps are necesary because NeoOffice Secure Edition is sold in Apple's Mac App Store and applications in Apple's Mac App Store must implement several security requirements. Unfortunately, Apple's security requirements make MySQL's default ODBC driver installation inaccessible to NeoOffice Secure Edition.+While Mac App Store versions of NeoOffice cannot use JDBC drivers, Mac App Store versions of NeoOffice can connect to MySQL servers using ODBC.
-{{alertbox2|NeoOffice Secure Edition cannot open Base reports so if you need to use Base reports, the NeoOffice developers recommend that you use [http://www.openoffice.org/ Apache OpenOffice] with the [http://extensions.openoffice.org/en/project/oracle-report-builder Oracle Report Builder extension] instead.}}+Please note that you must use the steps listed below to use MySQL's ODBC driver in Mac App Store versions of NeoOffice. These special steps are necessary because applications in Apple's Mac App Store must implement several security requirements. Unfortunately, Apple's security requirements make MySQL's default ODBC driver installation inaccessible to Mac App Store versions of NeoOffice.
-#Download the .tar.gz for MySQL's ODBC driver (32 bit for NeoOffice 2013 and 64 bit for NeoOffice 2014 and higher). The .tar.gz must be used because the .dmg installer will not work with applications that run in Apple's App Sandbox.+#Download the .tar.gz for MySQL's 64 bit ODBC driver. The .tar.gz must be used because the .dmg installer will not work with applications that run in Apple's App Sandbox.
#Double-click on the downloaded .tar.gz file to unpack it. That should create a folder with name starting with "mysql-connector-odbc". Move that folder to your <tt>~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data</tt> folder (note: "~" means your Home folder). #Double-click on the downloaded .tar.gz file to unpack it. That should create a folder with name starting with "mysql-connector-odbc". Move that folder to your <tt>~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data</tt> folder (note: "~" means your Home folder).
#If your DSN definitions are in the <tt>/Library/ODBC</tt> folder or <tt>~/Library/ODBC</tt> folder, copy the applicable folder into your <tt>~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library</tt> folder. #If your DSN definitions are in the <tt>/Library/ODBC</tt> folder or <tt>~/Library/ODBC</tt> folder, copy the applicable folder into your <tt>~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library</tt> folder.
Line 11: Line 11:
#Open the <tt>~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/ODBC/odbcinst.ini</tt> file that you created in a text editor and replace any occurrences of "/usr/local/lib" with "/Users/<username>/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/<mysql>". Note: replace "<username>" with your Mac user account name and "<mysql>" with the name of the folder that you moved in step 2 above. #Open the <tt>~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/ODBC/odbcinst.ini</tt> file that you created in a text editor and replace any occurrences of "/usr/local/lib" with "/Users/<username>/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/<mysql>". Note: replace "<username>" with your Mac user account name and "<mysql>" with the name of the folder that you moved in step 2 above.
-If you did the above correctly and your MySQL server is running, you should be able to connect to the MySQL server from Base in NeoOffice Secure Edition.+If you did the above correctly and your MySQL server is running, you should be able to connect to the MySQL server from Base in Mac App Store versions of NeoOffice.
==References== ==References==

Revision as of 04:03, 2 July 2015

Warning! (click icon for its license info) Base users: if you use Base, we recommend that you use NeoOffice 3.4.1. The Base features in Mac App Store versions of NeoOffice are much more limited than in NeoOffice 3.4.1.

While Mac App Store versions of NeoOffice cannot use JDBC drivers, Mac App Store versions of NeoOffice can connect to MySQL servers using ODBC.

Please note that you must use the steps listed below to use MySQL's ODBC driver in Mac App Store versions of NeoOffice. These special steps are necessary because applications in Apple's Mac App Store must implement several security requirements. Unfortunately, Apple's security requirements make MySQL's default ODBC driver installation inaccessible to Mac App Store versions of NeoOffice.

  1. Download the .tar.gz for MySQL's 64 bit ODBC driver. The .tar.gz must be used because the .dmg installer will not work with applications that run in Apple's App Sandbox.
  2. Double-click on the downloaded .tar.gz file to unpack it. That should create a folder with name starting with "mysql-connector-odbc". Move that folder to your ~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data folder (note: "~" means your Home folder).
  3. If your DSN definitions are in the /Library/ODBC folder or ~/Library/ODBC folder, copy the applicable folder into your ~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library folder.
  4. Open the ~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/ODBC/odbc.ini file that you created in the previous step in a text editor and replace any occurrences of "localhost" with "127.0.0.1". Using "localhost" will cause the MySQL ODBC driver to use the /tmp/mysql.sock file to connect to the database and that file is not accessible to applications running in Apple's App Sandbox.
  5. Open the ~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/ODBC/odbcinst.ini file that you created in a text editor and replace any occurrences of "/usr/local/lib" with "/Users/<username>/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/<mysql>". Note: replace "<username>" with your Mac user account name and "<mysql>" with the name of the folder that you moved in step 2 above.

If you did the above correctly and your MySQL server is running, you should be able to connect to the MySQL server from Base in Mac App Store versions of NeoOffice.

References

Personal tools