Monday, August 27, 2018

Instalasi VNC Server di Centos 6.8 (For Remote)

1. INSTALASI APLIKASI PENDUKUNG
yum groupinstall Desktop
yum install gnome-core xfce4 firefox

2. INSTALASI VNC SERVER
yum install tigervnc-server

3. MAKE AUTOSTART ON BOOT
chkconfig vncserver on

4. CREATE VNC PASSWORD
vncpasswd

5. CONFIG VNC SERVER  (example using root user):
vi /etc/sysconfig/vncservers

teks paling akhir, ubah menjadi :
VNCSERVERS="1:root"
VNCSERVERARGS[1]="-geometry 1024x768"

6. RESTART SERVICE
service vncserver restart

7. CONFIG STARTUP VNC
vi /root/.vnc/xstartup

teks paling akhir, ubah menjadi :
#twm &
exec gnome-session &

Instalasi MySQL 5.6 di Centos 6.8 (64 bit)

1. DOWNLOAD & INSTALL REPOSITORY
wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
rpm -Uvh mysql-community-release-el6-5.noarch.rpm


2. INSTAL MYSQL SERVER
yum -y install mysql mysql-server


3. START SERVICEE
chkconfig mysqld on
service mysqld start


4. CONFIG MYSQL SERVER
mysql_secure_instalation

Saturday, August 25, 2018

Instalasi PHP 5.6 di Centos 6.x dan 7.x

1. DOWLOAD  RPM :
CentOS/RHEL 7.x:
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm

CentOS/RHEL 6.x:
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm


2. INSTALL PHP 5.6 :
yum install php56w php56w-mbstring php56w-devel php56w-ldap 
php56w-mbstring php56w-mcrypt php56w-xml php56w-mysqlnd 
php56w-pear php56w-gd


3. RESTART APACHE :
service httpd restart 

Tuesday, November 7, 2017

Membaca Log Absensi dari Mesin Fingerprint (Attendance System) Menggunakan PHP

Mesin Fingerprint yang sudah mendukung pertukaran data dengan SOAP memungkinkan untuk membaca log absensi menggunakan PHP. Untuk mengetahui apakah mesin fingerprint sudah mendukung SOAP hanya dengan mengakses IP Address mesin melalui web broswer. Jika saat diakses muncul halaman login, artinya mesin tersebut sudah mendukung SOAP.

Selanjutnya, berikut script PHP untuk membaca log absensi dari mesin :

<?php
set_time_limit(500);
$IP  = "192.168.5.98"; //isi dengan ip fingerprint
$Key = "0";  // key di mesin fingerprint, nol adalah nilai default

$Connect = fsockopen($IP, "80", $errno, $errstr, 1);
if ($Connect) {
  $soap_request = "<GetAttLog>
    <ArgComKey xsi:type=\"xsd:integer\">".$Key."</ArgComKey>
    <Arg><PIN xsi:type=\"xsd:integer\">ALL</PIN></Arg>
  </GetAttLog>";

  $newLine = "\r\n";
  fputs($Connect, "POST /iWsService HTTP/1.0".$newLine);
  fputs($Connect, "Content-Type: text/xml".$newLine);
  fputs($Connect, "Content-Length: ".strlen($soap_request).$newLine.$newLine);
  fputs($Connect, $soap_request.$newLine);
  $buffer = "";
  while($Response = fgets($Connect, 1024)) {
    $buffer = $buffer.$Response;
  }
} else echo "Koneksi Gagal";

$buffer = Parse_Data($buffer,"<GetAttLogResponse>","</GetAttLogResponse>");
$buffer = explode("\r\n",$buffer);

$c=0;
for ($a=1; $a<count($buffer)-1; $a++) {
    $data=Parse_Data($buffer[$a],"<Row>","</Row>");    
    $export[$c]['pin'] = Parse_Data($data,"<PIN>","</PIN>");
    $export[$c]['date'] = substr(Parse_Data($data,"<DateTime>","</DateTime>"),0,10) ;
    $export[$c]['time'] = substr(Parse_Data($data,"<DateTime>","</DateTime>"),11,8) ;
    $export[$c]['verif'] = Parse_Data($data,"<Verified>","</Verified>");
    $export[$c]['state'] = Parse_Data($data,"<Status>","</Status>");
    $export[$c]['wrkcode'] = Parse_Data($data,"<WorkCode>","</WorkCode>");
    $c++;
}

echo json_encode($export);

function Parse_Data ($data,$p1,$p2) {
  $data = " ".$data;
  $hasil = "";
  $awal = strpos($data,$p1);
  if ($awal != "") {
    $akhir = strpos(strstr($data,$p1),$p2);
    if ($akhir != ""){
      $hasil=substr($data,$awal+strlen($p1),$akhir-strlen($p1));
    }
  }
  return $hasil;    
}
?>

Hasil dari script diatas adalah log absensi dalam format JSON.

Wednesday, November 9, 2016

ACCESS SHARING FOLDER DARI LINUX KE WINDOWS

0. instal SAMBA
#yum install samba
#yum install samba-client
#yum install cifs-utils

1. Ubah Registry Di Computer Windows :
HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\LargeSystemCache - set it to 1
HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\Size - set it to 3

2. Restart service Windows bernama "Server", melalui serivces.msc

3. Mounting folder di Linux
Jika dengan otentikasi user :
mount.cifs //fileserver1.serverlab.intra/dept /mnt/share

Jika dengan guest user :
mount.cifs //fileserver1.serverlab.intra/dept /mnt/share -o guest

Wednesday, October 7, 2015

INFO VERSI CENTOS/REDHAT

# cat /etc/redhat =release
atau
# uname -a

MENGAKTIFKAN KONEKSI INTERNET DI CENTOS

Dengan asumsi bahwa Gateway internet di IP Address 192.168.5.240 dengan IP CLIENT STATIC

KONFIGURASI FILE :
# vi /etc/sysconfig/network
tambahkan : GATEWAY 192.168.5.240

# vi /etc/sysconfig/network-scripts/ifcfg-eth0
ubah BOOTPROTO = static

# vi /etc/resolv.conf
tambahkan :
nameserver : 192.168.5.240
nameserver : 8.8.8.8

#/etc/init.d/network restart

KONFIGURASI ASTERISK DI UBUNTU (IMPLEMENTASI VOIP)

FILE KONFIGURASI :
 # vi /etc/asterisk/sip.conf
[dany]
type=friend
context=kktvoip
username=dany
secret=asdfg
host=dynamic

# vi /etc/asterisk/extensions.conf
[kktvoip]
exten => 111,1,Dial(SIP/dany)


RESTART SERVICE :
/etc/init.d/asterisk restart

Mengaktifkan mod_rewrite Apache di CentOs 5.8

1. Buka config httpd dengan editor pada direktori /etc/httpd/conf/httpd.conf
# vi /etc/httpd/conf/httpd.conf


2. Pastikan modul rewrite aktif (tidak ada tanda # di awal baris) dengan memeriksa baris berikut
LoadModule rewrite_module modules/mod_rewrite.so

3. Scroll ke bawah, dan cari bagian <Directory "/var/www/html"> lalu ganti
AllowOverride None
    Menjadi
AllowOverride All

4. Simpan file hasil perubahan.

5. Restart apache/httpd dengan perintah
service httpd restart

PHP Increase Upload File Size Limit

Your php installation putting limits on upload file size. The default will restrict you to a max 2 MB upload file size. You need to set the following two configuration options:

  1. upload_max_filesize - The maximum size of an uploaded file.
  2. memory_limit - This sets the maximum amount of memory in bytes that a script is allowed to allocate. This helps prevent poorly written scripts for eating up all available memory on a server. Note that to have no memory limit, set this directive to -1.
  3. post_max_size - Sets max size of post data allowed. This setting also affects file upload. To upload large files, this value must be larger than upload_max_filesize. If memory limit is enabled by your configure script, memory_limit also affects file uploading. Generally speaking, memory_limit should be larger than post_max_size.
  4. There are two methods two fix this problem.

Method # 1: Edit php.ini

# vi /etc/php.ini

memory_limit = 32M
upload_max_filesize = 10M
post_max_size = 20M

 

Method #2: Edit .htaccess

# vi /home/httpd/html/.htaccess 

php_value upload_max_filesize 10M
php_value post_max_size 20M
php_value memory_limit 32M

 

 

    PhpMyAdmin 4.2.2 Released – Install for Apache or Nginx on RHEL/CentOS 6.5/5.9 Fedora 20-12

    Step 1: Install Required Repositories for PhpMyAdmin 4.2.2

    [For RHEL/CentOS 6.5/5.9 – 32 Bit OS]
    ## Epel Dependency on RHEL/CentOS 6 ##
    # rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
    
    ## Remi Dependency on RHEL/CentOS 6 ##
    # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
    
    ## Epel Dependency on RHEL/CentOS 5 ##
    # rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
    
    ## Remi Dependency on RHEL/CentOS 5 ##
    # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
     
    [For RHEL/CentOS 6.5/5.9 – 64 Bit OS]
    ## Epel Dependency on RHEL/CentOS 6 ##
    # rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
    
    ## Remi Dependency on RHEL/CentOS 6 ##
    # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
    
    ## Epel Dependency on RHEL/CentOS 5 ##
    # rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
    
    ## Remi Dependency on RHEL/CentOS 5 ##
    # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
     
    [For Fedora 20-12]
    ## Remi Dependency on Fedora 20,19,18,17,16,15,14,13,12 ##
    # rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm 
    # rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
    
    ## Remi Dependency on Fedora 20 ##
    rpm -Uvh http://rpms.famillecollet.com/remi-release-20.rpm
    
    ## Remi Dependency on Fedora 19 ##
    rpm -Uvh http://rpms.famillecollet.com/remi-release-19.rpm
    
    ## Remi Dependency on Fedora 18 ##
    rpm -Uvh http://rpms.famillecollet.com/remi-release-18.rpm
    
    ## Remi Dependency on Fedora 17 ##
    rpm -Uvh http://rpms.famillecollet.com/remi-release-17.rpm
    
    ## Remi Dependency on Fedora 16 ##
    rpm -Uvh http://rpms.famillecollet.com/remi-release-16.rpm
    
    ## Remi Dependency on Fedora 15 ##
    rpm -Uvh http://rpms.famillecollet.com/remi-release-15.rpm
    
    ## Remi Dependency on Fedora 14 ##
    rpm -Uvh http://rpms.famillecollet.com/remi-release-14.rpm
    
    ## Remi Dependency on Fedora 13 ##
    rpm -Uvh http://rpms.famillecollet.com/remi-release-13.rpm
    
    ## Remi Dependency on Fedora 12 ##
    rpm -Uvh http://rpms.famillecollet.com/remi-release-12.rpm
     

    Step 2: Install PhpMyAdmin 4.2.2

    # yum --enablerepo=remi install phpmyadmin
     
    Note : If your are using PHP 5.4 on RHEL/CentOS systems, then you need to run the below command to install it.
    # yum --enablerepo=remi,remi-test install phpmyadmin
     

    Step 3: Configuring PhpMyAdmin for Apache 

    In Apache you don’t need to setup any Virtual Host for phpMyAdmin, because you will get working phpMyAdmin automatically. The main configuration file is located under /etc/httpd/conf.d/phpMyAdmin.conf.

    Step 4: Restarting Apache 

    # /etc/init.d/httpd restart
    OR
    # service httpd restart
     

    Step 5: Starting PhpMyAdmin

    http://localhost/phpmyadmin.

     

     

     

     

     

    Install Apache 2.2.15, MySQL 5.5.34 & PHP 5.5.4 on RHEL/CentOS 6.4/5.9 & Fedora 19-12

    Step 1: Installing Remi Repository

    ## Install Remi Repository on Fedora 19, 18, 17, 16, 15 ##
    rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm 
    rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
    
    
    ## Fedora 19 ##
    # rpm -Uvh http://rpms.famillecollet.com/remi-release-19.rpm
    
    ## Fedora 18 ##
    # rpm -Uvh http://rpms.famillecollet.com/remi-release-18.rpm
    
    ## Fedora 17 ##
    # rpm -Uvh http://rpms.famillecollet.com/remi-release-17.rpm
    
    ## Fedora 16 ##
    # rpm -Uvh http://rpms.famillecollet.com/remi-release-16.rpm
    
    ## Fedora 15 ##
    # rpm -Uvh http://rpms.famillecollet.com/remi-release-15.rpm
    
    ## Fedora 14 ##
    # rpm -Uvh http://rpms.famillecollet.com/remi-release-14.rpm
    
    ## Fedora 13 ##
    # rpm -Uvh http://rpms.famillecollet.com/remi-release-13.rpm
    
    ## Fedora 12 ##
    # rpm -Uvh http://rpms.famillecollet.com/remi-release-12.rpm
    
    ## Install Remi & Epel Repository on RHEL/CentOS 6.4-6.0 - 32 Bit ##
    rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
    rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm 
    
    ## Install Remi & Epel Repository on RHEL/CentOS 6.4-6.0 - 64 Bit ##
    rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
    rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm 
    
    ## Install Remi Repository on RHEL/CentOS 5.9-5.0 - 32 Bit ##
    rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
    rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
    
    ## Install Remi Repository on RHEL/CentOS 5.9-5.0 - 64 Bit ##
    rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
    rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
     
    
    

    Step 2: Installing Apache 2.2.15, MySQL 5.5.34 & PHP 5.5.4

    ## Installing on Fedora 12, 13, 14, 15, 16, 17, 18, 19 ##
    # yum --enablerepo=remi install httpd mysql mysql-server php php-common
    
    ## Installing on RHEL/CentOS 5-6 ##
    # yum --enablerepo=remi,remi-test install httpd mysql mysql-server php php-common
     

    Step 3: Installing PHP 5.5.4 Modules

    ## Installing on Fedora 12, 13, 14, 15, 16, 17, 18, 19 ##
    # yum --enablerepo=remi install php-mysql php-pgsql php-pecl-mongo php-sqlite php-pecl-memcache php-pecl-memcached php-gd php-mbstring php-mcrypt php-xml php-pecl-apc php-cli php-pear php-pdo
    
    ## Installing on RHEL/CentOS 5-6 ##
    # yum --enablerepo=remi,remi-test install php-mysql php-pgsql php-pecl-mongo php-sqlite php-pecl-memcache php-pecl-memcached php-gd php-mbstring php-mcrypt php-xml php-pecl-apc php-cli php-pear php-pdo

     

    Step 4: Starting/Stopping Apache & MySQL

    ## Enable Apache and MySQL on Run-Levels ##
    # chkconfig --levels 235 httpd on
    # chkconfig --levels 235 mysqld on
    
    ## Apache Commands ## 
    # /etc/init.d/httpd start
    # /etc/init.d/httpd stop
    # /etc/init.d/httpd status
    
    ## MySQL Commands ## 
    # /etc/init.d/mysqld start
    # /etc/init.d/mysqld stop
    # /etc/init.d/mysqld status
     

    Step 5: Verifying Apache 2.2.15, MySQL 5.5.34 & PHP 5.5.4

    <?php
    
         phpinfo ();
    ?>

     

     

     

    Sunday, January 26, 2014

    Cara Copy File di Visual Basic 6.0

    Private Sub Command1_Click()
    'Reference : Microsoft Scripting Runtime
    Dim fso As New FileSystemObject
    fso.CopyFile "J:\Striping.jpg", "\\192.168.5.90\app\", True
    End Sub

    Tuesday, July 23, 2013

    Situs Menulis Huruf Arab

    Situs yang bagus untuk menulis huruf arab klik disini

    Thursday, July 4, 2013

    Mendapatkan Informasi No IMEI Pada Handphone

    Caranya ketik *#06# lalu klik OK, maka akan tampil Nomor IMEI Handphone.

    Untuk cek validitas IMEI klik di sini

    Monday, March 18, 2013

    Beda script VB 6.0 dengan VB,Net


    Script untuk mengetahui root direktori  :

    Di Visual Basic 6.0
    Me.Caption = App.Path


    Di Visual Basic .NET
    Me.Text = System.AppDomain.CurrentDomain.BaseDirectory()

    Wednesday, February 20, 2013

    Legalitasi Broker Forex


    Untuk mencari broker forex yang bagus harus dipelajari dan dicari tahu lembaga pemerintah mana broker tersebut terdaftar. Karena bukan tidak mungkin banyak muncul broker-broker palsu yang hendak menipu dan mengeruk keuntungan mengingat antusiasnya calon trader untuk berdagang di pasar valuta asing. Hampir setiap di negara, broker harus terdaftar dan legal. 
    Seperti halnya Amerika Serikat, broker harus terdaftar sebagai Futures Commission Merchant (FCM) dengan The Commodity Futures Trading Commissin (CFTC) dan anggota NFA. CFTC dan NFA yang dibentuk untuk melindungi publik penipuan, manipulasi dan praktek-praktek kecurangan perdagangan. Anda dapat memeriksa registrasi Commodity Futures Trading Commissin (CFTC) dan status keanggotaan NFA seorang broker tertentu dan mengecek sejarah kependidikan mereka dengan menelpon NFA di (800)621-3570 atau dengan mengecek bagian informasi broker/firma (BASIC) pada situs website National Future Association

    Friday, June 15, 2012

    Cara Sederhana Konfigurasi Dasar Mikrotik

    Ada 3 langkah sederhana untuk konfigurasi mikrotik dengan skema koneksi seperti berikut  :
    MODEM ADSL >>> Mikrotik >>> Access Point (Untuk Client)
    Dengan asumsi bahwa Mikrotik hanya menggunakan dua port jaringan, yaitu untuk ke Modem ADSL dan ke Access Point.
    Berikut langkah-langkahnya (Gunakan Winbox agar lebih mudah):
    1. Mengaktifkan DHCP Client pada Mikrotik
      Klik : IP >> DHCP Client >> Klik tanda (+) >> pilih Interface yang digunakan untuk koneksi ke internet >> Klik OK
      Ini artinya kita akan membuat mikrotik sebagai penerima IP Address dari Modem ADSL. Cara ini sama halnya seperti ketika anda menghubungkan langsung Komputer anda ke Modem ADSL. Tentunya komputer akan di setting sebagai penerima IP Address atau IP Dynamic pada TCP/IPv4 nya.
    2. Menentukan IP Address yang akan digunakan sebagai IP dasar hotspot
      Untuk membuat server hotspot tentunya anda akan diminta untuk menentukan IP Address yang nantinya akan diberikan kepada Client Mikrotik anda.
      Klik : IP >> Addresses
      Klik tanda (+) >> masukkan IP Address >> pilih interface untuk ke client >> Klik OK
    3. Mensetup Server
      Langkah terakhir adalah men-setup Hotspot berdasarkan IP Address yang telah anda tentukan.
      Klik : IP >> Hotspot >> Server >> Hotspot Setup (klik next terus sampai selesai).
    Setelah selesai dengan 3 langkah di atas, selanjutnya lakukan Reboot dengan cara :
    Klik  System >> Reboot
    Tunggu hingga Mikrotik startup kembali. Kemudian coba koneksi ke internet menggunakn browser anda.