[Cdash] Weird problem with uploading project logo

[Marcel Loose]

Hi Julien,

The following php5-zlib is installed: php5-zlib-5.2.14-0.7.24.1
However, I noticed that this rpm is only installed on the production
machine!

Here are the differences w.r.t. installed php rpm's:

test machine                            production machine
-------------------------------------------------------------------------
apache2-mod_php5-5.2.14-0.7.24.1        apache2-mod_php5-5.2.14-0.7.24.1
php5-5.2.14-0.7.24.1                    php5-5.2.14-0.7.24.1
php5-ctype-5.2.14-0.7.24.1              php5-ctype-5.2.14-0.7.24.1
                                      > php5-curl-5.2.14-0.7.24.1
php5-dom-5.2.14-0.7.24.1                php5-dom-5.2.14-0.7.24.1
php5-gd-5.2.14-0.7.24.1                 php5-gd-5.2.14-0.7.24.1
                                      > php5-gettext-5.2.14-0.7.24.1
php5-hash-5.2.14-0.7.24.1               php5-hash-5.2.14-0.7.24.1
php5-iconv-5.2.14-0.7.24.1              php5-iconv-5.2.14-0.7.24.1
php5-json-5.2.14-0.7.24.1               php5-json-5.2.14-0.7.24.1
                                      > php5-ldap-5.2.14-0.7.24.1
php5-mysql-5.2.14-0.7.24.1              php5-mysql-5.2.14-0.7.24.1
                                      > php5-openssl-5.2.14-0.7.24.1
php5-pdo-5.2.14-0.7.24.1                php5-pdo-5.2.14-0.7.24.1
php5-suhosin-5.2.14-0.7.24.1            php5-suhosin-5.2.14-0.7.24.1
php5-tokenizer-5.2.14-0.7.24.1          php5-tokenizer-5.2.14-0.7.24.1
php5-xmlreader-5.2.14-0.7.24.1          php5-xmlreader-5.2.14-0.7.24.1
php5-xmlwriter-5.2.14-0.7.24.1          php5-xmlwriter-5.2.14-0.7.24.1
php5-xsl-5.2.14-0.7.24.1                php5-xsl-5.2.14-0.7.24.1
                                      > php5-zlib-5.2.14-0.7.24.1


The MySQL database encoding is somewhat strange in my opinion (see
below). However, the encoding on production and test machine is
identical! So that wouldn't explain why uploading works on the test
machine and fails on the production machine.


mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

mysql> show variables like 'collation%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database   | latin1_swedish_ci |
| collation_server     | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)


Best regards,
Marcel Loose.


On Sat, 2011-07-09 at 10:15 +0200, Julien Jomier wrote:
> Hi Marcel,
> 
> Could you check the encoding of the database? It should be UTF-8. Also

> could you make sure that the server with the issue as the zlib
libraries 
> for PHP?
> 
> Julien
> 
> On 08/07/2011 15:05, Marcel Loose wrote:
> > Hi all,
> >
> > I'm experiencing a very weird problem with a project logo.
> > I have two (almost) identical machines -- one production, one test
--
> > both running SuSE Linux Enterprise 11. Both are using CDash 1.8.2.
> >
> > On the test machine I can successfully upload a project logo, which
then
> > also displays on the CMake top-level banner and on the project
> > configuration page.
> >
> > On the production machine uploading fails. To be more precisely,
> > uploading itself seems to succeed, but the image in the database is
> > corrupt. To make things even weirder, the checksum for the image is
> > identical on both test and production machine.
> >
> > Does anyone have a clue on where to look for this strange behavior?
> >
> > Best regards,
> > Marcel Loose.
> >