Oracle SQL Plus Command Reference

Introduction

At the SQL prompt, you can begin typing any SQL command. Upon hitting return (i.e., enter key) the SQL prompt will change to line number prompts. When you are finished typing a command, type / or RUN to execute the SQL command. Also, a semicolon at the end of the SQL command will execute the command immediately after hitting return. In addition to SQL commands, /, and RUN, other commands can be issued at the SQL prompt (a semicolon does not have to follow the nonSQL commands).

Commands

  • DESCRIBE tablename -- lists the attributes and their specifications of tablename

I.E. and mozilla firefox vuln discovered !

hunt3r (www.nepsecure.tk) has released a 0 day D0S exploit known to effect I.E. (SP2)
and Mozilla Firefox

http://www.z0mbi3.info/~nepsec/bb/viewtopic.php?t=184

The exploit is simple in design, yet poses a serious threat to these browsers.

Bash Backdoors

Whenever any hacker/cracker manages to get root acceess in a system, his motive mostly is to install a backdoor so that he can return later.This article demonstrates how simple bash backdoors can be made with a few lines of C code and misuse of linux's file permission mechanism.

Read Article

/proc File Systems...

The kernel provides a list of file system types it is able to mount via the /proc file system. To view the list, run the command `cat /proc/filesystems`. The output will look something like:

nodev    proc
         ext3
         ext2
         vfat
         iso9660
nodev    nfs
nodev    smbfs

In this output, the entry vfat means you can mount FAT/VFAT (Microsoft Windows) partitions. The entries ending with smbfs and nfs mean you can interact with file servers that use SMBFS (Microsoft's Server Message Block File System, accessed via Samba) or NFS (Sun's Network File System). The iso9660 indicates that you can mount standard CD-ROM file systems, and ext3 and ext2 indicate that you can mount those kinds of Linux file systems.

Get PHPwiki up and running with mysql

Ran into some difficulty installing the wiki with mysql backend as the documentation wasn't upto-date.

Below are some notes and customization done during the process:

  1. Download the latest tarball from SourceForge
  2. Extract all files.
  3. Copy 'config/config-dist.ini' to 'config/config.ini' and edit the settings.
  4. Make sure to set the value of 'DEBUG' to either 1 or 0 and do not comment it out. The install process complains if the DEBUG value is not found.
  5. Upload the "passencrypt.php" to the web-server and access it via browser to encrypt password.

Nepali Meta Search Engine : www.metalnepal.com

Quoting the site : ..."metanepal.com is Nepal's first metasearch engine. metanepal uses innovative metasearch technology to search the Internet's top search engines, including Google, msn, kanoodle and nepal specific search engines such as explorenepal.com"

Also by the way they also provide a "News Search" feature. Even though this search engine parses the results of different search engines, it still is a valuable tool for web searchers looking esp. at Nepali sites.

MRTG Performance Monitoring Extensions

MRTG is awesome, but by default it’s limited to SNMP metrics.

The MRTG extension packages allow for the monitoring of performance analysis metrics over SSH or locally, and they’re easy to set up, configure and maintain. With these extensions installed, it's possible to monitor UNIX performance metrics such as CPU and memory utilization, as well as paging, swapping and process statistics. Plus, since you don’t need to have an SNMP daemon running, your system is more secure.

Load test your web application with OpenLoad

OpenLoad is a tool for load testing web applications. It aims to be easy to use and providing near real-time performance measurements of the application under test. This is particulary useful when you are doing optimization as you can see the impact of your changes almost immediately.

OpenSource Tomcat Book

Tomcat is the reference implementation of the Java Server Pages(JSP) and Java Servlet specifications. This means it is the most standards compliant Java server available.

Despite Tomcat's popularity, it suffers from a common shortcoming among open source projects: lack of complete documentation. There is documentation distributed with Tomcat mirrored at jakarta.apache.org. However, there is also an open source effort to write a Tomcat book at tomcatbook.sourceforge.net

Sync hardware clock with current system date and time

There are two main clocks in a Linux system:

The Hardware Clock: This is a clock that runs independently of any control program running in the CPU and even when the machine is powered off.

The System Time: This is the time kept by a clock inside the Linux kernel and driven by a timer interrupt. It has meaning only while Linux is running on the machine.

Often-times, it happens that when you reboot, your clock does not reflect the correct date and time. You may be forgetting to sync the hardware clock with the current system time. Here is how:

First check and set the current system date and time.

# date
# date -s 'Wed May 28 11:35:00 EST 2003'

Then sync your hardware clock with the system time.

# hwclock --show
# hwclock --systohc

man date and hwclock for more info...

Comment