Hi Joel,
The first error (Trigger already exists) is unavoidable (ugh!). Any
attempt to re-install the database on a machine that already has the
database will print this message.
I don't know what permission you are lacking given your GRANT statements
(in the other email). This looks perfectly good to me.
-Eric
Joel Mandapat wrote:
hi eric,
how do i resolve this?
[EMAIL PROTECTED] bin]# zeneventbuild zenoss z3n055 203.190.77.153
ERROR 1359 at line 79: Trigger already exists
ERROR 1370 at line 2: alter routine command denied to user
'zenoss'@'202.52.163.42' for routine 'events.close_events'
----
i edited the zeneventbuild and it looks like this now:
#!/bin/sh
if [ "$ZENHOME" = "" ]; then
echo ERROR: ZENHOME envrionment variable not set.
exit 1
fi
EVTDB=$ZENHOME/Products/ZenEvents/db
if [ -d $EVTDB ]; then
cd $EVTDB
else
echo ERROR: $EVTDB not installed.
exit 1
fi
mysql -u $1 --password=$2 -h $3 < zenevents.sql
mysql -u $1 --password=$2 -h $3< zenprocs.sql
----
is this ok?
i followed ur instructions in installing zenoss to a vm instance.
and copied it to my desired machine.
it looks fine.
also updated the zeneventmanager properties.
also followed the steps on mysql grants.
but i still see this in the dashboard: --> *Lost Connection to Zenoss*
event.log:
-------
File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py", line
294, in getEventSummaryME
return self.getEventSummary(where, severity, state, prodState)
File "/usr/local/zenoss/Products/ZenEvents/MySqlEventManager.py",
line 65, in getEventSummary
db = self.connect()
File "/usr/local/zenoss/Products/ZenEvents/DbAccessBase.py", line 25,
in connect
db="events",conv=mysqlconv)
File "usr/local/zenoss/lib/python/MySQLdb/__init__.py", line 66, in
Connect
# log messages. When the "real" loggers are set up, we flush
File "usr/local/zenoss/lib/python/MySQLdb/connections.py", line 134,
in __init__
OperationalError: (2013, 'Lost connection to MySQL server during query')
bin]# tail ../log/zenxevent.log
retval = method(*data)
File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py", line
767, in sendEvents
db = self.connect()
File "/usr/local/zenoss/Products/ZenEvents/DbAccessBase.py", line 25,
in connect
db="events",conv=mysqlconv)
File "usr/local/zenoss/lib/python/MySQLdb/__init__.py", line 66, in
Connect
return Connection(*args, **kwargs)
File "usr/local/zenoss/lib/python/MySQLdb/connections.py", line 134,
in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2013, 'Lost connection to MySQL server during query')
---
do u think its also a network problem?
thanks
Eric Newton wrote:
Hey Joel,
This isn't really hard, but if you are not comfortable with mysql or
scripting, you probably just want to reinstall on a different
computer or VMPlayer instance.
You need to install the database schema on some remote host. First
install MySQL 5.0.22 or later on the remote host. You will have to
create a user (or use root) and allow remote access. You will need
to edit zeneventbuild to talk to your remote host. You then need to
run zeneventbuild:
$ zeneventbuild someuser somepassword
Next, you need to point ZenEventManager to your remote instance. You
can do this by changing the mysql properties. You can access the
properties of the ZenEventManager using Zope's object interface.
Add "manage" to the URL to access this interface. For example:
http://zenoss:8080/zport/dmd/manage
Navigate on the left to ZenEventManager. Select the "properties" tab
on the right. Update the parameters of hostname, port number, login,
password, etc.
-Eric
Joel Mandapat wrote:
hi guys.. need help.
how do i connect zenoss installation to a remote host?
locally i have a running mysql and i dont want to upgrade it since
it will have conflicts to my running apps.
do i need to tweak the install.sh?
im not much of a programmer.
please help.
thanks.
----
[EMAIL PROTECTED] zenoss-0.22.3]$ ./install.sh
bash: /root/.bashrc: Permission denied
MySQL username for Zenoss events database [root]: zenoss
MySQL password for zenoss:
Password for the Zenoss "admin" user:
Enter the password again:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
mysql install, user or password is incorect
_______________________________________________
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
