Paolo Pizzolongo

setup odbc to AS400 (iSeries) on Debian 9 and PHP

Ago 03, 2019 Lascia un commento ~ Scritto da paolo 
apt-get install unixodbc unixodbc-dev
dpkg -i ibm-iaccess-1.1.0.11-1.0.amd64.deb
apt-get install php7.0-odbc
odbcinst -i -d -f /opt/ibm/iaccess/unixodbcregistration
nano /etc/odbc.ini

On the ini file type:

[MyDSN]
Description             = Company DB
Driver                  = IBM i Access ODBC Driver
System                  = myserver.mycompany.local
UserID                  = username
Password                = password
Naming                  = 0
DefaultLibraries        = mylibrary
Database                =
ConnectionType          = 1 (0=read/write; 1=readonly)
BlockFetch              = 1
BlockSizeKB             = 512

[MyDSN2]
Description             = Company DB2
Driver                  = IBM i Access ODBC Driver
System                  = myserver2.mycompany.local
UserID                  = username
Password                = password
Naming                  = 0
DefaultLibraries        = mylibrary
Database                =
ConnectionType          = 1
BlockFetch              = 1
BlockSizeKB             = 512

.....

On my php file with PDO:

$pdo = new PDO("odbc:MyDSN");
$stmt = $pdo->query("SELECT * FROM mytable");
while ($row = $stmt->fetch()) {
        print_r($row);
}
Pubblicato sotto Linux, Server - con tag , , , , , ,

How to use PDO with PHP and MySQL

Lug 06, 2019 Lascia un commento ~ Scritto da paolo 
$db = new PDO('mysql:host=localhost;dbname=mydb;', 'username', 'password');

$q="select my query";
$db->query($q);
Pubblicato sotto News - con tag , , ,

Crontab Tutorial

Lug 04, 2019 Lascia un commento ~ Scritto da paolo

https://crontab.guru/

Pubblicato sotto Linux, Server - con tag , , ,

Uptime Windows Server

Giu 22, 2019 Lascia un commento ~ Scritto da paolo

from CMD:

net statistics server

from task manager:
Uptime Windows Server

Days – Hours – Minutes – Seconds

Pubblicato sotto Server, Windows Server

How to remove double quotes from variables in batch file with cmd

Giu 21, 2019 Lascia un commento ~ Scritto da paolo 
set widget="my little string"
set widget
set widget=%widget:"=%
set widget

Output:

widget="my little string"
widget=my little string
Pubblicato sotto Server, Windows Server - con tag , ,

Zabbix icmp pinger processes more than 75% busy

Giu 21, 2019 Lascia un commento ~ Scritto da paolo 
nano /etc/zabbix/zabbix_server.conf

change the value for

### Option: StartPingers
#       Number of pre-forked instances of ICMP pingers.
#
# Mandatory: no
# Range: 0-1000
# Default:
StartPingers=10
Pubblicato sotto Linux, Server - con tag , ,

How to use fgetcsv in PHP

Giu 06, 2019 Lascia un commento ~ Scritto da paolo 
$i=0;
if (($handle = fopen("myfile.csv", "r")) !== FALSE) {
    while (($cells = fgetcsv($handle, 1000, ",")) !== FALSE) {
        if ($i==0){// header 

        }else{ //content
                 
        }
        $i++;
    }
    fclose($handle);
}
Pubblicato sotto News - con tag , ,

Setting Up Full Disk Encryption on Debian 9 Stretch

Mag 01, 2019 Lascia un commento ~ Scritto da paolo

I say “Full” disk encryption but that’s not entirely correct: there is still a small partition /boot that’s unencrypted. That contains your kernel, grub config and initrd and needs to be unencrypted so we can start booting and decrypt the rest of the OS.

So let’s get started:

Installing

Boot up your CD, USB flash drive, ISO file or install media of choice and select Graphical install.

CD Boot

Select your language.

Select a language

Select your location.

Select a location

Set your keyboard layout.

Configure the Keyboard

Pick a name for your computer.

Configure the network

Set your local domain.

Configure the network

I personally leave the root password blank, this disables the root account and instead sets you up with a first user that can run sudo to become root.

set up users and passwords

Enter your full name.

set up users and passwords

Pick your username (the default is usually pretty good).

set up users and passwords

Set your password.

set up users and passwords

Set your timezone.

Configure the clock

The encryption:
This is where the magic happens, actually it’s quite simple, we are going to pick “Guided – use entire disk and set up encrypted LVM” and then just go with the defaults.

Partition disks

Select the volume to install Debian. (This will wipe whatever you have on that disk!!)

Partition disks

Pick “All files in one partition (recommended for new users)”.

Partition disks

Pick ‘Yes’ to write the changes to the disks.

Partition disks

Now the disk will be writen with random data, this is to prevent analysis of the disk. This step can be skipped by pressing cancle but it’s highly reccomend you wait it out. It could take several minutes to a few hours so now is an absolutely smashing time to go and have a cup of tea.

Partition disks

Now set a passphrase for your disk.

Partition disks

Select “Finish partitioning and write changes to disk”

Partition disks

Pick ‘Yes’ to write the changes to the disks.

Partition disks
Continue the installation

Now we continue the installation as per normal.

Pick ‘No’ for any extra CDs.

configure the package manager

Pick your country to find a local mirror .

configure the package manager

And pick your mirror of choice, often (at least in Australia) you will find your local ISP has a mirror and this will likely be fastest for you.

configure the package manager

Enter any proxy information (most times this will be blank)

configure the package manager

You are given the option to opt-in to Debian’s statistics collection.

Configure the popularity contest

Pick your software, I’ve gone with KDE as my desktop of choice but it’s a matter of personal taste.

Debian Software Selection

Install GRUB

Install the grub boot loader on a hard disk

Pick your boot disk.

Install the grub boot loader on a hard disk

and finish the installation.

Finish the installation
Boot your system

Now when you boot up you should presented with a prompt asking for the key to decrypt sda5_crypt (your encrypted volumne)

Enter your passphrase (Note: you won’t see characters as you type)

Finish the installation

Now you can log in and enjoy your new Debian system

Pubblicato sotto Linux, Server - con tag ,

How to Configure NTP Server in Windows Server 2016

Apr 02, 2019 Lascia un commento ~ Scritto da paolo

This article shows how to configure Windows Time Service on Windows Server 2016 so that it acts as an NTP server for domain client computers.

Configure Windows Time Service

1. Type the following commands on PowerShell:

w32tm /config /manualpeerlist:pool.ntp.org /syncfromflags:MANUAL
Stop-Service w32time
Start-Service w32time

Now the Windows Server 2016 is an NTP client of pool.ntp.org and its time/clock is synced with the NTP pool servers (The server is at the same time the NTP server for other domain client systems).

If your Windows Server 2016 machine is a VM inside Hyper-V, you have to disable time sync. Go to VM settings-> Management-> Integration Services and uncheck Time Synchronization. Otherwise, Windows Server 2016 time/clock will be synced with the Host time/clock.

2. Go to the client machines and run the following command on PowerShell to force them to sync their time/clock with the domain controller on the Windows Server 2016.

w32tm /resync

You can check the time synchronization status using the following command.

w32tm /query /status
Pubblicato sotto Server, Windows Server - con tag , ,
←