APACHE TOMCAT ON WINDOWS SERVER 2012 PASSWORD

It can be solved combining port filtering with mysql authentication.

Because you make your mysql server connectable from the net, it were really useful if only B were able to connect your database on A. In this case, you don't need any encryption between the servers, although a minor firewalling I considered needed. If something isn't clear, we are here for your next question.Įxtension: As you wrote, the net between A and B can be considered trusted. But actually, these are the main big leaps. These are not really step-by-step instructions, every step needs probably further investigation from you. Start the webapp and test if it can also connect.The the Mysql connectivity on server B to server A with the mysql -host=A -port=3306 -user=.

Test the TCP-level possibility on server B with a telnet A 3306 command.It needs a little bit of java experience, probably you will need to change some xml files somewhere below a WEB-INF of META-INF directory.

APACHE TOMCAT ON WINDOWS SERVER 2012 PASSWORD

Change the configuration of your tomcat web application on server B to use A:3306 with your password in the mysql configuration.Generate a long and secure password for your tomcat user, for example with the pwgen command.If there are any intermediate firewalls/routers/packet filtering, enable the B->A:3306 TCP connections, but only them.Enable the ssl support in your mysql server on server A.Enable the port 3306 in the firewall of your mysql machine, but only for your server B.

Make the mysql server listening on port 3306 in your my.cnf.

Enable the network access in the mysql (both in the host-based auth, and both in the users table).

I suspect if the network between your servers isn't trusted.

Apache tomcat on windows server 2012