External MySQL Server (MP-Server on virtual machine) (1 Viewer)

[LukasW]

MediaPortal Version: 1.1
MediaPortal Skin: Blue3wide
Windows Version: Windows XP Pro SP3, Win7 Pro
CPU Type: AMD Athlon X2 5050e (2x2,6Ghz, 45W TDP)
HDD: Intel X25-V SSD (40GB) + 2TB Raid5 on Ubuntu 10.04 Server
Memory: 2x1GB DDR2-800
Motherboard: Asus M3A78-EM
Video Card: ATI HD-3200 (Integrated on AMD780G)
Video Card Driver: Catalyst 10.7
Sound Card: Realtek HD Audio (Integrated on AMD780G)
Sound Card AC3: HDMI (ac3 not working on WinXP)
Sound Card Driver: Realtek HD audio driver v2.08
1. TV Card: Technisat Skystar2 PCI
1. TV Card Type: DVB-S
1. TV Card Driver: 4.5.0
2. TV Card: Pinnacle PCTV 400e (USB)
2. TV Card Type: DVB-S
2. TV Card Driver: 1.0.1.3
MPEG2 Video Codec: Cyberlink PDVD9
h.264 Video Codec: Cyberlink PDVD9
Satelite/CableTV Provider: Astra 19.2°E
HTPC Case: Antec Fusion V2 Media Center (silver)
Cooling: Scythe Ninja Mini
Power Supply: Antec 430W
Remote: Logitech Harmony 525
TV: Philips 37PFL7603D (37" FullHD LCD)
TV - HTPC Connection: HDMI


Hello together,
iam just trying to get MP-Server running on a virtual winxp machine on ubuntu linux 10.04, because i do not want 2 servers and i need linux.
I am using a Pinnacle USB-DVB-S Card, a few moments ago recoding works the first time with vmware.

Unfortunately connecting the client (which is native Win7 Pro) does not work, because there is no connection to the mysql database:

Some TCP/IP ports are blocked
3306 (TCP) Mysql Server

TV
Connected to TV-Service
No connection to database
Please check firewall

(messages translated, iam german native)

Iam not wondering about that, as there IS no mysql server on my virtual mp-server machine, but on the linux host (because i thought mysql is more performant if its running natively). The firewall is correct. How do i tell the client to connect to the database on my linux server (different IP)?

 

[LukasW]

What Ports is MP using??

Idea: What ports would i have to forward, if i change the VMs network interface to NAT, so the mp-server gets its own subnet. I could then route the mp ports to the linux host and use that as server.

As far as i could find MP is using TCP 554 for RTSP streaming. Is there a UDP port, too? Cant believe that video streaming is done through a TCP port together with the controlling...

 

[Peter2]

Hi LukasW,

Just out of curiosity: why don't you do it the other way around, that is MP server and linux in vmware?
MySQL indeed uses 3306 TCP

P²

 

[LukasW]

Peter2: Easy. Iam running a 2TB Soft-Raid5 array (3*1TB disks) on my server. With Windows i would need a Raid-Controller for that. In addition iam not very skilled in using windows... (linuxer for 10 years now)

MySQL is no problem, as my server provides that itself. I have to forward the mediaportal ports to my VM. RTSP is no problem (TCP 554). I just dont know which range mediaportal is using for the RTP UDP connections.

 

[LukasW]

Ok,
ive testet so much now, i think it is just not possible to run mysql server externally. Even the mp server needs a local installation, otherwise its not possible to get a stream to the client (tested with native win7).

Does anybody know, how to forward a port in windows? I would need to forward mysql port to my Linux host... or is there a way to do that with VMWare?