MP Client can't find the server (1 Viewer)

[kpatch]

Hi:

My client can't find the server. When I look at Windows services, the TV service isn't started. When I try to start the TV service, I get a message that dependency failed. Further investigation shows that the MySQL service won't start. Hmmm.

The Watchdog file is attached.

P

 

[mm1352000]

Hello

Further investigation shows that the MySQL service won't start.

Correct - the Windows application and system event logs confirm that MySQL has been crashing on startup. This is the first instance:
[collapse]"29/03/2016 11:06:43 PM";"Application Error";"Application Crashing Events";"Error";"Faulting application name: mysqld.exe, version: 5.6.10.0, time stamp: 0x510bce27 Faulting module name: mysqld.exe, version: 5.6.10.0, time stamp: 0x510bce27 Exception code: 0xc0000005 Fault offset: 0x0038e1c5 Faulting process id: 0xc20 Faulting application start time: 0x01d18a311d91e08f Faulting application path: D:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe Faulting module path: D:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe Report Id: 6def407e-f624-11e5-b616-000272a71914";"1000"
"29/03/2016 11:06:51 PM";"Windows Error Reporting";"(0)";"Information";"Fault bucket , type 0 Event Name: APPCRASH Response: Not available Cab Id: 0 Problem signature: P1: mysqld.exe P2: 5.6.10.0 P3: 510bce27 P4: mysqld.exe P5: 5.6.10.0 P6: 510bce27 P7: c0000005 P8: 0038e1c5 P9: P10: Attached files: C:\Windows\Temp\WER7B18.tmp.appcompat.txt C:\Windows\Temp\WER8324.tmp.WERInternalMetadata.xml C:\Windows\Temp\WER8335.tmp.hdmp C:\Windows\Temp\WER8690.tmp.mdmp These files may be available here: C:\ProgramData\Microsoft\Windows\WER\ReportQueue\AppCrash_mysqld.exe_cd6030c096bb38f0909f47a87eeb76e2c5e66f24_cab_15498729 Analysis symbol: Rechecking for solution: 0 Report Id: 6def407e-f624-11e5-b616-000272a71914 Report Status: 4";"1001"[/collapse]

I suspect the cause is this:
"29/03/2016 11:05:23 PM";"Microsoft-Windows-Kernel-Power";"(63)";"0";"The system has rebooted without cleanly shutting down first. This error could be caused if the system stopped responding, crashed, or lost power unexpectedly.";"41"

If the MySQL database or configuration has been corrupted, there's probably nothing you can do to fix it short of a complete uninstall and reinstall of MySQL. To fully uninstall:

1. Uninstall MySQL server from Control Panel -> Add/Remove Programs.
2. Delete the C:\Program Files\MySQL or C:\Program Files (x86)\MySQL folder.
3. Delete the C:\ProgramData\MySQL folder.

It's possible other files have been corrupted, and as a result you may experience ongoing problems with any program that was running at the time of the power loss or hard reset.

 

[kpatch]

Thanks mm1352000. As always, your assistance comes through.

As regards MySQL, if I remove the current installation, will the MP installer re-install MySQL for me?

Again, many thanks.

P

 

[mm1352000]

As regards MySQL, if I remove the current installation, will the MP installer re-install MySQL for me?

Yes, the MP installer can reinstall MySQL for you if you reinstall MediaPortal as well.

 

[kpatch]

Thanks. I was able to reinstall MySQL.Unfortunately, with fresh install of MySQL, I'm having to go through all of my configuration.

I am receiving the message "Program/Channel not found". I had this occur a couple of years ago, but for the life of me, I can't remember/figure out the proposed solution.

BTW...would it be useful to set up a MySQL backup. I sure could have used on today.

As always, any assistance would be greatly appreciated.

P

 

[mm1352000]

I am receiving the message "Program/Channel not found". I had this occur a couple of years ago, but for the life of me, I can't remember/figure out the proposed solution.

My guess is that you've created your channels with incorrect input settings.
Currently the input settings seem to be set for s-video and S/PDIF:
[2016-03-31 22:52:43,341] [Log ] [4 ] [DEBUG] - CardReservationBase.RequestCardTuneReservation: placed reservation with id=2, tuningdetails=tv:1605 HISTHDC Freq:0 Channel:1605 Country:Canada Tuner:Cable Video:SvhsInput1 Audio:SPDIFInput1

Is that correct?
If not, you need to reconfigure the SchedulesDirect plugin -> advanced tab -> video/audio source settings according to the info in the first post here:
https://forum.team-mediaportal.com/threads/hauppauge-hd-pvr-colossus-support.94850/

...then delete all your current channels, and restart the TV service to have SD recreate channels with the correct settings.

BTW...would it be useful to set up a MySQL backup. I sure could have used on today.

It's completely up to you. If you think it would be useful, do it.
You could do it with a tool designed for MySQL (ie. generic)...
...or do it on an ad-hoc basis (eg. after you finish setup, then again after you make major changes in future... or maybe just when you remember!) using the import/export section of TV Server Configuration...
...or do it with the TV Server BackUpSettings plugin from huha (I think this can be acquired using the MediaPortal Extension Installer):
https://www.team-mediaportal.com/extensions/system/backupsettings

 

[kpatch]

My guess is that you've created your channels with incorrect input settings.
Currently the input settings seem to be set for s-video and S/PDIF:
[2016-03-31 22:52:43,341] [Log ] [4 ] [DEBUG] - CardReservationBase.RequestCardTuneReservation: placed reservation with id=2, tuningdetails=tv:1605 HISTHDC Freq:0 Channel:1605 Country:Canada Tuner:Cable Video:SvhsInput1 Audio:SPDIFInput1

Video input should be set YxYyP(?). For the life of me I can't find where to make the changes.

Help.

P

 

[mm1352000]

For the life of me I can't find where to make the changes.

As per the instructions in my previous reply:

If not, you need to reconfigure the SchedulesDirect plugin -> advanced tab -> video/audio source settings according to the info in the first post here:
https://forum.team-mediaportal.com/threads/hauppauge-hd-pvr-colossus-support.94850/

...then delete all your current channels, and restart the TV service to have SD recreate channels with the correct settings.

 

[kpatch]

In the words of Homer Simpson, "D'oh!" Anyway, that did the trick. Thanks so much for assistance...and patience.

P