remove metadata file with linux terminal

sudo apt-get install id3v2

id3v2 -l some_file.mp3

id3v2 -s some_file.mp3

id3v2 -s some_file.mp3

for i in *.mp3; do echo "Processing $i"; id3v2 -s "$i"; done

mysql varius sentences

1. I see all foreign keys to a table or column: SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_NAME = '<table>'
2. Distinc values in 2 columns from 2 tables:SELECT
    SELECT DISTINCT t1.`ID_POSTULANTE` AS T1_ID_POSTULANTE FROM
     `tb_postulante` t1 INNER JOIN `aulaasignada` as t2
      ON t1.`ID_POSTULANTE` != t2.`ID_POSTULANTE`
      GROUP BY T1_ID_POSTULANTE
3. values duplicate for one column: SELECT certificado_id_correlativo FROM t_certificado_digital group by certificado_id_correlativo having count(*) >= 2
4. update from select: update tabla1 inner join tabla2 on tabla1.id_tabla2 = tabla2.id set tabla1.campo=tabla2.language
   
5. update year sales: update sales set created_at=DATE_FORMAT(created_at, '2020-%m-%d') where YEAR(created_at) < 2020 ;
6. update month sales: update sales set created_at=DATE_FORMAT(created_at, '%y-10-%d') where MONTH(created_at) < 10 ;
7. update day sales: update sales set created_at=DATE_FORMAT(created_at, '%y-%m-25') where DAY(created_at) < 10 and MONTH(created_at) = 10 ;
8. update month invertval sales: update sales set created_at=date_add(created_at, interval 1 month);
9. insert select:
   
1. INSERT INTO generic_stage.entity_items (
       client_id,
       item_type_id,
       item_id,
       action_type,
       action_result,
       marketing_flag,
       creation_timestamp
   )
   SELECT
       '300001' AS client_id,
       8 AS item_type_id,
       cg.id AS item_id,
       1 AS action_type,
       1 AS action_result,
       0 AS marketing_flag,
       NOW() AS creation_timestamp -- use NOW() for current timestamp
   FROM generic_source.item_source cg
   WHERE source_provider_id = 7;
10. 
    

•  https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column
• http://www.dataprix.com/blog-it/dml/como-hacer-update-select-mysql

arch and manjaro temp size

#!/bin/bash

sudo mount -o remount,size=40G,noatime /tmp
echo "Done. Please use 'df -h' to make sure folder size is increased."

how create service linux repeat each 10s

nano /etc/systemd/system/test.service

[Unit]                                                                                                                                            
Description=test_job                                                                                                                              
                                                                                                                                                  
[Service]                                                                                                                                         
Type=oneshot                                                                                                                                      
ExecStart=/usr/bin/php /tmp/run.php 

nano /etc/systemd/system/test.timer

[Unit]                                                                                                                                            
Description=test                                                                                                                                  
                                                                                                                                                  
[Timer]                                                                                                                                           
OnUnitActiveSec=10s                                                                                                                               
OnBootSec=10s                                                                                                                                     
                                                                                                                                                  
[Install]                                                                                                                                         
WantedBy=timers.target

systemctl daemon-reload

systemctl start test.timer

systemctl list-timers --all

docker sonarqube laravel

docker run -d --name sonarqube sonarqube

unzip sonar-scanner-cli-*

sudo cp -a sonar-scanner-* /opt/

sudo chmod -R 775 /opt/sonar-scanner-*

sudo ln -s /opt/sonar-scanner-3.2.0.1227-linux/bin/sonar-scanner /bin/sonar-scanner

sudo nano /opt/sonar-scanner-3.2.0.1227-linux/conf/sonar-scanner.properties

# Required metadata
sonar.projectKey=testproject
sonar.projectName=testproject
sonar.projectVersion=1.0.0

# Path to the parent source code directory.
sonar.sources=app

# Language
# We've commented this out, because we want to analyse both PHP and Javascript
#sonar.language=php

# Encoding of the source code
sonar.sourceEncoding=UTF-8

# Reusing PHPUnit reports
sonar.php.coverage.reportPath=ci/codeCoverage/codeCoverage.xml
sonar.php.tests.reportPath=ci/testResults.xml

# Here, you can exclude all the directories that you don't want to analyse.
# As an example, I'm excluding the Providers directory
sonar.exclusions=app/Providers/**

# Additional parameters
#sonar.my.property=value

# Required metadata
sonar.projectKey=project1
sonar.projectName=project1
sonar.projectVersion=1.0.0

# Path to the parent source code directory.
sonar.sources=app

# Language
# We've commented this out, because we want to analyse both PHP and Javascript
sonar.language=php

# Encoding of the source code
sonar.sourceEncoding=UTF-8

# Reusing PHPUnit reports
sonar.php.coverage.reportPath=ci/codeCoverage/codeCoverage.xml
sonar.php.tests.reportPath=ci/testResults.xml

# Here, you can exclude all the directories that you don't want to analyse.
# As an example, I'm excluding the Providers directory
sonar.exclusions=vendor/**

# Additional parameters
#sonar.my.property=value

sonar-scanner -e -X

how run ireport v5.6.0 o JasperReports in GNU/LINUX jdk 7

sudo apt-get install jdk7-openjdk

./ireport --jdkhome "/usr/lib/jvm/java-7-jdk/"

how block visibility only articles

how Simply selecting a Gimp layer

how to connect your home server to a domain with cloudflare

1. Add site
2. Auto update your dynamic ip 
3. Add sub-domains to domain
4. Select to type of encryption
5. Configuration encryption pem and key with nginx

curl -X GET "https://api.cloudflare.com/client/v4/zones/YOUR_ZONE_ID/dns_records?type=A&name=YOUR_DOMAIN" -H "X-Auth-Email: YOUR_EMAIL" -H "X-Auth-Key: YOUR_API_KEY" -H "Content-Type: application/json"

curl -X PUT "https://api.cloudflare.com/client/v4/zones/YOUR_ZONE_ID/dns_records/YOUR_ID_DOMAIN" \
     -H "X-Auth-Email: user@example.com" \
     -H "X-Auth-Key: YOUR_API_KEY" \
     -H "Content-Type: application/json" \
     --data '{"type":"A","name":"example.com","content":"127.0.0.1","ttl":1,"proxied":false}'

#!/bin/sh
ipNow=$(/sbin/ifconfig enp2s0 | grep -i 'Direc. inet' | cut -d ":" -f 2 | cut -d " " -f 1)
ipOld=""
UBICATION_LOGS="/opt/logs/"
ejecutarCodigo() {
 {
  echo "From: Server Update IP <server@YOUR-DOMAIN.COM>"
  echo "Sender: YOUR-MAIL@GMAIL.COM"
  echo "To: YOUR-MAIL@GMAIL.COM"
  echo "Subject: The server change ip"
  echo
  echo "The server change ip "$ipOld" to "$ipNow
 } | /usr/sbin/ssmtp YOUR-MAIL@gmail.com #enviar email
}
while read line; do
 ipOld=$line 
done <$UBICATION_LOGS"ipOld.js"
echo $ipOld"  -  "$ipNow
if [ $ipOld != $ipNow ]; then
 #loadwebs.tk
 curl -X PUT "https://api.cloudflare.com/client/v4/zones/YOUR_ID_ZONE/dns_records/YOUR_ID_DOMAIN" \
  -H "X-Auth-Email: YOUR-MAIL@gmail.com" \
  -H "X-Auth-Key: YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  --data '{"type":"A","name":"YOUR_DOMAIN","content":'\"$ipNow\"',"ttl":1,"proxied":false}' 
 ejecutarCodigo
else
 echo "NO"
fi

server {
 listen 443 ssl;
 server_name first.ramdontest.ml;
 root /var/www;
 index index.php index.html index.htm index.nginx-debian.html;
 ssl_certificate        /opt/ssl/ramdontest.pem;
 ssl_certificate_key    /opt/ssl/ramdontest.key;
 access_log /opt/logs/ramdontest.ml.access_log.js;
 error_log /opt/logs/ramdontest.ml.error_log.js;
 rewrite_log on;
 location / {
  proxy_pass http://localhost:3202;
  proxy_http_version 1.1;
  proxy_set_header Upgrade $http_upgrade;
  proxy_set_header Connection 'upgrade';  
 }
}

virtualbox manjaro error /sbin/vboxconfig solved kernel 4.14

uname -a 

sudo pacman -S linux414-virtualbox-host-modules

sudo modprobe vboxdrv

sudo adduser your_home_user vboxusers

sudo usermod -aG vboxusers your_home_user

how create modules, controllers, plugin block drupal 8.54

sudo docker-compose up

vendor/bin/drupal generate:module

vendor/bin/drupal generate:controller

vendor/bin/drupal generate:plugin:block

start drupal 8.54 or 7.59 with docker

sudo docker-compose up

sudo docker-compose stop

how to resize multiple to image Ubuntu/Manjaro

sudo apt-get install imagemagick

sudo pacaman -S imagemagick

convert *.jpg -resize 500x500 -quality 100 foto.jpg

convert *.jpg -resize 500x500! -quality 100 foto.jpg

mkdir ../tmp

for i in *.jpg; do convert "$i" -quality 40  ../tmp/"$i"; done

du -smh * | sort -h

docker openvpn ubuntu 16.04

OVPN_DATA="ovpn-data-example"

docker volume create --name $OVPN_DATA

docker run -v $OVPN_DATA:/etc/openvpn --rm kylemanna/openvpn ovpn_genconfig -u udp://VPN.SERVERNAME.COM

docker run -v $OVPN_DATA:/etc/openvpn --rm -it kylemanna/openvpn ovpn_initpki

docker run -v $OVPN_DATA:/etc/openvpn -d -p 1194:1194/udp --cap-add=NET_ADMIN kylemanna/openvpn

docker run -v $OVPN_DATA:/etc/openvpn --rm -it kylemanna/openvpn easyrsa build-client-full CLIENTNAME nopass

docker run -v $OVPN_DATA:/etc/openvpn --rm -it kylemanna/openvpn easyrsa build-client-full CLIENTNAME

docker run -v $OVPN_DATA:/etc/openvpn --rm kylemanna/openvpn ovpn_getclient CLIENTNAME > CLIENTNAME.ovpn

OVPN_DATA="ovpn-data-server" && CLIENTNAME=phone && sudo docker run -v $OVPN_DATA:/etc/openvpn --log-driver=none --rm -it kylemanna/openvpn easyrsa build-client-full $CLIENTNAME nopass && sudo docker run -v $OVPN_DATA:/etc/openvpn --log-driver=none --rm kylemanna/openvpn ovpn_getclient $CLIENTNAME > $CLIENTNAME.ovpn && cp $CLIENTNAME.ovpn /tmp/

sudo apt-get install openvpn

sudo openvpn --config CLIENTNAME.ovpn --comp-lzo no

sudo openvpn --config CLIENTNAME.ovpn --comp-lzo no --pull-filter ignore redirect-gateway

redirect-gateway def1

pull-filter ignore "dhcp-option DNS"
pull-filter ignore "route"
route-nopull
route 10.0.0.0 255.255.0.0