January 23, 2010
Can’t connect to Plesk SQL Server (after updating Plesk admin password)
Linux/Windows Support,Can’t connect to Plesk SQL Server (after updating Plesk admin password) Jet engine is configured as Plesk Database Provider by default and Plesk SQL (MySql) service is set to disabled. However Plesk installer sets MySQL admin’s password the same as Plesk’s admin. If Plesk’s admin password is changed MySQL admin’s password remains the same which…
Read more
January 13, 2010
Can’t change administrator email address
Linux/Windows Support,Can’t change administrator email address Error : Unable to update administrator information: Error 2 at CMMFile::CMMFile: open file C:\inetpub\vhosts\default\htdocs\index.html: The system cannot find find the file specified. Solution : You should be able to resolve this after getting the contents css img favicon.ico index.html replaced over here ‘C:\inetpub\vhosts\default\htdocs’. You will be able to update the…
Read more
January 9, 2010
Unable to add/remove domain alias in Helm Control Panel
Linux/Windows Support,Unable to add/remove domain alias in Helm Control Panel You could have experienced this error CDomainAlias.DeleteEx 0-xxxxxxxxxx: Unknown error while adding host header: A name contained an invalid character. in Helm Error Logs. If that’s the case please remove IIS.XML in the remote server where the domain is actually hosted. P.S. IIS.XML is available at…
Read more
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 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?
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
