Reply to thread

Message

<blockquote data-quote="steveperthau" data-source="post: 472809" data-attributes="member: 55181">I'm surprised that there is no sticky for SQL related installation FAQ? After all its pretty much a integral part of mediaportal.That aside, i just noticed that Comodo (v3.9.95478.509) Lists:mysqld-nt.exe listening to TCP port 3306TvService.exe listening to TCP port 31456 &amp; 554So, from what i understand tvservice and mysql need to talk to each other, i get that.But what i don't understand is why there appears to be no bytes in or out to any of these ports (according to comodo's &quot;active Connections&quot;). If there is no 'reported' communication between these two why have the ports open?Also why is TvService.exe listening to TCP ports 31456 &amp; 554 ?I've been tightening my firewall security (shutting down ports 137-139, 445 etc). So this begs the question, how safe is MySql ? Is there any specific things to do to make sql safe..ie firewall settings /configuration etc.This is probably a noob question and my apologies if there is a thread on this already.ps. Great job with MP 1.0 guys, i love it.SteveTV-Server Version: MediaPortal Version: 1.0.1MediaPortal Skin: Blue WideWindows Version: XP SP3CPU Type: AMD x2 4400+HDD: Samsung 500GBMemory: 2GB corsairMotherboard: Gigabyte GA-78GM-S2H V1.0Video Card: ONBOARD ATI RADEON HD 3200Video Card Driver: Catalyst CC 2008.1201Sound Card: Onboard1. TV Card: Avermedia 777 (16ar)1. TV Card Type: dvb-tHTPC Case: sonata 3Remote: usb generic HIDTV: PanasonicTV - HTPC Connection: HDMI</blockquote>

[QUOTE="steveperthau, post: 472809, member: 55181"] I'm surprised that there is no sticky for SQL related installation FAQ? After all its pretty much a integral part of mediaportal. That aside, i just noticed that Comodo (v3.9.95478.509) Lists: mysqld-nt.exe listening to TCP port 3306 TvService.exe listening to TCP port 31456 & 554 So, from what i understand tvservice and mysql need to talk to each other, i get that. But what i don't understand is why there appears to be no bytes in or out to any of these ports (according to comodo's "active Connections"). If there is no 'reported' communication between these two why have the ports open? Also why is TvService.exe listening to TCP ports 31456 & 554 ? I've been tightening my firewall security (shutting down ports 137-139, 445 etc). So this begs the question, how safe is MySql ? Is there any specific things to do to make sql safe..ie firewall settings /configuration etc. This is probably a noob question and my apologies if there is a thread on this already. ps. Great job with MP 1.0 guys, i love it. Steve [b]TV-Server Version[/b]: [b]MediaPortal Version[/b]: 1.0.1 [b]MediaPortal Skin[/b]: Blue Wide [b]Windows Version[/b]: XP SP3 [b]CPU Type[/b]: AMD x2 4400+ [b]HDD[/b]: Samsung 500GB [b]Memory[/b]: 2GB corsair [b]Motherboard[/b]: Gigabyte GA-78GM-S2H V1.0 [b]Video Card[/b]: ONBOARD ATI RADEON HD 3200 [b]Video Card Driver[/b]: Catalyst CC 2008.1201 [b]Sound Card[/b]: Onboard [b]1. TV Card[/b]: Avermedia 777 (16ar) [b]1. TV Card Type[/b]: dvb-t [b]HTPC Case[/b]: sonata 3 [b]Remote[/b]: usb generic HID [b]TV[/b]: Panasonic [b]TV - HTPC Connection[/b]: HDMI [/QUOTE]

Verification