This service will be undergoing maintenance at 00:00 UTC, 2016-08-01. It is expected to last about 1 hours

Bug 983096

Summary: Zabbix WEB doesn't work due to deprecated mysql_connect()
Product: [Fedora] Fedora Reporter: Roman Pavlyuk <roman>
Component: zabbixAssignee: Dan Horák <dan>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 19CC: brett.lentz, bugzilla_rhn, dan, gilboad, nelsonab, vilius, volker27
Target Milestone: ---   
Target Release: ---   
Hardware: i686   
OS: Unspecified   
Whiteboard:
Fixed In Version: zabbix-2.0.8-3.fc19 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-10-13 15:54:33 EDT Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Attachments:
Description Flags
Zabbix 2.0.6 error on F19/PHP5.5
none
Zabbix 2.0.6 error on F19/PHP5.5 (Screens section) none

Description Roman Pavlyuk 2013-07-10 09:40:50 EDT
Description of problem:
After upgrading from F18 to F19 Zabbix WEB UI (MySQL) stopped to work correctly by rising an error:
mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead [include/db.inc.php:77]

This bug is already filed at Zabbix JIRA: https://support.zabbix.com/browse/ZBX-6020

The problem is caused by PHP 5.5 which deprecates MySQL library and force to use MySQLi.

Version-Release number of selected component (if applicable):
zabbix-2.0.6-2.fc19.i686
zabbix-agent-2.0.6-2.fc19.i686
zabbix-server-2.0.6-2.fc19.i686
zabbix-server-mysql-2.0.6-2.fc19.i686
zabbix-web-2.0.6-2.fc19.noarch
zabbix-web-mysql-2.0.6-2.fc19.noarch
php-5.5.0-1.fc19.i686
php-bcmath-5.5.0-1.fc19.i686
php-cli-5.5.0-1.fc19.i686
php-common-5.5.0-1.fc19.i686
php-gd-5.5.0-1.fc19.i686
php-mbstring-5.5.0-1.fc19.i686
php-mysqlnd-5.5.0-1.fc19.i686
php-pdo-5.5.0-1.fc19.i686
php-pear-1.9.4-19.fc19.noarch
php-pecl-jsonc-1.3.1-1.fc19.i686
php-process-5.5.0-1.fc19.i686
php-soap-5.5.0-1.fc19.i686
php-xml-5.5.0-1.fc19.i686

How reproducible:
Always

Steps to Reproduce:
1. Make sure you have Zabbix WEB UI on F18 running
2. Upgrade from F18 to F19
3. Open Zabbix WEB UI

Actual results:


Expected results:


Additional info:
Option display_errors is set to Off but the error is being shown anyway.
Comment 1 Roman Pavlyuk 2013-07-10 09:42:01 EDT
Created attachment 771618 [details]
Zabbix 2.0.6 error on F19/PHP5.5
Comment 2 Roman Pavlyuk 2013-07-10 09:45:19 EDT
Created attachment 771620 [details]
Zabbix 2.0.6 error on F19/PHP5.5 (Screens section)
Comment 3 Gilboa Davara 2013-07-11 13:26:34 EDT
AFAICS db.inc.patch seems to get zabbix up-and-running on my F19 machine (after some manual labour to fix logger and pid issues).

- Gilboa
Comment 4 Vilius Šumskas 2013-07-31 02:56:40 EDT
This should be looked at faster. It's not only warning message, but that message totally breaks all graphs display. Zabbix is unusable on F19 at this point.
Comment 5 Volker Fröhlich 2013-08-04 13:08:08 EDT
Let's see if we get a response on Monday. I'll include db.inc.patch otherwise.
Comment 6 Vilius Šumskas 2013-08-23 08:22:10 EDT
Zabbix 2.0.8 with a fix is out. Can someone repack RPM to include the latest version?
Comment 7 Vilius Šumskas 2013-09-17 05:01:45 EDT
Ping?
Comment 8 Vilius Šumskas 2013-10-02 12:56:16 EDT
Bi-weekly ping?
Comment 9 Fedora Update System 2013-10-03 16:31:02 EDT
zabbix-2.0.8-3.fc19 has been submitted as an update for Fedora 19.
https://admin.fedoraproject.org/updates/zabbix-2.0.8-3.fc19
Comment 10 Fedora Update System 2013-10-03 16:31:34 EDT
zabbix-2.0.8-3.fc20 has been submitted as an update for Fedora 20.
https://admin.fedoraproject.org/updates/zabbix-2.0.8-3.fc20
Comment 11 Fedora Update System 2013-10-03 16:31:50 EDT
zabbix-2.0.8-3.fc18 has been submitted as an update for Fedora 18.
https://admin.fedoraproject.org/updates/zabbix-2.0.8-3.fc18
Comment 12 Volker Fröhlich 2013-10-03 16:32:23 EDT
(In reply to Vilius Šumskas from comment #8)
> Bi-weekly ping?

Sorry it took so long! The situation wasn't very clear from the upstream side at first and maintaining zabbix and zabbix20 in 7 places is a hell lot of work. I'd be happy to have a co-maintainer.
Comment 13 Fedora Update System 2013-10-04 21:42:50 EDT
Package zabbix-2.0.8-3.fc20:
* should fix your issue,
* was pushed to the Fedora 20 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing zabbix-2.0.8-3.fc20'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2013-18314/zabbix-2.0.8-3.fc20
then log in and leave karma (feedback).
Comment 14 Vilius Šumskas 2013-10-06 07:12:08 EDT
Looks OK on testing.
Comment 15 Fedora Update System 2013-10-13 15:54:33 EDT
zabbix-2.0.8-3.fc20 has been pushed to the Fedora 20 stable repository.  If problems still persist, please make note of it in this bug report.
Comment 16 Fedora Update System 2013-10-14 03:01:59 EDT
zabbix-2.0.8-3.fc18 has been pushed to the Fedora 18 stable repository.  If problems still persist, please make note of it in this bug report.
Comment 17 Fedora Update System 2013-10-14 03:06:20 EDT
zabbix-2.0.8-3.fc19 has been pushed to the Fedora 19 stable repository.  If problems still persist, please make note of it in this bug report.
Comment 18 Fedora Update System 2013-10-14 13:12:37 EDT
zabbix-2.0.8-3.fc18 has been pushed to the Fedora 18 stable repository.  If problems still persist, please make note of it in this bug report.
Comment 19 Fedora Update System 2013-10-14 13:20:08 EDT
zabbix-2.0.8-3.fc19 has been pushed to the Fedora 19 stable repository.  If problems still persist, please make note of it in this bug report.