Docker Containers in Windows Server 2016 Pre Release

SQL server Express Example:

Installation:

1. Download Windows server 2016 ISO image and install inside Virtual Box

2. Install-PackageProvider ContainerImage -Force

Once installed, a list of Base OS images can be returned using Find-ContainerImage.

Find-ContainerImage

Name                           Version          Source           Summary
----                           -------          ------           -------
NanoServer                     10.0.14300.1010  ContainerImag... Container OS Image of Windows Server 2016 Technical...
WindowsServerCore              10.0.14300.1000  ContainerImag... Container OS Image of Windows Server 2016 Technical...

3. Download WindowsServerCore and NanoServer Docker Images

Install-ContainerImage -Name NanoServer

Install-ContainerImage -Name WindowsServerCore

4. Download DockerFile for MS SQL Server Express

wget https://github.com/brogersyh/Dockerfiles-for-windows/archive/master.zip -outfile master.zip

5. Unzip Docker file and build docker image from docker file, this operation would take up to 1 hour.

expand-archive master.zip
cd master\dockerfiles-for-windows-master\sqlexpress
docker build -t sqlexpress .
docker images

6. This example demonstrate running 2 SQL Server Express instances together ruing on ports 1433 and 1434, following command with create firewall exception rules
if (!(Get-NetFirewallRule | where {$_.Name -eq "SQLServer 1433"})) { New-NetFirewallRule -Name "SQL Server 1433" -DisplayName "SQL Server 1433" -Protocol tcp -LocalPort 1433 -Action Allow -Enabled True}

if (!(Get-NetFirewallRule | where {$_.Name -eq "SQLServer 1434"})) { New-NetFirewallRule -Name "SQL Server 1434" -DisplayName "SQL Server 1434" -Protocol tcp -LocalPort 1434 -Action Allow -Enabled True} 

7. Run sqlexpress image on host post 1434 named as sql2

mkdir c:\sql
mkdir c:\sql2 

8. Connect SQL server express from network, this example using SQL Work Bench on a MAC

ESX/ESXi Copy Paste not working, ESXi Isolation issue

I several posts and guides I found that there is an issue that seems to be correct configuration of vmx file do not enable copy paste functionality, I finally figured out the issue.

Requirement

Enable Copy ans Paste between Virtual Machine and remote User Machine, given that VM is hosted on VMware ESX/ESXi server.

Even setting following properties in .vmx file it wont enable copy and paste

isolation.tools.copy.disable = "FALSE"

isolation.tools.paste.disable = "FALSE"

Solution

In most of the websites they do not mentioned case sensitivity requirement, for example ESXi 5.5 must required false in lower case, therefore correct property should be

isolation.tools.copy.disable = "false"

isolation.tools.paste.disable = "false"

Access Vmware ESXi guest console without runing vSphere client

There are several reasons to access remote console/desktop ESXi guest virtual machines without running vSphere client software

1. You do not want keep your ESXi connected to vSphere while accessing a console one, because of security reasons.
2. vSphere do not allow to get full screen console on secondary monitor.
3. Access guest console from vSphere client is not a single step operation, and opens multiple application windows 

Depending on your installation of vSphere client your path may deffer, you can create a shortcut of Guest Console by using following command.

Command

C:\Program Files (x86)\Common Files\VMware\VMware VMRC Plug-in\Internet Explorer>vmware-vmrc -X -u root -p rootPassword -h 10.10.10.22:443 -d "[datastore1] Ubuntu 64-bit/ Ubuntu 64-bit.vmx"

Note:
Replace rootPassword with your Esxi root password, if you do not use -u and -p switch, vmware-vmrc pop up a dialog to input credentials.

Replace 10.10.10.22 with your ESXi server IP address 

MYSQL Enable Users or Root Remote Access Suse Linux 11.3

All you need to do is update the user table host field with % for which ever user you need to grant remote access permission.

Remember that when you remotely try to connect, if there is no connection, means Firewall or network issue, if there is an access dined error mean you need to follow the below demonstration:


TestManager:~ # mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.46-log SUSE MySQL RPM

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql;Database changed
mysql> select host,user from user;
+------------+-----------------+
| host       | user                |
+------------+-----------------+
| %          | root                  |
| %          | super_user     |
| 127.0.0.1  | root             |
| linux-npc5 |                     |
| linux-npc5 | root             |
| localhost  |                      |
| localhost  | asad            |
| localhost  | my_new_username |
| localhost  | root              |
+------------+-----------------+
9 rows in set (0.00 sec)

mysql> update user set host='%' where user='root' and host='linux-npc5';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
(This error came because I have two records for user root, one is correct one is bad, let delte the bad one)
mysql> delete  from user where user='root' and host='linux-npc5';
Query OK, 1 row affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>
========================================================================

Testing from Workbench:

Configuring Juniper Secure Networks SA SSL-VPN

1. Add RADIUS Authentication Server

Start the Juniper Secure Networks Secure Access SSL-VPN Central Manager.

Go to Authentication - Auth. Servers
--> New RADIUS Auth Server
Configure as below

2. Custom Radius Authentication Rules

Note that "Access Challenge” has to be added where the "Reply-Message" "matches the expression" "(.*)" and in that case shows ”show GENERIC LOGIN page”. This will present the OTP field for the user.

When you're done configuring the Authentication Rules they should look like this:

3. Sign in page

Create a Sign-in page

4. User Realm

Create a User Realm that uses the Authentication Server created in step 1 for

authentication.

5. Sign In Policy

Create a Sign In Policy that uses the Sign-in Page from step 2 and the User Realm
from step 3.

Note that from the users’ perspective you can always configure the login-pages for both
graphics and text to suit your company.

6. Start testing

Go to your Juniper url and add that realm you have created. In this example juniper.nordicedge.se/test

Enter the user-id and password for the user that you have added your mobile number to.

Enter your one time password and click on “Sign In”.