January 9, 2010
Accessing Plesk shows invalid security certificate.
Linux/Windows Support,Accessing Plesk shows invalid security certificate Accessing Plesk Control Panel with https displays the following; mydomain:8443 uses an invalid security certificate. The certificate is not trusted because it is self signed. The certificate is only valid for plesk. (Error code: sec_error_ca_cert_invalid) You don’t need to buy another certificate, the certificate you now have is auto-generated…
Read more
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
Linux/Windows Support,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
Database,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...
Read more
December 26, 2009
How to change the client prompt in MySQL?
Database,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,Optimize Database Server Performance for Peak Efficiency Now, to ensure your systems are functioning at peak efficiency, you should run the database server optimally by following the procedures outlined below. – 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…
Read more
