Dokumen perpanjang STNK

Dokumen yang diperlukan untuk perpanjang STNK Samsat Jakarta:

1. Ktp - asli
2. Tanda lunas thn sebelum - asli
3. Stnk - asli
4. Cp ktp
5. Cp stnk
6. Cp bpkb
7. Formulir yang telah diisi

Drive thru Samsat Jakarta:

1. KTP asli
2. STNK dan bukti bayar Asli
3. BPKB asli
4. Pemilik kendaraan
5. Kendaraan

Perpanjangan STNK online install aplikasi SIGNAL–SAMSAT DIGITAL NASIONAL

Debian Buster: install and configure phpmyadmin

Required Apache2, Mysql/MariaDB,  and PHP 7.x

There is no phpmyadmin package in Debian 10 Buster Repository. You need to install it manually.

1. Create folder /usr/share/phpmyadmin/
2. Download phpmyadmin from https://www.phpmyadmin.net/downloads/ and extract into  /usr/share/phpmyadmin/. Note: phpMyAdmin version 4.9.1.
3. Create folder /etc/phpmyadmin/
4. Create a new config file from configuration using file config.sample.inc.php
   # cp /usr/share/phpmyadmin/config.sample.inc.php /etc/phpmyadmin/config.inc.php
5. Create folder /var/lib/phpmyadmin/tmp
   # mkdir /var/lib/phpmyadmin/tmp
6. Edit /etc/phpmyadmin/config.inc.php
   $cfg['blowfish_secret'] = 'ABCDEabcde1234567890ABCDEfghij12'; // random 32 characters
   ...
   /**
    * Directories for saving/loading files from server
    */
   $cfg['UploadDir'] = '/var/lib/phpmyadmin/tmp';
   $cfg['SaveDir'] = '/var/lib/phpmyadmin/tmp';
7. Create apache configuration file for phpmyadmin
   # touch /etc/apache2/conf-available/phpmyadmin.conf
8. Edit /etc/apache2/conf-available/phpmyadmin.conf, copy paste these lines.
   Alias /phpmyadmin /usr/share/phpmyadmin
   
   <Directory /usr/share/phpmyadmin>
       Options SymLinksIfOwnerMatch
       DirectoryIndex index.php
   
       <IfModule mod_php5.c>
           <IfModule mod_mime.c>
               AddType application/x-httpd-php .php
           </IfModule>
           <FilesMatch ".+\.php$">
               SetHandler application/x-httpd-php
           </FilesMatch>
   
           php_value include_path .
           php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
           php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/
           php_admin_value mbstring.func_overload 0
       </IfModule>
       <IfModule mod_php.c>
           <IfModule mod_mime.c>
               AddType application/x-httpd-php .php
           </IfModule>
           <FilesMatch ".+\.php$">
               SetHandler application/x-httpd-php
           </FilesMatch>
   
           php_value include_path .
           php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
           php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/
           php_admin_value mbstring.func_overload 0
       </IfModule>
   
   </Directory>
   
   # Authorize for setup
   <Directory /usr/share/phpmyadmin/setup>
       <IfModule mod_authz_core.c>
           <IfModule mod_authn_file.c>
               AuthType Basic
               AuthName "phpMyAdmin Setup"
               AuthUserFile /etc/phpmyadmin/htpasswd.setup
           </IfModule>
           Require valid-user
       </IfModule>
   </Directory>
   
   # Disallow web access to directories that don't need it
   <Directory /usr/share/phpmyadmin/templates>
       Require all denied
   </Directory>
   <Directory /usr/share/phpmyadmin/libraries>
       Require all denied
   </Directory>
   <Directory /usr/share/phpmyadmin/setup/lib>
       Require all denied
   </Directory>
9. Enabling your phpmyadmin config in apache2
   # a2enconf phpmyadmin
   Note to disable # a2disconf phpmyadmin
10. Reload/restart your apache2
    # systemctl reload apache2

Remove folder /usr/share/phpmyadmin/test/ and /usr/share/phpmyadmin/setup/. You can access your phpmyadmin using http://localhost/phpmyadmin.

If your mysql root (with password) can not login with error:
mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost', do these:

1. using cli connect to mysql
   # mysql -u root -p
   Enter password:
2. Select mysql database
    > use mysql;
   Reading table information for completion of table and column names
   You can turn off this feature to get a quicker startup with -A
   
   Database changed
3. Change root plugin from unix_socket to mysql_native_password
   > update user set plugin='mysql_native_password' where user='root';
   Query OK, 1 row affected (1.372 sec)
   Rows matched: 1  Changed: 1  Warnings: 0
4. restart your mysql
   # systemctl restart mysql

If something goes wrong after you change unix_socket to mysql_native_password, revert it back.

Stop mysql server

# systemctl stop mysql

Start your mysql using mysqld_safe

# mysqld_safe --skip-grant-tables

In other terminal connect to mysql using root user

# mysql -u root
MariaDB [(none)]> user mysql;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'user mysql' at line 1
MariaDB [(none)]> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [mysql]> update user set plugin='unix_socket' where user='root';
\q


Now, You may kill your terminal where mysqld_safe running and start your mysql service normally.

References:

1. https://docs.phpmyadmin.net/en/latest/setup.html
2. https://salsa.debian.org/phpmyadmin-team/phpmyadmin/blob/master/debian/README.Debian
3. https://computingforgeeks.com/install-phpmyadmin-with-apache-on-debian-10-buster/
4. https://docs.phpmyadmin.net/en/latest/config.html#config
5. https://askubuntu.com/questions/998920/1698-access-denied-for-user-rootlocalhost-mysql-5-7-and-ubuntu-16-04

Update date time using batch file

For dual OS, sometimes windows show date incorrect. You need to go setting and force windows to synchronize its date time.
The easy way and fast is using batch files. Using text editor, create batch files for example datesync.bat in your desktop. Write or copy/paste this code:

Echo off
Echo Starting Windows Time Service
net start w32time


Echo Syncronizing Date Time
w32tm /resync
pause

Everytime your date show incorrect, run this script as administrator. It will start windows time service (should not be disable on services.msc) and syncronize date time from internet.

Android Studio 3.5: Clone android project into new android project with diferent name

Requirement and test on Android Studio 3.5

Make sure your old project working properly with your existing android studio library.

1. Copy project directory and rename folder for new project name e.g. Bramara
2. Open your existing new project using Android Studio 3.5. After opening project complete,  Navigate to 1: Project -> Project. You may seen your project only has two directory pointing to new project folder and old project folder. Close your project.
3. Edit appl.iml on directory new project -> app -> appl.iml using text editor. Replace all old project name into new Project Name.
4. Reopen your exising new project. Navigate to 1: Project -> Project. You may seen your project only has one directory.
5. Navigate to 1: Project -> Packages. right click on your component -> Refactor -> Rename.
6. A Warning message will pop up. Make sure all change will apply to new project folder! After that choose Rename packages e.g. com.dedetok.bramara.
7. Navigate to 1: Project -> Android. Open app -> manifests -> AndroidManifest.xml. Fix Application Activity to new pakage name. Change your Application Name to a new one.
8. Open Gradle Scripts -> build.gradle (Module: app), change your applicationId to new project, e.g com.dedetok.bramara and sync project.
9. Clean and rebuild your new project.
10. Your new project to edited/change.

Note: if adb run showing activity not found, edit your Run/Debug Configuration. Module should point to module application e.g. app

Android Studio 3.5.0 and Migrate to AndroidX

System requirement:

Android Studio requirement 3.5 or above

At the end of "Project -> Gradle Scripts -> gradle.properties(Project Properties)" add these lines:

    android.useAndroidX=true
    android.enableJetifier=true

At the end of "Project -> Gradle Scripts -> build.gradle(Project:)" add these lines:

...
buildscript {
    repositories {
        google()
        jcenter()
    }
    dependencies {
        classpath 'com.android.tools.build:gradle:3.5.0'

        // NOTE: Do not place your application dependencies here; they belong
        // in the individual module build.gradle files
    }
}
allprojects {

    repositories {
        jcenter()
        google()
    }
}

Change "Project -> Gradle Scripts -> build.gradle(Module:)" these lines:

androidTestImplementation 'com.android.support.test.espresso:espresso-core:3.0.2' -> androidx.test.espresso:espresso-core:3.2.0

implementation 'com.android.support:appcompat-v7:28.0.0' -> androidx.appcompat:appcompat:1.1.0

implementation 'com.android.support.constraint:constraint-layout:1.1.3' -> androidx.constraintlayout:constraintlayout:1.1.3

androidTestImplementation 'com.android.support.test:runner:1.0.2' -> androidx.test:runner:1.2.0

implementation 'com.google.android.gms:play-services-ads:17.2.1' -> com.google.android.gms:play-services-ads:18.2.0

For Example:

...
    implementation fileTree(dir: 'libs', include: ['*.jar'])
    androidTestImplementation 'androidx.test.espresso:espresso-core:3.2.0'
    implementation 'androidx.appcompat:appcompat:1.1.0'
    implementation 'androidx.constraintlayout:constraintlayout:1.1.3'
    testImplementation 'junit:junit:4.12'
    androidTestImplementation 'androidx.test:runner:1.2.0'
    implementation 'com.google.android.gms:play-services-ads:18.2.0'
  
In Java code, change import android.support.v7.app.AppCompatActivity; to import androidx.appcompat.app.AppCompatActivity;

In activity xml, change android.support.v7.widget.Toolbar to androidx.appcompat.widget.Toolbar

References:

•     https://developer.android.com/jetpack/androidx/migrate
•     https://developer.android.com/jetpack/androidx/migrate/artifact-mappings