DEV Community: jsguru

List users in SQL Server database

jsguru — Sun, 23 Feb 2020 19:12:35 +0000

The image below shows how. (on Microsoft SQL Server Management Studio).

Query

use [database_name]
select name as username,
       create_date,
       modify_date,
       type_desc as type,
       authentication_type_desc as authentication_type
from sys.database_principals
where type not in ('A', 'G', 'R', 'X')
      and sid is not null
      and name != 'guest'
order by username;

I could not access newly created web application in SharePoint Central Administration.

jsguru — Fri, 21 Feb 2020 19:51:21 +0000

"I could not access newly created web application in SharePoint Central Administration."

It was the problem that bothered me today.

After strenuous efforts, I resolved it.

I installed SharePoint Server 2019 on Windows Server 2019 in VMware Workstation 15 Pro.
Then I created a new web application using default settings.

Web application jsguru.group.com:29457 was created. See screenshot below.

So far so good.
But when I tried to access the web application in VM machine I had worked on, I could not.

Let me show you how I resolved it.

Step 1. Add the web application name (here jsguru.group.com) to the string value of BackConnectionHostNames under
windows registry HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0.
If there is no entry BackConnectionHostNames, you have to create it as multi-string value.

Alternatively, create DWORD-value entry DisableLoopbackCheck with value 1 under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa.(This is not recommended)

Step 2. Add the IP address and host name of the web application to the bottom of the hosts file. The hosts file path is C:\Windows\System32\drivers\etc

Thus I could get access to the web application.

I hope this helps someone who is trying to do the same thing like me.

How to Setup Python Virtual Environment for Python3 on Ubuntu 19.10

jsguru — Mon, 03 Feb 2020 08:45:14 +0000

If your OS is Ubuntu 19.10, you don't need to install python3 separately.
Because Ubuntu comes with Python3.
You can check it by typing:
$ python3 --version

jsguru@ubuntu:~$ python3 --version
Python 3.7.5

Then, the first step is to install pip for Python3
$ sudo apt-get install python3-pip

Working on a python project in an isolated python environment is recommended so that python modules and packages don't meddle with that of other projects or even that of the operating system. Thus, a virtual environment is needed eminently.

We can achieve it with virtualenv or virtualenvwrapper.
virtualenvwrapper is better choice than virtualenv.
Creating and deleting virtual environments is easy with virtualenvwrapper.

For installation it run:
$ sudo pip3 install virtualenvwrapper

And
$ mkdir ~/Envs

After running the commands above, open the .bashrc file via gedit or any other tool you prefer.

$ gedit ~/.bashrc

And add below lines at the end of .bashrc file.

WORKON_HOME=~/Envs
VIRTUALENVWRAPPER_PYTHON=/usr/bin/python3
. /usr/local/bin/virtualenvwrapper.sh

You can now use mkvirtualenv, rmvirtualenv and workon commands to create, remove and list virtual environments.

Create a new virtualenv
$ mkvirtualenv myproject

jsguru@ubuntu:~$ mkvirtualenv myproject
Using base prefix '/usr'
New python executable in /home/jsguru/Envs/myproject/bin/python3
Also creating executable in /home/jsguru/Envs/myproject/bin/python
Installing setuptools, pip, wheel...
done.
virtualenvwrapper.user_scripts creating /home/jsguru/Envs/myproject/bin/predeactivate
virtualenvwrapper.user_scripts creating /home/jsguru/Envs/myproject/bin/postdeactivate
virtualenvwrapper.user_scripts creating /home/jsguru/Envs/myproject/bin/preactivate
virtualenvwrapper.user_scripts creating /home/jsguru/Envs/myproject/bin/postactivate
virtualenvwrapper.user_scripts creating /home/jsguru/Envs/myproject/bin/get_env_details
(myproject) jsguru@ubuntu:~$

Load or switch between virtualenvs
$ workon myanotherproject

(myproject) jsguru@ubuntu:~$ workon
myanotherproject
myproject
(myproject) jsguru@ubuntu:~$ workon myanotherproject
(myanotherproject) jsguru@ubuntu:~$

Deactivate a virtualenv
$ deactivate

(myanotherproject) jsguru@ubuntu:~$ deactivate
jsguru@ubuntu:~$

Remove a virtualenv
$ rmvirtualenv myanotherproject

jsguru@ubuntu:~$ workon
myanotherproject
myproject
jsguru@ubuntu:~$ rmvirtualenv myanotherproject
Removing myanotherproject...
jsguru@ubuntu:~$ workon
myproject
jsguru@ubuntu:~$

Programmatically determine OS is up to date or outdated on windows or mac osx .

jsguru — Fri, 31 Jan 2020 10:38:19 +0000

Recently I have developed Software for Windows and Mac osx.
Here I needed to determine my os is up to date or outdated programmatically.

For windows version, programming language is C# and for mac osx version, swift is used.

I could implement the function in C# because there are C# code snippet related my purpose over internet.

But unfortunately, no luck for Mac osx and swift.
There are too much articles to get Mac osx or iOS version.
They was not my concerns.

Below is C# implementation for windows version.

bool CheckIsOSUpdated()
{
    IUpdateSession updateSession = new UpdateSession();
    IUpdateSearcher searcher;
    searcher = updateSession.CreateUpdateSearcher();
    ISearchResult updates = searcher.Search("IsInstalled=0 and Type='Software' and IsHidden=0");
    //ISearchResult updates = searcher.Search("IsInstalled=0");
    if (updates.Updates.Count == 0)
        return true;
    else
        return false;
}

Then the implementation in swift for Mac osx version is

import SwiftShell

func getIsOSXUpdate() -> Bool {
    // softwareupdate --list|tee
    // let command = runAsync("softwareupdate", "--list").stdout.runAsync("tee")
    let command = runAsync("softwareupdate", "--list")
    do {
        try command.finish()
    } catch {
        NSLog("could not collect available updates.")
        return false
    }

    _ = command.stdout.read()
    let error = command.stderror.read()

    if error.contains("No new software available") {
        return true
    }

    return false
}

You may wonder why stderror is used rather than stdout.
When you run softwareupdate --list on terminal, you will see the result like below if your Mac os is up to date.

JSGURUs-Mac:~ jsguru$ softwareupdate --list
Software Update Tool

Finding available software
No new software available.
JSGURUs-Mac:~ jsguru$

Strangely, stdout returns "Software Update Tool\n\nFinding available software\n" and stderror returns "No new software available.\n".
That's why stderror is used.

I hope these code snippets help you.