Mediaportal Silent installations

[midiboy]

Dear Mediaportal Dev Team !

I used to include MP in my unattended installation DVD which installed MP silently. Now since RC1 this is a bit harder to do because of the deploy tool and the combination of the TV Plugin together with TV Server in one NSIS installer package.

I figured out most of the things needed for a silent installation for MP, MP TV Server and MySQL database engine out for myself but a few questions remain. Would you be so kind to share that information with me ?

1.

I am installing the MySQL silently using the /quiet /norestart switch (which by the way, gets rid of the MySQL advertisment popup that comes up when using the Deploy tool -> I guess you guys use the /passive switch?)

I then installed the service using this command:

mysqld-nt.exe --install MySQL

and placed the my.ini file that was there after a MySQL installation using the deploy tool in the My SQL Install folder.

is there Anything else I need to do to configure the MySQL database the way MP TV Server needs it ? How can I silently configure the default master password ? Is the database created automatically I guess ?

2.

Is there a way to silently install only the TV Client plugin and not the TV Server ? The /S switch for the NSIS installer will install both and I did not find a way to include only the TV Client Plugin but not the server.


In the future, would it be possible to maybe offer a way to script the deploy tool so that a silent installation would be easier ? eg. provide template answer files and tell the deploy tool to for instance silently install MP, TV Client plugin but no tv server etc.

Also it would be nice if local paths to needed components could be added to those answer files so that for instance the MySQL installation files could be delivered with the deploy package and no internet connectivity would be needed.

Thanks for your help,
Alex

[midiboy]

Hi !

Made some progress on the silent installation thing.

As for question 1, this is what I am doing:

1. Install SQL database silently:

mysql-essential-5.0.45-win32.msi /quiet /norestart

2. copy my.ini from a previous installation to the MySQL install folder:

copy /Y .\my.ini "%PROGRAMFILES%\MySQL\MySQL Server 5.0\"

3. tell MySQL to start the server as a service:

cd "%PROGRAMFILES%\MySQL\MySQL Server 5.0\bin"
mysqld-nt.exe --install MySQL

4. start up the server:

net start mysql

5. Change root password and give it full privileges to connect from external and localhost client:

cd "%PROGRAMFILES%\MySQL\MySQL Server 5.0\bin"
mysql -u root
UPDATE mysql.user SET Password = PASSWORD('mediaportal') WHERE User = 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mediaportal';
FLUSH PRIVILEGES;
exit

6. Restart the server:

net stop mysql
net start mysql

First connection from Mediaportal will now be successful. However, the above is actually not very secure since root access to the MySQL Server is enabled from everywhere. But I believe MP TV Server does the same thing ?


As for question 2:

Steven83 on IRC pointed me to the development wiki: TV-Server Development/NSISinstaller - MediaPortal Wiki Documentation

where the switches can be found !
Thanks !
Alex