![]() |
Consumption Analytics Documentation |
This article explains how to create an Azure SQL database (a SQL Server database hosted on Windows Azure) that can be used with Cloud Cruiser and how to install Cloud Cruiser with that database.
Azure SQL databases are not yet supported with Cloud Cruiser 4.
If you are also installing Cloud Cruiser on an Azure VM, make sure that the VM is configured according to Configuring a Windows Azure VM for Cloud Cruiser. You can verify endpoints in the Windows Azure Management Portal at Virtual Machines > yourVM > Endpoints.
ccdb
.This procedure replaces the one in Installing the Cloud Cruiser application.
C:\Program Files\CloudCruiser
. If you are installing a version prior to 3.2, due to a bug you must choose a directory with no spaces in its path.lib3rd
.\sqljdbc_3.0\enu
under that directory copy the file sqljdbc4.jar
to both of the following directories under the Cloud Cruiser installation: <install_dir>/lib3rd
<install_dir>/apache-tomcat-7.0.54/lib
<install_dir>/apache-tomcat-7.0.54/webapps/ROOT/WEB-INF
/classes
directory, rename the database.properties.sample
file to database.properties
, then open the file in a text editor.Azure (Microsoft driver) SSL
block to match the following, substituting your values for the placeholders in <brackets>
: #### Azure (Microsoft driver) SSL jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc.url=jdbc:sqlserver://<serverName>;database=<dbName>;encrypt=true;hostNameInCertificate=*.database.windows.net jdbc.username=<loginName>@<serverName> jdbc.password=<password> hibernate.dialect=org.hibernate.dialect.SQLServerDialect validation.query=select 1 validation.query.timeout=5
The following example shows the correct block for a database named ccdb
on the server r8lslme0zc.database.windows.net
with a login name of ccadmin
and password myCl0ud$
db
:
#### Azure (Microsoft driver) SSL jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc.url=jdbc:sqlserver://r8lslme0zc.database.windows.net;database=ccdb;encrypt=true;hostNameInCertificate=*.database.windows.net jdbc.username=ccadmin@r8lslme0zc.database.windows.net jdbc.password=myCl0ud$db hibernate.dialect=org.hibernate.dialect.SQLServerDialect validation.query=select 1 validation.query.timeout=5
<install_dir>
.install -u <dbaName>@<serverName> -p <dbaPassword>
.sa
with the same password as the Cloud Cruiser database user, the command would beinstall -u sa@r8lslme0zc.database.windows.net -p myCl0ud$db
.The install script ends with the following message. Though you are unable to create a JDBC data source for your Cloud Cruiser database, the product is able to run successfully.
Creating '<dbName>' data source entry...No driver matches file sqljdbc4.jar
bin
and run the command:ccservice install
This section explains how to fix common problems with this installation scenario.
If the following error appears when you run the install
command:
Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization. The server name is *.database.windows.net, the name in certificate is xxxxxxxx.database.windows.net.
Then in the database.properties
file, update the hostNameInCertificate
value to match the server name in the error message, then relaunch the install command.
If the following error appears when you run ccservice install
:
The specified service already exists. Failed to install serviceFailed installing 'CloudCruiser' service (errorlevel=8)
Then a previous installation was not fully uninstalled. Remove the previously installed service with the command:
sc delete CloudCruiser
(c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP