Jumat, 13 Juni 2014

Rabu, 30 April 2014

Multiple Count Statements With Different Criteria

Table:
Code:  Status  Cancel_Date
-----------------------------------
AAA    X       2012-02-01
AAA
BBB    X       2012-02-01
AAA    D       2012-01-01
AAA
BBB    
BBB    D       2012-02-01
BBB    X       2012-01-01
Example result (based on the above data):
Code:  TotalNotXorD     TotalXorD
------------------------------------
AAA    2                1
BBB    1                2
in SQL SERVER

SELECT  Code,
        SUM(CASE WHEN status NOT IN ('X','D') OR status IS NULL THEN 1 ELSE 0 END) TotalNotXorD,
        SUM(CASE WHEN status IN ('X','D') AND cancel_date >= '2012-02-01' THEN 1 ELSE 0 END) TotalXorD  
FROM    tableName
GROUP   BY Code
in MS ACCESS

 SELECT
    Sum(IIf(status<>'X' and status<>'D',1,0)) AS TotalNotXorD,
    Sum(IIf(status='X' and status='D',1,0)) AS TotalXorD
FROM tableName
GROUP   BY Code



Kamis, 28 November 2013

linux command

delete directory
rm -rf letters/
Add User 
useradd -u <username> -p <password> -d <directory>
Change Port
vi /etc/ssh/sshd_config
Change Port
vi /etc/ssh/sshd_config
# Run ssh on a non-standard port:
Port 2345  #Change me
service sshd restart
List All User
cat /etc/passwd
Archieve
zip -r filename.zip files

Compress an Entire Directory or a Single File

tar -czvf archive.tar.gz /path/to/directory-or-file
or
tar -czvf archive.tar.gz /home/ubuntu/Downloads /usr/local/stuff /home/ubuntu/Documents/notes.txt

Extract an Archive

tar -xzvf archive.tar.gz

Find / Search File Recursive

find -name *tgz




source : http://www.howtogeek.com/248780/how-to-compress-and-extract-files-using-the-tar-command-on-linux/

Rabu, 02 Oktober 2013

LAMP on Centos

Keep House Clean (TIDAK HARUS DILAKUKAN)
service httpd stop
yum remove php php-*
rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
rpm -Uvh http://repo.webtatic.com/yum/centos/5/latest.rpm
ls -1 /etc/yum.repos.d/epel* /etc/yum.repos.d/webtatic.repo
/etc/yum.repos.d/epel.repo
/etc/yum.repos.d/epel-testing.repo
/etc/yum.repos.d/webtatic.repo
vi /etc/yum.repos.d/webtatic.repo
[webtatic]
name=Webtatic Repository $releasever - $basearch
#baseurl=http://repo.webtatic.com/yum/centos/5/$basearch/
mirrorlist=http://repo.webtatic.com/yum/centos/5/$basearch/mirrorlist
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-webtatic-andy
 
=====================start here ============================
APACHE
yum install httpd
service httpd restart
PHP5
yum install php php-mysql
service httpd restart
untuk mencoba silahkan ketikkan
echo "<?php phpinfo();?>" >> /var/www/html/info.php
untuk mencari modul gunakan perintah
yum search php-
MYSQL
yum install mysql-server
service mysqld start
/usr/bin/mysql_secure_installation
MAKE APACHE AND MYSQL AUTORUN
chkconfig httpd on
chkconfig mysqld on
JSON
yum update
yum install php-pear php-devel gcc make
pecl install json
echo "extension=json.so" >> /etc/php.d/json.ini
echo "extension=php_curl.dll" >> /etc/php.ini
echo "extension=ffmpeg.so" >> /etc/php.ini
echo "extension=json.so" >> /etc/php.ini
service httpd restart
PHPMYADMIN
CentOS/RHEL 6, 32 Bit (i386):
rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
CentOS/RHEL 6, 64 Bit x86_64):
rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
CentOS/RHEL 5, 32 Bit (i386):
rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
CentOS/RHEL 5, 64 Bit (x86_64):
rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
step 2
yum install phpMyAdmin
Troubleshooting : » #2002 – Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) The server is not responding (or the local server’s socket is not correctly configured). ( This means your mysql server service is stopped , you must start the service “service mysql start”) » You don’t have permission to access /phpMyAdmin/ on this server. Open /etc/httpd/conf.d/phpMyAdmin.conf file and find the lines “Deny from All ” and comment those lines and restart httpd service

Tambahan
Reset root password
/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD("mynewpassword") where User='root';
flush privileges;
quit
/etc/init.d/mysqld start
mencoba hasil reset
mysql -u root -p mysql;
select host,user from user;
quit
/etc/init.d/mysqld start
chkconfig
sudo /sbin/chkconfig httpd on
sudo /sbin/chkconfig --list httpd
httpd           0:off        1:off  2:on    3:on    4:on    5:on    6:off
FIREWALL
sudo iptables -I INPUT -p tcp --dport 80 -j ACCEPT
sudo service iptables save
check firewall status
sudo netstat -plunt
source : http://www.rackspace.com/knowledge_center/article/centos-apache-and-php-install

LAMP and PHPMYADMIN on debian 6

CHANGE SSH PORT
vi /etc/ssh/sshd_config
/etc/init.d/ssh restart
UPDATE
apt-get update
APACHE 2
apt-get install apache2
PHP 5
apt-get install apache2 php5 libapache2-mod-php5 php-pear 'php5-suhosin
service apache2 restart
rm -fr /var/www/index.html
echo "<?php phpinfo();?>" >> /var/www/index.php
MYSQL
apt-get install mysql-server mysql-client php5-mysql
mysql_secure_installation
service apache2 restart
RESET ROOT PASSWORD
apt-get install phpmyadmin
/etc/init.d/apache2 restart


REMOTE MYSQL
vi /etc/mysql/my.cnf 
bind-address            = 127.0.0.1
diganti menjadi 
bind-address            = 0.0.0.0
service mysql restart
VSFTPD
apt-get install vsftpd
useradd bowongs0
passwd bowongs0
vi /etc/passwd


dont forget to remove samba
apt-get remove samba

Senin, 30 September 2013

Minggu, 29 September 2013

Webuzo Install

Open a Shell Terminal (e.g. PuTTY) and SSH to your server. Run the following commands:
wget -N http://files.webuzo.com/install.sh
chmod 0755 install.sh
./install.sh     // This will install the LAMP Stack, DNS Server and FTP server along with Webuzo
OR
./install.sh --install=lamp,bind // This will install the LAMP Stack(softname -> lamp) and DNS Server 
                                    (softname -> bind) along with Webuzo.
                                    Note : softname for Apps should be comma separated.
                                    Get list of softnames for the Apps here : http://api.webuzo.com/apps.php
OR
./install.sh --install=none // This will install only Webuzo without any LAMP Stack.
                               You can later install apps from the Apps Category in the Enduser Panel.
src http://www.webuzo.com/wiki/Install
mysql root pasword are saved in /var/webuzo/my.conf 
if WEBUZO STOP AFTER RESTART you can try this step
service webuzo restart
or in centos, execute this command
setenforce 0 >> /dev/null 2>&1
iptables -F >> /dev/null 2>&1
iptables -P INPUT ACCEPT >> /dev/null 2>&1
Tambahan Catatan Untuk mysql

Disable ONLY_FULL_GROUP_BY

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console

mysql -u pastuoke -p
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

you can read more here

Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin

  • Open phpmyadmin & select localhost
  • Click on menu Variables & scroll down for sql mode
  • Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.
 d