[SOLVED] Database connectivity when running as a Windows Service
I am setting up a proof of concept with a customer to try and demonstrate the potential of RapidMiner in a corporate setting. I'm starting with the 5.3CE server in hopes that we can get funding for funding next year.
Here is my setup:
1) RapidMiner 5.3CE Server, running as an installed Windows service, on Windows Server 2012 Standard (64-bit) w/8GB memory running in a VMware environment, plenty of hard drive, and Java JRE 1.8.0_20
2) MySQL 5.1.73 running on RedHat Linux 6.5 (64-bit) with 8GB RAM, plenty of hard drive.
When I start the service everything is great. No problems. After a while, things just stop working. Here are the two error situations:
1) I can hit the login page, and it doesn't "break" but it cannot authenticate the user. I can see from watching in MySQL workbench that the RM server stops attempting to connect to the MySQL database. No accounts work when attempting to access the web interface. Connecting from the RM client either does not authenticate or says "Cannot refresh folder. ... Reason: Read timed out"
2) In a more extreme failure situation, I'll just get the JBOSS error page. I don't have a copy of it right at the moment, but if memory serves, it says that the database server is no longer communicating with the JBOSS application.
I thought this might be a Java MySQL problem, so I updated the MySQL connector to my-sql-connector-java-5.1.32-bin. It did not seem to make a difference that I noticed.
This is really perplexing, I have installed RM Server 5.3 CE in a full Linux environment with no issues. So I'm not sure if I should look at something related to Windows, running RM Server as a Windows service, the Java configuration in Windows, etc.
I realize more information might be needed, but I'm not all that familiar with JDBC so am not quite sure where to look. Any help would be appreciated.
THANK YOU in advance for your help!
-Eric
Here is my setup:
1) RapidMiner 5.3CE Server, running as an installed Windows service, on Windows Server 2012 Standard (64-bit) w/8GB memory running in a VMware environment, plenty of hard drive, and Java JRE 1.8.0_20
2) MySQL 5.1.73 running on RedHat Linux 6.5 (64-bit) with 8GB RAM, plenty of hard drive.
When I start the service everything is great. No problems. After a while, things just stop working. Here are the two error situations:
1) I can hit the login page, and it doesn't "break" but it cannot authenticate the user. I can see from watching in MySQL workbench that the RM server stops attempting to connect to the MySQL database. No accounts work when attempting to access the web interface. Connecting from the RM client either does not authenticate or says "Cannot refresh folder. ... Reason: Read timed out"
2) In a more extreme failure situation, I'll just get the JBOSS error page. I don't have a copy of it right at the moment, but if memory serves, it says that the database server is no longer communicating with the JBOSS application.
I thought this might be a Java MySQL problem, so I updated the MySQL connector to my-sql-connector-java-5.1.32-bin. It did not seem to make a difference that I noticed.
This is really perplexing, I have installed RM Server 5.3 CE in a full Linux environment with no issues. So I'm not sure if I should look at something related to Windows, running RM Server as a Windows service, the Java configuration in Windows, etc.
I realize more information might be needed, but I'm not all that familiar with JDBC so am not quite sure where to look. Any help would be appreciated.
THANK YOU in advance for your help!
-Eric