Drupal: Access control

Download, extract, copy content_access directory to:
/sites/all/modules

Enable node access control:
Administration > Structure > Content types > Basic page > Access control
/admin/structure/types/manage/page/access
Check "Enable per content node access control settings"
Submit

Link
http://drupal.org/project/content_access

Adaptec RAID controller / arcconf 

arcconf GETLOGS 1 DEVICE 

# list logical devices
arcconf GETCONFIG 1 LD

# list phisical devices
arcconf GETCONFIG 1 PD

# start adaptec verifi
arcconf TASK START 1 DEVICE 0 0 VERIFY

arcconf GETSTATUS 1

# create JBOD on all devices
# get device count
COUNT=$(arcconf GETCONFIG 1 PD | grep "Hard drive" | wc -l)

# create JBOD on all devices
for CHANNEL in `echo $(seq 1 ${COUNT})`; do
    CHANNEL=$((CHANNEL-1))
    echo ${CHANNEL}

    arcconf CREATE 1 JBOD 0 ${CHANNEL} noprompt
done

# delete devices
arcconf DELETE 1 LOGICALDRIVE ALL noprompt

# delete all JBOD devices
arcconf DELETE 1 JBOD ALL noprompt

# create RAID 10
arcconf CREATE 1 LOGICALDRIVE MAX 10 0 0 0 1 0 2 0 3 0 4 0 5 0 6 0 7 noprompt

Links
http://wiki.hetzner.de/index.php/Adaptec_RAID_Controller/en
http://www.thomas-krenn.com/de/wiki/Festplattenausfall_bei_Adaptec_RAID_Controller_mit_ARCCONF_beheben

Compile smartmontools

[embed_url: https://raw.githubusercontent.com/panticz/scripts/master/compile.smartmontools.sh]

check smartctl version

smartctl -V

Old vesion

# Install required software
apt-get update
apt-get install -y subversion build-essential automake

# Get smartmontools from repository
svn co https://smartmontools.svn.sourceforge.net/svnroot/smartmontools/trunk/smartmontools smartmontools

# Compile
cd smartmontools
./autogen.sh
./configure
make
make install

Links
http://sourceforge.net/apps/trac/smartmontools/wiki/Download
http://sourceforge.net/projects/smartmontools/files/smartmontools/
http://sourceforge.net/apps/trac/smartmontools/wiki/Download#Installprecompiledpackage

Install MySql Workbench under Ubuntu

Install from snap
https://github.com/tonybolzan/snap-mysql-workbench

sudo snap install mysql-workbench-community --edge
snap connect mysql-workbench-community:password-manager-service 
snap connect mysql-workbench-community:ssh-keys

Install from APT repository

wget https://repo.mysql.com//mysql-apt-config_0.8.32-1_all.deb -P /tmp/
sudo dpkg -i /tmp/mysql-apt-config_*_all.deb

sudo apt-get update

sudo apt-get install mysql-workbench-community

# cat /etc/apt/sources.list.d/mysql.list 
### THIS FILE IS AUTOMATICALLY CONFIGURED ###
# You may comment out entries below, but any other modifications may be lost.
# Use command 'dpkg-reconfigure mysql-apt-config' as root for modifications.
deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/ubuntu/ jammy mysql-apt-config
deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/ubuntu/ jammy mysql-8.0
deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/ubuntu/ jammy mysql-tools
#deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/ubuntu/ jammy mysql-tools-preview
deb-src [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/ubuntu/ jammy mysql-8.0

Links
https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/

https://raw.githubusercontent.com/panticz/installit/master/install.mysql-workbench.sh

https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/
https://dev.mysql.com/downloads/workbench/

dpkg -i mysql-workbench-community_8.0.26-1ubuntu21.04_amd64.deb
sudo apt install -y libzip4 libmysqlclient21 libproj19 libzip4 mysql-common proj-data

# test
cat < /etc/apt/sources.list.d/mysql.list
deb http://repo.mysql.com/apt/${ID}/ $(lsb_release -cs) mysql-apt-config
deb http://repo.mysql.com/apt/${ID}/ $(lsb_release -cs) workbench-8.0
EOF

# fix utopic ?
sed -i 's|utopic|trusty|g' /etc/apt/sources.list.d/mysql.list

apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 5072E1F5

sudo apt-get update

debconf-set-selections <<\EOF
mysql-apt-config mysql-apt-config/select-workbench select workbench-6.2
EOF

sudo apt-get install -y mysql-apt-config

# sudo apt-get install libmysqlclient18
sudo apt-get install -y mysql-workbench-community

# test 2
# dpkg --force-all
# sudo apt-get install libaio1
# sudo apt-get install libcairo2

Install Jameica + Hibiscus online banking

Jameica + Hibiscus with PayPal
https://hibiscus-mashup.derrichter.de/index.php/download

wget https://hibiscus-setup.derrichter.de/Jameica-Hibiscus_Linux_x64-Installer.run -qO /tmp/Jameica-Hibiscus_Linux_x64-Installer.run
chmod +x /tmp/Jameica-Hibiscus_Linux_x64-Installer.run
/tmp/Jameica-Hibiscus_Linux_x64-Installer.run
rm /tmp/Jameica-Hibiscus_Linux_x64-Installer.run

[embed_url: https://raw.githubusercontent.com/panticz/installit/master/install.hibiscus.sh]

Ansible playbook

https://github.com/panticz/ansible/tree/master/roles/hibiscus
- hosts: localhost
  roles:
    - hibiscus

PayPal account
https://www.paypal.com/businessprofile/mytools/apiaccess/firstparty/signature
https://hibiscus-mashup.derrichter.de/index.php/faq/79-hibiscus-mashup/96-paypal-api#api-signaturdaten-api-benutzername-und-api-unterschrift-selbst-manuell-in-hibiscus-eintragen

Links
https://www.willuhn.de/wiki/doku.php?id=support:ubuntu_18.04_64bit
https://wiki.ubuntuusers.de/Hibiscus/
http://www.willuhn.de/products/jameica/download.php
http://www.willuhn.de/products/hibiscus/download.php
https://www.willuhn.de/wiki/doku.php?id=support:bezugsquellen
http://www.heise.de/download/linux/office/finanzsoftware/homebanking-50003505037/

Update Mellanox firmware under Ubuntu

Install Driver
http://www.panticz.de/mellanox/install-dirver

Install MFT
http://www.panticz.de/install-mellanox-mft

Get NIC info

# get controller info
for MST in $(mst status | grep "mst" | cut -d" " -f1); do
    flint -d ${MST} query #| egrep "FW Version|UEFI|PSID"
    echo
done

# get board id for update
for MST in $(ls /dev/mst/*); do
    echo ${MST}
    flint -d ${MST} query | grep PSID | cut -d":" -f2 | tr -d ' '
    echo
done

# reset parameter
for MST in $(ls /dev/mst/*); do
    mlxconfig -y -d ${MST} reset
    echo
done

Get cable statistics
https://www.mellanox.com/related-docs/MFT/MFT_user_manual_4_8_0.pdf

mst start
mst cable add
mlxcables

mget_temp -d /dev/mst/mt4117_pciconf0
mlxcables -d mt4117_pciconf0_cable_0 -q
mlxcables -d mt4117_pciconf0_cable_0 --read_all_regs
mlxcables -d mt4117_pciconf0_cable_0 --DDM

Links
http://www.mellanox.com/page/firmware_HCA_FW_identification - Firmware Support and Downloads - Identifying Adapter Cards
http://www.mellanox.com/page/firmware_table_IBM
http://www.mellanox.com/page/firmware_HCA_FW_update
http://www.mellanox.com/page/firmware_NIC_FW_update
http://www.mellanox.com/content/pages.php?pg=firmware_HCA_FW_update
http://www.mellanox.com/pdf/MFT/ESXi_bootable_mst_README.txt
http://www.mellanox.com/page/products_dyn?product_family=27
http://www.mellanox.com/page/products_dyn?product_family=26&mtag=linux_sw_drivers
http://www.mellanox.com/page/infiniband_cards_overview
http://www.mellanox.com/page/firmware_table_ConnectX2EN
http://www.mellanox.com/content/pages.php?pg=firmware_HCA_FW_identification
http://www.mellanox.com/content/pages.php?pg=management_tools&menu_section=34
http://packages.ubuntu.com/search?searchon=names&keywords=libmlx

Linpack under Ubuntu / Linux

Check latest LINPACK version
https://software.intel.com/en-us/articles/intel-mkl-benchmarks-suite

# https://software.intel.com/sites/default/files/managed/cc/19/l_mklb_p_2019.6.005.tgz

configure parameter

export MKL_DYNAMIC=false
export OMP_NUM_THREADS=4

Run LINPACK

wget https://raw.githubusercontent.com/panticz/scripts/master/run_linpack.sh -qO- | bash

[embed_url: https://raw.githubusercontent.com/panticz/scripts/master/run_linpack.sh]

Install LINPACK
[embed_url: https://raw.githubusercontent.com/panticz/installit/master/install.linpack.sh]

Get CPU info

CPU=$(cat /proc/cpuinfo | grep "model name" | tail -1)
COUNT=$(cat /proc/cpuinfo | grep processor | wc -l)

echo "
CPU   : ${CPU}
COUNT : ${COUNT}
"

Links
http://www.roylongbottom.org.uk/linpack%20results.htm