Bug #23440 Serv Inst (Bitrock) - Specified port not passed correctly to merlin.xml(br 1735)
Submitted: 18 Oct 2006 18:10 Modified: 3 Nov 2006 14:42
Reporter: Punita Srivastava Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Installing Severity:S1 (Critical)
Version:0.7.4 OS:Linux (rhel4)
Assigned to: CPU Architecture:Any

[18 Oct 2006 18:10] Punita Srivastava
Description:
This could be an install issue but the merlin.xml has all the right content. I get a 'got status 500' when I try to login into the dashboard for the first time.

Here is what my configration.txt file contains:
-bash-3.00$ sudo cat configuration_report.txt

Application hostname and port: http://127.0.0.1:88
Tomcat Ports: 8080 - 8443 (SSL)
MySQL Port : 9306

Application Role Credentials:
----------------------------
Root role: root/mysql
Agent role: agent/mysql

MySQL Credentials:
------------------
root/merlin

MySQL Agent configuration file 'hostname' syntax:
-------------------------------------------------
hostname = http://agent:mysql@127.0.0.1:8080/merlin/heartbeat-
-----------------------

Here is what mysql db has in merlin
----start of paste from mysql console-----
mysql> connect merlin;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Connection id:    3
Current database: merlin

mysql> show tables;
+------------------+
| Tables_in_merlin |
+------------------+
| users            |
+------------------+
1 row in set (0.00 sec)
-------end of paste----------

Here is the contents of my merlin.xml file
-------start of paste-----
<?xml version="1.0"?><doc><db><![CDATA[merlin]]></db><server><![CDATA[localhost]
]></server><port><![CDATA[3306]]></port><user><![CDATA[root]]></user><pass><![CD
ATA[merlin]]></pass><key><![CDATA[59605B9EDD885014]]></key><advisorMinThreads><!
[CDATA[2]]></advisorMinThreads><advisorMaxThreads><![CDATA[3]]></advisorMaxThrea
ds><advisorWarmUpTime><![CDATA[30000]]></advisorWarmUpTime></doc>
~---------end of paste----------

How to repeat:
latest build 0.7.4- can't get it up on RHEL4
[18 Oct 2006 21:35] Sloan Childers
BitRock sent us an updated image today with proper string substitution variables for the mysqld port, user and pass in the installer's merlin.xml and server.xml tomcat configuration files.
[18 Oct 2006 21:41] Punita Srivastava
So this was a case of merlin.xml not having the correct port number. It conflicts with what was spcified- (See contents of the config.txt). Changed Synopsis, Assign ed to Keith and added comments.
- Checked server.xml , it is fine
- Checked mysqld.log under .../mysql/data and Darren caught it as the mysqld.log said...9306 and not 3306
- There is also exception in the JDBC.html caused by os err(2) which is 'file does  not exist'
[18 Oct 2006 22:06] Sloan Childers
BitRock has already fixed this.  It will be in tonights build.
[23 Oct 2006 6:04] Carsten Segieth
tested OK on Windows with 0.7.9
[3 Nov 2006 14:42] Mark Leith
Verified fixed 0.7.17