Bug#450525: zabbix-frontend-php: Cannot access zabbix frontend after installation
Uwe Storbeck
Version: 1:1.1.4-10
Severity: important
After the installation of zabbix I could not access the zabbix frontend
to configure it:
Fatal error: Call to undefined function mysql_pconnect() in
/usr/share/zabbix/include/db.inc.php on line 32
After installing the package php5-mysql and restarting apache this error
message vanished, but I run into the next problem:
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user
'zabbix'@'localhost' (using password: NO) in
/usr/share/zabbix/include/db.inc.php on line 32
Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user
'www-data'@'localhost' (using password: NO) in
/usr/share/zabbix/include/db.inc.php on line 33
Warning: mysql_select_db() [function.mysql-select-db]: A link to the server
could not be established in /usr/share/zabbix/include/db.inc.php on line 33
Error connecting to database [Access denied for user 'www-data'@'localhost'
(using password: NO)]
The user zabbix exists in the DB, but it seems to be password protected
while it has an empty password string in the file /etc/zabbix/dbconfig.php.
The user www-data seems not to exist in the database.
During the package installation I selected the automatic database
installation and did not get any error messages:
Setting up zabbix-server-mysql (1.1.4-10) ...
dbconfig-common: writing config to /etc/dbconfig-common/zabbix-server-mysql.conf
Creating config file /etc/dbconfig-common/zabbix-server-mysql.conf with new version
Creating config file /etc/zabbix/zabbix_server.conf with new version
granting access to database zabbix for zabbix@localhost: success.
verifying access for zabbix@localhost: success.
creating database zabbix: success.
verifying database zabbix exists: success.
populating database via sql... done.
dbconfig-common: flushing administrative password
Starting Zabbix server: zabbix_server
Copying the zabbix password from /etc/dbconfig-common/zabbix-server-mysql.conf
into /etc/zabbix/dbconfig.php finally got me the login page ...
Regards,
Uwe
-- System Information:
Debian Release: 4.0
APT prefers stable
APT policy: (850, 'stable'), (750, 'testing'), (650, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-5-k7
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages zabbix-frontend-php depends on:
ii apache [httpd] 1.3.34-4.1 versatile, high-performance HTTP s
ii debconf [debconf-2.0] 1.5.11 Debian configuration management sy
ii php4 6:4.4.4-8+etch4 server-side, HTML-embedded scripti
ii php4-cgi 6:4.4.4-8+etch4 server-side, HTML-embedded scripti
ii php4-mysql 6:4.4.4-8+etch4 MySQL module for php4
ii php5-gd 5.2.0-8+etch7 GD module for php5
ii ucf 2.0020 Update Configuration File: preserv
Versions of packages zabbix-frontend-php recommends:
ii mysql-server 5.0.32-7etch1 mysql database server (meta packag
ii mysql-server-5.0 [mysql-se 5.0.32-7etch1 mysql database server binaries
ii zabbix-server-mysql 1:1.1.4-10 software for monitoring of your ne
-- debconf information:
zabbix-frontend-php/database-type: MYSQL
zabbix-frontend-php/database-server: localhost
zabbix-frontend-php/restart-webserver: true
zabbix-frontend-php/database-name: zabbix
zabbix-frontend-php/database-user: zabbix
zabbix-frontend-php/reconfigure-webserver: apache, apache-ssl, apache-perl, apache2
--
To UNSUBSCRIBE, email to debian-bugs-...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Michael Ablassmeier
thanks
hi,
On Wed, Nov 07, 2007 at 10:14:48PM +0100, Uwe Storbeck wrote:
> After the installation of zabbix I could not access the zabbix frontend
> to configure it:
>
> URL: http://localhost/zabbix/
>
> Fatal error: Call to undefined function mysql_pconnect() in
> /usr/share/zabbix/include/db.inc.php on line 32
>
> After installing the package php5-mysql and restarting apache this error
> message vanished, but I run into the next problem:
could it be you had php4-mysql or some other php-* package installed which
satisfied the php5-mysql|php5-pgsql|php4-mysql|php4-pgsql Dependency?
This doesnt look like beeing entirely the zabbix packages fault.
> During the package installation I selected the automatic database
> installation and did not get any error messages:
>
> Setting up zabbix-server-mysql (1.1.4-10) ...
> dbconfig-common: writing config to /etc/dbconfig-common/zabbix-server-mysql.conf
>
> Creating config file /etc/dbconfig-common/zabbix-server-mysql.conf with new version
>
> Creating config file /etc/zabbix/zabbix_server.conf with new version
> granting access to database zabbix for zabbix@localhost: success.
> verifying access for zabbix@localhost: success.
> creating database zabbix: success.
> verifying database zabbix exists: success.
> populating database via sql... done.
> dbconfig-common: flushing administrative password
> Starting Zabbix server: zabbix_server
>
> Copying the zabbix password from /etc/dbconfig-common/zabbix-server-mysql.conf
> into /etc/zabbix/dbconfig.php finally got me the login page ...
did you install both the frontend and the server in one run? If the server package
is installed *before* the frontend package, the frontend reads the password from
the servers config file and places it in /etc/zabbix/dbconfig.php.
If the frontend does not find any server configuration file it prompts for the
database settings using debconf. Those settings are priority medium, probably
your DEBCONF_PRIORITY was set to high and thus the question was skipped.
bye,
- michael