Reply to thread

Message

<blockquote data-quote="stevengood" data-source="post: 866332" data-attributes="member: 112766">Hi,&nbsp; I have used MedialPortal before and this is actually a new install because I had problems with my Tuner cards and The TV Server would not see my tuners anymore so I figured uninstall all, then do a fresh install.&nbsp;I have been trying different things as suggested in other forum post but still can't get the past the SQL connection test for the TV Server.&nbsp;1) I have uninstalled Media Portal and deleted any filed directories and app data2) I have uninstalled MySQL and also removed any directories3) I have re-booted the system after the uninstalls4) I did a fresh install of MySQL the latest version (that did not help so I also installed MS SQL Express 2012) that also did not help5) With both the SQL servers installed, I did the fresh install of Medial Portal 1.2.3 and every time I do this, I get to the screen that tests the SQL connection and can't get past the test.&nbsp;This is on a Windows 7 system fully patched.&nbsp;When is says &quot;root&quot; username, do I actually need to create a &quot;root&quot; user account?&nbsp; If so I have not done this, as I did not need it when running medial portal before.&nbsp;The Windows Firewall is set up to allow both the MySQL and MS SQL Express servers.&nbsp;I have tried both the 1 click install (but even though I have MySQL installed, the one click wants to install MySQL but the older version).&nbsp;I just tried again with the 1 click install, and got the pop-up message&nbsp;&quot;MySQL - set password error: 1&quot;after clicking OK on that pop-up this one comes up.&quot;Failed to install application [MySQL 5.1]&quot;&nbsp;Options given for the SQL part are:&nbsp;&nbsp; Microsoft SQL Server Express 2005 is disabled (duh, I have 2012 installed, 2005 is no longer available)&nbsp;&nbsp; MySQL 5 (well last one click install was not able to install this so why try again)&nbsp;&nbsp; SQL sever is already present and will be used for TV server (this is what I checked since I do have MySQL 2012) installed&nbsp;Now when I do the advanced install (Fresh) this happens.&nbsp;OK this is what happens - it says you have successfully completed the installation&nbsp;So now I go and use the TV Server ConfigurationGet the Setup database connection pop-upMy SQL 5 is checked by default so I click testand oh my god I get &quot;Please specify a valid hostanem of IP address for the server&quot; localhost was the defaultI change the hostname to &quot;PVR-PC&quot; the name of my PC and click test and get&nbsp;Connection failed!Access denied for user 'root'@'PVR-PC' (using password: YES)&nbsp;I really love or should I say loved Medial Portal but the SQL part of the install is driving me crazy.&nbsp;Please please please (did I say please) what am I doing wrong.&nbsp;Seriously this SQL issue is about to drive me to drinking or pulling out my hair</blockquote>

[QUOTE="stevengood, post: 866332, member: 112766"] Hi, I have used MedialPortal before and this is actually a new install because I had problems with my Tuner cards and The TV Server would not see my tuners anymore so I figured uninstall all, then do a fresh install. I have been trying different things as suggested in other forum post but still can't get the past the SQL connection test for the TV Server. 1) I have uninstalled Media Portal and deleted any filed directories and app data 2) I have uninstalled MySQL and also removed any directories 3) I have re-booted the system after the uninstalls 4) I did a fresh install of MySQL the latest version (that did not help so I also installed MS SQL Express 2012) that also did not help 5) With both the SQL servers installed, I did the fresh install of Medial Portal 1.2.3 and every time I do this, I get to the screen that tests the SQL connection and can't get past the test. This is on a Windows 7 system fully patched. When is says "root" username, do I actually need to create a "root" user account? If so I have not done this, as I did not need it when running medial portal before. The Windows Firewall is set up to allow both the MySQL and MS SQL Express servers. I have tried both the 1 click install (but even though I have MySQL installed, the one click wants to install MySQL but the older version). I just tried again with the 1 click install, and got the pop-up message "MySQL - set password error: 1" after clicking OK on that pop-up this one comes up. "Failed to install application [MySQL 5.1]" Options given for the SQL part are: Microsoft SQL Server Express 2005 is disabled (duh, I have 2012 installed, 2005 is no longer available) MySQL 5 (well last one click install was not able to install this so why try again) SQL sever is already present and will be used for TV server (this is what I checked since I do have MySQL 2012) installed Now when I do the advanced install (Fresh) this happens. OK this is what happens - it says you have successfully completed the installation So now I go and use the TV Server Configuration Get the Setup database connection pop-up My SQL 5 is checked by default so I click test and oh my god I get "Please specify a valid hostanem of IP address for the server" localhost was the default I change the hostname to "PVR-PC" the name of my PC and click test and get Connection failed! Access denied for user 'root'@'PVR-PC' (using password: YES) I really love or should I say loved Medial Portal but the SQL part of the install is driving me crazy. Please please please (did I say please) what am I doing wrong. Seriously this SQL issue is about to drive me to drinking or pulling out my hair [/QUOTE]

Verification