Posts

Showing posts from May, 2012

ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist

Image
Lỗi MySQL Hôm nay ở công ty sử dụng "flush privileges" của thằng MySQL tự nhiên bật ra lỗi này: " ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist" Sau một hồi check hóa ra db mysql thiếu bảng này mysql.servers (Chuối). Để khắc phục lỗi trên chỉ cần tạo lại bảng mysql.user trong db mysql là ok USE mysql;  CREATE TABLE `servers` ( `Server_name` char(64) NOT NULL, `Host` char(64) NOT NULL, `Db` char(64) NOT NULL, `Username` char(64) NOT NULL, `Password` char(64) NOT NULL, `Port` int(4) DEFAULT NULL, `Socket` char(64) DEFAULT NULL, `Wrapper` char(64) NOT NULL, `Owner` char(64) NOT NULL, PRIMARY KEY (`Server_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=’MySQL Foreign Servers table’; Test lại: mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) -End-

Cấu trúc cây thư mục trong Linux

Image
Trong bài viết này, chúng tôi sẽ ôn lại giúp bạn về cấu trúc file hệ thống của Linux và ý nghĩa của từng thư mục chính. 1. / - Root Đúng với tên gọi của mình: nút gốc (root) đây là nơi bắt đầu của tất cả các file và thư mục. Chỉ có root user mới có quyền ghi trong thư mục này. Chú ý rằng /root là thư mục home của root user chứ không phải là /. 2. /bin - Chương trình của người dùng Thư mục này chứa các chương trình thực thi. Các chương trình chung của Linux được sử dụng bởi tất cả người dùng được lưu ở đây. Ví dụ như: ps, ls, ping... 3. /sbin - Chương trình hệ thống Cũng giống như /bin, /sbinn cũng chứa các chương trình thực thi, nhưng chúng là những chương trình của admin, dành cho việc bảo trì hệ thống. Ví dụ như: reboot, fdisk, iptables... 4. /etc - Các file cấu hình Thư mục này chứa các file cấu hình của các chương trình, đồng thời nó còn chứa các shell script dùng để khởi động hoặc tắt các chương trình khác. Ví dụ: /etc/resolv.conf, /etc/logrolate.conf 5. /dev

[Ebook] HTTP Essentials: Protocols for Secure, Scaleable Web Sites

Image
Author: Stephen A. Thomas, Stephen Thomas Publisher: John Wiley & Sons Publish Date: 08 March, 2001 The first complete reference guide to the essential Web protocol.  As applications and services converge and Web technologies not only assume HTTP but require developers to manipulate it, it is becoming increasingly crucial for network managers, Web masters, and anyone working with HTTP to understand the nuts and bolts of this most prevalent Web protocol. This book provides complete documentation and explanation of the protocol, including advanced and experimental extensions. Readers will get core guidance on implementing HTTP 1.1 in their products, including how to accelerate HTTP in large scale Web sites, how to secure it, and how to handle compatibility issues with versions 0.9 and 1.0. HTTP switching and invisible HTTP operations such as option negotiations, status checks, and path tracing are also examined.

DSO (mod_php) vs. CGI vs. suPHP vs. FastCGI

Image
This is one of the most common topics that I see customers will ask about. As highly important as PHP handlers are, they often the least understood. They seem complicated, but its not too hard to understand. You don’t have to know that exact science of how it all works, but one should learn the basics if you want to take your website seriously. Picking the right PHP handler for your website will give you the optimal speeds you want and maybe allow you to save some money by using a cheaper hosting package. So I invite you to take a few minutes and learn something new. What are PHP handlers In order to run a PHP site, the server must interpret the PHP code and generate a page when visitors access the website. It interprets the code based on which PHP library you are using, such as PHP 4 or PHP 5. A PHP handler is what actually loads the libraries so that they can be used for interpretation. PHP handlers determine how PHP is loaded on the server. There are multiple different handle

6 Stages of Linux Boot Process (Startup Sequence)

Image
Press the power button on your system, and after few moments you see the Linux login prompt. Have you ever wondered what happens behind the scenes from the time you press the power button until the Linux login prompt appears? The following are the 6 high level stages of a typical Linux boot process. 1. BIOS BIOS stands for Basic Input/Output System Performs some system integrity checks Searches, loads, and executes the boot loader program. It looks for boot loader in floppy, cd-rom, or hard drive. You can press a key (typically F12 of F2, but it depends on your system) during the BIOS startup to change the boot sequence. Once the boot loader program is detected and loaded into the memory, BIOS gives the control to it. So, in simple terms BIOS loads and executes the MBR boot loader. 2. MBR MBR stands for Master Boot Record. It is located in the 1st sector of the bootable disk. Typically /dev/hda, or /dev/sda MBR is less than 512 bytes in size. This has three compon

Top 10 Open Source Bug Tracking System

Image
All IT projects needs a bug tracking (or issue tracking, or defect tracking) system. Sure, we need a bug tracking system for a software development project. But, what about a sysadmin team, dba team, network team? They all need some help to track their work, and issues of their system, database and network. I’ve listed 10 open source bug tracking systems, that you can experiment, and choose based on your taste and requirement. This is not a comprehensive list by any means. I’ve used all the systems listed in the top 5, and I strongly recommend that you choose one from the top 5 list. I love bugzilla, and have been using it for several years. If you don’t have time to play around with multiple systems to figure-out which one you like, just go with Bugzilla. What is your favorite bug tracking system?  Leave a comment and let me know. 1. Bugzilla Are you looking for a stable, actively maintained, widely adapted bug tracking system? Look no further. Bugzilla is for you. This