(Solved): Local SQL Server needed ? (MP 1.1) (1 Viewer)

[ritchie]

MediaPortal Version: 1.1.0
MediaPortal Skin: Blue3Skin 4:3
Windows Version: Windows XP MCE SP3
CPU Type: Intel Core2 Duo E8200 2x2.67GHz BOX 6MB
HDD: 2x HD 750GB (Raid 1) / QNAP 419P (2TB)
Memory: 2 X 2048MB Corsair PC2-800 CL4 TWIN2X2048-6400C4
Motherboard: ASUS P5E-VM HDMI G35
Video Card: Intel® Graphics Media Accelerator X3500
Video Card Driver:
Sound Card: Onboard Realtek ALC883 7.1
Sound Card AC3:
Sound Card Driver:
1. TV Card: Hauppauge WinTV Nova-S plus
1. TV Card Type: DVB-S
1. TV Card Driver:
2. TV Card: Terratec Cinergy 2400 i DT
2. TV Card Type: 2xDVB-T
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: ffdshow
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider: Astra 19.2E / Hotbird
HTPC Case: OrigenAE S16T Media Desktop Case black
Cooling: Scythe Zipang Universal CPU Kühler
Power Supply: 550W Seasonic Energy Plus
Remote: OrigenAE RC197
TV: Samsung SyncMaster 275T
TV - HTPC Connection: DVI with HDCP Support

Hi,

I am using a remote SQL server from my NAS (QNAP 419P) and would like to unistall the local
MY SQL server, because there is normally no need for it.

But after I disabled the MySQL service, the TV Server - Service did not work proper.

Is the local installation of MySQL needed ?
Where is my failure ?

Greatings

R.

 

[Spooky]

Re: Local SQL Server needed ? (MP 1.1)

Well, did you configure the TV server to use the new SQL server yet? (You have to start SetupTV.exe with the command line argument -c.)
Also the new server will not have the database yet, unless you transferred the database to the SQL server on your QNAP manually. I'd suggest to make a data export from the tv server, uninstall and reinstall the tv server, with the new SQL server settings and then reimport everything again.

 

[ritchie]

Re: Local SQL Server needed ? (MP 1.1)

Ok, the system is running well with the remote SQL server.
I just let create the database of the QNAP and reinstall the configuration of the system (recan of senders and so one).

But now, the MySQL server on the TVServer Computer is still running and it looks like, that MP needs the local MySQL.
I do not know why, but when I disable the "MySQL service" on the TV-Server, MP does not work anymore.

Where is my failure ?

Greatings R.

 

[Spooky]

Re: Local SQL Server needed ? (MP 1.1)

Also was genau hast du jetzt gemacht? Mach es mal in dieser Reihenfolge:

- TV Server deinstallieren (complete uninstall, also alles löschen und database droppen)
- lokalen MySQL server deinstallieren
- TV Server installieren
- bei der TV Server database configuration den SQL Server auf dem QNAP angeben

 

[ritchie]

Re: Local SQL Server needed ? (MP 1.1)

Also, ich hatte/habe ein lauffähiges System, als erstes!
(First of all, the system is fully functional)


- Die Verbindung zur der MySQL Daten von lokal auf einen entfernten SQL Server umgebogen.
( I changed the connection from the local server to the remote SQL Server, QNAP drive)

- Datenbank musste hierbei neu erstellte werden, da unter Windows keine Grosskleinschreibung verwendet wird,
bei der Erstellung der Datenbank, aber unter Linux das wohl abgefragt wird.
(The database needs to create new, because the naming of the database between a windows MySQL Server and a linux SQL Server is different. (Linux is using low and upper letters, windows only lower case)
- Dann System neu konfiguiert (Sendertabelle und so)
(reconfiguration of the system, like channel configuration and so one)


- Mediaportal läuft jetzt mit einer Datenbank auf dem entfernten SQL Server (Zeitstempel des lokalen ändern sich nicht mehr)
Media portal is running on the remote MySQL Database, because time stamps of the local server did not changed, datas in the remote server are collected correctly)

Idee für schnelle Bootzeit und Resourcengewinn, den lokalen SQL Server deinstallieren.
My idea, no to get a fast system and more memory on the local TV server, by removing the MySQL Server on the TV Server.

- Wenn ich aber jetzt den MySQL Dienst stoppen, kommt eine Meldung (wird vom TV-Server verwendet).
After I disabled the MYSQL service in the system settings, I get a warning message, that the "MySQL Service" is used by the TV-Service.

- MySQL Server Deaktiviert und den Diensten und neu gestartet
(disabling of the MySQL Server service and a reboot of the system)

- TV-Server arbeitet nicht mehr
TV Server did not work anymore

- MySQL Server wieder aktiviert und neu gebootet
MySQL Server enabled and reboot
- TV-Server arbeitet wieder korrekt
TV Server is working correctly

Ich brauche aber doch keine lokale Installation von MySQL, Oder ?
Do I need a local instanze of the My SQL Server on the TV server ?

Gruss R.
Greatings
R.

P.S.: Edit and try to translate for everybody as well

 

[Spooky]

Re: Local SQL Server needed ? (MP 1.1)

Well, I'd still try a clean reinstall. Just export your current settings, before you make a complete uninstall of the TV server, so that you don't have to do everything again afterwards.
Make a complete uninstall of the TV server, then deinstall the local SQL server, and then reinstall the TV server again and configure it to use the remote SQL server.

I also thought, that the TV server doesn't necessarely need a local SQL server.

 

[ritchie]

Hi,

I found the reason for the stopping of the TV-Server, when the MySQL Server was disabled.

The TV-Service has a entry "DependOnService", which was related to "MYSQL".
I removed this setting in the registry and now I could uninstall the local MYSQL Server.

The system is now running well only with the remote SQL Server!

Greatings

R.