Increase the size of innodb_buffer_pool_size
Increase the size of innodb_log_buffer_size
Monthly Archives: February 2017
check the manual that corresponds to your MySQL server version for the right syntax to use near TYPE=MyISAM
TYPE=MyISAM
with
ENGINE=MyISAM
Failed to open socket family 10 : Address family not supported by protocol at /usr/libexec/webmin
If webmin wont start an no errors. Webmin is stopped
vi /etc/webmin/miniserv.conf
ipv6=0
centos mod_h264
wget http://h264.code-shop.com/download/apache_mod_h264_streaming-2.2.7.tar.gz
tar -zxvf apache_mod_h264_streaming-2.2.7.tar.gz
cd mod_h264_streaming-2.2.7
./configure
make
make install
vi /etc/httpd/conf/httpd.conf
LoadModule h264_streaming_module /usr/lib64/httpd/modules/mod_h264_streaming.so
AddHandler h264-streaming.extensions .mp4
/etc/init.d/httpd start
apachectl -t -D DUMP_MODULES | grep h264_streaming_module
MyISAM; ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
mysql> SET sql_mode = “”;
ERROR 2006 (HY000) at line xxx: MySQL server has gone away
Set max_allowed_packet=64M
mysql allow user create database
GRANT ALL PRIVILEGES ON `user\_%` . * TO 'user'@'localhost';
centos ispconfig
This is for Centos 6 install
yum update -y
yum install epel-release -y
yum install http://rpms.famillecollet.com/enterprise/remi-release-6.rpm -y
vi /etc/yum.repos.d/MariaDB.repo
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
yum install MariaDB-server -y
/etc/my.cnf.d/server.cnf
sql-mode=NO_ENGINE_SUBSTITUTION
yum install which fcgi mod_ssl postfix mailman dovecot dovecot-mysql clamav pure-ftpd mod_fcgid -y
yum --enablerepo=remi,remi-php56 install php phpmyadmin php-mcrypt php-fpm php-mbstring php-xml -y
yum install amavisd-new clamd clamav
freshclam
yum install "perl(DBD::mysql)"
for i in postfix pure-ftpd mysql php-fpm dovecot crond amavisd; do service $i start; done
for i in postfix pure-ftpd mysql php-fpm dovecot crond amavisd ; do chkconfig $i on; done
yum --enablerepo=remi,remi-php56 install php phpmyadmin php-mcrypt -y
cd
wget https://ispconfig.org/downloads/ISPConfig-3.1.15p3.tar.gz
mysql_secure_installation
php -f install/install.php
screen attached
screen -rd name
dovecot allow plaintext authentication
disable_plaintext_auth = no
installatron error log
tailf /var/installatron/logs/install_error_log