darKonsole

FIX Ubuntu LVM : extend volume - Duplicate UUID of disk

isach_xx@yahoo.com (sakti) — Sun, 18 Dec 2022 13:52:00 +0700

-- problem --

while you wanna extend your vg to bigger size, and you find an error like this bellow, then we probably in the same server of problem.

root@darKonsole:~# lvextend -l +100%FREE /dev/mapper/ubuntu--vg-ubuntu--lv
WARNING: Not using lvmetad because duplicate PVs were found.
WARNING: Use multipath or vgimportclone to resolve duplicate PVs?
WARNING: After duplicates are resolved, run "pvscan --cache" to enable lvmetad.
WARNING: PV MHz3Ac-7ShK-2j8s-6u58-dnpf-1rrC-e3q4Kc on /dev/sda3 was already found on /dev/md126p3.
WARNING: PV MHz3Ac-7ShK-2j8s-6u58-dnpf-1rrC-e3q4Kc prefers device /dev/md126p3 because device is used by LV.
Size of logical volume ubuntu-vg/ubuntu-lv changed from <112.52 GiB (28805 extents) to <225.04 GiB (57610 extents).
Cannot update volume group ubuntu-vg with duplicate PV devices.

in my case the problem exist on ubuntu 18.4 distro, using lvm . DellEMC poweredge T40 with raid1

-- root couse --

As the message that mentioned on error command, we figure it out that UID of pv are duplicate.
maked sure with this command :

root@darKonsole:~# lsblk -f
NAME                        FSTYPE          LABEL UUID                                   MOUNTPOINT
sda                         isw_raid_member
├─sda1                      vfat                  ADB1-9283
├─sda2                      ext4                  37eb5c71-bf90-4580-9f99-65db5a549521
├─sda3                      LVM2_member           MHz3Ac-7ShK-2j8s-6u58-dnpf-1rrC-e3q4Kc
└─md126
├─md126p1                 vfat                  ADB1-9283                              /boot/efi
├─md126p2                 ext4                  37eb5c71-bf90-4580-9f99-65db5a549521   /boot
└─md126p3                 LVM2_member           MHz3Ac-7ShK-2j8s-6u58-dnpf-1rrC-e3q4Kc
    └─ubuntu--vg-ubuntu--lv ext4                  4f96b7ce-67a3-483a-bc83-c0e5bbf93bcd   /
sdb                         isw_raid_member
└─md126
├─md126p1                 vfat                  ADB1-9283                              /boot/efi
├─md126p2                 ext4                  37eb5c71-bf90-4580-9f99-65db5a549521   /boot
└─md126p3                 LVM2_member           MHz3Ac-7ShK-2j8s-6u58-dnpf-1rrC-e3q4Kc
    └─ubuntu--vg-ubuntu--lv ext4                  4f96b7ce-67a3-483a-bc83-c0e5bbf93bcd   /
sr0

hope you got what i mean .. :)

-- solusion and fixing --

we have the problem and we know the root couse, now we go to the trying for the solusion.
and the solusion we try is to add filter in lvm.conf to not scan the disk that we not used.

edit lvm.conf under etc and add filter in general section .

root@darKonsole:~# vi /etc/lvm/lvm.conf

#penambahan
filter = [ "a/dev/mapper/.*/", "r/dev/sd.*/" ]

note :

- Don't forget to include anything else that should be there (e.g. maybe dda1 was the internal disk on which my LVM for root and other filesystems existed, for mine no need).

fyi :

- This setting accepts all /dev/mapper/* devices and rejects all the /dev/sd* devices while scanning the LVM disks. Refer to the LVM2 user guide for further details. If the root device is also a multipathed LVM device, then make change(s) to /etc/lvm/lvm.conf before creating a new initrd image. Where “multipath on root” is required, the lvm.conf is needed in the initrd image, which requires the initrd to be re-made.

save the config and : Stop any applications/services that access LVM managed devices/filesystems, Unmount all LVM-based filesystems, Deactivate all Volume Groups, rescan vg, reactivate bla bla bla
simply task, mine reboot the server

and .........

result :
login to server and check the UUID of the volume disk

Welcome to Ubuntu 18.04.6 LTS (GNU/Linux 5.4.0-132-generic x86_64)

* Documentation: https://help.ubuntu.com
* Management:     https://landscape.canonical.com
* Support:        https://ubuntu.com/advantage

System information as of Tue Nov 29 09:17:58 UTC 2022

System load: 1.35               Processes:           207
Usage of /:   7.3% of 110.19GB   Users logged in:     1
Memory usage: 3%                 IP address for eno1: xx.xx.xx.xx
Swap usage:   0%

0 updates can be applied immediately.
Last login: Tue Nov 29 08:48:15 2022 from xx.xx.xx.xx
sama@darKonsole:~$ lsblk -f
NAME                        FSTYPE          LABEL UUID                                   MOUNTPOINT
sda                         isw_raid_member
└─md126
├─md126p1                 vfat                  ADB1-9283                              /boot/efi
├─md126p2                 ext4                  37eb5c71-bf90-4580-9f99-65db5a549521   /boot
└─md126p3                 LVM2_member           MHz3Ac-7ShK-2j8s-6u58-dnpf-1rrC-e3q4Kc
    └─ubuntu--vg-ubuntu--lv ext4                  4f96b7ce-67a3-483a-bc83-c0e5bbf93bcd   /
sdb                         isw_raid_member
└─md126
├─md126p1                 vfat                  ADB1-9283                              /boot/efi
├─md126p2                 ext4                  37eb5c71-bf90-4580-9f99-65db5a549521   /boot
└─md126p3                 LVM2_member           MHz3Ac-7ShK-2j8s-6u58-dnpf-1rrC-e3q4Kc
    └─ubuntu--vg-ubuntu--lv ext4                  4f96b7ce-67a3-483a-bc83-c0e5bbf93bcd   /
sr0
sama@darKonsole:~$ sudo -i
root@darKonsole:~# lsblk -f
NAME                        FSTYPE          LABEL UUID                                   MOUNTPOINT
sda                         isw_raid_member
└─md126
├─md126p1                 vfat                  ADB1-9283                              /boot/efi
├─md126p2                 ext4                  37eb5c71-bf90-4580-9f99-65db5a549521   /boot
└─md126p3                 LVM2_member           MHz3Ac-7ShK-2j8s-6u58-dnpf-1rrC-e3q4Kc
    └─ubuntu--vg-ubuntu--lv ext4                  4f96b7ce-67a3-483a-bc83-c0e5bbf93bcd   /
sdb                         isw_raid_member
└─md126
├─md126p1                 vfat                  ADB1-9283                              /boot/efi
├─md126p2                 ext4                  37eb5c71-bf90-4580-9f99-65db5a549521   /boot
└─md126p3                 LVM2_member           MHz3Ac-7ShK-2j8s-6u58-dnpf-1rrC-e3q4Kc
    └─ubuntu--vg-ubuntu--lv ext4                  4f96b7ce-67a3-483a-bc83-c0e5bbf93bcd   /
sr0

try to extend the lvm

now we have to extend the LV capacity of ubuntu_lv

root@darKonsole:~# lvextend -l +100%FREE /dev/mapper/ubuntu--vg-ubuntu--lv
Size of logical volume ubuntu-vg/ubuntu-lv changed from <112.52 GiB (28805 extents) to <225.04 GiB (57610 extents).
Logical volume ubuntu-vg/ubuntu-lv successfully resized.

root@darKonsole:~# df -h
Filesystem                         Size Used Avail Use% Mounted on
udev                               7.7G     0 7.7G   0% /dev
tmpfs                              1.6G 1.5M 1.6G   1% /run
/dev/mapper/ubuntu--vg-ubuntu--lv 111G 8.1G   97G   8% /
tmpfs                              7.8G 100K 7.8G   1% /dev/shm
tmpfs                              5.0M     0 5.0M   0% /run/lock
tmpfs                              7.8G     0 7.8G   0% /sys/fs/cgroup
/dev/md126p2                       974M 169M 739M 19% /boot
/dev/md126p1                       511M 4.5M 507M   1% /boot/efi
tmpfs                              1.6G 8.0K 1.6G   1% /run/user/1000

root@darKonsole:~# resize2fs -p /dev/mapper/ubuntu--vg-ubuntu--lv
resize2fs 1.44.1 (24-Mar-2018)
Filesystem at /dev/mapper/ubuntu--vg-ubuntu--lv is mounted on /; on-line resizing required
old_desc_blocks = 15, new_desc_blocks = 29
The filesystem on /dev/mapper/ubuntu--vg-ubuntu--lv is now 58992640 (4k) blocks long.

VOILA.....

root@darKonsole:~# df -h
Filesystem                         Size Used Avail Use% Mounted on
udev                               7.7G     0 7.7G   0% /dev
tmpfs                              1.6G 1.5M 1.6G   1% /run
/dev/mapper/ubuntu--vg-ubuntu--lv 221G 8.1G 203G   4% /
tmpfs                              7.8G 100K 7.8G   1% /dev/shm
tmpfs                              5.0M     0 5.0M   0% /run/lock
tmpfs                              7.8G     0 7.8G   0% /sys/fs/cgroup
/dev/md126p2                       974M 169M 739M 19% /boot
/dev/md126p1                       511M 4.5M 507M   1% /boot/efi
tmpfs                              1.6G 8.0K 1.6G   1% /run/user/1000
root@darKonsole:~#

/* Your warranty is now void. *

* I am not responsible for bricked devices, dead service / server

* thermonuclear war, or you getting fired because the app/service failed.

*Please do some research if you have any concerns about this.

* Do at your own risk

Ubuntu SSH Authentication with TACACSGUI

isach_xx@yahoo.com (sakti) — Tue, 1 Nov 2022 11:14:00 +0700

--Assumptions--

what is tacacsgui??? find out in this link : tacacsgui.com

how to install and how to administering tacac not include - explore by yourself

in this scenario we will use tacacs as authentication for ssh of ubuntu server ( hope you understand what i mean. ) then we can go ...

--preparation--

--tacacs

* device already add on tacacsgui including secret key

* and user also

--ubuntu

* Download the tacacs+ PAM module from SourceForge. or github

* Install pam development package for your linux distro.

RHEL / CentOS call it pam-devel; Debian /Ubuntu call it libpam-dev (a virtual package name for libpam0g-dev).

* Un-tar the tacacs+ pam module into a temporary working directory (tar xvfz tacplus-1.6.1.tar.gz)

* cd into the new folder created by tar.

* As root: auto.sh ; ./configure; make; and make install

* make sure no error on installation of PAM module

--implement--

Configure sshd config with editing /etc/pam.d/sshd, and add this line as the first entry in the file:

# PAM configuration for the Secure Shell service
auth include tacacsauth

Then create a new file called /etc/pam.d/tacacsauth :

auth sufficient /usr/local/lib/security/pam_tacplus.so debug server=x.x.x.x secret=1234 login=login prompt=: service=ssh protocol=tcp
account sufficient /usr/local/lib/security/pam_tacplus.so debug server=x.x.x.x secret=1234 service=ssh protocol=tcp
password required /usr/local/lib/security/pam_tacplus.so debug server=x.x.x.x secret=1234

*note : x.x.x.x is your tacacsgui IP

--final--

restart ssh service

systemctl restart sshd.service

create a local linux user account that matches the tacacsgui username for all required users.

The users can optionally use passwd to set their local password to whatever they like as a last resort; however,

if they set a local password, they will be able to login locally at any time without tacacs+ even if the service is available.

sudo adduser jajal

--test and drive--

* do with your own risk.....

script : kill slow MySQL queries

isach_xx@yahoo.com (sakti) — Fri, 28 Oct 2022 11:08:00 +0700

--muqodimah---

Hello everyone, this time i will share simple script to kill long query of MySQL.

Based on of my experience, Long-running MySQL queries can bring down the whole database even before you react. One of the ways to keep the application running and debug long running query issues is by monitoring, logging and killing them.

This will give a chance to keep application running while you debug to find out the issues.

please use wisely.

--1--

this script is to view how many query is runing

=======================

#!/bin/bash
#brekele.inc
#by Darkonsole
#^_^
i="0"
mysql -u root -pYOURPASSWORD -e 'show processlist\G' | egrep -b5 'Time: [1-9]{3,10}' | grep 'Id:'| cut -d':' -f2 | sed 's/^ //'| while read id
do
echo " $id" i=$[$i+1]
done
echo "jumlah Query lama $i"

sama@darKonsole:/var/www/kill$ ./mysql-show.sh
jumlah Query lama 0

--2--

now the importing thing, kill that damn query ( be brave .. )

------------

#!/bin/bash
#brekele.inc
#by Darkonsole
#^_^
mysql -u root -pYOURPASSWORD -e 'show processlist\G' | egrep -b5 'Time: [1-9]{3,10}' | grep 'Id:'| cut -d':' -f2 | sed 's/^ //'| while read id
do
echo $id;
mysql -u root -pYOURPASSWORD -e "kill $id;"
done

--end of story--

/* Your warranty is now void. *

* I am not responsible for bricked devices, dead service,

* thermonuclear war, or you getting fired because the app failed.

*Please do some research if you have any concerns about this.

* Do at your own risk

SSL certificate Verification

isach_xx@yahoo.com (sakti) — Mon, 12 Jul 2021 15:00:00 +0700

this is a simple action that make simple thing become nightmare....when you late to run on your environment.

use this command to check the certificate. is the certificate good or bad ( this is usualy if you bouht a certificate form ~~suck~~ sll-SHOP )

openssl verify -CAfile CARoot.crt -untrusted CAIntermediate.crt yourCertificate.crt

just run it to make sure that your certificate is OK.

#a simple thing can become a nightmare if you don't do it in the right time.

ONLINE DISK Migration / mirror of AIX server

isach_xx@yahoo.com (sakti) — Wed, 24 Mar 2021 10:20:00 +0700

Hello everyone... not write down an article for long time with no reason, now i present to you an article about migrating disk with mirror method. this method is used on AIX 6.1 using SAN storage as it's disk. we will mirror disk on SAN 1 to disk on SAN 2
and ones again, for your information, new disk we call hdisk1 and present disk we call hdisk0

this environment is allready installed with Multipath driver from storage vendor like EMC.AIX.5.3.1.0-xtremIO-driver-mpio (installaing this driver need AIX reboot to detect multipath ) .

let's start it

--1--
add new disk to existing VG
[darkonsole@AIX_LPAR]/> extendvg db2vg hdisk1

--2--
simpli mirror the disk with this following command
[darkonsole@AIX_LPAR]/> mirrorvg -S -m db2vg hdisk1

Use The ‘-S’ option (Uppercase ‘S’) for Background sync

If all looks good at this point and the sanity checks are good, mirror is working.
You need to use the force option when bringing it into rootvg.

[darkonsole@AIX_LPAR]/> extendvg -f rootvg hdisk1
[darkonsole@AIX_LPAR]/> mirrorvg rootvg hdisk1

--3--
chek mirror progres using this command
[darkonsole@AIX_LPAR]/> lsvg db2vg | grep STALE

or with script :

#!/usr/bin/ksh93
### W.M. Duszyk, 3/2/12
### AVandewerdt 01/05/14
### show percentage of re-mirrored PPs in a volume group
[[ $# < 1 ]] && { print "Usage: $0 vg_name"; exit 1; }
vg=$1
printf "Volume Group $vg has ";lsvg -L $vg | grep 'ACTIVE PVs:' | awk '{printf $3}';printf " copies "
Stale=`lsvg -L $vg | grep 'STALE PPs:' | awk '{print $6}'`
[[ $Stale = 0 ]] && { print "and is fully mirrored."; exit 2; }
Total=`lsvg -L $vg | grep 'TOTAL PPs:' | awk '{print $6}'`
PercDone=$(( 100 - $(( $(( Stale * 50.0 )) / $Total )) ))
echo "and is mirrored $PercDone%."
exit 0

--4--
when it'a all done, then we can un-mirro and remove old disk

for un-mirroring disk and remove from VG, run bellow command

[darkonsole@AIX_LPAR]/> unmirrorvg db2vg hdisk0
0516-1804 chvg: The quorum change takes effect immediately.
[darkonsole@AIX_LPAR]/> lspv -l hdisk0
[darkonsole@AIX_LPAR]/> reducevg db2vg hdisk0

then remove the disk from server

[darkonsole@AIX_LPAR]/># rmdev -dl hdisk0

all done now. and you can go on with your life again

[Solved] Disk space eaten by UNKNOWN ( Culprit Process )

isach_xx@yahoo.com (sakti) — Thu, 12 Mar 2020 15:23:00 +0700

When suddenly all the available disk space on / has disappeared. If i make room in the disk (by deleting ~50GB of stuff, for example), after a few minutes I am back to 0 available disk space (according to df).
Clearly, some process is eating up disk space at a rapid rate, but I can't figure out what it is.
One thing is certain, though: whatever it is, it must be creating many small files, because there are no files bigger than 10GB on the disk, and all the ones bigger than 1GB are much older than today.

And the question is ""How can I find what's eating up disk space?"
[root@valuecard mnt]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_valuecard-lv_root 50G 47G 488M 99% /
tmpfs 2.0G 0 2.0G 0% /dev/shm /dev/mapper/ddf1_4c5349202020202080862682000000004711471100000a28p1 485M 63M 397M 14% /boot
/dev/mapper/vg_valuecard-lv_home 175G 24G 143G 14% /home

Root partitiion is mesh up... , then I run du to find what is eating my disk space

[root@valuecard /]# du -h --max-depth=1
. 210M
lib 14M
./sbin 0
./misc 188K
./dev 4.0K
./srv
du: cannot access `./proc/25765/task/25765/fd/4': No such file or directory
du: cannot access `./proc/25765/task/25765/fdinfo/4': No such file or directory
du: cannot access `./proc/25765/fd/4': No such file or directory
du: cannot access `./proc/25765/fdinfo/4': No such file or directory 0
./proc 4.0K
./home 144K
./root 53M
./boot 7.3M
./bin 6.4M
./share 0
./sys 4.2G
./var 16K
./lost+found 20K
./tmp 0
./selinux 4.0K
./cgroup 1.7G
./usr 87M
./mnt 0
./net 29M
./etc 8.0K
./opt 30G .

If the calculation betwen free space and du command not match, nah that mean You are dealing with deleted files, that is why du does not register used space, but df does.
Deleted files only disappear after the owner process is stopped; they remain in use while that does not happen. and it's called "Culprit process".

So to find the culprit process, I recommend you doing this command: lsof -nP | grep '(deleted)'

[root@valuecard mnt]# lsof -nP | grep '(deleted)'
php-fpm 2175 root txt REG 253,3 4017744 2108436 /usr/sbin/php-fpm (deleted)
php-fpm 2175 root 4u REG 253,3 0 1966095 /tmp/.ZendSem.ceje6o (deleted)
php-fpm 2176 data txt REG 253,3 4017744 2108436 /usr/sbin/php-fpm (deleted)
php-fpm 2176 data 4u REG 253,3 0 1966095 /tmp/.ZendSem.ceje6o (deleted)
php-fpm 2177 data txt REG 253,3 4017744 2108436 /usr/sbin/php-fpm (deleted)
php-fpm 2177 data 4u REG 253,3 0 1966095 /tmp/.ZendSem.ceje6o (deleted)
php-fpm 2178 data txt REG 253,3 4017744 2108436 /usr/sbin/php-fpm (deleted)
php-fpm 2178 data 4u REG 253,3 0 1966095 /tmp/.ZendSem.ceje6o (deleted)
php-fpm 2179 data txt REG 253,3 4017744 2108436 /usr/sbin/php-fpm (deleted)
php-fpm 2179 data 4u REG 253,3 0 1966095 /tmp/.ZendSem.ceje6o (deleted)
php-fpm 2180 data txt REG 253,3 4017744 2108436 /usr/sbin/php-fpm (deleted)
php-fpm 2180 data 4u REG 253,3 0 1966095 /tmp/.ZendSem.ceje6o (deleted)
certmonge 2239 root txt REG 253,3 245668 2108803 /usr/sbin/certmonger (deleted)
mysqld 8264 mysql 1w REG 253,3 40960 2490572 /var/log/mysqld.log-20170930 (deleted)
mysqld 8264 mysql 2w REG 253,3 40960 2490572 /var/log/mysqld.log-20170931 (deleted)
mysqld 8264 mysql 5u REG 253,3 0 1966083 /tmp/ibH9SS9X (deleted)
mysqld 8264 mysql 6u REG 253,3 0 1966084 /tmp/ibBhluEV (deleted)
mysqld 8264 mysql 7u REG 253,3 0 1966085 /tmp/ibPrt68S (deleted)
mysqld 8264 mysql 8u REG 253,3 118784 1966086 /tmp/ib1ncybO (deleted)
mysqld 8264 mysql 11w REG 253,3 42880016330 2490615 /var/log/mysql-slow.log-20170928 (deleted)
mysqld 8264 mysql 12u REG 253,3 0 1966087 /tmp/ibdtjnTL (deleted)
httpd 11609 root 72u REG 253,3 0 1966091 /tmp/.ZendSem.KD4Via (deleted)
httpd 18913 data 72u REG 253,3 0 1966091 /tmp/.ZendSem.KD4Via (deleted)

as you can see, mysql-slow.log look like with big size, and all you can do is kill that process

--kill the proses--
[root@valuecard mnt]# kill -9 8264

--result--
[root@valuecard mnt]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_valuecard-lv_root 50G 6.4G 41G 14% /
tmpfs 2.0G 0 2.0G 0% /dev/shm /dev/mapper/ddf1_4c5349202020202080862682000000004711471100000a28p1 485M 63M 397M 14% /boot
/dev/mapper/vg_valuecard-lv_home 175G 24G 143G 14% /home

and everyone is happy... ^_^

[SOLVED] Failed to update Group Policy on Windows 10

isach_xx@yahoo.com (sakti) — Wed, 10 Oct 2018 10:55:00 +0700

Once upon a time, on my Windows 10 computer, I found Group Policy is not being applied anymore. If I ran group policy update on a administrative command shell, I get this:

PS C:\WINDOWS\system32> gpupdate /force
Updating policy…
Computer Policy update has completed successfully.
User Policy could not be updated successfully. The following errors were encountered:

The processing of Group Policy failed. Windows could not determine if the user and computer accounts are in the same forest. Ensure the user domain name matches the name of a trusted domain that resides in the same forest as the computer account.

To diagnose the failure, review the event log or run GPRESULT /H GPReport.html from the command line to access information about Group Policy results.

So after some research I found the issue and fixed it.
and The solution is :

Make the freaking NETLOGON service to start automatically and start the service.

and done... *$*&^%*#(#*#^@*@(@)

[ FIX ] "Failed to validate certificate, The application will not be executed." on Java

isach_xx@yahoo.com (sakti) — Tue, 21 Aug 2018 17:22:00 +0700

Problem :
Unable to launch Java applications with error "Failed to validate certificate, The application will not be executed." error.
Failed to validate certificate,
The application will not be executed.
sun.security.validator.ValidatorException: PKIX path validation failed: java.security.cert.CertPathValidatorException: algorithm constraints check failed
at sun.security.validator.PKIXValidator.doValidate(Unknown Source)
at sun.security.validator.PKIXValidator.engineValidate(Unknown Source)
in this case i run for brocade san switch

Description:
Starting with Java/JRE 7u40, Java requires the application (the jar file executed via jnlp) to be signed by a certificate with a minimum public key size of 1024 bits.
At this time the Live Health jnlps are signed with a certificate of less than 1024 bits (we use 512 bits), causing a security validation failure.

solution :

Changing the value 1024 to 256 solves the issue in eHealth Live clients (as they are currently signed by a certificate with a 512-bit key). This change in java.security has to be done by a user with the administrator role, and java must be restarted in order for changes to take effect.

- edit java security @ : C:\Program Files (x86)\Java\jre1.8.0_181\lib\security\java.security

jdk.certpath.disabledAlgorithms=MD2, MD5, SHA1 jdkCA & usage TLSServer, \
RSA keySize < 1024, DSA keySize < 1024, EC keySize < 224

to :

jdk.certpath.disabledAlgorithms=MD2, MD5, SHA1 jdkCA & usage TLSServer, \
RSA keySize < 256, DSA keySize < 256, EC keySize < 224

==> tested on windows 10 with

install oci 8 /oci8 on centos 7 ( allmost all centos can use this how to ^_^)

isach_xx@yahoo.com (sakti) — Wed, 20 Jun 2018 16:35:00 +0700

first :
install oracle lib on your server

# rpm -Uvh oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64.rpm
# rpm -Uvh oracle-instantclient12.1-devel-12.1.0.1.0-1.x86_64.rpm

then run this command to install oci8

pecl install oci8

Enable the PHP OCI8 extension by create/editing /etc/php.d/oci8.ini
extension=oci8.so

then restart httpd service by :
systemctl restart httpd

and now you can check via phpinfo from browser or via command with like this screenshot :

and yeah as simple as that ^_^

.:-TroubleShoot-:.

--Error 1--

running: make

/bin/sh /var/tmp/pear-build-root8YDCsA/oci8-2.2.0/libtool --mode=compile cc -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root8YDCsA/oci8-2.2.0/include -I/var/tmp/pear-build-root8YDCsA/oci8-2.2.0/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/12.1/client64 -DHAVE_CONFIG_H -g -O2 -c /var/tmp/oci8/oci8.c -o oci8.lo

libtool: compile: cc -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root8YDCsA/oci8-2.2.0/include -I/var/tmp/pear-build-root8YDCsA/oci8-2.2.0/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/12.1/client64 -DHAVE_CONFIG_H -g -O2 -c /var/tmp/oci8/oci8.c -fPIC -DPIC -o .libs/oci8.o

In file included from /var/tmp/oci8/oci8.c:49:0:

/var/tmp/oci8/php_oci8_int.h:46:29: fatal error: oci8_dtrace_gen.h: No such file or directory

#include "oci8_dtrace_gen.h"

compilation terminated.

make: *** [oci8.lo] Error 1

ERROR: `make' failed

---Solusion--

[root@localhost mnt]# export PHP_DTRACE=yes

--Error 2--

configure: error: Cannot find sys/sdt.h which is required for DTrace support

ERROR: `/var/tmp/oci8/configure --with-php-config=/usr/bin/php-config --with-oci8' failed

--Solusion--

install this package

[root@localhost mnt]# yum install systemtap-sdt-devel

How to Expand a.k.a Extend filesystem in aix

isach_xx@yahoo.com (sakti) — Wed, 8 Nov 2017 15:56:00 +0700

it's will be really simple to do that, ofcourse if there are space available on the volume group ( vg )
--sample-
this is the sample for our experimental learning :

bash-3.2# df -g
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           1.50      0.00  100%     4495    50% /
/dev/hd2           4.50      1.35   70%    50922    14% /usr
/dev/hd9var        2.75      1.50   46%     8420     3% /var
/dev/hd3           2.25      1.94   14%      890     1% /tmp

and for this sample also we already know that /usr is on rootvg

bash-3.2# lsvg -l rootvg
rootvg:
LV NAME             TYPE       LPs     PPs     PVs  LV STATE      MOUNT POINT
hd5                 boot       1       1       1    closed/syncd  N/A
hd6                 paging     62      62      1    open/syncd    N/A
hd8                 jfs2log    1       1       1    open/syncd    N/A
hd4                 jfs2       6       6       1    open/syncd    /
hd2                 jfs2       30      30      1    open/syncd    /usr
hd9var              jfs2       11      11      1    open/syncd    /var

and for some kind of reason we need to extend /usr partition to 2GB or more.

--the story--
ok..... , for the first time we should do is make sure that space is available. for that reason you need to run this command on your console :

bash-3.2# lsvg -L rootvg
VOLUME GROUP:       rootvg                   VG IDENTIFIER:  00f7590e00004c000000013f5ad3954d
VG STATE:           active                   PP SIZE:        256 megabyte(s)
VG PERMISSION:      read/write               TOTAL PPs:      1092 (279552 megabytes)
MAX LVs:            256                      FREE PPs:       956 (244736 megabytes)
LVs:                13                       USED PPs:       136 (34816 megabytes)
OPEN LVs:           12                       QUORUM:         2 (Enabled)
TOTAL PVs:          2                        VG DESCRIPTORS: 3
STALE PVs:          0                        STALE PPs:      0
ACTIVE PVs:         2                        AUTO ON:        yes
MAX PPs per VG:     32512
MAX PPs per PV:     1016                     MAX PVs:        32
LTG size (Dynamic): 1024 kilobyte(s)         AUTO SYNC:      no
HOT SPARE:          no                       BB POLICY:      relocatable
PV RESTRICTION:     none                     INFINITE RETRY: no

--the command--
nah... all preparation is complet and all what we need is here, so let start to extend /usr filesystem with this command

chfs -a size=+2G /usr

that's it........ only that command ... OK......
now test on your own box

What those mean

The “M” stands for megabytes
The “G” stands for gigabytes
The “+” is relative sizing: change the current amount by adding this much
Without the “+” is absolute sizing: change the current amount TO this much
NOTE: You can use “-” to decrease a filesystem size. Generally speaking for LVs, it is harder to shrink a filesystem. Sometimes it cannot be done while the filesystem is mounted, and sometimes depending on fragmentation it may not be able to be done at all. I have found AIX to be more robust in this department than various Linux LVM implementations. Generally speaking, though, when you increase your filesystem size, it is best to think of it as permanent .. (for the most part).

*note : do with your own risk.. ^_^

BASH: Handling File Names With Spaces on loop script with bash

isach_xx@yahoo.com (sakti) — Tue, 17 Oct 2017 11:31:00 +0700

--one upon a time--
if you try to process a for loop on file name with spaces in them, you are going to have some problem.
By default, the shell splits the output of a command on spaces, tabs, and newlines. it's called IFS variable

--example--
we have list of file on foltest:

/some/where/aku hebat
/some/where/cema ngat

and than the script is:

#!/bin/bash
#darKonsole
#^_^
NAMES=`cat /some/where/foltest`
for file in $NAMES
do
find /ifs/admedika/ftp/FTP/$file/ -type f -exec ls {} \;
done

--theory jowo--
the long long explanation is To figure out what to set file to, the shell has to take the output of find and interpret it somehow, otherwise file would just be the entire output of find.

The shell reads the IFS variable, which is which is set to by default.

Then it looks at each character in the output of find. As soon as it sees any character that's in IFS, it thinks that marks the end of the file name, so it sets file to whatever characters it saw until now and runs the loop. Then it starts where it left off to get the next file name, and runs the next loop, etc., until it reaches the end of output.

To tell it to only split the input on newlines, you need to do
IFS=$(echo -en "\n\b")
before your for ... find command.

That sets IFS to a single newline, so it only splits on newlines, and not spaces and tabs as well.
That is probably enough to get your script working, but if you're interested to handle some other corner cases properly, read on...

--implementasi--
now lets take the theory to the reality..., are you ready ????
this is the script we will got:

#!/bin/bash
#darKonsole
#^_^

#save default value IFS
darkIFS=$IFS
IFS=$(echo -en "\n\b")

NAMES=`cat ftpfoltest`
for i in $NAMES
do
find /ifs/admedika/ftp/FTP/$i/ -type f -exec ls {} \;
done

# restore $IFS
IFS=$darkIFS--note--

--note--
for good environment add default value of IFS to the some variable and than restore it back when the looping is done

Enable NFS Mount after Reboot on linux CentOS

isach_xx@yahoo.com (sakti) — Thu, 10 Aug 2017 15:12:00 +0700

perkiraan ilustrasi yang memungkinkan

-- pra-kata-kata --

unnecessary mukodimah that needed is telling that we need an opening ~~messege~~ message for opening article. and here we go i think it's enought for opening :D

--step one--

you need some .... yeah... you know what you need for comforting yourself. Back to topic, the real for what you need is some NFS server (nfs.server.com) or of course, and the client absolutly.

preparation complete and now lets go to next level of this article

--step two--

for this configuration, all you have to do is open your /etc/fstab file. and it's will be something like this :

# /etc/fstab
# Created by anaconda on Tue Apr 25 22:51:16 2017
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/VolGroup-LogVol01        /              ext4    defaults         1 1
UUID=dd89f8e6                        /boot          ext4    defaults         1 2
/dev/mapper/VolGroup-lv_swap         swap           swap    defaults         0 0
tmpfs                               /dev/shm        tmpfs   defaults         0 0
devpts                              /dev/pts        devpts  gid=5,mode=620   0 0
sysfs                               /sys            sysfs   defaults         0 0
proc                                /proc           proc    defaults         0 0
nfs.server.com:/data                /Data           nfs     defaults,_netdev 0 0

just focus on the last line, thas is sample of nfs mount that we need.

are we done here.... ??? no .. no... noo... we need to enable one more service to make our hard work done. the service is netfs and make sure that service is load on booting.

chkconfig netfs on

-- check $ jajal --

and the final is to test our config.... reboot the mechine a.k.a server, and se what happen next.. ^_^.

the point is "ndang di jajal dewe dewe ben dong gitu...."

-- penutupan --

secara algorithm,your mount boot process should be something like this:

- Automounter reads config on /etc/fstab

- Ignores /Data since it has _netdev option set

- Mounts all other filesystems

- Finishes mount jobs and allows system to continue booting

- Network comes up

- Service netfs started, and service netfs reads /etc/fstab and finds an nfs filesystem

- netfs mounts the /Data

* do with your own risk

RHCSA Pass... the exam.....................

isach_xx@yahoo.com (sakti) — Thu, 3 Mar 2016 10:17:00 +0700

Setelah perjuangan tiap malem jungkir balik mlumah mengkurep selama sepekan( lebay mode on), akhirnya lulus juga......

mayan buat menuh menuhin cv dan mumpung gratis gitu...

next step ....................... ???????

#dan akhirnya setelah 3 tahun gak posting, ada juga bahan postingan... :D

AIX Health Check - with nmon

isach_xx@yahoo.com (sakti) — Wed, 16 Oct 2013 10:51:00 +0700

ilustrasi

-- opening --
Lama gak ngeblog susah juga nyari kalimat enaknya. the point is how to collect data from aix. And tool used for this is "nmon".

--need--
basicly we need nmon of course, AIX, and anything that make you comfort :P

--1--
ok lets started, make script with this following command

#!/usr/bin/ksh

# brekele.inc

# ^_^
/usr/bin/nmon -s 300 -c 288 -fdTPAN -m /nmon_data
find /nmon_data -mtime +90 -type f -exec rm -f {} \;

and save it ( ex : nmon.sh )
--2--
first preparation done, now make it work. Make directory /nmon_data, give it "x" permission, done ?
the last add to crontab. ex every night

00 00 * * * sh  /mnt/nmon.sh > /dev/null 2>&1

done step one.

-- report--
download nmon analyzer from here and follow the intruction how to read it :P

-- check $ jajal --
monggo di coba sendiri - sendiri :D

* do with your own risk

swap on android

isach_xx@yahoo.com (sakti) — Sat, 6 Apr 2013 22:21:00 +0700

--why--
tinimbang ngenthong ra nggenah.... just trying improve performa on weak android :D
and do all this "tuto" with your own risk

-- needed--
- kernel support for swap ( if you don't have try to complie your kernel or find enother kernel that support it)
- rooted android
- and make it easy using adb command on your PC

most people make swap partition on their sdcard, and most people say's it slow and can reduce "sd card" life.
on mine, i use free space on /data partition ( have 1GB ) and create swap image in it and hope faster than on sdcard.

--creating swap image--
create swap image using dd command ( you can run this command on android or you can run faster on linux PC)

ok swap image created and formated as swap, push image to android phone ( /data/ ).

--turn on swap--
ok, swap allready on /data/swp.img. now turn it on with this command.

busybox swapon /data/swp.img

at this point swap is on ^_^

--bonus--
next let android automatic turn swap ON after reboot. in this case we need add script on init.d
this my simple script placed on /system/etc/init.d/91swapon

#!/system/bin/sh
# brekele.inc ^_^ 
#Init.d runing swap 

busybox swapon /data/swp.img

Set permission to init file with :

chmod 777 /system/etc/init.d/91swapon

test this script with reboot your device.

have fun.... :D

make it simple "Bash Script for Reverse Tethering android on linux mint "

isach_xx@yahoo.com (sakti) — Sun, 17 Feb 2013 13:16:00 +0700

-- alibi--
just make it simple as possible
base on this post

-- prepare--
* make sure your device connected to PC
* make sure adb command running properly
* and make usb tethering active on android

--1--
download script from here

--2--
you can disable data connection on your android first,or script will delete default gateway on android
extract and run it

--checking--
akses internet via your android

--note--
if data connection on android active, network service will auto reconect to provider internet and it will replace default gateway with provider gateway.
throught provider gateway mean reverse tethering fail

reverse tethering android on linux mint "Nadia"

isach_xx@yahoo.com (sakti) — Sat, 2 Feb 2013 09:44:00 +0700

--why--
if you want to connect your android to internet even if you doesn't have Data Package.

--info--
tested on linux mint 14 and maybe, it will be work on other linux distribution.

*note : kalo kopi sudah di bikin maka mari di lanjutkan.. :D

-- persiapan--
plug you phone's usb and enable usb tethering android in setting menu. This will assign an IP automatically when the device is added. bow check the IP address on both

PC/laptop

Android

-- on linux mint --
share your PC/laptop's internet connection, and make it as router with :

>$ sudo iptables -A POSTROUTING -t nat -j MASQUERADE
>$ sudo echo 1 > /proc/sys/net/ipv4/ip_forward

-- on android --
run this command to pass the data internet via PC/laptop

># route add default gw 192.168.42.105 dev usb0

then set you DNS to google dns

># setprop net.dns1 8.8.8.8

-- testing --

open browser and enjoy the show...

*note : this methode can download/install app from android market. if you want to install app, use other market app ( black market )

adb no permissions error on linux mint 14 "nadia"

isach_xx@yahoo.com (sakti) — Sat, 2 Feb 2013 08:35:00 +0700

when this happen :

Create a file named /etc/udev/rules.d/99-android.rules with the following contents (hex vendor numbers were taken from the vendor list page):
SUBSYSTEM=="usb", ATTRS{idVendor}=="0bb4", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0e79", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0502", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0b05", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="413c", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0489", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="091e", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="18d1", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0bb4", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="12d1", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="24e3", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="2116", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0482", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="17ef", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="1004", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="22b8", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0409", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="2080", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0955", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="2257", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="10a9", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="1d4d", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0471", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="04da", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="05c6", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="1f53", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="04e8", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="04dd", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0fce", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="0930", MODE="0666"
SUBSYSTEM=="usb", ATTRS{idVendor}=="19d2", MODE="0666"

or you can add "idVendor" with lsusb command

Bus 001 Device 005: ID 12d1:1021 Huawei Technologies Co., Ltd.
Bus 001 Device 004: ID 14cd:6600 Super Top USB 2.0 IDE DEVICE

Run the following commands (without the leading $):
$ sudo vi /etc/udev/rules.d/99-android.rules
$ sudo chmod 644 /etc/udev/rules.d/51-android.rules
$ sudo chown root. /etc/udev/rules.d/51-android.rules
$ sudo service udev restart
$ sudo killall adb

Disconnect the USB cable between the phone and the computer.
Reconnect the phone.
Run adb devices to confirm that now it has permission to access the phone.

Please note that it's possible to use , USER="$LOGINNAME" instead of , MODE="0666" in the .rules file, substituting $LOGINNAME for your login name, i.e. what id -nu prints.

"Your SIM card does not allow a connection to this network"

isach_xx@yahoo.com (sakti) — Wed, 30 Jan 2013 15:07:00 +0700

"Your SIM card does not allow a connection to this network"

when this aper on searching mobile network manualy, than you can do this step to resolve that problem

1. Open the phone dialer
2. Enter: *#*#4636#*#* (Once entered, you will be taken directly to a "Testing" page)
3. Tap Phone Information
4. Scroll to the bottom of the screen and you should see a button that says radio off. Hit this button and when it reads radio on Hit it again to turn the radio back on.

then you can "run ping test" for make it sure...

^_^

hope can remember it and halpfull

config serial access on IBM P 720

isach_xx@yahoo.com (sakti) — Wed, 21 Nov 2012 11:56:00 +0700

-- why --
on going to install or maintenance VIO Server on P720

-- need --
-laptop and serial cable
-secure crt or putty

--config --

--result--

Overclocked Huawei vision benchmark

isach_xx@yahoo.com (sakti) — Wed, 31 Oct 2012 10:23:00 +0700

spesifikasi :
http://www.gsmarena.com/huawei_u8850_vision-4109.php

hasil overclock dari 1Ghz menjadi 1,9 Ghz

Note: my phone afterall

Find Range Line of File

isach_xx@yahoo.com (sakti) — Mon, 22 Oct 2012 13:17:00 +0700

-- why--
intermezo by the way .... :D

--1--
when looking of a million or maybe a billion of log file, it would be faster if we go on line that we suspected

--trying--
a simple command it can be done it by this command

sed '2000,30000!d' aku.sh

nb: it will print line 2000 to 30000 of a file

Red Ribbon aplied

isach_xx@yahoo.com (sakti) — Sun, 24 Jun 2012 20:14:00 +0700

sekedar sharing aja setelah rehat sejenak :

same theme on my phone and my computer..

RED RIBBON

how about you... :D

Etherchannel on AIX server a.k.a teaming/bonding network interface

isach_xx@yahoo.com (sakti) — Fri, 13 Apr 2012 13:26:00 +0700

--GOAL--
~~had a project to tunning data transfer performa of production server~~. intinya adalah ngoprek aja :D

--bahan dan bahan--
membutuhkan minimal 2 ethernet card ( secara default sudah ada 4 ethernet card, no worry :p)
dlm config menggunakan I*M series with AIX sebagai operating system nya.
koneksikan 2 atau lebih dalam switch yang sama.

--1--
masuk konsole dan jalankan command berikut ;

# smitty etherchannel

dan menampilkan hasil sebagai berikut:

Etherchannel
Move cursor to desired item and press Enter.

  List All Etherchannels
  Add An Etherchannel
  Change / Show Characteristics of an Etherchannel
  Remove An Etherchannel

pilih add An Etherchannel :

                              Etherchannel

Move cursor to desired item and press Enter.

  List All Etherchannels
  Add An Etherchannel
  Change / Show Characteristics of an Etherchannel
  Delete An Etherchannel
   --------------------------------------------------------------------------
  |                        Available Network Adapters                        |
  |                                                                          |
  | Move cursor to desired item and press F7.                                |
  |     ONE OR MORE items can be selected.                                   |
  | Press Enter AFTER making all selections.                                 |
  |                                                                          |
  | > ent0                                                                |
  | > ent1                                                                |
  |   ent2                                                                   |
  |   ent3                                                                   |
  |   ent4                                                                   |
  |                                                                          |
  | F1=Help                 F2=Refresh              F3=Cancel                |
  | F7=Select               F8=Image                F10=Exit                 |
F1| Enter=Do                /=Find                  n=Find Next              |
F9 --------------------------------------------------------------------------

select dengan F7 dan enter :

 Add an Etherchannel

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

                                                        [Entry Fields]
  Etherchannel Adapters                               ent0 ent1               +
  Enable ALTERNATE ETHERCHANNEL address               no                      +
  ALTERNATE ETHERCHANNEL address                     []                       +
  Mode                                                Round_Robin             +
  Enable GIGABIT ETHERNET JUMBO frames                no                      +
  Internet Address to Ping                           []
  Number of Retries                                  []                        #
  Retry Timeout (sec)                                []                        #

enter lagi untuk commit settingan

COMMAND STATUS

Command: OK            stdout: yes           stderr: no

Before command completion, additional instructions may appear below.

ent4 Available

--2-- etherchanel sudah siap pada ent4, tinggal setting ip saja... --test&jajal--

#entstat -d ent4 | egrep "ETH|Device Type|Link State|Link Status|Media"
ETHERNET STATISTICS (ent4) :
Device Type: EtherChannel
ETHERNET STATISTICS (ent0) :
Device Type: Host Ethernet Adapter (l-hea)
Logical Port Link State: Up
Physical Port Link State: Up
Media Speed Selected: 1000 Mbps / 1 Gbps, Full Duplex
Media Speed Running: 1000 Mbps / 1 Gbps, Full Duplex
ETHERNET STATISTICS (ent1) :
Device Type: 2-Port 10/100/1000 Base-TX PCI-Express Adapter (14104003)
Link Status : Up
Media Speed Selected: 1000 Mbps Full Duplex
Media Speed Running: 1000 Mbps Full Duplex

Note:
- tested by me and running well till today
- i use mode round Robin to load balancing data transfer.

Remote Access MySql root user

isach_xx@yahoo.com (sakti) — Tue, 6 Mar 2012 14:48:00 +0700

--1--
login to mysql with root user

mysql -u root

--2--
and type command below :

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
mysql> flush privileges ;
mysql> exit;

that's all and try to connect remotely