Skip to main content

Posts

Complete guide to update/upgrade cakephp

This is what people always forgotten. How to update your cakephp to the latest from CLI         phpmamp composer.phar update How to upgrade to 3.* branch     phpmamp composer.phar require --update-with-dependencies "cakephp/cakephp:3.5.*"         ./composer.json has been updated Loading composer repositories with package information Updating dependencies (including require-dev)       - Removing cakephp/cakephp (3.4.13)       - Installing cakephp/cakephp (3.5.6)         Downloading: 100% Writing lock file Generating autoload files Done !
Recent posts

Masalah unetbootin di Mac untuk USB boot

Masalah unetbootin kadang jadi kadang tidak, so solution yang cepat ialah gunakan dd. Kenal pasti USB disk kita dia mac dengan arahan : Yusof$ diskutil list /dev/disk0 (internal, physical):    #:                       TYPE NAME                    SIZE       IDENTIFIER    0:      GUID_partition_scheme                        *240.1 GB   disk0    1:                        EFI EFI                     209.7 MB   disk0s1    2:          Apple_CoreStorage Macintosh SSD           239.2 GB   disk0s2    3:                 Apple_Boot Recovery HD             650.0 MB   disk0s3 /dev/disk1 (internal, virtual):    #:                       TYPE NAME                    SIZE       IDENTIFIER    0:                  Apple_HFS Macintosh SSD          +238.8 GB   disk1                                  Logical Volume on disk0s2                                  CBE9D533-87EA-4C43-87EC-C6D4AB34B87E                                  Unencrypted /dev/disk2 (external, physical):    #:              

DirectAdmin - Upgrading MySQL from 5.5 to 5.6

cd /usr/local/directadmin/custombuild mkdir -p mysql cd mysql wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-client-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-devel-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-server-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-shared-5.5.41-1.linux2.6.x86_64.rpm cd .. ./build mysql_backup mv mysql_backups mysql_backups.`date +%F` #after this point, you can't abort rpm -e --noscripts `rpm -qa | grep MariaDB` cd mysql rpm -ivh MySQL*5.5.41*.rpm #ensure it's running. cd .. ./build set mysql 5.6 ./build set mysql_inst yes ./build mysql # confirm mysqld is running. ./build php n

Building a KVM Proxy

Traditionally we seldomly connect our KVM from the port directly to the server that consists of usb for keyboard and mouse, vga cable for display purposes. More advanced you may have an experience using the iKVM which connect all you kvm port from the internet where you can have a remote location as long as you have the internet connection. When technology evolve, physical server are becoming obsolete since we have the virtualization technology. Since that to access your virtual machine (vm) are more easier. Instead of using SSH, like a Xen hypervisor, the Xen itself can host as a KVM server and map to the vm on different port as configured from the config file.

Exim force remove frozen queue

One of our client got a spam message in queue and almost 14mil of message in queue has been generated by the culprit. The exim itself generated a log file message which do a lot of write process to the log file. Because of that, the server inodes also got exhausted. Really need some cleanup for them :) I've tried to remove the frozen mail queue using several method, and the best command is : exim -bp|grep frozen|awk '{print $3}' |xargs exim -Mrm Other command that you can try : xiqgrep -zi|xargs exim -Mrm exim -bp | awk '/^ *[0-9]+[mhd]/{print "exim -Mrm " $3}' | bash exim -bp | exiqgrep -i | xargs exim -Mrm good luck!

Installing MariaDB 10 on fresh CentOS 6.6

1. Create a repo configuration file vi /etc/yum.repos.d/mariadb.repo Paste the following [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.0/centos6-amd64 gpgkey= https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1   Or you can create your own configuration from MariaDB repo creator https://downloads.mariadb.org/mariadb/repositories/#mirror=neusoft 2. Install MariaDB server and client yum install MariaDB-server MariaDB-client 3. Start service mysql start 4. Enable on boot chkconfig mysql on 5. Run mysql_secure_installation program to secure and check your installation. /usr/bin/mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB       SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we'll need the current password for the root user.  If you've just installed MariaDB, and you haven't set the root password yet, the password will be blank

Upgrading MySQL to MariaDB

Ever since MariaDB exists, I really like to install and test the performance but time consume for my daily work stopped me to try MariaDB, today I plan to update my MySQL server that serve lot of data in and out to MariaDB 10.0 (today latest version :P ) So there's a few step that should be considered before we can proceed further. 1. BACKUP - Always backup your data at the first place. - Save it to the proper place so that if anything goes wrong, you can export back your data. mysqldump -u root -pYOURPASSWORD --all-databases > allbackup.sql & If you don't want to wait and you know that the current database is big, just put the process at the background so that you can monitor the process using top :) - Backup your current configuration files cp /etc/my.cnf /tmp/my.cnf.bak 2. Let's go If you're installing mysql from webtatic and made a replacing package name , you may encountered an error like Error: mysql55w conflicts with MariaDB-server-5.5.