forgot to include the grants:
mysql> show grants;
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for
[EMAIL PROTECTED]
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT FILE, SUPER ON *.* TO 'zenoss'@'202.52.163.42' IDENTIFIED BY
PASSWORD
'48e3adf732725a2c'
|
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES,
INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `events`.* TO
'zenoss'@'202.52.163.42' |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.27 sec)
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
--
Joel M. Mandapat
Chikka Asia, Inc.
3104-B, East Tektite Towers,
Philippine Stock Exchange Center
Exchange Road, Ortigas
Pasig City, Philippines
Mobile: +639285028664
Tel: +6326316166 local 145
Fax: +6326317217
AN ISO 9001:2000; ISO 15000:2002; ISO 17799:2002 CERTIFIED COMPANY; A CMMI Maturity level 5 Organization.
[EMAIL PROTECTED]
http://www.chikka.com
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith.
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
--
Joel M. Mandapat
Chikka Asia, Inc.
3104-B, East Tektite Towers,
Philippine Stock Exchange Center
Exchange Road, Ortigas
Pasig City, Philippines
Mobile: +639285028664
Tel: +6326316166 local 145
Fax: +6326317217
AN ISO 9001:2000; ISO 15000:2002; ISO 17799:2002 CERTIFIED COMPANY; A CMMI Maturity level 5 Organization.
[EMAIL PROTECTED]
http://www.chikka.com
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith.
|
