Wednesday, July 6, 2011

Mysql command

Join tables on common columns.

mysql> select lookup.illustrationid, lookup.personid,person.birthday from lookup left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;

Wednesday, January 12, 2011

This is a linux command line reference for common operations.

CommandDescription
apropos whatisShow commands pertinent to string. See also threadsafe
man -t ascii | ps2pdf - > ascii.pdfmake a pdf of a manual page
 which commandShow full path name of command
 time commandSee how long a command takes
time catStart stopwatch. Ctrl-d to stop. See also sw
dir navigation

Tuesday, December 28, 2010

Cài đặt và cấu hình Subversion


1-      Cài đặt apache và svn:  yum install --exclude=*.i386 httpd* mod_dav_svn
2-      Cấu hình web apache:  vi /etc/httpd/conf.d/subversion.conf

+ Đường dẫn lưu trú của repos : /var/www/svn/kimsach/
            Cách tạo:
            #mkdir /var/www/svn
            #svnadmin create /var/www/svn/kimsach

Thursday, December 16, 2010

Checking the file attributes using lsattr

lsattr is a command line program for listing the attributes on a Linux second extended file system
It is also a command to display attributes of devices on an AIX operating system

Tuesday, December 14, 2010

Quản lý tri thức-Một xu hướng của quản trị kinh doanh hiện đại

Trong điều kiện toàn cầu hóa kinh tế đang diễn ra một cách nhanh chóng trên toàn thế giới, cùng với sự phát triển với tốc độ chóng mặt của cuộc cách mạng khoa học kỹ thuật và công nghệ, các công ty đối mặt với rất nhiều cơ hội và thách thức do toàn cầu hóa và cuộc cách mạng khoa học - kỹ thuật - công nghệ mang lại. Nguồn nhân lực đã trở thành “một tài sản quý nhất, quan trọng nhất và quyết định nhất” cho sự tồn tại và phát triển của bất kỳ một tổ chức nào. Song, khi chúng ta nói về những nhận thức được hầu hết mọi người chấp nhận này thì cần phải hiểu đó là nguồn nhân lực có tri thức, có kỹ năng ở trình độ cao, biết lao động sáng tạo chứ không phải sức lao động cơ bắp dựa trên kinh nghiệm. Lực lượng lao động xã hội đã có sự chuyển biến rõ rệt từ những công nhân “cổ xanh” là chủ yếu thành những công nhân “cổ trắng” là chủ yếu.  Peter Drucker (1993)-một chuyên gia hàng đầu của lý luận quản lý- đã nhận xét rằng: “Trong thời kỳ 1880, khoảng chín phần mười số người lao động là lao động chân tay; ngày nay, con số này giảm xuống một phần năm. Bốn phần năm lực lượng lao động là những người lao động tri thức”.

Monday, December 6, 2010

Bandwidth, Network and Servers Monitoring tools with Installation Tutorials

Nagios

Nagios is a host and service monitor designed to inform you of network problems before your clients, end-users or managers do. It has been designed to run under the Linux operating system, but works fine under most *NIX variants as well. The monitoring daemon runs intermittent checks on hosts and services you specify using external "plugins" which return status information to Nagios. When problems are encountered, the daemon can send notifications out to administrative contacts in a variety of different ways (email, instant message, SMS, etc.). Current status information, historical logs, and reports can all be accessed via a web browser.

Installation and Configuration

http://www.debianhelp.co.uk/nagios.htm

Oreon

Oreon© is an Open Source monitoring solution based on Nagios. It offers to this monitoring standard a new front end and brings it a panel of new functionalities.

Installation and Configuration

Friday, November 5, 2010

The services of Centos

Stop unnecessary services for your system which are enabled on the default settings
NetworkManager The NetworkManager daemon attempts to keep an active network connection available at all times.  
acpid Advanced Configuration and Power Interface event daemon.  
anacron Anacron can be used to execute commands periodically, with a frequency specified in days.  
apmd Advanced Power Management (APM) BIOS utilities for laptops.  
atd atd runs jobs queued by at.  
auditd The audit package contains the user space utilities for storing and searching the audit records generate by the audit subsystem in the Linux 2.6 kernel. *
autofs autofs controls the operation of the automount(8) daemons running on the Linux system.  
avahi-daemon Avahi mDNS/DNS-SD daemon Avahi is a fully LGPL framework for Multicast DNS Service Discovery.  
avahi-dnsconfd avahi-dnsconfd is a small daemon which may be used to configure conventional DNS servers using mDNS in a DHCP-like fashion.  
bluetooth It provids wireless connections among computers.  
conman ConMan is a serial console management program designed to support a large number of console devices and simultaneous users.  
cpuspeed This program monitors the systemfs idle percentage and reduces or raises the CPUsf clock speeds and voltages accordingly to minimize power consumption when idle and maximize perfor-mance when needed.  
crond The daemon to execute scheduled commands. *
cups It's the print system.  
dund It's BlueZ Bluetooth dial-up networking daemon.  
firstboot It's a tool that we can configure basic settings ofthe system by it.  
gpm It's a cut and paste utility and mouse server for virtual consoles.  
haldaemon It searches infomations for hardwares.  
hidd It's Bluetooth HID daemon.  
ip6tables It's IPv6 packet filter administration.  
iptables It's administration tool for IPv4 packet filtering and NAT.  
irda IrDA is a complete implementation of the various IrDA protocols and IrDA drivers for Linux.  
irqbalance It distributes hardware interrupts across processors on a multiprocessor system. *
kudzu It detects and configures new and/or changed hardware on a system.  
lvm2-monitor Monitor LVM2 with using dmeventd.  
mcstrans It's the daemon for SELinux.  
mdmonitor It watches software-based RAID.  
mdmpd It watches software-based RAID.  
messagebus It sends messages between apprications. *
microcode_ctl It's microcode utility for Intel IA32 processors.  
multipathd Manage kernel's function called DeviceMapper.  
netfs It's NFS client.  
netplugd It's the daemon for network cable hotplug management.  
network It's the daemon for network system. *
nfs It's NFS server.  
nfslock It provids file lock function for NFS server.  
nscd Nscd is a daemon that provides a cache for the most common name service requests.  
oddjobd The oddjobd daemon provides the com.redhat.oddjob service on the system-wide message bus.  
pand The pand PAN daemon allows your computer to connect to ethernet networks using Bluetooth.  
pcscd It's PC/SC Smart Card Daemon.  
portmap Portmap is a server that converts RPC program numbers into DARPA protocol port numbers.  
psacct PSACCT is a standard process running on each node that generates daily usage logs containing information on the jobs that ran and how many resources they consumed.  
rawdevices The rawdevices is allocated in the block device.  
rdisc Detect routers in local subnet.  
readahead_early It reads files in page cache early.  
readahead_later It reads files in page cache early when system is running in GUI mode.  
restorecond It's the daemon that watches for file creation and then sets the default SELinux file context.  
rpcgssd It's the daemon which is used for network filesystem like NIS or NFS.  
rpcidmapd It's the daemon which is used for network filesystem like NIS or NFS.  
rpcsvcgssd It's the daemon which is used for network filesystem like NIS or NFS.  
saslauthd saslauthd is a daemon process that handles plaintext authentication requests on behalf of the SASL library.  
sendmail It's SMTP server.  
smartd It's SMART Disk Monitoring Daemon.  
sshd It's OpenSSH SSH daemon. *
syslog It reads and/or clears kernel message ring buffer; set console_loglevel. *
tcsd TrouSerS server daemon  
wpa_supplicant Provide IEEE 802.1x authentication.  
xfs It's X fonts server.  
ypbind ypbind finds the server for NIS domains and maintains the NIS binding information.  
yum-updatesd yum-updatesd provides notification of updates which are available to be applied to your system.