public void TC002_ServiceTestConfig()
{
Assert.AreEqual(".\\", UhuruSection.GetSection().Service.BaseDir);
Assert.AreEqual(0, UhuruSection.GetSection().Service.Index);
Assert.AreEqual("198.41.0.4", UhuruSection.GetSection().Service.LocalRoute);
Assert.AreEqual("(local)", UhuruSection.GetSection().Service.MSSql.Host);
Assert.AreEqual("sa", UhuruSection.GetSection().Service.MSSql.User);
Assert.AreEqual(1433, UhuruSection.GetSection().Service.MSSql.Port);
}
public void TC001_TestConfig()
{
if (!File.Exists("uhuruTest.config"))
{
Assert.Fail();
}
Assert.AreEqual("c:\\droplets", UhuruSection.GetSection().DEA.BaseDir);
Assert.AreEqual("iis", UhuruSection.GetSection().DEA.Runtimes["iis"].Name);
Assert.AreEqual("7.0", UhuruSection.GetSection().DEA.Runtimes["iis"].Environment["iisVersion"].Value);
Assert.AreEqual("3.5;4.0", UhuruSection.GetSection().DEA.Runtimes["iis"].Environment["supportedFrameworks"].Value);
Assert.AreEqual("true", UhuruSection.GetSection().DEA.Runtimes["iis"].Debug["simple"].Environment["useCredentials"].Value);
Assert.AreEqual("60000", UhuruSection.GetSection().DEA.Runtimes["iis"].Debug["simple"].Environment["connectionTimeout"].Value);
}
/// <summary>
/// Starts the MS SQL Node using the specified arguments.
/// </summary>
internal void Start()
{
ServiceElement serviceConfig = UhuruSection.GetSection().Service;
Options options = new Options();
options.AvailableStorage = serviceConfig.AvailableStorage;
options.Capacity = serviceConfig.Capacity;
options.BaseDir = serviceConfig.BaseDir;
options.Index = serviceConfig.Index;
options.LocalDB = serviceConfig.LocalDB;
options.MaxDBSize = serviceConfig.MaxDBSize;
options.MaxLengthyQuery = serviceConfig.MaxLengthyQuery;
options.MaxLengthTX = serviceConfig.MaxLengthTX;
options.MigrationNFS = serviceConfig.MigrationNFS;
options.NodeId = serviceConfig.NodeId;
options.Plan = serviceConfig.Plan;
options.Uri = new System.Uri(serviceConfig.MBus);
options.ZInterval = serviceConfig.ZInterval;
options.LocalRoute = serviceConfig.LocalRoute;
options.StatusPort = serviceConfig.StatusPort;
MSSqlOptions sqlServerOptions = new MSSqlOptions();
sqlServerOptions.Host = serviceConfig.MSSql.Host;
sqlServerOptions.User = serviceConfig.MSSql.User;
sqlServerOptions.Port = serviceConfig.MSSql.Port;
sqlServerOptions.Password = serviceConfig.MSSql.Password;
sqlServerOptions.LogicalStorageUnits = serviceConfig.MSSql.LogicalStorageUnits;
sqlServerOptions.InitialDataSize = serviceConfig.MSSql.InitialDataSize;
sqlServerOptions.InitialLogSize = serviceConfig.MSSql.InitialLogSize;
sqlServerOptions.MaxDataSize = serviceConfig.MSSql.MaxDataSize;
sqlServerOptions.MaxLogSize = serviceConfig.MSSql.MaxLogSize;
sqlServerOptions.DataFileGrowth = serviceConfig.MSSql.DataFileGrowth;
sqlServerOptions.LogFileGrowth = serviceConfig.MSSql.LogFileGrowth;
this.node = new Node();
this.node.Start(options, sqlServerOptions);
}
public VCAPComponent()
{
this.VarzLock = new ReaderWriterLockSlim(LockRecursionPolicy.SupportsRecursion);
this.Varz = new Dictionary <string, object>();
this.Discover = new Dictionary <string, object>();
this.ConstructReactor();
this.UUID = Guid.NewGuid().ToString("N");
// Initialize Index from config file
if (this.Index != null)
{
this.UUID = string.Format(CultureInfo.InvariantCulture, "{0}-{1}", this.Index, this.UUID);
}
this.Host = NetworkInterface.GetLocalIPAddress(UhuruSection.GetSection().DEA.LocalRoute);
VCAPReactor.Uri = new Uri(UhuruSection.GetSection().DEA.MessageBus);
// http server port
this.Port = NetworkInterface.GrabEphemeralPort();
this.Authentication = new string[] { Credentials.GenerateCredential(32), Credentials.GenerateCredential(32) };
}
public void CreateDatabaseTest()
{
try
{
Node_Accessor target = new Node_Accessor();
target.mssqlConfig = new MSSqlOptions();
UhuruSection config = UhuruSection.GetSection();
target.mssqlConfig.Host = config.Service.MSSql.Host;
target.mssqlConfig.User = config.Service.MSSql.User;
target.mssqlConfig.Password = config.Service.MSSql.Password;
target.mssqlConfig.Port = config.Service.MSSql.Port;
target.maxLongQuery = config.Service.MaxLengthyQuery;
target.mssqlConfig.LogicalStorageUnits = config.Service.MSSql.LogicalStorageUnits;
target.mssqlConfig.InitialDataSize = config.Service.MSSql.InitialDataSize;
target.mssqlConfig.InitialLogSize = config.Service.MSSql.InitialLogSize;
target.mssqlConfig.MaxDataSize = config.Service.MSSql.MaxDataSize;
target.mssqlConfig.MaxLogSize = config.Service.MSSql.MaxLogSize;
target.mssqlConfig.DataFileGrowth = config.Service.MSSql.DataFileGrowth;
target.mssqlConfig.LogFileGrowth = config.Service.MSSql.LogFileGrowth;
target.connection = target.ConnectMSSql();
ProvisionedService provisionedService = new ProvisionedService();
DateTime now = DateTime.Now;
string decoration = string.Format(
"{0}_{1}_{2}",
now.Hour,
now.Minute,
now.Second);
provisionedService.Name = "CreateDatabaseTest_" + decoration;
provisionedService.User = "******" + decoration;
provisionedService.Password = "******";
provisionedService.Plan = ProvisionedServicePlanType.Free;
//////////////////////////////////////////////////////////////////////////
// create the provisioned service db and user
//////////////////////////////////////////////////////////////////////////
target.CreateDatabase(provisionedService);
Thread.Sleep(500);
//////////////////////////////////////////////////////////////////////////
// assert the existence of the db files
//////////////////////////////////////////////////////////////////////////
string dbScript = target.createDBScript;
Regex fnRegex = new Regex(@"FILENAME = N'(.*)'");
MatchCollection matches = fnRegex.Matches(dbScript);
foreach (Match m in matches)
{
string fileName = m.Value.Substring(m.Value.IndexOf('\'')).Trim(new char[] { '\'' });
Assert.IsTrue(File.Exists(fileName), string.Format("File '{0}' does not exist", fileName));
}
//////////////////////////////////////////////////////////////////////////
// try to connect as the newly created user
//////////////////////////////////////////////////////////////////////////
string sqlTestConnString = string.Format(
CultureInfo.InvariantCulture,
"Data Source={0},{1};User Id={2};Password={3};MultipleActiveResultSets=true;Pooling=false",
target.mssqlConfig.Host,
target.mssqlConfig.Port,
provisionedService.User,
provisionedService.Password);
SqlConnection sqlTest = new SqlConnection(sqlTestConnString);
sqlTest.Open();
//////////////////////////////////////////////////////////////////////////
// try to connect create a table as the newly created user
//////////////////////////////////////////////////////////////////////////
SqlCommand cmdTest = new SqlCommand(
string.Format("CREATE TABLE [{0}].[dbo].[TestTable]([Command] [varchar](100) NULL, [Description] [varchar](50) NULL) ON [DATA]", provisionedService.Name),
sqlTest);
cmdTest.ExecuteNonQuery();
sqlTest.Close();
//////////////////////////////////////////////////////////////////////////
// try to operate on the service db as a different user
//////////////////////////////////////////////////////////////////////////
// connect as sa
sqlTest.ConnectionString = string.Format(
CultureInfo.InvariantCulture,
"Data Source={0},{1};User Id={2};Password={3};MultipleActiveResultSets=true;Pooling=false",
target.mssqlConfig.Host,
target.mssqlConfig.Port,
target.mssqlConfig.User,
target.mssqlConfig.Password);
sqlTest.Open();
string dummyUser = "******" + decoration;
string dummyPwd = "password1234!";
//create a dummy user
string createLoginString = string.Format(@"CREATE LOGIN {0} WITH PASSWORD = '******'", dummyUser, dummyPwd);
cmdTest = new SqlCommand(createLoginString, sqlTest);
cmdTest.ExecuteNonQuery();
sqlTest.Close();
// connect as the dummy user
sqlTest.ConnectionString = string.Format(
CultureInfo.InvariantCulture,
"Data Source={0},{1};User Id={2};Password={3};MultipleActiveResultSets=true;Pooling=false",
target.mssqlConfig.Host,
target.mssqlConfig.Port,
dummyUser,
dummyPwd);
sqlTest.Open();
// try to drop the service db
try
{
cmdTest.CommandText = string.Format("CREATE TABLE [{0}].[dbo].[DummyTable]([Command] [varchar](100) NULL, [Description] [varchar](50) NULL) ON [DATA]", provisionedService.Name);
cmdTest.ExecuteNonQuery();
Assert.Fail("Other users have read/write access to the service db");
}
catch (SqlException sex)
{
}
//////////////////////////////////////////////////////////////////////////
//Remove database
//////////////////////////////////////////////////////////////////////////
ServiceCredentials sc = new ServiceCredentials();
sc.UserName = provisionedService.User;
sc.Password = provisionedService.Password;
sc.Name = provisionedService.Name;
sc.User = provisionedService.User;
target.DeleteDatabase(provisionedService);
//target.Unprovision(provisionedService.Name, new ServiceCredentials[] { sc });
sqlTest.Close();
target.connection.Close();
}
catch (System.Exception ex)
{
Assert.Fail(ex.Message);
}
}
public void KillLongTransactionsTest()
{
Node_Accessor target = new Node_Accessor();
target.mssqlConfig = new MSSqlOptions();
UhuruSection config = UhuruSection.GetSection();
target.mssqlConfig.Host = config.Service.MSSql.Host;
target.mssqlConfig.User = config.Service.MSSql.User;
target.mssqlConfig.Password = config.Service.MSSql.Password;
target.mssqlConfig.Port = config.Service.MSSql.Port;
target.maxLongTx = config.Service.MaxLengthTX;
target.ConnectMSSql();
int queryTime = target.maxLongTx + 5;
string longQuery = string.Format(@" DECLARE @startTime datetime2(0) = GETDATE(); WHILE (GETDATE() < DATEADD(SECOND, {0}, @startTime)) BEGIN WAITFOR DELAY '00:00:02'; END",
queryTime);
DateTime dueQueryCompletion = DateTime.Now.AddSeconds(queryTime);
int INDEX_COMPLETED = 0;
int INDEX_KILLED = 1;
WaitHandle[] events = new WaitHandle[]
{
new ManualResetEvent(false),
new ManualResetEvent(false)
};
ThreadPool.QueueUserWorkItem(new WaitCallback(
(object o) =>
{
SqlConnection testConnection = new SqlConnection(target.ConnectionString);
testConnection.Open();
SqlCommand sqlLongQuery = new SqlCommand(longQuery, testConnection);
try
{
sqlLongQuery.ExecuteNonQuery();
(events[INDEX_COMPLETED] as ManualResetEvent).Set();
}
catch (SqlException)
{
(events[INDEX_KILLED] as ManualResetEvent).Set();
}
}
));
Thread t = new Thread(new ThreadStart(
() =>
{
while (DateTime.Now.CompareTo(dueQueryCompletion) <= 0)
{
target.KillLongTransactions();
Thread.Sleep(100);
}
}
));
t.Start();
int index = ManualResetEvent.WaitAny(events);
if (index == 0)
{
Assert.Fail("Long query completed without being killed");
}
t.Abort();
}