postgrey whitelist hotmail or outlook

vi /etc/postfix/postgrey_whitelist_clients

# Do NOT greylist hotmail.com MX servers (see dig in mx hotmail.com)
/^mx[1-4]\.hotmail\.com$/

# Do NOT greylist ANY host from hotmail.com or outlook.com

#hotmail
/^.*\.hotmail\.com$/
#outlook
/^.*\.outlook\.com$/

killall postgrey
service start postgrey

Log:

postgrey[30881]: action=pass, reason=client whitelist, client_name=bay004-omc4s14.hotmail.com, client_address=65.54.190.216, sender=

You also can whitelist *.outbound.protection.outlook.com and etc

Number of processes running now: 0

If your MySQL or MariaDB server is rebooting itself using something like ISPConfig:

max_connections=50
innodb_buffer_pool_size = 512M

Other settings is custom:

innodb_file_per_table = 1
innodb_buffer_pool_size = 512M
max_connections=50
max_allowed_packet=256M
table_cache=512
sort_buffer_size=4M
myisam_sort_buffer_size=64M
thread_cache=128
wait_timeout=300
thread_concurrency=1

Error:

161213 11:49:56 mysqld_safe Number of processes running now: 0
161213 11:49:56 mysqld_safe mysqld restarted
161213 11:50:00 [Note] /usr/sbin/mysqld (mysqld 10.0.28-MariaDB) starting as process 1233 …
161213 11:50:00 [Note] InnoDB: Using mutexes to ref count buffer pool pages

can’t start server: Bind on TCP/IP port. Got error: 98: Address already in use


ps aux | grep mysql

root 553 0.0 0.0 11448 1540 ? S 13:54 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/cloudlix.com.pid
mysql 657 0.0 4.1 1177708 105960 ? Sl 13:54 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/cloudlix.com.err --pid-file=/var/lib/mysql/cloudlix.com.pid

service mysql stop if not working:

kill -9 553 && kill -9 657

create glassfish jdbc resource

#!/bin/bash
# Shell script to create the GlassFish 4 JDBC Connection pool for Mysql

# http://stackoverflow.com/questions/6572895/how-can-i-create-a-mysql-connection-pool-using-asadmin-tool-in-glassfish-server
echo "Create JDBC connection pool"
asadmin create-jdbc-connection-pool \
--datasourceclassname \
com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource \
--restype javax.sql.DataSource \
--property User=arquillian:Password=arquillian:URL=\"jdbc:mysql://localhost:3306/arquillian\" \
ArquillianPool

# An alternative command line
# asadmin create-jdbc-connection-pool --datasourceclassname com.mysql.jdbc.jdbc2.optional.MysqlDataSource --restype javax.sql.DataSource
# --property user=root:password=test:DatabaseName=test:ServerName=localhost:port=3306 test-pool

echo "Create JDBC resource"
asadmin create-jdbc-resource --connectionpoolid ArquillianPool jdbc/arquillian