Talk About Server

1. apt-get update
2. apt-get upgrade
3. apt-get install bind9
4. /etc/init.d/apparmor teardown
5. update-rc.d -f apparmor remove
6. wget --user=ftp --password=ftp ftp://ftp.rs.internic.net/domain/db.cache -O /etc/bind/db.root
7. Change/Add this line in /etc/bind/named.conf.option in option{}
   
   allow-query { any; };
   allow-recursion { any; };
   forwarders {
   

   8.8.8.8;

   
   

   8.8.4.4; 

   
   

   };

   dnssec-validation no;
8. /etc/init.d/bind9 restart
9. update-rc.d bind9 defaults

1. Kurangi nilai max_connections pada postgresql.conf
2. Tambahkan nilai kernel.shmmax dan kernel.shmall pada /etc/sysctl.conf
3. #sysctl -p
4. service postgresql start
5. FINISH

1. cd /home
2. Type at terminal:
    for file in *; do
   chown  -R $file'.pnj' $file;
   done
3. Finish :-)

   # setup
                      +--------[ Choose a Tool ]---------+                      
                      |                                  |                      
                      |   Authentication configuration   |                      
                      |   Firewall configuration         |                      
                      |   Keyboard configuration         |                      
                      |   Network configuration          |                      
                      |   System services                |                      
                      |   Timezone configuration         |                      
                      |   X configuration                |                      
                      |                                  |                      
                      |      +----------+  +------+      |                      
                      |      | Run Tool |  | Quit |      |                      
                      |      +----------+  +------+      |                      
                      |                                  |                      
                      |                                  |                      
                      +----------------------------------+ 
   Pilih : Authentication configuration
      +----------------[ Authentication Configuration ]-----------------+       
      |                                                                 |       
      |  User Information        Authentication                         |       
      |  [ ] Cache Information   [*] Use MD5 Passwords                  |       
      |  [ ] Use Hesiod          [*] Use Shadow Passwords               |       
      |  [*] Use LDAP            [*] Use LDAP Authentication            |       
      |  [ ] Use NIS             [ ] Use Kerberos                       |       
      |  [ ] Use Winbind         [ ] Use SMB Authentication             |       
      |                          [ ] Use Winbind Authentication         |       
      |                          [ ] Local authorization is sufficient  |       
      |                                                                 |       
      |            +--------+                      +------+             |       
      |            | Cancel |                      | Next |             |       
      |            +--------+                      +------+             |       
      |                                                                 |       
      |                                                                 |       
      +-----------------------------------------------------------------+
   Choose "*" like example, and then click Next. 
             +-----------------[ LDAP Settings ]-----------------+              
             |                                                   |              
             |          [ ] Use TLS                              |              
             |  Server: ldap://127.0.0.1/_______________________ |              
             | Base DN: dc=jaringankantor,dc=com________________ |              
             |                                                   |              
             |         +------+                  +----+          |              
             |         | Back |                  | Ok |          |              
             |         +------+                  +----+          |              
             |                                                   |              
             |                                                   |              
             +---------------------------------------------------+  
   Input server with 127.0.0.1 and Base DN : dc=jaringankantor, dc=com

1. Disabled selinux:
   # vim /etc/selinux/config
   SELINUX=disabled
   ESC => :wq
2. Restart your PC
3. Config httpd.conf:
   # vim /etc/httpd/conf.d/welcome.conf
   and mark with #
   #<LocationMatch "^/+$">
   #    Options -Indexes
   #    ErrorDocument 403 /error/noindex.html
   #</LocationMatch>
   ESC => :wq
   # vim /etc/httpd/conf/httpd.conf
   User anwar
   Group anwar
   .
   .
   DocumentRoot "/home/anwar/public_html"
   .
   .
   <Directory "/home/anwar/public_html">
   ESC => :wq
4. Restart httpd:
   # service httpd restart
5. FINISH

SELECT user_id, name where user_id LIKE '%ANWAR%' or name LIKE '%ANWAR%';

CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int4out($1));';

CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(smallint) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int2out($1));';

CREATE CAST (smallint AS text) WITH FUNCTION pg_catalog.text(smallint) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(oid) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(oidout($1));';

CREATE CAST (oid AS text) WITH FUNCTION pg_catalog.text(oid) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(date) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(date_out($1));';

CREATE CAST (date AS text) WITH FUNCTION pg_catalog.text(date) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(double precision) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(float8out($1));';

CREATE CAST (double precision AS text) WITH FUNCTION pg_catalog.text(double precision) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(real) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(float4out($1));';

CREATE CAST (real AS text) WITH FUNCTION pg_catalog.text(real) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(time with time zone) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(timetz_out($1));';

CREATE CAST (time with time zone AS text) WITH FUNCTION pg_catalog.text(time with time zone) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(time without time zone) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(time_out($1));';

CREATE CAST (time without time zone AS text) WITH FUNCTION pg_catalog.text(time without time zone) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(timestamp with time zone) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(timestamptz_out($1));';

CREATE CAST (timestamp with time zone AS text) WITH FUNCTION pg_catalog.text(timestamp with time zone) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(interval) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(interval_out($1));';

CREATE CAST (interval AS text) WITH FUNCTION pg_catalog.text(interval) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(bigint) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int8out($1));';

CREATE CAST (bigint AS text) WITH FUNCTION pg_catalog.text(bigint) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(numeric) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(numeric_out($1));';

CREATE CAST (numeric AS text) WITH FUNCTION pg_catalog.text(numeric) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(timestamp without time zone) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(timestamp_out($1));';

CREATE CAST (timestamp without time zone AS text) WITH FUNCTION pg_catalog.text(timestamp without time zone) AS IMPLICIT;