1.34 1.34 clean install fails at SQL test (2 Viewers)

[sortie]

Hi,

went from a 1.29 install (working, reinstalled for other reasons) on a fairly fresh and fully updated Windows 10 system for a complete wipe (full MP cleanup through uninstaller) to 1.34 and had the SQL test fail (se attached dump) during TV server installation. Skipped and had the installation finish but of course had the same problem when trying to start TV Server configuration. I have performed quite a few MP installations over almost twenty years but this one is new to me.

I did notice that there has been a change (from MySQL to MariaDB) and tried a new full cleanup + manual delete of leftovers (folders in program + program data usually are not deleted by the uninstaller). Also uninstalled MySQL and MariaDB, deleted leftover folders and ran CCleaner for registry leftovers. Same result.

After a few more attempts, among them installing as administrator, I just searched for the last version using MySQL (1.33), performed a new full cleanup and installed without a problem.

Because of the thorough cleanup procedures I have not got any logs, unfortunately, but the error message clearly states the db for some reason was tested with password YES. Values in the database setup window could be altered but not saved. Everything (host name as well - exactly the same as with previous installations on this system) looked correct until the test fail, though.

I can see that this problem was mentioned in the News/1.34 release thread but nothing about a solution and no, I do not do db work . Edit: x64 version and yes, host name (although correct) was blanked out by me.

Edit #2: Could "using password: YES" be a simple confirmation that the test was performed WITH password (instead of "using password: NO")? This way it actually could have used the correct (MediaPortal) password. Well, something is wrong either way.

Regards,

 

[Vhasst]

Having exactly this issue upon performing a clean install of MediaPortal 1.34 64 bit on a clean Windows 11 install, off to try 1.33

 

[Noise672]

Having exactly this issue upon performing a clean install of MediaPortal 1.34 64 bit on a clean Windows 11 install, off to try 1.33

I had the same install problem with SQL on clean 1.35 x64 installation.
I had the same install problem with SQL on clean 1.34 x64 installation.

Install 1.33 x64 using MySQL, after a new full cleanup and installed without a problem.

Thank you all for your informations

 

[OldMPuser]

I thought this was just me. For me, after many frustrating hours, I found it was the capitalization in the populated password that was wrong. Try "Mediaportal" with a "p" instead of "P".

 

[AberDino]

For me, a clean install of 1.34 x64 TV server only on a fresh Windows 11 Pro device failed because the installation of MySQL in the background never completed, hence no database to connect to. A manual installation of MySQL worked fine, but I didn't know how to prepare MySQL for the TV server database. In the end, I opted for the MariaDB option and the installation completed without any issues. Have since upgraded to 1.35 x64.

 

[desmond]

Hi, I have had the same issue, eg failure of my SQL during insulation on a brand new windows 11 pro pc with never installed media portal before. I "fixed" it by installing version 1.33 then moving to 1.35, both 64 bit.

Thanks

 

[Noise672]

Hi, I have had the same issue, eg failure of my SQL during insulation on a brand new windows 11 pro pc with never installed media portal before. I "fixed" it by installing version 1.33 then moving to 1.35, both 64 bit.

Thanks

Same for me when I was trying to install x64 1.34 and/or 1.35 (MariaDB). So I installed 1.33 (MySQL) and then upgraded to 135.
All is good now.
Thanks

 

[desmond]

Hi again. Ok, seems like i haven't resolved this issue. I thought i had, but the TV server was not installed. The issue is related to the database used for the Tv server. I have tried completely removing MYsql, deleting everything i could find there, and also uninstalling Media portal using a deep clean and deleting everything i can find related to it. This is on a new install of windows 11 pro on a new PC with an AMD 5600G with 16GB ram and an NVME drive.

I tried installing mariadb manually, but don't know how to set it up or what to do. My problem is with the TV server, the install fails to connect to the database. So when i skip that and proceed i cannot run the TV server configuration, as it also cannot connect to the database. The fault message is:

Connection failed. "authorization to host "my computers name" for user "root" using method "mysql_native_password" failed with message "access denied" for user "root@my computer name " (using password: YES).

I know nothing about databases and just want this to work. I have tried installing version 1.33 64 bit and also 1.35. same issues. What should i do. Thanks, des.

 

[desmond]

Windows 11 has performed an update, and now things seem to be working. I will report back if i am still stuck, but now after another reinstall (i also ran the install as admin) i can access the TV serve config without any DB server issues. Thanks.

 

[Pablik]

The MP 1.34 switched MySQL installation version from 5.6 to 8.3. The new version 8.3 is INCOMPATIBLE with the current version of MP. I don't know why there was a jump to the new version.
After some struggling I was finally able to get it work but it requires to switch the MP to higher NET version (tested 4.7.2) and latest MySql.Data.dll connector (9.1.0).
The MariaDB installation seems to be working (tested on W10 in VM).