Hi Josh,
If you are using the latest Zenoss, you should be able to check the
mysql username/password/etc in from the Event Manager link on the left
hand side. Check to make sure the information there is correct.
-Eric
Baird, Josh wrote:
Thanks, I think I am on the right road! I ran into a couple of issues.
I went with modifying the init file. I created the database and gave
the 'zenoss' user SUPER privileges.
The tables were created:
* alert_state
* detail
* heartbeat
* history
* log
* status
However, during init, the following error popped up:
ERROR 1359 (HY000) at line 76: Trigger already exists
ERROR 1044 (42000) at line 3: Access denied for user
'zenoss'@'localhost' to database 'zenoss'
What is it trying to do? The zenoss user has proper permissions to the
'zenoss' database.
Upon finishing init, I tried to start zenoss. Scrolling through the
various logs found in /opt/zenoss/log I see several MySQL errors:
2006-11-14 09:55:34 ERROR zen.ZenSyslog: (1045, "Access denied for user
'zenoss'@'localhost' (using password: YES)")
2006-11-14 09:55:03 ERROR zen.Events: (1045, "Access denied for user
'zenoss'@'localhost' (using password: YES)")
Traceback (most recent call last):
Etc..
I am not sure what its trying to do. The 'zenoss' user has proper
privileges for the 'zenoss' database.
Anyone know what might be going on?
Thanks,
Josh Baird
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Christopher Blunck
Sent: Monday, November 13, 2006 4:59 PM
To: General discussion of using zenoss system
Subject: Re: [zenoss-users] RPM Installation
Hello Josh,
The RPM installation does not allow you to customize the MySQL options
during the installation. You have 2 choices of how you would like to
proceed:
Choice #1: Rebuild the RPM after changing zenoss.spec
Install the source RPM and modify the zenoss.spec in
/usr/src/redhat/SPECS. At the top you will find %define's for the MySQL
settings. After you finish modifying the script you can rebuild the
binary RPM using the following command (run as root):
# rpmbuild -ba /usr/src/redhat/SPECS/zenoss.spec
Be warned tho - the rpmbuild requires a few additional dependencies in
order to build. And it takes a long time. :)
Choice #2: Modify /opt/zenoss/bin/zenoss_init and set the values
manually
The zenoss_init script is run when the /opt/zenoss/.installed file does
not exists and it is responsible for creating and initializing the MySQL
and Zeo DB. If you modify /opt/zenoss/bin/zenoss_init and also rm
/opt/zenoss/.installed you should be able to achieve the customization
you're looking for.
I recommend choice #2. It requires < 30 seconds and will get you the
customization you're looking for. If you're feeling ambitious and would
like to rebuild the RPM send a reply and I'll send you a link to the src
RPM (it's not out on sourceforge.net).
-c
Baird, Josh wrote:
Hello,
I have just installed the ZenOSS RPM per the instructions in the RPM
Installation PDF. I have everything up and running fine, but I was
given no option to set my MySQL options (user/database name, etc).
Shouldn't the installation ask me these credentials and then populate
the database with some things? I know that when installing from
source,
install.sh should do this. What am I missing in my RPM installation?
I
can see that it is trying to access a database with the username
"zenoss" but is unsuccessful.
This is a CentOS 4.4 box with MySql 5.0.22.
Thanks,
Josh Baird
------------------------------------------------------------------------
_______________________________________________
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
