Menu
▾
▴
hyperic-hq-discuss — Hyperic HQ SVN Commits
You can subscribe to this list here.
| 2007 |
Jan
|
Feb
|
Mar
(927) |
Apr
(419) |
May
(352) |
Jun
(431) |
Jul
(463) |
Aug
(345) |
Sep
(304) |
Oct
(596) |
Nov
(466) |
Dec
(414) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
(348) |
Feb
(313) |
Mar
(665) |
Apr
(688) |
May
(434) |
Jun
(311) |
Jul
(540) |
Aug
(554) |
Sep
(467) |
Oct
(341) |
Nov
(365) |
Dec
(272) |
| 2009 |
Jan
(386) |
Feb
(293) |
Mar
(279) |
Apr
(239) |
May
(229) |
Jun
(199) |
Jul
(186) |
Aug
(111) |
Sep
(196) |
Oct
(146) |
Nov
(116) |
Dec
(140) |
| 2010 |
Jan
(170) |
Feb
(159) |
Mar
(151) |
Apr
(161) |
May
(90) |
Jun
(56) |
Jul
(28) |
Aug
(22) |
Sep
(5) |
Oct
|
Nov
(23) |
Dec
(12) |
| 2011 |
Jan
(8) |
Feb
(8) |
Mar
(22) |
Apr
(24) |
May
(4) |
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2012 |
Jan
(5) |
Feb
(1) |
Mar
|
Apr
(1) |
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Charles L. <cl...@hy...> - 2007-03-31 00:03:01
|
Not at the moment, but we are planning/designing a very cool new UI feature that allows you to drop in your own view definitions into the application, similar to the product plugins. In addition to providing custom views of the data, it'll also have some new capabilities of displaying live data in real time. We are very excited about this and will make the plans available as soon as we can spec out the design. Charles |
|
From: Charles L. <cl...@hy...> - 2007-03-30 23:58:20
|
Hi Josh, There was a discussion regarding this already: http://forums.hyperic.com/jiveforums/thread.jspa?messageID=5096 As for being able to better navigate the alerts (there have been many different requests for this), we are planning on designing an alert center, where you can manage and view alerts more easily. To better manage the recipient list, you should make use of the escalation schemes. An escalation scheme can be associated with multiple alert definitions, and you can change the escalation scheme to affect all of the alert definitions that use it. Charles On Mar 30, 2007, at 11:10 AM, Josh Jondle wrote: > Also, is there a way to just list all alerts on the server? I need > to make a change to every single alert recipient list and it'd be > far easier if I could just do it from a big list instead of having > to drone through every item to see if it has an alert set on it. > > > Thanks, > > Josh > |
|
From: Charles L. <cl...@hy...> - 2007-03-30 23:51:06
|
Hi Mike, This issue was logged and resolved: http://jira.hyperic.com/browse/HHQ-792 Essentially, 'alert list' without any parameters should not be valid. To get help with any command in the CLI, you can simply type 'help command' or just 'help' for a list of available commands. Also, here's the link to our CLI documentation: http://support.hyperic.com/confluence/display/DOCSHQ30/CLI+Reference Charles |
|
From: Charles L. (JIRA) <ji...@hy...> - 2007-03-30 23:49:37
|
[ http://jira.hyperic.com/browse/HHQ-792?page=all ] Charles Lee moved HQ-586 to HHQ-792: ------------------------------------ Project: Hyperic HQ (was: Hyperic HQ Enterprise) Key: HHQ-792 (was: HQ-586) Issue Type: Bug (was: Developer) Component: CLI (was: CLI) Fix Version: 3.0.3 3.1.0 (was: 3.0.3) (was: 3.1.0) Version: 3.0.2 (was: 3.0.2) > CLI Alert list throws error > --------------------------- > > Key: HHQ-792 > URL: http://jira.hyperic.com/browse/HHQ-792 > Project: Hyperic HQ > Type: Bug > Components: CLI > Versions: 3.0.2 > Environment: Server 3.0.2-EE build # 338 ,Platform Windows XP SP2 > Reporter: Nipuna Bhayani > Assignee: Charles Lee > Priority: Minor > Fix For: 3.0.3, 3.1.0 > > > Steps to reproduce: > Login to hq-shell > run alert list > Actual Results: > hq-shell::hqadmin> alert list > org.hyperic.util.shell.ShellCommandExecException: Error getting alertsWithin undeclared throwable was: java.lang.ClassNotFoundException: org.hibernate.collection.PersistentBag (no security manager: RMI class loader disabled) > Expected Results: > Should list the alerts without any error -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.hyperic.com/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |
|
From: <cl...@hy...> - 2007-03-30 23:45:34
|
Author: clee Date: 2007-03-30 15:45:30 -0800 (Fri, 30 Mar 2007) New Revision: 3976 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3976 Modified: trunk/installer/data/db-upgrade.xml Log: Add the RT tables to upgrade script Modified: trunk/installer/data/db-upgrade.xml =================================================================== --- trunk/installer/data/db-upgrade.xml 2007-03-30 23:44:36 UTC (rev 3975) +++ trunk/installer/data/db-upgrade.xml 2007-03-30 23:45:30 UTC (rev 3976) @@ -5009,6 +5009,105 @@ </schema-directSQL> </schemaSpec> + <!-- Add the missing RT tables for .org. Deliberately skipping Oracle, since + users who use Oracle (likely Enterprise customers) will already have these + tables --> + <schemaSpec version="3.24"> + <schema-directSQL> + <statement desc="Add eam_error_code table" fail="false" targetDB="postgresql"> + CREATE TABLE eam_error_code ( + id integer NOT NULL, + version_col bigint DEFAULT 0 NOT NULL, + code integer NOT NULL, + description character varying(64) NOT NULL + ); + </statement> + <statement desc="Add eam_error_code constraint" fail="false" targetDB="postgresql"> + ALTER TABLE ONLY eam_error_code ADD CONSTRAINT eam_error_code_pkey PRIMARY KEY (id); + </statement> + <statement desc="Add eam_error_code index" fail="false" targetDB="postgresql"> + CREATE INDEX error_code ON eam_error_code USING btree (code); + </statement> + <statement desc="Add eam_service_request table" fail="false" targetDB="postgresql"> + CREATE TABLE eam_service_request ( + id integer NOT NULL, + version_col bigint DEFAULT 0 NOT NULL, + serviceid integer NOT NULL, + url character varying(767) NOT NULL + ); + </statement> + <statement desc="Add eam_service_request primary key" fail="false" targetDB="postgresql"> + ALTER TABLE ONLY eam_service_request + ADD CONSTRAINT eam_service_request_pkey PRIMARY KEY (id); + </statement> + <statement desc="Add eam_service_request unique constraint" fail="false" targetDB="postgresql"> + ALTER TABLE ONLY eam_service_request + ADD CONSTRAINT eam_service_request_serviceid_key UNIQUE (serviceid, url); + </statement> + <statement desc="Add eam_service_request index" fail="false" targetDB="postgresql"> + CREATE INDEX service_request_svcid ON eam_service_request USING btree (serviceid); + </statement> + <statement desc="Add eam_service_request index" fail="false" targetDB="postgresql"> + CREATE INDEX service_request_url ON eam_service_request USING btree (url); + </statement> + <statement desc="Add eam_request_stat table" fail="false" targetDB="postgresql"> + CREATE TABLE eam_request_stat ( + id integer NOT NULL, + version_col bigint DEFAULT 0 NOT NULL, + ipaddr character varying(20) NOT NULL, + min double precision NOT NULL, + max double precision NOT NULL, + total double precision NOT NULL, + count integer NOT NULL, + begintime bigint NOT NULL, + endtime bigint NOT NULL, + svctype integer NOT NULL, + svcreq_id integer + ); + </statement> + <statement desc="Add eam_request_stat primary key" fail="false" targetDB="postgresql"> + ALTER TABLE ONLY eam_request_stat + ADD CONSTRAINT eam_request_stat_pkey PRIMARY KEY (id); + </statement> + <statement desc="Add eam_request_stat index" fail="false" targetDB="postgresql"> + CREATE INDEX reqstat_idx_begintime ON eam_request_stat USING btree (begintime); + </statement> + <statement desc="Add eam_request_stat index" fail="false" targetDB="postgresql"> + CREATE INDEX reqstat_idx_endtime ON eam_request_stat USING btree (endtime); + </statement> + <statement desc="Add eam_request_stat index" fail="false" targetDB="postgresql"> + CREATE INDEX service_id ON eam_request_stat USING btree (svcreq_id); + </statement> + <statement desc="Add eam_request_stat foreign key" fail="false" targetDB="postgresql"> + ALTER TABLE ONLY eam_request_stat + ADD CONSTRAINT fke8ebbc72154d0f55 FOREIGN KEY (svcreq_id) REFERENCES eam_service_request(id) ON DELETE CASCADE; + </statement> + <statement desc="Add eam_stat_errors table" fail="false" targetDB="postgresql"> + CREATE TABLE eam_stat_errors ( + id integer NOT NULL, + version_col bigint DEFAULT 0 NOT NULL, + count integer NOT NULL, + error_id integer, + reqstat_id integer + ); + </statement> + <statement desc="Add eam_stat_errors primary key" fail="false" targetDB="postgresql"> + ALTER TABLE ONLY eam_stat_errors + ADD CONSTRAINT eam_stat_errors_pkey PRIMARY KEY (id); + </statement> + <statement desc="Add eam_stat_errors index" fail="false" targetDB="postgresql"> + CREATE INDEX stat_errors_reqstat ON eam_stat_errors USING btree (reqstat_id); + </statement> + <statement desc="Add eam_stat_errors foreign key constraint" fail="false" targetDB="postgresql"> + ALTER TABLE ONLY eam_stat_errors + ADD CONSTRAINT fk6f2383a8237d366c FOREIGN KEY (error_id) REFERENCES eam_error_code(id) ON DELETE CASCADE; + </statement> + <statement desc="Add eam_stat_errors foreign key constraint" fail="false" targetDB="postgresql"> + ALTER TABLE ONLY eam_stat_errors + ADD CONSTRAINT fk6f2383a82de89070 FOREIGN KEY (reqstat_id) REFERENCES eam_request_stat(id) ON DELETE CASCADE; + </statement> + </schema-directSQL> + </schemaSpec> </dbupgrade> |
|
From: <cl...@hy...> - 2007-03-30 23:44:38
|
Author: clee Date: 2007-03-30 15:44:36 -0800 (Fri, 30 Mar 2007) New Revision: 3975 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3975 Modified: trunk/src/org/hyperic/tools/ant/dbupgrade/SST_DirectSQL.java Log: Add flag to allow statements to fail without throwing exception Modified: trunk/src/org/hyperic/tools/ant/dbupgrade/SST_DirectSQL.java =================================================================== --- trunk/src/org/hyperic/tools/ant/dbupgrade/SST_DirectSQL.java 2007-03-30 23:38:21 UTC (rev 3974) +++ trunk/src/org/hyperic/tools/ant/dbupgrade/SST_DirectSQL.java 2007-03-30 23:44:36 UTC (rev 3975) @@ -40,7 +40,6 @@ public class SST_DirectSQL extends SchemaSpecTask { private VerifySchema verifySchema; - private Statement statement; private List statements; public SST_DirectSQL () { @@ -95,15 +94,29 @@ private Connection conn = null; private String desc = null; private String targetDB = null; + private boolean fail = true; public Statement () {} public void init (Connection conn) { this.conn = conn; } - public void setDesc (String s) { desc=s; } - public String getDesc () { return desc; } + public void setDesc(String s) { + desc = s; + } + public String getDesc() { + return desc; + } + + public boolean isFail() { + return fail; + } + + public void setFail(boolean fail) { + this.fail = fail; + } + public void setTargetDB (String t) { targetDB = t; } public void addText(String msg) { @@ -153,8 +166,9 @@ try { ps.execute(); } catch (SQLException e) { - if (sqlStmt.trim().toLowerCase().startsWith("drop")) { - log(">>>>> Drop failed: " + e); + if (!isFail() || + sqlStmt.trim().toLowerCase().startsWith("drop")) { + log(">>>>> SQL failed: " + e); conn.rollback(); conn.commit(); } else { |
|
From: <cl...@hy...> - 2007-03-30 23:38:25
|
Author: clee Date: 2007-03-30 15:38:21 -0800 (Fri, 30 Mar 2007) New Revision: 3974 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3974 Modified: trunk/src/org/hyperic/util/jdbc/DBUtil.java Log: Update MySQL error statement Modified: trunk/src/org/hyperic/util/jdbc/DBUtil.java =================================================================== --- trunk/src/org/hyperic/util/jdbc/DBUtil.java 2007-03-30 22:27:26 UTC (rev 3973) +++ trunk/src/org/hyperic/util/jdbc/DBUtil.java 2007-03-30 23:38:21 UTC (rev 3974) @@ -646,7 +646,7 @@ case DATABASE_MYSQL5: msg = changeNullAndTrim(e.getMessage()); - return (msg.startsWith("Base table or view not found")); + return (msg.endsWith("doesn't exist")); default: return false; } |
|
From: mike m. <mi...@an...> - 2007-03-30 23:31:05
|
I logged into the hyperic shell and just wanted to check on the commands and their output . Im having trouble understanding the sysntax I do a alert list and get : alert list org.hyperic.util.shell.ShellCommandExecException: Error getting alerts Within undeclared throwable was: java.lang.ClassNotFoundException: org.hibernate .collection.PersistentBag (no security manager: RMI class loader disabled) When I use the"alertdef list "command it comes back with : alertdef list <-group | -platform | -server | -service > <resource> [-enabled | -disabled] Do I replace -platform with say -linux ? or a particular platforn computer name what are they referring to with resource ? is the HQ agent a resource ? what is required and what is not. . Cant seen to get anything to work . An example for this command is all I need . |
|
From: John S. <hq-...@hy...> - 2007-03-30 23:10:45
|
Yes, you can do this with HQ-EE. You can apply an alert to all resources of the same type (i.e. Solaris platforms). You can also apply an alert to every member of a compatible group. |
|
From: mike m. <mi...@an...> - 2007-03-30 23:06:47
|
If I create an alert for a process or agent for say "availability" under the open source , or for the EE version , can this alert that is defined for 1 solaris system, be used to monitor all the rest of my Solaris systems or do I have to create separate alerts for each system ??? I see that I can do various tests of systems but as of now I am just configuring them on 1 system. Need to be able to do this to a multiple of like systems ... |
|
From: mike m. <mi...@an...> - 2007-03-30 23:02:20
|
I have created an alert for the hyperic client agent on a remote system to email me when its availability changes. I have availability changed to 1 min intervals . Yet the dashboard doesnt upgrade for much more than 1 minute. I see this primarily on remote windows clients that the dasboard doesnt update quickly. Also when looking at the platform of the machine where the client was stopped under the RESOURCES column the various parts of the Platform services health update to red at different times . Why NOT all at the same time. What goes into the how often the dashboard is updated ??? If i click on a specific favorite resource the availability graph show red but the dashboard under the Favorite resource is still green ?? |
|
From: Darin F. <dfe...@ci...> - 2007-03-30 22:58:39
|
>From what I have read JBoss Operations Network contains Hyperic HQ. But is this just a direct OEM of the Hyperic HQ product, or does JBoss modify / extend Hyperic HQ in its JBoss ON deliverable? If its a direct OEM is there a way to map the JBoss ON version to the Hyperic HQ version? Thanks |
|
From: John S. (JIRA) <ji...@hy...> - 2007-03-30 22:55:36
|
Max/min data points not being charted correctly
-----------------------------------------------
Key: HHQ-791
URL: http://jira.hyperic.com/browse/HHQ-791
Project: Hyperic HQ
Type: Bug
Components: Charts
Versions: 2.6
Reporter: John Sachs
Assigned to: Charles Lee
Fix For: 3.0.3
There have been examples where an extreme value for a metric is not charted correctly, depending on the metric display range. For instance, say there was a metric that averaged under 5 and then it had a data point of 200. The 200 point shows up on metric display ranges that are relatively "zoomed in" (i.e. "8 hours", "4 days", etc). But if you "zoom out" sufficiently, the high point is lost. That high point should never be lost regardless of the display range.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.hyperic.com/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
|
|
From: Darin F. <dfe...@ci...> - 2007-03-30 22:55:31
|
I got the database running now, thanks. I am still having problems with exceptions in the server though, trying to track down, looks like port use issues. Thanks for the help. |
|
From: Darin F. <dfe...@ci...> - 2007-03-30 22:52:57
|
Can the user interface be customized to add new views / functionality? |
|
From: mike m. <mi...@an...> - 2007-03-30 22:35:36
|
Thanks for the info |
|
From: John S. (JIRA) <ji...@hy...> - 2007-03-30 22:33:36
|
Make availability icons clickable
---------------------------------
Key: HHQ-790
URL: http://jira.hyperic.com/browse/HHQ-790
Project: Hyperic HQ
Type: New Feature
Components: UI
Versions: 3.0.2
Reporter: John Sachs
Assigned to: Charles Lee
Fix For: 3.0.3
Wherever there are availability icons, it would be nice if they were clickable...especially on the dashboard.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.hyperic.com/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
|
|
From: <cl...@hy...> - 2007-03-30 22:27:32
|
Author: clee Date: 2007-03-30 14:27:26 -0800 (Fri, 30 Mar 2007) New Revision: 3973 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3973 Modified: trunk/installer/bin/hq-setup.sh trunk/installer/data/setup-db-hibernate.xml trunk/installer/data/setup.xml trunk/installer/src/org/hyperic/hq/install/BaseConfig.java trunk/installer/src/org/hyperic/hq/install/ServerConfig.java Log: Add options for -full and -mysql for installer to support installing on or upgrade MySQL schema. Modified: trunk/installer/bin/hq-setup.sh =================================================================== --- trunk/installer/bin/hq-setup.sh 2007-03-30 12:37:52 UTC (rev 3972) +++ trunk/installer/bin/hq-setup.sh 2007-03-30 22:27:26 UTC (rev 3973) @@ -97,6 +97,8 @@ INSTALL_MODE=oracle elif [ "x${1}" = "x-postgresql" ] ; then INSTALL_MODE=postgresql + elif [ "x${1}" = "x-mysql" ] ; then + INSTALL_MODE=mysql else SETUP_FILE="${1}" fi Modified: trunk/installer/data/setup-db-hibernate.xml =================================================================== --- trunk/installer/data/setup-db-hibernate.xml 2007-03-30 12:37:52 UTC (rev 3972) +++ trunk/installer/data/setup-db-hibernate.xml 2007-03-30 22:27:26 UTC (rev 3973) @@ -49,10 +49,12 @@ <property name="hyperic.dialect" value="PostgreSQL" /> <property name="hibernate.dialect" value="org.hyperic.hibernate.dialect.${hyperic.dialect}Dialect" /> </case> - <case value="mySQL"> - <property name="hyperic.dialect" value="MySQL" /> + <case value="MySQL"> + <property name="hyperic.dialect" value="MySQL5InnoDB" /> + <property name="hibernate.dialect" value="org.hyperic.hibernate.dialect.${hyperic.dialect}Dialect" /> </case> <default> + <property name="hibernate.dialect" value="org.hibernate.dialect.${hyperic.dialect}Dialect" /> <fail> Unrecognized datasource mapping name: ${server.database} </fail> @@ -129,7 +131,6 @@ </sequential> </for> - <property name="hibernate.dialect" value="org.hibernate.dialect.${hyperic.dialect}Dialect" /> <property file="${hibernate-properties}" /> <echoproperties destfile="${hibernate-properties-gen}.xml" format="xml"> <propertyset> Modified: trunk/installer/data/setup.xml =================================================================== --- trunk/installer/data/setup.xml 2007-03-30 12:37:52 UTC (rev 3972) +++ trunk/installer/data/setup.xml 2007-03-30 22:27:26 UTC (rev 3973) @@ -541,6 +541,7 @@ <include name="libreadline-java.jar"/> <include name="ojdbc14.jar"/> <include name="postgresql-7.4.3.jar"/> + <include name="mysql-connector-java-5.0.5-bin.jar"/> <include name="optional.jar"/> <include name="sigar.jar"/> <include name="xercesImpl.jar"/> Modified: trunk/installer/src/org/hyperic/hq/install/BaseConfig.java =================================================================== --- trunk/installer/src/org/hyperic/hq/install/BaseConfig.java 2007-03-30 12:37:52 UTC (rev 3972) +++ trunk/installer/src/org/hyperic/hq/install/BaseConfig.java 2007-03-30 22:27:26 UTC (rev 3973) @@ -46,6 +46,7 @@ public static final String INSTALLMODE_QUICK = "quick"; public static final String INSTALLMODE_ORACLE = "oracle"; public static final String INSTALLMODE_POSTGRESQL = "postgresql"; + public static final String INSTALLMODE_MYSQL = "mysql"; public static final String INSTALLMODE_FULL = "full"; private String baseName; Modified: trunk/installer/src/org/hyperic/hq/install/ServerConfig.java =================================================================== --- trunk/installer/src/org/hyperic/hq/install/ServerConfig.java 2007-03-30 12:37:52 UTC (rev 3972) +++ trunk/installer/src/org/hyperic/hq/install/ServerConfig.java 2007-03-30 22:27:26 UTC (rev 3973) @@ -63,10 +63,14 @@ public static final String DBC_ORA9 = "Oracle 9i/10g"; public static final String DBC_PGSQL = "PostgreSQL"; public static final String DBC_BUILTIN = "HQ Built-in Database"; + public static final String DBC_MYSQL = "MySQL 5.x"; + // database names we need to use internally public static final String DB_ORA8 = "Oracle8"; public static final String DB_ORA9 = "Oracle9i"; public static final String DB_PGSQL = "PostgreSQL"; + public static final String DB_MYSQL = "MySQL"; + // Required for postgresql public static final String PGSQL_PROTOCOL = "?protocolVersion=2"; @@ -159,7 +163,6 @@ throws EarlyExitException { ConfigSchema schema = super.getInstallSchema(previous, iterationCount); - String dbCreateChoice; String portChoice; String fqdn; String domain; @@ -168,15 +171,11 @@ String dbChoice; StringConfigOption usernameOption; StringConfigOption passwordOption; - String advancedDBSetupChoice; - int tablespaceIndex; String serverInstallDir; - String installMode = getProjectProperty("install.mode"); - boolean isOracleQuickMode = installMode.equals(INSTALLMODE_ORACLE); - boolean isPGSQLQuickMode = installMode.equals(INSTALLMODE_POSTGRESQL); - boolean isQuickMode = isPGSQLQuickMode || isOracleQuickMode || - installMode.equals(INSTALLMODE_QUICK); + InstallMode installMode = + new InstallMode(getProjectProperty("install.mode")); + // Do we have an builtin-postgresql packaged with us? boolean haveBuiltinDB = getReleaseHasBuiltinDB(); @@ -221,7 +220,7 @@ + serverInstallDir); } - if (isQuickMode) { + if (installMode.isQuick()) { schema.addOption (new HiddenConfigOption("server.webapp.port", "7080")); @@ -266,7 +265,7 @@ // creating the database, since we don't yet run dbsetup // for upgrades String computedBaseUrl = computeHTTPBaseUrl(fqdn, portChoice); - if (isQuickMode) { + if (installMode.isQuick()) { schema.addOption (new HiddenConfigOption("server.webapp.baseurl", computedBaseUrl)); @@ -287,7 +286,7 @@ fqdn)); } - if (isQuickMode) { + if (installMode.isQuick()) { schema.addOption(new HiddenConfigOption("server.mail.sender", "hqadmin@" + domain)); } else { @@ -298,47 +297,53 @@ break; case 5: - if (isOracleQuickMode) { + if (installMode.isOracle()) { String defaultDB = DBC_ORA9; String[] dbs = new String[] { DBC_ORA8, DBC_ORA9 }; - schema.addOption - (new EnumerationConfigOption("server.database.choice", - Q_DATABASE, - defaultDB, - dbs)); - } else if (isPGSQLQuickMode) { - schema.addOption - (new HiddenConfigOption("server.database.choice", - DBC_PGSQL)); - - } else if (isQuickMode && haveBuiltinDB) { - schema.addOption - (new HiddenConfigOption("server.database.choice", - DBC_BUILTIN)); - + schema.addOption( + new EnumerationConfigOption("server.database.choice", + Q_DATABASE, + defaultDB, + dbs)); + } else if (installMode.isPostgres()) { + schema.addOption( + new HiddenConfigOption("server.database.choice", + DBC_PGSQL)); + } else if (installMode.isMySQL()) { + schema.addOption( + new HiddenConfigOption("server.database.choice", + DBC_MYSQL)); + } else if (installMode.isQuick() && haveBuiltinDB) { + schema.addOption( + new HiddenConfigOption("server.database.choice", + DBC_BUILTIN)); } else { - String defaultDB - = haveBuiltinDB ? DBC_BUILTIN : DBC_ORA9; + String defaultDB = haveBuiltinDB ? DBC_BUILTIN : DBC_ORA9; String[] dbs = haveBuiltinDB ? new String[] { DBC_BUILTIN, DBC_ORA8, DBC_ORA9, - DBC_PGSQL } - : new String[] { DBC_ORA8, DBC_ORA9, DBC_PGSQL }; - schema.addOption - (new EnumerationConfigOption("server.database.choice", - Q_DATABASE, - defaultDB, - dbs)); + DBC_PGSQL, DBC_MYSQL } + : new String[] { DBC_ORA8, DBC_ORA9, DBC_PGSQL, DBC_MYSQL }; + schema.addOption( + new EnumerationConfigOption("server.database.choice", + Q_DATABASE, + defaultDB, + dbs)); } break; case 6: // determine server.database from server.database.choice... dbChoiceStr = previous.getValue("server.database.choice"); - if (dbChoiceStr.equals(DBC_ORA8)) dbChoice = DB_ORA8; - else if (dbChoiceStr.equals(DBC_ORA9)) dbChoice = DB_ORA9; - else if (dbChoiceStr.startsWith(DBC_PGSQL)) dbChoice = DB_PGSQL; + if (dbChoiceStr.equals(DBC_ORA8)) + dbChoice = DB_ORA8; + else if (dbChoiceStr.equals(DBC_ORA9)) + dbChoice = DB_ORA9; + else if (dbChoiceStr.startsWith(DBC_PGSQL)) + dbChoice = DB_PGSQL; + else if (dbChoiceStr.startsWith(DBC_MYSQL)) + dbChoice = DB_MYSQL; else if (dbChoiceStr.equals(DBC_BUILTIN)) { - dbChoice = DB_PGSQL; + dbChoice = DB_PGSQL; schema.addOption(new HiddenConfigOption("using.builtin.db", "true")); } @@ -353,12 +358,6 @@ StringUtil.replace(Q_JDBC_URL, "%%DBNAME%%", dbChoiceStr), "jdbc:oracle:thin:@localhost:1521:HYPERIC_" + PRODUCT)); - schema.addOption(new StringConfigOption("server.database-user", - Q_JDBC_USER)); - passwordOption = new StringConfigOption( - "server.database-password", Q_JDBC_PASSWORD); - passwordOption.setSecret(true); - schema.addOption(passwordOption); schema.addOption(new HiddenConfigOption( "server.database-driver", "oracle.jdbc.driver.OracleDriver")); @@ -373,19 +372,23 @@ dbChoiceStr), "jdbc:postgresql://localhost:5432/" + PRODUCT + PGSQL_PROTOCOL)); - schema.addOption(new StringConfigOption("server.database-user", - Q_JDBC_USER)); - passwordOption = new StringConfigOption( - "server.database-password", Q_JDBC_PASSWORD); - passwordOption.setSecret(true); - schema.addOption(passwordOption); schema.addOption(new HiddenConfigOption( "server.database-driver", "org.postgresql.Driver")); schema.addOption(new HiddenConfigOption( "server.quartzDelegate", "org.quartz.impl.jdbcjobstore.PostgreSQLDelegate")); + } else if ( dbChoice.equals(DB_MYSQL) ) { + schema.addOption(new StringConfigOption("server.database-url", + StringUtil.replace(Q_JDBC_URL, "%%DBNAME%%", + dbChoiceStr), + "jdbc:mysql://localhost:3306/" + PRODUCT)); + schema.addOption(new HiddenConfigOption( + "server.database-driver", "com.mysql.jdbc.Driver")); + schema.addOption(new HiddenConfigOption( + "server.quartzDelegate", + "org.quartz.impl.jdbcjobstore.StdJDBCDelegate")); } else { - if (!isQuickMode) { + if (!installMode.isQuick()) { // In "full" mode, we even let them pick the pgsql port schema.addOption (new PortConfigOption("server.postgresql.port", @@ -398,10 +401,6 @@ } schema.addOption(new HiddenConfigOption - ("server.database-user", "hqadmin")); - schema.addOption(new HiddenConfigOption - ("server.database-password", "hqadmin")); - schema.addOption(new HiddenConfigOption ("server.database-driver", "org.postgresql.Driver")); schema.addOption @@ -409,20 +408,32 @@ ("server.quartzDelegate", "org.quartz.impl.jdbcjobstore.PostgreSQLDelegate")); } + + if (dbChoiceStr.equals(DBC_BUILTIN)) { + schema.addOption(new HiddenConfigOption + ("server.database-user", "hqadmin")); + schema.addOption(new HiddenConfigOption + ("server.database-password", "hqadmin")); + } + else { + schema.addOption(new StringConfigOption("server.database-user", + Q_JDBC_USER)); + passwordOption = new StringConfigOption( + "server.database-password", Q_JDBC_PASSWORD); + passwordOption.setSecret(true); + schema.addOption(passwordOption); + } senderChoice = previous.getValue("server.mail.sender"); // dont ask about admin username if this is an HA node // this should have already been set up - if (isQuickMode) { - schema.addOption(new HiddenConfigOption - ("server.admin.username", - "hqadmin")); - schema.addOption(new HiddenConfigOption - ("server.admin.password", - "hqadmin")); - schema.addOption - (new HiddenConfigOption("server.admin.email", - senderChoice)); + if (installMode.isQuick()) { + schema.addOption(new HiddenConfigOption( + "server.admin.username", "hqadmin")); + schema.addOption(new HiddenConfigOption( + "server.admin.password", "hqadmin")); + schema.addOption(new HiddenConfigOption("server.admin.email", + senderChoice)); } else { usernameOption = new AdminUsernameConfigOption ("server.admin.username", Q_ADMIN_USER, "hqadmin"); @@ -689,7 +700,7 @@ String url = config.getValue("server.database-url"); try { - return DBUtil.checkTableExists(url, user, password, + return DBUtil.checkTableExists(url, user, password, "EAM_CONFIG_PROPS"); } catch (DriverLoadException e) { throw new EarlyExitException("Error connecting to database " @@ -713,4 +724,35 @@ + "hqdb"); return (hqdbDir.exists() && hqdbDir.isDirectory() && hqdbDir.canRead()); } + + private class InstallMode { + boolean _oracleQuickMode = false; + boolean _postgresQuickMode = false; + boolean _mysqlQuickMode = false; + boolean _quickMode = false; + + InstallMode(String mode) { + _oracleQuickMode = mode.equals(INSTALLMODE_ORACLE); + _postgresQuickMode = mode.equals(INSTALLMODE_POSTGRESQL); + _mysqlQuickMode = mode.equals(INSTALLMODE_MYSQL); + _quickMode = mode.equals(INSTALLMODE_QUICK); + } + + boolean isOracle() { + return _oracleQuickMode; + } + + boolean isPostgres() { + return _postgresQuickMode; + } + + boolean isMySQL() { + return _mysqlQuickMode; + } + + boolean isQuick() { + return _postgresQuickMode || _oracleQuickMode || _mysqlQuickMode || + _quickMode; + } + } } |
|
From: heathert <hq...@hy...> - 2007-03-30 21:25:55
|
Hi Zuo, I've sent you an email and am looking forward to get your files. Thanks very much. -Heather |
|
From: John M. W. <joh...@hy...> - 2007-03-30 20:42:15
|
Venkat, I had the same problem. In my case, it was permissions. If the XML file is not readable by your HQ process owner(s), then it won't show up. When I changed permissions, I had to restart the agent. If you have to change permissions in the server directory, it might require a server restart as well. |
|
From: John M. W. <joh...@hy...> - 2007-03-30 20:34:06
|
oh yeah, to see the section on agentless SNMP monitoring, go to page 21 of the "test ride guide" - http://www.hyperic.com/downloads/assets/review_guide.pdf |
|
From: John M. W. <joh...@hy...> - 2007-03-30 20:21:28
|
It might take a couple of minutes. I noticed that you posted your last message right after you solved the permissions issue. |
|
From: John M. W. <joh...@hy...> - 2007-03-30 20:19:05
|
How are you starting the database? The preferred way to start HQ in Windows is to install HQ as a service - use "hq-server.exe -i" In absence of that, you'll have to do a 2-step procedure: "db-start.bat" and "hq-server.exe" |
|
From: Josh J. <jj...@gc...> - 2007-03-30 20:16:13
|
I have never had to start the database manually on my windows HQ server. It is a dependency from, and starts automatically, when you start the HQ-Server service. Did you install by running our installation batch file in a command prompt? After installation completed did you leave the server running and connect to the HQ to verify connectivity and login ability? Based on the limited knowledge all I could suggest is this. (only if this is a new install) 1. Re-run your "setup.bat -full" 2. Pick server installation 3. Answer all questions and let installation complete 4. Once install is complete close the server 5. Run "hq-server.exe -i" to install the server as a service 6. Go to your Services and right-click Hyperic HQ Server and click Start 7. It should start the server first and then the database 8. Verify that you can log into the HQ interface. As I typed this it started sounding pretty thin to me, but hope it helps. If you did most of this but didn't finish, i.e.-didn't install as a service, pick up at that point and finish up. |
|
From: norcom <hq-...@hy...> - 2007-03-30 20:05:59
|
My Availability still shows as 0% and I'm no longer getting any errors trying to save the configuration. Any help would be appreciated. Thanks. |
14 messages has been excluded from this view by a project administrator.
