Failed Install JasperServer on Windows Server 2K8

[jwilcox746]

I'm attempting to install JasperServer 3.7 on a Windows Server 2008 box. I'm seeing a couple problems/errors related to the MySQL component. When the first error appears, there is no mysqld service installed.

I am running the installation "As Administrator".

The first error;

"Problem running post-install step. Installation may not complete correctly. Error running c:/PROGRA~2/JASPER~1.7/mysql/bin/mysqladmin.exe --defaults-file=C:/PROGRA~2/JASPER~1.7/mysql/my.ini -u root --password=password -h 127.0.0.1 -P 3306 shutdown :

C:\PROGRA~2\JASPER~1.7\mysql\bin\MYSQLA~1.EXE: connect to server at '127.0.0.1' failed error: 'Can't connect to MySQL server on '127.0.0.1' (10061)' Check that mysqld is running on 127.0.0.1 and that the port is 3306. You can check this by doing 'telnet 127.0.0.1 3306'"

 The Second error;

"Problem running post-install step. Installation may not complete correctly Error running C:/PROGRA~2/JASPER~1.7/scripts/mysql/sampledata_init.bat

jasperadmin : C:/PROGRA~2/JASPER~1.7/mysql/bin/mysqladmin.exe: connect to server at '127.0.0.1' failed

error: 'Access denied for user 'root'@'localhost' (using password:YES)'

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 

[cshaw]

 Did you resolve the first problem with MySQL?  I am seeing the same problem.

[gautier]

Both problems are linked. It is due to windows 2008 and the installer.

Try to do the install in a folder like c:\jasper (with all permissions needed)

 

Hope this helps,

Guillaume

[cshaw]

Thanks for the information Guillaume. I am installing on a Windows Server 2003 64 bit. I cancelled the first install that showed the error, re-installed, and the problem went away. Not sure why, but I am up and running.

 

chris

[mdahlman]

It's great that the install is working well for Chris.

For later readers of the thread, here are the important points:

• In current Windows versions (Vista, 7, 2008 Server, etc.) you need to run as Administrator. (Generally this part happens automatically, but it's worth mentioning.)
• The default install location of "C:\Program Files (x86)" doesn't work correctly for our bundled version of MySQL. Work around this by installing somewhere else like "C:\Jaspersoft" or by installing MySQL separately.
• The installer is 32-bit only.

The first point has a common follow-up issue. Everything goes well, and JasperServer launches and works correctly. But then next week you try to run JasperServer but get errors. The problem is that on subsequent launches Tomcat does not get launched as Administrator, so it has insufficient privileges. Even though it was installed correctly, you need to be careful when launching the server later.

The second point is of course a bug. It should get resolved in later releases.

Thirdely, as Chris points out in this thread, the 32-bit version works fine on 64-bit platforms. But of course it doesn't take advantage of all the 64-bit goodness you might want. It's fine for quick evaluations and even for development. For production you should use the WAR file install. You need to install an application server (like Tomcat) and a database (like MySQL) appropriate for your 64-bit environment. Then JasperServer can be deployed to this and take full advantage of 64-bit happiness.

Regards,
Matt

[cshaw]

Great information Matt. Yes, I am using the 32 bit bundled version on a 64 bit machine in one of our dev environments. I did the install to the default location C:\Program Files (x86), and I am not encountering problems on subsequent startups. It seems to be working fine. Are the startup problems you mention predictable or is there some randomness about it?

chris

[mdahlman]

I'm not sure about the details of when subsequent startups don't work. It's definitely linked to whether it starts up with Administrative privileges. I don't know Windows well enough to know when the admin role is automatically attached (I'm still on XP).

I encountered the problem on a Win2008 Server, and I've seen others encounter it on other platforms. The fix is easy when you know to look for it. But I'm not sure why it would not affect every single installation.

-Matt

[mespub]

Hi,

There,s a special way to install Mysql on Windows Server 2K8 (same with Vista and Seven).

 I got this on the web :

To install MySQL Server 5.0.51a in Vista
1. Disable the UAC in Windows Control Panel->User Accounts
2. Use mysql-essential-5.0.51a-win32.msi
3. In the final step uncheck "Configure MySQL Server now"
4. Download and run Resource Hacker http://www.angusj.com/resourcehacker/
5. Open ...\MySQL Server 5.0\bin\MySQLInstanceConfig.exe with Resource Hacker
6. Navigate to 24\1\1033
7. Change
<requestedExecutionLevel level="asAdministrator" uiAccess="false">
to
<requestedExecutionLevel level="requireAdministrator" uiAccess="false">
8. Press "Compile script"
9. Exit Resource Hacker and save the result (overwrite the initial MySQLInstanceConfig.exe)
10. Now MySQLInstanceConfig.exe should start normally.
11. Configure the server.
12. Sometimes the server doesn't start:
a) Check Windows Firewall settings (3306/TCP)
b) Try changing the compability mode for the file ...\MySQL Server 5.0\bin\mysqld-nt.exe to Windows XP-SP2.
 

 

 

[jabee]

Hi,

 

I have encountered almost same errors. I am using Windows XP by the way.

 

First warning:

 

"Problem running post-install step. Installation may not complete correctly. Error running c:/PROGRA~2/JASPER~1.7/mysql/bin/mysqladmin.exe --defaults-file=C:/PROGRA~2/JASPER~1.7/mysql/my.ini -u root --password=password -h 127.0.0.1 -P 3306 shutdown :

 

C:\PROGRA~2\JASPER~1.7\mysql\bin\MYSQLA~1.EXE: connect to server at '127.0.0.1' failed error: 'Access denied for user 'root'@'localhost' (using password:YES)'

 

 

Second Warning:

 

"Problem running post-install step. Installation may not complete correctly Error running C:/PROGRA~2/JASPER~1.7/scripts/mysql/sampledata_init.bat

 

jasperadmin : C:/PROGRA~2/JASPER~1.7/mysql/bin/mysqladmin.exe: connect to server at '127.0.0.1' failed

 

error: 'Access denied for user 'root'@'localhost' (using password:YES)'

 

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 

 

Hope to hear from you soon

Thanks

 

 

 

Jabee