January 1, 2010
Create directory & set permission using a single Linux command
Linux General,Linux/Windows Support,Generaly, we create directory using “mkdir” command and then change it’s permissions using “chmod” command. Create directory & set permission using a single Linux command Actually, we can set the permissions for the directory at the time of it’s creation itself, with the following command: $ mkdir zyz -v -m 644 mkdir: created directory `zyz'…
Read more
January 1, 2010
Linux Package Management Tips
Linux General,Linux/Windows Support,Try these Linux package management tips. Linux Package Management Tips 1) To check if a package is available in repositories and if so available, to check the version and size of the package, as superuser run the following commands in respective distro: Fedora, CentOS: yum list <package_name> Ubuntu/Debian: aptitude search <package_name> OpenSuse: zypper search <package_name>…
Read more
January 1, 2010
Find programs hogging bandwidth using iftop command in Linux
Linux General,Linux/Windows Support,Find programs hogging bandwidth using iftop command in Linux Using iftop command we shall be able to determine what program is hogging bandwidth. iftop -bNBP is the commonly used option where -n don’t do hostname lookups -N don’t convert port numbers to services -B Display bandwidth in bytes -P show ports as well as hosts…
Read more
December 29, 2009
How To set the timezone in FreeBSD OS
FreeBSD,Copy from /usr/share/zoneinfo/Etc or /usr/share/zoneinfo/<continent>/<city>, the timezone, that coresponds to your city/GMT setting to /etc/localtime Once the timezone is set in the FreeBSD server, run the command: adjkerntz -a (adjut kernel timezone). How To set the timezone in FreeBSD OS
Read more
December 26, 2009
Converting MySQL query results into a CSV file
Linux General,MySQL,To dump data from the database into an Excel file, SELECT query can be used to convert data to CSV formatting. Converting MySQL query results into a CSV file All needs to be done is to identify how the fields and lines should be terminated. For example, to dump a table named customers to a…
Read more
December 26, 2009
How to change the client prompt in MySQL?
Linux General,MySQL,Change MySQL’s prompt by using the prompt command: mysql>prompt mysql (\d)> Once executed, the currently selected database will appear in the prompt, like so: mysql (mydatabase)> It’s also easy to lose track of which database server you’re logged in to, not to mention which account you’re using. To fix this, modify your prompt using the…
Read more
December 26, 2009
Linux modules and libraries
Linux General,Dynamically linked libraries are linked and loaded at run time, either by “ld.so” or “ld-linux.so”, depending on how it was compiled: in a.out or ELF format. Every program whenever they need a library, look through a known list of places to find the needed library. One place they look is “/etc/ld.so.cache”, which contains an ordered…
Read more
December 26, 2009
RPM – RedHat Package Manager
Linux General,What does a RPM Package contain? RPMs (*.rpm) typically include 1) the compiled programs and/or libraries needed for the package, 2) documentation 3) install, verify, and uninstall scripts 4) cryptographic signatures for each file in the package. This makes it easy to verify the integrity of the package. 5) It also includes a list of…
Read more
September 16, 2009
Run Database Servers Optimally
Linux/Windows Support,Now run the database server optimally using the below procedures and ensure your systems are functioning at peak efficiency. – kernel.shmmax=268435456 for 32-bit – kernel.shmmax=1073741824 for 64-bit – kernel.msgmni=1024- fs.file-max=8192 – kernel.sem=”250 32000 32 1024″ Shared Memory Shared Memory To view current settings, run the command: # more /proc/sys/kernel/shmmax To set it to a new…
Read more
September 16, 2009
Linux Security Tools
Linux General,In this page i will try to provide some of the must have tools for linux OS. Some of these tools can also be used for FreeBsd: ROOT KIT HUNTERS: Installation how to * CHKROOTKIT * RKHUNTER * ROOTCHECK @RootCheck: You can download the rootcheck latest version from the following URL: http://www.ossec.net/rootcheck/files/ Installation how to:…
Read more
