[Pkg-nagios-devel] Bug#352762: nagios-mysql: check_nagios_db error connecting to database (no status found in web pages)

[Akira Yamanita]

Package: nagios-mysql
Version: 2:1.3-cvs.20050402-12
Severity: grave
Tags: patch
Justification: renders package unusable

A bug in the code used to connect to the database causes the status
pages to be unavailable.

-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'stable'), (1, 'experimental')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.14-2-686
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)

Versions of packages nagios-mysql depends on:
ii  dbconfig-common    1.8.11                common framework for packaging dat
ii  debconf [debconf-2 1.4.57                Debian configuration management sy
ii  libc6              2.3.5-8.1             GNU C Library: Shared libraries an
ii  libdbd-mysql-perl  3.0002-1              A Perl5 database interface to the 
ii  libgd2-xpm         2.0.33-2              GD Graphics Library version 2
ii  libjpeg62          6b-10                 The Independent JPEG Group's JPEG 
ii  libmysqlclient15   5.0.16-1              mysql database client library
ii  libpng12-0         1.2.8rel-4            PNG library - runtime
ii  nagios-common      2:1.3-cvs.20050402-12 A host/service/network monitoring 
ii  zlib1g             1:1.2.3-3             compression library - runtime

Versions of packages nagios-mysql recommends:
pn  nagios-images                 <none>     (no description available)

-- debconf information:
  nagios-mysql/database-type: mysql
  nagios-mysql/upgrade-error: abort
  nagios-mysql/remove-error: abort
  nagios-mysql/import-oldsettings:
  nagios-mysql/upgrade-backup: true
* nagios-mysql/db/app-user: nagios-mysql
* nagios-mysql/dbconfig-install: true
* nagios-mysql/mysql/method: tcp/ip
  nagios-mysql/remote/newhost: localhost
* nagios-mysql/db/dbname: nagiosmysql
* nagios-mysql/install-error: ignore
* nagios-mysql/mysql/admin-user: root
* nagios-mysql/dbconfig-remove: true
* nagios-mysql/remote/port:
  nagios-mysql/performing_upgrade: true
  nagios-mysql/passwords-do-not-match:
* nagios-mysql/remote/host: localhost
  nagios-mysql/dbconfig-upgrade: true
* nagios-mysql/purge: true
-------------- next part --------------
64,65c64,65
< if(defined($dbhost)) { $dsn .= ";host=$dbhost"; } else { $dbhost=""; }
< if(defined($dbport)) { $dsn .= ";port=$dbport"; } else { $dbport=""; }
---
> if(defined($dbhost)) { $dsn .= "host=$dbhost"; } else { $dbhost=""; }
> if(defined($dbport)) { $dsn .= "port=$dbport"; } else { $dbport=""; }