Connecting to MySQL from remote website
Posted: 30. November 2009 09:00
Hello,
With the help of Izzy I got everything locally working with MySQL and the broadcast software.
Now I am having a problem getting our website that is hosted on another server outside the LAN to connect to the server's database.
How the website works is that it pulls the information from the station server, such as, what is playing at the moment, Top 10, if requested, recently played, playlist and requests and a couple of other items for local viewing. The firewall is set to pass the new port set for MySQL and the music request port. These are the only two ports that need to be passed. This was already set up earlier for the server. Everything is the same here except the rebuilt server. Before the new setup I was able to access the database via the work computer on the network, I can not do this anymore.
Mainly, what I need is for the website host to be able to connect to the station database for its constant updates for the page. The last time I set this up was roughly 5 years ago, so I have a bit of a mental block on how we got things to talk to each other.
The below image is to give you an idea how things are setup and the flow of the network.
Thanks
GEE
With the help of Izzy I got everything locally working with MySQL and the broadcast software.
Now I am having a problem getting our website that is hosted on another server outside the LAN to connect to the server's database.
How the website works is that it pulls the information from the station server, such as, what is playing at the moment, Top 10, if requested, recently played, playlist and requests and a couple of other items for local viewing. The firewall is set to pass the new port set for MySQL and the music request port. These are the only two ports that need to be passed. This was already set up earlier for the server. Everything is the same here except the rebuilt server. Before the new setup I was able to access the database via the work computer on the network, I can not do this anymore.
Mainly, what I need is for the website host to be able to connect to the station database for its constant updates for the page. The last time I set this up was roughly 5 years ago, so I have a bit of a mental block on how we got things to talk to each other.
The below image is to give you an idea how things are setup and the flow of the network.
Thanks
GEE