Dejar base de datos en modo single user

dejar base de datos en modo single user

 USE master;

GO

ALTER DATABASE AdventureWorks2012

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

GO

ALTER DATABASE AdventureWorks2012

SET READ_ONLY;

GO

ALTER DATABASE AdventureWorks2012

SET MULTI_USER;

GO

The transaction log for database 'AdventureWorks2012' is full due to 'LOG_BACKUP' - log full

log full dejar en modo single 

ALTER DATABASE AdventureWorks2012  SET RECOVERY SIMPLE

GO

Reset Onedrive - Reiniciar Onedrive

 

In the Run window, enter: 

Copy and paste

%localappdata%\Microsoft\OneDrive\onedrive.exe /reset

Click OK.

 

Wait 1 minute and then execute the following command:

 

Copy and paste

%localappdata%\Microsoft\OneDrive\onedrive.exe /update

Click OK.

 

If the OneDrive icon doesn’t re-appear after a few minutes, open the Run window again and enter:

Copy and paste

%localappdata%\Microsoft\OneDrive\onedrive.exe

Click OK.

 

I look forward to hearing from you.

 

DotNet Core Raspbian buster 10 RPI4 - ARM64

uname -a #para saber que version tenemos en la raspberry.

me sucedio que al instalar la version de net core no podia ejecutar la instalacion de arm32, ya que instale la nueva version de buster arm64

curl -SL -o dotnet.tar.gz https://download.visualstudio.microsoft.com/download/pr/64353333-3080-45f7-a3d5-33e391e4596c/e9d5d53cb318628485e8d1fbd26ec30d/aspnetcore-runtime-3.1.16-linux-arm64.tar.gz

curl -SL -o dotnetSDK.tar.gz https://download.visualstudio.microsoft.com/download/pr/0d0ad29d-da90-42ce-a88d-94f47f9ddc09/bbfafc31b9a7e36140a74e0e157e9e3e/dotnet-sdk-3.1.410-linux-arm64.tar.gz

sudo mkdir -p /usr/share/dotnet

sudo tar -zxf dotnet.tar.gz -C /usr/share/dotnet

sudo tar -zxf dotnetSDK.tar.gz -C /usr/share/dotnet

sudo ln -s /usr/share/dotnet/dotnet /usr/bin/dotnet

#o para variables de entorno

export DOTNET_ROOT=$HOME/usr/share/dotnet

export PATH=$PATH:$HOME/usr/share/dotnet

#si ademas queremos instalar vs code en raspbian 

sudo apt update

sudo apt install code

#crear solucion por consola 

mkdir hello-netcore3.1

cd hello-netcore3.1/

dotnet new console

dotnet run

acá el detalle del SO y DotNet.

Commando :   dotnet --info

.NET Core SDK (reflecting any global.json):

 Version:   3.1.404

 Commit:    470f6754b3

Runtime Environment:

 OS Name:     debian

 OS Version:  10

 OS Platform: Linux

 RID:         debian.10-arm64

 Base Path:   /usr/share/dotnet/sdk/3.1.404/

Host (useful for support):

  Version: 3.1.10

  Commit:  1721e39439

.NET Core SDKs installed:

  3.1.404 [/usr/share/dotnet/sdk]

.NET Core runtimes installed:

  Microsoft.AspNetCore.App 3.1.10 [/usr/share/dotnet/shared/Microsoft.AspNetCore.App]

  Microsoft.NETCore.App 3.1.10 [/usr/share/dotnet/shared/Microsoft.NETCore.App]

To install additional .NET Core runtimes or SDKs:

  https://aka.ms/dotnet-download

Instalar Antivirus Clam AV en raspberry

sudo apt update

sudo apt install clamav

https://pimylifeup.com/raspberry-pi-clamav/

Instalar VPN en Raspberry

 https://www.pivpn.io/

sudo service openvpn start

sudo service openvpn stop

sudo service openvpn status

systemctl status openvpn@raspberrypi | grep active

netstat -tlnpu | grep openvpn

#si se requiere desintalar

pivpn -u

#para instalar

    curl -L https://install.pivpn.io | bash

Enviar Correo por Consola ubuntu 18.04

 basado en esta web.

https://techexpert.tips/es/ubuntu-es/enviar-gmail-desde-la-linea-de-comandos-de-ubuntu-linux/

sudo apt-get update

sudo apt-get install ssmtp

sudo nano /etc/ssmtp/ssmtp.conf 

root=correogmail@gmail.com

mailhub=smtp.gmail.com:465

FromLineOverride=YES

AuthUser=correogmail@gmail.com

AuthPass=laclave

UseTLS=YES

(echo "Subject: EquipoLinuxCasaReiniciado"; echo "From: gmail@gmail.com"; echo "To:destino@gmail.com"; echo ""; echo "Reiniciado") | ssmtp destino@gmail.com