Your message dated Sun, 08 Nov 2020 17:34:50 +0000 with message-id <e1kboay-00038u...@fasolo.debian.org> and subject line Bug#888045: fixed in mdbtools 0.9.0~beta5-1 has caused the Debian Bug report #888045, regarding mdbtools: mdb-schema fails with archives greater than 2 GByte on i386 architecture to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact ow...@bugs.debian.org immediately.) -- 888045: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=888045 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
--- Begin Message ---Package: mdbtools Version: 0.7.1-5 Severity: normal Dear Maintainer, *** Reporter, please consider answering these questions, where appropriate *** * What led up to the situation? I've tried to export the schema of a Microsoft Access Database (MDB) file as SQL text. The MDB file size is 2147483648 bytes (2GByte). * What exactly did you do (or not do) that was effective (or ineffective)? I have used the following comman ds given as a regular user: $ ls -lha *.mdb -rwxrwxrwx 1 root root 2,0G gen 22 21:05 test.mdb $ file test.mdb test.mdb: Microsoft Access Database $ mdb-schema ./test.mdb mysql File not found Could not open file As you can see, the command mdb-schema fails without reason. I have traced the error using gdb up to the failure of function stat() in the source file mdbtools-0.7.1/src/libmdb/file.c at line 121: 105 /** 106 * mdb_find_file: 107 * @filename: path to MDB (database) file 108 * 109 * Finds and returns the absolute path to an MDB file. Function will first try 110 * to fstat file as passed, then search through the $MDBPATH if not found. 111 * 112 * Return value: gchar pointer to absolute path. Caller is responsible for 113 * freeing. 114 **/ 115 static char *mdb_find_file(const char *file_name) 116 { 117 struct stat status; 118 gchar *mdbpath, **dir, *tmpfname; 119 unsigned int i = 0; 120 /* try the provided file name first */ 121 if (!stat(file_name, &status)) { 122 char *result; 123 result = g_strdup(file_name); 124 if (!result) 125 fprintf(stderr, "Can't alloc filename\n"); 126 return result; 127 } The stat(..) function fails with error code "EOVERFLOW",due to overflow in fields of struct stat caused by file size greater 2G because the package is compiled for 32 bit (i386) architeture. This can be overcomed rebuilding mdbtools package using the _FILE_OFFSET_BITS=64 and _LARGEFILE64_SOURCE compiler options as reported by stat() linux man page; for example: $ su -c "apt-get source mdbtools" $ su -c "apt-get build-dep mdbtools" $ cd mdbtools-0.7.1 $ DEB_BUILD_OPTIONS='nostrip noopt debug' \ CFLAGS='-D_FILE_OFFSET_BITS=64 -D_LARGEFILE64_SOURCE' \ dpkg-buildpackage -b -uc -us $ su -c "dpkg -i ../*.deb" Can these compiler options (CFLAGS='-D_FILE_OFFSET_BITS=64 -D_LARGEFILE64_SOURCE') be included in Debian 32 bit (i386) standard packaging ? * What was the outcome of this action? The SQL schema was not generated, the error "file not found" was shown, instead. After rebuilding the pacakge with _FILE_OFFSET_BITS=64 and _LARGEFILE64_SOURCE compiler options, the mdb-schema program correctly opened the MDB file with size greater than 2 GByte on 32 bit (i386) architecture. * What outcome did you expect instead? The SQL schema was expected on /dev/stdout. After rebuilding the pacakge with _FILE_OFFSET_BITS=64 and _LARGEFILE64_SOURCE compiler options, the mdb-schema program correctly opened the MDB file with size greater than 2 GByte on 32 bit (i386) architecture. *** End of the template - remove these template lines *** -- System Information: Debian Release: buster/sid APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 4.14.0-1-686-pae (SMP w/1 CPU core) Locale: LANG=it_IT.utf8, LC_CTYPE=it_IT.utf8 (charmap=UTF-8), LANGUAGE=it_IT.utf8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages mdbtools depends on: ii libc6 2.25-5 ii libglib2.0-0 2.54.2-4 ii libmdb2 0.7.1-5 ii libmdbsql2 0.7.1-5 ii libreadline7 7.0-3 mdbtools recommends no packages. Versions of packages mdbtools suggests: ii bash-completion 1:2.1-4.3 pn mdbtools-doc <none> -- no debconf information
--- End Message ---
--- Begin Message ---Source: mdbtools Source-Version: 0.9.0~beta5-1 Done: =?utf-8?q?Jean-Michel_Vourg=C3=A8re?= <nir...@debian.org> We believe that the bug you reported is fixed in the latest version of mdbtools, which is due to be installed in the Debian FTP archive. A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to 888...@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Jean-Michel Vourgère <nir...@debian.org> (supplier of updated mdbtools package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing ftpmas...@ftp-master.debian.org) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Format: 1.8 Date: Sun, 08 Nov 2020 17:56:47 +0100 Source: mdbtools Binary: libmdb3 libmdb3-dbgsym libmdbsql3 libmdbsql3-dbgsym mdbtools mdbtools-dbgsym mdbtools-dev mdbtools-doc odbc-mdbtools odbc-mdbtools-dbgsym Architecture: source Version: 0.9.0~beta5-1 Distribution: unstable Urgency: medium Maintainer: Jean-Michel Vourgère <nir...@debian.org> Changed-By: Jean-Michel Vourgère <nir...@debian.org> Description: libmdb3 - Core library for accessing JET / MS Access (MDB) files libmdbsql3 - mdbtools SQL library mdbtools - JET / MS Access database (MDB) tools mdbtools-dev - mdbtools development files mdbtools-doc - Documentation for MDB tools odbc-mdbtools - MDB tools ODBC driver Closes: 888045 Changes: mdbtools (0.9.0~beta5-1) unstable; urgency=medium . * New upstream beta. (Closes: #888045) Checksums-Sha1: c2e3d37dbc098a44702fbd1d6b096ec2b41b3c1e 2363 mdbtools_0.9.0~beta5-1.dsc 6bea552a252df673cfdd80b6f0f5740027792098 182906 mdbtools_0.9.0~beta5.orig.tar.gz 1df19d98f5eb2b3d51aef25cb95d15a87ebf5f22 18732 mdbtools_0.9.0~beta5-1.debian.tar.xz Checksums-Sha256: 0cbbdf2f3af0de13f4518abbb3dc55bf1626942ce75d13c2a07c484e0989b277 2363 mdbtools_0.9.0~beta5-1.dsc 87e55be9fe4b02e240b54cf9b67608f871f273274cd4636bef642434382f5137 182906 mdbtools_0.9.0~beta5.orig.tar.gz 704844b2a3a8a2e7373e9dc7c65fc3a04d826dc8cf1ea9f31c378cd6bec138f4 18732 mdbtools_0.9.0~beta5-1.debian.tar.xz Files: 8928dfd7d4e6f489db0d7ebe19445096 2363 database optional mdbtools_0.9.0~beta5-1.dsc 22163b129da437ec9915eba8a2a7a5d8 182906 database optional mdbtools_0.9.0~beta5.orig.tar.gz d2e98161fb069aa41107d1620d72b1f0 18732 database optional mdbtools_0.9.0~beta5-1.debian.tar.xz -----BEGIN PGP SIGNATURE----- iQJGBAEBCgAwFiEEQIMD57NJdABlZVMrO1wscaIY2DwFAl+oJbgSHG5pcmdhbEBk ZWJpYW4ub3JnAAoJEDtcLHGiGNg8588QAJvHhgfUq6AYMuw1Ff/ba8ouwvq/xbLg EjnGyEi1/b+plU1UcT5eg3AWseFnOVeNrcCKm0HsHgKPtY+9Pa/Vum/UthzsUsS6 w6/dlD5vFiBwAaLRbyapjQBlsd8LXE09kCj5+/VMNIhW6ap46LjLOQYvCGFq0/4Y kHl9UTKn4HJgzDbmP+hKBjZ5eJHjHNSttbxJZ0WsERM4QFafTNNVhnNjVVqknnWB cNprzezLpG5ooLin6Rd20wKbOra+KL6149YJEqCM7OaDRouPOQkGXFDRM2ATvIlW 97CFch9euq2RG+6b1svOA8V0iQaxkHv7R11MrEh6AvkdoOdoTzqWCfpe4BW1xHGs sgSHYkhoDskbH6SDmB8rFBAeNbqhpiRhRm4S+rHRKqufOn0KucMTnrwoYFgtb/IT Cyepb6DnenjZzGVTTJuqVEFC4yJ7KyPf/IDMobRN0EwyghwUw97sgcE0IoX5nqx5 iU63nXaLc0VYm3p8GDjY3SQ0riEtXeFcSS22/WiCfo9OJPtT2Mq8OKSIkJ/I51wZ fSkH5pXtzc7a/H2kZwA6ojIV3sr8oKFGEoImmb7ygrouuNJQkATMaPcAgl7ZZdxo UOgg1ELAtV8OlGq4IK3i0ed0RR6VCjvW0dhgGV7zLmWh3b7YTb3TWdFz5VuC5ug5 h3K6lJBlFQhI =klZr -----END PGP SIGNATURE-----
--- End Message ---
