SSL Cert - Windows
Certyfikaty SSL - wszystkie klucze prywatne ulokowane są w następującej lokalizacji:
C:\ProgramData\Microsoft\Crypto\RSA\MachineKeys
W systemie windows certyfikaty - KeySpace można podejrzeć z linii poleceń używając polecenia
certutil –v –store my <thumbprint>
UWAGA: W powyższym poleceniu informacje o odcisku palca można znaleźć w zakładce szczegółów certyfikatu. Poniżej przedstawiono prawidłowe polecenia:
certutil -v -store my "77 e6 5a 43 59 93 5d 5f 7a 75 80 1a cd ad c2 22"
certutil -v -store my "77e65a4359935d5f7a75801acdadc222"
certutil -v -store my 77e65a4359935d5f7a75801acdadc222
Właściwość KeySpec określa, czy klucz prywatny może być używany do szyfrowania, podpisywania, czy obu.
Error HRESULT: 0x80070520 when adding SSL binding in IIS
Error HRESULT: 0x80070520 when adding SSL binding in IIS
Error There was an error while performing this operation
Details:
A specified logon session does not exist. It may alredy have been terminated. (EXception from HRelult: 0x80070520)


you can use the option to generate a certificate:
openssl pkcs12 -export -out domain.name.pfx -inkey domain.name.key -in domain.name.crt
The key file is just a text file with your private key in it.
If you have a root CA and intermediate certs, then include them as well using multiple -in params
openssl pkcs12 -export -out domain.name.pfx -inkey domain.name.key -in domain.name.crt -in intermediate.crt -in rootca.crt
If you're looking for a Windows graphical user interface, check out DigiCert. It is a fairly simple program with an easy interface. On the SSL tab, import the generated certificate. Then, after selecting the Certificate, you can export the file as PFX with or without a key.
https://www.digicert.com/util
This program can also repair a certificate that was uploaded with an error
How to create .pfx file from certificate and private key?
How to create .pfx file from certificate and private key?
1. Open web page -
2. Select Type of Current Certificate

Your certificate should be issued in Standard PEM format. Common PEM extensions include .cer, .crt, and .pem. Make sure Type of Current Certificate is set to “Standard PEM”.
3. Select Type to Convert To
Select “PFX/PKCS#12” as the Type to Convert To.
4. Upload Certificate
Locate Certificate File to Convert and click the Choose File button to upload your certificate. This file should be the certificate that is issued to your web server domain.
5. Upload Private Key
Locate Private Key File and click the Choose File button to upload the file.
6. Upload Chain Certificate Files
Locate Chain Certificate File and click Choose File to upload the CA intermediate certificate. The appropriate certificate depends on what brand of SSL you have, so please make sure you have the correct intermediate certificate before you upload your file.
8. PFX Password
Create a new password for your PFX file. You will need to remember this password when you install the PFX file on your system.
9. Convert Certificate
Once you have uploaded the certificate and key files, click the Convert Certificate button to complete the process and download your new PFX file.
Postgresql – Possible backup corruption using pg_dump only with compress parameter
Postgresql – Possible backup corruption using pg_dump only with compress parameter
the command can be used to backup the database in postgresql
pg_dump -Z 1 db_name > backup
where -Z - compression level
db_name - database name
backup - backup file name
Restoring: psql -U username -d dbname < filename.sql -- For Postgres versions 9.0 or earlier psql -U username -d dbname -1 -f filename.sql or pg_restore -U username -d dbname -1 filename.dump Postgresql – How to pg_restore In your pg_dump, specify the -F t flag. This tells pg_dump to create the backup in tar format
make backup with commang:
pg_dump -U postgres -h /tmp -Ft -b -C mydb > file_db.tar
When I want to restore from backup, i give error.
pg_restore -U postgres -d template1 -v -C < file_db.tar
Strona 27 z 125
