How to identify which database is in use - SQL mr MYSQL? (1 Viewer)

alexeix

Portal Pro
January 28, 2005
199
5
UK
Hi,

I have both SQL and MYSQL installed on my Media Portal server, but I don't know which one is in use by Media Portal.
Is there any way to tell?
Thanks!
 

HTPCSourcer

Retired Team Member
  • Premium Supporter
  • May 16, 2008
    11,418
    2,336
    Home Country
    Germany Germany
    Open a TVServer.log file that shows the startup of the TVServer and look for:
    [2015-06-26 11:53:55,272] [Log ] [TVService] [INFO ] - Controller: Initializing TVServer
    [2015-06-26 11:53:55,272] [Log ] [TVService] [INFO ] - Controller: 1 init attempt
    [2015-06-26 11:53:55,272] [Log ] [PowerEventThread] [DEBUG] - TV service PowerEventThread message loop is running
    [2015-06-26 11:53:55,288] [Log ] [TVService] [INFO ] - C:\ProgramData\Team MediaPortal\MediaPortal TV Server\gentle.config
    [2015-06-26 11:53:55,288] [Log ] [TVService] [INFO ] - Controller: using SQLServer database connection: Password
    [2015-06-26 11:53:55,288] [Log ] [TVService] [INFO ] - Controller: started at SERVER

    In this case MSSQL is used. MYSQL would show "MySQL" instead.

    Alternatively open gentle.config at C:\ProgramData\Team MediaPortal\MediaPortal TV Server and check which <DefaultProvider Name> is uncommented
     

    Users who are viewing this thread

    Similar threads

    Hello, Name need to be the same as computer name. Also, logs could be useful.
    Hello, Name need to be the same as computer name. Also, logs could be useful.
    It is a bit of a long story! I successfully installed MP2 on my old PC as client/server with client on my laptop to confirm my...
    Replies
    2
    Views
    309
    Hi, I didn't have SQL problems but just wanted to agree that on my Win7 system, a clean install of 1.36 TV server x86 does not work since it won't start the TV server configuration. Installing 1.33 first and upgrading to1.36 fixed the problem. Eggert
    Hi, I didn't have SQL problems but just wanted to agree that on my Win7 system, a clean install of 1.36 TV server x86 does not...
    Hi, went from a 1.29 install (working, reinstalled for other reasons) on a fairly fresh and fully updated Windows 10 system for a...
    Replies
    26
    Views
    6K
    I see no reason in Windows XP or 7, in my experience, on ancient Atom, Windows 10 worked faster than XP or 7...
    I see no reason in Windows XP or 7, in my experience, on ancient Atom, Windows 10 worked faster than XP or 7...
    Hi all, I'm new to MediaPortal and looking forward to using it. Just one catch and I apologize if it sounds silly - I want to run...
    Replies
    3
    Views
    313
    Hi, First off: there are some issues with the latest Mediaportal (32bits vs 64bits), so that is one of the issues you're stumbling with. If you take the previous version (1.31) it should work as expected. For IPTV there is also a different option (with different pros and cons): Onlinevideos. I'm using that sometimes for my IPTV as...
    Hi, First off: there are some issues with the latest Mediaportal (32bits vs 64bits), so that is one of the issues you're stumbling...
    Hi I am trying to play a m3u file from my IPTV provider, but when I try to install the TV part of Media Portal v1.3.2 I get an...
    Replies
    1
    Views
    2K
    Ok, so perhaps a solution, but not the "right" solution. On the client, within media portal configuration, under TV settings, advanced options, I switched to UNC paths instead of the default RSS, and it's working very well. Sure I had to figure out the paths, but no big deal. Maybe helpful for someone in the future. Thanks for the...
    Ok, so perhaps a solution, but not the "right" solution. On the client, within media portal configuration, under TV settings...
    Hi folks. I have an issue with a new install/integration into my mediaportal system. I have a “mediaportal server” which has the TV...
    Replies
    5
    Views
    1K
    Top Bottom