WARNING: the tzconfig command is deprecated

Quick note for myself :

# date
Sat Jun 21 01:30:45 EDT 2014

# tzconfig
WARNING: the tzconfig command is deprecated, please use:
dpkg-reconfigure tzdata
# dpkg-reconfigure tzdata
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_PAPER = “id_ID.UTF-8”,
LC_ADDRESS = “id_ID.UTF-8”,
LC_MONETARY = “id_ID.UTF-8”,
LC_NUMERIC = “id_ID.UTF-8”,
LC_TELEPHONE = “id_ID.UTF-8”,
LC_IDENTIFICATION = “id_ID.UTF-8”,
LC_MEASUREMENT = “id_ID.UTF-8”,
LC_TIME = “id_ID.UTF-8”,
LC_NAME = “id_ID.UTF-8”,
LANG = “en_US.UTF-8”
are supported and installed on your system.
perl: warning: Falling back to the standard locale (“C”).
locale: Cannot set LC_ALL to default locale: No such file or directory
/usr/bin/locale: Cannot set LC_ALL to default locale: No such file or directory

Current default time zone: ‘Asia/Jakarta’
Local time is now:      Sat Jun 21 12:32:35 WIT 2014.
Universal Time is now:  Sat Jun 21 05:32:35 UTC 2014.

# date
Sat Jun 21 12:33:13 WIT 2014
#

cat 6

Maintain small network where you only dealing with 3 or 4 computer plus a few (around 4 laptop that use wireless connection) machines is simple. Just plug the ADSL modem and turn on dhcp with default setting but when happy problem came (grow bigger to thousand computer)  then its no more room for playing :-)

Yes, most of past problem is came with cable. Good network design without good network cable is like building sandbox. Looks strong but weak inside. Last week we have a job to see a hospital network built by someone that heavily use network cable here and there. You can drying clothes with the cable due to the way they pull the cord.

After look around for almost an hour we came with conclusion, mainly judge old cable they use. We give them online reference too (related to price and youtube videos). Some of them listed here :

Use different colour

By using different colour you can easily identify which cable work as backbone and which cable work as branch, channeled to the client.

Blue cable for backbone and other for client.

Continue reading

How to install Gammu on Lubuntu 14.04

linux insideMy friend bought Wavecom 1306B gsm modem for his campus last task. He use Windows XP and trying to use the modem without success. He try it on his friend laptop that run Windows 7 also not work and he ask me to try it. Just to test the modem. If its not work might then He will return it to the seller.

I use Lubuntu 14.04 but I think the instruction would be same for Ubuntu 14.04 variant :

Install Gammu

# apt-get install gammu
Reading package lists… Done
Building dependency tree
Reading state information… Done
The following extra packages will be installed:
libgammu-i18n libgammu7
Suggested packages:
wammu gammu-doc
The following NEW packages will be installed:
gammu libgammu-i18n libgammu7
0 upgraded, 3 newly installed, 0 to remove and 128 not upgraded.
Need to get 1.051 kB of archives.
After this operation, 3.161 kB of additional disk space will be used.
Do you want to continue? [Y/n] y

………………………..
…………………………..
………………………………
Preparing to unpack …/libgammu7_1.33.0-3_i386.deb …
Unpacking libgammu7 (1.33.0-3) …
Selecting previously unselected package gammu.
Preparing to unpack …/gammu_1.33.0-3_i386.deb …
Unpacking gammu (1.33.0-3) …
Selecting previously unselected package libgammu-i18n.
Preparing to unpack …/libgammu-i18n_1.33.0-3_all.deb …
Unpacking libgammu-i18n (1.33.0-3) …
Processing triggers for man-db (2.6.7.1-1) …
Setting up libgammu7 (1.33.0-3) …
Setting up gammu (1.33.0-3) …
Setting up libgammu-i18n (1.33.0-3) …
Processing triggers for libc-bin (2.19-0ubuntu6) …
# Continue reading

Cheap VPS that support FreeBSD, OpenBSD, NetBSD and many more – KVM SSD technology

Since I retire from my old company I don’t have access to FreeBSD server that I manage. I use FreeBSD since version 4.7 till latest version 9.0 (last version when I retire). The only option I do is using VirtualBox.

With less access to server make my memory get weak but I still get my old post here work when I need together with video made. Last week a friend told me about new VPS provider called Vultr that give great deal.

Location

Start from $5/month or you can choose hourly charge you can choose many location available such as Dallas, Chicago, New Jersey, Los Angeles, Seattle, Washington for USA preferred location. Other server location are Amsterdam, London, Frankfurt, Paris, German for Europe vps preferred location or Sydney and Tokyo for Asia consumer (at the of writing I see 14 location available). I hope in future they can add other for Asia, Singapore for example.

vps with 14 location available; support usa, europe and asia region

Operating System

By default Vultr provide two architecture; 32 and 64 bit. Each bit have their own ‘default’ OS like CentOS, Ubuntu, Debian, FreeBSD and Windows. In 64 bit OS section you have ‘custom iso’ section. This section dedicated for other OS that not available on the list. So far I have try install DragonFlyBSD, FreeBSD and OpenBSD and other Linux variant like Slackware, OpenSuse and Fedora using custom iso and working well.

Price

Price scheme also good I my opinion. I can tell my student to do their experiment using this service. They can get more memory with same price as other provide like DigitalOcean (but DO not provide custom iso).

vps default operating system available plus custom iso and snapshot then price option

Custom Iso Service

custom _iso_vps

Vultr provide custom iso that let you use iso with maximum 5192MB in size, that could be DVD size. Very spoiling me and my imagination. I can do my experiment with so many scenario. For example I can deploy linux distribution that specialize in disk management like gparted the followed by install Slackware OS or vice versa start with OS installation then resize the disk with gparted for new swap and more.

Server Type

I see it from benchmark experiment. I can experiment for server recipe that might involve database load balancing, high availability, data server like ftp and multi processor utilization operation.

cheap vps that provide different type of server; performance series, storage series and multicore series

KVM and SSD Technology

I love KVM since I never face problem with it. Using SSD for fast operation and I think I prefer to use VPS than my ‘dedicated’ server that utilize IDE for some work.

Last time I make deposit, the provider match my deposit 1:1. $10 get $10 so I got $20 in my account. Good for one instance for 4 month or I can switch the operating system each month :-)

My friend told me if the provider maybe try to compete with Digital Ocean so they give same price. I don’t care. Competition is good for customer like us. Give more location, good up time and low latency then your customer ‘soul’ is yours ( Mortal Combat ).

Click here to get your box.

MySQL Tuner on FreeBSD 9.2

I just know if mysqltuner is available via ports.

Quick heads up :

# cd /usr/ports/databases/mysqltuner

# make install

# whereis mysqltuner.pl
mysqltuner.pl: /usr/local/bin/mysqltuner.pl

# /usr/local/bin/mysqltuner.pl

>>  MySQLTuner 1.2.0 – Major Hayden <major@mhtx.net>
>>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
>>  Run with ‘–help’ for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

——– General Statistics ————————————————–
[–] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.34
[OK] Operating on 64-bit architecture

——– Storage Engine Statistics ——————————————-
[–] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[–] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] InnoDB is enabled but isn’t being used
[OK] Total fragmented tables: 0

——– Security Recommendations  ——————————————-
[OK] All database users have passwords assigned

——– Performance Metrics ————————————————-
[–] Up for: 1h 21m 43s (54 q [0.011 qps], 12 conn, TX: 28K, RX: 1K)
[–] Reads / Writes: 84% / 16%
[–] Total buffers: 168.0M global + 2.8M per thread (151 max threads)
[OK] Maximum possible memory usage: 583.2M (5% of installed RAM)
[OK] Slow queries: 0% (0/54)
[OK] Highest usage of available connections: 0% (1/151)
[OK] Key buffer size / total MyISAM indexes: 8.0M/98.0K
[!!] Key buffer hit rate: 50.0% (2 cached / 1 reads)
[!!] Query cache is disabled
[OK] Temporary tables created on disk: 0% (0 on disk / 6 total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 85% (41 open / 48 opened)
[OK] Open file limit used: 0% (48/11K)
[OK] Table locks acquired immediately: 100% (50 immediate / 50 locks)
[!!] Connections aborted: 25%

——– Recommendations —————————————————–
General recommendations:
Add skip-innodb to MySQL configuration to disable InnoDB
MySQL started within last 24 hours – recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Set thread_cache_size to 4 as a starting value
Your applications are not closing MySQL connections properly
Variables to adjust:
query_cache_size (>= 8M)
thread_cache_size (start at 4)

Interesting…. as I see this job is not just set and forget but must be running regularly to identified a running process.

P.S : my.cnf location can be seen from ps command

# ps -ax | grep mysql
96928 ??  Is       0:00.01 /bin/sh /usr/local/bin/mysqld_safe –defaults-extra-file=/var/db/mysql/my.cnf –user=mysql –datadir=/var/db/mysql –pid-file=/var/db/mysql/
97024 ??  I        0:00.91 /usr/local/libexec/mysqld –defaults-extra-file=/var/db/mysql/my.cnf –basedir=/usr/local –datadir=/var/db/mysql –plugin-dir=/usr/local/li

or if its not exist you can copy one from share

# ls /usr/local/share/mysql | grep my-
my-huge.cnf
my-innodb-heavy-4G.cnf
my-large.cnf
my-medium.cnf
my-small.cnf