Hi,
Today I am working on a project where I need to convert an access database dump to something else (mysql likely). Most things I found on the web are not really suitable to script this process (it will need to run every month), but mdbtools looks to be promising. However I tried to compile that on toolserver all I got out of it are coredumps :-(. (Tried both on willow and nightshade). The ubuntu pacakge does work on my home server.
Did anybody ever look into mdbtools and have it working? Is it perhaps possible to have it globally installed on toolserver, as it probably is usefull to some of the glam-projects as well?
If people want an mdb file to test with, the file I need to convert is at /mnt/user-store/rce-nl-data.
Regards,
Andre
On 10/11/12 16:58, Andre Koopal wrote:
Hi,
Today I am working on a project where I need to convert an access database dump to something else (mysql likely). Most things I found on the web are not really suitable to script this process (it will need to run every month), but mdbtools looks to be promising. However I tried to compile that on toolserver all I got out of it are coredumps :-(. (Tried both on willow and nightshade). The ubuntu pacakge does work on my home server.
Did anybody ever look into mdbtools and have it working? Is it perhaps possible to have it globally installed on toolserver, as it probably is usefull to some of the glam-projects as well?
I was able to compile mdbtools-0.6pre1 for linux, see the result at /mnt/user-store/mdbtools
I admit that compilation was a bit tricky. When it complains that backend.c:31: error: static declaration of 'mdb_backends' follows non-static declaration, remove the static keyword from that line. yacc and flex are not installed in nightshade, I worked around that by running those of willow. The flex rule expected an output file of .c, so I ran ln -s lex.yy.c .c (otherwise you get an empty lexer.c)
However, the generated binaries didn't output any table for your file.
I then realised that my local mdbtools does work with yout file. Seems that mdbtools-0.7 is in GitHub, but not in SourceForge: https://github.com/brianb/mdbtools
However, in order for just running autoconf.sh, it needs libtool, which is not installed in Linux or Solaris.
If people want an mdb file to test with, the file I need to convert is at /mnt/user-store/rce-nl-data.
Regards,
Andre
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
On Sat, Nov 10, 2012 at 05:55:59PM +0100, Platonides wrote:
On 10/11/12 16:58, Andre Koopal wrote:
Hi,
Today I am working on a project where I need to convert an access database dump to something else (mysql likely). Most things I found on the web are not really suitable to script this process (it will need to run every month), but mdbtools looks to be promising. However I tried to compile that on toolserver all I got out of it are coredumps :-(. (Tried both on willow and nightshade). The ubuntu pacakge does work on my home server.
Did anybody ever look into mdbtools and have it working? Is it perhaps possible to have it globally installed on toolserver, as it probably is usefull to some of the glam-projects as well?
I was able to compile mdbtools-0.6pre1 for linux, see the result at /mnt/user-store/mdbtools
I admit that compilation was a bit tricky. When it complains that backend.c:31: error: static declaration of 'mdb_backends' follows non-static declaration, remove the static keyword from that line. yacc and flex are not installed in nightshade, I worked around that by running those of willow. The flex rule expected an output file of .c, so I ran ln -s lex.yy.c .c (otherwise you get an empty lexer.c)
However, the generated binaries didn't output any table for your file.
I then realised that my local mdbtools does work with yout file. Seems that mdbtools-0.7 is in GitHub, but not in SourceForge: https://github.com/brianb/mdbtools
However, in order for just running autoconf.sh, it needs libtool, which is not installed in Linux or Solaris.
Hi Platonides, I indeed have 0.7 as well on my home-server. Will there be any luck getting libtool? Is there perhaps already a mdbtools 0.7 package for debian, that can be installed?
Regards,
Andre
If people want an mdb file to test with, the file I need to convert is at /mnt/user-store/rce-nl-data.
Regards,
Andre
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Hello,
I am a bit confused. I found libtool installed on yarrow and nightshade which are the linux userland servers. I tried to autogen.sh the version of mdbtools from github and it worked until it tried to generate the man pages but this problem could be solved quite quick too. So I have a working copy of mdbtools 0.7 in my home done by autogen.sh. Our debian stable would install:
mdbtools (0.5.99.0.6pre1.0.20051109-7)
Is this version fine too or do you prefer 0.7?
Kind regards Marlen/nosy
On Tue, 13 Nov 2012, Andre Koopal wrote:
I was able to compile mdbtools-0.6pre1 for linux, see the result at /mnt/user-store/mdbtools
I admit that compilation was a bit tricky. When it complains that backend.c:31: error: static declaration of 'mdb_backends' follows non-static declaration, remove the static keyword from that line. yacc and flex are not installed in nightshade, I worked around that by running those of willow. The flex rule expected an output file of .c, so I ran ln -s lex.yy.c .c (otherwise you get an empty lexer.c)
However, the generated binaries didn't output any table for your file.
I then realised that my local mdbtools does work with yout file. Seems that mdbtools-0.7 is in GitHub, but not in SourceForge: https://github.com/brianb/mdbtools
However, in order for just running autoconf.sh, it needs libtool, which is not installed in Linux or Solaris.
Hi Platonides, I indeed have 0.7 as well on my home-server. Will there be any luck getting libtool? Is there perhaps already a mdbtools 0.7 package for debian, that can be installed?
Regards,
Andre
On Tue, Nov 13, 2012 at 09:12:30AM +0100, Marlen Caemmerer wrote:
Hello,
I am a bit confused. I found libtool installed on yarrow and nightshade which are the linux userland servers. I tried to autogen.sh the version of mdbtools from github and it worked until it tried to generate the man pages but this problem could be solved quite quick too. So I have a working copy of mdbtools 0.7 in my home done by autogen.sh. Our debian stable would install:
mdbtools (0.5.99.0.6pre1.0.20051109-7)
Is this version fine too or do you prefer 0.7?
Hi Marley, at first thanks for looking, appreciated.
Given the test Platonides did, 0.5 doesn't read the mdb file I need to read, so 0.7 will be the version that is needed.
Regards,
Andre
Kind regards Marlen/nosy
On Tue, 13 Nov 2012, Andre Koopal wrote:
I was able to compile mdbtools-0.6pre1 for linux, see the result at /mnt/user-store/mdbtools
I admit that compilation was a bit tricky. When it complains that backend.c:31: error: static declaration of 'mdb_backends' follows non-static declaration, remove the static keyword from that line. yacc and flex are not installed in nightshade, I worked around that by running those of willow. The flex rule expected an output file of .c, so I ran ln -s lex.yy.c .c (otherwise you get an empty lexer.c)
However, the generated binaries didn't output any table for your file.
I then realised that my local mdbtools does work with yout file. Seems that mdbtools-0.7 is in GitHub, but not in SourceForge: https://github.com/brianb/mdbtools
However, in order for just running autoconf.sh, it needs libtool, which is not installed in Linux or Solaris.
Hi Platonides, I indeed have 0.7 as well on my home-server. Will there be any luck getting libtool? Is there perhaps already a mdbtools 0.7 package for debian, that can be installed?
Regards,
Andre
On 13/11/12 09:12, Marlen Caemmerer wrote:
Hello,
I am a bit confused. I found libtool installed on yarrow and nightshade which are the linux userland servers. I tried to autogen.sh the version of mdbtools from github and it worked until it tried to generate the man pages but this problem could be solved quite quick too. So I have a working copy of mdbtools 0.7 in my home done by autogen.sh.
It's strange:
platonides@nightshade ~$ cd /mnt/user-store/mdbtools/brianb-mdbtools-004cc9f platonides@nightshade brianb-mdbtools-004cc9f $ ./autogen.sh /usr/bin/libtoolize
**Error**: You must have `libtool' installed. Get ftp://ftp.gnu.org/pub/gnu/libtool-1.2d.tar.gz (or a newer version if it is available)
Maybe it's not really libtool but some other dependency and the error message is misleading, what it's needing, but it's odd that it worked for you...
Ok, there is a bug in autogen.sh, it tries to run "libtooloze", not "libtoolize":
which libtoolize && (libtooloze --version)
Fixing that, it does compile (not even failing at the man pages). The result is at /mnt/user-store/mdbtools/mdbtools-0.7 and it seems to work with Extract_ODB_V10.2.10.mdb.
Marlen, you probably ran autoconf directly so you didn't hit the libtoolize call.
toolserver-l@lists.wikimedia.org