a day to write, a day to change

Latest

Install Mono 3.4.1 on Ubuntu Server 12.04 64bit

Right after this tutorial, I wanna try to install mono 3.4 that have .net 4.5 luxury on my Ubuntu Server.

1. Go to https://github.com/mono/mono, I try the c option. Building the software from Git.

2. Make sure you have git : sudo apt-get install git automake.

3. git clone git://github.com/mono/mono.git. Be passion, it takes long to download all mono source.

4. Go into mono directory: cd mono.

5. I have an error that I don’t have libtool package after running this  :

./autogen.sh –prefix=/usr/local

So, from this tutorial, I have to install it first :

apt-get install libtool automake autoconf autotools-dev

6. ./autogen.sh –prefix=/usr/local

7. make install

8. Check installed mono version : mono –version

Image

9. Done!. Deploy your .net 4.5 apps.

 

Install MonoDevelop 5.1 on fresh Ubuntu 14.04 LTS 64bit

I use davidloo tutorial and I wanna add some point from my experience.

1. sudo apt-get install git automake gnome-sharp2 mono-xsp4

2. git clone https://github.com/mono/monodevelop.git

3. cd monodevelop

4. ./configure –profile=stable

At this point I have error “No package ‘glade-sharp-2.0′ found.” and with ‘monodoc’ package.

The solution is to install that packages from synaptic. 

apt-get install synaptic

Check this on synaptic and click Apply :

Image

Image

 

And run configure again.

4. ./configure –profile=stable

5. sudo make install

And now you have MonoDevelop 5.1 and .net 4.5.

Image

 

Deploying Oracle Application using ODP.Net on Win7 32 bit

1. Login as administrator

2. Image Download ODAC XCopy Version 32 bit.

3. Image Unzip the packages.

4. Image Open cmd and Run as administrator.

5. Image  Go to unpackage ODAC folder. Type “install.bat all c:\oracle myhome” on command-prompt.

6. Image Create new Value on Path Environment Variables “c:\oracle;c:\oracle\bin”.

7. Done!.

Add SoapHeader to php-wsdl-2.3

1. Add this function to class.soapdemo.php

Snap 2014-05-12 at 14.28.31

 

2. Edit overridden method __Call on SoapDemoSoapClient.php to add SoapHeader :

Snap 2014-05-12 at 14.30.23

 

Done!.

 

PHP Webservice using php-wsdl-2.3

I want some alternative deploying soap web service on linux.
While there’s solution on .Net like ServiceStack, It’s difficult to deploy it on Linux using Nginx and fast-cgi.
So I’m googling php alternative. It’s in https://code.google.com/p/php-wsdl-creator/. And it’s damn easy.
1. After download it, put it in your var/www or xampp htdocs.
2. Change CreateInstance parameter demo.php code :
Snap 2014-05-12 at 14.18.26
3. Run it :
 Snap 2014-05-12 at 14.22.00
 
or just http://localhost:82/phpwsdl23/demo.php to see the description.
4. You can acces it using soapui, or .net service reference, or using php http://localhost:82/phpwsdl23/demo.php?PHPSOAPCLIENT.
Snap 2014-05-12 at 14.24.52

How to pg_dump

e:\Program\PostgreSQL\9.2\bin>pg_dump –file=your-path-file-to-dump-data -s -U <user-name> <database-name>

Mutasi SIM for dummy

Daerah Asal
  • Fotokopi KTP terbaru dan SIM lama.
  • Urus surat mutasi di daerah asal menggunakan fotokopi diatas. Waktu: sehari cukup untuk mudik.
 
Daerah Tujuan (Sidoarjo)
  • Pengurusan SIM baru dilakukan di Polres. Waktu penulisan ini, pintu masuk sudah pindah di sayap Selatan.
  • Parkir motor/mobil di dalam Polres saja.
  • Pergi ke tempat fotokopi yang ada di lokasi Polres (lokasi ada di belakang masjid, dekat tempat tes SIM A).
  • Bilang ke tukang fotokopi kita mau mutasi dan perpanjangan. Surat mutasi dan fotokopi kita akan di-map.
  • Cek kesehatan. Lokasi ada di luar Polres. Yaitu tepat di sayap Utara. Membayar total 55 ribu. 
  • Perjalanan ke lokasi cek kesehatan tersebut cukup menyehatkan, sambil meladeni para calo yang menawarkan jasa.
  • Pergi ke Gudang arsip untuk mendapat stempel. Gudang ini tepatnya persis di utara parkir motor.
  • Pergi ke ruang pelayanan SIM utama (ruang pelayanan sudah mirip Bank, bedanya hanya jumlah orang yang dilayani lebih banyak..banyak sekali).
  • Pelayanan perpanjangan ada di meja paling Utara. Penting, harap antri!. 
  • Bilang kita sudah cek kesehatan dan sudah dapat stempel gudang arsip. 
  • Menerima formulir sim dan tanda pembayaran Bank BRI. Isi formulir tersebut.
  • Pergi ke Bank BRI, masih di dalam lokasi Polres dan membayar Rp. 75.000,-.
  • Kembali ke ruang pelayanan SIM utama dan menyerahkan map ke loket tengah.
  • Tunggu formulir kita dientri, dan siap untuk foto. Nama kita akan dipanggil. Berkas akan kita ambil kembali dan mendapat nomor antrian foto.
  • Pergi ke ruang foto dan tunggu di dalam ruang foto. Berkas dibawa saja sambil menunggu nomor antrian kita dipanggil.
  • Jika sudah dipanggil, cek kebenaran entri dan jika sepi langsung sidik jari jempol kiri dan kanan, serta tandatangan, lanjut foto.
  • Tunggu diluar ruang foto, nama kita akan dipanggil jika SIM sudah jadi.
  • Total sekitar 2 jam. Saya urutan ke 106, mulai mengurus sekitar jam 8.30.
  • Live happily ever after with your new license. 

PostgreSQL : Show idle open connection that need to kill

select * from pg_stat_activity

Please review your code design so it will close connection if there’s an error.

PostgreSQL 9.2.1 move data folder

I found difficulty when I wanna move data folder of PostgreSQL. After googling stackoverflow, I try my own way:

1. Backup data folder.

2. Uninstall PostgreSQL and Re-Install PostgreSQL. Remember to use the same installer version.

I move folder installation from C to E.

3. Stop service.

4. Copy content of data backup folder and paste to folder data new installed. All the folder excep *.conf, *.pid, *.opts.

5. Start service. 

The theory is this won’t work if you try to upgrade from older PostgreSQL version. Use pg_upgrade instead.

 

PostgreSQL error : function crosstab(unknown) does not exist

Solution steps :

1. Login to your schema

2. CREATE EXTENSION tablefunc;

Done!.

 

Follow

Get every new post delivered to your Inbox.

Join 26 other followers