Langsung ke konten utama

Postingan

Menampilkan postingan dari Januari, 2017

List History WIndows Update dengan Menggunakan Command Prompt

Here i will share how to list windows update history with command prompt. first you must open command prompt, to list your computer list of history windows update you can try this command: wmic qfe list and you will see list of your pc windows update history, C:\Windows\system32>wmic qfe list Caption                                        CSName         Description      FixComments  HotFixID   InstallDate  InstalledBy                  InstalledOn http://support.microsoft.com/?kbid=2479943     JAMALLUDIN-PC  Security Update               KB2479943               NT AUTHORITY\SYSTEM          9/29/2015 http://support.microsoft.com/?kbid=2509553     JAMALLUDIN-PC  Security Update               KB2509553               NT AUTHORITY\SYSTEM          9/29/2015 http://support.microsoft.com/?kbid=2510531     JAMALLUDIN-PC  Security Update               KB2510531               NT AUTHORITY\SYSTEM          9/29/2015 http://support.microsoft.com/?kbid=2511455     JAMALLUDIN-PC  Se

Login Error "The Security Database on the Server Does Not Have a Computer Account for This Workstation Trust Relationship"

Last 3 month we have problem on several user which can't change password when user password is expired. We get error message "The Security Database on the Server Does Not Have a Computer Account for This Workstation Trust Relationship" when we try to change the password. Consider the following scenario:     - You have a domain controller that runs Windows Server 2008 R2.     - You perform an authoritative restore action on the KRBTGT account.     - You log on to a Windows 8.1 client, a Windows 8 client with the Kerberos.dll file from update 2883201 or a later update, or a Windows 7 client with update 2845626 or a later update.     - You try to reset or change the domain password. In this scenario, the password cannot be reset or changed. Additionally, you receive the following error message: "The security Database on the server does not have a computer account for this workstation trust relationship" This issue occurs because the Win

Bagaimana cara Install PHP 5.6 AND PHP 7 Pada UBUNTU 16.04 LTS (XENIAL XERUS)

Jika kamu kesulitan untuk menginstall php5 dan php7 pada ubuntu server 16.4 simak tutorial berikut ini. Pertama-tama kita perlu menambahkan php 5 PPA dan melakukan update pada repository data pada server kita, untuk melakukan nya kita tinggal execute command berikut : sudo apt-add-repository -y PPA:ondrej/php sudo apt-get -y update Jika kamu familiar dengan repository ini, kamu akan tau bahwa versi php tidak termasuk dalam PPA repository, untuk ubuntu 16.4 baik php 5.5 ataupun php 5.6 keuda-duanya termasuk dalam PPA repository tersebut, jika kamu masih ingin menggunakan versi php di bawah 5.4 kamu hanya bisa install di server ubuntu versi di bawah 16.4 atau bisa menggunakan ubuntu versi 14.4 LTS Trusty Tahr. Sekarang kita bisa menginstall baik itu php 5.6 atau 5.5 dan php 7, bersamaan dengan support untuk apache dan MySQL termasuk bermacam php modul seperti module yang di perlukan untuk framework laravel. Execute command berikut untuk installasi; sudo apt-get -y instal

MySQL Error #1055

When i deploy an application i have several problem with mysqlserver, i have error message "#1055 - Expression of SELECT list is not in GROUP BY clause and contains non aggregated column this is incompatible with sql_mode=only_full_group_by" after search several time i have a solution, the solution is to disable the only_full_group_by setting on mysql server; Method one : You can disable the only_full_group_by by login to mysql server and execute this command; mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; or you can edit /etc/mysql/conf.d/mysql.cnf [mysql] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION afte

OTRS - INNODB ERROR LOG FILE SIZE

I attempt to install OTRS but I got error when check the database setting likes image bellow; After some research I know that innodb was not enable on mysql, The solution is try to add configuration on /etc/my.cf like bellow; innodb=on innodb_log_file_size=512M innodb_log_files_in_group=4 Restart mysql service and try again;