Talk About Server

1. Give password for LDAP
   # slappasswd
   

   New password: 
   Re-enter new password: 
   {SSHA}ntokc0c+JJwxXWqoAI17EqX7UvNMzXQd

2. Edit File /etc/openldap/slapd.conf
   

   suffix          "dc=jaringankantor,dc=com"
   rootdn          "cn=Manager,dc=jaringankantor,dc=com"
   rootpw          "{SSHA}ntokc0c+JJwxXWqoAI17EqX7UvNMzXQd"

3. Restart LDAP
   

   # service ldap restart

4. Edit File /usr/share/openldap/migration/migrate_common.ph (OR /usr/share/migrationtools/migrate_common.ph)
   

   $DEFAULT_MAIL_DOMAIN = "jaringankantor.com";
   $DEFAULT_BASE = "dc=jaringankantor,dc=com";

5. Make root.ldif File
   

   # /usr/share/openldap/migration/migrate_base.pl > root.ldif

6. Input root.ldif file to LDAP
   

   # ldapadd -x -D "cn=Manager,dc=jaringankantor,dc=com" -f root.ldif -W

7. Migration user /etc/passwd to user.ldif
   

   # /usr/share/openldap/migration/migrate_passwd.pl /etc/passwd user.ldif

8. Input user.ldif to LDAP
   

   # ldapadd -x -D "cn=Manager,dc=jaringankantor,dc=com" -f user.ldif -W

9. Migration group /etc/group to group.ldif
   

   # /usr/share/openldap/migration/migrate_group.pl /etc/group group.ldif

10. Input group.ldif to LDAP
    

    # ldapadd -x -D "cn=Manager,dc=jaringankantor,dc=com" -f group.ldif -W

11. Login To Webmin/Virtualmin
12. Open Webmin > System > LDAP Client > LDAP Server Configuration
    Login for root user  : cn=Manager,dc=pnj,dc=ac,dc=id
    Password for root user : YourPassword
    Click Save
13. Open Webmin > System > LDAP Client > LDAP Search Base
    Global search base : dc=jaringankantor,dc=com
    Search depth : Entire Subtree
    Click Save
14. Open Webmin > System > LDAP Client > Services Using LDAP
    Unix users:  First data source : LDAP
    Unix shadow passwords:  First data source : LDAP
    Unix Group:    First data source : LDAP
15. Open Webmin > System > LDAP Client > Validate Configuration
    
    Finding LDAP base for users ..
    .. found base dc=jaringankantor,dc=com.
    Connecting to LDAP server ..
    .. connected to 127.0.0.1
    Searching for users ..
    .. found 7269 users.
    Checking Unix users service ..
    .. service is setup to query LDAP.
    Your system has been successfully configured as an LDAP client!
16. Open Virtualmin > System Setting > Virtualmin Configuration
    Store users and groups: in LDAP
    Click Save
17. Finish

Hi all friends ...

This time I want to share applications CodeIgniter (CI) inventory system that collaborated with the YUI (Yahoo UI).

Please click here: http://kenalanwar.co.cc/source-code/elektro-pnj.zip

Enjoy ...

Regards,

Nur Cholikul Anwar

CREATE DATABASE db_inventaris_elektro

CREATE TABLE t_list_barang
(
  f_id serial NOT NULL,
  f_kode character varying(50) NOT NULL,
  f_nama_barang character varying(100) NOT NULL,
  f_tipe_barang character varying(100),
  f_jumlah character varying(15) NOT NULL,
  ref_master_lokasi_f_id integer NOT NULL,
  f_jumlah_kondisi_baik character varying(15) NOT NULL,
  f_tanggal_masuk date NOT NULL,
  f_status_hapus boolean NOT NULL DEFAULT false,
  CONSTRAINT t_list_barang_pkey PRIMARY KEY (f_id),
  CONSTRAINT t_list_barang_ref_master_lokasi_f_id_fkey FOREIGN KEY (ref_master_lokasi_f_id)
      REFERENCES t_master_lokasi (f_id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE RESTRICT
)

CREATE TABLE t_master_lokasi
(
  f_id serial NOT NULL,
  f_kode_lokasi character varying(15) NOT NULL,
  f_nama_lokasi character varying(50) NOT NULL,
  CONSTRAINT t_master_lokasi_pkey PRIMARY KEY (f_id),
  CONSTRAINT t_master_lokasi_f_kode_lokasi_key UNIQUE (f_kode_lokasi),
  CONSTRAINT t_master_lokasi_f_nama_lokasi_key UNIQUE (f_nama_lokasi)
)

CREATE TABLE t_session
(
  session_id character varying(40) NOT NULL DEFAULT 0,
  ip_address character varying(16) NOT NULL DEFAULT 0,
  user_agent character varying(120) NOT NULL,
  last_activity integer NOT NULL DEFAULT 0,
  user_data text NOT NULL DEFAULT ''::text,
  CONSTRAINT ci_sessions_pkey PRIMARY KEY (session_id)
)

CREATE TABLE t_user
(
  f_id serial NOT NULL,
  f_username character varying(20) NOT NULL,
  f_password character varying(50) NOT NULL,
  f_nama character varying(50),
  CONSTRAINT t_user_pkey PRIMARY KEY (f_id),
  CONSTRAINT t_user_f_username_key UNIQUE (f_username)
)

• Codeigniter adalah salah satu framework PHP
• CKEditor adalah editor berbasis javascript
• KCFinder adalah filebrowser gratis berbasis web pengganti CKFinder yang saat ini berbayar

Alhamdulillah setelah oprek beberapa script langsung bisa. Langsung aja ya supaya cepet ngerti :-D