mdbtools-dev

[mdb-dev] Long Binary Data

[RI D. <s02...@sm...>]

Hi,

I was just curious if anybody had managed to return anything from columns in a 
DB containing Long Binary Data using MDB-Tools.  I have not been able to do 
this, and am assuming this functionality is not available.  Is it likely this 
will be possible in future version of MDB-Tools?

Kind Regards,

Rob Dunfey

[mdb-dev] Problems building mdb-tools from both CVS and 0.5rc2

[KEVIN Z. <KZE...@jh...>]

I've been able to successfully connect to the CVS server and get mdbtools, =
but I get these errors when I try to compile it:
www:~# su - kevinz
kevinz@www:~$ cd mdbtools
kevinz@www:~/mdbtools$ ./autogen.sh --enable-sql --with-unixodbc=3D/usr/loc=
al
processing .
Running libtoolize...
You should add the contents of `/usr/share/aclocal/libtool.m4' to =
`aclocal.m4'.
Running aclocal  ...
Running autoheader...
configure.in:21: warning: AC_TRY_RUN called without default to allow cross =
compiling
Running automake --gnu  ...
Running autoconf ...
configure.in:21: warning: AC_TRY_RUN called without default to allow cross =
compiling
autoconf: Undefined macros:
configure.in:107:AC_CONFIG_FILES([src/Makefile])
Running ./configure --enable-sql --with-unixodbc=3D/usr/local ...

<snip>

checking for GLIB - version >=3D 2.0.0... yes (version 2.0.1)
checking for libglade-2.0 libgnomeui-2.0... Package libgnomeui-2.0 was not =
found in the pkg-config search path.
Perhaps you should add the directory containing `libgnomeui-2.0.pc'
to the PKG_CONFIG_PATH environment variable
No package 'libgnomeui-2.0' found
./configure: line 6350: syntax error near unexpected token `AC_CONFIG_FILES=
(src/Makefile)'
./configure: line 6350: `AC_CONFIG_FILES(src/Makefile)'
kevinz@www:~/mdbtools$=20

Yet, I have libgnomeui, I think:
www:~# apt-cache search libgnomeui
libgnome-perl - Perl module for the gnome and zvt libraries.
libgnomeui32 - The Gnome libraries (User Interface)
www:~# apt-get install libgnomeui32
Sorry, libgnomeui32 is already the newest version.
www:~# apt-get install libgnome-perl
Sorry, libgnome-perl is already the newest version.

Although, I don't seem to have the specific file mentioned:
www:~# find / -name "libgnomeui*"     =20
/var/cache/apt/archives/libgnomeui32_1.4.1.4-3_i386.deb
/var/lib/dpkg/info/libgnomeui32.shlibs
/var/lib/dpkg/info/libgnomeui32.list
/var/lib/dpkg/info/libgnomeui32.postinst
/var/lib/dpkg/info/libgnomeui32.prerm
/var/lib/dpkg/info/libgnomeui32.postrm
/var/lib/dpkg/info/libgnomeui32.md5sums
/usr/share/doc/libgnomeui32
/usr/doc/libgnomeui32
/usr/lib/libgnomeui.so.32.14.1
/usr/lib/libgnomeui.so.32
www:~#=20

I don't use Gnome on this box, it's a server, which I don't even think has =
X on it. I do everything from the command line on it.

Next, I tried buiding it from the 0.5rc2 source tarball. I have been =
successful doing this previously, However, I've never used the '--with-unix=
odbc' option yet. When I did, the make ended with:
Making all in odbc
make[2]: Entering directory `/home/kevinz/mdbtools-0.5rc2/src/odbc'
source=3D'odbc.c' object=3D'odbc.lo' libtool=3Dyes \
depfile=3D'.deps/odbc.Plo' tmpdepfile=3D'.deps/odbc.TPlo' \
depmode=3Dgcc /bin/sh ../../depcomp \
/bin/sh ../../libtool --mode=3Dcompile gcc -DPACKAGE_NAME=3D\"\" -DPACKAGE_=
TARNAME=3D\"\" -DPACKAGE_VERSION=3D\"\" -DPACKAGE_STRING=3D\"\" -DPACKAGE_B=
UGREPORT=3D\"\" -DPACKAGE=3D\"mdbtools\" -DVERSION=3D\"0.5rc2\" -DSTDC_HEAD=
ERS=3D1 -DHAVE_SYS_TYPES_H=3D1 -DHAVE_SYS_STAT_H=3D1 -DHAVE_STDLIB_H=3D1 =
-DHAVE_STRING_H=3D1 -DHAVE_MEMORY_H=3D1 -DHAVE_STRINGS_H=3D1 -DHAVE_INTTYPE=
S_H=3D1 -DHAVE_STDINT_H=3D1 -DHAVE_UNISTD_H=3D1 -DHAVE_DLFCN_H=3D1 =
-DYYTEXT_POINTER=3D1 -DSTDC_HEADERS=3D1 -DHAVE_FCNTL_H=3D1 -DHAVE_LIMITS_H=
=3D1 -DHAVE_UNISTD_H=3D1 -DHAVE_WORDEXP_H=3D1  -I. -I. -I ../../include =
`glib-config --cflags`    -g -O2 -DSQL -DUNIXODBC -c -o odbc.lo `test -f =
'odbc.c' || echo './'`odbc.c
/bin/sh: glib-config: command not found
mkdir .libs
gcc -DPACKAGE_NAME=3D\"\" -DPACKAGE_TARNAME=3D\"\" -DPACKAGE_VERSION=3D\"\"=
 -DPACKAGE_STRING=3D\"\" -DPACKAGE_BUGREPORT=3D\"\" -DPACKAGE=3D\"mdbtools\=
" -DVERSION=3D\"0.5rc2\" -DSTDC_HEADERS=3D1 -DHAVE_SYS_TYPES_H=3D1 =
-DHAVE_SYS_STAT_H=3D1 -DHAVE_STDLIB_H=3D1 -DHAVE_STRING_H=3D1 -DHAVE_MEMORY=
_H=3D1 -DHAVE_STRINGS_H=3D1 -DHAVE_INTTYPES_H=3D1 -DHAVE_STDINT_H=3D1 =
-DHAVE_UNISTD_H=3D1 -DHAVE_DLFCN_H=3D1 -DYYTEXT_POINTER=3D1 -DSTDC_HEADERS=
=3D1 -DHAVE_FCNTL_H=3D1 -DHAVE_LIMITS_H=3D1 -DHAVE_UNISTD_H=3D1 -DHAVE_WORD=
EXP_H=3D1 -I. -I. -I ../../include -g -O2 -DSQL -DUNIXODBC -c odbc.c =
-Wp,-MD,.deps/odbc.TPlo  -fPIC -DPIC -o .libs/odbc.lo
In file included from ../../include/mdbodbc.h:22,
                 from odbc.c:28:
../../include/mdbtools.h:31: glib.h: No such file or directory
In file included from ../../include/mdbodbc.h:23,
                 from odbc.c:28:
../../include/mdbsql.h:3: glib.h: No such file or directory
In file included from odbc.c:33:
connectparams.h:23: glib.h: No such file or directory
make[2]: *** [odbc.lo] Error 1
make[2]: Leaving directory `/home/kevinz/mdbtools-0.5rc2/src/odbc'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/kevinz/mdbtools-0.5rc2/src'
make: *** [all-recursive] Error 1
kevinz@www:~/mdbtools-0.5rc2$=20

Can anyone offer me any suggestions on where I should go from here?

Thanks for your help.

-Kevin Zembower


-----
E. Kevin Zembower
Unix Administrator
Johns Hopkins University/Center for Communications Programs
111 Market Place, Suite 310
Baltimore, MD  21202
410-659-6139

[mdb-dev] Query from Command Line

[RI D. <s02...@sm...>]

Hi Guys,

I would like to use mdb tools to extract values of a 'long binary data' data 
type from an Access DB.  I am not sure if this is possible.  However, more 
importantely I am unable to find out, as I don't know how to run a query from 
the command line?  mdb-tools has been installed without the user interface or 
manual pages.  So could anyone point me in the direction of an online manual, 
or give some pointers as to how I run a query from the command line.

Any help, much appreciated,

Rob

Re: [mdb-dev] Seg fault and CVS problems

[KEVIN Z. <KZE...@jh...>]

Michael, thanks, again, for your persistent help. I've tried to do all the =
things you asked, just to give a complete picture.

Here's the output of gdb again:
kevinz@www:~/budgetdb$ gdb mdb-export
(gdb) run -H budgettables.mdb BCODE
Starting program: /usr/local/bin/mdb-export -H budgettables.mdb BCODE

Program received signal SIGSEGV, Segmentation fault.
0x08048db3 in main (argc=3D4, argv=3D0xbffffdd4) at mdb-export.c:103
103                                     if (quote_text && is_text_type(col-=
>col_type)) {
(gdb) backtrace
#0  0x08048db3 in main (argc=3D4, argv=3D0xbffffdd4) at mdb-export.c:103
(gdb) print col
$1 =3D (MdbColumn *) 0x4f2
(gdb) print col->col_type
Cannot access memory at address 0x512
(gdb) quit
A debugging session is active.
Do you still want to close the debugger?(y or n) y
kevinz@www:~/budgetdb$=20

I made the addition you suggested before line 103 of src/util/mdb-export.c,=
 and the -H option executed perfectly. Thanks so much for looking into =
this.

I also created the .cvspass file you suggested, and was then able to log =
into CVS and download the mdbtools file. While it seems like there are =
numerous differences between the CVS version and the 0.5rc2 one, now that =
I have one working, I'll just wait for a stable release.

I really appreciate your help with my problem.

-Kevin

>>> Michael Wood <mw...@it...> 07/11/03 04:06AM >>>
Hi

On Thu, Jul 10, 2003 at 02:16:30PM -0400, KEVIN ZEMBOWER wrote:
> Michael, thank you for your response.

No problem.

> I tried both things, to see if there was difference. Here's the output
> of the debugging, after compiling with the -g option:
> www:/home/kevinz/mdbtools-0.5rc2# gdb mdb-export
[snip]
> (gdb) run -H ../budgetdb/budgettables.mdb BCODE
> Starting program: /usr/local/bin/mdb-export -H ../budgetdb/budgettables.m=
db BCODE
>=20
> Program received signal SIGSEGV, Segmentation fault.
> 0x08048db3 in main (argc=3D4, argv=3D0xbffff914) at mdb-export.c:103
> 103                                     if (quote_text && is_text_type(co=
l->col_type)) {
> (gdb) backtrace
> #0  0x08048db3 in main (argc=3D4, argv=3D0xbffff914) at mdb-export.c:103
> (gdb)=20

OK, do that again, but this time type:
(gdb) print col

I think col is either NULL or has some other bad value.  If it's NULL it
will look something like this:

$1 =3D (MdbColumn *) 0x0

(gdb) print col->col_type

If col is NULL or contains some other bad value, this will fail
something like this:

Cannot access memory at address 0x20

After a quick look at the code, it seems that if you pass in "-H" then
col is used before it is initialised.  I am not one of the developers of
mdbtools, but try this:

Insert the following line:
col=3Dg_ptr_array_index(table->columns,0);

Just before the following line on line 103:
if (quote_text && is_text_type(col->col_type)) {

so the code reads:

			[...]
			while(mdb_fetch_row(table)) {
				col=3Dg_ptr_array_index(table->columns,0);
				if (quote_text && is_text_type(col->col_typ=
e)) {
			[...]

Actually, after looking at the latest code from CVS, I see that's
exactly what it does :)

> Just pressing RETURN when asked for the password gave the same result:
> kevinz@www:~$ cvs -d:pserver:ano...@cv...:/cvsr=
oot/mdbtools login
> Logging in to :pserver:ano...@cv...:2401/cvsroo=
t/mdbtools=20
> CVS password:   [Just pressed RETURN here]
> cvs [login aborted]: recv() from server cvs.mdbtools.sourceforge.net: =
Connection reset by peer

"Connection reset by peer" means that the server closed the connection.
SourceForge's CVS servers have been quite flakey recently.  Try that
login again until it completes successfully.  SourceForge suggests
waiting a minute or so and trying again, but there's no guarantee it
will work the second time :)  You will have the same problem when trying
to checkout the sources after logging in.

Actually, just skip the cvs login and create a file called
/home/kevinz/.cvspass containing the following line:

/1 :pserver:ano...@cv...:2401/cvsroot/mdbtools A

That's what cvs login does anyway.

Maybe Brian or someone else could provide CVS snapshots occasionally?
(I didn't see any available for download.)

> kevinz@www:~$ cvs -z3 -d:pserver:ano...@cv...:/=
cvsroot/mdbtools co mdbtools
> cvs checkout: failed to open /home/kevinz/.cvspass for reading: No such =
file or directory
> cvs [checkout aborted]: recv() from server cvs.mdbtools.sourceforge.net: =
EOF

This is because you have not yet logged in successfully.  See the error
message about there being no .cvspass file?  This file is
created/updated by cvs login.

--=20
Michael Wood <mw...@it...>


-------------------------------------------------------
This SF.Net email sponsored by: Parasoft
Error proof Web apps, automate testing & more.
Download & eval WebKing and get a free book.
www.parasoft.com/bulletproofapps1=20
_______________________________________________
mdbtools-dev mailing list
mdb...@li...=20
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Re: [mdb-dev] Seg fault and CVS problems

[Michael W. <mw...@it...>]

Hi

On Thu, Jul 10, 2003 at 02:16:30PM -0400, KEVIN ZEMBOWER wrote:
> Michael, thank you for your response.

No problem.

> I tried both things, to see if there was difference. Here's the output
> of the debugging, after compiling with the -g option:
> www:/home/kevinz/mdbtools-0.5rc2# gdb mdb-export
[snip]
> (gdb) run -H ../budgetdb/budgettables.mdb BCODE
> Starting program: /usr/local/bin/mdb-export -H ../budgetdb/budgettables.mdb BCODE
> 
> Program received signal SIGSEGV, Segmentation fault.
> 0x08048db3 in main (argc=4, argv=0xbffff914) at mdb-export.c:103
> 103                                     if (quote_text && is_text_type(col->col_type)) {
> (gdb) backtrace
> #0  0x08048db3 in main (argc=4, argv=0xbffff914) at mdb-export.c:103
> (gdb) 

OK, do that again, but this time type:
(gdb) print col

I think col is either NULL or has some other bad value.  If it's NULL it
will look something like this:

$1 = (MdbColumn *) 0x0

(gdb) print col->col_type

If col is NULL or contains some other bad value, this will fail
something like this:

Cannot access memory at address 0x20

After a quick look at the code, it seems that if you pass in "-H" then
col is used before it is initialised.  I am not one of the developers of
mdbtools, but try this:

Insert the following line:
col=g_ptr_array_index(table->columns,0);

Just before the following line on line 103:
if (quote_text && is_text_type(col->col_type)) {

so the code reads:

			[...]
			while(mdb_fetch_row(table)) {
				col=g_ptr_array_index(table->columns,0);
				if (quote_text && is_text_type(col->col_type)) {
			[...]

Actually, after looking at the latest code from CVS, I see that's
exactly what it does :)

> Just pressing RETURN when asked for the password gave the same result:
> kevinz@www:~$ cvs -d:pserver:ano...@cv...:/cvsroot/mdbtools login
> Logging in to :pserver:ano...@cv...:2401/cvsroot/mdbtools
> CVS password:   [Just pressed RETURN here]
> cvs [login aborted]: recv() from server cvs.mdbtools.sourceforge.net: Connection reset by peer

"Connection reset by peer" means that the server closed the connection.
SourceForge's CVS servers have been quite flakey recently.  Try that
login again until it completes successfully.  SourceForge suggests
waiting a minute or so and trying again, but there's no guarantee it
will work the second time :)  You will have the same problem when trying
to checkout the sources after logging in.

Actually, just skip the cvs login and create a file called
/home/kevinz/.cvspass containing the following line:

/1 :pserver:ano...@cv...:2401/cvsroot/mdbtools A

That's what cvs login does anyway.

Maybe Brian or someone else could provide CVS snapshots occasionally?
(I didn't see any available for download.)

> kevinz@www:~$ cvs -z3 -d:pserver:ano...@cv...:/cvsroot/mdbtools co mdbtools
> cvs checkout: failed to open /home/kevinz/.cvspass for reading: No such file or directory
> cvs [checkout aborted]: recv() from server cvs.mdbtools.sourceforge.net: EOF

This is because you have not yet logged in successfully.  See the error
message about there being no .cvspass file?  This file is
created/updated by cvs login.

-- 
Michael Wood <mw...@it...>

Re: [mdb-dev] Seg fault and CVS problems

[KEVIN Z. <KZE...@jh...>]

Michael, thank you for your response.

I tried both things, to see if there was difference. Here's the output of =
the debugging, after compiling with the -g option:
www:/home/kevinz/mdbtools-0.5rc2# gdb mdb-export
GNU gdb 2002-04-01-cvs
Copyright 2002 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you =
are
welcome to change it and/or distribute copies of it under certain =
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for =
details.
This GDB was configured as "i386-linux"...
(gdb) run -H ../budgetdb/budgettables.mdb BCODE
Starting program: /usr/local/bin/mdb-export -H ../budgetdb/budgettables.mdb=
 BCODE

Program received signal SIGSEGV, Segmentation fault.
0x08048db3 in main (argc=3D4, argv=3D0xbffff914) at mdb-export.c:103
103                                     if (quote_text && is_text_type(col-=
>col_type)) {
(gdb) backtrace
#0  0x08048db3 in main (argc=3D4, argv=3D0xbffff914) at mdb-export.c:103
(gdb)=20

Just pressing RETURN when asked for the password gave the same result:
kevinz@www:~$ cvs -d:pserver:ano...@cv...:/cvsroo=
t/mdbtools login
Logging in to :pserver:ano...@cv...:2401/cvsroot/=
mdbtools
CVS password:   [Just pressed RETURN here]
cvs [login aborted]: recv() from server cvs.mdbtools.sourceforge.net: =
Connection reset by peer
kevinz@www:~$ cvs -z3 -d:pserver:ano...@cv...:/cv=
sroot/mdbtools co mdbtools
cvs checkout: failed to open /home/kevinz/.cvspass for reading: No such =
file or directory
cvs [checkout aborted]: recv() from server cvs.mdbtools.sourceforge.net: =
EOF
kevinz@www:~$=20

Michael, thanks again for your help.

-Kevin Zembower

>>> Michael Wood <mw...@it...> 07/10/03 08:21AM >>>
On Wed, Jul 09, 2003 at 01:06:05PM -0400, KEVIN ZEMBOWER wrote:
> I'm trying to get my first installation of MDB tools working. I'm also =
not familiar with CVS, so I couldn't get this command to work:
> www:~# cvs -d:pserver:ano...@cv...:/cvsroot/mdb=
tools login
[snip]
> I tried putting in 'anonymous' and my email address in response to the
> password prompt, but neither was accepted.

Try just pressing ENTER without typing anything for the password.

> Then, I got the 0.5rc2 tarball and did the dance: tar zxvf
> mdbtools-0.5rc2.tar.gz; cd mdbtools-0.5rc2/; ./configure --enable-sql;
> make; su -; make install. All seemed to go well, except for some
> complaints about missing libglade and libgnomeui, which didn't stop
> the build. mdbtools seems to be working, except for a Segmentation
> fault when the '-H' (omit the header row) is used:
[snip]
> kevinz@www:~/budgetdb$ mdb-export -H budgettables.mdb BCODE
> Segmentation fault
> kevinz@www:~/budgetdb$=20
>=20
> Any ideas on how to troubleshoot this problem? I tried to search the

You could try compiling everything with debugging and then run that
command under gdb.

e.g.

$ CFLAGS=3D"-g" ./configure ...
$ make

$ gdb mdb-export
[...]
(gdb) run -H budgettables.mdb BCODE

Then when it crashes, type:
(gdb) backtrace

If you post that to the list someone should be able to tell what the
problem is.

--=20
Michael Wood <mw...@it...>

Re: [mdb-dev] Seg fault and CVS problems

[Michael W. <mw...@it...>]

On Wed, Jul 09, 2003 at 01:06:05PM -0400, KEVIN ZEMBOWER wrote:
> I'm trying to get my first installation of MDB tools working. I'm also not familiar with CVS, so I couldn't get this command to work:
> www:~# cvs -d:pserver:ano...@cv...:/cvsroot/mdbtools login
[snip]
> I tried putting in 'anonymous' and my email address in response to the
> password prompt, but neither was accepted.

Try just pressing ENTER without typing anything for the password.

> Then, I got the 0.5rc2 tarball and did the dance: tar zxvf
> mdbtools-0.5rc2.tar.gz; cd mdbtools-0.5rc2/; ./configure --enable-sql;
> make; su -; make install. All seemed to go well, except for some
> complaints about missing libglade and libgnomeui, which didn't stop
> the build. mdbtools seems to be working, except for a Segmentation
> fault when the '-H' (omit the header row) is used:
[snip]
> kevinz@www:~/budgetdb$ mdb-export -H budgettables.mdb BCODE
> Segmentation fault
> kevinz@www:~/budgetdb$ 
> 
> Any ideas on how to troubleshoot this problem? I tried to search the

You could try compiling everything with debugging and then run that
command under gdb.

e.g.

$ CFLAGS="-g" ./configure ...
$ make

$ gdb mdb-export
[...]
(gdb) run -H budgettables.mdb BCODE

Then when it crashes, type:
(gdb) backtrace

If you post that to the list someone should be able to tell what the
problem is.

-- 
Michael Wood <mw...@it...>

[mdb-dev] Seg fault and CVS problems

[KEVIN Z. <KZE...@jh...>]

I'm trying to get my first installation of MDB tools working. I'm also not =
familiar with CVS, so I couldn't get this command to work:
www:~# cvs -d:pserver:ano...@cv...:/cvsroot/mdbto=
ols login
Logging in to :pserver:ano...@cv...:2401/cvsroot/=
mdbtools
CVS password:=20
cvs login: authorization failed: server cvs.mdbtools.sourceforge.net =
rejected access to /cvsroot/mdbtools for user anonymous
www:~# cvs -d:pserver:ano...@cv...:/cvsroot/mdbto=
ols login
Logging in to :pserver:ano...@cv...:2401/cvsroot/=
mdbtools
CVS password:=20
cvs [login aborted]: recv() from server cvs.mdbtools.sourceforge.net: =
Connection reset by peer
www:~#=20

I tried putting in 'anonymous' and my email address in response to the =
password prompt, but neither was accepted.

Then, I got the 0.5rc2 tarball and did the dance: tar zxvf mdbtools-0.5rc2.=
tar.gz; cd mdbtools-0.5rc2/; ./configure --enable-sql; make; su -; make =
install. All seemed to go well, except for some complaints about missing =
libglade and libgnomeui, which didn't stop the build. mdbtools seems to be =
working, except for a Segmentation fault when the '-H' (omit the header =
row) is used:
kevinz@www:~/budgetdb$ mdb-export budgettables.mdb BCODE | head -3  =20
BUDGETNUMB,BUDGETDESC,THRU_DATE,FROM_DATE,ACTIVE_INA,AT_T_CODE,AWARD_NUMB,O=
N_OFF_CAM,OLD_BUDGET,BREGION,FUNDING,FINANALYST,PROGOFFICE,DATERECORD,DATEL=
ASTMO,TIMELASTM9,LASTMODIFI,TIMERECTM9,CREATEDBYO,MASTERACCO,TYPEFUNDIN,COU=
NTRY,OLDAUTHCODE,FUND,AREAORG,NOTES,TEAM
8050104.000000,"Popdynamics GF","","","I",,2,"On Campus","","Admin","CCP","=
vsmith","","08/23/96 00:00:00","06/12/97 00:00:00","07443677","CGK","134946=
60","DTN",8850105.000000,"","Nepal",,690,,"",
9800131.000000,"General Funds '04","06/30/04 00:00:00","07/01/00 00:00:00",=
"A",2398613.000000,,"On Campus","H-32-0005","Admin","CCP","vsmith","SHD",""=
,"11/29/00 00:00:00","13541336","CGK","","",9800131.000000,"Discretionary",=
"Non-Country",9416,0,,"Requires prior approval by Susan",
kevinz@www:~/budgetdb$ mdb-export -H budgettables.mdb BCODE
Segmentation fault
kevinz@www:~/budgetdb$=20

Any ideas on how to troubleshoot this problem? I tried to search the =
archives on "Segmentation" but the SourceForge archive server must be done =
right now; I couldn't get a response.

Here's some information on my system:
kevinz@www:~/budgetdb$ cat /proc/sys/kernel/ostype=20
Linux
kevinz@www:~/budgetdb$ cat /proc/sys/kernel/osrelease=20
2.4.18-686-smp
kevinz@www:~/budgetdb$ cat /etc/issue
Debian GNU/\s 3.0 \n \l
kevinz@www:~/budgetdb$ cat /proc/sys/kernel/version  =20
#1 SMP Sun Apr 14 12:07:19 EST 2002
kevinz@www:~/budgetdb$=20

Thank you all for your help and suggestions.

-Kevin Zembower

-----
E. Kevin Zembower
Unix Administrator
Johns Hopkins University/Center for Communications Programs
111 Market Place, Suite 310
Baltimore, MD  21202
410-659-6139

[mdb-dev] Seg fault and CVS problems

[KEVIN Z. <KZE...@jh...>]

I'm trying to get my first installation of MDB tools working. I'm also not =
familiar with CVS, so I couldn't get this command to work:
www:~# cvs -d:pserver:ano...@cv...:/cvsroot/mdbto=
ols login
Logging in to :pserver:ano...@cv...:2401/cvsroot/=
mdbtools
CVS password:=20
cvs login: authorization failed: server cvs.mdbtools.sourceforge.net =
rejected access to /cvsroot/mdbtools for user anonymous
www:~# cvs -d:pserver:ano...@cv...:/cvsroot/mdbto=
ols login
Logging in to :pserver:ano...@cv...:2401/cvsroot/=
mdbtools
CVS password:=20
cvs [login aborted]: recv() from server cvs.mdbtools.sourceforge.net: =
Connection reset by peer
www:~#=20

I tried putting in 'anonymous' and my email address in response to the =
password prompt, but neither was accepted.

Then, I got the 0.5rc2 tarball and did the dance: tar zxvf mdbtools-0.5rc2.=
tar.gz; cd mdbtools-0.5rc2/; ./configure --enable-sql; make; su -; make =
install. All seemed to go well, except for some complaints about missing =
libglade and libgnomeui, which didn't stop the build. mdbtools seems to be =
working, except for a Segmentation fault when the '-H' (omit the header =
row) is used:
kevinz@www:~/budgetdb$ mdb-export budgettables.mdb BCODE | head -3  =20
BUDGETNUMB,BUDGETDESC,THRU_DATE,FROM_DATE,ACTIVE_INA,AT_T_CODE,AWARD_NUMB,O=
N_OFF_CAM,OLD_BUDGET,BREGION,FUNDING,FINANALYST,PROGOFFICE,DATERECORD,DATEL=
ASTMO,TIMELASTM9,LASTMODIFI,TIMERECTM9,CREATEDBYO,MASTERACCO,TYPEFUNDIN,COU=
NTRY,OLDAUTHCODE,FUND,AREAORG,NOTES,TEAM
8050104.000000,"Popdynamics GF","","","I",,2,"On Campus","","Admin","CCP","=
vsmith","","08/23/96 00:00:00","06/12/97 00:00:00","07443677","CGK","134946=
60","DTN",8850105.000000,"","Nepal",,690,,"",
9800131.000000,"General Funds '04","06/30/04 00:00:00","07/01/00 00:00:00",=
"A",2398613.000000,,"On Campus","H-32-0005","Admin","CCP","vsmith","SHD",""=
,"11/29/00 00:00:00","13541336","CGK","","",9800131.000000,"Discretionary",=
"Non-Country",9416,0,,"Requires prior approval by Susan",
kevinz@www:~/budgetdb$ mdb-export -H budgettables.mdb BCODE
Segmentation fault
kevinz@www:~/budgetdb$=20

Any ideas on how to troubleshoot this problem? I tried to search the =
archives on "Segmentation" but the SourceForge archive server must be done =
right now; I couldn't get a response.

Here's some information on my system:
kevinz@www:~/budgetdb$ cat /proc/sys/kernel/ostype=20
Linux
kevinz@www:~/budgetdb$ cat /proc/sys/kernel/osrelease=20
2.4.18-686-smp
kevinz@www:~/budgetdb$ cat /etc/issue
Debian GNU/\s 3.0 \n \l
kevinz@www:~/budgetdb$ cat /proc/sys/kernel/version  =20
#1 SMP Sun Apr 14 12:07:19 EST 2002
kevinz@www:~/budgetdb$=20

Thank you all for your help and suggestions.

-Kevin Zembower

-----
E. Kevin Zembower
Unix Administrator
Johns Hopkins University/Center for Communications Programs
111 Market Place, Suite 310
Baltimore, MD  21202
410-659-6139

[mdb-dev] Access 1.x/2.x

[Kevin O. <ke...@ho...>]

I need to be able to parse Access 1.x/2.x database types. has anyone got any 
info on the page layouts? specficially the hex layout equivalents to 
tabledef/coldef/non-system data pages in HACKING.TXT?

ps. I've used the HACKING.TXT to write a pure-java converter from A97 to 
XML.  It's specific to the application I'm working on, but I'll release it 
to a sourceforge project once I've genericised it (and hopefully added A2K 
support). big thanks to the mdbtools group for the all great work

_________________________________________________________________
Hotmail is now available on Australian mobile phones. Go to  
http://ninemsn.com.au/mobilecentral/signup.asp

Re: [mdb-dev] RH 7.3 compatibility

[Luis M. C. M. <lu...@b2...>]

I created the mdbtools rpm for a RedHat 7.3.
I can send you it if you want.

At 11:21 13/06/2003 +0200, you wrote:
>I have a question, Is mdbtools 0.5 compatible with RedHat 7.3 ?
>
>I have a 7.3 with Ximian desktop 2.
>
>I have tried to install mdbtools from the source :
>./configure --with-unixodbc --enable-sql
>make
>And the compilation failed at /mdbtools-0.5/src/gmdb2/debug.c"
>
>I have tried --disable-debug but no effect.
>
>There is my error messages :
>
>debug.c: In function `gmdb_debug_display':
>debug.c:398: parse error before `*'
>debug.c:401: `store' undeclared (first use in this function)
>debug.c:401: (Each undeclared identifier is reported only once
>debug.c:401: for each function it appears in.)
>debug.c: In function `gmdb_debug_new_cb':
>debug.c:950: parse error before `*'
>debug.c:952: `tree' undeclared (first use in this function)
>debug.c:952: `store' undeclared (first use in this function)
>debug.c:954: parse error before `*'
>debug.c:963: parse error before `*'
>debug.c:964: `renderer' undeclared (first use in this function)
>debug.c:965: `column' undeclared (first use in this function)
>debug.c:969: parse error before `*'
>debug.c:971: warning: passing arg 1 of `gtk_tree_selection_set_mode'
>from incompatible pointer type
>make[3]: *** [debug.o] Erreur 1
>
>Please help !
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: INetU
>Attention Web Developers & Consultants: Become An INetU Hosting Partner.
>Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
>INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
>_______________________________________________
>mdbtools-dev mailing list
>mdb...@li...
>https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Luis Miguel Cruz Miranda.               |       B2B INTEGRAL, S.A.
CCNA - Systems Administrator            |       Pol. Ind. de Asipo
                                         |       C/A - Parcela 86-C
Tel: +34 902 506 605                    |       33.428 - CAYES - LLANERA
Fax:+34 985 980 794                     |       ASTURIAS (ESPA=D1A/SPAIN)

AVISO SOBRE CONFIDENCIALIDAD: Este mensaje y en su caso, sus anexos, se
dirige exclusivamente a su destinatario, por poder contener informaci=F3n
confidencial sometida a secreto profesional o cuya divulgaci=F3n est=E9
prohibida en virtud de la legislaci=F3n vigente, se informa a qui=E9n lo
recibiera sin ser el destinatario o persona autorizada por =E9ste, que la
informaci=F3n contenida en el mismo es reservada y su utilizaci=F3n o
divulgaci=F3n con cualquier fin est=E1 prohibida. Si ha recibido este
documento por error, le rogamos que nos lo comunique a la mayor brevedad
posible y proceda a su destrucci=F3n. =20

Re: [mdb-dev] RH 7.3 compatibility

[Martin M. <mar...@de...>]

Moin, moin, ...

"guillaume BITON @ Batinix" <gb...@ba...> wrote:

>I have a question, Is mdbtools 0.5 compatible with RedHat 7.3 ?

Question should be: Is mdbtools compatible with the compiler on my
system in order to fully compile ;-)

>debug.c: In function `gmdb_debug_display':
>debug.c:398: parse error before `*'
>debug.c:401: `store' undeclared (first use in this function)
>debug.c:401: (Each undeclared identifier is reported only once
>debug.c:401: for each function it appears in.)
>debug.c: In function `gmdb_debug_new_cb':
>debug.c:950: parse error before `*'
>debug.c:952: `tree' undeclared (first use in this function)
>debug.c:952: `store' undeclared (first use in this function)
>debug.c:954: parse error before `*'
>debug.c:963: parse error before `*'
>debug.c:964: `renderer' undeclared (first use in this function)
>debug.c:965: `column' undeclared (first use in this function)
>debug.c:969: parse error before `*'
>debug.c:971: warning: passing arg 1 of `gtk_tree_selection_set_mode'
>from incompatible pointer type
>make[3]: *** [debug.o] Erreur 1

What kind of gcc you are using?
Looks like you have a gcc higher that 3.x?
Consider using gcc < 3.x and test that.


kind regards

Martin Mewes

--=20
Novacote Flexpack - Division of COIM Deutschland GmbH
c/o IT/IS-Department - Hamburg - Germany

Re: [mdb-dev] An Example SQL (2)

[Peter S. <pet...@wa...>]

Le Jeudi 19 Juin 2003 19:16, Carlos Arias a =E9crit :
> Hi Adam and other ,
>
>     Yes of course,  you are right,  the same happens  in my
> Linux+PHP4+unixODBC+mdbtools. is it a bug?
>     I 've installed the last version of all needed soft.
>     I 've tried to solve this and i haven't had any data from tables
> when i try to use the "WHERE" clause.
>     Then i execute "SELECT * FROM table" and they export the data to
> postgreSQL (all all all data).
>     This solves half of my problems.
>     But, fun haven't finished.
>     One of the tables has only one column of type date/time and when i
> try to read this table again, any response from php, in my netscape
> browser "The document contains no data".
>      This is horrible, i don't know what to to.
>     Has anyone any idea to solve this trouble?
>     can mdbtools read one table with one colum of type date/time?
>     can mdbtools use the "WHERE" clause?
> Could someone help me?
> Any help will be wellcome.
>
> Regards.

Hello,
Yes, mdbtools knows to read day-time colums of access97 and access 2000.
There is another problem I think.
You told from import to postgr=E9 and then reading with php if I understo=
od=20
well.
I don't know postgr=E9,
but I tried importing in mysql and read that mysql understand only=20
date-time-values in
year-month-day (yyyy-mm-dd hh:mm:ss) format, whereas mdbtools exports in =
the=20
format given by the database (my tries where with german date formats).
My idea is (when I'll have time) to write a script which changes the date=
=20
formats before importation in another database.

I think there is still some work to do for mdbtools but it seems to be th=
e=20
only serious project trying to read and export datas from MS-Access direc=
tly=20
in Linux. So I will write a postcard to the developper Brian Bruns. I wou=
ld=20
like to help more but I don't know enough :-)

Regards
peter
--=20
Peter Stopschinski
pet...@wa...

[mdb-dev] An Example SQL (2)

[Carlos A. <ka...@ar...>]

Hi Adam and other ,

    Yes of course,  you are right,  the same happens  in my 
Linux+PHP4+unixODBC+mdbtools. is it a bug?
    I 've installed the last version of all needed soft.
    I 've tried to solve this and i haven't had any data from tables 
when i try to use the "WHERE" clause.
    Then i execute "SELECT * FROM table" and they export the data to 
postgreSQL (all all all data).
    This solves half of my problems.
    But, fun haven't finished.
    One of the tables has only one column of type date/time and when i 
try to read this table again, any response from php, in my netscape 
browser "The document contains no data".
     This is horrible, i don't know what to to.
    Has anyone any idea to solve this trouble?
    can mdbtools read one table with one colum of type date/time?
    can mdbtools use the "WHERE" clause?
Could someone help me?
Any help will be wellcome.

Regards.

[mdb-dev] Little modif

[guillaume B. @ B. <gb...@ba...>]

Hi,

I have made some modification on two files to make mdbtools-0.5 running
under my RedHat 7.3 with Ximian Desktop 2.

The modification are just declaration of variables and some types fixes.

This two files are in /src/gmdb2/

Regards,
Guillaume Biton

[mdb-dev] RH 7.3 compatibility

[guillaume B. @ B. <gb...@ba...>]

I have a question, Is mdbtools 0.5 compatible with RedHat 7.3 ?

I have a 7.3 with Ximian desktop 2.

I have tried to install mdbtools from the source :
./configure --with-unixodbc --enable-sql
make
And the compilation failed at /mdbtools-0.5/src/gmdb2/debug.c"

I have tried --disable-debug but no effect.

There is my error messages :

debug.c: In function `gmdb_debug_display':
debug.c:398: parse error before `*'
debug.c:401: `store' undeclared (first use in this function)
debug.c:401: (Each undeclared identifier is reported only once
debug.c:401: for each function it appears in.)
debug.c: In function `gmdb_debug_new_cb':
debug.c:950: parse error before `*'
debug.c:952: `tree' undeclared (first use in this function)
debug.c:952: `store' undeclared (first use in this function)
debug.c:954: parse error before `*'
debug.c:963: parse error before `*'
debug.c:964: `renderer' undeclared (first use in this function)
debug.c:965: `column' undeclared (first use in this function)
debug.c:969: parse error before `*'
debug.c:971: warning: passing arg 1 of `gtk_tree_selection_set_mode'
from incompatible pointer type
make[3]: *** [debug.o] Erreur 1

Please help !

[mdb-dev] German Umlaute?

[<Tho...@Be...>]

hi there,

I have to extract data from a DB given to me which contains german umlaute
in the field names.

Unfortunately I'm not able to change this, but have to read data from this
fields. 

If I try this with mdbtools I alway get a 'parse error' message. I have no
idea how to handle this. Could anyone give me a hint?

Any help would be appreciated!

TIA

Thorsten Klein

IT-Consultant/Web-Developer
GWV Fachverlage: Gabler.Vieweg. WV.Teubner   
D-65189 Wiesbaden

[mdb-dev] An Example SQL

[Adam W. <awi...@wh...>]

I'm in the process of updating my Data Access presentation for a
re-showing in a couple of weeks.  So I'm testing the current version of
MDB Tools.

Unfortunately I can't get an SQL with a where clause to execute.

"select * from employees" works.

but "select * from employees where city = 'Haslett'" returns nothing. 
It shoudl return several rows.  And "select * from Employees where
Active = 1" returns every row, even where active = 0.

Maybe I'm missing some sytax quirck?

Re: [mdb-dev] [PATCH] implement handling of encrypted databases

[Brian B. <ca...@ai...>]

Ok, you are there.  no problem by me doing a 0.5.1 release.  I had big 
plans of getting write support going for 0.6, but it's pretty hairy and I 
flat ran out of time.

Brian

On Wed, 21 May 2003, David Mansfield wrote:

> 
> > David,
> > 
> > Send me your sourceforge account name and I'll give you check in rights.  
> > Sorry I dont have time to merge the patches but I'm in the process of 
> > moving, ehh!
> > 
> 
> Ok.  I have a sourceforge user: davidlmansfield my email there is 
> sf...@dm....
> 
> I think checking these fixes in as a 'maintenance' release, 0.5.1 would be 
> a good thing, as well as committing to the HEAD.  Do you agree?
> 
> David
> 
> 
> 

Re: [mdb-dev] [PATCH] implement handling of encrypted databases

[David M. <mdb...@dm...>]

> David,
> 
> Send me your sourceforge account name and I'll give you check in rights.  
> Sorry I dont have time to merge the patches but I'm in the process of 
> moving, ehh!
> 

Ok.  I have a sourceforge user: davidlmansfield my email there is 
sf...@dm....

I think checking these fixes in as a 'maintenance' release, 0.5.1 would be 
a good thing, as well as committing to the HEAD.  Do you agree?

David


-- 
/==============================\
| David Mansfield              |
| mdb...@db...       |
\==============================/

Re: [mdb-dev] [PATCH] implement handling of encrypted databases

[Brian B. <ca...@ai...>]

David,

Send me your sourceforge account name and I'll give you check in rights.  
Sorry I dont have time to merge the patches but I'm in the process of 
moving, ehh!

Brian

On Thu, 15 May 2003 da...@co... wrote:

> 
> Hi Brian,
> 
> This patch (on top of all of my other patches, 00 thru 18, which I can
> resend to you if you want) implements handling of encrypted databases.
> 
> The technique for encrypting databases by access appears to be as follows:
> 
> - each data page except for page 0 (2k pages for jet3, 4k for jet4) is
> encrypted separately using the RC4 algorithm and with a different key
> 
> - the key can be obtained by XORing together the following:
> 
>   - the database key, found at offset 0x3e from the start of the file
>   - the 'unencrypted' key, found at offset 0x3e of any unencrypted 
>     database (this appears to be 0x4ebc8afb when taking endianness 
>     into account)
>   - the page number
> 
> The existing code already extracted the database key, and XORed it with 
> the number 0xe15e01b9.  I don't know where this number came from, but I 
> can imagine there may be more than one 'unencrypted' key.  I added the rc4 
> routines to src/libmdb/file.c.  They could be replaced easily with calls 
> to openssl (the interface I used is almost identical to the openssl 
> routines).
> 
> This works for the one encrypted database I needed to access. YMMV.
> 
> David
> 
> P.S. to enable other people to find this post with a search engine I 
> include the following keywords.  I had a really hard time finding out 
> information about this topic.
> 
> msaccess microsoft ac97 access97 mdb dbEncrypt CompactDatabase
> 
> 
> 

[mdb-dev] [PATCH] implement handling of encrypted databases

[David M. <mdb...@dm...>]

This is a resend of a prior message.  It was sent under the wrong mail 
account and is being held up since that account is not subscribed.

David

-- 
/==============================\
| David Mansfield              |
| mdb...@db...       |
\==============================/

---------- Forwarded message ----------

Hi Brian,

This patch (on top of all of my other patches, 00 thru 18, which I can
resend to you if you want) implements handling of encrypted databases.

The technique for encrypting databases by access appears to be as follows:

- each data page except for page 0 (2k pages for jet3, 4k for jet4) is
encrypted separately using the RC4 algorithm and with a different key

- the key can be obtained by XORing together the following:

  - the database key, found at offset 0x3e from the start of the file
  - the 'unencrypted' key, found at offset 0x3e of any unencrypted 
    database (this appears to be 0x4ebc8afb when taking endianness 
    into account)
  - the page number

The existing code already extracted the database key, and XORed it with 
the number 0xe15e01b9.  I don't know where this number came from, but I 
can imagine there may be more than one 'unencrypted' key.  I added the rc4 
routines to src/libmdb/file.c.  They could be replaced easily with calls 
to openssl (the interface I used is almost identical to the openssl 
routines).

This works for the one encrypted database I needed to access. YMMV.

David

P.S. to enable other people to find this post with a search engine I 
include the following keywords.  I had a really hard time finding out 
information about this topic.

msaccess microsoft ac97 access97 mdb dbEncrypt CompactDatabase

[mdb-dev] [PATCH] implement handling of encrypted databases

[<da...@co...>]

Hi Brian,

This patch (on top of all of my other patches, 00 thru 18, which I can
resend to you if you want) implements handling of encrypted databases.

The technique for encrypting databases by access appears to be as follows:

- each data page except for page 0 (2k pages for jet3, 4k for jet4) is
encrypted separately using the RC4 algorithm and with a different key

- the key can be obtained by XORing together the following:

  - the database key, found at offset 0x3e from the start of the file
  - the 'unencrypted' key, found at offset 0x3e of any unencrypted 
    database (this appears to be 0x4ebc8afb when taking endianness 
    into account)
  - the page number

The existing code already extracted the database key, and XORed it with 
the number 0xe15e01b9.  I don't know where this number came from, but I 
can imagine there may be more than one 'unencrypted' key.  I added the rc4 
routines to src/libmdb/file.c.  They could be replaced easily with calls 
to openssl (the interface I used is almost identical to the openssl 
routines).

This works for the one encrypted database I needed to access. YMMV.

David

P.S. to enable other people to find this post with a search engine I 
include the following keywords.  I had a really hard time finding out 
information about this topic.

msaccess microsoft ac97 access97 mdb dbEncrypt CompactDatabase


-- 
/==============================\ 
| David Mansfield              | 
| mdb...@db...       | 
\==============================/

[mdb-dev] Build problems

[Joseph W. <jo...@kd...>]

Hi

Today I updated my anonymous cvs checkout again and have compile
problems. The build fails in src/libmdb because of a missing props.c
file.

It looks like the file is missing in CVS and I can't see anywhere that
it should be automatically generated.

Kind regards
Joseph Wenninger

[mdb-dev] Encrypted MDB Files => Segmentation fault

[<al...@fr...>]

Encrypted MDB Files => Segmentation fault
I had systematic crash :
Segmentation fault
until I understand that Encrypted files seem to be unsupported
May be you have got a solution ??
I found à WINDOWS based (free) Program who Decrypts the files
but cant be used on Command line mode it interactively
and asks for the source and dest throuh win API
I sent to the author this mail, may be it would be

interresting for you to contact eac other
Best regards

Andre LACHAUD

the author Serge Gavrilov http://www.pdmi.ras.ru/~serge/

sg...@ma... <sg...@ma...>;
sg...@ne... <sg...@ne...>
se...@pd...

Hello
I have seen your tool to decrypt MDB
I need to use it like that

mdbdc Crypt.mdb Decrypt.mdb

and after it will be processed by mdbtools
May be you have tools to extract schema and/or Data Directly from files

Is it possible to get source of your tool to use it under Linux
and as a command line tool


May be you don't know but there is a project

http://sourceforge.net/projects/mdbtools/

To extract data from mdb files directly
but they actually do not support Encrypted files
These tools extract tables, schema etc...