Hi there

I have a standalone mysql server and an 'app' server running php/apache. I've set this up according to the instructions set out here: http://library.linode.com/databases/mys ... sql-server

However, since installing a firewall on the mysql server (using exactly the steps shown here: http://library.linode.com/securing-your ... a-firewall) I can no longer access the mysql server from my app server.

Can anyone with iptables knowledge help me out?

Cheers


Jim

Add a rule like this

-A INPUT -s <your app server ip>/32 -p tcp -m tcp --dport 3306 -j ACCEPT 

to your firewall config

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue

Or you could tunnel traffic over an ssh session like this:

ssh -L 3306:localhost:3306 user@your.mysql.server.name

You would run this from the app server, and then set the app to connect to localhost for the database. Keep in mind that you would probably want some automatic way to re-establish the ssh session in case it gets closed.