tag:blogger.com,1999:blog-3881428479518553465.post3559714627670489103..comments2010-12-15T01:36:00.577-06:00Matthew Kinghttp://www.blogger.com/profile/03223931423148258501noreply@blogger.comBlogger29125tag:blogger.com,1999:blog-3881428479518553465.post-35085694197003654792010-02-01T07:59:34.079-06:002010-02-01T07:59:34.079-06:00Awesome! MacPorts installed mdbtools perfectly. I&#39;m having some trouble and am hoping you might have some advice.<br /><br />When I run mdb-tables mydata.mdb, it returns nothing, or an empty array with ActiveMDB. When I run mdb-ver mydata.mdb, it says &quot;JET4&quot;, which looks like it&#39;s from Jet 4 Access 2000. The mydata.mdb file is 80MB and if I open it, I can see some of the data amongst all the crazy characters.<br /><br />Why might this not be returning any tables? Any ideas?viatroposhttp://www.blogger.com/profile/09628929648082049933noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-17805222612707716372009-12-15T10:19:10.497-06:002009-12-15T10:19:10.497-06:00Hooray for MacPorts.Matthew Kinghttp://www.blogger.com/profile/03223931423148258501noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-9434610165982289032009-12-14T10:32:30.158-06:002009-12-14T10:32:30.158-06:00$ sudo bash<br />Password:<br /># port install mdbtools<br />---&gt; Fetching mdbtools<br />---&gt; Attempting to fetch mdbtools-0.6pre1.tar.gz from http://internap.dl.sourceforge.net/mdbtools<br />---&gt; Verifying checksum(s) for mdbtools<br />---&gt; Extracting mdbtools<br />---&gt; Applying patches to mdbtools<br />---&gt; Configuring mdbtools<br />---&gt; Building mdbtools<br />---&gt; Staging mdbtools into destroot<br />---&gt; Installing mdbtools @0.6pre1_0<br />---&gt; Activating mdbtools @0.6pre1_0<br />---&gt; Cleaning mdbtools<br />#Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-85558377613917772832009-10-08T17:22:22.882-05:002009-10-08T17:22:22.882-05:00Justin, that&#39;s great. Glad that it&#39;s helping the poor souls who must work with Access. Wyrd has decreed that I no longer must suffer so.Matthew Kinghttp://www.blogger.com/profile/03223931423148258501noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-52472268570974162502009-10-06T16:53:03.480-05:002009-10-06T16:53:03.480-05:00I just thought I&#39;d post and say that the PECL extension mdbtools successfully installed with the patched version of mdbtools that you provide. Thank you.Justinnoreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-88283627885190696602009-05-28T13:06:45.695-05:002009-05-28T13:06:45.695-05:00Hello,<br /><br />Thanks for all this very helpful information. Just FYI, the pastie.org link for your patch seems to have gotten fouled somehow.. it links to what looks like diff output, instead of a complete shell script. For the convenience of others, I re-posted the intact version from your git archive: http://pastie.org/492955Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-81578609165987994942008-11-19T18:27:00.000-06:002008-11-19T18:27:00.000-06:00Just got this working as per instructions,<BR/>using the SF CVS repo and OS X 10.5.5.<BR/><BR/>I also had to get gawk for the man pages to install: port install gawk<BR/><BR/>thanks!marsnoreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-79578123999497938232008-11-14T17:59:00.000-06:002008-11-14T17:59:00.000-06:00@k-mac<BR/><BR/>Have you checked to see which version of automake is being used with:<BR/><BR/>which automake<BR/><BR/>most likely there is another version somewhere else that is being used. To solve the problem temporarily, you can put your mac ports path at the front of your path eg:<BR/><BR/>PATH=/opt/local/bin:$PATH<BR/><BR/>before you run autogen.shGregnoreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-56649883722873495222008-11-03T16:06:00.000-06:002008-11-03T16:06:00.000-06:00k-mac, sounds like automake isn't installed. You need to run:<BR/><BR/>sudo port install automakeJim Bentonhttp://autonomousmachine.comnoreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-45920651342414579412008-08-20T12:17:00.000-05:002008-08-20T12:17:00.000-05:00k-mac, I am perplexed.<BR/><BR/>I cloned the git repo anew, then ran autogen.sh, receiving no errors. The configure file that was produced does not have the string "AM_PATH_GLIB_2_0" anywhere in it. I don't know much about automake, but it seems that AM_PATH_GLIB_2_0 is a macro that shouldn't be showing up in your configure file.<BR/><BR/>My best guess is that something is wrong with your automake/autoconf system.Matthew Kinghttp://www.blogger.com/profile/03223931423148258501noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-41727592099257185662008-08-20T11:27:00.000-05:002008-08-20T11:27:00.000-05:00Finally I got git installed. Had to patch the Portfile of p5-error to use the Version 17015 rather than 17012 cos I found out that 012 was no longer on the servers.<BR/>Than I had to make a port install git-core without +svn. The latter brought me other errors building sqlite3.<BR/><BR/>Than I did the git command you posted which gave me another mdbtools folder where I could start autogen.sh<BR/>...<BR/>leading to exactly the same error message as in my previous post<BR/>./configure: line 20350: syntax error near unexpected token `2.0.0'<BR/>./configure: line 20350: `AM_PATH_GLIB_2_0(2.0.0)'<BR/><BR/>:(<BR/><BR/>Looks like mdbtools are not made for the mac. Damned there is no alternative out in the world.<BR/>Trying to find a osx binary version of the tools, but whyever noone leaves them for download.k-macnoreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-17322629014469564062008-08-20T10:37:00.000-05:002008-08-20T10:37:00.000-05:00Well, don&#39;t know about git. Have tried a<BR/>port install git-core +svn<BR/>like it was written somewhere, but I get<BR/>---&gt; Fetching p5-error<BR/>---&gt; Attempting to fetch Error-0.17012.tar.gz from (several servers, none working).<BR/>So I don&#39;t have that thing called &quot;git&quot;.<BR/><BR/>Have downloaded the cvs repo and fouznd a autogen.sh which I could patch. Done so, I tried a ./autogen.sh, but got the following error:<BR/><BR/>checking Are we using flex ... yes <BR/>./configure: line 20350: syntax error near unexpected token `2.0.0&#39;<BR/>./configure: line 20350: `AM_PATH_GLIB_2_0(2.0.0)&#39;<BR/><BR/>looking up I found a message at the very beginning, saying:<BR/># ./autogen.sh<BR/>**Warning**: I am going to run `configure&#39; with no arguments.<BR/>If you wish to pass any to it, please specify them on the<BR/>`./autogen.sh&#39; command line.<BR/><BR/>processing .<BR/>Running aclocal ...<BR/>configure.in:106: warning: macro `AM_PATH_GLIB_2_0&#39; not found in library<BR/>Running libtoolize...<BR/>... and so forth<BR/><BR/>Also tried with --enable-sql --disable-gmdb2<BR/>no changesk-macnoreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-59954580132367085402008-08-19T18:06:00.000-05:002008-08-19T18:06:00.000-05:00k-mac:<BR/><BR/>I don't think I ever tried the release packages. I went straight to the CVS repo. Have you tried the Git repo I published?Matthew Kinghttp://www.blogger.com/profile/03223931423148258501noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-78595349074664737752008-08-19T17:57:00.000-05:002008-08-19T17:57:00.000-05:00was a comment typo. meant<BR/>port install glib2 libtool automake<BR/><BR/>of course.<BR/><BR/>btw: doing a simple configure with the options above + make, I get an error:<BR/>ld: duplicate symbol _mdb_backends in mem.lo and catalog.lo<BR/><BR/>collect2: ld returned 1 exit status<BR/>make[2]: *** [libmdb.la] Error 1<BR/>make[1]: *** [all-recursive] Error 1<BR/>make: *** [all-recursive] Error 1k-macnoreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-17042588292539666792008-08-19T17:54:00.000-05:002008-08-19T17:54:00.000-05:00Don't know what I'm doing wrong.<BR/>Have done port install glib2 libtool automke<BR/><BR/>Downloaded the sources 0.5 and 0.6pre1.<BR/><BR/>Wanted to follow your instructions, but where is autogen.sh? It's not in the mdbtools-folder, nor anywhere in the system.<BR/><BR/>OSX 10.5.4 :(<BR/>Isn't there a working copy of the tools for osx out in the world without compiling, installing a bunch of macports and so forth?k-macnoreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-90659038674048557402008-06-22T19:16:00.000-05:002008-06-22T19:16:00.000-05:00Thanks Matthew,<BR/><BR/>As it happens I managed to checkout the code from cvs eventually (2 days of trying!) and got it to compile OK.<BR/><BR/>L3KLinker3000noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-89601410258768796802008-06-20T09:22:00.000-05:002008-06-20T09:22:00.000-05:00Linker3000, I can't remember whether I tested the changes on any Linux. Looking at the patch, though, the changes seem pretty straightforward, and not Mac specific. So the git repo should be at least a decent starting point.Matthew Kinghttp://www.blogger.com/profile/03223931423148258501noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-9642459807161966632008-06-20T05:31:00.000-05:002008-06-20T05:31:00.000-05:00Can I use git to grab the code for a build on CentOS 5 or is the code Mac-specific. <BR/><BR/>cvs made you cry - it's making me stabby!<BR/><BR/>ThanksLinker3000noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-47845722064227405972008-06-13T10:25:00.000-05:002008-06-13T10:25:00.000-05:00Thanks for the information, Mark. I made a note in the main article.Matthew Kinghttp://www.blogger.com/profile/03223931423148258501noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-37155357645006429112008-06-13T06:30:00.000-05:002008-06-13T06:30:00.000-05:00Thanks for sharing this information. It's been very helpful for me.<BR/><BR/>A small note: I followed the instructions and used GIT to get the sourcecode. The only problem I encountered when typing 'make' was an error about an 'invalid token character' or something.<BR/><BR/>After a bit of Google searching I found that this error was due to a bug in flex. Upgrading flex to 2.5.35 fixed it.<BR/><BR/>Hope this information helps someone else.Markhttp://www.blogger.com/profile/18394129491176460071noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-24489807011934212532008-05-29T12:17:00.000-05:002008-05-29T12:17:00.000-05:00I too am pathetically grateful. Had this working months ago, but I had to reinstall recently and lost it in the process, along with all memory of how I got it to build in the first place.<BR/><BR/>Thank you, thank you, thank you!Hugh Caylesshttp://www.blogger.com/profile/05582281819129069158noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-91038315564326802942008-05-22T10:10:00.000-05:002008-05-22T10:10:00.000-05:00Peter:<BR/><BR/>You'll need git installed, which you can do with macports for sure, and probably fink. With macports, you do something like:<BR/><BR/>$ sudo port install git-core +svn<BR/><BR/>The "+svn" part gets you the git-svn tools, which allow near-seamless tracking of Subversion repos<BR/><BR/>Once you have git installed, cd to the directory where you want to keep mdb-tools source and start following my instructions where it says "git clone ..."Matthew Kinghttp://www.blogger.com/profile/03223931423148258501noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-69513872614401578442008-05-22T09:53:00.000-05:002008-05-22T09:53:00.000-05:00I use the CVS, 0.6pre1. But I don't understand when to use the patch. Maybe that's the problem. <BR/><BR/>How do I utilise the git repo?Peter Boyehttp://www.blogger.com/profile/17293155559518304295noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-44078160426943840082008-05-21T12:25:00.000-05:002008-05-21T12:25:00.000-05:00Peter, are you using the git repo, or the CVS + patch?Matthew Kinghttp://www.blogger.com/profile/03223931423148258501noreply@blogger.comtag:blogger.com,1999:blog-3881428479518553465.post-20868981010928166592008-05-21T08:54:00.000-05:002008-05-21T08:54:00.000-05:00Running autogen.sh, I get the error: "config.status: error: cannot find input file: Makefile.in" <BR/><BR/>What do I do wrong?Peter Boyehttp://www.blogger.com/profile/17293155559518304295noreply@blogger.com