+/**********************************************************************/

+/* Install.SQL */

+/* Creates a login and makes the user a member of db roles */

+/* */

+/**********************************************************************/

+

+-- Declare variables for database name, username and password

+DECLARE @dbName sysname,

+ @dbUser sysname,

+ @dbPwd nvarchar(max);

+

+-- Set variables for database name, username and password

+SET @dbName = 'PlaceHolderForDb';

+SET @dbUser = 'PlaceHolderForUser';

+SET @dbPwd = 'PlaceHolderForPassword';

+

+DECLARE @cmd nvarchar(max)

+

+-- Create login

+IF( SUSER_SID(@dbUser) is null )

+BEGIN

+ print '-- Creating login '

+ SET @cmd = N'CREATE LOGIN ' + quotename(@dbUser) + N' WITH PASSWORD ='''+ replace(@dbPwd, '''', '''''') + N''''

+ EXEC(@cmd)

+END

+

+-- Create database user and map to login

+-- and add user to the datareader, datawriter, ddladmin and securityadmin roles

+--

+SET @cmd = N'USE ' + quotename(@DBName) + N';

+IF( NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = ''' + replace(@dbUser, '''', '''''') + N'''))

+BEGIN

+ print ''-- Creating user'';

+ CREATE USER ' + quotename(@dbUser) + N' FOR LOGIN ' + quotename(@dbUser) + N';

+ print ''-- Adding user'';

+ EXEC sp_addrolemember ''db_owner'', ''' + replace(@dbUser, '''', '''''') + N''';

+END'

+EXEC(@cmd)

+GO

+USE PlaceHolderForDb$$

+

+DROP PROCEDURE IF EXISTS add_user $$

+

+CREATE PROCEDURE add_user()

+BEGIN

+DECLARE EXIT HANDLER FOR 1044 BEGIN END;

+GRANT ALL PRIVILEGES ON PlaceHolderForDb.* to 'PlaceHolderForUser'@'PlaceHolderForServer' IDENTIFIED BY 'PlaceHolderForPassword';

+FLUSH PRIVILEGES;

+END

+$$

+

+CALL add_user() $$

+

+DROP PROCEDURE IF EXISTS add_user $$

+<msdeploy.iisapp>

+ <iisapp path="phpBB3" />

+

+ <dbmysql path="install/mysql.sql" commandDelimiter="$$" removeCommandDelimiter="true" />

+

+ <dbfullsql path="install/mssql.sql" />

+

+ <setAcl path="phpBB3/cache" setAclAccess="Modify" setAclUser="anonymousAuthenticationUser" />

+ <setAcl path="phpBB3/files" setAclAccess="Modify" setAclUser="anonymousAuthenticationUser" />

+ <setAcl path="phpBB3/store" setAclAccess="Modify" setAclUser="anonymousAuthenticationUser" />

+ <setAcl path="phpBB3/images/avatars/upload" setAclAccess="Modify" setAclUser="anonymousAuthenticationUser" />

+ <setAcl path="phpBB3/config.php" setAclAccess="Modify" setAclUser="anonymousAuthenticationUser" setAclResourceType="File" />

+</msdeploy.iisapp>

+<parameters>

+ <parameter

+ name="AppPath"

+ defaultValue="Default Web Site/phpBB3"

+ tags="iisapp">

+

+ <parameterEntry

+ type="ProviderPath"

+ scope="iisapp"

+ match="phpBB3" />

+ </parameter>

+

+ <parameter

+ name="aclCache"

+ description="Sets the ACL on the cache/ folder"

+ defaultValue="{AppPath}/cache"

+ tags="Hidden">

+

+ <parameterEntry

+ type="ProviderPath"

+ scope="setAcl"

+ match="phpBB3/cache" />

+ </parameter>

+

+ <parameter

+ name="aclFiles"

+ description="Sets the ACL on the files/ folder"

+ defaultValue="{AppPath}/files"

+ tags="Hidden">

+

+ <parameterEntry

+ type="ProviderPath"

+ scope="setAcl"

+ match="phpBB3/files" />

+ </parameter>

+

+ <parameter

+ name="aclStore"

+ description="Sets the ACL on the store/ folder"

+ defaultValue="{AppPath}/store"

+ tags="Hidden">

+

+ <parameterEntry

+ type="ProviderPath"

+ scope="setAcl"

+ match="phpBB3/store" />

+ </parameter>

+

+ <parameter

+ name="aclAvatarUpload"

+ description="Sets the ACL on the avatars/upload/ folder"

+ defaultValue="{AppPath}/images/avatars/upload"

+ tags="Hidden">

+

+ <parameterEntry

+ type="ProviderPath"

+ scope="setAcl"

+ match="phpBB3/images/avatars/upload" />

+ </parameter>

+

+ <parameter

+ name="aclConfig"

+ description="Sets the ACL on the config.php file"

+ defaultValue="{AppPath}/config.php"

+ tags="Hidden">

+

+ <parameterEntry

+ type="ProviderPath"

+ scope="setAcl"

+ match="phpBB3/config.php" />

+ </parameter>

+

+ <parameter

+ name="DatabaseServer"

+ description="Enter the database server"

+ defaultValue=".\SQLExpress"

+ tags="SQL, dbServer" >

+ </parameter>

+

+ <parameter

+ name="DatabaseName"

+ description="Database name for your application."

+ defaultValue="phpbb"

+ tags="SQL, dbName">

+

+ <parameterEntry

+ type="TextFile"

+ scope="install/mssql.sql"

+ match="PlaceHolderForDb" />

+ </parameter>

+

+ <parameter

+ name="DatabaseAdministrator"

+ description="Database server administartor username."

+ defaultValue="sa"

+ tags="SQL, DbAdminUsername" >

+ </parameter>

+

+ <parameter

+ name="DatabaseAdministratorPassword"

+ description="Database server administrator password."

+ tags="Password,SQL,DbAdminPassword">

+ </parameter>

+

+ <parameter

+ name="Database Username"

+ description="Username to access your database."

+ defaultValue="phpbb"

+ tags="SQL, DbUsername">

+

+ <parameterEntry

+ type="TextFile"

+ scope="install/mssql.sql"

+ match="PlaceHolderForUser" />

+ </parameter>

+

+ <parameter

+ name="Database Password"

+ description="Password for your phpBB database. (Must be at least 8 characters, contain at least one lower case letter, one upper case letter and one digit)"

+ tags="New, Password,SQL, DbUserPassword">

+

+ <parameterValidation

+ type = "RegularExpression"

+ validationString = "^.*(?=.{8,})(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).*$" />

+

+ <parameterEntry

+ type="TextFile"

+ scope="install/mssql.sql"

+ match="PlaceHolderForPassword" />

+ </parameter>

+

+ <parameter

+ name="ConnectionString"

+ description="Automatically sets the connection string for the connection request."

+ defaultValue="Server={DatabaseServer};Database={DatabaseName};uid={DatabaseAdministrator};Pwd={DatabaseAdministratorPassword};"

+ tags="Hidden,SQLConnectionString,Validate">

+

+ <parameterEntry

+ type="ProviderPath"

+ scope="dbfullsql"

+ match="install/mssql.sql" />

+ </parameter>

+

+ <parameter

+ name="SQL Database type"

+ description="SQL database type"

+ defaultValue="mssql"

+ tags="SQL,Hidden">

+ </parameter>

+

+ <parameter

+ name="MySQL Database Server"

+ description="Enter the hostname"

+ defaultValue="localhost"

+ tags="MySQL, dbServer">

+

+ <parameterEntry

+ type="TextFile"

+ scope="install/mysql.sql"

+ match="PlaceHolderForServer" />

+ </parameter>

+

+ <parameter

+ name="Application Database Name"

+ description="Database Name for your application."

+ defaultValue="phpbb"

+ tags="MySQL, dbName">

+

+ <parameterEntry

+ type="TextFile"

+ scope="install/mysql.sql"

+ match="PlaceHolderForDb" />

+ </parameter>

+

+ <parameter

+ name="MySQL Database Administrator"

+ description="Database administrator username."

+ defaultValue="root"

+ tags="MySQL, DbAdminUsername" >

+ </parameter>

+

+ <parameter

+ name="MySQL Database Administrator Password"

+ description="Database administrator password."

+ tags="Password,MySQL,DbAdminPassword" >

+ </parameter>

+

+ <parameter

+ name="phpBB Database Username"

+ description="Username to access your phpBB database."

+ defaultValue="phpbb"

+ tags="MySQL, DbUsername">

+

+ <parameterEntry

+ type="TextFile"

+ scope="install/mysql.sql"

+ match="PlaceHolderForUser" />

+ </parameter>

+

+ <parameter

+ name="MySQL Database Password"

+ description="Password for your phpBB database. (Minimum 4 characters)"

+ tags="New, Password,MySQL,DbUserPassword">

+

+ <parameterValidation

+ type = "RegularExpression"

+ validationString = "^.{4,}$" />

+

+ <parameterEntry

+ type="TextFile"

+ scope="install/mysql.sql"

+ match="PlaceHolderForPassword" />

+ </parameter>

+

+ <parameter

+ name="MySQLConnectionString"

+ description="Automatically sets the connection string for the connection request."

+ defaultValue="Server={MySQL Database Server};Database={Application Database Name};uid={MySQL Database Administrator};Pwd={MySQL Database Administrator Password};"

+ tags="Hidden,MySQLConnectionString,Validate">

+

+ <parameterEntry

+ type="ProviderPath"

+ scope="dbmysql"

+ match="install/mysql.sql" />

+ </parameter>

+</parameters>