Tuesday, December 5, 2023

Set a static IP Address on Raspberry Pi OS Bookworm

 

Set a static IP Address on Raspberry Pi OS Bookworm


desde https://www.abelectronics.co.uk/kb/article/31/set-a-static-ip-address-on-raspberry-pi-os-bookworm


sudo nmcli c mod "Wired connection 1" ipv4.addresses $IPLOCAL$/24 ipv4.method manual

reinicio IP
sudo nmcli c down "Wired connection 1" && sudo nmcli c up "Wired connection 1"

Sunday, November 12, 2023

underclock ryzen 3 5300U

 https://ryzencontroller.com/#downloads


bajar la temperatura y controlar consumo

Tuesday, October 17, 2023

cambiar tamaño base de datos Azure por sql cmd

#cambiar tamaño base de datos Azure por sql cmd

 ALTER DATABASE AzureDB2 MODIFY (MAXSIZE= 50 GB)

Friday, August 25, 2023

actualizar Raspberry desde buster a bullseye

Actualizar Raspberry desde buster a bullseye

lsb_release -a

sudo apt update

sudo apt dist-upgrade -y

sudo rpi-update

sudo nano /etc/apt/sources.list

#cambiar donde dice buster por bullseye

sudo apt update && sudo apt upgrade -y

sudo apt autoclean


Monday, July 31, 2023

How to drop a SQL Server user with db owner privilege

The error


The database principal owns a schema in the database, and cannot be dropped.


Query to identify users:

SELECT s.name

FROM sys.schemas s

WHERE s.principal_id = USER_ID('user');


Query Executed
ALTER AUTHORIZATION ON SCHEMA::db_owner TO dbo;
ALTER AUTHORIZATION ON SCHEMA::db_datareader TO dbo;
ALTER AUTHORIZATION ON SCHEMA::db_datawriter TO dbo;

finally

drop user usertobeDeleted

based https://stackoverflow.com/questions/35434389/how-to-drop-a-sql-server-user-with-db-owner-privilege 

Wednesday, July 26, 2023

Ubuntu cargar teclado en español

ubuntu cargar teclado en español

 setxkbmap es

Thursday, June 1, 2023

Error HRESULT E_FAIL has been returned from a call to a COM component vs 2019

 Error HRESULT E_FAIL has been returned from a call to a COM component vs 2019


basado en :

https://developercommunity.visualstudio.com/t/add-a-reference-raise-error-error-hresult-e-fail-h/260196


la solucion

C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.8 Tools\x64\gacutil.exe /i "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\PublicAssemblies\Microsoft.VisualStudio.Shell.Interop.11.0.dll"

posterior a eso reiniciar el DevEnv.exe y listo

Tuesday, May 23, 2023

SharePoint Designer 2013 Crash after install office 2021

 


https://social.msdn.microsoft.com/Forums/en-US/12a06282-e1a6-4ba2-aa30-b13b87b5d56a/sharepoint-designer-2013-continues-to-crash-in-quotfirst-things-firstquot-tab?forum=sharepointcustomization


The below steps worked for me, however my 'first things first' prompt only showed the licence agreement.

Open regedit.

Create Key:
Computer\HKEY_CURRENT_USER\Software\Policies\Microsoft\office\15.0\common\general

Add DWORD with value 1:
• OptInDisable
• shownfirstrunoptin

Create Key:
Computer\HKEY_CURRENT_USER\Software\Policies\Microsoft\office\15.0\Registration

Add DWORD with value 1:
AcceptAllEulas

I could then launch SharePoint Designer 2013 without the prompt, and it didn't crash.


otra opcion con windows 11

Equipo\HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\General


Thursday, March 2, 2023

How to Check the .NET Framework Version with PowerShell? - how to see max net framework installed

 how to see max net framework installed


Get-ChildItem ‘HKLM:\SOFTWARE\Microsoft\NET Framework Setup\NDP’ -Recurse | Get-ItemProperty -Name version -EA 0 | Where { $_.PSChildName -Match ‘^(?!S)\p{L}’} | Select PSChildName, version

Monday, January 2, 2023

Pi-Hole Docket rpi4

 

https://pi-hole.net/


https://github.com/pi-hole/docker-pi-hole/#running-pi-hole-docker


sudo apt install docker

sudo apt install docker-compose

create este sh


#!/bin/bash
# https://github.com/pi-hole/docker-pi-hole/blob/master/README.md
PIHOLE_BASE="${PIHOLE_BASE:-$(pwd)}"
[[ -d "$PIHOLE_BASE" ]] || mkdir -p "$PIHOLE_BASE" || { echo "Couldn't create storage directory: $PIHOLE_BASE"; exit 1; }
# Note: FTLCONF_LOCAL_IPV4 should be replaced with your external ip.
docker run -d \
--name pihole \
-p 53:53/tcp -p 53:53/udp \
-p 80:80 \
-e TZ="America/Chicago" \
-v "${PIHOLE_BASE}/etc-pihole:/etc/pihole" \
-v "${PIHOLE_BASE}/etc-dnsmasq.d:/etc/dnsmasq.d" \
--dns=127.0.0.1 --dns=1.1.1.1 \
--restart=unless-stopped \
--hostname pi.hole \
-e VIRTUAL_HOST="pi.hole" \
-e PROXY_LOCATION="pi.hole" \
-e FTLCONF_LOCAL_IPV4="127.0.0.1" \
pihole/pihole:latest
printf 'Starting up pihole container '
for i in $(seq 1 20); do
if [ "$(docker inspect -f "{{.State.Health.Status}}" pihole)" == "healthy" ] ; then
printf ' OK'
echo -e "\n$(docker logs pihole 2> /dev/null | grep 'password:') for your pi-hole: http://${IP}/admin/"
exit 0
else
sleep 3
printf '.'
fi
if [ $i -eq 20 ] ; then
echo -e "\nTimed out waiting for Pi-hole start, consult your container logs for more info (\`docker logs pihole\`)"
exit 1
fi
done;



https://pimylifeup.com/pi-hole-docker/

sudo docker ps -a # para mirar que hay 
sudo docker rm 3c501a524b12 # para eliminar
sudo docker-compose up -d   #para subir

Error al levantar en ubuntu 2022

ERROR: for pihole  Cannot start service pihole: driver failed programming external connectivity on endpoint pihole (b829371fdb48806bd51274093e2e543f17c9b3b0c9dbaef4d067ccd5f55ae04f): Error starting userland proxy: listen tcp4 0.0.0.0:53: bind: address already in use

ERROR: for pihole  Cannot start service pihole: driver failed programming external connectivity on endpoint pihole (b829371fdb48806bd51274093e2e543f17c9b3b0c9dbaef4d067ccd5f55ae04f): Error starting userland proxy: listen tcp4 0.0.0.0:53: bind: address already in use

#como resolver el error
systemctl disable systemd-resolved.service
systemctl stop systemd-resolved


XRDP is not working

 Based on 

https://forums.raspberrypi.com/viewtopic.php?t=323471

Re: bullseye: xrdp not working for user "pi"


https://github.com/neutrinolabs/xrdp/issues/2060

Modify /etc/X11/xrdp/xorg.conf to use xrdp normally


sudo nano /etc/X11/xrdp/xorg.conf

and comment 

#Option "DRMDevice" "/dev/dri/renderD128"

Option "DRMDevice" ""


ademas agregar esto al final para que ande mas rapido el xrdp

Section "Extensions"
    Option "Composite" "Disable"
EndSection