Install Alfresco CMS di OpenSuse10

INSTALLING ALFRESCO DI OPENSUSE10

1. Sebelum menginstall alfresco, pastikan terlebih dahulu install software di bawah ini:
1. MySQL Database
2. JDK
3. OpenOffice
2. Install Package alfresco di dalam file yang telah ditentukan sebelumnya:
A. Install dengan wizard
1. Browse atau tempatkan ke file yang tersimpan file Alfresco
contoh:
# cd /home/download/recomend
2. Lakukan install file dengan melakukan:
# ./Alfresco-Community-3.2r2-Linux-x86-Install
3. Lalu muncul pilikan bahasa, pilih English and klik OK.
4. Klik Yes.
5. Lakukan hingga selesai, untuk memudahkan pilih secara default saja.
B. Install dengan Package tar.gz
1. Browse atau tempatkan ke file yang tersimpan file Alfresco
contoh:
# cd /opt
2. Extrack package installernya
# tar zxfv
# tar zxfv alfresco-community-tomcat-3.2r2.tar.gz
3. Edit file catalina.properties.
Pastikan file tersebut memuat:
shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar
4. Pastikan juga file commons-el.jar berada dalam directory lib.
5. Modifikasi file /conf/server.xml atau /opt/Alfresco/tomcat/conf/server.xml. Menjadi:
dan

6. Modifikasi file webscript-framework-config-custom.xml yang ada di:
# /opt/Alfresco/tomcat/shared/classes/alfresco/web-extension/webscript-framework-config-custom.xml
Ubah pada server IP dan Port Number yang digunakan:
http://yourserver:8080
.....................................................................................

Membuat User di Oracle dengan OpenSuse10

1. Login Sebagai user Oracle
# login as : oracle
# password : oracle
2. Masuk ke dalam database Oracle
# su oracle
# sqlplus /nolog
3. Aktifkan oracle
sql> conn / as sysdba
sql> startup
sql> exit
Lalu kembali ke user Oracle, ketik:
# lsnrctl start
Kembali lagi ke database oracle untuk membuat user.
# sqlplus /nolog
4. Membuat User
sql> create user identified by default tablespace ;
5. Membuat Grant atau hak Akses untuk User.
sql> grant connect,resource to ;
sql> grant create synonym to ;

Proxy Server with squid in RedHat

To use the services of Squid, you first need to install certain packages and utilities, and then needs to perform the following tasks:
1. Identify the technology for implementing a proxy server.
2. Implement the proxy server.
3. Restart the proxy server

1. Identify the technology for implementing a proxy server in RZTV.
In Linux, a proxy server can be implemented using the Squid proxy server. Squid can be used for caching, connecting sharing, and restrict the restricting the Web sites accessed by users.

2. Implement the proxy server.
To set up the squid proxy server, perform with open the /etc/squid/squid.conf file in editor.
# vi /etc/squid/squid.conf
http_port 192.168.3.130:8080
cache_peer 10.14.202.2 parent 8080 0 no-query default

icp_port 0
cache_mem 8 MB
cache_dir ufs /var/spool/squid 100 16 256
cache_access_log /var/log/squid/access.log
cache_log /var/log/squid/cache.log
cache_store_log /var/log/squid/store.log
cache_mgr zareuli_rz@yahoo.co.id
acl all src 0.0.0.0/0.0.0.0
# Blok forbidden ip
acl forbidden_ip src 192.168.3.65-192.168.3.94
http_access deny forbidden_ip

# Blok site and porno word
acl asusila_domain dstdomain "/etc/squid/asusila_domain.txt"
acl kata_kotor url_regex -i "/etc/squid/kata_kotor.txt"
deny_info PESAN kata_kotor
deny_info PESAN asusila_domain
http_access deny asusila_domain
http_access deny kata_kotor

# download limited
acl working_time time MTWHF 09:00-17:00
acl movie_file urlpath_regex "/etc/squid/moviefile.txt"
http_access deny working_time movie_file

http_access allow all

# Bandwidth limiter
acl server src 192.168.3.130/27
acl staf src 192.168.3.34-192.168.3.62/27 192.168.3.65-192.168.3.94/27 192.168.3.98-192.168.3.126/27

delay_pools 2

# To pool no 1 and class no 1
delay_class 1 1
delay_parameters 1 -1/-1
delay_access 1 allow server
delay_access 1 deny all

# To pool no 2 and class no 2
delay_class 2 2
delay_parameters 2 5000000/5000000 20000/2000000
delay_access 2 allow staf
delay_access 2 deny all

never_direct allow all
visible_hostname rztv.com
cache_effective_group squid
cache_effective_user squid

Note:
1. http_port: HTTP port is used by the Squid.
2. icp_port: Port that is used by Squid to conduct cooperation with other Squid.
3. cache_mem: Memory physical ideal that is used by Squid to handle objects in-Transit (object is in a transition period between the time cache object download until the object was delivered to the client).
4. cache_dir ufs /var/spool/squid: Cache_dir option is determine the storage system such as that which will be used (UFS), the name of the directory where to store cache (/var/spool/squid).
5. acl: rule list that the state of privileges, to prevent people who do not have access rights to use the cache infrastructure.
6. http_access: HTTP Access parameter is to allow or deny access from the ACL, the ACL has been defined.
7. delay_pools: This option is for specifying the exact amount of pool that is used to limit the amount of bandwidth from the ACL.
8. delay_class: This option specifies the group from each pool that has been defined on the delay-pools option.
9. delay_parameters: This formula specifies the bandwidth that will be obtained by the ACL that will enter delay_pool.
10. delay_access: This defines who ACL that will be entered into a pool for the "slowing" bandwidth.

3. Restart the proxy server
To restart the Squid proxy service, enter the following command at the shell prompt:
# service squid restart

Setting DNS in RedHat Enterprise4

To solve problem about DNS, needs to perform the following tasks:
1. Configure a Linux node as a master DNS server for authenticated hosts.
2. Configure the forward zone file.
3. Configure the reverse zone file.
4. Configure the DNS.
5. Start named daemon for the master DNS server.

1. Configure a Linux node as a master DNS server for authenticated hosts.
To configure a Linux node as a master DNS server for RZTV, edit the /etc/named.conf file as follows:
zone "rztv.com" IN {
type master;
file "rztv.zone";
allow-update { none; };
};

zone "3.168.192.in-addr.arpa" IN {
type master;
file "named.rztv";
allow-update { none; };
};

Note:
A zone statement defines the characteristics of a zone and holds all the information regarding a zone, including the location of its configurations file. The following are some of the zone-options directives:
a. allow-update: Specifies the hosts that are allowed to dynamically update information in their zone.
b. file: Specifies the name of the zone’s configuration data file.
c. type: Specifies the types of zones, which are:
- master: Designates a name server as authoritative for the zone.
- forward: Forwards all requests regarding the information about the current zone to other name servers.
- hint: Points to the root name servers.

2. Configure the forward zone file.
Edit the /var/named/chroot/var/named/rztv.zone file in the linux node, which will act as the master DNS server, as follows:
$TTL 86400
@ IN SOA rztv.com. root.rztv.com. (
42 ; serial (d. adams)
3H ; refresh
15M ; retry
1W ; expiry
1D ) ; minimum

IN NS rztv.com.
rztv.com. IN A 192.168.3.130

Note:
1. $TTL: Used to set the default Time to Live (TTL) value for the zone. The TTL directive takes the value in seconds.
2. A: Address record, maps the host name to the IP address.
3. NS: Name Server record, defines the authoritative name servers for a particular zone.
4. SOA: State Of Authority record provides authoritative information about a domain. Contains the authoritative information about a namespace to the name server.
3. Configure the reverse zone file.
Edit the /var/named/chroot/var/named/named.rztv file in the Linux node, which will act as the master DNS server, as follows:
$TTL 86400
@ IN SOA rztv.com. root.rztv.com. (
1997022700 ; Serial
28800 ; Refresh
14400 ; Retry
3600000 ; Expire
86400 ) ; Minimum
IN NS rztv.com.

130 IN PTR rztv.com.
Note:
- PTR: PoinTeR record, maps an IP address to the host name. PTR are primarily used for reverse name solution, as they point IP addresses back to a particular host name.

4. Configure the DNS.
; generated by /sbin/dhclient-script
search localdomain
nameserver 192.168.3.130