mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' identified by 'password';
Privileges on MySQL
setup odbc to AS400 (iSeries) on Debian 9 and PHP
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);
}
How to use PDO with PHP and MySQL
$db = new PDO('mysql:host=localhost;dbname=mydb;', 'username', 'password');
$q="select my query";
$db->query($q);
Crontab Tutorial
https://crontab.guru/
Uptime Windows Server
from CMD:
net statistics server
from task manager:
Days – Hours – Minutes – Seconds
How to remove double quotes from variables in batch file with cmd
set widget="my little string" set widget set widget=%widget:"=% set widget
Output:
widget="my little string" widget=my little string
Zabbix icmp pinger processes more than 75% busy
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
How to use fgetcsv in PHP
$i=0;
if (($handle = fopen("myfile.csv", "r")) !== FALSE) {
while (($cells = fgetcsv($handle, 1000, ",")) !== FALSE) {
if ($i==0){// header
}else{ //content
}
$i++;
}
fclose($handle);
}
Setting Up Full Disk Encryption on Debian 9 Stretch
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
Recent Comments