I am quite new to the world of pi and would like to know if the following is possible. I have a r-pi which runs a php based web interface for monitoring machines on the network.
Network 1: Linux Machines SQL Databases No Internet Access LAN Connection
Network 2: Wifi Connection, Internet, Users
What i need to do is have the pi run all my scripts over network 1 (ports 22, 3306, 3307 - Sql & ssh) and then use network 2 to send out mails via php mailer also network 2 is where my users connect to the pi to view the statusses of these machines and run sql queries from the site hosted on the pi.
Is this in anyway possibl;e?