Category: Development

How to fix error 10013 on XAMPP MySQL Windows 10 even no MySQL installed

If you experiencing error like below even you don’t have any another mysql server installed OR no other programs/application use port 3306 and try change any other port still have the same error 2021-05-25 20:26:07 0 [ERROR] Can’t start server: Bind on TCP/IP port. Got error: 10013: An attempt was made to access a socket…
Read more


May 27, 2021 0

Devexpress Xamarin.Forms UI Controls free for limited time

Devexpress offer free copy of Devexpress Xamarin.Forms UI control v20.2 from untill November 1, 2021 23:59GMT. You can check from https://www.devexpress.com/xamarin/free-offer/. The free offer contains Xamarin Data Grid v20.2.x Xamarin Scheduler v20.2.x Xamarin Chart v20.2.x Xamarin Collection View v20.2.x Xamarin Data Form & Editors v20.2.x Xamarin Drawer & TabView v20.2.x Once you register, you can…
Read more


May 23, 2021 0

Mengaktifkan http authorization header untuk REST API pada Bitnami WordPress di AWS

Jika anda mengalami kendala dalam mengirimkan http authorization REST API saat mencoba mengakses REST API WordPress, terutama pada Bitnami WordPress di AWS, sedangkan anda sudah mengaktifkanĀ  RewriteCond %{HTTP:Authorization} ^(.*) RewriteRule ^(.*) – [E=HTTP_AUTHORIZATION:%1] SetEnvIf Authorization “(.*)” HTTP_AUTHORIZATION=$1 pada file .htcaccess di root folder wordpress dan tetap tidak bisa mengirimkan http authorization REST API, maka anda…
Read more


May 23, 2021 0

Download .NET Framework 2.0 – 4.8

Sometimes you download a program from internet or from your software vendor and cannot run because your Windows doesn’t have .net framework runtime, OR you need run your old application but missing .net framework, you can download it here and choose which version you need Download link http://gestyy.com/eekrhz This is the content of the folder:…
Read more


September 10, 2020 0

Upgrade Lightsail Instance

Untuk melakukan upgrade lebih mudah dibandingkan dengan downgrade, berikut ini langkah-langkahnya: Stop intance yang aktif buat snapshot sambil menunggu proses snapshot, detach dulu instance yang lama dari ip public setelah snapshot terbentuk, klik pada tanda titik 3 di sebelah kanan snaphot Pilih create new instance pilih instance yang lebih tinggi setelah terbentuk, attach instance yang…
Read more


July 22, 2020 0

DOWNGRADE WORDPRESS LIGHTSAIL AWS

Lightsail dari AWS merupakan cara termudah untuk membuat VPS di AWS, berbeda dengan EC2, dimana kita masih harus memilih ukuran storage, memory dan processor yang sesuai dengan kebutuhan kita sendiri. Nah, Lightsail ini sudah ada pricing nya sendiri dan FIXED hardware, perhatikan gambar di bawah ini JIka diperhatikan, bahwa pasangan antara VCPU, memory, storage, data…
Read more


July 22, 2020 0

Setup Bitnami WordPress Multisite sub Direktori pada AWS EC2

Sekitar awal bulan Juni 2020 saya mendapatkan kesempatan credit AWS selama 2 tahun dari program AWS Startups (https://aws.amazon.com/startups/), iseng-iseng ikut, ternyata mendapatkan credit yang cukup banyak selama 2 tahun plus premium support selama 1 tahun. Setelah dapat credit, langsung saya coba migrasi aplikasi wordpress dari shared hosting ke AWS, proses instalasi cepat, dan aksesnya juga…
Read more


July 17, 2020 0

Trigger AutoNumber di SQL Server

Berikut ini trigger buatan saya untuk membuat autonumber, mungkin belum sempurna 100%, tapi paling tidak sudah berjalan dalam 3 tahun terakhir === begin trigger === SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[ti_Quotation] ON [dbo].[Quotation] after insert AS declare @xcounter nvarchar(100), @tahun nvarchar(2), @bulan nvarchar(2), @nomor int; declare @curr_tahun nvarchar(2), @curr_bulan nvarchar(2);…
Read more


August 19, 2017 0

Saving bandwidth when downloading Visual Studio 2017

Today Microsoft release Visual Studio 2017, in the my previous post, you can download offline install of Visual Studio, but for some people, they just need Desktop development only, no need to download all component which is total around 18GB. To saving your bandwidth, download only what you need, use –add <workload_id> options,for example: I…
Read more


March 7, 2017 0

Step by step using Microsoft Synchronize SDK for multi client

Prepare SQL Server Local Cache Start command prompt Check your localdb version, if you want deploy to 32 bit client, you should use version 12.xx (SQL server 2014 LocalDB) Type sqllocaldb v To check SqlLocalDB Instannce, use sqllocaldb i If you have 2 version, now check your MSSQLLocalDB server version If the version is not…
Read more


January 7, 2017 0