Monday, March 21, 2016

Error Pada $dom = new DOMDocument()

terjadi pada server ku karena kurang aplikasi, setelah di instal aplikasi ini maka baru bisa berjalan lancar.

#sudo yum install php-xml



Friday, March 18, 2016

ERROR PADA Warning: date

Terjadi error pada  Warning: date( )
Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www

Solusinya tambah pada baris akhir dengan :
date.timezone = "Asia/Jakarta"

ERROR Notice: Undefined index: en in /var/www/html

error Notice: Undefined index: en in /var/www/html
Biasanya hanya beda versi php
hal ini di edit pada file php.ini

error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED


Thursday, March 17, 2016

Use mysqlcheck to Optimize and Repair MySQL Databases on Linux

Here are three quick commands that are useful to check, optimize, and also repair your mysql databases!

1. Check Databases
    $ mysqlcheck -cA -u root -p
       (-c for check database, -A for all databases)

2. Optimize Databases

    $ mysqlcheck -oA -u root -p
       (-o for optimize)

3. Repair Corrupted Databases
    $ mysqlcheck -rA -u root -p
       (-r for repair)

Friday, February 26, 2016

Install "crontab" on CentOS 6

Install the package and dependencies

#yum install vixie-cron

Enable the package on boot and start
# /sbin/chkconfig crond on

# /etc/init.d/crond start 
 
 # service crond start
# chkconfig crond on
 
 
# crontab -e
# crontab -l
 
Eksekusi script backup setiap jam 1 Siang
0 13 * * *  /bin/bash /root/backup.sh
 
Eksekusi script setiap 10 Menit
*/10 * * * * /root/script.sh
 
Eksekusi script setiap hari minggu Pukul 5 pagi
0 5 * * 0 /root/script.sh
 
----------------//--------------- 
 
 
 
 
 
 

Buat Database Centos

Ini adalah cara membuat database di centos 6


login ke server dulu, kemudian masuk e mysql:

root@centos:# mysql -u root -p
masukan pass anda

mysql> CREATE DATABASE databaseku;

mysql> CREATE USER 'namauser'@'localhost' IDENTIFIED BY 'mypassword';

mysql> GRANT ALL PRIVILEGES ON databaseku.* TO 'namauser'@'localhost';



Wednesday, January 20, 2016

Install LAMP Centos 6 Serverku

hanya catatanku

login server dulu

sudo yum install httpd
sudo service httpd start

sudo yum install mysql-server
sudo service mysqld start

sudo /usr/bin/mysql_secure_installation

sudo yum install php php-mysql

sudo chkconfig httpd on
sudo chkconfig mysqld on

sudo nano /var/www/html/info.php

Add in the following line:

<?php
phpinfo();
?>

Matiin Firewall

/etc/init.d/iptables stop

chkconfig iptables off


install PHP mbstring on CentOS 6.2

sudo nano /etc/yum.repos.d/CentOS-Base.repo

di bawah sektion "updates: hilangkan pagar


lalu

yum install php-mbstring

sudo service httpd restart

-selesai-