SSH without password

Yes, it less of security. but I really need it when I want to doing automatic database backup to other computer in each time I turn on my computer.

Then, I got this link. http://lqman.wordpress.com/2008/08/29/ssh-tanpa-password/
I try it, and it worked..

the steps are below:
in example we want doing SSH from mawaddah to prita. So, in mawaddah type the command below in terminal

==================================================
mawaddah@mawaddah-laptop:~$ ssh-keygen
Generating public/private rsa key pair.
Enter file in which to save the key (/home/mawaddah/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/mawaddah/.ssh/id_rsa.
Your public key has been saved in /home/mawaddah/.ssh/id_rsa.pub.
The key fingerprint is:
c1:8d:d4:d7:4a:b0:58:1b:2d:7f:9f:37:dd:9c:6f:fa mawaddah@mawaddah-laptop

mawaddah@mawaddah-laptop:~$ ssh-copy-id -i .ssh/id_rsa prita@192.168.1.246
prita@192.168.1.246's password:
Now try logging into the machine, with "ssh 'prita@192.168.1.246'", and check in:

.ssh/authorized_keys

to make sure we haven't added extra keys that you weren't expecting.

mawaddah@mawaddah-laptop:~$ ssh prita@192.168.1.246
Linux prita 2.6.20-15-generic #2 SMP Sun Apr 15 07:36:31 UTC 2007 i686

The programs included with the Ubuntu system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by
applicable law.
Last login: Fri Nov 7 10:44:46 2008 from mawaddah-laptop.local
prita@prita:~
============================================================

Finish........
thanks for Mr. Luqman

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

I'm currently using lampp-1.6.6 as my php/mysql server in my ubuntu 7.10.

It's very easy to use.. especially when I want to use mysql database server. I just go to their phpmyadmin to create database, import, view, insert, etc..

But the lack is when I want to using import facilities..it has maximum file size to uploaded, that is 2,048 KiB

So, what I must to do when I have to import more that 2MB file size is using mysql from terminal/console..

It seems simply to just use this command:
# mysql -u [username] -p [password] [database_to_restore] < [backupfile]

but it always returned this error:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

what's wrong...??

I search in google to find out if there anyone have the same problem like I have...

yes there are so many people have that problem..

I try one by one solution they recommended but it still fail..

Then, I go to directory /opt/lampp-1.6.6/bin
then I repeat my command one more time.. but it still failed..

Then I change the command just to add ./ that is:
# ./mysql -u [username] -p [password] [database_to_restore] < [backupfile]

then it worked???

My analysis is when I type command: # mysql -u [username] -p [password] [database_to_restore] < [backupfile]

without "./" it will refer to default mysql server which it not currently installed.

SO, of course it will failed...

Bu when I added "./" and I do that in lampp directory it will refering to mysql in lampp..

Hmm I don't know yet how to make mysql in lampp being default mysql database server

Sony Ericsson w200i GPRS Telkomsel Modem in Ubuntu

Basically I just want to maximize the functionality of my cell phone Sony Ericsson w200i which I bought in last March. Yes I have that pc suite for windows OS. But unfortunately, i'm using Ubuntu in my (office) laptop.
SO, I asked to Mr Google and I got this blog
In my first trial, it tutorial could'nt worked for my cell phone. I don't know why, maybe I just make a mistake in entry the phone number or etc.
Then I remember that my friend had ever successfully using my cell phone as modem in a PC Ubuntu. But, I just forgot to asked him how to do that.
Then I try to find in his blog and finally I got a complete but simple step to do that.

Here, I rewrite its steps:
1. Plug the USB Cable of your Sony Ericsson w200i (sew200i) and choose phone mode
2. Of course make sure that your phone still credit on it.
3. Make sure that phone detected in your PC with doing this command in your terminal

mawaddah@mawaddah-laptop:~$ lsusb
Bus 005 Device 001: ID 0000:0000
Bus 004 Device 001: ID 0000:0000
Bus 002 Device 003: ID 062a:0000 Creative Labs Optical Mouse
Bus 002 Device 001: ID 0000:0000
Bus 003 Device 001: ID 0000:0000
Bus 001 Device 002: ID 0fce:d090 Sony Ericsson Mobile Communications AB
Bus 001 Device 001: ID 0000:0000


You can see that device "Sony Ericsson Mobile Communications AB" has been connected

4. Do automatically configuration with this command

mawaddah@mawaddah-laptop:~$ sudo wvdialconf

which will resulting in last line like this:

Found an USB modem on /dev/ttyACM0.
Modem configuration written to /etc/wvdial.conf.
ttyACM0: Speed 460800; init "ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0"
ttyACM1: Speed 460800; init "ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0"


5. Command in no 4 will also creating configuration file wvdial.conf in /etc/
Adjusting that file to needs your gprs spesification.
mawaddah@mawaddah-laptop:~$ sudo vi /etc/wvdial.conf

For telkomsel use this configuration:
[Dialer Defaults]
Init1 = ATZ
Init2 = ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0
Modem Type = USB Modem
ISDN = 0
New PPPD = yes
Phone = *99#
Modem = /dev/ttyACM0
Username = wap
Password = wap123
Baud = 460800

Just make sure you enter the username, password and phone with the valid configuration.


6. Dialing with this command
mawaddah@mawaddah-laptop:~$ sudo wvdial

with that command will resulting this line in the end:
WvDial<*1>: local IP address 114.121.151.189
WvDial<*1>: pppd: ��[06][08]��[06][08]
WvDial<*1>: remote IP address 10.64.64.64
WvDial<*1>: pppd: ��[06][08]��[06][08]
WvDial<*1>: primary DNS address 202.3.208.10
WvDial<*1>: pppd: ��[06][08]��[06][08]
WvDial<*1>: secondary DNS address 202.3.210.10
WvDial<*1>: pppd: ��[06][08]��[06][08]


7. Then your cell phone will give you information that you have been connected to internet.
Just try to test with doing ping
mawaddah@mawaddah-laptop:~$ ping www.google.com
PING www.l.google.com (74.125.95.104) 56(84) bytes of data.
64 bytes from iw-in-f104.google.com (74.125.95.104): icmp_seq=1 ttl=242 time=774 ms
64 bytes from iw-in-f104.google.com (74.125.95.104): icmp_seq=2 ttl=242 time=853 ms
64 bytes from iw-in-f104.google.com (74.125.95.104): icmp_seq=3 ttl=242 time=777 ms
64 bytes from iw-in-f104.google.com (74.125.95.104): icmp_seq=4 ttl=242 time=873 ms



Yeahh... it worked...
But unfortunately tariff of telkomsel gprs still expensive Rp.5/KB
So, when I just open this blog, my friend blog, YM, and my office webmail in just shorttime. It has use Rp.11.385 for 2.277KB...
I'm bankrupt..... :((

Ohyaa, btw I try one more time the steps ini this blog.
Then it worked...

So, thanks for this blog and my friend

enable remote access PostgreSQL

In default, for security reason, postgreSQL doesn't allow to be accessed remoted.
But, we can configure it so it can be accessed remotely.

Below is the step to do that with follow the steps I done with postgreSQL8.2 in Ubuntu OS
1. Login as postgres
# su - postgres
2. edit configuration file (pg_hba.conf)
# vi /etc/postgresql/8.2/main/pg_hba.conf
append below line to that file:
host all all 192.168.1.0/24 trust

where 192.168.1.0 is IP configuration in your network
3. edit configuration file: postgresql.conf to allow TCP/IP socket
# vi /etc/postgresql/8.2/main/postgresql.conf
find line:
listen_addresses='localhost'
and change into:
listen_addresses='*'


4. restart postgreSQl with:
# /etc/init.d/postgresql-8.2 restart

Finisih

openbravo

Convert ogg file to mp3

In last friday, I bought an original CD "Laskar Pelangi"... for the first time I bought with my own money !!!! yippi..

Then the problem is the files in that CD can't copied easily like I bought an pirated cd. It can use software "Alcohol" in windows OS..
But because I used "ubuntu" I use sound juicer to copied all the content of CD. And it worked.

But, it produced files with "ogg" extension. not with "mp3" extension which familiar with my ears. and it not suitable for some music tools.

So, I asked my friend how to convert "ogg" to "mp3". Then I got an answer that is used software "ffmpeg"

I do this steps:
mawaddah@mawaddah-laptop# sudo apt-get install ffmpeg
mawaddah@mawaddah-laptop# ffmpeg -i fileinogg.ogg -ab 128 fileinoggtomp3.mp3

and it worked.. =D

i am extroverted person

Yeah... I'm extroverted person...
So what? hahahahahaha

Finally I know my vision..maybe

Today, my another boss asked me the same question... I told him some condition of me... And finally he make a summary that he know my vision... it just simple, that is "just to make my parents happy" Insya Allah :D

My Future Partner

Hmm...yesterday I involved in a serious topic discussion with my friend from India... that is about his future partner.
< My friend
>Me

Thu Sep 4 2008
(23:49:19) < salam
(23:49:40) > wa'alaikumsalam wrwb
(23:49:43) > hi
(23:49:51) > how are you?
(23:50:21) < Alhamdulillah i am fine
(23:50:24) < how abt u?
(23:52:09) > i'm fine too... thank you..
(23:52:15) > what are you doing now?
(23:52:47) < i am waiting for iftar
(23:53:21) < hey u look busy?
(23:53:41) > hmm not really...
(23:53:54) > iftar? what time is it there?
(23:54:59) < 18:51
(23:55:23) < we have 2 1/2 hours more
(23:55:39) > wooow... that's o long time...
(23:55:49) > thwn what time you got shahur?
(23:56:26) < 5:06
(23:56:56) > so you almost fasting in 15 hour?
(23:57:05) > then how you feel about it?
(23:57:42) < it is ok ,i am used to fast long time
(23:58:01) < Allah gives me power to fast long
(23:58:14) > Subhanallah...
(23:58:39) > where will you get iftar? in mosque?
(23:59:09) < yes
(23:59:23) < becoz i am still single and dont have time to cook

Fri Sep 5 2008
mawaddah_1985
(00:00:53) < :((
(00:01:32) > hmm... do not be sad...
(00:02:02) > so how your try to get a "partner"?
(00:03:35) < hehehhe
(00:03:41) < still dont have to try
(00:04:17) > why?
(00:05:15) < i think ,we dont know each other good
(00:05:35) > you true
(00:05:52) < i am doing my master in germany
(00:06:01) < i am writing my thesis now
(00:06:41) > hmm..so you will finish it before you try to find your partner?
(00:07:38) < yes
(00:07:53) < and i also dont want any german girl as my partner
(00:10:02) > hmmm then what your desire? you really have specific nationality of your partner?
(00:12:00) < no
(00:12:17) < i have no big requirment
(00:12:30) < just simple educated and religios girl
(00:13:21) > so, if you find an educated and religious german girl ... you'll be happy right?
(00:14:58) < i dont want to marry german
(00:17:00) > may i know why?
(00:17:19) < they r not religios
(00:17:39) < may i say u somthing,,but dont laugh
(00:21:19) > ok... i won't
(00:21:41) > what is that?
(00:22:33) < i want to marry a indonesian or malaysian girl
(00:23:42) < :">
(00:24:00) > wuhuuu...
(00:24:12) > why?
(00:24:32) < i tell u later
(00:24:39) > why not arabic, palestin, pakistan... etc which are moslems also?
(00:24:48) < hope u can chat latet insha Allah
(00:25:00) < now i have to leave for masjid
(00:25:15) > oke... i'll be waiting
(00:25:23) > so, happy iftar... :)
(00:26:08) < salam walekum
(00:26:17) > wa'alaikumsalam wr.wb


From above conversation, I summarize that he want a partner that have simple character that is "just simple educated and religios girl"
then he hope that partner is from Indonesia or Malaysia...

Hmm unfortunately we can't continue that discussion, so I can't get the reason why Indonesian or Malaysian??


But, the fact is that he really have a spesific character about his future partner.
Then how about me? I don't know yet...
Yes of course I want my future partner is a religious person, and also educated person... what more?? Must he is a good looked person, or rich person, or etc etc... I don't think so.

How about love?? must the person is a person who I can love him easily... or just enough with that the person is love me...

I know, the best choice is from Allah... My Lovely God who create Love itself... But how I can convinced myself that the choice is really the best choice from Allah...

Fiuhh...... I don't know yet....

My vision in carrier

In this week, there 2 person who had asked me about my vision in carrier.
The first is my sister (a good friend who I deemed as a sister) and the second is my Project Manager (PM) Superior ..

When my sister asked me that question, I answered, " There some vision..(ada lah)"... Then, after I leave her, suddenly I asked myself, "What is my vision?? Is it really there?? What 'ada lah' means??"

In other time, when my PM asked me, I convinced to him that I really don't know my vision, my achievement etc..

I don't know why I try hard to still in my current job with all of the lack and the excess, but also I still don't know where I must go and move on? What the kind of job that I really want to?

In the first times I worked in my current job, I really motivated with my big plan. I want still worked there because I want realized my plan. Then it realized, at least I just wait the chance from My God to permit me finishing that plan.

Then, when that plan realized I don't know what other motivation is it... is it higher position, higher salary??? not really...
specific knowledge?? I haven't decided what it will be?

I just know one motivation, that is I worked in good environment with many good and kind friends with Islamic nuance.
I just wonder, if I can get another job place with the peoples who always motivated me directly or indirectly to be a better person..

And I just know 1 of my achievement, that is have a little company .. specifically virtual company... but I think it still long time to realize it... because it really need mature plans, and need some capital...

Hmm I try with my best to still think about it all...

Hajimemashite

Ich