1.4.0pre from nothing (1 Viewer)

[SpudR]

S0 I was having some interesting issues with the install so I thought I'd go for a complete removal and re-install.
I'm having problems getting the above version on.
Firstly the installer gets stuck installing mySQL with a password set error - that's when the 'fun' begins
After this it fails to install the TV server and client
Re-running the installer seems to get stuck at this point again (presumably because there is a password error on the DB?)

Anyone got any tips on how to get past this?

 

[CyberSimian]

Firstly the installer gets stuck installing mySQL with a password set error

When I tried to upgrade from 1.9.0 pre to 1.12.0 final, I had an error with the SQL installation. After several attempts, the solution that worked for me was to deselect the installation or upgrading of SQL during the installation of MP.

It seems to me that SQL is a "once only" installation. Once installed, you can never ever get rid of it or upgrade it, so you are stuck with whatever SQL you have at the moment.

If you want to install different SQL software, I would suggest re-formatting your C: drive, and re-installing Windows from your Windows DVD.

-- from CyberSimian in the UK

 

[mm1352000]

Re-running the installer seems to get stuck at this point again (presumably because there is a password error on the DB?)

My understanding is that in order to update MySQL, the installer needs to know the root user password for your database. If you don't use the default root user password ("MediaPortal") then the installer will run into the "set password" error you're seeing.

Anyone got any tips on how to get past this?

You have several options:
1. Temporarily change the MySQL root user password to MediaPortal, run the MP installer (which should now succeed), then change the password back to what it was before.
2. Deselect install/update of MySQL in the MP installation as CyberSimian suggested. I presume he's referring to this option. If you want, you can later update MySQL manually with an installer/updater from MySQL.
3. Uninstall and completely remove all traces of MySQL before running the MP installer. The process is described in the wiki.

It seems to me that SQL is a "once only" installation. Once installed, you can never ever get rid of it or upgrade it, so you are stuck with whatever SQL you have at the moment.

This isn't true. You always have the option of updating using the installer/updater from Oracle (MySQL) or Microsoft (SQL Server). In fact in my opinion it would be far better to use the Oracle/Microsoft installer. MediaPortal's installer can sometimes do some things on your behalf, but ultimately the database engine is a separate application in its own right... and in my opinion it should be treated as such.

If you want to install different SQL software, I would suggest re-formatting your C: drive, and re-installing Windows from your Windows DVD.

In my opinion that's serious overkill.
The database engine is just another piece of software. Therefore you can remove it using the Windows add/remove programs function and/or it's own installer. There's no need to go nuclear and blitz Windows over something like this.

 

[SpudR]

I would suggest re-formatting your C: drive, and re-installing Windows from your Windows DVD

Nuclear option We like this - lol
I uninstalled the entire mySQL version completely, and rebooted - this is technically a new installation, so it really should be failing at this point at all..?
there is no password to change on any installation 'cos it's simply not there anymore. Hence the confusion as to why this should be.

 

[mm1352000]

Did you also delete the data and config folders as instructed in the wiki page that I linked?
If not, you haven't done enough. The stuff that gets left behind is enough to cause this.

 

[SpudR]

Thanks mm, I can't see the link to the wiki page, but I have done a complete system search and removed anything to do with mysql.
It still doesn't install.
I'll try one of the installers...

 

[mm1352000]

Thanks mm, I can't see the link to the wiki page, but I have done a complete system search and removed anything to do with mysql.

Here:
http://wiki.team-mediaportal.com/1_...ult_root_MySQL_password_was_the_original_one)

Make sure to follow the part:

It is NOT enough to remove MySQL from Add/Remove Programs in the Windows Control Panel. Steps for a complete uninstall are...

 

[SpudR]

Yeah that might have been the issue - but in my defense, I did manually remove all the folders the system could find and manually searched the registry for leftovers and removed those too.
Looks like there is an issue with the DVDArt plugin - I think it requires a specific version of something. No other errors yet though...

 

[SpudR]

Just to add to this = I removed the mySQL 5.7 version like this:
Admin command prompt (

• net stop mysql
• sc delete mysql
• exit

Manually delete

• C:\program files\mysql\[server folder]
• C:\programdata\mysql\[server folder]

REBOOT < This is VERY important!

Run the deploy tool again
Download only
Grab the components
Run the mySQL installer
Admin command prompt

• cd\
• cd program files\mysql\mysql server 5.6\bin
• mysqld --install (if you get a warning about time stamps - do it again until you get a 'succeeded' message)
• net start mysql

5.6 is now installed and running
Run mySQL workbench (install it if it's not installed)
Add a connection (empty password)
open a conenction to the server
create a new user with these details

• User name - root
• host - [your computer name]
• password - MediaPortal
• User role - DBA

#TIP#
You can get your PC name by entering 'hostname' (without the quotes) in to a command prompt.

Run the TV server setup thing and the connect to the database app starts - pressing 'test' should make it all go green.
You can then change what is required (if anything) using the mySQL Workbench.

Now I've just got an issue writing to the music DB (not mysql)

Thanks for the help guys!