Convert SSL certificate to PFX using OpenSSL

Posted on December 12, 2020 by osco.se

If you want to create a password protected PFX file from certificate file and a private key you can use OpenSSL. Follow these steps to create a PFX file.

1. Download the SSL/TLS tookit from https://www.openssl.org.
2. Run this command in a terminal window:
“{PATH}\openssl.exe” pkcs12 -export -out “{PATH}\{filename-of-pfx}.pfx” -inkey “{PATH}{filename-of-key}.key” -in “{PATH}{filename-of-certificate}.crt” -certfile {PATH}{filename-of-ca-bundle}.crt
3. Choose a password for the pfx file.
4. Done, the pfx file is now created at specified path.

.NET MVC – Illegal characters in path

Posted on May 5, 2020 by osco.se

Scenario
Render a ASP.NET MVC Razor view with a model from the controller.

Error / Exception
System.ArgumentException: Illegal characters in path.

Cause
The model from the controller was returning JSON and the view had declared “@model string” to handle the JSON.

Solution
Updates in both controller and view. Change controller return type from string to the object.

Controller
Original: return View(JsonConvert.SerializeObject(List));
Change to: return View(List);

View
Original: @model string
Change to: @model List<object>

Error when reading from PFX certificate SSL/TLS

Posted on March 27, 2020 by osco.se

Case
Establish a secure connection to a server. Authentication with certificate.

Error message
The request was aborted: Could not create SSL/TLS secure channel.

Start Microsoft Management Console, either from control panel or by run command “mmc”.
In MMC select File > Add/Remove Snap-In (Ctrl+M).
Select Certificates > Add > OK. In next window select Local Computer.
When Certificates is added select Certificates > Personal > Certificates.
You can see all the installed certificates in the window to the right. In order to add a permission right-click on a certificate and select All Tasks > Manage Private Keys.
Search for user IIS_IUSRS (IIS User) and then add the user. You can configure the permissions like full control, read etc.
when the user is added.

Problems connecting to WCF service

Posted on November 7, 2019 by osco.se

Trying to connect to a WCF-service but get some error messages:

The HTTP request is unauthorized with client authentication scheme Anonymous The authentication header received from the server was Basic

The provided URI scheme https is invalid expected http

The solution was to adjust web.config > system.serviceModel section. Add “Transport” to security mode. and clientCredentialType should be “Basic” if the server expects Basic Realm.

  <system.serviceModel>
    <bindings>
      <basicHttpBinding>
        <binding name="Document_Binding" closeTimeout="01:00:00" openTimeout="01:00:00" receiveTimeout="01:00:00" sendTimeout="01:00:00" maxReceivedMessageSize="2147483647">
          <security mode="Transport">
            <transport clientCredentialType="Basic" />
          </security>
        </binding>
      </basicHttpBinding>
    </bindings>
    <client>
    <endpoint ....../>
    </client>
  </system.serviceModel>

Good luck with your connections =)

Unable to connect to SQL DB via SSMS on Azure VM

Posted on May 11, 2019 by osco.se

I’ve installed SQL Server 2016 Express on a Azure Virtual Machine (VM). I opened the ports (port 1433) to connect to the server via Sql Server Management Studio (SSMS) but access was denied. I also opened the port inside the Azure portal on the server but still no success.
Then I came over a solution to the connection problem. You need to set the port number on IPAll among IP Addresses inside TCP/IP in Sql Server Configuration Manager. See screenshot below.

How to navigate to the TCP Port setting:

Open Sql Server Configuration Manager.
Click on “Protocols” for “{INSTANCE NAME}” under Sql Server Network Configuration.
Double click on TCP/IP.
Click on tab “IP Addresses”.
Scroll to the bottom and write the port number (1433 is default).

Good luck!

Visual studio 2019 – Launch

Posted on April 3, 2019 by osco.se

Now is VS 2019 available from Microsoft.
https://visualstudio.microsoft.com/vs2019-launch/

Copy files using a runtime created batch file C#

Posted on November 14, 2018 by osco.se

If you would like to copy one or several files using a batch file. The command for that is “copy {target} {destination}”. It’s also possible to use wildcards i.e “copy *.txt c:\temp”.
To create a bat (batch) file on runtime and then execute the file you could write something like this in C#.

string batchFileName = @"C:\{filePath}\copy.bat"; System.IO.File.WriteAllText(batFileName, @"copy {fileName}.{extension} {destination-filePath}"); System.Diagnostics.Process.Start(batFileName);

Posted on May 29, 2018 by osco.se

I have a table in Microsoft SQL Server where insert or updates isn’t possible. Table is only responsible to increment a unique id.

The table looks like this:

CREATE TABLE [dbo].[CustomerOrderNumbers](
[customerOrderNumberId] [int] IDENTITY(1,1) NOT NULL,
[createdOn] [datetime] NOT NULL,
[isDeleted] [bit] NOT NULL,
PRIMARY KEY CLUSTERED
(
[customerOrderNumberId] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CustomerOrderNumbers] ADD DEFAULT (getdate()) FOR [createdOn]
GO

ALTER TABLE [dbo].[CustomerOrderNumbers] ADD DEFAULT ((0)) FOR [isDeleted]

But how do you increase the primary key when you can’t insert any values?

Answer, insert default value:
INSERT INTO [CustomerOrderNumbers] DEFAULT VALUES

This command also works with Azure SQL database.

Cordova build APK – Package damaged

Posted on May 8, 2018 by osco.se

I tried to build an APK (Android) in Cordova, build is successful so far so good!
When transferring the file to my mobile I got error message during install “Installation is not possible, package is damaged”. I created a new Cordova project and compared my “config.xml” file with the one in the project that failed. Found out that the “android-versionCode” is causing the problem. This is specified in the top of the config.xml. Remove that and the install is successful!

Use only Swedish servers in tor browser

Posted on January 13, 2018 by osco.se

If you want to use only Swedish servers in Tor browser (or any other country) to connect on you can do it like this:
1. Open the file “torrc” at “Tor Browser\Browser\TorBrowser\Data\Tor\”.

2. Add line “ExitNodes {countryCode}”.
You can use country code se for swedish, gb or us for english and so on) at end of the file.
3. Save the file and restart the browser.

Osco.se

A notebook
Is also seen at MSDN

Author Archives: osco.se