Paolo Pizzolongo

How to use PHPSpreadSheet with composer on Debian 10

Gen 16, 2020 ~ Scritto da paolo

from root:
apt-get install composer php-cli

from user:
composer require phpoffice/phpspreadsheet

Into myfile.php (example):

require_once('vendor/autoload.php');
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
// Creates New Spreadsheet
$spreadsheet = new Spreadsheet();
// Retrieve the current active worksheet
$sheet = $spreadsheet->getActiveSheet();
// Set the value of cell A1
$sheet->setCellValue('A1', 'Paolo');
// Sets the value of cell B1
$sheet->setCellValue('B1', 'Pizzolongo');
// Write an .xlsx file
$writer = new Xlsx($spreadsheet);
// Save .xlsx file to the current directory
$writer->save('paolo.xlsx');

Pubblicato sotto Linux, Server - con tag , , , ,

How to install and use youtube-dl

Gen 16, 2020 ~ Scritto da paolo

Available also with apt-get on debian, this repository package is usually not updated to the latest version. Consider to donwload it manually and use standalone.

wget https://yt-dl.org/downloads/latest/youtube-dl -O /usr/bin/youtube-dl

chmod a+rx /usr/bin/youtube-dl

for updates:youtube-dl -U

youtube-dl <video_url>

To specify a format: youtube-dl -F <video_url>

To download with a specific format youtube-dl -f <chosen_format><video_url>

For subtitles:

youtube-dl --list-subs <video_url>

youtube-dl --all-subs --skip-download <video_url>

For Playlists: youtube-dl -cit <playlist_url>

Only Audio: youtube-dl -x --audio-format mp3 <video_url>

Pubblicato sotto Linux, Server - con tag , , , ,

Useful Software

Gen 10, 2020 ~ Scritto da paolo
Flashback Recorder: https://www.flashbackrecorder.com/express/
Record audio and video from desktop or meetings
Velocity Console: https://www.wavelink.com/Download-Velocity_enterprise-app-modernization-Software/
Configure Ivanti Terminal Emulation for android devices
Sysinternals Suite: https://docs.microsoft.com/en-us/sysinternals/downloads/sysinternals-suite
Suite of many useful tools for windows os management
Rufus: https://rufus.ie/it_IT.html
Tool for freating bootable USB drives from .ISO files
Heidi SQL: https://www.heidisql.com/
Tool to manage MySQL, MariaDB, Postgres, SQL Server databases
WinSCP: https://winscp.net/eng/download.php
Connect and manage files through SFTP connctions
QR Code Studio: https://www.tec-it.com/it/download/free-software/qrcode-studio/Download.aspx
Generate QR Codes from text
FreeFileSync: https://freefilesync.org/
Copy, sync and backup files

Pubblicato sotto News - con tag ,

Zabbix 3.0 to 4.0 Upgrade during Debian 9 to 10 Ugrade

Gen 06, 2020 ~ Scritto da paolo

stop zabbix services
change apt soutrces from stretch to buster
apt update
apt install –only-upgrade ‘zabbix.*’
apt install –only-upgrade ‘zabbix-server.*’
apt install –only-upgrade ‘zabbix-agent.*’
apt upgrade
apt full-upgrade
reboot
apt –purge autoremove
start zabbix services (during the new start of services the database will be updated)

Pubblicato sotto Linux, Server - con tag ,

Send Mail with PHPMailer as debian 10 meta-package

Gen 06, 2020 ~ Scritto da paolo

install on the debian server the following package:

apt-get install libphp-phpmailer

and use it as in the example below:

require("/usr/share/php/libphp-phpmailer/autoload.php");
$mail = new PHPMailer\PHPMailer\PHPMailer();
$mail->IsSMTP(); 
$mail->SMTPAuth = false; 
$mail->SMTPSecure = false; 
$mail->SMTPAutoTLS = false; 
$mail->Host = ""; 
$mail->Port = 25; 
$mail->IsHTML(true); 
$mail->SetFrom("from@mydomain.tld"); 
$mail->Subject = "my subject"; 
$mail->Body = "my body"; $mail->AddAddress("to@anotherdomain.tld"); 
if(!$mail->Send()) { 
     echo "Mailer Error: " . $mail->ErrorInfo;
} else {
     echo "Message has been sent";
}

Pubblicato sotto Linux, Server - con tag , ,

Change Debian 10 VM Resolution on Hyper-V

Dic 24, 2019 ~ Scritto da paolo

from root or sudo:

nano /etc/default/grub

find the row with GRUB_CMDLINE_LINUX_DEFAULT

and complete with:

“quiet video=hyperv_fb:1920×1080”

or the resolution you want; save and exit

update-grub

reboot the vm

Pubblicato sotto Linux, Server, Windows Server - con tag ,

How to install Zabbix on Debian 10

Dic 08, 2019 ~ Scritto da paolo

1. apt-get install mariadb-server
2.Setup rights for user root or zabbix or similar
3.mysql
4.create DB zabbix with collate utf8_bin
5.create user zabbix with correct rights on zabbix DB
6.apt-get install zabbix-server-mysql zabbix-frontend-php php-mysql
7./etc/init.d/mysql restart
8.a2enconf zabbix-frontend-php
9.nano /etc/php/7.3/apache2/php.ini
10.setup date.timezone in php.ini (Europe/Rome)
11.systemctl reload apache2
12.systemctl restart apache2
13.nano /etc/mysql/mariadb.conf.d/50-server.cnf
14.innodb_log_file_size = 500M
15.innodb_log_buffer_size = 800M
16.innodb_strict_mode = 0
17.cd /usr/share/zabbix-server-mysql/
18.gunzip *.gz
19.mysql -uzabbix -p zabbix < schema.sql
20.mysql -uzabbix -p zabbix < images.sql
21.mysql -uzabbix -p zabbix < data.sql
22./etc/init.d/mysql restart
23./etc/init.d/mysql restart
24. http:///zabbix
25.apt-get install zabbix-agent
26.nano /etc/zabbix/zabbix_server.conf (DBPassword)
27.systemctl enable zabbix-server
28.reboot

Pubblicato sotto Linux, Server - con tag ,

Send Mail with PHPMailer

Dic 04, 2019 ~ Scritto da paolo 
require("/var/www/html/PHPMailer-master/src/Exception.php");
require("/var/www/html/PHPMailer-master/src/PHPMailer.php");
require("/var/www/html/PHPMailer-master/src/SMTP.php");

$mail = new PHPMailer\PHPMailer\PHPMailer();
$mail->IsSMTP();
$mail->SMTPAuth = false;
$mail->SMTPSecure = false;
$mail->SMTPAutoTLS = false;
$mail->Host = "";
$mail->Port = 25;
$mail->IsHTML(true);
$mail->SetFrom("from@mydomain.tld");
$mail->Subject = "my subject";
$mail->Body = "my body";
$mail->AddAddress("to@anotherdomain.tld");

if(!$mail->Send()) {
     echo "Mailer Error: " . $mail->ErrorInfo;
} else {
     echo "Message has been sent";
}

Pubblicato sotto Linux, Server - con tag , ,

Auto execution of an Excel file

Nov 19, 2019 ~ Scritto da paolo

MyFile.bat:

runas /user:mydomain\myuser “C:\Program Files\Microsoft Office\Office14\excel.exe \\myserver\path\to\file\myfile.xlsx”

If the excel fila has an auto_load macro it’s possibile to execute an update and close the file saving changes automatically.

Pubblicato sotto Server, Windows Server - con tag , ,
←