Tools and utilities is available on ESXi, – busybox executable

~ # /usr/lib/vmware/busybox/bin/busybox --list
[
[[
addgroup
adduser
ash
awk
basename
cat
chgrp
chmod
chown
chvt
cksum
clear
cp
crond
cut
date
dd
delgroup
deluser
diff
dirname
dnsdomainname
du
echo
egrep
eject
env
expr
false
fdisk
fgrep
find
getty
grep
groups
gunzip
gzip
halt
head
hexdump
hostname
inetd
init
kill
ln
logger
login
ls
lzop
lzopcat
md5sum
mkdir
mkfifo
mknod
mktemp
more
mv
nohup
nslookup
od
passwd
poweroff
printf
readlink
reboot
reset
resize
rm
rmdir
sed
seq
setsid
sh
sha1sum
sha256sum
sha512sum
sleep
sort
stat
stty
sum
sync
tail
tar
tee
test
time
timeout
touch
true
uname
uniq
unlzop
unzip
usleep
vi
watch
wc
wget
which
who
xargs
zcat

How to wget from a ISO source:

# cd /vmfs/volumes/datastore_name_here

Load 2012 into the data store

# wget cd http://care.dlservice.microsoft.com/dl/download/6/2/A/62A76ABB-9990-4EFC-A4FE-C7D698DAEB96/9600.17050.WINBLUE_REFRESH.140317-1640_X64FRE_SERVER_EVAL_EN-US-IR3_SSS_X64FREE_EN-US_DV9.ISO

APPLIES TO:

Plesk 12.0 for Linux
Plesk 11.0 for Linux
Plesk 11.5 for Linux

How to enable gzip support on nginx?

Create /etc/nginx/conf.d/gzip.conf with the following:


gzip         on;
gzip_disable "MSIE [1-6]\.(?!.*SV1)";
gzip_proxied any;
gzip_types   text/plain text/css application/x-javascript text/xml application/xml application/xml+rss text/javascript image/x-icon image/bmp image/svg+xml;
gzip_vary    on;

gzip_types to compress other file types can be obtained from /etc/nginx/mime.types

Windows 2008 R2

1) SQL Server should be up and running.

All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server Services, and check if SQL Server service status is “Running”.

Run “sqlcmd -L” in your command prompt to ascertain if your server is included in your network list.

2) Enable TCP/IP in SQL Server Configuration

When two or more SQL Servers are connected across network they do all communication using TCP/IP. The default port of SQL Server installation is 1433. This port can be changed through SQL Server Configuration Manager. TCP/IP should be enabled for SQL Server to be connected.

Go to All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> Select TCP/IP >> right click and enable

3) Open Port in Windows Firewall

Go to Control Panel >> Windows Firewall >> Change Settings >> Exceptions >> Add Port

Make the following entries in popup “Add a Port” and click OK.
Name : SQL
Port Number: 1433
Protocol: Select TCP

1) SQL Server should be up and running.

Go to All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server Services, and check if SQL Server service status is “Running”.

2) Enable TCP/IP in SQL Server Configuration

Go to All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> Select TCP/IP >>Right Click on TCP/IP >> Click on Enable

restart SQL Server Services

3) Open Port in Windows Firewall

Go to Control Panel >> Windows Firewall >> Change Settings >> Exceptions >> Add Port

Make the following entries in popup “Add a Port” and click OK.
Name : SQL
Port Number: 1433
Protocol: Select TCP

4) Enable Remote Connection

All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager
Right click on the server node and select Properties.
Go to Left Tab of Connections and check “Allow remote connections to this server”

5) Enable SQL Server Browser Service
Go to All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server Browser

root@server ~]# yum install ImageMagick
[root@server ~]# yum install ImageMagick-devel

PHP-imagick Installation:
[root@server ~]# yum install gcc
[root@server ~]# yum install make automake
[root@server ~]# yum install php-pear
[root@server ~]# yum install php-devel
[root@server ~]# pecl install imagick

On some servers

yum install php-pecl-imagick.x86_64

Test:

convert image.jpg -resize 64x64 resize_image.jpg

Login with ssh

Login to mysql

# mysql -uadmin -p`cat /etc/psa/.psa.shadow`

use the mysql db.

mysql> use mysql;
mysql> SELECT* FROM db;

To add same user to another database, you have to insert that user into db table and give him same privileges he already has for his existing database.

mysql> INSERT INTO db VALUES(‘localhost’,’second_db’,’same_username_you_used_for_first_db’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’N’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’);

The second database is accessible to the same user as the first database, from command line but it will not appear yet in your Plesk admin panel. In order to have access to second database from Plesk interface you will have to link your database user to this second database in plesk table:


mysql> use psa;

First you must find out the database id Plesk internally assigned to your second database which we do with the following:


mysql> SELECT * FROM data_bases;

    +—-+—————————+——-+————-+————————+———————-+
    | id | name                             | type  | dom_id              | db_server_id    | default_user_id    |
    +—-+—————————+——-+————-+——————-+—————————+
    |  1 | first_db                         | mysql |      1              |            1 |               1       |
    |  2 | second_db                        | mysql |      1              |            1 |               0       |
    |  3 | test                             | mysql |      1              |            1 |               0       |
    |  4 | wordpress                        | mysql |      1              |            1 |               3       |
    +—-+—————————+——-+————-+——————+—————————–+

Note: We are going to get second_db to use first_db’s user so we are going to need the id “2”. Now we have to find out what id plesk has signed internally to the Database user:


mysql> SELECT * FROM db_users;

    +—-+—————–+—————-+———+
    | id | login          | account_id    | db_id     |
    +—-+—————–+—————-+———+
    |  1 | first_db_user  |       3       |    1      |
    |  2 | worpress_user  |       4       |    4      |
    +—-+—————–+—————-+———+

Note: We are going to use first_db’s account ID above which is “3”. Now you have to link the user to the second database using the command below


mysql> INSERT INTO db_users VALUES(”,’first_db_user’,’3′,’2′);

Note: For people who do not like to copy an paste those are single quotes at the start.
You should run the select db_users command again to check for your changes then exit mysql and restart MySQL:


# service mysqld restart


# dig +short test.openresolver.com TXT @1.1.1.1 (IP of the server)

Other Information

Test your server for an open DNS resolver here:

http://openresolver.com/

Closing DNS Resolvers on Windows Server 2003/2008/2008 R2:

http://technet.microsoft.com/en-us/library/cc787602(v=ws.10).aspx

Windows Servers running Plesk:

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

Closing DNS Resolvers on Servers running Bind:

http://www.zytrax.com/books/dns/ch9/close.html

Issue: Please server with postfix and roundcube

Pots changed for SMTP mail.

Edit the roundcube config:

 /usr/share/psa-roundcube/config

Check that the config is correct:

SMTP server host

// SMTP server host (for sending mails).
// To use SSL/TLS connection, enter hostname with prefix ssl:// or tls://
// If left blank, the PHP mail() function is used
// Supported replacement variables:
// %h - user's IMAP hostname
// %n - hostname ($_SERVER['SERVER_NAME'])
// %t - hostname without the first part
// %d - domain (http hostname $_SERVER['HTTP_HOST'] without the first part)
// %z - IMAP domain (IMAP hostname without the first part)
// For example %n = mail.domain.tld, %t = domain.tld
$rcmail_config['smtp_server'] = 'smtp.domain.com';

Port

// SMTP port (default is 25; use 587 for STARTTLS or 465 for the
// deprecated SSL over SMTP (aka SMTPS))
$rcmail_config['smtp_port'] = 9025;