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




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/

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

https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password

PHPMYADMIN

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

this tutorial belong to
https://www.digitalocean.com/community/articles/how-to-install-linux-apache-mysql-php-lamp-stack-on-debian

Referall

http://api.idhostinger.com/redir/2117029
sugarsync

dropbox
Onedrive

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

Akses POP3 email yahoo

Pengaturan server POP dasar untuk Yahoo! Mail

Artikel ini menjelaskan pengaturan server dasar yang digunakan untuk mengonfigurasi akun Yahoo! Mail Plus di klien email yang menggunakan akses POP. 

Gunakan pengaturan Akses POP berikut ini untuk mengonfigurasi Yahoo! Mail dengan SSL:

• Server Pesan Masuk (POP3): pop.mail.yahoo.com
• Port masuk: 995
• Server Email Keluar (SMTP): smtp.mail.yahoo.com
• Port keluar: 465 (dengan SSL) atau 587 (dengan SSL/TLS)
  SSL atau TLS perlu diaktifkan untuk server Outgoing SMTP.
• Alamat email: Alamat Yahoo! Mail Anda (pengguna@domain.com)
• Kata Sandi: Kata sandi Yahoo! Mail Anda