Yet Another Unable to Connect Error (1 Viewer)

[Noelix]

MediaPortal Version: 0.2.2.0 SVN 2-14-07
MediaPortal Skin: BlueTwo
Windows Version: Windows 2000 (SP4)
CPU Type: AMD AthlonXP 2200+
HDD: 200GB Seagate
Memory: 384MB
[Video Card: Nvidia Geforce FX 5500 (256 MB)
Video Card Driver: 9.1.3.1
MPEG2 Video Codec: Nvidia Purevideo
MPEG2 Audio Codec: Nvidia Purevideo
Satelite/CableTV Provider: Cox Communications (Basic)

Running the client on Windows 2000.

Running the server on Windows XP (SP2), using MySQL as the database engine for the tv server. I've gone through the wiki a number of times, opened up all the noted ports, tested the RTSP stream in VLC (works), and everything seems to be kosher other than the fact that I get the "Connected to TV Server. Unable to connect to database." Error every time I enter in the IP address in the client application. When I open up MySQL Administrator, I can see both the server computer and the client computer connecting just fine to the database without issue. When I look at the MediaPortal.log file on the client machine, the program appears to connect fine as well (see how it notices how many channels there are?) I've disabled firewalls on both systems and have opened the necessary ports in the router. What more can I do to help this work? Below is my log file link.

http://pastebin.team-mediaportal.com/12028

 

[frippe75]

Well I have the same problem. Not searched extensively on the forum yet but this thread matches my problem. The only difference is that I have one fully working network based tv client. No i've installed media portal on my laptop and it's NOT working.

Get connected to TVserver but not the Database. As the previous entry I do see the connection in MYSQL manager.

I have attached a ethereal trace which looks ok database whise.

TV client 192.168.0.159
TV server 192.168.0.4

Mysql standard port 3306

To get the stream between set tcp.port == 3306 as a filter
The X11 protocol is the vnc connection which can be removed.
And yes there probably are some cleartext passwords in my traces but who cares didnt have the time to have them removed.

 

[scythelt]

I'm seeing the above issue as well - also running mysql.

I haven't had a chance to troubleshoot too much since I only just got the server setup last night. But I can connect to Mysql remotely from my laptop via Mysql Administrator, so the remote access to root option is working fine.

If this is a bug in the latest svn's I'll save my time debugging... if not... anybody have a solution?

 

[Noelix]

scythelt: If you can post the tv server log up here as well it will help to get this asserted as an actual bug. The more people that speak up about it the more likely it is to get fixed Thanks

 

[scythelt]

No problemo, the log is attached.

Scanning through it looks to me that the client keeps on trying to connect via sqlserver despite the tvserver being set to use mysql.

Is there anywhere in the client configuration to force it to use one or the other?

 

[scythelt]

Update - changed the default db provider in gentle.config from sqlserver to mysql and now it connects!

I'm having issues with stability of the stream, but that's a different story entirely...

 

[frippe75]

Update - changed the default db provider in gentle.config from sqlserver to mysql and now it connects!

I'm having issues with stability of the stream, but that's a different story entirely...

This is not my issue. Mysql configured on server. client tries 3306 port (mysql)

ANY SUGGESTIONS???

 

[Noelix]

frippe75: My client tries MySQL as well, here's my gentle.config:
http://pastebin.team-mediaportal.com/12044

Is that similar to yours?

 

[scythelt]

ANY SUGGESTIONS???

Checked your firewall?

 

[Noelix]

Yup its off. I can see it connecting with the MySQL Administrator. I can see in the MP log it receiving the channels. I don't know whats up.