Drew (or anyone that has any ideas),
I installed MySql 5.0.27 right before i installed Zenoss. MySql was
installed using an rpm from MySql's website.
Zenoss (1.0.2) was installed using the source code tar.gz.
To provide further information for debugging, i have attached the exact
Install Procedure i made as i went along, command by command (in Wiki
friendly syntax :) ).
I have also attached the "ERROR"s and "WARNING"s from the zenbuild.log file.
Is there any other file/command you can think of that would aid in
helping me?
I am really excited about showing this product off. I love how easy it
was to use the VMware for it. I just hope i can get it to work on my
staging server so it can go live and potentially replace my Nagios
implementation!
Thanks in advance for the help,
-Daniel
P.S. I see a few nasty looking log entries:
2006-12-17 17:06:44 WARNING zen.Events Failed to refresh conversions, db
connection failed.
ERROR 1227 (42000) at line 76: Access denied; you need the SUPER
privilege for this operation.
Drew Bray wrote:
Daniel,
That is a strange error. We have ben discussing it a bit. Can you
check to see what version of mySQL you are running? I don't think RHEL
3 comes with MySQL 5.0 which is required to run Zenoss. also, what
kind of install did you use? (rpms, tar, source?)
Drew
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
On Dec 13, 2006, at 4:40 PM, Daniel McKinney wrote:
Folks,
I have just tried to install Zenoss on the following operating system:
Red Hat Enterprise Linux ES release 3 (Taroon Update 6)
Everything seems to work fine minus the fact that when i go to the
Dashboard, i get in red at the top-right, "Lost Connection to Zenoss".
I looked at the bottom of /usr/local/zenoss/log/events.log and i keep
getting this over and over again:
------
2006-12-13T16:11:54 ERROR Zope.SiteErrorLog
http://192.168.204.29:8080/zport/dmd/ZenEventManager/getDashboardInfo
Traceback (most recent call last):
File "usr/local/zenoss/lib/python/ZPublisher/Publish.py", line 114,
in publish
File "usr/local/zenoss/lib/python/ZPublisher/mapply.py", line 88,
in mapply
File "usr/local/zenoss/lib/python/ZPublisher/Publish.py", line 40,
in call_object
File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py",
line 738, in getDashboardInfo
data['heartbeat'] = self.getHeartbeat()
File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py",
line 555, in getHeartbeat
curs.execute(sel)
File "usr/local/zenoss/lib/python/MySQLdb/cursors.py", line 137, in
execute
File "usr/local/zenoss/lib/python/MySQLdb/connections.py", line 33,
in defaulterrorhandler
ProgrammingError: (1146, "Table 'events.heartbeat' doesn't exist")
------
That same message pops up alot throughout all the logfiles in that
same directory: ProgrammingError: (1146, "Table 'events.heartbeat'
doesn't exist")
I take a look at the mysql database and issue the following commands
to see what tables were built after install:
mysql> use events;
mysql> show tables;
+------------------+
| Tables_in_events |
+------------------+
| history |
| status |
+------------------+
2 rows in set (0.00 sec)
Before i tried installing Zenoss on my server, i downloaded and
tested Zenoss with the VMware on my desktop and i checked inside the
database in that install and the same commands show this:
mysql> use events;
mysql> show tables;
+------------------+
| Tables_in_events |
+------------------+
| alert_state |
| detail |
| heartbeat |
| history |
| log |
| status |
+------------------+
2 rows in set (0.00 sec)
Any idea why the tables for my install are not getting created correctly?
-Daniel
_______________________________________________
zenoss-users mailing list
[email protected] <mailto:[email protected]>
http://lists.zenoss.org/mailman/listinfo/zenoss-users
------------------------------------------------------------------------
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
== User Setup ==
groupadd zenoss
useradd -c "Zenoss User" -d /home/zenoss -g zenoss zenoss
Add the following to the ~/zenoss/.bash_profile:
# Zenoss environment variables
ZENHOME=/usr/local/zenoss
export ZENHOME
PYTHONPATH=$ZENHOME/lib/python
export PYTHONPATH
PATH=$ZENHOME/bin:$PATH
export PATH
== System Setup ==
mkdir /usr/local/zenoss
mkdir /usr/local/zenoss/include
mkdir /usr/local/zenoss/lib
cp -R /usr/local/include/* /usr/local/zenoss/include
cp -R /usr/local/lib/* /usr/local/zenoss/lib
chown -R zenoss:zenoss /usr/local/zenoss
== Sudo Setup ==
Add the following to the bottom of /etc/sudoers file by issueing the "visudo"
command:
visudo
#---------------------------------------------
Defaults env_reset
Defaults env_keep = "PYTHONPATH ZENHOME"
zenoss ALL=(ALL) NOPASSWD: /usr/local/zenoss/bin/python,/usr/bin/kill
#----------------------------------------
'''Note: Start MySql (If it is not already started)'''
== Install ==
cd /tmp
tar xvzf zenoss-1.0.2.tar.gz
chown -R zenoss:zenoss /tmp/zenoss-1.0.2
cd zenoss-1.0.2
su - zenoss
./install.sh
MySQL event database name [events]: <ENTER>
MySQL username for Zenoss zenoss_db database [zenoss]: <ENTER>
MySQL password for root [zenoss]: <password>
Enter the password again: <password>
Attempting to run python with sudo:
Password:<ENTER>
== Testing ==
/usr/local/zenoss/bin/zenping start; ps -ef | grep zenping | grep -v grep
/usr/local/zenoss/bin/zenperfsnmp start; ps -ef | grep zenperfsnmp| grep -v
grep
/usr/local/zenoss/bin/zenperfxmlrpc start; ps -ef | grep zenperfxmlrpc | grep
-v grep
/usr/local/zenoss/bin/zenmodeler start; ps -ef | grep zenmodeler | grep -v grep
/usr/local/zenoss/bin/zensyslog start; ps -ef | grep zensyslog | grep -v grep
(NOTE: Have to be root to start this one!)
/usr/local/zenoss/bin/zenactions start; ps -ef | grep zenactions | grep -v grep
/usr/local/zenoss/bin/zenstatus start; ps -ef | grep zenstatus | grep -v grep
/usr/local/zenoss/bin/zenoss status
== Expected Output ==
Daemon: zeoctl program running; pid=20743
Daemon: zopectl program running; pid=20747
Daemon: zenxevent program running; pid=20752
Daemon: zenmodeler program running; pid=20761
Daemon: zenperfsnmp program running; pid=20770
Daemon: zenperfxmlrpc program running; pid=20792
Daemon: zenprocess program running; pid=20800
Daemon: zenping program running; pid=20807
Daemon: zensyslog program running; pid=20815
Daemon: zenstatus program running; pid=20824
Daemon: zenactions program running; pid=20833
Daemon: zentrap program running; pid=20849
Daemon: zencommand program running; pid=20870
[EMAIL PROTECTED] zenoss-1.0.2]$ egrep ERROR zenbuild.log
ERROR 1227 (42000) at line 76: Access denied; you need the SUPER privilege for
this operation
[EMAIL PROTECTED] zenoss-1.0.2]$ egrep WARNING zenbuild.log
configure: WARNING: Skipping radius plugin
configure: WARNING: install radius libs to compile this plugin (see
REQUIREMENTS).
configure: WARNING: Install NTP programs (http://www.ntp.org) if you want to
monitor time synchronization
configure: WARNING: Get lmstat from Globetrotter Software to monitor flexlm
licenses
configure: WARNING: Tried /usr/bin/perl - install Net::SNMP perl module if you
want to use the perl snmp plugins
configure: WARNING: Get qstat from
http://www.activesw.com/people/steve/qstat.html in order to make check_game
plugin
configure: WARNING: Get fping from http://www.fping.com in order to make
check_fping plugin
configure: WARNING: Could not find qmail-qstat or eqivalent
WARNING: insufficient access; not installing setuid plugins
WARNING:OFS.Application:Duplicate Product name
2006-12-17 17:06:32 WARNING OFS.Application Duplicate Product name
WARNING:zen.Events:Failed to refresh conversions, db connection failed.
2006-12-17 17:06:44 WARNING zen.Events Failed to refresh conversions, db
connection failed.
WARNING:zen.Events:Failed to refresh conversions, db connection failed.
2006-12-17 17:06:44 WARNING zen.Events Failed to refresh conversions, db
connection failed.
WARNING:zen.XmlDataLoader:Object /zport/dmd/Manufacturers already exists
skipping
2006-12-17 17:06:44 WARNING zen.XmlDataLoader Object /zport/dmd/Manufacturers
already exists skipping
WARNING:zen.XmlDataLoader:Object /zport/dmd/Services already exists skipping
2006-12-17 17:07:02 WARNING zen.XmlDataLoader Object /zport/dmd/Services
already exists skipping
WARNING:zen.XmlDataLoader:Object /zport/dmd/Events already exists skipping
2006-12-17 17:07:56 WARNING zen.XmlDataLoader Object /zport/dmd/Events already
exists skipping
WARNING:zen.XmlDataLoader:Object IpService already exists skipping
2006-12-17 17:07:56 WARNING zen.XmlDataLoader Object IpService already exists
skipping
WARNING:zen.XmlDataLoader:Object OSProcess already exists skipping
2006-12-17 17:07:56 WARNING zen.XmlDataLoader Object OSProcess already exists
skipping
WARNING:zen.XmlDataLoader:Object /zport/dmd/Devices already exists skipping
2006-12-17 17:07:57 WARNING zen.XmlDataLoader Object /zport/dmd/Devices already
exists skipping
[EMAIL PROTECTED] zenoss-1.0.2]$
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
