Sunday, February 4, 2024

Quickstart: Run SQL Server Linux container images with Docker

Quickstart: install connect docker

Error:

liblber-2.4.so.2 No such file or directory
libcrypto.so.6 No such file or directory

on RHEL8/9 

Investigate:

yum provides \*/libcrypto.so
yum provides \*/liblber-2.4.so 
Solution:

sudo yum install openldap-compat


 

Sunday, February 19, 2023

There was no match for the specified key in the index. (0x80070491)

Problem

using Microsoft.Windows.ApplicationModel.DynamicDependency;
using System;

namespace CsConsoleActivation
{
    class Program
    {
        // Windows App SDK version.
        static uint majorMinorVersion = 0x00010000;
        private static string executablePath;
        private static string executablePathAndIconIndex;

        static void Main(string[] args)
        {
            try
            {
                Bootstrap.Initialize(majorMinorVersion);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
        }
    }
}

This code generates an error, because I've got 
Windows App SDK of version 1.2 on my machine. So, I tried to modify 
majorMinorVersion to 0x00010010 to no avail.

Solution


After several hours of deep diving on the Win. App SDK source code I found out, 
that the field majorMinorVersion is not a binary type, but something different. 
It should have been set to 0x00010002. So, for my 1.2 version of Windows App SDK,
the correct code looks like this: 


using Microsoft.Windows.ApplicationModel.DynamicDependency;
using System;

namespace CsConsoleActivation
{
    class Program
    {
        // Windows App SDK version.
        static uint majorMinorVersion = 0x00010002;
        private static string executablePath;
        private static string executablePathAndIconIndex;

        static void Main(string[] args)
        {
            try
            {
                Bootstrap.Initialize(majorMinorVersion);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
        }
    }
}

Sunday, August 14, 2022

The pip command produces wierd LookupError: unknown encoding: cp65001

Running Python 2.7 is not easy in these modern days. Today I needed to have Conda running on Python 2.7, and I was struggling with this weird error: (xxxxx) C:\Users\name>pip install jupyter notebook Traceback (most recent call last): File "D:\Anaconda3\envs\xxxxx\Scripts\pip-script.py", line 6, in from pip._internal.main import main File "D:\Anaconda3\envs\xxxxx\lib\site-packages\pip\_internal\main.py", line 13, in from pip._internal.cli.autocompletion import autocomplete File "D:\Anaconda3\envs\xxxxx\lib\site-packages\pip\_internal\cli\autocompletion.py", line 11, in from pip._internal.cli.main_parser import create_main_parser File "D:\Anaconda3\envs\xxxxx\lib\site-packages\pip\_internal\cli\main_parser.py", line 7, in from pip._internal.cli import cmdoptions File "D:\Anaconda3\envs\xxxxx\lib\site-packages\pip\_internal\cli\cmdoptions.py", line 31, in from pip._internal.utils.ui import BAR_TYPES File "D:\Anaconda3\envs\xxxxx\lib\site-packages\pip\_internal\utils\ui.py", line 64, in _BaseBar = _select_progress_class(IncrementalBar, Bar) # type: Any File "D:\Anaconda3\envs\xxxxx\lib\site-packages\pip\_internal\utils\ui.py", line 57, in _select_progress_class six.text_type().join(characters).encode(encoding) LookupError: unknown encoding: cp65001

For Windows 10/11 I'm on, the solution is to switch encoding in Python console to UTF-8.

(xxxxx) C:\Users\name>set PYTHONIOENCODING=UTF-8
Then ensure running
pip install jupyter notebook
Instead of
conda install jupyter notebook

Tuesday, July 27, 2021

SIGINT handler in cxx


#include <iostream>
#include <csignal>
#ifdef _WIN32
#include <Windows.h>
#else
#include <unistd.h>
#endif


using namespace std;

void signalHandler( int signum ) {
    cout << "Interrupt signal (" << signum << ") received.\n";

    // cleanup and close up stuff here
    // terminate program

    exit(signum);
}

int main () {
    // register signal SIGINT and signal handler
    signal(SIGINT, signalHandler);

    while(1) {
        cout << "Going to sleep...." << endl;
        sleep(1);
    }

    return 0;
}

Sunday, April 25, 2021

Convert python dictionary to object

Consider having json response from REST service stored internally in dictionary object. Now, following code converts content of the dictionary to instace of class Test.

Keep in mind though it's just simple demonstration. Enhancement in form of data validation might be required!


from collections import namedtuple

class Test:
    def __init__(self, name : str, description : str, float_number : float): 
        self.name, self.descrition, self.float_number  = name, description, float_number

    def __repr__(self) -> str:
        return f"Test class data: name='{self.name}', description='{self.descrition}', number={self.float_number}"

paramDict = dict(name="Name Property Value", description="Description Property Value", float_number=102.0036)

tstInstance = Test(*(namedtuple('x', paramDict.keys())(*paramDict.values())))

print(repr(tstInstance))

Running the code above prints following representation of the object on the std output:

Test class data: name='Name Property Value', description='Description Property Value', number=102.0036

Saturday, March 6, 2021

Create trustore and keystore for local Kafka and Zookeeper on Windows

Scenario:

  1. Needed to use local Zookeeper and Kafka with existing CA certificate as well as existing consumer certificate. 
  2. Hence needed to be able to use specific CN for 127.0.0.1, not a localhost
  3. Modification of windows hosts file not allowed
All samples I found on the net presumed that CA needs to be generated. My use case was different. I was given with CA and client certificate and I needed to use defined certificate chain for authentication.

Used Git Bash i.e. cygwin for this exercise, hence winpty presence on line with openssl command.


 keytool -genkeypair -keyalg RSA -keysize 2048 -alias projenvlocal -dname "CN=projenvlocal" 
    -ext SAN=DNS:projenvlocal,DNS:localhost,IP:127.0.0.1 -validity 3650 -keystore server.keystore.jks 
    -storepass pwd1234 -keypass pwd1234 -deststoretype pkcs12  

 keytool -keystore server.truststore.jks -alias CARoot -import -file projEnvCALocal.crt 
    -storepass pwd1234 -noprompt

 keytool -keystore server.keystore.jks -alias projenvlocal -certreq -file localhost.csr 
    -storepass pwd1234  

 winpty openssl x509 -req -CA projEnvCALocal.crt -CAkey projEnvCALocal.key -in localhost.csr 
    -out localhost-signed.crt -days 3650 -CAcreateserial -extfile sign-cert.cnf 
    -extensions server_cert -passin pass:keypwd  

 keytool -keystore server.keystore.jks -alias CARoot -import -file projEnvCALocal.crt 
    -storepass pwd1234 -noprompt  

 keytool -keystore server.keystore.jks -alias projenvlocal -import -file localhost-signed.crt 
    -storepass pwd1234  

* passwords are just illustrative of full command line

This part below is the main thing for being able to use certificate's CN as user name for Kafka authentication on localhost/127.0.0.1

   -dname "CN=projenvlocal" -ext SAN=DNS:projenvlocal,DNS:localhost,IP:127.0.0.1

Performing of script above create two files, server.trustore.jks and server.keystore.jks .These files need to be used in ssl section of Kafka's server.properties and Zookeeper's zoo.cfg (file names may differ though).

Wednesday, November 4, 2020

The Pylance - Goodbye Kite

Goodbye Kite.

Fast, feature-rich language support for Python in Visual Studio Code

The name Pylance serves as a nod to Monty Python’s Lancelot, who is the first knight to answer the bridge keeper’s questions in the Holy Grail.


(cheers John Cleese et al.)

Expecting Pybrian plugin in the near future :)

The Quntopian has drawn to the close

The Quantopian has been brought to the end but some of their valuable resources have been placed on the github.

[1] Quantopian research 

[2] Community classes 

[3] ... (?)


Saturday, October 3, 2020

Black-Sholes delta


import numpy as np 
from scipy.stats import norm

def delta(flag, s, k, t, r, v): 
  d1 = (np.log(s/k)+(r+v*v/2)*t)/(v*np.sqrt(t)) 
  if flag == “C”:
    return norm.cdf(d1) 
  else: 
    return norm.cdf(-d1) # +signed put delta

Type = ‘C’ # call
S = 97.65 # underlying
K = 100.00 # strike
T = 30/365 # 30 days to expiry (in years)
R = 0.00 # “risk-free” rate
V = 0.12 # 12 vol
delta(Type, S, K, T, R, V)

0.25044822

Type = ‘P’
S = 3000
K = 2900
T = 30/365
R = 0.00
V = 0.20
delta(Type, S, K, T, R, V)

0.27

S = 2950
T = 29/365
delta(Type, S, K, T, R, V)

0.37

Saturday, December 6, 2014

LNK2001: unresolved external symbol __imp__PyObject_IsTrue

Recently I was experiencing following liknking error [1] .
I was checking path VC++ directories settings, upgrading from boost 1.55 to 1.57, still the same issue. After couple of ours, the resolution was so simple, I could not believe I can be so absent minded.

Never try to compile project referencing 32bit of boost, and linking 64bit Python engine.

[1] error LNK2001: unresolved external symbol __imp__PyObject_IsTrue    %PATH%\libboost_python-vc120-mt-gd-1_55.lib(class.obj)