https://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice&limit=20&action=history&feed=atomConfiguring MySQL using ODBC and Mac App Store versions of NeoOffice - Revision history2024-03-29T14:26:14ZRevision history for this page on the wikiMediaWiki 1.10.1https://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice&diff=18167&oldid=prevPluby: Update version to be more generic2018-06-26T15:00:03Z<p>Update version to be more generic</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 15:00, 26 June 2018</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{alertbox2|'''Base users:''' if you use Base, we recommend that you use [http://www.neooffice.org/neojava/download.php NeoOffice <del style="color: red; font-weight: bold; text-decoration: none;">3.4.1</del>]. The Base features in Mac App Store versions of NeoOffice are much more limited than in NeoOffice <del style="color: red; font-weight: bold; text-decoration: none;">3.4.1</del>.}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">{{alertbox2|'''Base users:''' if you use Base, we recommend that you use [http://www.neooffice.org/neojava/download.php NeoOffice <ins style="color: red; font-weight: bold; text-decoration: none;">Professional Edition or NeoOffice Classic Edition</ins>]. The Base features in Mac App Store versions of NeoOffice are much more limited than in NeoOffice <ins style="color: red; font-weight: bold; text-decoration: none;">Professional Edition or NeoOffice Classic Edition</ins>.}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">While Mac App Store versions of NeoOffice cannot use JDBC drivers, Mac App Store versions of NeoOffice can connect to MySQL servers using ODBC.</td><td> </td><td style="background: #eee; font-size: smaller;">While Mac App Store versions of NeoOffice cannot use JDBC drivers, Mac App Store versions of NeoOffice can connect to MySQL servers using ODBC.</td></tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice&diff=17380&oldid=prevPluby: Move alert box to top of article2015-07-02T04:03:07Z<p>Move alert box to top of article</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 04:03, 2 July 2015</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">{{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.}}</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">While Mac App Store versions of NeoOffice cannot use JDBC drivers, Mac App Store versions of NeoOffice can connect to MySQL servers using ODBC.</td><td> </td><td style="background: #eee; font-size: smaller;">While Mac App Store versions of NeoOffice cannot use JDBC drivers, Mac App Store versions of NeoOffice can connect to MySQL servers using ODBC.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">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.</td><td> </td><td style="background: #eee; font-size: smaller;">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.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"></td><td colspan="2"> </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{alertbox2|Mac App Store versions of NeoOffice cannot open Base reports so if you need to use Base reports, the NeoOffice developers recommend that you use [http://www.neooffice.org/neojava/download.php NeoOffice 3.4.1]}}</td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#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.</td><td> </td><td style="background: #eee; font-size: smaller;">#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.</td></tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice&diff=17379&oldid=prevPluby: Replace OpenOffice link with link to NeoOffice 3.4.12015-07-02T02:24:10Z<p>Replace OpenOffice link with link to NeoOffice 3.4.1</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 02:24, 2 July 2015</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">While NeoOffice <del style="color: red; font-weight: bold; text-decoration: none;">2013 and higher </del>cannot use JDBC drivers, Mac App Store versions of NeoOffice can connect to MySQL servers using ODBC.</td><td>+</td><td style="background: #cfc; font-size: smaller;">While <ins style="color: red; font-weight: bold; text-decoration: none;">Mac App Store versions of </ins>NeoOffice cannot use JDBC drivers, Mac App Store versions of NeoOffice can connect to MySQL servers using ODBC.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">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 <del style="color: red; font-weight: bold; text-decoration: none;">NeoOffice 2013 and higher is sold in Apple's Mac App Store and </del>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.</td><td>+</td><td style="background: #cfc; font-size: smaller;">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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{alertbox2|Mac App Store versions of NeoOffice cannot open Base reports so if you need to use Base reports, the NeoOffice developers recommend that you use [http://www.<del style="color: red; font-weight: bold; text-decoration: none;">openoffice</del>.org/ <del style="color: red; font-weight: bold; text-decoration: none;">Apache OpenOffice] with the [http:</del>/<del style="color: red; font-weight: bold; text-decoration: none;">/extensions</del>.<del style="color: red; font-weight: bold; text-decoration: none;">openoffice</del>.<del style="color: red; font-weight: bold; text-decoration: none;">org/en/project/oracle-report-builder Oracle Report Builder extension</del>] <del style="color: red; font-weight: bold; text-decoration: none;">instead.</del>}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">{{alertbox2|Mac App Store versions of NeoOffice cannot open Base reports so if you need to use Base reports, the NeoOffice developers recommend that you use [http://www.<ins style="color: red; font-weight: bold; text-decoration: none;">neooffice</ins>.org/<ins style="color: red; font-weight: bold; text-decoration: none;">neojava</ins>/<ins style="color: red; font-weight: bold; text-decoration: none;">download</ins>.<ins style="color: red; font-weight: bold; text-decoration: none;">php NeoOffice 3</ins>.<ins style="color: red; font-weight: bold; text-decoration: none;">4.1</ins>]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Download the .tar.gz for MySQL's ODBC driver <del style="color: red; font-weight: bold; text-decoration: none;">(32 bit for NeoOffice 2013 and 64 bit for NeoOffice 2014 and higher)</del>. The .tar.gz must be used because the .dmg installer will not work with applications that run in Apple's App Sandbox.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#Download the .tar.gz for MySQL's <ins style="color: red; font-weight: bold; text-decoration: none;">64 bit </ins>ODBC driver. The .tar.gz must be used because the .dmg installer will not work with applications that run in Apple's App Sandbox.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#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).</td><td> </td><td style="background: #eee; font-size: smaller;">#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).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#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.</td><td> </td><td style="background: #eee; font-size: smaller;">#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.</td></tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice&diff=17323&oldid=prevPluby: Replace "Secure Edition" in product name2015-03-28T04:13:31Z<p>Replace "Secure Edition" in product name</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 04:13, 28 March 2015</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">While NeoOffice 2013 and higher <del style="color: red; font-weight: bold; text-decoration: none;">- also known as NeoOffice Secure Edition - </del>cannot use JDBC drivers, <del style="color: red; font-weight: bold; text-decoration: none;"> </del>NeoOffice <del style="color: red; font-weight: bold; text-decoration: none;">Secure Edition </del>can connect to MySQL servers using ODBC.</td><td>+</td><td style="background: #cfc; font-size: smaller;">While NeoOffice 2013 and higher cannot use JDBC drivers, <ins style="color: red; font-weight: bold; text-decoration: none;">Mac App Store versions of </ins>NeoOffice can connect to MySQL servers using ODBC.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">Please note that you must use the steps listed below to use MySQL's ODBC driver in NeoOffice <del style="color: red; font-weight: bold; text-decoration: none;">Secure Edition</del>. These special steps are <del style="color: red; font-weight: bold; text-decoration: none;">necesary </del>because NeoOffice <del style="color: red; font-weight: bold; text-decoration: none;">Secure Edition </del>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 <del style="color: red; font-weight: bold; text-decoration: none;">Secure Edition</del>.</td><td>+</td><td style="background: #cfc; font-size: smaller;">Please note that you must use the steps listed below to use MySQL's ODBC driver in <ins style="color: red; font-weight: bold; text-decoration: none;">Mac App Store versions of </ins>NeoOffice. These special steps are <ins style="color: red; font-weight: bold; text-decoration: none;">necessary </ins>because NeoOffice <ins style="color: red; font-weight: bold; text-decoration: none;">2013 and higher </ins>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 <ins style="color: red; font-weight: bold; text-decoration: none;">Mac App Store versions of </ins>NeoOffice.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{alertbox2|NeoOffice <del style="color: red; font-weight: bold; text-decoration: none;">Secure Edition </del>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.}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">{{alertbox2|<ins style="color: red; font-weight: bold; text-decoration: none;">Mac App Store versions of </ins>NeoOffice 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.}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#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.</td><td> </td><td style="background: #eee; font-size: smaller;">#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.</td></tr>
<tr><td colspan="2" align="left"><strong>Line 11:</strong></td>
<td colspan="2" align="left"><strong>Line 11:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#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.</td><td> </td><td style="background: #eee; font-size: smaller;">#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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">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 <del style="color: red; font-weight: bold; text-decoration: none;">Secure Edition</del>.</td><td>+</td><td style="background: #cfc; font-size: smaller;">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 <ins style="color: red; font-weight: bold; text-decoration: none;">Mac App Store versions of </ins>NeoOffice.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==References==</td><td> </td><td style="background: #eee; font-size: smaller;">==References==</td></tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice&diff=17321&oldid=prevPluby: Configuring MySQL using ODBC and NeoOffice Secure Edition moved to Configuring MySQL using ODBC and Mac App Store versions of NeoOffice2015-03-28T04:09:32Z<p><a href="/index.php/Configuring_MySQL_using_ODBC_and_NeoOffice_Secure_Edition" title="Configuring MySQL using ODBC and NeoOffice Secure Edition">Configuring MySQL using ODBC and NeoOffice Secure Edition</a> moved to <a href="/index.php/Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice" title="Configuring MySQL using ODBC and Mac App Store versions of NeoOffice">Configuring MySQL using ODBC and Mac App Store versions of NeoOffice</a></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 04:09, 28 March 2015</td>
</tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice&diff=17127&oldid=prevPluby: Make warning of when to use OpenOffice when data store is MySQL2014-05-27T23:07:33Z<p>Make warning of when to use OpenOffice when data store is MySQL</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 23:07, 27 May 2014</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 3:</strong></td>
<td colspan="2" align="left"><strong>Line 3:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">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.</td><td> </td><td style="background: #eee; font-size: smaller;">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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{alertbox2|<del style="color: red; font-weight: bold; text-decoration: none;">If </del>you <del style="color: red; font-weight: bold; text-decoration: none;">do a significant amount of work with databases</del>, 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.}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">{{alertbox2|<ins style="color: red; font-weight: bold; text-decoration: none;">NeoOffice Secure Edition cannot open Base reports so if </ins>you <ins style="color: red; font-weight: bold; text-decoration: none;">need to use Base reports</ins>, 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.}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#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.</td><td> </td><td style="background: #eee; font-size: smaller;">#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.</td></tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice&diff=17126&oldid=prevPluby: Remove warnings about using ODBC now that 64 bit bugs have been fixed2014-05-27T23:03:57Z<p>Remove warnings about using ODBC now that 64 bit bugs have been fixed</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 23:03, 27 May 2014</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">{{handbook sidebar|DatabaseTOC}} {{fixme}}</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">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.</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">The security restrictions of Apple’s “App Sandbox†place many limitations on applications available from </del>the <del style="color: red; font-weight: bold; text-decoration: none;">Mac App Store, including </del>NeoOffice Secure Edition <del style="color: red; font-weight: bold; text-decoration: none;">(</del>NeoOffice <del style="color: red; font-weight: bold; text-decoration: none;">2013 </del>and <del style="color: red; font-weight: bold; text-decoration: none;">2014)</del>. <del style="color: red; font-weight: bold; text-decoration: none;"> This particularly affects NeoOffice’s [[NeoBase|Base]] component. {{alertbox2|If you do a significant amount of work with databases</del>, <del style="color: red; font-weight: bold; text-decoration: none;">the </del>NeoOffice <del style="color: red; font-weight: bold; text-decoration: none;">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</del>.<del style="color: red; font-weight: bold; text-decoration: none;">}}</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">Please note that you must use </ins>the <ins style="color: red; font-weight: bold; text-decoration: none;">steps listed below to use MySQL's ODBC driver in </ins>NeoOffice Secure Edition<ins style="color: red; font-weight: bold; text-decoration: none;">. These special steps are necesary because </ins>NeoOffice <ins style="color: red; font-weight: bold; text-decoration: none;">Secure Edition is sold in Apple's Mac App Store </ins>and <ins style="color: red; font-weight: bold; text-decoration: none;">applications in Apple's Mac App Store must implement several security requirements</ins>. <ins style="color: red; font-weight: bold; text-decoration: none;">Unfortunately</ins>, <ins style="color: red; font-weight: bold; text-decoration: none;">Apple's security requirements make MySQL's default ODBC driver installation inaccessible to </ins>NeoOffice <ins style="color: red; font-weight: bold; text-decoration: none;">Secure Edition</ins>.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{alertbox2|If you <del style="color: red; font-weight: bold; text-decoration: none;">wish to continue using NeoOffice 2013/2014 for database </del>work, the NeoOffice developers [<del style="color: red; font-weight: bold; text-decoration: none;">https</del>://<del style="color: red; font-weight: bold; text-decoration: none;">trinity</del>.<del style="color: red; font-weight: bold; text-decoration: none;">neooffice</del>.org/<del style="color: red; font-weight: bold; text-decoration: none;">modules.php%3fname%3dForums%26file%3dviewtopic%26p%3d64779%2364779 recommend</del>]<del style="color: red; font-weight: bold; text-decoration: none;"><!-- sucks to have to encode all those characters for this to work </del>:<del style="color: red; font-weight: bold; text-decoration: none;">P </del>--<del style="color: red; font-weight: bold; text-decoration: none;">> using a [[Working_with_dBase_databases|dBase</del>]<del style="color: red; font-weight: bold; text-decoration: none;">] database </del>instead<del style="color: red; font-weight: bold; text-decoration: none;">, because Base experiences a number of bugs when using MySQL’s OBDC drivers</del>.}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">{{alertbox2|If you <ins style="color: red; font-weight: bold; text-decoration: none;">do a significant amount of </ins>work <ins style="color: red; font-weight: bold; text-decoration: none;">with databases</ins>, the NeoOffice developers <ins style="color: red; font-weight: bold; text-decoration: none;">recommend that you use </ins>[<ins style="color: red; font-weight: bold; text-decoration: none;">http</ins>://<ins style="color: red; font-weight: bold; text-decoration: none;">www</ins>.<ins style="color: red; font-weight: bold; text-decoration: none;">openoffice</ins>.org/ <ins style="color: red; font-weight: bold; text-decoration: none;">Apache OpenOffice</ins>] <ins style="color: red; font-weight: bold; text-decoration: none;">with the [http</ins>:<ins style="color: red; font-weight: bold; text-decoration: none;">//extensions.openoffice.org/en/project/oracle</ins>-<ins style="color: red; font-weight: bold; text-decoration: none;">report</ins>-<ins style="color: red; font-weight: bold; text-decoration: none;">builder Oracle Report Builder extension</ins>] instead.}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">{{alertbox2|However, if you wish </del>to <del style="color: red; font-weight: bold; text-decoration: none;">proceed </del>with <del style="color: red; font-weight: bold; text-decoration: none;">MySQL </del>in <del style="color: red; font-weight: bold; text-decoration: none;">spite of these warnings</del>, you <del style="color: red; font-weight: bold; text-decoration: none;">can </del>use the <del style="color: red; font-weight: bold; text-decoration: none;">following steps </del>to connect to <del style="color: red; font-weight: bold; text-decoration: none;">a MySQL </del>database <del style="color: red; font-weight: bold; text-decoration: none;">via OBDC</del>.<del style="color: red; font-weight: bold; text-decoration: none;">}}</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#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.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Double-click on the downloaded .tar.gz file </ins>to <ins style="color: red; font-weight: bold; text-decoration: none;">unpack it. That should create a folder </ins>with <ins style="color: red; font-weight: bold; text-decoration: none;">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).</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#If your DSN definitions are </ins>in <ins style="color: red; font-weight: bold; text-decoration: none;">the <tt>/Library/ODBC</tt> folder or <tt>~/Library/ODBC</tt> folder</ins>, <ins style="color: red; font-weight: bold; text-decoration: none;">copy the applicable folder into your <tt>~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library</tt> folder.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Open the <tt>~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/ODBC/odbc.ini</tt> file that </ins>you <ins style="color: red; font-weight: bold; text-decoration: none;">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 </ins>use the <ins style="color: red; font-weight: bold; text-decoration: none;"><tt>/tmp/mysql.sock</tt> file </ins>to connect to <ins style="color: red; font-weight: bold; text-decoration: none;">the </ins>database <ins style="color: red; font-weight: bold; text-decoration: none;">and that file is not accessible to applications running in Apple's App Sandbox.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#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</ins>.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#Download the .tar.gz for MySQL's ODBC driver (32 bit for NeoOffice 2013 and 64 bit for NeoOffice 2014). The .dmg driver will not work with applications that run in Apple's App Sandbox.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">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 <ins style="color: red; font-weight: bold; text-decoration: none;">Secure Edition</ins>.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#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).</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#If your DSN definitions are in the ~/Library/ODBC folder, copy that folder into your ~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library folder.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#Open the ~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/ODBC/odbc.ini that you created 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.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#Open the ~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/ODBC/odbcinst.ini that you created in a text editor and replace any occurrences of "/usr/local/lib" with " /Users/<your>/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/<mysql>". Note: replace "<your>" with your Mac user account name and "<mysql>" with the name of the folder that you moved in step 2 above.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">If you did the above correctly and your MySQL server is running, you should be able to connect to the MySQL server from <del style="color: red; font-weight: bold; text-decoration: none;">BASE in NeoOffice 2013 or 2014. Note, however, that when you create a new .odb file that connects to your MySQL server, </del>Base <del style="color: red; font-weight: bold; text-decoration: none;">will not display any existing tables but you can query such tables using SQL. This is one of the problems that caused me to recommend using a dBASE database if you were using an HSQLDB database </del>in NeoOffice <del style="color: red; font-weight: bold; text-decoration: none;">3.x or OpenOffice</del>. </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==References==</td><td> </td><td style="background: #eee; font-size: smaller;">==References==</td></tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice&diff=17122&oldid=prevSardisson: link to dbase article, since the NeoSE changes for dBase are limited2014-05-20T05:31:35Z<p>link to dbase article, since the NeoSE changes for dBase are limited</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 05:31, 20 May 2014</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 3:</strong></td>
<td colspan="2" align="left"><strong>Line 3:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">The security restrictions of Apple’s “App Sandbox†place many limitations on applications available from the Mac App Store, including NeoOffice Secure Edition (NeoOffice 2013 and 2014). This particularly affects NeoOffice’s [[NeoBase|Base]] component. {{alertbox2|If you do a significant amount of work with databases, 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.}}</td><td> </td><td style="background: #eee; font-size: smaller;">The security restrictions of Apple’s “App Sandbox†place many limitations on applications available from the Mac App Store, including NeoOffice Secure Edition (NeoOffice 2013 and 2014). This particularly affects NeoOffice’s [[NeoBase|Base]] component. {{alertbox2|If you do a significant amount of work with databases, 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.}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{alertbox2|If you wish to continue using NeoOffice 2013/2014 for database work, the NeoOffice developers [https://trinity.neooffice.org/modules.php%3fname%3dForums%26file%3dviewtopic%26p%3d64779%2364779 recommend]<!-- sucks to have to encode all those characters for this to work :P --> using a dBase database instead, because Base experiences a number of bugs when using MySQL’s OBDC drivers.}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">{{alertbox2|If you wish to continue using NeoOffice 2013/2014 for database work, the NeoOffice developers [https://trinity.neooffice.org/modules.php%3fname%3dForums%26file%3dviewtopic%26p%3d64779%2364779 recommend]<!-- sucks to have to encode all those characters for this to work :P --> using a <ins style="color: red; font-weight: bold; text-decoration: none;">[[Working_with_dBase_databases|</ins>dBase<ins style="color: red; font-weight: bold; text-decoration: none;">]] </ins>database instead, because Base experiences a number of bugs when using MySQL’s OBDC drivers.}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{alertbox2|However, if you wish to proceed with MySQL in spite of these warnings, you can use the following steps to connect to a MySQL database via OBDC.}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{alertbox2|However, if you wish to proceed with MySQL in spite of these warnings, you can use the following steps to connect to a MySQL database via OBDC.}}</td></tr>
</table>Sardissonhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_ODBC_and_Mac_App_Store_versions_of_NeoOffice&diff=17121&oldid=prevSardisson: dump of Patrick's post2014-05-20T05:29:01Z<p>dump of Patrick's post</p>
<p><b>New page</b></p><div>{{handbook sidebar|DatabaseTOC}} {{fixme}}<br />
<br />
The security restrictions of Apple’s “App Sandbox†place many limitations on applications available from the Mac App Store, including NeoOffice Secure Edition (NeoOffice 2013 and 2014). This particularly affects NeoOffice’s [[NeoBase|Base]] component. {{alertbox2|If you do a significant amount of work with databases, 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.}}<br />
<br />
{{alertbox2|If you wish to continue using NeoOffice 2013/2014 for database work, the NeoOffice developers [https://trinity.neooffice.org/modules.php%3fname%3dForums%26file%3dviewtopic%26p%3d64779%2364779 recommend]<!-- sucks to have to encode all those characters for this to work :P --> using a dBase database instead, because Base experiences a number of bugs when using MySQL’s OBDC drivers.}}<br />
<br />
{{alertbox2|However, if you wish to proceed with MySQL in spite of these warnings, you can use the following steps to connect to a MySQL database via OBDC.}}<br />
<br />
#Download the .tar.gz for MySQL's ODBC driver (32 bit for NeoOffice 2013 and 64 bit for NeoOffice 2014). The .dmg driver will not work with applications that run in Apple's App Sandbox.<br />
#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).<br />
#If your DSN definitions are in the ~/Library/ODBC folder, copy that folder into your ~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library folder.<br />
#Open the ~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/ODBC/odbc.ini that you created 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.<br />
#Open the ~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/ODBC/odbcinst.ini that you created in a text editor and replace any occurrences of "/usr/local/lib" with " /Users/<your>/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/<mysql>". Note: replace "<your>" with your Mac user account name and "<mysql>" with the name of the folder that you moved in step 2 above.<br />
<br />
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 2013 or 2014. Note, however, that when you create a new .odb file that connects to your MySQL server, Base will not display any existing tables but you can query such tables using SQL. This is one of the problems that caused me to recommend using a dBASE database if you were using an HSQLDB database in NeoOffice 3.x or OpenOffice. <br />
<br />
==References==<br />
<br />
* [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=64784#64784 trinity post]<br />
<br />
<br />
<!--{{botlangbarEN|[[Fr:Configurer_MySQL_avec_JDBC_et_NeoOffice_2.0|Français]]}}--><br />
[[Category:NeoOffice]][[Category:Tips and Hints]]</div>Sardisson