Photo merit

Foto2 merit q.

Merit

Yahoo ...blok ip telkomspeedy ...

Test email dari server testing Centos 5.1, saya pakai cyrus-imapd versi 2.3.7 dan postfix 2.3.3. Server kirim dan terima dari server gmail bisa, namun begitu saya coba email ke yahoo ternyata di blok.


: host mx1.mail.sg1.yahoo.com[124.108.116.72]
said: 553 Mail from wahyu@xxxxx.org not allowed - 5.7.1
[BL21] Connections not accepted from IP addresses on Spamhaus PBL; see
http://postmaster.yahoo.com/550-bl21.html [550] (in reply to MAIL FROM
command)

Ternyata yahoo blok dari spamhaus PBL. Saya menggunjungi website spamhaus.


IP Address Lookup

125.164.xx.xxx is not listed in the SBL

125.164.xx.xxx is listed in the PBL, in the following records:

* PBL171259

125.164.xx.xxx is not listed in the XBL


Berdasarkan di bawah, blok ip dari Telkomspeedy di blok
Ref: PBL171259

125.164.72.0/23 is listed on the Policy Block List (PBL)

Berarti ada 510 IP yang di blok. Karena hanya untuk testing, saya tidak remove IP address statik saya.

Setting PPPoE di Centos 5.1 menggunakan telkomspeedy

Catatan untuk membuat PPPoE di Centos 5.1 menggunakan telkomnetspeedy.
Karena Up Link dan Down Link Telkomspeedy sudah lumayan kenceng, walaupun kalau lagi lemot juga sangat lemot.

Gambar di bawah capture konfigurasi modem am300 gratis dari telkomspeedy :)




Setting modem di setting seperti diatas.

Kemudian setting Centos 5.1 dengan 2 ethernet, 1 ethernet untuk jaringan lokal, dan 1 ethernet untuk koneksi ke modem.

Internet <--> Modem(bridge) <--> Server gateway(eth1,eth0)

[root@wahyucentos ssh]# cat /etc/redhat-release
CentOS release 5 (Final)
[root@wahyu ssh]#

[root@wahyucentos ssh]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:50:8D:C3:39:7D
inet addr:192.168.0.105 Bcast:192.168.0.255 Mask:255.255.255.0
inet6 addr: fe80::250:8dff:fec3:397d/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:5990 errors:0 dropped:0 overruns:0 frame:0
TX packets:2161 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:825820 (806.4 KiB) TX bytes:1069634 (1.0 MiB)
Interrupt:217 Base address:0xa800

eth1 Link encap:Ethernet HWaddr 00:1E:58:31:B3:EB
inet addr:192.168.100.96 Bcast:192.168.100.255 Mask:255.255.255.0
inet6 addr: fe80::21e:58ff:fe31:b3eb/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:2847 errors:0 dropped:0 overruns:0 frame:0
TX packets:2878 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1084873 (1.0 MiB) TX bytes:539141 (526.5 KiB)
Interrupt:209 Base address:0x2000
[root@wahyucentos ssh]#
[root@wahyucentos ssh]#system-config-network




Klik New, dan pilih xDSL connections, pilih ethernet 1(eth1)masukan username dan
password telkom.

Setelah itu, active kan ppp
Sehingga dapat di lihat seperti dibawah ini. Dapat di lihat bahwa, pppC dengan nama koneksi test sudah aktif.



Di atas, saya juga mengaktifkan eth1 dengan ip address lokal.

[root@wahyucentos ssh]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:50:8D:C3:39:7D
inet addr:192.168.0.105 Bcast:192.168.0.255 Mask:255.255.255.0
inet6 addr: fe80::250:8dff:fec3:397d/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:5990 errors:0 dropped:0 overruns:0 frame:0
TX packets:2161 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:825820 (806.4 KiB) TX bytes:1069634 (1.0 MiB)
Interrupt:217 Base address:0xa800

eth1 Link encap:Ethernet HWaddr 00:1E:58:31:B3:EB
inet addr:192.168.100.96 Bcast:192.168.100.255 Mask:255.255.255.0
inet6 addr: fe80::21e:58ff:fe31:b3eb/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:2847 errors:0 dropped:0 overruns:0 frame:0
TX packets:2878 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1084873 (1.0 MiB) TX bytes:539141 (526.5 KiB)
Interrupt:209 Base address:0x2000

lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:1296 errors:0 dropped:0 overruns:0 frame:0
TX packets:1296 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:2913220 (2.7 MiB) TX bytes:2913220 (2.7 MiB)

ppp0 Link encap:Point-to-Point Protocol
inet addr:125.xxx.xx.xxx P-t-P:125.xxx.xx.x Mask:255.255.255.255
UP POINTOPOINT RUNNING NOARP MULTICAST MTU:1492 Metric:1
RX packets:2629 errors:0 dropped:0 overruns:0 frame:0
TX packets:2617 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:3
RX bytes:1013596 (989.8 KiB) TX bytes:460371 (449.5 KiB)

[root@wahyucentos ssh]#

Jangan lupa untuk setting iptables, dan forwarding agar, bisa di gunakan sebagai gateway. Atau kalau ingin menggunakan squid, bisa di installkan juga.

Delete mailbox on cyrus-imap

To delete mailbox on cyrus-imap you have to give permission. By default admin doesn't have permission deleting mailbox.


moonlight# cyradm -u cyrus localhost
Password:
localhost> lm
user.bafrin (\HasChildren) user.john.Sent (\HasNoChildren)
user.bafrin.Drafts (\HasNoChildren) user.john.Trash (\HasNoChildren)
user.bafrin.Sent (\HasNoChildren) user.wahyu (\HasChildren)
user.bafrin.Trash (\HasNoChildren) user.wahyu.Drafts (\HasNoChildren)
user.john (\HasChildren) user.wahyu.Sent (\HasNoChildren)
user.john.Drafts (\HasNoChildren) user.wahyu.Trash (\HasNoChildren)
localhost> dm user.john
deletemailbox: Permission denied
localhost>
localhost> lam user.john
john lrswipkxtecda
localhost> dm user.john
deletemailbox: Permission denied
localhost> sam user.john cyrus c
localhost> lam user.john
john lrswipkxtecda
cyrus kxc
localhost> dm user.test
deletemailbox: Mailbox does not exist
localhost> dm user.john
localhost> lm
user.bafrin (\HasChildren) user.wahyu (\HasChildren)
user.bafrin.Drafts (\HasNoChildren) user.wahyu.Drafts (\HasNoChildren)
user.bafrin.Sent (\HasNoChildren) user.wahyu.Sent (\HasNoChildren)
user.bafrin.Trash (\HasNoChildren) user.wahyu.Trash (\HasNoChildren)
localhost>

General IO error in openoffice using NFS

http://ubuntuforums.org/showthread.php?t=332043

Buat jasperserver di satu server

Idenya sih, karena kita memakai jasperserver 2.1, dan ada beberapa aplikasi yang berjalan menggunakan DB postgresql 8.2 yang berbeda. Agar aplikasi report yang di pakai, bisa menggunakan satu server report(jasperserver).

Saya menggunakan jasperserver versi di bawah, karena untuk mempermudah saja, installnya.
Karena sudah bundle dengan MySql, dan tomcat.

jasperserver-2.1-linux-installer.bin


Installasi saya taruh di /home/jasperserver-2.1

[root@temo jasperserver-2.1]# ls
ant jasperctl.sh license.txt scripts
apache-tomcat java mysql uninstall
docs js-installer-version.txt releaseNotes.txt
ireport licenses samples
[root@temo jasperserver-2.1]#
/home/jasperserver-2.1/apache-tomcat/webapps

copy folder jasperserver ke jasperprc, jaspershp, jaspervr di sesuaikan dgn namanya.

Edit file2 berikut, di sesuaikan dgn kebutuhan.

[root@temo WEB-INF]#
hibernate.properties jboss-web.xml web.xml
[root@temo WEB-INF]#

Edit web.xml, edit bagian ini ...

JasperSHP UI application


webAppRootKey
jaspershp.root


Di samakan dgn DBnya mysql.

Untuk hibernate.properties
# Properties file with JDBC-related settings.
# Applied by PropertyPlaceholderConfigurer from "applicationContext-*.xml".
# Targeted at system administrators, to avoid touching the context XML files.

# Property that determines the Hibernate dialect
metadata.hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

metadata.hibernate.dataSource.jndiName=jdbc/jaspershp

Dan seterusnya.

Buat database di mysql.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| foodmart |
| jasperprc |
| jaspershp |
| jaspervr |
| mysql |
| sugarcrm |
| test |
+--------------------+
8 rows in set (0.03 sec)

mysql>

Edit file di :
/home/jasperserver-2.1/apache-tomcat/webapps/jaspershp/META-INF
nama file context.xml

auth="Container"
name="jdbc/jaspershp"
type="javax.sql.DataSource"
password="passwordnya"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="30"
maxWait="1000"
username="usernya"
url="jdbc:mysql://127.0.0.1:3306/jaspershp?useUnicode=true&characterEncoding=UTF-8"
maxActive="20"/>


Restart apache tomcat, melalui manager.


note: bbrp langkah di lewati, spt, create db, import db data(import DB data dump harus di ganti sesuai dbnya [use namadbnya])