March 31, 2021March 31, 2021uncategorized mysql: find special characters on strings SELECT id, first_name FROM contacts WHERE first_name REGEXP '[^a-zA-Z0-9-]'
March 31, 2021uncategorized asheville nc https://livability.com/topics/experiences-adventures/7-spiritual-escapes-in-the-us
March 31, 2021uncategorized 3 lugares perfectos para retiro espiritual en venezuela 3 Lugares Perfectos para un Retiro Espiritual en Venezuela
March 30, 2021uncategorized python script getting stuck: how to debug? python3 -m trace --trace /path to python string.py
March 22, 2021March 22, 2021uncategorized php: execute remote ssh script $command = "sudo ssh -p 22 root@XXX.XXX.XX.XX python3 /home/scripts/apps/xxx/xxx/email_address/email_builder.py"; shell_exec($command); note the you have to configure both server to be able […]
March 22, 2021March 22, 2021uncategorized execute command as www-data for example. add known_host to remote server. you cannot su www-data as its not permitted by default, so you can run: […]
March 21, 2021March 23, 2021uncategorized mysql foreign constraints cannot truncate tables because it has constraints. SET FOREIGN_KEY_CHECKS = 0; TRUNCATE table leads; SET FOREIGN_KEY_CHECKS = 1; […]
March 21, 2021uncategorized python: remove special characters from string re.sub('[^A-Za-z0-9]+', '', mystring)
March 20, 2021April 4, 2021uncategorized php composer: incompatible version 2 you can downgrade to version 1 , execute composer install and then revert back composer self-update --1 revert to version 2 […]
March 18, 2021March 18, 2021uncategorized jenkins: run jobs as root reference: https://stackoverflow.com/questions/29926773/run-shell-command-in-jenkins-as-root-user sudo vi /etc/default/jenkins $JENKINS_USER="root" sudo chown -R root:root /var/lib/jenkins sudo chown -R root:root /var/cache/jenkins sudo chown -R root:root […]