The VMware vCloud Director needs a MSSQL or an Oracle Database server to run. This article will describe how to install a MSSQL Server Express on RHEL/CentOS for testing and developing purposes.
1. Add the MSSQL server repository for RHEL
wget https://packages.microsoft.com/config/rhel/7/mssql-server.repo -O /etc/yum.repos.d/mssql-server.repo
2. Install the MSSQL Server to your RHEL or CentOS
2. Install Microsoft MSQL server to your RHEL or CentOS
yum install mssql-server –y
3. Run the MSSQL configuration script
/opt/mssql/bin/mssql-conf setup
Select MSSQL Express. Its free and vCloud Director runs fine with it (only test&dev).
If you get this error:
ValueError: unknown locale: UTF-8
Add locales and try again.
export LC_ALL=en_US.UTF-8
export LANG=en_US.UTF-8
source ~/.bash_profile
4. Add the MSSQL tools repository for RHEL
wget https://packages.microsoft.com/config/rhel/7/prod.repo -O /etc/yum.repos.d/prod.repo
5. Install MSSQL tools and unixODBC developer package
yum install -y mssql-tools unixODBC-devel
6. Make the MSSQL command tool (sqlcmd) usable directly in shell
echo ‚export PATH=“$PATH:/opt/mssql-tools/bin“‚ >> ~/.bash_profile
echo ‚export PATH=“$PATH:/opt/mssql-tools/bin“‚ >> ~/.bashrc
source ~/.bashrc
7. Now open port 1433 in the integrated firewall or stop the firewall service (firewalld)
firewall-cmd –zone=public –add-port=1433/tcp –permanent
OR
systemctl stop firewalld
systemctl disable firewalld
8. Connect to your local MSSQL Server using your Credentials
sqlcmd -S 127.0.0.1 -U SA
9. Run the following scripts to create and configure the database. /YOURPATH/ must be owned by the mssql user.
USE [master]
GO
CREATE DATABASE [vcloud]ON PRIMARY
(NAME = N’vcloud‘, FILENAME = N’/YOURPATH/vcloud.mdf‘, SIZE = 100MB, FILEGROWTH = 10% )
LOG ON
(NAME = N’vcdb_log‘, FILENAME = N’/YOURPATH/vcloud.ldf‘, SIZE = 1MB, FILEGROWTH = 10%)
COLLATE Latin1_General_CS_AS
GO
USE [vcloud]
GO
ALTER DATABASE [vcloud] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE [vcloud] SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE [vcloud] SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT;
ALTER DATABASE [vcloud] SET MULTI_USER;
GO
10. Create the Service User for vCloud Director and make him owner of the vCloud Database
USE [vcloud]
GO
CREATE LOGIN [vcloud] WITH PASSWORD = ‚vcloudpass‘, DEFAULT_DATABASE =[vcloud], DEFAULT_LANGUAGE =[us_english], CHECK_POLICY=OFF
GO
CREATE USER [vcloud] for LOGIN [vcloud]
GO
USE [vcloud]
GO
sp_addrolemember [db_owner], [vcloud]
GO
Now you can use this for your vCloud Director. Have fun!