Skip to content

Ricardo Malla's Blog

  • Home
  • Information Technology
    • O/S
    • Databases
    • Software
  • Life
    • Health
  • Ideas
  • Notes

php: execute remote ssh script

March 22, 2021March 22, 2021 Uncategorized

  $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 to communicate via ssh (creating the key on the first one, uploading the pub key to the other, […]

Read more >

execute command as www-data

March 22, 2021March 22, 2021 Uncategorized

  for example. add known_host to remote server. you cannot su www-data as its not permitted by default, so you can run: sudo -u www-data ssh root@remote_ip additionally, you can test if www-data has permission to open a file: sudo […]

Read more >

mysql foreign constraints

March 21, 2021March 23, 2021 Uncategorized

cannot truncate tables because it has constraints.     SET FOREIGN_KEY_CHECKS = 0; TRUNCATE table leads; SET FOREIGN_KEY_CHECKS = 1;     Note that you need to SET FOREIGN_KEY_CHECKS = 0 with a user that has privilage to do so. […]

Read more >

python: remove special characters from string

March 21, 2021 Uncategorized

  re.sub('[^A-Za-z0-9]+', '', mystring)

Read more >

php composer: incompatible version 2

March 20, 2021April 4, 2021 Uncategorized

  you can downgrade to version 1 , execute composer install and then revert back composer self-update --1 revert to version 2 composer self-update --2

Read more >

Posts navigation

Previous 1 … 3 4 5 … 64 Next

Recent Posts

  • unifi: set java_home
  • python: create multi-dimensional list
  • mautic: campaign stuck
  • unifi video ubuntu nvr broken with java update
  • openjdk installation
  • idempiere installation notes
  • 2021 top opensource erps
  • firefox: sync profiles between computers
  • imaplib: search by uid
  • mautic: email config - test mail not working

Categories

  • Adempiere (1)
  • Android (1)
  • Apache (3)
  • Asterisk (11)
  • Backup Strategies (3)
  • CentOS (1)
  • Dropbox (2)
  • Elasticsearch (1)
  • Email Marketing (3)
  • ESXi (1)
  • Fail2Ban (1)
  • Finance (1)
  • Google (1)
  • Google Cloud (1)
  • Ideas (1)
  • iDempiere (17)
  • Information Technology (1)
  • Java (8)
  • Legal (1)
  • Life (2)
  • Magento (6)
  • Management (1)
  • Mautic (10)
  • Microsoft Stack (6)
  • MySQL (15)
  • NginX (1)
  • Notes (1)
  • O/S (1)
  • OpenBravo (39)
  • OpenERP/Odoo (6)
  • Outlook (1)
  • Pentaho (1)
  • PFSense (6)
  • PHP (4)
  • PhpList (1)
  • phpMyAdmin (1)
  • Pingdom (1)
  • Podcasts (1)
  • Podcasts (1)
  • Postfix (1)
  • PostgreSQL (19)
  • PowerBI (1)
  • Prestashop (22)
  • Procurement (1)
  • Python (2)
  • Sales (1)
  • Scrapy (1)
  • SEO (1)
  • Shell Scripts (2)
  • Software (3)
  • Splunk (1)
  • SugarCRM (20)
  • Synology (2)
  • sys admin (2)
  • Talend (3)
  • Tibco - Jasper Reports (20)
  • Ubuntu (30)
  • Uncategorized (73)
  • Unifi (3)
  • VirtualBox (1)
  • Virtualization (1)
  • VMware (6)
  • Wordpress (2)
  • Zoiper (1)
Proudly powered by WordPress | Theme: Sydney by aThemes.