Category Archives: Hosting

nginx virtual host allow ip


location /spme_private/ {

  allow XX.XX.XX.XX;

  deny all;

}

[ERROR] Unknown/unsupported storage engine: InnoDB

Leave a reply

180221 18:36:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2018-02-21 18:36:17 140090271954976 [Note] /usr/sbin/mysqld (mysqld 10.1.24-MariaDB) starting as process 3594 …
2018-02-21 18:36:17 7f694ee57820 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB’s internal memory allocator.
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: The InnoDB memory heap is disabled
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: Using Linux native AIO
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: Using SSE crc32 instructions
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: Initializing buffer pool, size = 1.2G
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: Completed initialization of buffer pool
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: Highest supported file format is Barracuda.
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: Starting crash recovery from checkpoint LSN=90555493549
2018-02-21 18:36:18 140090271954976 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer…
InnoDB: Set innodb_force_recovery to ignore this error.
2018-02-21 18:36:18 140090271954976 [ERROR] Plugin ‘InnoDB’ init function returned error.
2018-02-21 18:36:18 140090271954976 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2018-02-21 18:36:18 140090271954976 [Note] Plugin ‘FEEDBACK’ is disabled.
2018-02-21 18:36:18 140090271954976 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-02-21 18:36:18 140090271954976 [ERROR] Aborting

Error in my_thread_global_end(): 1 threads didn’t exit
180221 18:36:23 mysqld_safe mysqld from pid file /var/lib/mysql/srv2.diavolesa.com.pid ended

mv /var/lib/mysql/ib_logfile0{,_backup}
mv /var/lib/mysql/ib_logfile1{,_backup}
service mysql restart

pm.status_path blank nginx

Leave a reply


   location ~ ^/(status-blabla|ping)$ {

     access_log off;

     allow 127.0.0.1;

     allow XX.XX.XX.XX;

     deny all;

     include fastcgi_params;

     fastcgi_param SCRIPT_FILENAME /status-blabla;

     fastcgi_pass unix:/var/run/php5-fpm-blabla.sock;

}
# XX.XX.XX.XX is your IP address

centos mysql 5.6 repo

Leave a reply

yum install http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
yum install mysql-server

nginx repo yum centos

Leave a reply


vi  /etc/yum.repos.d/nginx.repo

[nginx]

name=nginx repo

baseurl=http://nginx.org/packages/centos/$releasever/$basearch/

gpgcheck=0

enabled=1

clear memcached memcache

Leave a reply

echo flush_all > /dev/tcp/localhost/11211

The frontend does not match Zabbix database. Current database version (mandatory/optional): 3010002/3010002. Required mandatory version: 3050068. Contact your system administrator.

Leave a reply

mv /etc/zabbix/zabbix_server.conf{,_back}
mv /etc/zabbix/zabbix_server.conf.rpmnew /etc/zabbix/zabbix_server.conf
vi /etc/zabbix/zabbix_server.conf
DBPassword=your_secret_password
service zabbix-server restart

If still error:
22001:20180503:094957.500 starting automatic database upgrade
22001:20180503:094957.514 [Z3005] query failed: [1091] Can’t DROP ‘id’; check that column/key exists [alter table history_text drop column id]
22001:20180503:094957.514 database upgrade failed

mysql zabbix
alter table history_text add column id BIGINT(20);
alter table history_log add column id BIGINT(20);
service zabbix-server restart