How do i view Zenoss events database?

[r c]

r c [http://community.zenoss.org/people/raelanne] created the discussion

"How do i view Zenoss events database?"

To view the discussion, visit: http://community.zenoss.org/message/64679#64679

--------------------------------------------------------------
I installed zenoss using deb stack installation, how do i view the mysql events database? thanks
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64679#64679]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[dhopp]

dhopp [http://community.zenoss.org/people/dhopp] created the discussion

"Re: How do i view Zenoss events database?"

To view the discussion, visit: http://community.zenoss.org/message/64680#64680

--------------------------------------------------------------
What exactly do you mean?  You want to get access to mysql directly?
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64680#64680]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[r c]

r c [http://community.zenoss.org/people/raelanne] created the discussion

"Re: How do i view Zenoss events database?"

To view the discussion, visit: http://community.zenoss.org/message/64681#64681

--------------------------------------------------------------
yes. can i view the zenoss events database?
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64681#64681]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[dhopp]

dhopp [http://community.zenoss.org/people/dhopp] created the discussion

"Re: How do i view Zenoss events database?"

To view the discussion, visit: http://community.zenoss.org/message/64682#64682

--------------------------------------------------------------
I'm not familiar with the stack installer (and if you aren't too far into your zenoss implementation now might be a good time to switch to a different install method.  Stack installer doesn't exist in version 4).

But I believe the mysql listens on port 3307 by default.  So you should be able to do something like this from the command line of the zenoss server:

mysql -u zenoss -p -h localhost -P 3307 events

I might have the options slightly off as this was just off the top of my head.

--Dennis
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64682#64682]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[r c]

r c [http://community.zenoss.org/people/raelanne] created the discussion

"Re: How do i view Zenoss events database?"

To view the discussion, visit: http://community.zenoss.org/message/64685#64685

--------------------------------------------------------------
I still can't view the database, when i type

mysql -u zenoss -p
then i type zenoss as the password, this error occurs
ERROR 1045 (28000): Access denied for user 'zenoss'@'localhost' (using password: YES)

There's a default connection on the zenoss GUI but i can't login.what's the password?I never set a mysql password for zenoss

Loading Image... Loading Image...
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64685#64685]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[luizzmizz]

luizzmizz [http://community.zenoss.org/people/luizzmizz] created the discussion

"Re: How do i view Zenoss events database?"

To view the discussion, visit: http://community.zenoss.org/message/64697#64697

--------------------------------------------------------------
I didn't use the stack installer either, but... did you try with no "-p"? I find it hard to believe, a debian mysql without a password, but not beeing the root mysql user... it's possible!

also try to connect directly to the database, using mysql -u zenoss *-D events*
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64697#64697]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]