Generar PFX desde un certificado auto generado

 

openssl pkcs12 -export -in certificate.crt -inkey privatekey.key -certfile ca-bundle.crt -out output.pfx

al querer cargar en windows 2016 arroja error.

con este otro comando permite instalar

openssl pkcs12 -export -certpbe PBE-SHA1-3DES -keypbe PBE-SHA1-3DES -nomac -inkey tetra.key -in tetra.crt -out tetra.pfx

Convertir PPK a p12 - how to export to p12 from PPK

Basado en 

Steps to import Private Key (PPK) in SAP PI/PO for... - SAP Community

se debe de instalar

C:\cygwin64\bin>openssl

openssl.exe req -new -x509 -days 3650 -key PrivatePEM.pem -out x509_Private.pem

despues

openssl.exe pkcs12 -export -in x509_Private.pem -inkey PrivatePEM.pem -out PrivateP12.p12

Enter pass phrase for PrivatePEM.pem:

Enter Export Password:

Verifying - Enter Export Password:

htaccess como bloquear bots de web scrapping

 

Para visualizar el archivo .htaccess se debe de habilitar en el gestor de archivos , ver archivos ocultos del home 

<IfModule mod_rewrite.c>

ErrorDocument 403 "403"

RewriteEngine on

RewriteCond %{HTTP_USER_AGENT} "ClaudeBot|PetalBot|YandexBot|dotbot|DotBot|SemrushBot-SI|Googlebot"

RewriteRule ^(.*)$ - [F,L]

</IfModule>

complemento https://www.lucushost.com/ayuda/como-bloquear-el-trafico-de-bots/

lector de pgp files

 https://gpg4win.org/thanks-for-download.html

Crear llaves PGP publica y Privada

fue validado en ubuntu server y funciona sin problema :D 

#primero

gpg --full-generate-key

#para la llave publica

gpg --export -a --output Public_Key.asc tu correo

#para la llave privada acá te pide clave

gpg -a --export-secret-keys > private_secret_key.asc 

basado en https://docs.github.com/es/authentication/managing-commit-signature-verification/generating-a-new-gpg-key?platform=linux

https://unix.stackexchange.com/questions/481939/how-to-export-a-gpg-private-key-and-public-key-to-a-file

IP server desde SQL command

https://stackoverflow.com/questions/142142/sql-query-to-get-servers-ip-address

select @@version

SELECT  

   CONNECTIONPROPERTY('net_transport') AS net_transport,

   CONNECTIONPROPERTY('protocol_type') AS protocol_type,

   CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,

   CONNECTIONPROPERTY('local_net_address') AS local_net_address,

   CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,

   CONNECTIONPROPERTY('client_net_address') AS client_net_address 

Output

net_transport protocol_type auth_scheme local_net_address local_tcp_port

TCP                         TSQL     SQL         10.10.89.21         1433

Espacio utilizado por la tablas en SQL Server - table space already used into SQL server or TSQL

Query para conocer el detalle de espacio utilizado por las tablas

 SELECT 

t.NAME AS Tabla,

s.Name AS Esquema,

p.rows AS NumeroDeFilas,

CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalEspacio_MB,

CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS EspacioUtilizado_MB, 

CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS EspacioNoUtilizado_MB

FROM

sys.tables t

INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id

INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id

INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id

LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id

GROUP BY t.Name, s.Name, p.Rows

ORDER BY TotalEspacio_MB desc

post de : https://es.stackoverflow.com/questions/315885/espacio-utilizado-por-la-tablas-en-sql-server