Attachments suddenly corrupted

[Booze_]

Hi There,

We are using phpMyFAQ 2.7.9, and after a few patches of the linux os, all the attachments are corrupted. While opening an attached pdf document i wil get a notification: "Adobe Reader could not open … because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn’t correctly decoded).

Last friday the attachments worked correctly, so the files should be correct. This happens with al the attachments, files with another extension also results in error messages

Newly posted attachments also won't work.

Any Idea's someone?

[Thorsten]

Hi,

what did you changed?

bye
Thorsten

[Booze_]

Hi Thorsten,

I'm running Ubuntu Server 12.04.1LTS X64, i've done a system upgrade with the folowing commands:

aptitude update
aptitude safe-upgrade

The logs of the upgrade:
2013-01-20 02:30:52 startup archives unpack
2013-01-20 02:30:53 install linux-headers-3.2.0-36 <none> 3.2.0-36.57
2013-01-20 02:30:53 status half-installed linux-headers-3.2.0-36 3.2.0-36.57
2013-01-20 02:31:03 status unpacked linux-headers-3.2.0-36 3.2.0-36.57
2013-01-20 02:31:03 status unpacked linux-headers-3.2.0-36 3.2.0-36.57
2013-01-20 02:31:03 install linux-headers-3.2.0-36-generic <none> 3.2.0-36.57
2013-01-20 02:31:03 status half-installed linux-headers-3.2.0-36-generic 3.2.0-$
2013-01-20 02:31:05 status unpacked linux-headers-3.2.0-36-generic 3.2.0-36.57
2013-01-20 02:31:05 status unpacked linux-headers-3.2.0-36-generic 3.2.0-36.57
2013-01-20 02:31:05 upgrade linux-headers-server 3.2.0.35.40 3.2.0.36.43
2013-01-20 02:31:05 status half-configured linux-headers-server 3.2.0.35.40
2013-01-20 02:31:06 status unpacked linux-headers-server 3.2.0.35.40
2013-01-20 02:31:06 status half-installed linux-headers-server 3.2.0.35.40
2013-01-20 02:31:06 status half-installed linux-headers-server 3.2.0.35.40
2013-01-20 02:31:06 status unpacked linux-headers-server 3.2.0.36.43
2013-01-20 02:31:06 status unpacked linux-headers-server 3.2.0.36.43
2013-01-20 02:31:07 startup packages remove
2013-01-20 02:31:07 status installed linux-headers-3.2.0-35-generic 3.2.0-35.55
2013-01-20 02:31:07 remove linux-headers-3.2.0-35-generic 3.2.0-35.55 <none>
2013-01-20 02:31:07 status half-configured linux-headers-3.2.0-35-generic 3.2.0$
2013-01-20 02:31:07 status half-installed linux-headers-3.2.0-35-generic 3.2.0-$
2013-01-20 02:31:09 status config-files linux-headers-3.2.0-35-generic 3.2.0-35$
2013-01-20 02:31:09 status config-files linux-headers-3.2.0-35-generic 3.2.0-35$
2013-01-20 02:31:09 status config-files linux-headers-3.2.0-35-generic 3.2.0-35$
2013-01-20 02:31:09 status not-installed linux-headers-3.2.0-35-generic <none>
2013-01-20 02:31:09 status installed linux-headers-3.2.0-35 3.2.0-35.55
2013-01-20 02:31:09 remove linux-headers-3.2.0-35 3.2.0-35.55 <none>
2013-01-20 02:31:09 status half-configured linux-headers-3.2.0-35 3.2.0-35.55
2013-01-20 02:31:09 status half-installed linux-headers-3.2.0-35 3.2.0-35.55
2013-01-20 02:31:10 status config-files linux-headers-3.2.0-35 3.2.0-35.55
2013-01-20 02:31:11 status config-files linux-headers-3.2.0-35 3.2.0-35.55
2013-01-20 02:31:11 status config-files linux-headers-3.2.0-35 3.2.0-35.55
2013-01-20 02:31:11 status not-installed linux-headers-3.2.0-35 <none>
2013-01-20 02:31:12 startup archives unpack
2013-01-20 02:31:12 upgrade dpkg 1.16.1.2ubuntu7 1.16.1.2ubuntu7.1
2013-01-20 02:31:12 status half-configured dpkg 1.16.1.2ubuntu7
2013-01-20 02:31:12 status unpacked dpkg 1.16.1.2ubuntu7
2013-01-20 02:31:12 status half-installed dpkg 1.16.1.2ubuntu7
2013-01-20 02:31:12 status triggers-pending man-db 2.6.1-2ubuntu1
2013-01-20 02:31:12 status half-installed dpkg 1.16.1.2ubuntu7
2013-01-20 02:31:14 status half-installed dpkg 1.16.1.2ubuntu7
2013-01-20 02:31:14 status unpacked dpkg 1.16.1.2ubuntu7.1
2013-01-20 02:31:14 status unpacked dpkg 1.16.1.2ubuntu7.1
2013-01-20 02:31:14 trigproc man-db 2.6.1-2ubuntu1 2.6.1-2ubuntu1
2013-01-20 02:31:14 status half-configured man-db 2.6.1-2ubuntu1
2013-01-20 02:31:19 status installed man-db 2.6.1-2ubuntu1
2013-01-20 02:31:19 startup packages configure
2013-01-20 02:31:19 configure dpkg 1.16.1.2ubuntu7.1 <none>
2013-01-20 02:31:19 status unpacked dpkg 1.16.1.2ubuntu7.1
2013-01-20 02:31:19 status unpacked dpkg 1.16.1.2ubuntu7.1
2013-01-20 02:31:20 status unpacked dpkg 1.16.1.2ubuntu7.1
2013-01-20 02:31:20 status unpacked dpkg 1.16.1.2ubuntu7.1
2013-01-20 02:31:20 status unpacked dpkg 1.16.1.2ubuntu7.1
2013-01-20 02:31:20 status unpacked dpkg 1.16.1.2ubuntu7.1
2013-01-20 02:31:20 status half-configured dpkg 1.16.1.2ubuntu7.1
2013-01-20 02:31:20 status installed dpkg 1.16.1.2ubuntu7.1
2013-01-20 02:31:30 startup archives unpack
2013-01-20 02:31:31 upgrade libfreetype6 2.4.8-1ubuntu2 2.4.8-1ubuntu2.1
2013-01-20 02:31:31 status half-configured libfreetype6 2.4.8-1ubuntu2
2013-01-20 02:31:31 status unpacked libfreetype6 2.4.8-1ubuntu2
2013-01-20 02:31:31 status half-installed libfreetype6 2.4.8-1ubuntu2
2013-01-20 02:31:31 status half-installed libfreetype6 2.4.8-1ubuntu2
2013-01-20 02:31:31 status unpacked libfreetype6 2.4.8-1ubuntu2.1
2013-01-20 02:31:31 status unpacked libfreetype6 2.4.8-1ubuntu2.1
2013-01-20 02:31:32 install linux-image-3.2.0-36-generic <none> 3.2.0-36.57
2013-01-20 02:31:32 status half-installed linux-image-3.2.0-36-generic 3.2.0-36$
2013-01-20 02:31:49 status unpacked linux-image-3.2.0-36-generic 3.2.0-36.57
2013-01-20 02:31:49 status unpacked linux-image-3.2.0-36-generic 3.2.0-36.57
2013-01-20 02:31:49 upgrade linux-server 3.2.0.35.40 3.2.0.36.43
2013-01-20 02:31:49 status half-configured linux-server 3.2.0.35.40
2013-01-20 02:31:50 status unpacked linux-server 3.2.0.35.40
2013-01-20 02:31:50 status half-installed linux-server 3.2.0.35.40
2013-01-20 02:31:50 status half-installed linux-server 3.2.0.35.40
2013-01-20 02:31:50 status unpacked linux-server 3.2.0.36.43
2013-01-20 02:31:50 status unpacked linux-server 3.2.0.36.43
2013-01-20 02:31:50 upgrade linux-image-server 3.2.0.35.40 3.2.0.36.43
2013-01-20 02:31:50 status half-configured linux-image-server 3.2.0.35.40
2013-01-20 02:31:50 status unpacked linux-image-server 3.2.0.35.40
2013-01-20 02:31:50 status half-installed linux-image-server 3.2.0.35.40
2013-01-20 02:31:50 status half-installed linux-image-server 3.2.0.35.40
2013-01-20 02:31:50 status unpacked linux-image-server 3.2.0.36.43
2013-01-20 02:31:50 status unpacked linux-image-server 3.2.0.36.43
2013-01-20 02:31:51 upgrade linux-libc-dev 3.2.0-35.55 3.2.0-36.57
2013-01-20 02:31:51 status half-configured linux-libc-dev 3.2.0-35.55
2013-01-20 02:31:51 status unpacked linux-libc-dev 3.2.0-35.55
2013-01-20 02:31:51 status half-installed linux-libc-dev 3.2.0-35.55
2013-01-20 02:31:52 status half-installed linux-libc-dev 3.2.0-35.55
2013-01-20 02:31:52 status unpacked linux-libc-dev 3.2.0-36.57
2013-01-20 02:31:52 status unpacked linux-libc-dev 3.2.0-36.57
2013-01-20 02:31:52 startup packages configure
2013-01-20 02:31:53 configure linux-headers-3.2.0-36 3.2.0-36.57 <none>
2013-01-20 02:31:53 status unpacked linux-headers-3.2.0-36 3.2.0-36.57
2013-01-20 02:31:53 status half-configured linux-headers-3.2.0-36 3.2.0-36.57
2013-01-20 02:31:53 status installed linux-headers-3.2.0-36 3.2.0-36.57
2013-01-20 02:31:53 configure linux-headers-3.2.0-36-generic 3.2.0-36.57 <none>
2013-01-20 02:31:53 status unpacked linux-headers-3.2.0-36-generic 3.2.0-36.57
2013-01-20 02:31:53 status half-configured linux-headers-3.2.0-36-generic 3.2.0$
2013-01-20 02:31:53 status installed linux-headers-3.2.0-36-generic 3.2.0-36.57
2013-01-20 02:31:53 configure linux-headers-server 3.2.0.36.43 <none>
2013-01-20 02:31:53 status unpacked linux-headers-server 3.2.0.36.43
2013-01-20 02:31:53 status half-configured linux-headers-server 3.2.0.36.43
2013-01-20 02:31:53 status installed linux-headers-server 3.2.0.36.43
2013-01-20 02:31:53 configure libfreetype6 2.4.8-1ubuntu2.1 <none>
2013-01-20 02:31:53 status unpacked libfreetype6 2.4.8-1ubuntu2.1
2013-01-20 02:31:53 status half-configured libfreetype6 2.4.8-1ubuntu2.1
2013-01-20 02:31:53 status installed libfreetype6 2.4.8-1ubuntu2.1
2013-01-20 02:31:53 status triggers-pending libc-bin 2.15-0ubuntu10.3
2013-01-20 02:31:53 configure linux-image-3.2.0-36-generic 3.2.0-36.57 <none>
2013-01-20 02:31:53 status unpacked linux-image-3.2.0-36-generic 3.2.0-36.57
2013-01-20 02:31:53 status half-configured linux-image-3.2.0-36-generic 3.2.0-3$
2013-01-20 02:32:26 status installed linux-image-3.2.0-36-generic 3.2.0-36.57
2013-01-20 02:32:26 configure linux-image-server 3.2.0.36.43 <none>
2013-01-20 02:32:26 status unpacked linux-image-server 3.2.0.36.43
2013-01-20 02:32:26 status half-configured linux-image-server 3.2.0.36.43
2013-01-20 02:32:26 status installed linux-image-server 3.2.0.36.43
2013-01-20 02:32:27 configure linux-server 3.2.0.36.43 <none>
2013-01-20 02:32:27 status unpacked linux-server 3.2.0.36.43
2013-01-20 02:32:27 status half-configured linux-server 3.2.0.36.43
2013-01-20 02:32:27 status installed linux-server 3.2.0.36.43
2013-01-20 02:32:27 configure linux-libc-dev 3.2.0-36.57 <none>
2013-01-20 02:32:27 status unpacked linux-libc-dev 3.2.0-36.57
2013-01-20 02:32:27 status half-configured linux-libc-dev 3.2.0-36.57
2013-01-20 02:32:27 status installed linux-libc-dev 3.2.0-36.57
2013-01-20 02:32:27 trigproc libc-bin 2.15-0ubuntu10.3 <none>
2013-01-20 02:32:27 status half-configured libc-bin 2.15-0ubuntu10.3
2013-01-20 02:32:27 status installed libc-bin 2.15-0ubuntu10.3

This is exactly what i've done, nothing more.

Thanks in advance for any help!

[Booze_]

This also might be usefull:

phpMyFAQ Version phpMyFAQ 2.7.9
Server Software Apache/2.2.22 (Ubuntu)
PHP Version PHP 5.3.10-1ubuntu3.4
Register Globals off
Safe Mode off
Open Basedir off
DB Server Mysql
DB Client Version 5.5.28
DB Server Version 5.5.28-0ubuntu0.12.04.3
Webserver Interface APACHE2HANDLER
PHP Extensions Core, date, ereg, libxml, openssl, pcre, zlib, bcmath, bz2, calendar, ctype, dba, dom, hash, fileinfo, filter, ftp, gettext, SPL, iconv, json, mbstring, session, posix, Reflection, standard, shmop, SimpleXML, soap, sockets, Phar, exif, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, zip, apache2handler, curl, gd, imagick, imap, mcrypt, mysql, mysqli, PDO, pdo_mysql, mhash

[Thorsten]

HI,

could be everything. Is it possible to get a downloaded PDF? Did you enable encryption?

bye
Thorsten

[Booze_]

I haven't enabled encryption as far as I know, i've tried to attach a pdf file which i've downloaded from phpmyfaq, but this forum says: "The uploaded file is empty"

[Thorsten]

HI,

you can send me a file by e-mail to thorsten AT phpmyfaq DOT de

bye
Thorsten

[Booze_]

Hi Thorsten,

With sending an e-mail I've got the same problem, de files are 0 bytes after downloading, as far as i know it shouldn't be posible to create a file of 0 bytes, every program which i can use to send the file imediatly says it's corrupt.

After checking the configuration files the encryption option is set (is that by default?), and there is no key set as far as I can see. In the database in table faqattachment al the password_hash all fields are empty, so it looks like there aint an encryption key is set, is that correct?

When I go to the directory structure of the attachmentdir, I can clearly see that the files are encrypted, all of them, there are no unencrypted files.

There isn't a backup of last week, we had just filled the database last week, and I've configured a backuproutine of the server after the updates I've installed.

It seems to me that someone has changed the configuration settings of the attachments, is there any way to see that in a logfile?

Cheers!

[Thorsten]

Hi,

yes, there's an admin logging if it's enabled where you can check what was done in the admin backend.

bye
Thorsten