Showing posts with label Build Server. Show all posts

About Windows Server

Windows Server is one of operating server that use for server usage. Windows server is brand of Microsoft that release since April, 2003. The last version of windows server is Windows Server 2012 R2.

The another version of Windows Server but are not part of Windows Server Family and build for server computer are:
#1 Windows MultiPoint Server: that having many simultan local users

#2 Windows Home Server: use for home example for backup automatically, video streaming, and file sharing for many user

Windows Server 2012 R2 offer flexibility and fast performance, using for cloud services with new feature in management hardware and software, manage storage, virtualization or virtual desktop infrastructure. Many new feature presented in this version:
#1 Hyper V
Hyper V is virtualization software that support many operating system. In hyper V you can setting your network and setting may input or output devices

#2 User Interface
In start menu offer fast access to all apps and files, is very fast

#3 Powershell
Windows improve that tool is easy to select text, copy, cut, and paste, line break, and tabs. And now you can paste special character

#4 Windows Defender
That software using for fix an healing virus or malware in many version of windows like windows 7, windows 8, server 2008, and windows 2012

Maybe many improvement but that's all that i know

LOG: logger shutting down Error Postgresql (With Restart)

Login with postgres user
# su postgres

And then restart PostgreSQL
$ pg_ctl -D /usr/local/pgsql/data restart

Traceroute With Port Email

Sometime you must your internet provider for check what network support for email server:

# traceroute -n -T -p 25 gmail-smtp-in.l.google.com

BIND 9 Install / Named in Ubuntu


Bind is great DNS software. If you want to install follow this intruction:

  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

Done thank's

Nur Choliku Anwar

could not create semaphores: No space left on device (Shared Memory and Semaphores)

Pernah ketemu problem kaya gitu?

Postgresqlnya ga bisa hidup...nyebelin kan..

Trus Gimana?


  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

Change Password Postgresql

  1. Bypass login with setting /var/lib/pgsql/data/pg_hba.conf From "MD5" to "ident" (REMEMBER!: return back after finish), example:
    local all all ident
    host all all 127.0.0.1/32 ident
    host all all 0.0.0.0/0 md5
    host all all ::1/128 ident
  2. service postgresql restart
  3. su postgres
  4. psql
  5. ALTER USER postgres WITH ENCRYPTED PASSWORD 'password';
  6. \q
  7. exit
  8. service postgresql restart
Salam,

Nur Cholikul Anwar

Disable IPV6 Centos

# vim /etc/sysctl.conf

net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1

# sysctl -p

Device eth0 does not seem to be present, delaying initialization

For Solve that problem:

# echo "" > /etc/udev/rules.d/70-persistant-net.rules
# vim /etc/sysconfig/network-scripts/ifcfg-eth0 # reboot

HWADDR=YOUR_MAC_ADDRESS

Salam,

Nur Cholikul Anwar

Repositori Centos 6.3 ke kambing UI




[Add-Ons]
name=CentOS
baseurl=http://kambing.jaringankantor.com/centos/6.3/addons/i386/
enabled=1
gpgcheck=1
gpgkey=http://kambing.jaringankantor.com/centos/RPM-GPG-KEY-CentOS-6

[CentOS-Plus]
name=CentOS
baseurl=http://kambing.jaringankantor.com/centos/6.3/centosplus/i386/
enabled=1
gpgcheck=1
gpgkey=http://kambing.jaringankantor.com/centos/RPM-GPG-KEY-CentOS-6

[Extras]
name=CentOS
baseurl=http://kambing.jaringankantor.com/centos/6.3/extras/i386/
enabled=1
gpgcheck=1
gpgkey=http://kambing.jaringankantor.com/centos/RPM-GPG-KEY-CentOS-6

[Fasttrack]
name=CentOS
baseurl=http://kambing.jaringankantor.com/centos/6.3/fasttrack/i386/
enabled=1
gpgcheck=1
gpgkey=http://kambing.jaringankantor.com/centos/RPM-GPG-KEY-CentOS-6

[OS]
name=CentOS
baseurl=http://kambing.jaringankantor.com/centos/6.3/os/i386/
enabled=1
gpgcheck=1
gpgkey=http://kambing.jaringankantor.com/centos/RPM-GPG-KEY-CentOS-6

[Update]
name=CentOS
baseurl=http://kambing.jaringankantor.com/centos/6.3/updates/i386/
enabled=1
gpgcheck=1
gpgkey=http://kambing.jaringankantor.com/centos/RPM-GPG-KEY-CentOS-6


Last ID in PostgreSQL using adodb


$sql="INSERT INTO pollquestion (question,pollID,dtcreated,dtmodified) values (".
tosql($txtquestion,"Text").", ".
tosql($pollid,"Number").", ".
"Now(),Now())";
$svdb=clone $db;
$svdb->query($sql.' RETURNING questionid');
$svdb->next_record();
$qid=$svdb->f("questionid");

and you can try:
$this->master_conn->PO_Insert_ID('announcement','modid');
=>> 'announcement': table name
=>> 'modid': an increment id

How To fix invalid byte sequence for encoding "UTF8"

To solve that: clear the spaces between the commas in sql query PHP or you can add/change to:
utf8_encode($variabel);

Salam,

[NCA]

Konfigurasi Grandstream GXW410x dengan Asterisk


1. Lebih detail lihat file gxw410x_interop_asterisk.pdf
2. Pada sip sip.conf tambahkan/ubah
dtmfmode=rfc2833
allow=ulaw
allow=gsm
# include sip_additional.conf
3. Buat sip_additional.conf pada directory /etc/asterisk dan isi dengan (terlampir)
Point penting:
[gxw410x]
type=peer
dtmfmode=rfc2833
context=jadwal
host=gxw410x_ip_address
insecure=port
4. Setting grandstream:
On the GXW410x, under FXO Lines web configuration page set the following:
1. Wait for Dial-Tone(Y/N) to N.
2. Stage Method(1/2) to 1.
3. Unconditional Call Forward to VoIP: The user should construct a valid URI where to
forward the call. The User ID can be the extension number like ch1-4:200; The SIP
server will be using the IP address or FQDN indicated in the profile page, we use p1 for
profile1, p2 or profile2 and p3 for profile3. The SIP destination port should be the one
where the Asterisk is listening for incoming SIP communication.

DTMF Method (1-7): ch1-8:2
2 artinya adalah dtmfmode=rfc2833 (supaya dapat merespon key press dari telepon analog)
Buat dialplan di extensions_additional.conf dengan menambahkan
# include extensions_additional.conf
pada extensions.conf
5. Setting musiconhold.conf:
[default]
mode=files
directory=/var/lib/asterisk/moh
sort=random
6. Masukan musik ke dalam =/var/lib/asterisk/moh yang dapat di download di http://downloads.asterisk.org/pub/telephony/sounds/ cari yang moh gsm
7. Untuk masuk CLI: # asterisk –vvvr
8. Untuk apply konfigurasi: CLI > reload
9. Untuk hangup telepon yang belum ditutup: CLI > hangup request SIP/xxxxxx

oleh Nur Cholikul Anwar

Differences Postgresql Script and Mysql Script


This is Differences Postgresql Script and Mysql Script


mysql: SHOW DATABASES
postgresql: \l
postgresql: SELECT datname FROM pg_database;


mysql: SHOW TABLES
postgresql: \d
postgresql: SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';


mysql: DESCRIBE TABLE
postgresql: \d+ table
postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table';


mysql: SHOW COLUMNS
postgresql: \d table
postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table';


Export Data MySQL kedalam file format CSV

mysqldump -u [username] -p -t -T/tmp [database] --fields-enclosed-by=\" --fields-terminated-by=,

If you have problem don't change /tmp directory :-)

and this is an output (example):

"1","Nur Cholikul","Anwar","2000-01-01 01:01:01"
"2","Putri","Yuniartis"," 2000-01-01 01:01:01 "
"3","Jaringan","Kantor"," 2000-01-01 01:01:01 "

Membuat Perbandingan atau rasio Terkecil antar 2 (dua) angka Excel

Misalkan:
Ada Dua buah angka yang berada di A1 dan B1 untuk hasilnya ditampikan pada C1
     |  A   |  B   |  C  |
 1  | 12  | 16 | 3:4 |

Maka rumus untuk C1 adalah:
=IF(OR(A1=0, B1=0),A1&":"&B1,(A1/GCD(A1,B1))&":"&(B1/GCD(A1,B1)))

GCD: digunakan untuk mencari FPB (Faktor Persekutuan Besar)


Suppose that:
There are Two numbers are in A1 and B1 to C1 results are displayed in

     |  A   |  B   |  C  |
 1  | 12  | 16 | 3:4 |


Then the formula for C1 is:
= IF (OR (A1 = 0, B1 = 0), A1 & ":" & B1, (A1/GCD (A1, B1)) & ":" & (B1/GCD (A1, B1)))

GCD: used to find gcd (a factor of the Great Guild)


Salam damai selalu,

NCA :-)

Chown with folder/file name

Example you have a folder or file name at /home

abdillah             fauzan            kjbi           rosmaniar
adbis                fehmeed           kji            sekretariat
admin                fikri             kmk            sekretariatpd1
admniaga             grafika           kopma          sekretariatpd2
agah                 gretha            ksa            sekretariatpd3
agung                hani              ksm            sekretariatpd4

and then you want that folder/file get owner same as folder/file name.

Try this:

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

Authentication With LDAP


   # 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

Setting Root Directory Http to Own Home Directory


  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

How to backup MYSQL database

# mysqldump -u username -p database_name > dump.sql


and enter your password

Running OpenVPN as Daemon when start

Hello All,

Please type this command:
# vim /etc/rc.local

and go to end of line with type :$ and press i and then add this line (example):
openvpn --cd /etc/openvpn/ToRouterJakarta --daemon --config client.conf

press ESC and type :wq

FINISH...Alhamdulillah