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