Change timezone in Redhat linux

Run these command

rm -f /etc/localtime

ln -s /usr/share/zoneinfo/Asia/Bangkok /etc/localtime

Why does the Green Bar not appear for Google Chrome?

Problem
When accessing a secure site with a Extended Validation (EV) SSL certificate, the green bar and the company name does not display to the right of the lock icon in the Google Chrome address bar.

Resolution
- Click the Tools menu
- Select Options
- Click the Under the Hood tab
- Select the "Check for server certificate revocation" checkbox
- Click Close

If the green bar or the organization's name is still not displayed, it may be due to one of the following conditions:

- The website might not use an EV-SSL certificate. EV certificates provide extra assurance as to the identity of the website, but not all websites using SSL use EV-SSL certificates.
- The website might contain security errors, such as mixed content or expired certificates.

Firefox does not display green address bar when visiting a web site with Extended Validation certificate

Problem
When accessing a web site with an Extended Validation certificate, you may experience the following behavior:

Green bar does not appear for Firefox users

Cause
Currently, Extended Validation certificates are natively supported by Internet Explorer 7, Firefox 3.x+, Opera 9 and Safari 3.2+.

Resolution
To resolve this problem, ensure Online Certificate Status Protocol (OCSP) is enabled.

- Open Firefox browser
- From the tool bar, click Tools > Options > Advanced > Encryption tab > Validation
- Ensure Use OCSP to validate only certificates that specify an OCSP service URL is checked

How to transfer the logins and the passwords of SQL Server

How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008

How to transfer logins and passwords between instances of SQL Server

How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008

How to move databases between computers that are running SQL Server

Green address bar does not appear with Microsoft Internet Explorer

Problem
When accessing a website securely with Extended Validation SSL Certificate, you may experience the following behavior:

The green address bar does not appear.

Cause

This issue occurs when one of the following conditions are true:

- The Phishing Filter built into Internet Explorer 7 is not enabled
- Smart Screen Filter built into Internet Explorer 8/9 is not enabled
- Any certificate related error message prior to accessing the secure site will prevent the Green Bar from being displayed when connecting to a secure web site with an Extended Validation SSL certificate installed
- The Root CA Certificate does not exist on the computer
- The Intermediate Certificate Authority (CA) certificates are not installed on the Web server
- Non secure content displayed on the web page

Resolution

Method 1: Enable Phishing Filter/Smart Screen Filter on Internet Explorer

To resolve this problem for Internet Explorer 7, perform the following steps:

1. Open Internet Explorer 7
2. Click Tools > Phishing Filter > Turn Off/On Automatic Website checking
3. Ensure Turn on automatic Phishing Filter (recommended) is selected
4. Click OK

If web site is access through the Local Intranet zone, the phishing filter is turned off by default. To enable:

1. Open Internet Explorer 7
2. Click Tools > Internet Options > Security
3. Select Local intranet zone
4. Click Custom level
5. Under Miscellaneous, ensure Use Phishing Filter is enabled for all zones

To resolve this problem for Internet Explorer 8/9, perform the following steps:

1. Open Internet Explorer 8
2. From the top menu, click Tools > Internet Options
3. Click Advanced tab
4. Under Security, check the box Enable SmartScreen Filter
5. Click Apply > OK

If the problem persists, determine which security zone is used when accessing the website.

1. After accessing the website, in the lower right hand corner, confirm the zone: Internet, Intranet, or Trusted Site
2. From the top menu, click Tools > Internet Options > Security tab
3. Select the appropriate zone from step 1
4. Click Custom Level
5. Under Miscellaneous > Use SmartScreen Filter, click Enable
6. Click OK

Method 2: Check for possible certificate errors

The security certificate presented by this web site was not issued by a trusted certificate authority

Note: If the Root CA is not uploaded to the Windows XP machine via Windows Update, the chain of trust will not be complete and the certificate will not be trusted

The security certificate presented by this web site has expired or is not yet valid

The security certificate presented by this web site was issued for a different web site's address

Non secure content displayed on the web page. Typically these are images or scripts that reside on a server that is not secured. Links to this type of content must contain 'https'

If any of theses alerts are presented by Internet Explorer, the Green Bar will not display.


Method 3: Enable the Check for Server Certificate Revocation

- Start an Internet Explorer 7 browser session
- Go to Tools > Internet Options
- Click on the Advanced tab
- Under the Security section, check the box next to Check for server certificate revocation
- Click Apply > OK

Method 4: Ensure Update Root Certificate component is enabled

1. Click Start > Control Panel > Add or Remove Programs > Add/Remove Windows Components
2. Ensure Update Root Certificates is checked

You can download Update for Root Certificate from Microsoft.

Note: This will not take effect until after you restart Internet Explorer


The EV OID must be activated on behalf of Microsoft for the Green Bar to appear. Tentatively this is set to occur On January 31, 2007.

How to enable NTFS filesystem on linux kernel

Introduction

kernel version m.n.x-y
m = major version number
n = minor version number (revision number and development status (odd number = development version and even number = stable version))
x = patch level
y = extra version number

{arch} = architecture

Required Package:
kernel-source
dev86
glibc-devel
make
gcc
binutils
ncurses-devel
cpp

Begin:
# cd /usr/src/linux-m.n

create default config from old kernel
# cp config/kernel-m.n.x-{arch}.config .config

modify kernel config
# make config - interactive
# make menuconfig - text mode
# make xconfig - gui mode

Edit extra version number
# vi /usr/src/linux-m.n/makefile

EXTRAVERSION=-yntfs

Check dependencies
# make dep

Remove certain files from previous compile operation
# make clean

Compile kernel source and build to file "bzImage"
# make bzImage

Compile dependencied modules
# make modules

Install compiled modules to /lib/modules/m.n.x-yntfs
# make modules_install

Install new compiled kernel to boot loader

Make initial ramdisk
# mkinitrd /boot/initrd-m.n.x-yntfs.img m.n.x-yntfs

Copy symbol table of the compiled kernel source to /boot
# cp /usr/src/linux-m.n/System.map /boot/system.map-m.n.x-yntfs

Copy new compiled kernel to /boot
# cp /usr/src/linux-m.n/arch/{arch}/boot/bzImage /boot/vmlinuz-m.n.x-yntfs

Backup config file of the compiled kernel source
# cp /usr/src/linux-m.n/.config /boot/config-m.n.x-yntfs

Add boot menu to grub boot loader
# vi /etc/grub.conf

# append these lines to grub.conf

# (hd0,0) = first partition of first hard drive

# /dev/VolGroup00/LogVol00 = volume or partition for / mountpoint

title Linux with NTFS support (m.n.x-yntfs)
root (hd0,0)
kernel /vmlinuz-m.n.x-yntfs ro root=/dev/VolGroup00/LogVol00 rhgb quiet
initrd /initrd-m.n.x-yntfs.img

Restart machine and select new compiled kernel in boot menu then check known file systems
# cat /proc/filesystems

for loop example in bash

Example 1

for i in 1 2 3 4 5
do
echo $i
done

Example 2

for i in {1..5}

do
echo $i
done

Example 3

for ((i=0; i<=5; i++))

do
echo $i
done

Example 4

Bash v4.0+ has inbuilt support for setting up a step value using {START..END..INCREMENT} syntax:

for i in {1..10..2}

do
echo $i
done

Linux System Monitoring Tools

1. top - Displays dynamic real-time view of a running system

2. vmstat - Report virtual memory statistics

3. w - Show who is logged on and what they are doing.

4. uptime - Tell how long the system has been running.

5. ps - display information about the current processes.

6. free - Display amount of free and used memory in the system

7. iostat - Report CPU statistics and input/output statistics for devices and partitions.

8. sar - Collect, report, or save system activity information.

9. mpstat - Report multiprocessors related statistics.

10. pmap - report memory map of a process

11. netstat - Print network connections, routing tables, interface statistics, masquerade connections, and multicast memberships

12. ss - Dump socket statistics

13. iptraf - Interactive IP traffic Monitor

14. tcpdump - Detailed Network Traffic Analysis

15. strace - Trace system calls and signals

16. /Proc file system - Process information pseudo-filesystem.

17. Nagios - Application, Services, Servers And Network Monitoring with Email and SMS alert

18. Cacti - Web-based Monitoring Tool

19. KDE System Guard - Real-time Systems Reporting and Graphing

20. Gnome System Monitor - Real-time Systems Reporting and Graphing

21. nmap - network exploration tool and security auditing.

22. lsof - list open files

23. ntop - web based network traffic probe that shows the network usage, similar to what the popular top Unix command does.

24. Conky - light-weight system monitor for X, that displays any information (uname, uptime, CPU usage, mem usage, disk usage, "top" like process stats, and network monitoring,) on your desktop.

25. GKrellM - Single process stack of system monitors that can used to monitor CPUs, Process, Disk, Network Interface, Memory, File system, Temperature, fan, voltage sensor monitors, and many other things.

26. vnstat - a console-based network traffic monitor. It keeps a log of hourly, daily and monthly network traffic for the selected interface(s).

27. htop - htop is an enhanced version of top, the interactive process viewer, which can display the list of processes in a tree form.

28. mtr - a network diagnostic tool that combines the functionality of the traceroute and ping programs.

29. users - print the user names of users currently logged in to the current host

How can I know what configure options were used to compile it?

You can see the configure options using the mysqlbug command-line utility.

In your shell type mysqlbug and you'll see a template e-mail for bug submission.
At the bottom end of that e-mail you can see the configure line with all the options your copy of MySQL was compiled with.

Reference: http://serverfault.com/questions/62212/configure-options-mysql-server-was-compiled-with

Windows x64 problem: The 'Microsoft.Jet.OLEDB. 4.0' provider is not registered on the local machine.

Cause:

There is no 64 bit version of Microsoft Jet OLE DB driver.

Resolution:

1. Install lastest service pack for windows

2. Force program to run as a 32 Bit application. In order to do this, you need utility found in .NET SDK named corflags.exe.

>> corflags program.exe /32BIT+

2. For run on IIS, you need to enable 32 bit applications on IIS

>> cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1