apt-get update
apt-get install unixodbc unixodbc-dev php-odbc php-cli
wget https://packages.microsoft.com/debian/10/prod/pool/main/m/msodbcsql17/msodbcsql17_17.4.1.1-1_amd64.deb
odbcinst -i -d -f /opt/microsoft/msodbcsql17/etc/odbcinst.ini
nano /etc/odbc.ini
[MySQLServerDB]
Description = Database SqlServerDB
Driver = ODBC Driver 17 for SQL Server
Server = server[,port]
Types of Virtual Switches
External – This type of switch is bound to the physical network cards located in the host. As you would imagine, they provide VMs located on these switches with access to the physical network the Hyper-V host is connected to. The External switch can also share management traffic as well as VM traffic on the same switch and this is one of the options that can be set when creating the external switch.
Internal – This switch is not bound to a physical network card so only allows traffic between VMs and the host itself. However, a new addition to the Internal switch functionality in 2016 is the addition of the NAT forwarding internal switch which does allow external connectivity via NAT from the Hyper-V host.
Private – This type of switch is only used for virtual machines to communicate with each other. This type of switch might be useful for certain specific types of traffic such as cluster network if only using one host as it can’t be utilized between hosts.
Based on HP
You can configure the link type of a port as access, trunk, or hybrid. The link types use the following VLAN tag handling methods:
The PVID identifies the default VLAN of a port. Untagged packets are transmitted through the default VLAN.
When you configure the PVID on a port, follow these guidelines:
Based on Cisco:
Each port or LAG is marked with one of the following modes:
For each port or LAG (Link Aggregation Group), select one of the following values:
For each port or LAG, one or both of the following values may be selected:
Assuming that “pagecount” is the global counter item of our printer we can create a calculated item with the following expression:
max(pagecount,2592000)-min(pagecount,2592000)
where 2592000 is the number of seconds (30 days, i.e 60sec x 60min x 24hours x 30days) of our interval to get the minimum and the maximum number detected.
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');
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>
Recent Comments