This sums it up:
[admin@<...> ~/hyperic-hq-installer]$ ./setup.sh
Initializing Hyperic HQ 4.1.1 Installation...
Loading taskdefs...
Taskdefs loaded
Choose which software to install:
1: Hyperic HQ Server
2: Hyperic HQ Agent
You may enter multiple choices, separated by commas.
1
HQ server installation path [default '/home/hyperic']:
Choices:
1: Oracle 10g/11g
2: PostgreSQL
3: MySQL 5.x
What backend database should the HQ server use? [default '1']:
3
Enter the JDBC connection URL for the MySQL 5.x database [default 'jdbc:mysql://localhost:3306/HQ']:
Enter the username to use to connect to the database:
<...>
Enter the password to use to connect to the database:
(again):
Choices:
1: Upgrade the HQ server database
2: Overwrite the HQ server database (ERASE all existing data)
3: Exit the installer
An HQ server database already exists at the JDBC connection URL.
What should be done with this database? [default '3']:
1
Loading install configuration...
Install configuration loaded.
Preparing to install...
Validating server install configuration...
Checking server webapp port...
Checking server secure webapp port...
Checking server JRMP port...
Checking server JNP port...
Checking database permissions...
Validating server DB configuration...
Installing the server...
Unpacking server to: /home/hyperic/server-4.1.1...
Creating server configuration files...
Copying binaries and libraries to server installation...
Copying server configuration file...
Copying server control file...
Copying server binaries...
Copying server libs...
Setting up server database...
Upgrading database...
--------------------------------------------------------------------------------
An ERROR occurred, the installation cannot continue.
FATAL EXCEPTION at /home/admin/hyperic-hq-installer/installer-4.1.1/data/setup.xml:401: : The following error occurred while executing this line:
/home/admin/hyperic-hq-installer/installer-4.1.1/data/setup.xml:407: The following error occurred while executing this line:
/home/admin/hyperic-hq-installer/installer-4.1.1/data/setup.xml:531: The following error occurred while executing this line:
/home/admin/hyperic-hq-installer/installer-4.1.1/data/setup-db-MySQL.xml:21: The following error occurred while executing this line:
/home/admin/hyperic-hq-installer/installer-4.1.1/data/setup-db-common.xml:95: The following error occurred while executing this line:
/home/admin/hyperic-hq-installer/installer-4.1.1/data/db-upgrade.xml:28: DBUpgrader: Error running SchemaSpec: 3.138: Error running SchemaSpecTask: org.hyperic.tools.ant.dbupgrade.SST_DirectSQL: Error executing statement desc=[null] SQL=[
alter table EAM_CPROP drop foreign key FKE5D04798CCF47F9F
] java.sql.SQLException: Error on rename of './HQ/EAM_CPROP' to './HQ/#sql2-3e78-1f' (errno: 152)