Get this working outside bsa first.
Does this command:
msiexec /i mysql-installer-web-community-22.214.171.124.msi /quiet
install mysql as you want it, from the command line, outside of bsa ?
No, even with command line it just deploys the installer. You need to manually then install MySQL through GUI, go through some steps until you come to install or the execute MySQL server step.
I was wondering how to automate the whole installation steps through BSA. there ain't any Zipkits even for this.
Spend some time researching how to get the silent install to work…
Take advantage of Config file in that case.
You may read point 5-e at: Adding software - BMC Server Automation 8.7 - BMC Documentation
Also, if it was SQL Server installation, you can find the configfile.ini gets generated after selecting the required features, accounts setup, etc. and just when you are about to hit Install. You may get the same in MySQL? If yes, you may simply copy the file and use it for the installations (if no further update is required to it).
1 of 1 people found this helpful
why would you be able to use a config file for SQL Server (a microsoft product) with MySQL - an open source and non-microsoft product ? they are completely different things.
for a product install to work w/ bsa, it needs to run in an unattended or silent mode. most softwares have documented methods of how to accomplish a silent or unattended install on the vendor's website or from googling a bit. the general rule is to get the install working in an unattended fashion outside of bsa and then bring it into bsa.
Bill, I am just giving him an example of configfile usage for SQL Server.
Also, I just suggest him to use the configfile generated (if any) by mysql-installer-web-community-126.96.36.199.msi .
Thanks Bill, headed your approach and it worked. Followed the following steps:
1. Created an empty BLPackage. Added custom command to copy the installer into target.
2. Install MySQL server using the command:
msiexec /i "C:\temp\MySQL\mysql-5.5.53-winx64.msi" /qn
3. Configure MySQL server using the command:
"%ProgramFiles%\MySQL\MySQL Server 5.5\bin\mysqlinstanceconfig.exe" -i -q ServiceName=MySQL RootPassword=mysql ServerType=DEVELOPER DatabaseType=MYISAM Port=3306 Charset=utf8
4. Set the path using the command:
setx PATH "%%Program Files%\MySQL\MySQL Server 5.5\bin%;"