C o o l S i n c h a n ! !

Facebook Alam Gaib

noreply@blogger.com (c4nx3) — Tue, 01 Dec 2009 10:14:00 +0000

Taken from kaskus
.:cool_sinchan@yahoo.com:.

Find a duplicate rows in mysql

noreply@blogger.com (c4nx3) — Tue, 01 Dec 2009 02:37:00 +0000

How to find duplicate rows with SQL
with 60 comments

This article shows how to find duplicated rows in a database table. This is a very common beginner question. The basic technique is straightforward. I’ll also show some variations, such as how to find “duplicates in two columns” (a recent question on the #mysql IRC channel).

How to find duplicated rows

The first step is to define what exactly makes a row a duplicate of another row. Most of the time this is easy: they have the same value in some column. I’ll take this as a working definition for this article, but you may need to alter the queries below if your notion of “duplicate” is more complicated.

For this article, I’ll use this sample data:

create table test(id int not null primary key, day date not null);

insert into test(id, day) values(1, '2006-10-08');
insert into test(id, day) values(2, '2006-10-08');
insert into test(id, day) values(3, '2006-10-09');

select * from test;
+----+------------+
| id | day |
+----+------------+
| 1 | 2006-10-08 |
| 2 | 2006-10-08 |
| 3 | 2006-10-09 |
+----+------------+
The first two rows have the same value in the day column, so if I consider those to be duplicates, here’s a query to find them. The query uses a GROUP BY clause to put all the rows with the same day value into one “group” and then count the size of the group:

select day, count(*) from test GROUP BY day;
+------------+----------+
| day | count(*) |
+------------+----------+
| 2006-10-08 | 2 |
| 2006-10-09 | 1 |
+------------+----------+
The duplicated rows have a count greater than one. If you only want to see rows that are duplicated, you need to use a HAVING clause (not a WHERE clause), like this:

select day, count(*) from test group by day HAVING count(*) > 1;
+------------+----------+
| day | count(*) |
+------------+----------+
| 2006-10-08 | 2 |
+------------+----------+
This is the basic technique: group by the column that contains duplicates, and show only those groups having more than one row.

Why can’t you use a WHERE clause?

A WHERE clause filters the rows before they are grouped together. A HAVING clause filters them after grouping. That’s why you can’t use a WHERE clause in the above query.

How to delete duplicate rows

A related question is how to delete the ‘duplicate’ rows once you find them. A common task when cleaning up bad data is to delete all but one of the duplicates, so you can put proper indexes and primary keys on the table, and prevent duplicates from getting into the table again.

Again, the first thing to do is make sure your definition is clear. Exactly which row do you want to keep? The ‘first’ one? The one with the largest value of some column? For this article, I’ll assume you want to keep the ‘first’ row — the one with the smallest value of the id column. That means you want to delete every other row.

Probably the easiest way to do this is with a temporary table. Especially in MySQL, there are some restrictions about selecting from a table and updating it in the same query. You can get around these, as I explain in my article How to select from an update target in MySQL, but I’ll just avoid these complications and use a temporary table.

The exact definition of the task is to delete every row that has a duplicate, except the row with the minimal value of id for that group. So you need to find not only the rows where there’s more than one in the group, you also need to find the row you want to keep. You can do that with the MIN() function. Here are some queries to create the temporary table and find the data you need to do the DELETE:

create temporary table to_delete (day date not null, min_id int not null);

insert into to_delete(day, min_id)
select day, MIN(id) from test group by day having count(*) > 1;

select * from to_delete;
+------------+--------+
| day | min_id |
+------------+--------+
| 2006-10-08 | 1 |
+------------+--------+
Now that you have this data, you can proceed to delete the ‘bad’ rows. There are many ways to do this, and some are better than others (see my article about many-to-one problems in SQL), but again I’ll avoid the finer points and just show you a standard syntax that ought to work in any RDBMS that supports subqueries:

delete from test
where exists(
select * from to_delete
where to_delete.day = test.day and to_delete.min_id <> test.id
)
If your RDBMS does not support subqueries, or if it’s more efficient, you may wish to do a multi-table delete. The syntax for this varies between systems, so you need to consult your system’s documentation. You may also need to do all of this in a transaction to avoid other users changing the data while you’re working, if that’s a concern.

How to find duplicates in multiple columns

Someone recently asked a question similar to this on the #mysql IRC channel:

I have a table with columns b and c that links two other tables b and c, and I want to find all rows that have duplicates in either b or c.

It was difficult to understand exactly what this meant, but after some conversation I grasped it: the person wanted to be able to put unique indexes on columns b and c separately.

It’s pretty easy to find rows with duplicate values in one or the other column, as I showed you above: just group by that column and count the group size. And it’s easy to find entire rows that are exact duplicates of other rows: just group by as many columns as you need. But it’s harder to identify rows that have either a duplicated b value or a duplicated c value. Take the following sample table, which is roughly what the person described:

create table a_b_c(
a int not null primary key auto_increment,
b int,
c int
);

insert into a_b_c(b,c) values (1, 1);
insert into a_b_c(b,c) values (1, 2);
insert into a_b_c(b,c) values (1, 3);
insert into a_b_c(b,c) values (2, 1);
insert into a_b_c(b,c) values (2, 2);
insert into a_b_c(b,c) values (2, 3);
insert into a_b_c(b,c) values (3, 1);
insert into a_b_c(b,c) values (3, 2);
insert into a_b_c(b,c) values (3, 3);
Now, you can easily see there are some ‘duplicate’ rows in this table, but no two rows actually have the same tuple {b, c}. That’s why this is a bit more difficult to solve.

Queries that don’t work

If you group by two columns together, you’ll get various results depending on how you group and count. This is where the IRC user was getting stumped. Sometimes queries would find some duplicates but not others. Here are some of the things this person tried:

select b, c, count(*) from a_b_c
group by b, c
having count(distinct b > 1)
or count(distinct c > 1);
This query returns every row in the table, with a COUNT(*) of 1, which seems to be wrong behavior, but it’s actually not. Why? Because the > 1 is inside the COUNT(). It’s pretty easy to miss, but this query is actually the same as

select b, c, count(*) from a_b_c
group by b, c
having count(1)
or count(1);
Why? Because (b > 1) is a boolean expression. That’s not what you want at all. You want

select b, c, count(*) from a_b_c
group by b, c
having count(distinct b) > 1
or count(distinct c) > 1;
This returns zero rows, of course, because there are no duplicate {b, c} tuples. The person tried many other combinations of HAVING clauses and ORs and ANDs, grouping by one column and counting the other, and so forth:

select b, count(*) from a_b_c group by b having count(distinct c) > 1;
+------+----------+
| b | count(*) |
+------+----------+
| 1 | 3 |
| 2 | 3 |
| 3 | 3 |
+------+----------+
Nothing found all the duplicates, though. What I think made it most frustrating is that it partially worked, making the person think it was almost the right query… perhaps just another variation would get it…

In fact, it’s impossible to do with this type of simple GROUP BY query. Why is this? It’s because when you group by one column, you distribute like values of the other column across multiple groups. You can see this visually by ordering by those columns, which is what grouping does. First, order by column b and see how they are grouped:

a b c
7 1 1
8 1 2
9 1 3
10 2 1
11 2 2
12 2 3
13 3 1
14 3 2
15 3 3
When you order (group) by column b, the duplicate values in column c are distributed into different groups, so you can’t count them with COUNT(DISTINCT c) as the person was trying to do. Aggregate functions such as COUNT() only operate within a group, and have no access to rows that are placed in other groups. Similarly, when you order by c, the duplicate values in column b are distributed into different groups. It is not possible to make this query do what’s desired.

Some correct solutions

Probably the simplest solution is to find the duplicates for each column separately and UNION them together, like this:

select b as value, count(*) as cnt, 'b' as what_col
from a_b_c group by b having count(*) > 1
union
select c as value, count(*) as cnt, 'c' as what_col
from a_b_c group by c having count(*) > 1;
+-------+-----+----------+
| value | cnt | what_col |
+-------+-----+----------+
| 1 | 3 | b |
| 2 | 3 | b |
| 3 | 3 | b |
| 1 | 3 | c |
| 2 | 3 | c |
| 3 | 3 | c |
+-------+-----+----------+
The what_col column in the output indicates what column the duplicate value was found in. Another approach is to use subqueries:

select a, b, c from a_b_c
where b in (select b from a_b_c group by b having count(*) > 1)
or c in (select c from a_b_c group by c having count(*) > 1);
+----+------+------+
| a | b | c |
+----+------+------+
| 7 | 1 | 1 |
| 8 | 1 | 2 |
| 9 | 1 | 3 |
| 10 | 2 | 1 |
| 11 | 2 | 2 |
| 12 | 2 | 3 |
| 13 | 3 | 1 |
| 14 | 3 | 2 |
| 15 | 3 | 3 |
+----+------+------+
This is probably much less efficient than the UNION approach, and will show every duplicated row, not just the values that are duplicated. Still another approach is to do self-joins against grouped subqueries in the FROM clause. This is more complicated to write correctly, but might be necessary for some complex data, or for efficiency:

select a, a_b_c.b, a_b_c.c
from a_b_c
left outer join (
select b from a_b_c group by b having count(*) > 1
) as b on a_b_c.b = b.b
left outer join (
select c from a_b_c group by c having count(*) > 1
) as c on a_b_c.c = c.c
where b.b is not null or c.c is not null
Any of these queries will do, and I’m sure there are other ways too. If you can use UNION, it’s probably the easiest.
Written by Xaprb
October 9th, 2006 at 10:56 pm

.:cool_sinchan@yahoo.com:.

From Rain city to Drain city (motorcycle)

noreply@blogger.com (c4nx3) — Mon, 10 Aug 2009 06:12:00 +0000

View Jalur Roda Dua in a larger map

.:cool_sinchan@yahoo.com:.

Hufff again

noreply@blogger.com (c4nx3) — Fri, 17 Jul 2009 12:52:00 +0000

god please help me, kenapa pada saat nya udah deket muncul perasaan perasaan gundah, ya tuhan bantu aku lalui jalanku, semoga semua berjalan lancar, bismillah.
.:cool_sinchan@yahoo.com:.

Peta Ke Wisma Asri

noreply@blogger.com (c4nx3) — Tue, 30 Jun 2009 06:01:00 +0000

View Journey To Wisma asri in a larger map

Listing STudio Musik Di Bogor

noreply@blogger.com (c4nx3) — Fri, 12 Jun 2009 09:31:00 +0000

KOTA BOGOR
Bogor tengah:
PINK Studio (0251-8317491)
RAJAWALI Studio (0251-8324435)

Bogor Timur:
OBS Studio (0251-8315287)
LUGINA Studio

Bogor Barat :
ZIDANE Studio (0251-8350181)
STUDIO 13 (0251-8315768)
Bogor Utara:
PATRA Studio (0251-8363685)
PANDAWA Studio (0251-8345103)
MODIS Studio
Bogor Selatan:
ANGGANA Studio (83224446)
BLUE Studio (0251-8228307)
OQ Studio (0251-8485311)
ORANGE Studio/Distro (0251-8383368)

KABUPATEN BOGOR
Ciomas:
CODA Studio (0251-8635275)
CAMELLION Studio (085219852080)
Cibinong:
BUMI Studio (021-87900471)
CHANNEL Studio
BUNBUN Studio
RAKA Studio
Citeureup:
ANGEL Studio (081310806747)
BEAT Studio
Gunung Puteri:
AROLAS Studio (021-8670017)
LOTUS Studio (021-8672406)
Leuwiliang:
METEOR Studio
Ciampea:
SILVER Studio
Cicurug:
CLASSIC Studio
TREZNA Studio
Cisarua:
BASEMAN Studio
GP Studio

.:cool_sinchan@yahoo.com:.

Step By Step

noreply@blogger.com (c4nx3) — Mon, 08 Jun 2009 03:27:00 +0000

alhamdulillah rumah sudah dapet, letaknya nggak jauh dari stasiun kereta, daerah wisma asri, meski butuh perbaikan, tapi lumayan kok, cukup bagus untuk ditinggali, hmm, ntar kudu kenalan sama tetangga nih kayaknya, semoga nggak ada masalah deh, sekarang tinggal ngurusin surat surat dan tetek bengek hufff, semangaaaddddd semuaaaaaaaaa, yakin lah selama masih ada usaha pasti ada jalan, hehehehe

.:cool_sinchan@yahoo.com:.

Harinya sudah ditentukan :D semangaat

noreply@blogger.com (c4nx3) — Mon, 18 May 2009 10:53:00 +0000

after all setelah mengalami pencarian panjang dan proses pencocokan, waktunya gwe memutuskan jalur hidup nih, hmm bosen juga hidup asal asalan :p, sekarang waktunya serius, pusatkan konsentrasi dan pikiran mu jalani hidup yang baru (padahal masih beberapa bulan lagi :p), mungkin bogor kota tercinta kan kutinggalkan, tapi tidak untuk selamanya, gwe punya banyak kenangan di kota hujan ini, dari cerita senang sampe cerita paling sedih dalam hidup gwe, BTW di kota yang baru nanti gwe kudu musti beradaptasi nih, semoga semua berjalan sesuai rencana amiiinn

dari kota hujan ke kota panas wakakakaka bekasi i'm comiinggg

.:cool_sinchan@yahoo.com:.

Pia Apel Pie

noreply@blogger.com (c4nx3) — Tue, 03 Mar 2009 18:12:00 +0000

akhirnya makan juga pia aple pie bogor, penasaran banget ternyata setelah mencoba, hmm lumayan, kaya kue lebaran cuma ukuran gede aja kali ya

nggak ketinggalan spagheti saus apel nya beuhhh

mao?? datengin aja ke Pia Apple Pie Pangrango No. 10 deket surya kencana
mayan juga buat ngedate mah :p

.:cool_sinchan@yahoo.com:.

Huffffff FULL Stress

noreply@blogger.com (c4nx3) — Mon, 16 Feb 2009 14:55:00 +0000

great semua yang gwe lakuin gagal total, gagal semuanya, hebat , damn, gwe jadi inget kata temen gwe, "jangan mau kalah ama masalah, yang namanya hidup nggak bakalan jauh2 dari masalah, kalo lo nggak mau punya masalah, mati aja!! beres kan...", damn, gwe pengen teriak, pengen berantem, pengen gebugin orang, BT banget asli, tapi tetep walau gini gwe harus tetep cooldown, jangan sampai keliatan hopeless (padahal udah),tarik napas dalem2 huuffff, oke lanjuuttt

Hujan...

noreply@blogger.com (c4nx3) — Tue, 23 Dec 2008 17:37:00 +0000

Brrr malem ini ujan lagi, dingin juga ya
jadi inget lagu hujan

HUJAN
==============
Bila mentari tak menyinari lagi
tertutup oleh awan kelabu
mendung pun datang dan menaungi alam
rintik hujan pun turun membasahi bumiku

Awan yang gelap menutup langit cerah
gemuruh petir memecah kesunyian
aku mencari tempat untuk berteduh
yang mungkin takkan kutemukan

Hujaannn.. Turunlahhh
Basahi dunia ku yang panas membara
Hujaannn.. Turunlahh
Basahi dunia ku yang panas membara

Akan kah turun hujan
Akan kah turun hujan

nb:oi kemas kapan ngeband lagihhh
.:cool_sinchan@yahoo.com:.

Lonely Night

noreply@blogger.com (c4nx3) — Tue, 23 Dec 2008 17:08:00 +0000

Huff malem malem gini udah mana balik keujanan brrr, minum teh anget dulu...
oke gwe coba buka buka page dari plurk sampe friedster, koneksi indosat 3g lumayan parah malam ini, iseng gwe buka friendster alumni smun 3 bogor hihihi ada photo photo anak anak smunti, gwe telusurin atu2, ada yang udah nikah, ada yang masih ngobral diri wkwkwkw, sedih juga kalo inget smu, pengenn rasanya balik ke masa lampau, coba punya doraemon,hihihi, inget kecengan smu,coba ah cari2 fotonya, hmm adaaaa!!, wkwkwkw lucu masih seperti yang dulu (ya iyalah secara itu poto kan waktu di smu dulu), huhuhu gwe kangennnn masa2 smu gwe, temen2 gwe dah pada jadi orang gwe aja nih yang belom...
kapan ya semua ini berakhir, kapan bisa mulai lagi dari bayi lagi.. i'm feel bored with my life now, aneh gwe percaya nanti kalo kita mati kita terlahir lagi dan mengalami kehidupan yang hampir sama...but that's just my imagination, but come on wake up man,time is running out, sampe kapan lo mau gini terus kata hati kecil gwe, bingung gwe gwe cape gwe pengen berhenti , ah cemen lo..(hati gwe lagi), lo pikir lo hidup buat diri lo sendiri, egois amat lo, lo tu idup buat orang2 disekitar lo, nyokap lo bokap lo, kaka lo ade lo, keluarga lo, temen2 lo, kapan sih lo mau sadar dan berhenti bermain main (hati kecil lagi), ah kapan ya gwe bisa berhenti bermain2 dan mulai serius? hmmm entah dh, gwe serasa kosong, gwe jalanin semua tapi gwe rasa ada yang kurang, tapi apa ya.. gwe harus tetep cari sampe dapet..... apapun itu...semoga gwe dikasih kesempatan sama yang diatas buat menemukannya..amiinn
.:cool_sinchan@yahoo.com:.

Damn!!

noreply@blogger.com (c4nx3) — Sun, 14 Dec 2008 08:50:00 +0000

sial nih orang bikin gwe bt aja, gwe tau kale lo ngeboongin gwe
bukannya ngaku kesalahan malah diulangin, sabar sih sabar.....
hehehe lo pikir gwe bisa di bodoin gitu aja, gua udah perhitungin semua
gwe sengaja ikutan jalan maen lo selama ini, diem bukan berarti gwe lupain...
lo liat nanti, hasil akhirnya.
.:cool_sinchan@yahoo.com:.

Radio Online euy (dari blog tetangga)

noreply@blogger.com (c4nx3) — Tue, 25 Nov 2008 03:28:00 +0000

Dj Wirya.com - Radio Online 24/7
| winamp | http://cast.idvps.com:8000/djwirya.m3u

Prambors - Tempat nak muda mangkal
| WHAMB | winamp | http://orange.ask.co.id:8000/1022fm.ogg.m3u

Kaskus Radio - Radionya anak indo
| real player | i-tunes | win MP | winamp | http://208.77.101.188:8888/listen.pls

D Radio - Radio Keluarga Indonesia
| win media player | mms://radio.vstreamer.com/dradio

Kiss FM Medan - 105 FM
| winamp | http://live.kissfm-medan.com:8080/

Voice of Human Rights (VHR) - Menyuarakan Hak Asasi Manusia, Hukum dan demokrasi
| webcast |

RRI - Radio Republik Indonesia
| winamp | http://www.rri.co.id/streaming/live.pls

Hang106 Batam - Radio Dakwah Sunnah
| winamp | http://125.162.88.125:8000/ atau http://radiohang.mine.nu:8000/

PutraFM - Online jam 10:00-24:00 WIB (Senin-Jum'at)
| i-tunes | Real player | winamp | http://www.putrafm.upm.edu.my:8080/listen.pls

Al-Barokah - Radio Tarbiyah
| winamp | http://radio.albarokah.or.id/listen.pls

Smart FM - The Spirit of Indonesia
| win media player | winamp | http://www.smartfm.dyndns.org:8000/smartfm.aac.m3u

My Quran - Komunitas Muslim Indinesia
| winamp | http://myquran.org:8000/listen.pls

CVC - Online Music, Shortwave Radio, Streaming Media
| winamp | http://www.cvc.tv/stream/CVC_Indo_64kbps.m3u atau http://www.cvc.tv/stream/CVC_Indo_24kbps.m3u

Hard Rock FM - Lifestyle Entertainment Station
| win media player |
Jakarta : mms://radio.vstreamer.com/hardrock
Surabaya : mms://202.148.11.104/hardrockfm

Elshinta - News and Talk
| win medi player | mms://202.158.49.136/elshinta

Geronimo - 106.1 FM Radionya Jogja
| webcast |

Redjo Buntung - Radio Jogja
| win media player | mms://219.83.62.246:1080/

SurfMusic - ada sekitar 10 statiun radio (tinggal pilih)
| webcast |

KapanLagi.com - sebelah kanan atas
| webcast |

spinRADIO - A new concept of internet radio
| winamp | http://203.134.232.66:8000/spin.m3u

Radio Rodja - Saluran Tilawah dan Kajian Islam
| winamp | http://rodja.sytes.net:8000/listen.pls

Cosmopolitan FM - your personal station
| win media player | mms://radio.vstreamer.com/cosmopolitan

IndoSound - Indonesian Internet Radio
| web cast | win Media Player | http://sc1.streamingchoice.com/4100/listen_aac.asx
| winamp | http://sc1.streamingchoice.com:4100/listen.pls

i-Radio FM
| win media player | mms://radio.vstreamer.com/iradio

Maestro FM Bandung
| winamp | http://202.6.239.11:10925/radio.maestro.m3u

Makobu FM Malang
| winamp | http://202.58.204.5/mars.htm

Istara FM Surabaya
| win media player | mms://radio.vstreamer.com/dradio

Heartbeat Station

|winamp | http://85.214.37.145:8000/ atau http://24.132.79.159:17845/ atau http://70.85.112.20:8000/

Indonesia NetRadio - Cyber Education and Entertainment
| winamp | http://208.77.102.97:8036/

COOL Radio Station, Bandung - Cyber Education and Entertainment
| winamp | http://sc7.spacialnet.com:18892/listen.pls

Mustang 88 FM - The Rhythm Of The City
| winamp | http://203.77.231.138:8000/listen.pls

DJFM 94.8 - The Ultimate Youngster Radio
| win media player | mms://202.148.11.104/djfm

Eltira FM - Yogya Spirit
| winamp | http://www.eltirafm.com/audio/stream/streamnew.m3u

Radio Star FM - The Real Music
| win media player | mms://202.148.11.104/starfm

Triangle Voice Radio
| winamp | http://s9.viastreaming.net:7140/listen.pls atau http://74.86.163.122:8062/listen.pls

Kis Fm Jakarta - 80's, 90's, Today & Beyond
| winamp | http://203.77.231.202:8000

Ramako FM - The Magic Of Jakarta
| winamp | http://203.77.230.50:8000

tjap Radio Bandoeng (tRB) FM
| winamp | http://69.80.224.163:7060 atau http://212.72.186.18:8130

Daftar beberapa Radio Streaming Lokal

* Kaskus Radio : http://indowebster.kaskusradio.com:8000/listen.pls
* Radio Nafiri FM Surabaya : http://streaming.nafirifm.net/listen.pls
* Radio Garuda Suriname NV : http://78.157.192.21:8010/listen.pls
* PAS FM : http://202.146.225.106:8000/listen.pls
* Cosmopolitan FM : mms://radio.vstreamer.com/cosmopolitan
* Elshinta : mms://202.158.49.136/elshinta
* RRI : http://www.rri.co.id/streaming/live.pls
* Hard Rock Jakarta : mms://radio.vstreamer.com/hardrock
* Hard Rock Surabaya : mms://202.148.11.104/hardrockfm
* Kapanlagi Radio : http://203.134.232.69:8000/kapanlagi.m3u
* Ria POP FM Jkt : http://riapopfm.big.net.id/listen.pls
* Radio Pelita Kasih FM (RPK FM) : mms://radio.vstreamer.com/rpkfm
* Ramako : http://203.77.230.50:8000/listen.pls
* Prambors : http://orange.ask.co.id:8000/1022fm.ogg.m3u
* Radio Rodja : http://radiorodja.sytes.net:8000/listen.pls
* tjap Radio Bandung (tRB) : http://69.80.224.163:7060/listen.pls
* Indo Hitz : http://69.80.224.163:7060/listen.pls
* Radio Anak Baik : http://69.80.224.163:7060/listen.pls
* CVC Online Music : http://www.cvc.tv/stream/CVC_Indo_24kbps.m3u
* KISS FM Medan : http://live.kissfm-medan.com:8080
* Dj Wirya : http://cast.idvps.com:8000/djwirya.m3u
* Heart Beat Station : http://heartbeatstation.info/listen.pls

.:cool_sinchan@yahoo.com:.

Bikin server Chat dengan Openfire dengan 2 database berbeda (user nya)

noreply@blogger.com (c4nx3) — Fri, 21 Nov 2008 09:40:00 +0000

Oke langsung aja step step nya

- download openfire disinih

http://www.igniterealtime.org/downloads/index.jsp

- karena gwe pake yang RPM jadi

ketik aja

% rpm -Uvw openfire.x.x.x.rpm

- terus cek ke /opt/openfire/

- kalo udah ada buat database di lokal server dulu (buat openfire nya)

- kalo dah kelar nyalain openfire pake

% service openfire start

- kalo dah nyala akses via web dengan alamat http://ipnya:9090/ nanti ada gui
untuk instalasi

- lanjut aja wizardnya ampe kelar (lo pasti ngerti caranya), ampe bisa login

- udah gitu matiin server nya

- masuk ke /opt/openfire/conf/

- ketik

% vi openfire.xml

nah buat setingannya kaya gini

<jive>

<jdbcProvider>

<driver>com.mysql.jdbc.Driver</driver>

<connectionString>jdbc:mysql://ipdatabaseuser/dbname?user=usname&password=pass</connectionString>

</jdbcProvider>

<provider>

<auth>



<className>com.gusto.plasa.auth.JDBCPlasaAuthProvider</className>



<className>org.jivesoftware.openfire.user.JDBCUserProvider</className>

</auth>

<user>

<className>org.jivesoftware.openfire.user.JDBCUserProvider</className>

</user>

</provider>

<jdbcAuthProvider>

<passwordSQL>SELECT password FROM tbl_user WHERE username=?</passwordSQL>

<passwordType>crypt3</passwordType>

</jdbcAuthProvider>

<jdbcUserProvider>

<loadUserSQL>SELECT nama,email FROM tbl_user WHERE username=?</loadUserSQL>

<userCountSQL>SELECT COUNT(*) FROM tbl_user</userCountSQL>

<allUsersSQL>SELECT username FROM tbl_user</allUsersSQL>

<searchSQL>SELECT username FROM tbl_user WHERE</searchSQL>

<usernameField>username</usernameField>

<nameField>nama</nameField>

<emailField>email</emailField>

</jdbcUserProvider>



<adminConsole>



<port>9090</port>

<securePort>9091</securePort>

</adminConsole>

<locale>en</locale>

<connectionProvider>

<className>org.jivesoftware.database.DefaultConnectionProvider</className>

</connectionProvider>

<database>

<defaultProvider>

<driver>com.mysql.jdbc.Driver</driver>

<serverURL>jdbc:mysql://localhost:3306/openfire</serverURL>

<username>xxxxxxxx</username>

<password>xxxxxxxx</password>

<testSQL>select 1</testSQL>

<testBeforeUse>true</testBeforeUse>

<testAfterUse>true</testAfterUse>

<minConnections>5</minConnections>

<maxConnections>25</maxConnections>

<connectionTimeout>1.0</connectionTimeout>

</defaultProvider>

</database>

<setup>true</setup>

</jive>

- restart lagi openfire dan walah nyala deh server openfire

.:cool_sinchan@yahoo.com:.

Patah Semangat lagi

noreply@blogger.com (c4nx3) — Thu, 13 Nov 2008 16:02:00 +0000

Huffff gagal lagi.... gagal lagi,,, guys gwe gagal lagi nih nilai e gwe nangkring di daftar nilai gwe kudu diulang deh, cape gwe, lama lama pegel juga, but gimana lagi kalo nggak gitu gwe nggak bakalan belajar, kalo sesuatu itu kalo mau sukses ya harus serius, like my friend say 'lo bisa kalo lo mao ry', udah deh lepasin dulu yg itu, lanjut ke yang satu ini, my song and lyrics

.: Pagi Indah :.
C G Am Em
Pagi ini mentari sinari
F C G
hangat dan menyejukkan hati
C G Am Em
kicau burung pun ikut bernyanyi
F C G
menambah indahnya pagi ini

C G Am Em
embun pagi menyegarkan bumi
F C G
berhias warna warni pelangi
C G Am Em
langit biru damaikan jiwaku
F C G
semilir angin hembus tubuhku

Dm Am
mungkinkah esok hari
Dm Am
mentari bersinar lagi
Dm Am F G
seperti pagi yang indah ini

Dm Am
mungkinkah esok hari
Dm Am
mentari bersinar lagi
Dm Am F G
seperti pagi yang indah ini

reff:
C G Am Em
wangi bunga ingatkan ku padanya
F G C
kekasih hati nun jauh disana
C G Am Em
andai saja kita bisa bersama
F G C
nikmati pagi yang indah berdua

end
huff bener kata temen gwe kegembiraan akan berakhir dengan kesedihan
dan kesedihan pasti akan berakhir menjadi kegembiraan
intinya hidup itu seperti roda kadang diatas kadang dibawah
so dont give up, itu cuma masalah waktu kok..chayooo
NB to Grip Band
Guys ni hits maker ke 2 kita masih inget dong...
dont give up guys tetep semangat ya
.:cool_sinchan@yahoo.com:.

Buronan

noreply@blogger.com (c4nx3) — Wed, 05 Nov 2008 12:27:00 +0000

Edun hari ini gwe dikejar kejar ama temen gwe gara2 project, hiks not the first time but kali ini orang yang ngejar beda dari biasanya, serius banget orangnya, gwe jadi ikut tegang, biasanya project bleeding udah lumrah di IT, cuma kayaknya orang ini belum ngerti soal begituan.... gwe jadi nggak enak, berharap semoga badai cepat berlalu
.:cool_sinchan@yahoo.com:.

Hufffff....

noreply@blogger.com (c4nx3) — Tue, 04 Nov 2008 11:06:00 +0000

hmm bingung gwe, sama semuanya, saat gwe pikir gwe bisa dekat dengannya, dia malah bikin sesuatu yang bikin gwe patah semangat, kadang gwe berpikir ngga baik juga kalo hidup selalu dibayang bayangin harapan akan sesuatu yang nggak mungkin terjadi, tapi setiap gwe liat senyumannya, beuh... pusing deh, keputusannya lanjut apa mundur aja ya?
hmm... dah ah pindah scene dulu, nih lagu ciptaan gw gwe taro sini biar nggak lupa..

SahabatKU

intro
C F C G

C F C G
Masih Teringat Saat Kita Bersama
C F A G
Habiskan Waktu Dengan Canda Tawa
C F C G
HilangKan Sejenak Duka Yang melanda
C F A G
Slalu Berbagi Semua rasa bahagia

Reff:
C F A G
Mari Bersama Arungi Waktu
C F A G
Hilangkanlah Duka Didalam Hati mu
C F A G
Sahabatku jangan pernah engkau ragu
C F A G
Aku takkan berhenti untuk mendukungmu
C F G C F G
Sahabatku..

kunci sama dengan awal
Jangan Pernah sampai kita terpisahkan
hanya oleh karena satu perbedaan
biarkan semua terus berjalan
jangan pernah kau coba untuk hentikan

Back To Reff

melodi

================================
dedicated to gripband
where are you guys... miss u all, meski kita dah punya jalan masing2, semangat gwe nggak ada matinya..... dont care about what they say, keep in rockkin..
.:cool_sinchan@yahoo.com:.

instalasi streaming rtsp pake vlc di linux ( Bioskop Jaringan )

noreply@blogger.com (c4nx3) — Wed, 10 Sep 2008 04:46:00 +0000

akhirnya jalan juga nih striming server, hehehe gimana caranya
rtsp di bikin streaming biar semua orang bisa menikmatinya
dengan vlc client di port 8080 atau port lain beuh....
kenapa vlc soalnya gratisan coy.
download aplikasinya di http://www.videolan.org/vlc/
nah kalo udah
di extract dah tar -zxvf vlc-0.8.6d.tar.gz
di folder vlc-0.8.6d jalanin

./configure --enable-x11 --enable-xvideo --disable-gtk --enable-sdl --enable-ffmpeg --enable-mad --enable-libdvbpsi --enable-a52 --enable-dts --enable-libmpeg2 --enable-dvdnav --disable-faad --enable-vorbis --enable-ogg --enable-theora --enable-faac --enable-mkv --enable-freetype --enable-fribidi --enable-speex --enable-flac --disable-livedotcom --enable-caca --enable-skins --enable-skins2 --enable-alsa --disable-kde --disable-qt --enable-wxwindows --enable-ncurses --enable-release --enable-dvbpsi --enable-realrtsp --enable-live555 --with-live555-tree=/root/live/

* bagian --with-live555-tree=/root/live/ <-- lokasi file live 555

kalo ada error biasanya karena modul library nya nggak ada
librari yang kudu ada dan diinstall:
libdvbpsi : libdvbpsi5-0.1.6.tar.gz -->http://downloads.videolan.org/pub/videolan/libdvbpsi/0.1.6/libdvbpsi5-0.1.6.tar.gz
libmpeg2 : libmpeg2-0.5.1.tar.gz
-->http://libmpeg2.sourceforge.net/files/libmpeg2-0.5.1.tar.gz
wxWidgets : wxWidgets-2.8.8.tar.gz
-->http://prdownloads.sourceforge.net/wxwindows/wxWidgets-2.8.8.tar.gz
live555 : live555MediaServer
-->http://www.live555.com/mediaServer/linux/live555MediaServer
kalo udah jalankan perintah compile diatas
kemudian lakukan perintah
#>make install
tunggu beberapa saat
kalo dah selesai
jalanin deh
#>vlc -vvv rtsp://iprtsp:port --sout '#duplicate{dst=std{access=http,mux=ts,dst=ipserver:port}}'
contoh
#>vlc -vvv rtsp://192.168.1.86:86 --sout '#duplicate{dst=std{access=http,mux=ts,dst=192.168.1.31:8080}}'
kalo udah semua maka server rstp akan berjalan
sekarang tinggal klien nya
nyalakan vlc client anda (di windows atau linux [GUI])
tekan Ctrl + N
atau File -> Open Nertwork Stream pilih tab Network
pilih HTTP isi url dengan ip server streaming anda, misal
192.168.1.31:8080
lalu pilih ok
tunggu beberapa saat, walah....anda bisa nonton bareng dalam satu jaringan
hihihihi

.:cool_sinchan@yahoo.com:.

Hari pertama Puasa yang mengerikan

noreply@blogger.com (c4nx3) — Mon, 01 Sep 2008 03:38:00 +0000

sial bener gwe hari ini, dengan semangat membara gwe menuju kantor dan tiba dikantor dengan semangat memulai pekerjaan baru di bulan yang suci ini. pas gwe nyalain kompi sempet bingung, kenapa nih kompi nggak mau nyala pas gwe coba mattiin nyalain lagai
boom surprise selamat LCD anda pecah, pengen marah tapi marah kesiapa
yasudah hadapi saja dengan senyuman. hari yang aneh gwe pikir. by the way gwe langsung cek dimana kira2 bis benerin nih laptop. berdasarkan temen gwe. untuk benerin nih laptop gwe kudu pnya kocek 1 juta minimal, hiks. astagfirullah.. apa ini termasuk cobaan mu ya allah.. tapi dalam hati berkata.. tuhan nggak bakal ngasih ujian lebih berat dari apa yang mampu dihadapi umatnya, gwe inget2 lagi kapan gwe pernah bikin dosa ke orang.. hmm banyak juga berarti wajar lah kalo gwe di kasih ujian sama yang diatas kebetulan ini baru hari pertama puasa, ujian nya dah seperti ini duh gusti...
sabar aja lah, pasti ada jalan keluarnya kok :'(

.:cool_sinchan@yahoo.com:.

After Crash (",)?

noreply@blogger.com (c4nx3) — Thu, 31 Jan 2008 06:56:00 +0000

Wadeuh dah lama nggak pernah posting lagi sejak gwe kecelakaan motor
:p, pelajaran buat gwe. banyak hal hal yang selama ini gwe lupain
ternyata menjadi sangat berarti. Thanx buat semua yang udah ngedukung gwe
terutama my mommy tercinta.. I Love U Mom....
Oke but life must still go on. sekarang gwe mesti belajar dari pengalaman
smangat semuanyaaaa
hidup itu mesti disyukuri
nikmati aja kalo susah atau pun senang
karena semuanya pasti ada hikmahnya

.:cool_sinchan@yahoo.com:.

Avatar Book 3 Fire Chapter 1 The Awakening

noreply@blogger.com (c4nx3) — Thu, 27 Sep 2007 07:52:00 +0000

Akhirnya keluar juga setelah sabar menanti
Buat Yang Mau nyedot silahkan
Download :http://www.sendspace.com/file/5kjejb

.:cool_sinchan@yahoo.com:.

Rush Hour 3 + bourne ultimatun (Bajakan again ! )

noreply@blogger.com (c4nx3) — Thu, 23 Aug 2007 07:23:00 +0000

loh kok ada yang lewat2 lagih...waduh...sereemm

nih pelem kocak, tapi aneh alur ceritanya....

.:cool_sinchan@yahoo.com:.

Minilyrics + HyperIm Tools Buat Winamp

noreply@blogger.com (c4nx3) — Tue, 21 Aug 2007 02:45:00 +0000

Iseng Iseng Muter muter ngedownloadin aplikasi nggak jelas
akhirnya nemu nih dua
Minilyrics : hehehe ini tools buat nampilin lirik,
kalo nggak ada dia bisa auto download liriknya looo mantep deh
nih linknya bisa dikolaborasiin ama YM katanya cuma gwe blom nyoba aja

download aja disini : http://www.crintsoft.com/minilyrics.htm

HyperIm: Ini buat nampilin judul lagu di YM IM dan mesenger lain, Mantep deh

Download nya cari disini
http://www.softpedia.com/progScreenshots/HyperIM-Screenshot-26105.html

.:cool_sinchan@yahoo.com:.

Baso Bakar + Es Krim Rujak

noreply@blogger.com (c4nx3) — Wed, 15 Aug 2007 04:07:00 +0000

Es Krim Rujak

Baso Bakar Mantab

lokasi: waroeng kampoeng dekete boboho bantarjati bogor

.:cool_sinchan@yahoo.com:.