Saturday, March 28, 2020

Instalar SVN en Raspberry PI


sudo apt-get update

sudo apt-get install -y apache2 apache2-utils

sudo apt-get install -y subversion subversion-tools libapache2-mod-svn

sudo mkdir /var/lib/svn

sudo svnadmin create /var/lib/svn/SPO

sudo chown -R www-data:www-data /var/lib/svn/SPO/

sudo nano /etc/apache2/mods-enabled/dav_svn.conf

<Location /svn>
 DAV svn
#SVNParentPath /var/lib/svn
 SVNParentPath /1tb_local/svn
 AuthType Basic
 AuthName "Subversion Repository"
 AuthUserFile /etc/apache2/dav_svn.passwd
 Require valid-user
</Location>


#para el respaldo
svnadmin dump personal > personal.dump

#Para Crear usuarios
sudo htpasswd -cm /etc/apache2/dav_svn.passwd pbeltran

systemctl restart apache2

#para Restaurar
svnadmin load /var/lib/svn/SPO < /home/pi/SPO.dump

para validar http://ip/svn/personal/

Basado en:
https://www.itzgeek.com/how-tos/linux/debian/install-apache-svn-subversion-on-debian-9-ubuntu-16-04.html

https://servidordebian.org/es/buster/intranet/version_control/subversion

para el respaldo de visual SVN

svnadmin dump C:\Repositories\MyRepo --file C:\repo.dump

https://www.visualsvn.com/support/topic/00173/#:~:text=Start%20the%20VisualSVN%20Server%20Manager,repository%20dump%20and%20click%20Next.


Saturday, March 21, 2020

desactivar el enterono grafico


#para conocer el entorno grafico
systemctl get-default
#aca lo mas seguro es que diga graphical mode

#con este comando lo dejamos como consola.
systemctl set-default multi-user.target

#para volver a dejarlo con entorno grapfico
systemctl set-default graphical.target

Friday, March 20, 2020

IP fija - Red statica

sudo nano /etc/dhcpcd.conf
# Example static IP configuration:
interface eth0
static ip_address=192.168.1.116/24
#static ip6_address=fd51:42f8:caae:d92e::ff/64
static routers=192.168.1.1
static domain_name_servers=192.168.1.1 8.8.8.8 fd51:42f8:caae:d92e::1


para agregar DNS de movistar
# Example static IP configuration:
interface eth0
static ip_address=192.168.1.35/24
#static ip6_address=fd51:42f8:caae:d92e::ff/64
static routers=192.168.1.1
static domain_name_servers=192.168.1.1 200.28.4.130 200.28.4.129

ubuntu 22

▪️ lsb_release -a ▪️ cd /etc/netplan ▪️ sudo nano 01-network-manager-al.yaml ❗️ Después, líneas a añadir en la terminal: ethernets: enp0s3: dhcp: no addresses: [IP_nueva/24] gateway: 192.68.##.1 nameservers: addresses: [8.8.8.8,8.8.4.4]

Friday, March 6, 2020

cannot drop database because it is currently in use.

-- Script para matar el proceso que no te permite eliminar la base de datos

DECLARE @DatabaseName nvarchar(50)
SET @DatabaseName = N'DatabaseName'

DECLARE @SQL varchar(max)

SELECT @SQL = COALESCE(@SQL,'') + 'Kill ' + Convert(varchar, SPId) + ';'
FROM MASTER..SysProcesses
WHERE DBId = DB_ID(@DatabaseName) AND SPId <> @@SPId

--Use this to see results
SELECT @SQL
--Uncomment this to run it
EXEC(@SQL)

drop database DatabaseName