Passive FTP set for 50000-51000
Or, port 60000-61000 on your hardware firewall for FTP passive ports.
Linux, Windows, Software Tips, Articles and Hacks
Passive FTP set for 50000-51000
Or, port 60000-61000 on your hardware firewall for FTP passive ports.
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
FTP logs:
# /usr/local/apache/domlogs/ftpxferlog
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:
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:
Rebuild the Dovecot mailer server To do this, run the following script:
# /usr/local/cpanel/scripts/builddovecotconf
Restart the Dovecot mail server.
To do this, run the
# /scripts/restartsrv_dovecot command.
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;