[ZBX-3468] GUI is broken after restore support of SQLite3 Created: 2011 Jan 27  Updated: 2017 May 30  Resolved: 2011 Nov 07

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.2 (alpha)
Fix Version/s: 1.9.8 (beta), 2.0.0

Type: Incident report Priority: Blocker
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: sqlite
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

FreeBSD Release-8.1
php5-5.3.5 PHP Scripting Language
php5-pdo_sqlite-5.3.5 The pdo_sqlite shared extension for php
php5-sqlite-5.3.5 The sqlite shared extension for php
sqlite3-3.7.4 An SQL database engine in a C library

  1. cat zabbix.conf.php | grep DB
    ...
    $DB["TYPE"] = 'MYSQL';
    ....

Attachments: File fix.patch     Text File phpinfo-freebsd81.txt     PNG File sqlite3_gui_broken.png    

 Description   

started from the revision 17098.
PHP Fatal error: require_once(): Failed opening required 'include/classes/class.sqlite3.php' (include_path='.:/usr/local/share/pear') in /usr/local/www/zabbix/include/config.inc.php on line 78
See to a picture.



 Comments   
Comment by Alexei Vladishev [ 2011 Jan 27 ]

I see where the problem is. Zabbix calls class_exists() functions, which by default tries to autoload missing SQLite3 class. Fixed and a patch is attached.

Comment by Oleksii Zagorskyi [ 2011 Jan 27 ]

Alexei, thanks for the fix, but i looked at your patch and i'am interesting whether the frontend now working with SQLite3 db-backend?
This is a complete solution or only a partial?

Comment by Alexei Vladishev [ 2011 Jan 27 ]

Yes, the front-end fully supports SQLite3. Normally it's just a matter of installing php5-sqlite package.

By the way, I did another minor fix for SQlite3 affecting installation wizard. Please use revision 17222 or later.

Comment by Oleksii Zagorskyi [ 2011 Jan 28 ]

And I still can not understand why you have not had a problems (ZBX-3468) with SQLite3 in frontend and I had.

As you can see I have a long-Installed all the SQLite3 components.
But when in a "zabbix.conf.php" i try t use SQLite3:
$DB["TYPE"] = 'SQLITE3';
then again:
Fatal error: require_once() [function.require]: Failed opening required 'include/classes/class.sqlite3.php' (include_path='.:/usr/local/share/pear') in /usr/local/www/zabbix/include/config.inc.php on line 78

Comment by Oleksii Zagorskyi [ 2011 Jan 28 ]

btw, do you see that a file 'include/classes/class.sqlite3.php' is missing in the SVN repository?

Comment by Alexei Vladishev [ 2011 Jan 28 ]

Are you running 17222 or later?

Comment by Oleksii Zagorskyi [ 2011 Jan 28 ]

yes, about my two last comments -> is running at latest 17254 revision.

Comment by Oleksii Zagorskyi [ 2011 Jan 28 ]

Alexei, your yesterday fix is gud for NONE SQLite3 db-backend. Today just for case i tried SQLite3 db-backend .

Comment by Alexei Vladishev [ 2011 Jan 31 ]

It looks like you have support of SQLite3 configure in, yet it does not provide access to the required SQLite3 class. Please could you post output of <?php phpinfo(); ?> here?

Comment by Oleksii Zagorskyi [ 2011 Jan 31 ]

phpinfo attached as file phpinfo-freebsd81.txt

Comment by Oleksii Zagorskyi [ 2011 Oct 29 ]

Maybe connected to ZBX-4289

Comment by Alexei Vladishev [ 2011 Nov 01 ]

Fixed in dev branch. Ready to test.

Comment by Alexei Vladishev [ 2011 Nov 07 ]

Fixed in revision 23016.

Generated at Fri Apr 26 16:04:39 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.