ERIC thanks for the help. When I updated mysql the 5.0 mysql db was
installed under /var/lib/mysql/mysql and my my.cnf file had the datadir to
/db/. I copied the 5.0 mysql db to my /db/mysql/ (which added the proc
table) and this fixed the install issue. I wanted to post in case others
have same issue.
I regret that I have another problem. I can not get
/usr/local/zenoss/bin/zenoss (status) to run or any other demon (zenping).
I get the following error for zenping as root user:
[root@ bin]# pwd
/usr/local/zenoss/bin
[root@ bin]# bash zenping start
zenping: line 3: /bin/zenfunctions: No such file or directory
zenping: line 11: generic: command not found
[root@ bin]# zenping start
-bash: zenping: command not found
[root@ bin]# bash zenoss status
zenoss: line 9: /bin/zenfunctions: No such file or directory
Usage: zenoss {start|stop|restart|status}
I also get same errors running as user zenoss.
[zenoss@ bin]$ zenoss status
bash: zenoss: command not found
[zenoss@ bin]$ bash zenoss status
zenoss: line 9: /bin/zenfunctions: No such file or directory
Usage: zenoss {start|stop|restart|status}
I followed the install instructions on adding the PATH variables to the
.bash_profile in /home/zenoss/. I also added them at the top of the
zenfunctions file as you suggested on the mailing list. I did not add
zenoss as a sudeor since I want to run the required deamons as root (i.e.
zenping). I can not start /bin/zenoss or /bin/zenping as user zenoss or
root after a reboot. It seems to not like the read-write zenfunctions file.
Should this file be executable and should it have bash syntax at the top??
Do you happen to have an init startup script that could work instead? Any
info will be great.
Thanks
Travis Freeland
>Seems like the 4.x version of mysql is still running because it
>didn't have stored procedures there for table mysql.proc isn't there...
>
>-EAD
>
>On Aug 29, 2006, at 5:46 PM, Travis Freeland wrote:
>
>
> I found an error in the zenbuild.log:
> "ERROR 1146 (42S02) at line 4: Table 'mysql.proc' doesn't exist"
>
> Only error any clue???
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Travis Freeland
> Sent: Tuesday, August 29, 2006 4:20 PM
> To: [email protected]
> Subject: [zenoss-users] Problem with MySQL event tables during install
>
>
> I can't get Zenoss to install on Fedora4. I updated the mysql from
> 4.1 to
> 5.0.24 and have all the appropriate dependencies that Zenoss
> requires. I
> run the install script as user zenoss and I get the following error.
>
> ### zenoss-0.22.1]$ bash install.sh
> MySQL username for Zenoss events database [root]: mysql
> MySQL password for mysql:
> Password for the Zenoss "admin" user:
> Enter the password again:
> installing into /usr/local/zenoss
> build log is in zenbuild.log
> installing libzenos/Products.tar.gz
> installing libzenos/bin.tar.gz
> unpacking CMF-1.5.6 in build/
> unpacking Zope-2.8.8-final in build/
> configuring build/Zope-2.8.8-final/makefile
> installing zope
> Wrote file /usr/local/zenoss/etc/zeo.conf
> Wrote file /usr/local/zenoss/bin/zeoctl
> Changed mode for /usr/local/zenoss/bin/zeoctl to 775
> Wrote file /usr/local/zenoss/bin/runzeo
> Changed mode for /usr/local/zenoss/bin/runzeo to 775
> installing cmf
> unpacking TwistedSNMP-0.3.13 in build/
> patching file snmpprotocol.py
> patching file v3/agentproxy.py
> unpacking pysnmp-3.4.3 in build/
> patching file pysnmp/proto/rfc1155.py
> installing pysnmp
> unpacking Twisted-2.4.0 in build/
> unpacking pycrypto-1.9a6 in build/
> installing pycrypto
> installing twisted
> installing twistedsnmp
> unpacking MySQL-python-1.2.0 in build/
> installing mysql-python
> unpacking rrdtool-1.2.11 in build/
> unpacking libart_lgpl-2.3.17 in build/
> configuring build/libart_lgpl-2.3.17/Makefile
> Installing libart-install
> unpacking freetype-2.1.9 in build/
> configuring build/freetype-2.1.9/Makefile
> Installing freetype-install
> unpacking libpng-1.2.8-config in build/
> configuring build/libpng-1.2.8-config/Makefile
> Installing libpng-install
> configuring build/rrdtool-1.2.11/Makefile
> installing rrdtool
> unpacking epydoc-2.1 in build/
> installing epydoc
> unpacking snpplib-1.1 in build/
> patching file snpplib.py
> installing snpp
> unpacking Yapps-2.1.1 in build/
> installing yapps
> unpacking nagios-plugins-1.4.3 in build/
> configuring build/nagios-plugins-1.4.3/Makefile
> Installing nagios-install
> unpacking libsmi-0.4.5 in build/
> configuring build/libsmi-0.4.5/Makefile
> installing libsmi
> installing conf/freetds.conf
> installing conf/zenactions.conf
> installing conf/zenagios.conf
> installing conf/zendisc.conf
> installing conf/zenmib.conf
> installing conf/zenmigrate.conf
> installing conf/zenmodeler.conf
> installing conf/zenperfsnmp.conf
> installing conf/zenping.conf
> installing conf/zenprocess.conf
> installing conf/zenstatus.conf
> installing conf/zensyslog.conf
> installing conf/zentrap.conf
> installing conf/zenxevent.conf
> unable to install MySQL event tables
>
> The error says unable to install MYSQL event tables. But I can log
> into the
> events database that zenoss creates and here are the tables it
> created. The
> mysql user above has superuser privileges. (I even tried a fresh
> install
> with mysql user root, same error).
>
> mysql> show tables;
> +------------------+
> | Tables_in_events |
> +------------------+
> | alert_state |
> | detail |
> | heartbeat |
> | history |
> | log |
> | status |
> +------------------+
> 6 rows in set (0.00 sec)
>
> I provided mysql server version below if it helps any. If anyone has
> encountered this issue please let me know how you resolved this. I
> like
> what I see with this software and would like to test it.
>
> mysql Ver 14.12 Distrib 5.0.24, for pc-linux-gnu (i686) using
> readline 5.0
>
> Thanks,
>
> Travis Freeland
> GVTC
> Network Specialist
>
>
>
> _______________________________________________
> zenoss-users mailing list
> [email protected]
> http://lists.zenoss.org/mailman/listinfo/zenoss-users
>
> _______________________________________________
> zenoss-users mailing list
> [email protected]
> http://lists.zenoss.org/mailman/listinfo/zenoss-users
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
