httpd 100% load

[kens]

I think I've got my zabbix.conf.php sorted out and I've tried to log on to the zabbix web page.

Logging in as "Admin" the httpd load goes to 98% CPU and after about 10 mins I get a blank page and the httpd load drops.

If I don't bother logging in, and just click on the Monitoring, Inventory, Reports links I get various pages. Several of them are full of Php/mysql errors such as

mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/etc/zabbix/db.inc.php:391]

The php source stanza referred to by the error is....
$result = mysql_fetch_array($cursor);

This is an FC6 system with zabbix loaded via RPM. I loaded the Mysql database from the files data.sql and mysql.sql in /usr/share/zabbix/create/

The file schema.sql that is referred to in the manual is not on this system. So is my database a bunch of nonsense without that file loaded?

I'd be interested to hear from folks who have a FC Zabbix system built from RPM's working? I don't see many folks here using FC. Is that a non supported distro?

The tables that are in mysql are.....


mysql> show tables;

+--------------------+
| Tables_in_zabbix |
+--------------------+
| acknowledges |
| actions |
| alerts |
| applications |
| auditlog |
| autoreg |
| conditions |
| config |
| events |
| functions |
| graphs |
| graphs_items |
| groups |
| help_items |
| history |
| history_log |
| history_str |
| history_str_sync |
| history_sync |
| history_text |
| history_uint |
| history_uint_sync |
| hosts |
| hosts_groups |
| hosts_profiles |
| hosts_templates |
| housekeeper |
| images |
| items |
| items_applications |
| mappings |
| media |
| media_type |
| node_cksum |
| node_configlog |
| nodes |
| profiles |
| rights |
| screens |
| screens_items |
| service_alarms |
| services |
| services_links |
| services_times |
| sessions |
| sysmaps |
| sysmaps_elements |
| sysmaps_links |
| trends |
| trigger_depends |
| triggers |
| users |
| users_groups |
| usrgrp |
| valuemaps |
+--------------------+
55 rows in set (0.00 sec)

Would I be better to re-install zabbix from source? This is not going well so far......

Thanks

Ken

[kens]

I guess these error messages are significant

This from Apache

[Tue Jun 26 18:00:52 2007] [error] [client 172.16.0.100] PHP Fatal error: Maximum execution time of 300 seconds exceeded in /usr/share/zabbix/include/config.
inc.php on line 308

and errors like this from the Zabbix log file

3479:20070626:184040 Query failed:Unknown column 'h.dns' in 'field list' [1054]
3521:20070626:184040 Query failed:Table 'zabbix.httptest' doesn't exist [1146]
3521:20070626:184040 Query::select count(*),min(nextcheck) from httptest t where t.status=0 and mod(t.httptestid,5)=4 and t.httptestid>=100000000000000*0 a

Is it worth reloading the database or should I start again and reinstall from scratch?

;-{

Ken

[JonB]

Sounds like you don't have php-mysql installed. Try

yum install php-mysql
service httpd restart

Jon

[kens]

# rpm -qa | grep php-mysql
php-mysql-5.1.6-3.6.fc6



# yum remove zabbix
Loading "installonlyn" plugin
Setting up Remove Process
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package zabbix.i386 0:1.4-2.fc6 set to be erased
--> Running transaction check

Dependencies Resolved

================================================== ===========================
Package Arch Version Repository Size
================================================== ===========================
Removing:
zabbix i386 1.4-2.fc6 installed 2.8 M

Transaction Summary
================================================== ===========================
Install 0 Package(s)
Update 0 Package(s)
Remove 1 Package(s)

Is this ok [y/N]: y
Downloading Packages:
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
warning: /etc/zabbix/zabbix_server.conf saved as /etc/zabbix/zabbix_server.conf.rpmsave
Removing : zabbix ######################### [1/1]

Removed: zabbix.i386 0:1.4-2.fc6
Complete!


# yum remove zabbix-agent
Loading "installonlyn" plugin
Setting up Remove Process
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package zabbix-agent.i386 0:1.4-2.fc6 set to be erased
--> Running transaction check

Dependencies Resolved

================================================== ===========================
Package Arch Version Repository Size
================================================== ===========================
Removing:
zabbix-agent i386 1.4-2.fc6 installed 409 k

Transaction Summary
================================================== ===========================
Install 0 Package(s)
Update 0 Package(s)
Remove 1 Package(s)

Is this ok [y/N]: y
Downloading Packages:
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Removing : zabbix-agent ######################### [1/1]

Removed: zabbix-agent.i386 0:1.4-2.fc6
Complete!


# yum remove zabbix-web
Loading "installonlyn" plugin
Setting up Remove Process
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package zabbix-web.i386 0:1.4-2.fc6 set to be erased
--> Running transaction check

Dependencies Resolved

================================================== ===========================
Package Arch Version Repository Size
================================================== ===========================
Removing:
zabbix-web i386 1.4-2.fc6 installed 2.3 M

Transaction Summary
================================================== ===========================
Install 0 Package(s)
Update 0 Package(s)
Remove 1 Package(s)

Is this ok [y/N]: y
Downloading Packages:
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
warning: /etc/zabbix/zabbix.conf.php saved as /etc/zabbix/zabbix.conf.php.rpmsave
Removing : zabbix-web ######################### [1/1]

Removed: zabbix-web.i386 0:1.4-2.fc6
Complete!
#

# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 86 to server version: 5.0.27

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> drop database zabbix;
Query OK, 55 rows affected (0.17 sec)

mysql>


As you can tell this is a pretty frustrating process.

I'll try from the sources

Ken

[Alexei]

Don't use old database schema with 1.4, it won't work.

[kens]

I used the .sql files that were with the .rpm packages to load the database. I also have the source unzipped on the machine too and I've done a quick comparison between the .sql files with the source and with the .rpm. It looked like schema.sql from the source package had been merged into data.sql in the rpm version I had.

I also noticed that a couple of the tables that the .sql files in the source package would have created were missing from my the database in my installation. Hence my questions about the validity of my database in the original post.

Thank you for the response. I'll build it up from source now and post the results back.

Ken

[NOB]

...

Thank you for the response. I'll build it up from source now and post the results back.

Ken

Hi Ken,

if a few days don't matter, you might want to wait for version 1.4.1 instead of
starting with "old" sources with a lot of bugs not fixed.
Or use the SVN version.

Regards,

Norbert.

[kens]

OK I'll hold on. Thanks.

I did start, but I'm having fight with Jabber that thinks GNU C is not on the system when it is......

Grrrrr. There's RPM's for FC5 & FC7 but not FC6 so I'm building it from source too...

By the way - the database now looks very different loaded from the sources.
:-)

Ken

[SharkCZ]

The Fedora rpm did contain wrong SQL scripts, it is fixed now. For details see https://bugzilla.redhat.com/bugzilla....cgi?id=244991

[kens]

A quick update to say that I've got 1.4.1 running from sources on FC6

I'm learning how to use it now

:-)

Ken