SQL Databases (1 Viewer)

[HudsonHawk04]

MediaPortal Version: 1.1.2.0
MediaPortal Skin: Maya
Windows Version: Windows 7 Ultimate 32bit
CPU Type: Intel Pentium 4 3.0 ghz
HDD: 233gb
Memory: 3gb ram
Motherboard: Dell
Video Card: ATI raideon HD 4300/4500 series
Video Card Driver: 8.753.0.0
Sound Card: Onboard Audio
Sound Card AC3:
Sound Card Driver:
1. TV Card: Hauppauge 1600
1. TV Card Type: analog
1. TV Card Driver:
2. TV Card: ati tv wonder 650
2. TV Card Type: analog
2. TV Card Driver:
3. TV Card: HD Home Run
3. TV Card Type: atsc
3. TV Card Driver:
4. TV Card: HD Homerun
4. TV Card Type: atsc
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider: Time Warner
HTPC Case: Dell Optiplex 620
Cooling:
Power Supply:
Remote: Mediagate GP-IR02BK
TV: Vizio
TV - HTPC Connection: DVI


Long story short I am running Media-Portal and XBMC, I attempted to create a database for my media and my xbmc hubs on my Media-Portal rig and failed. I was able to create a DB on the machine where my media is stored. However now Media-Portal is quirky, I thought I had my Media-Portal pointed to the SQL server but that does not appear to be the case. Is it possible for me to have the databases need for Media-portal accessed remotely? As it stands right now I cannot get the TV Server up and running it errors off with a 1068 error and Mysql501 gives error 1067, SQL gives error 2. Thanks for any help you can provide, if more information is needed it will be provided.

Just looked at sql server, and I am seeing MPTVDB listed. Still kind of at a loss though.

 

[mbuzina]

How about some logs??

I guess you will not get a lot of support with such a question.

 

[HudsonHawk04]

Sorry for the delay in the logs.

 

[mm1352000]

Hi again HudsonHawk04

I may not have understood what you want to do correctly, so please ignore me in advance if none of this makes sense.

1. Your TV Server has been using the following DB setting: Server=Bob-PC;Database=MpTvDb;User ID=root;.

2. Yes, you should be able to configure TV Server with a DB on a remote machine, although I'd imagine most users would probably host the DB on the same machine. You'd just have to configure the DB parameters correctly when you first install TV Server, ensuring that:

- there are no firewalls blocking TV Server's outbound access to the network
- there are no firewalls blocking TV Server's inbound access to the DB host machine SQL Server port
- you give the remote access privileges on the intended TV Server DB/schema to the SQL Server account that TV Server is to use (this is a MySQL concept, but I'm pretty sure it would apply to SQL Server too)

 

[HudsonHawk04]

If I did a clean install on the dedicated mediaportal machine and left the xbmc database alone on a separate machine, would that solve my problem?

 

[mm1352000]

If I did a clean install on the dedicated mediaportal machine and left the xbmc database alone on a separate machine, would that solve my problem?

Probably, but seems a bit heavy handed. I'm still not sure that I understand what you're trying to do. I think you're saying that you wanted to set up an XBMC database within the same SQL server that was hosting your MediaPortal database - is that correct? From what I saw in your logs you were using SQL Server for your TV Server DB. Where does MySQL come into this (you mentioned the MySQL error)?

FYI, if you interpret the error codes as SQL Server errors:
- error 1067 is a general error meaning that a service has failed to start
- error 2 is a connection failure type error

Have you looked at the system event log to see the full error?