From: Steve P. <n9...@n9...> - 2016-02-20 02:34:06
|
One more note... I just built the sources from Github and installed them: https://github.com/openlink/iODBC First thing I noticed that was a pleasant surprise is that the CONFIGURE and TEST buttons now work in the iODBC Administrator app *AND* when the GUI is invoked from an ODBC application. When I try to connect to the database from Excel 2011, it now prompts me for a username/password, which I don't think I ever saw before (but my memory is bad), but even for a SQLite3 database (through an ODBC connector). In Excel 2011 it works, no more crashing (at least in early testing.) When I try to connect to the database in Excel 2016 I also get the prompt for username and password (Yay!), and *NO CRASHES*, but it doesn't work for the SQLite3 database connector, it says connect failed. However, for my MySQL database (my main need, actually) it works! :) :) So, for Excel 2016, this may be pointing to an error in the SQLite3 connector, or that it can't handle a blank user/password, or something else... Unsure. The TEST button does work, but not a connection to the database. So hopefully this helps. Building was very easy, I only had to make a small change to the Makefile so it would build on my 10.11 system by adding a section copied from the one for 10.10, just changing 10.10 to 10.11 in all the lines. I will do more testing, but this is very encouraging. -Steve > On Feb 19, 2016, at 6:57 AM, Dmitry Pogorelov <dal...@gm...> wrote: > > Hi Steve and Patrick, > > I have the same problem related to Excel 2016 and sandbox: > Feb 19 13:22:38 localhost loginwindow[99]: -[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:] Notified of item changes to list with identifier com.apple.LSSharedFileList.RecentApplications > Feb 19 13:22:38 localhost sandboxd[127] ([57827]): Microsoft Excel(57827) deny file-read-data /usr/local/lib > Feb 19 13:22:38 localhost kernel[0]: warning: Microsoft Error (57836) performed out-of-band resume on pid 57827 > Feb 19 13:24:23 localhost loginwindow[99]: -[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:] Notified of item changes to list with identifier com.apple.LSSharedFileList.RecentApplications > Feb 19 13:24:23 localhost taskgated[151]: no application identifier provided, can't use provisioning profiles [pid=57852] > Feb 19 13:24:23 localhost taskgated[151]: no application identifier provided, can't use provisioning profiles [pid=57853] > Feb 19 13:24:24 localhost kernel[0]: IGAccelDevice: IOUserClient outputCount count mismatch > Feb 19 13:24:24 localhost Microsoft Excel[57852]: NSAllowAppKitWeakReferences=YES > Feb 19 13:24:43 localhost taskgated[151]: no application identifier provided, can't use provisioning profiles [pid=57861] > > though I've copied all libs to my local folder changing all dependencies via install_name_tool. Furthermore I can't get table list in LibreOffice/OpenOffice via psql and mysql drivers built for using iODBC - but I don't know if the problem is on LO/OO side or not. > > Best Regards, > Dmitrii > > Best Regards > Dmitry Pogorelov > > 2016-02-16 18:31 GMT+01:00 Steve Palm <n9...@n9... <mailto:n9...@n9...>>: > As a follow-up to this, some more information on the problems. > > Some were self-inflicted, as in using a bad SQL statement and misinterpreting the errors returned. > > I also just updated to the latest 5.3.4 MySQL connector, I was using 5.3.2. This was to be sure this was not the problem. > > Since I cannot get the OpenLink ODBC Administrator program to work (the Configure button does nothing except put an entry in the console log): > > 2/16/16 10:27:18.451 AM iODBC Administrator[18292]: iODBC Administrator(18292,0xa3b1e000) malloc: *** error for object 0x90acc9c7: pointer being freed was not allocated > *** set a breakpoint in malloc_error_break to debug > > So I tried using this ODBC GUI manager: > > http://www.odbcmanager.net <http://www.odbcmanager.net/> > > It seemed to work OK, and manually examining the odbc.ini/odbcinst.ini files looked OK, yet when trying "iodbctest" I was still getting a variety of errors... Either that it could not prompt for additional information (I know the MySQL connector for Mac does not have a GUI component), or that it could not process the connect string. > > I also found (did not know previously) that I could query the odbc.ini file from the myodbc_installer binary to see what values it could extract. This revealed that, for some reason, it could not read the PWD value even though it was in the file. > > After reworking odbc.ini by hand, though, I finally got it to the point where it would connect, so I could do: > > iodbctest "DSN=test-5a" > > ...and it would connect and work. So, for whatever reason or whatever else was wrong before, at least this should prove that the basics are in place. > > Excel 2011, from VBA, continues to work, and in fact I could now remove some of the DSN parameters I was having to add before to the connect string as it is able to pull them from the odbc.ini. So something in the formatting of that file was not 100% proper it would seem. > > Data -> Get External Data -> New Database Query... > > This opens the "iODBC Data Source Chooser" dialog, and I can pick the same DSN I use in VBA, and I get the same strange error I was getting before: > > [MySQL][ODBC 5.3(a) Driver]Access denied for user {garbage chars}@'host.ip.addr.here' (using password: YES) > > In the console log I also see these errors: > > 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft Query(18930,0xa3b1e000) malloc: *** error for object 0xb347a2a: pointer being freed was not allocated > *** set a breakpoint in malloc_error_break to debug > 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft Query(18930,0xa3b1e000) malloc: *** error for object 0x302aa00: pointer being freed was not allocated > *** set a breakpoint in malloc_error_break to debug > > > Excel 2016, when doing the same thing, crashes: > > Thread 0 crashed: > > # 1 0x530d7b9 in (merp + 0x000037b9) 0x0 > # 2 0x938d579b in __sigtramp + 0x0000002B (libsystem_platform.dylib + 0x0000279b) 0x0 > # 3 0xffffffff in ( + 0x00000000) 0xbff3cb18 > # 4 0x97825c34 in _abort + 0x0000009C (libsystem_c.dylib + 0x0005ec34) 0xbff3cee8 > # 5 0x90ace292 in _free + 0x000001B1 (libsystem_malloc.dylib + 0x00004292) 0xbff3cf18 > # 6 0x2bdc8cac in __iodbcdm_drvconn_dialbox + 0x0000027C (iODBCdrvproxy + 0x00001cac) 0xbff3cf58 > # 7 0x2fb42f8d in _iodbcdm_drvconn_dialboxw + 0x00001ECD (iODBCadm + 0x00002f8d) 0xbff3cfc8 > # 8 0x2fb4106c in _iodbcdm_drvconn_dialbox + 0x0000007C (iODBCadm + 0x0000106c) 0xbff4a8a8 > # 9 0x2fb0ec44 in _SQLDriverConnect_Internal + 0x00000BF4 (iODBC + 0x00011c44) 0xbff4a8d8 > # 10 0x2fb102c2 in _SQLDriverConnect + 0x00000152 (iODBC + 0x000132c2) 0xbff52198 > # 11 0x5807ad in (Microsoft Excel + 0x004d47ad) 0xbff521e8 > > But something new I had not seen before in the console log, four times: > 2/16/16 10:57:59.115 AM sandboxd[266]: ([18699]) Microsoft Excel(18699) deny file-read-data /usr/local/lib/libmyodbc5a.so > > I tried to research this, and the field is not quarantined (has no extended attributes), and has no special ACL on it. > > However, I moved the library files out of /usr/local/lib and put them into /Librarry/ODBC/ODBCDataSources, and I updated the odbc.ini and odbcinst.ini files. Now Excel 2016 no longer gives the sandbox errors, but I get this when I try to pick a data source: > > 2/16/16 11:21:30.670 AM Microsoft Excel[18910]: Microsoft Excel(18910,0xa3b1e000) malloc: *** error for object 0x2b47aa2a: pointer being freed was not allocated > *** set a breakpoint in malloc_error_break to debug > 2/16/16 11:21:30.699 AM taskgated[185]: no application identifier provided, can't use provisioning profiles [pid=18921] > 2/16/16 11:21:30.787 AM Microsoft Error Reporting[18921]: ApplePersistence=YES > 2/16/16 11:21:31.000 AM kernel[0]: warning: Microsoft Error (18921) performed out-of-band resume on pid 18910 > > > Seems similar to the error Excel 2011 is getting, and that the iODBC Administrator is getting, but maybe not. But it seems to happen when these apps try to work with the GUI iODBC Data Chooser. > > > Also, trying to use the "iODBC Demo (Ansi)" app to connect gives the same error as Excel 2011... The dialog box stating access is denied with some garbage characters in place of the username, also throwing these errors in console: > > 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo Ansi(18950,0xa3b1e000) malloc: *** error for object 0xae78a2a: pointer being freed was not allocated > *** set a breakpoint in malloc_error_break to debug > 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo Ansi(18950,0xa3b1e000) malloc: *** error for object 0x4065c00: pointer being freed was not allocated > *** set a breakpoint in malloc_error_break to debug > > I had another app on my system, "iQueryODBC", and if I put in the DSN=test-5a in the connection box, it will work. However, if I use the "select" button to pick a datasource, then I get the same behavior with the garbage characters in place of the username and putting the same type of errors in the console: > > 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000) malloc: *** error for object 0xfcfaa2a: pointer being freed was not allocated > *** set a breakpoint in malloc_error_break to debug > 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000) malloc: *** error for object 0x2086e00: pointer being freed was not allocated > *** set a breakpoint in malloc_error_break to debug > > Not sure where to go further with this. > > I hope this is helpful in tracking this down. > > -Steve > > > ------------------------------------------------------------------------------ > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 <http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140> > _______________________________________________ > Iodbc-macosx mailing list > Iod...@li... <mailto:Iod...@li...> > https://lists.sourceforge.net/lists/listinfo/iodbc-macosx <https://lists.sourceforge.net/lists/listinfo/iodbc-macosx> > > ------------------------------------------------------------------------------ > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________ > Iodbc-macosx mailing list > Iod...@li... > https://lists.sourceforge.net/lists/listinfo/iodbc-macosx |