Plesk

From Linux Tools

Jump to: navigation, search

geezzzzzzzzzz .......... got it .............now relaxing.................


How to install cpanel and plesk 

http://www.eukhost.com/forums/f16/install-plesk-cpanel-11-a-8254/



Plesk Demo 

http://www.parallels.com/products/plesk8/demo/

http://www.parallels.com/products/plesk/demo/


Plesk Login and password from psa: 

# mysql -u admin -p`cat /etc/psa/.psa.shadow`
mysql> use psa;
mysql> select * from clients where pname='Client Name';
select * from accounts where id='3245';



To find the password of an email account 

# mysql -u admin -p`cat /etc/psa/.psa.shadow`
# use psa;

# select * from domains where name='domainname';

---> will get like given below.
-+-----------+-------------+
| 181 | 2005-09-22 | domainname



#  select * from mail where dom_id='181';
---> will get like given below.
 ----+------------+--------+---------+
|  265 | domainname | true    |        784 | false    |            | false      | false         | false        | any     |         -1 |    181 |     392 |

# select * from accounts where id='784';



To find the ftp password 

# mysql -u admin -p`cat /etc/psa/.psa.shadow`
# use psa;
# select * from sys_users where home='/home/httpd/vhosts/domainname';
# select * from accounts where id ='712';



Reset Plesk admin Password 


http://blog.micfo.com/2006/08/26/reset-plesk-admin-password-reset-plesk-admin-password/



Additional ftp account 


http://kb.swsoft.com/en/415



FTP log in Plesk 

/usr/local/psa/var/log/xferlog


How to password protect a subdomain 

AuthName "Protected Folder"
AuthType Basic
AuthUserFile /home/httpd/vhosts/yourdomain.com/subdomains/yoursubdomain/httpdocs/.htpasswd
Require valid-user



How do I upgrade Plesk 

http://kb.parallels.com/en/230
http://download1.parallels.com/Plesk/Plesk8.1/Doc/plesk-8.1-unix-installation-guide/18514.htm
http://www.parallels.com/download/plesk/products/ (Including patches)


How to change the default port for Plesk 

Linux

To change the port Plesk listens on you will need to edit /usr/local/psa/admin/conf/httpsd.conf file and change the   
following directives to list the port you want Plesk to listen on:

Listen 8443
Port 8443
<VirtualHost *:8443>

You will need to restart Plesk afterwards and update the hardware object in the SoftLayer portal with the new port  
(Hardware > Click on Server name > Password Update / History)
Plesk cannot listen on any of the ports used for common services (21, 22, 23, 25, 53, 80, 110, 443 etc..).

Windows

Most Plesk installs will be using Apache by default. You will want to edit the Apache configuration file C:\Program  
Files\SWsoft\Plesk\admin\conf\httpd.conf

1.) Change the following line to list the port number you want Plesk to listen on
Listen 8443

2.) Restart Plesk Control Panel
You will need to restart Plesk afterwards and update the hardware object in the SoftLayer portal with the new port 
(Hardware > Click on Server name > Password Update / History)



How to setup a new server 

http://www.grafxsoftware.com/faq.php/HOW-TO-Setup-a-PLESK-Dedicated-Server/1/4/



updater Icon missing in Plesk

RPM is located at the .../opt/updater directory in the Plesk distributive.



Install components through autoinstaller 

cd  /usr/local/psa/bin/
./autoinstaller --help
./autoinstaller --select-release-current --show-components

you want to view.
   --select-release-latest      Select the latest product version available for your operating system
   --select-release-current     Select the same product version as the one installed on your machine

./autoinstaller --select-release-current --install-component drweb



Plesk error ERROR: PleskFatalException 

rm -rf /var/lib/rpm/__db.00*


Apache failed to start with the "No space left on device" error 

These errors mean that there is no available IPC (inter-process communication)  resources in the system, such as  
semaphores or shared memory segments.

Script to delete semaphore process 

ipcs -s | grep apache | perl -e 'while (<STDIN>) {@a=split(/\s+/); print `ipcrm sem $a[1]`}'
                          or
ipcs -s|grep apache|awk '{print $2}'|while read i; do ipcrm -s $i;done



webmail error "A fatal error has occurred DB Error: connect failed" 

http://kb.swsoft.com/en/940



To find the history of load on a server 

sar -q


How can we add the settings so as to access www.subdomain.com in Plesk 

Create A record or CNAME record for the subdomain in DNS and add the following line in the file given below.

ServerAlias www.subdomain.maindomain.com
/var/www/vhosts/maindomain/subdomains/<subdomain-name>/conf/vhost.conf

Reconfigure the domain and restart named and apache.


Reconfigure Domain: 

/usr/local/psa/admin/sbin/websrvmng --reconfigure-vhost --vhost-name=domain.com


Run stat 

/usr/local/psa/admin/sbin/statistics --calculate-one --domain-name=domainname


Fixing awstats after a Plesk 8.3 migration 

http://nickforsale.com/fixstats/
cd /root
wget http://nickforsale.com/fixstats/fixstats.tar.gz
tar -xzf fixstats.tar.gz

Please note to change the directory path in fixstats.pl as /home/httpd/vhosts or /var/www/vhosts . By default the script is set to /var/www/vhosts 

# ./fixstats.pl
fixstats v1.2
Usage: ./fixstats.pl [--all | --domain= | --verbose | --test | --help]

--all           : Run statistics on all domains. May not be used in conjunction with --domain.
--domain        : Run statistics on specified domain only. May not be used in conjunction with --all.
--verbose       : Verbose mode. Displays domains as they are processed.
--test          : Test mode. Does everything except call awstats. For debugging purposes mostly.
--help          : This message.

Enable Full Country list is awstats 

vi /usr/local/psa/etc/awstats/awstats.domainname.com-http.conf
uncomment the line LoadPlugin="geoipfree"
Rerun the stats for the domain




How to change the mail server ip 

/sbin/iptables -t nat -A POSTROUTING -p tcp --dport 25 -j SNAT --to-source <ip_address>


qmail notes - How to change the non existing email accounts bounceback settings globally 


http://rimuhosting.com/knowledgebase/linux/mail/qmail notes



path to email accounts 

/var/qmail/mailnames/domainname



Mail queue 

command to see mails in queue
/var/qmail/bin/qmail-qread

command to find the number of mails in a queue
/var/qmail/bin/qmail-qstat

Clean Mail queue 

Download qmail-remove tool from here
http://www.linuxmagic.com/opensource/qmail/qmail-remove/

qmail-remove -r -p "Online Banking" -i -v
qmail-remove -r -p mailer-daemon -i -v
qmail-remove -r -p bouncing -i -v


You can use third party programs like qmail-remove http://www.linuxmagic.com/opensource/qmail/qmail-remove to accomplish queue management in plesk control panel managed qmail

The Plesk control panel itself provides a modified version od qmHandle ( http://qmhandle.sourceforge.net/ )along with it that can be used with ease to manage the queue

To see the statistics of the queue: 

–
/usr/local/psa/admin/bin/mailqueuemng -s
Messages in local queue:  0
Messages in remote queue: 0
Messages in todo queue:   0
Messages total:           0
Messages found:           0
Timestamp: 1215870834
–

From this you can see the status of qmails local,remote and todo list

If you wish to do a delivery of the queued messages now run the following command 

/usr/local/psa/admin/bin/mailqueuemng -a

To list remote message queue: 

/usr/local/psa/admin/bin/mailqueuemng -R

list local message queue: 

/usr/local/psa/admin/bin/mailqueuemng -L


To delete messages with a particular pattern in the subject line 

/usr/local/psa/admin/bin/mailqueuemng -S”text”


To delete all messages in the queue (Use with caution - possible data loss ) 

/usr/local/psa/admin/bin/mailqueuemng -D



To disable reverse lookups in qmail with Plesk, simply add -Rt0 to the server_args line in /etc/xinetd.d/smtp_psa


The server is overloaded with SPAM. There are many messages in queue. Mail is delivered slowly 


http://kb.parallels.com/en/766



Many email messages are sent from PHP scripts on the server. How can I find what domains these scripts are running on - qmail wrapper 

http://kb.parallels.com/article_22_1711_en.html



sendmail wrapper 

http://mycutelife.net/sanju/newtickethelp/sendmail-wrapper.html



SMTP on different Port in Plesk 

http://www.digitalmurph.com/wordpress/?p=15

a) add the following to /etc/services
smtp-26         26/tcp          mail

b) Copy /etc/xinetd.d/smtp_psa to /etc/xinetd.d/smtp_psa-26
c) Change the first line from service smtp to service smtp-26
d) Restart xinetd



How to avoid reverse dns lookup in mail 

http://kb.parallels.com/en/298


hard disk quota is not supported 


http://forum.swsoft.com/showthread.php?t=41722

Add ‘usrquota’ to the options in fstab for home partition.
mount -o remount /home
then just ran:
quotaoff -av
quotacheck -avum
quotaon -av



Named error while starting 

http://forum.swsoft.com/showthread.php?t=22212



1) cd /var/named/run-root/etc
2) mv named.conf named.conf.bak
3) cp named.conf.default named.conf
4) for x in `ls`; do /usr/local/psa/admin/sbin/dnsmng update $x; done;/etc/init.d/named restart



Some clients experience a 30-60 second delay when trying to send/receive mail with Plesk mail server. 


 http://kb.swsoft.com/en/298


Plesk backup


http://rshagrawal.blogspot.com/2008/06/how-to-configure-backup-on-plesk.html


Backup convert 

 /usr/local/psa/bin/backup-convert convert -o output_file_name backup_name



Mail wrapper 

http://kb.swsoft.com/article_22_1711_en.html



Qmail faq 

http://qmail.3va.net/qmailfaq.html

Maintaining your qmail server 

http://www.qmailrocks.org/maintain.php
queuelifetime - The "queuelifetime" setting for qmail determines how long messages can stay in the queue. By  
default, your qmail server will keep messages in the queue for 604,800 seconds, or 7 days. However, you can set a 
custom queuelifetime by creating a file called /var/qmail/control/queuelifetime. The content of that file is a 
single line containing a number which represents the number of seconds the queue will hold any given message. If 
you want to set a custom queuelifetime, you might want to whip out the old calculator.



Squirrelmail 1.4.11 attachment issue 

http://sourceforge.net/tracker/index.php?func=detail&aid=1805471&group_id=311&atid=100311

wget http://www.mycutelife.net/sanju/downloads/1.4.11_compose_attachments.patch
Then from the root of the SquirrelMail directory (/usr/share/psa-horde/sqmail) (where src, class, etc can be seen),  
type:

patch -p0 < path_to_the_directory_to_patch/1.4.11_compose_attachments.patch
You should then see two lines come back that say it has updated
compose.php, and addrbook_search_html.php



The GTUBE (Generic Test for Unsolicited Bulk Email) is a 68 byte test string used to test anti spam solutions, notably those based on spamassassin. In spamassassin, it carries an antispam score of 1000 by default, which would be sufficient to trigger any installation.

The contents of the string are as follows: 

XJS*C4JDBQADN1.NSBN3*2IDNEN*GTUBE-STANDARD-ANTI-UBE-TEST-EMAIL*C.34X


How do I repair/rebuild all Qmail configuration files and restore settings for all mailboxes? 

It can be done with Plesk mchk utility which is located in:

$PRODUCT_ROOT_D/admin/bin/mchk
 Synopsis:
mchk [OPTION]
--without-spam - restore all settings except for SpamAssassin configuration
--with-spam - restore all settings
--spam-only - restore only SpamAssassin settings

This utility rebuilds in line with Plesk database Qmail control files
in the /var/qmail/control, /var/qmail/users directories and mail users' settings. Also, it sets proper 
ownership/permissions for all mailboxes (/var/qmail/mailnames/*).

Example:
 # /usr/local/psa/admin/bin/mchk --with-spam 
 # /usr/local/psa/admin/bin/mchk -v

MAXPERIP Settings 

If you are planning on having multiple users connect to your IMAP server from a single IP address, such as in a  
small home or office network, you may want to increase the "MAXPERIP" setting with the 
/usr/local/etc/coutier-imap/imapd config file. This setting establishes the maximum number of IMAP connections that 
can be made from a single IP address. An example of this might be if you have a small office network runing on a 
single DSL or Cable IP address and your mail server is outside of that network. While each computer in your 
internal network may have it's own private IP address, to the outside world anyone coming from your network has the 
single routeable IP address assigned to your DSL or Cable connection. The default setting for "MAXPERIP" is 4 so f 
you have a similar network setup and more than 4 people trying to access your IMAP server, you may want to increase 
this setting accordingly to avoid connection errors. Within the /usr/local/etc/imapd file, the line you are looking  
for looks like this:



Statistics for a domain is calculated, but no icons/images are shown on AwStats pages.

This problem fixed in Plesk 8.1.1 Until Plesk 8.1.1 release you can modify AwStats configuration files with: 

sed -i 's,^DirIcons=.*,DirIcons=\"/awstats-icon\",' /etc/awstats/*.conf /usr/local/psa/etc/awstats/*.conf

After next statistics utility execution by cron the icons will be shown up correctly.

If the problem still be actual even if you have Plesk versions greater than 8.1.1, the reason can be in different paths to the icons. Plesk searches for icons in /var/www/html/awstats directory, try to create link: 

# ln -s /usr/share/awstats/wwwroot/icon/ /var/www/html/awstats


Changing language in AWStats

Configuration files for AWStats statistics for Plesk domains are located in 

%plesk_dir%Additional\AWStats\wwwroot\cgi-bin\

and are called awstats.domain_name.conf where domain_name is the name of a domain located on the server.

If language needs to be changed for a specific domain, the stats.domain_name.conf file needs to be edited: 

replace the line
Lang="auto"
with (for example)
Lang="ru"

# Possible value:
# Albanian=al, Bosnian=ba, Bulgarian=bg, Catalan=ca,
# Chinese (Taiwan)=tw, Chinese (Simpliefied)=cn, Czech=cz, Danish=dk,
# Dutch=nl, English=en, Estonian=et, Euskara=eu, Finnish=fi,
# French=fr, Galician=gl, German=de, Greek=gr, Hebrew=he, Hungarian=hu,
# Icelandic=is, Indonesian=id, Italian=it, Japanese=jp, Korean=kr,
# Latvian=lv, Norwegian (Nynorsk)=nn, Norwegian (Bokmal)=nb, Polish=pl,
# Portuguese=pt, Portuguese (Brazilian)=br, Romanian=ro, Russian=ru,
# Serbian=sr, Slovak=sk, Slovenian=si, Spanish=es, Swedish=se, Turkish=tr,
# Ukrainian=ua, Welsh=cy.
# First available language accepted by browser=auto
# Default: "auto"

To change language for all domains the following file should be edited: 

%plesk_dir%\Additional\AWStats\wwwroot\cgi-bin\awstats.model.conf

with the same changes an in the example above.

After the next statistics calculation, statistics language for domains will be applied.



I cannot access the webstats for some of my domains via HTTP://, even though the webstat directory is present in their domain 

The short answer is: if SSL is enabled for a domain, stats can only be accessed via HTTPS. If SSL is   
disabled,statistics is accessible via HTTP.



Switching between Webalizer and AWstats 

Webalizer and AWstats have different accumulated data storage format, hence you will not be able to see old data  
from AWstats in Webalizer and vice versa



php in html or Parsing PHP in .html Files 

http://www.desilva.biz/php/phpinhtml.html

use the following in vhost.conf
AddHandler application/x-httpd-php .html .htm .shtml
AddType application/x-httpd-php .html .htm .shtml



Creating and Installing Free Self-signed SSL Certificate 


If you do not feel like paying money for SSL certificates, but still need to secure a site, you can create a  
self-signed certificate and install it on your web server. This will provide data encryption; however, your 
customers' browsers will show warning messages telling that your certificate is not issued by a recognized 
authority. Thus, using self-signed certificates is not recommended as it will not instill confidence in customers,   
and is likely to adversely affect the online sales of your client.

To secure a site with a self-signed SSL certificate:

  1. Go to Domains > domain name > Certificates and click Add New Certificate.
  2. Specify the certificate properties:
         * Certificate name. This will help you identify this certificate in the repository.
         * Encryption level. Choose the encryption level of your SSL certificate. We recommend that you choose a  
value more than 1024 bit.
         * Specify your location and organization name. The values you enter should not exceed the length of 64  
symbols.
         * Specify the domain name for which you wish to generate an SSL certificate. For example:  
www.your-domain.com.
         * Enter the domain owner's e-mail address.
        1. Click Self-Signed. Your certificate will be generated and stored in the repository.
  3. Return to the domain's administration screen (Domain > domain name) and click Setup in the Hosting group.
  4. Select the self-signed SSL certificate from the Certificate drop-down box.

     If there is no Certificate drop-down box on the screen, this means that you are on a shared hosting account; 
therefore, you need to upgrade your hosting package and purchase a dedicated IP address from your hosting provider.
  5. Select the SSL support check box and click OK.



Info] Directory for files browsed via HTTPS(SSL) 

Since Plesk 7 for Windows does not use httpsdocs directory, the files should be uploaded to httpdocs and they will  
be accessible via both HTTP and HTTPS protocols.

Starting with Plesk 7.5, the 'httpsdocs' directory is used for 'Shared SSL' feature only



Custom error docs 

For enabling this feacture you have to check the option "Custom Error Documents" in domain >> setup

http://www.jabwebsolutions.co.uk/support/knowledgebase/view/71/how-do-i-setup-custom-error-pages-in-plesk.html
http://kb.parallels.com/en/1531



Plesk Frontpage issue: 

http://kb.swsoft.com/en/909∞
http://kb.swsoft.com/en/751



"Access Denied" error when trying to log into Plesk

If you get a "Access Denied" error when trying to log into Plesk, it means that you are currently locked out because of too many bad login attempts. To resolve this issue do the following:

1. Log into the psa database. 

mysql -uadmin -p$(cat /etc/psa/.psa.shadow) psa

2. All user sessions are stored in the table 'lockout' in the psa database. To unlock all users in this table delete the user's entry from this table using the following query: 

delete from lockout;



Changing the page title for the login screen

You can change the title for the control panel login screen. 

cd /usr/local/psa/admin/htdocs/javascript
cp common.js common.js.back

open common.js and at the top of the page add this: 

document.title = '**ENETER THE TEXT HERE**';



How to reset Plesk admin Password

Linux Server :

Login to Linux server as root, and run following commands : 

cd /usr/local/psa/admin/bin
export PSA_PASSWORD='newpassword'
echo $PSA_PASSWORD
./ch_admin_passwd
export PSA_PASSWORD=
cat /etc/psa/.psa.shadow


Windows Server : Login to windows server via RDP as a administrator, then open command prompt and run following commands : 

C:\Program Files\SWsoft\Plesk\admin\bin\plesksrvclient.exe  (according to plesk location)

or 

cd %plesk_dir%
cd admin\bin

Execute this "plesksrvclient.exe", you will be prompted to enter the new password for your “admin” plesk user.

You can then log into the plesk interface again and use as normal.



Script to find vulnerable files in a server 

cd /usr/src
wget http://www.mycutelife.net/sanju/downloads/script
bash script

Open file /root/hacks_details.txt and you will get all the details



Frame redirects 

http://en.wikipedia.org/wiki/URL_redirection#Frame_redirects



URL Redirect 

http://www.seocompany.ca/seo/url-redirect.html



How to check whether mod_rewrite is enabled on a server 


http://www.wallpaperama.com/forums/how-to-test-check-if-mod-rewrite-is-enabled-t40.html



                OR

place the following lines in your .htaccess: Code: 

Options +FollowSymLinks
Redirect /joomla.html http://www.joomla.org

note: if your site is located in subdomain example "test" you need to insert in .htaccess as: Code: 

Options +FollowSymLinks
Redirect /test/joomla.html http://www.joomla.org

Now point your browser to: http://www.mysite.com/joomla.html

If it redirects you to joomla.org - mod_rewrite is working. If it gives you an error - mod_rewrite is not working.




Mamboo Installation issue in plesk 8.1.1 


http://forum.swsoft.com/showthread.php?s=b7fea76a5b4647bd4b4c56766aa17745&postid=175106



When you log in to control panel, it can open in either a standard view, a simplified desktop view, or a combination of both.

The standard view is a customary view of the control panel divided into two main areas: navigation pane on the left and the main screen where operations are performed on the right.

The desktop view can show server statistics and shortcuts to the operations you frequently perform everything you may need can now be accessible from a single screen. 

You can set the option through plesk admin login and the following steps will help you to select which type of interface to be used for accounts which are using a particular template.

Clients > Client templates > Click on the template to edit >> select the option "Only standard interface is  
allowed" or " Desktop and standard interface are allowed" or "Only Desktop interface is allowed".

The following url will help in changing the interface of each accounts.
http://download1.swsoft.com/Plesk/Plesk8.1/Doc/plesk-8.1-unix-administrators-guide/22919.htm



Enabling server-status 


http://kb.swsoft.com/en/264



<Location /server-status>
    SetHandler server-status
#    Order deny,allow
#    Deny from all
#    Allow from .example.com
</Location>

Also 

ExtendedStatus On



Error : command not in docroot in /etc/httpd/logs/suexec.log for .cgi files 

 cp -p /usr/local/psa/suexec/psa-suexec /usr/sbin/suexec


Error "Symbolic link not allowed"

Check open_basedir restriction and give the following in .htaccess file

Options Indexes FollowSymLinks


Redirection Rule 

Need to redirect all request to domain.com to www.domain.com

RewriteEngine On
RewriteBase /
RewriteCond %{HTTP_HOST} !^www\.domain\.com
RewriteRule ^(.*)$ http://www.domain.com/$1 [R=301,L]



Installing eaccelerator 

 wget http://bart.eaccelerator.net/source/0.9.5.2/eaccelerator-0.9.5.2.tar.bz2
 tar -xvzf eaccelerator-0.9.5.2.tar.bz2
 tar -xvjf eaccelerator-0.9.5.2.tar.bz2
 cd eaccelerator-0.9.5.2/
 ls
 phpize
 ./configure --enable-eaccelerator=shared
 make
 make install
 edit the file  /etc/php.d/eaccelerator.ini
 mkdir /tmp/eaccelerator
 chmod 0777 /tmp/eaccelerator
 /etc/init.d/httpd stop
 /etc/init.d/httpd start



Upgrading ioncube loader 

http://www.ioncube.com/loaders.php  ----------- download the latest version
http://blog.eukhost.com/webhosting/ioncube-installation-globally/ ----------- steps 

Download the latest version to some directory(htdocs). Copy the appropiate file (ioncube_loader_lin_4.4.so) to the  
ioncube folder (normally /usr/local/ioncube). You can get the path from php.ini file (zend_extension = 
/usr/local/ioncube/ioncube_loader_lin_4.3.so). Edit the above line in php.ini according to the version. Goto 
http://servername/ioncube-loader-helper.php (where you downloaded the ioncube source file) and you will see as 
below.

An ionCube encoded file has been loaded successfully.
Encoded files should now function correctly.


Get the following error when try to use PHPMyAdmin in the Plesk CP: "#1045 - Access denied for user 'pma_xxxxxxx'@'localhost' (using password: YES)" 


http://kb.swsoft.com/en/1252

path to config.default.php is /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries and the path to config.inc.php is /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin . Then give necessary privileges



Please Error : Unable to connect to database: get_admin_password() failed: file_get_contents() failed: 0: /usr/local/psa/admin/auto_prepend/auth.php3:1 psaerror(string "Unable to connect to database: get_admin_password() failed: file_get_contents() failed: ") 

Make sure that "/etc/psa/.psa.shadow" file has a valid permissions.
Right permissions should be as follows
-rw------- 1 psaadm psaadm 5 Feb 26 11:22 /etc/psa/.psa.shadow



Server monitor in HN 


http://www.nexusportal.net/support/login-usage/




Script to get mail password given a domain name: 

#!/bin/bash
#Author Anoop Alias
#Email anoop@gnusys.net

psapass=`cat /etc/psa/.psa.shadow`
echo "Please Enter Mailname:"
read mailname
echo $mailname >/tmp/mailname
domain=`cut -d@ -f2 /tmp/mailname`
user=`cut -d@ -f1 /tmp/mailname`

echo "use psa;select id from domains where name='gnusys';" >/tmp/query1
sed -i s/gnusys/$domain/ /tmp/query1
id=`mysql -uadmin -p$psapass < /tmp/query1|grep -v id` 

echo "use psa;select account_id from mail where dom_id='gnusys' and mail_name='idiot';" >/tmp/query1
sed -i s/gnusys/$id/ /tmp/query1
sed -i s/idiot/$user/ /tmp/query1

id=`mysql -uadmin -p$psapass </tmp/query1|grep -v account_id`

echo "use psa;select password from accounts where id='gnusys';">/tmp/query1
sed -i s/gnusys/$id/ /tmp/query1
mysql -uadmin -p$psapass < /tmp/query1


Plesk does not restart Apache automatically when we add a domain or its configuration. Restarting via the Service Management control panel works fine, however. 

http://kb.swsoft.com/en/242

Apache is not restarted immediately by default. Please check the apache restart interval on Server > Preferences.  
It was implemented to avoid too many apache restarts if a lot of operations are done in Plesk CP. It doesn't mean 
that apache will be restarted every time of this period. If no one makes changes in Plesk CP then apache will not 
be restarted, but if someone does, apache will be restarted not more often than once in the apache restart 
interval.



Error make_sock: problem listening on port 443, file descriptor (1068) larger than FD_SETSIZE (1024)

Unable to open logs

Too many open files 

http://kb.swsoft.com/en/260
http://kb.swsoft.com/en/2066



Do I need a new Certificate Signing Request (CSR) generated to renew a certificate? 


In most situations you will not require to generate a new Certificate Signing Request (CSR) to renew an SSL  
certificate because you can simply use the one we generated for you when you first purchased the certificate. 
However, we are finding that many SSL certificate issuers are now requesting that a new CSR be generated for each 
renewal. The reason that many certificate issuers will ask you to generate a new key pair and CSR to request a 
certificate renewal is because by renewing your public key along with the certificate you help to protect against 
the risk of the cryptographic key being compromised by a sustained computational attack over many years and 
maintain improved security for your transactions. You should check with your specific SSL certificate issuer to 
find out what their policy is with regards to renewals.


how to exclude an ip recording in webalizer 

plesk>Reports>Webstats Preferencies>Hide Refferer


How to setup ssl for subdomain in plesk 

http://www.webhostingtalk.com/archive/index.php/t-376301.html



URL to unblock ip that are blocked at hotmail 

https://support.msn.com/eform.aspx?productKey=edfsmsbl&page=support_home_options_form_byemail&ct=eformts&scrx=1


Error "1054 - Unknown column 'p.products_id' in 'on clause'" 

http://forums.oscommerce.com/index.php?showtopic=230304

https://helpdesk.apollohosting.com/kb_article.php?ref=7683-NMUY-3161

http://www.totalchoicehosting.com/forums/index.php?showtopic=33948


Error "1054 - Unknown column 'a.authors_id' in 'on clause'" 

http://www.oscmax.com/forums/oscmax-v2-customization-mods/6535-1054-unknown-column-authors_id-clause-2.html

To enable http://IP/~username in plesk use the following in httpd.conf 

http://httpd.apache.org/docs/2.0/mod/mod_userdir.html
http://httpd.apache.org/docs/1.3/mod/mod_userdir.html

<IfModule mod_userdir.c>
   #
   # UserDir is disabled by default since it can confirm the presence
   # of a username on the system (depending on home directory
   # permissions).
   #
   #      UserDir enable
   #
   # To enable requests to /~user/ to serve the user's public_html
   # directory, remove the "UserDir disable" line above, and uncomment
   # the following line instead:
   #
   UserDir httpdocs
</IfModule>


How do I enable cgi-scripts to run from httpdocs and httpsdocs directories 


http://kb.parallels.com/en/193


FTP not working….. Connection closed by foreign host 

http://mohammednv.wordpress.com/2008/04/16/ftp-not-working-connection-closed-by-foreign-host/


Error "Error: This alias already exists" while creating domain 

use psa;
select * from domainaliases where name='yourdomainname.com';
delete from domainaliases where name='yourdomainname.com';
select * from `dns_recs` where displayHost like '%yourdomainname.com%';
delete from `dns_recs` where displayHost like '%yourdomainname.com%';

Follow the steps given below if you still have issue

select * from dns_zone where displayName like '%yourdomainname.com%';
delete from dns_zone where displayName like '%yourdomainname.com%';
Then delete the named db file



Save MySQL query results into a text or CSV file 

http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/

mysql >  select firstname, email from TABLE INTO OUTFILE '/tmp/result.txt';
mysql> select firstname, email from TABLE INTO OUTFILE '/tmp/result.csv' FIELDS  
TERMINATED BY ',';  --> This will use , as field deliminator


Retrieved from "http://www.mycutelife.net/wiki/index.php?title=Plesk"
Personal tools
Main Page