Header Shadow Image


Archive for the 'NIX Posts' Category

Confluence 6 Clustered Installation

Download the bin and install it on the first node you want to use.  We are using Gluster to install confluence on.  See the Gluster specific bits on the preceding link: [root@atlas02 ~]# /n/mds.xyz/tom/atlassian-confluence-6.12.2-x64.bin Unpacking JRE … Starting Installer … This will install Confluence 6.12.2 on your computer. OK [o, Enter], Cancel [c] Click Next […]

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.

If you are getting the following: 2019-03-21 01:04:17,021 FATAL main:org.hsqldb.cmdline.SqlFile: SQL Error at 'UTF-8' line 6: "alter table SETTINGS     add column LDAP_USER_SEARCH_BASE varchar(1024),     add column LDAP_USER_SEARCH_FILTER varchar(1024),     add column LDAP_GROUP_SEARCH_BASE varchar(1024),     add column LDAP_GROUP_SEARCH_FILTER varchar(1024)" Row size too large. The maximum row size for the used table […]

File corrupted while reading record: null. Possible solution: use the recovery tool [90030-196]

If you are getting this: 2019-03-20 07:29:04,401 WARN [C3P0PooledConnectionPoolManager[identityToken->1hge0yya116dyh3nq4wx2q|27ff40ab]-HelperThread-#1] [mchange.v2.resourcepool.BasicResourcePool] log Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@6144cf24 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests. 2019-03-20 07:29:05,053 WARN [C3P0PooledConnectionPoolManager[identityToken->1hge0yya116dyh3nq4wx2q|73bf9ca0]-HelperThread-#0] [mchange.v2.resourcepool.BasicResourcePool] log com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6aaf62f7 — Acquisition Attempt Failed!!! Clearing pending acquires. While trying to […]

ERROR 1290 (HY000): The MySQL server is running with the –skip-grant-tables option so it cannot execute this statement

This is how to fix root password on MySQL Galera clusters if the environment doesn't let you login with your old one: [root@mysql01 mysql]# [root@mysql01 mysql]#systemctl set-environment MYSQLD_OPTS="–wsrep-new-cluster –skip-grant-tables" [root@mysql01 mysql]#systemctl start mysqld [root@mysql01 mysql]#mysql -u root -p Enter password: Welcome to the MySQL monitor.  Commands endwith ; or \g. Your MySQL connection id is […]

Zabbix: active check configuration update from [linsrvj01.nix.mds.xyz:10051] started to fail (cannot connect to [[mickey-mouse01.disney.land]:10051]: [111] Connection refused)

You are here because you are getting: Zabbix: active check configuration update from [linsrvj01.nix.mds.xyz:10051] started to fail (cannot connect to [[mickey-mouse01.disney.land]:10051]: [111] Connection refused) likely because of SELinux / Auditd: /var/log/audit/audit.log type=AVC msg=audit(1550015414.857:191): avc:  denied  { write } for  pid=2030 comm="rpc.statd" path="/run/rpc.statd.lock" dev="tmpfs" ino=19053 scontext=system_u:system_r:rpcd_t:s0 tcontext=system_u:object_r:var_run_t:s0 tclass=file and are probably looking to solve the problem […]

Nagios: connect to host 192.168.0.101 port 5666: Connection refused

Getting: Nagios: connect to host 192.168.0.101 port 5666: Connection refused Resolve it by specifying the correct bind address in the nrge.cfg file: [root@mbpc-pc nrpe]# grep server_address /etc/nagios/nrpe.cfg # server_address=127.0.0.1 server_address=0.0.0.0 [root@mbpc-pc nrpe]# Thx, TK

Nagios: Error: Could not read object configuration data!

Are you getting the following after installing Nagios? Nagios:  Error: Could not read object configuration data! Then check the following: 1) /var/log/nagios, owned by nagios:nagios , both folder and log files. 2) /etc/nagios owned by nagios:nagios , both folder and files within this folder. 3) SELinux: Either disable it or check the /var/log/audit/audit.log for any […]

ERROR 1045 (28000): Access denied for user ‘root’@’mysql03.nix.mds.xyz’ (using password: YES)

If you get this: [root@mbpc-pc ~]# mysql -h mysql-c01 -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'mysql03.nix.mds.xyz' (using password: YES) [root@mbpc-pc ~]# Run this to fix things: mysql> uninstall plugin validate_password; Query OK, 0 rows affected (0.02 sec) mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%.mws.mds.xyz'     ->   […]

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

A set of MySQL errors and how to resolve each one: [root@mysql02 ~]# mysql -h localhost -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 621464 Server version: 5.7.21 MySQL Community Server – (GPL), wsrep_25.14 Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights […]

Cloudera Manager: Exception: It seems that a CA setup has already been created.

If you get this message: Exception: It seems that a CA setup has already been created. simply remove the folder: [root@cm-r01nn01 ~]# rmdir /var/lib/cloudera-scm-server/certmanager And rerun the correct command as per the Cloudera Installation Pages: JAVA_HOME=/usr/java/jdk1.8.0_181-cloudera /opt/cloudera/cm-agent/bin/certmanager setup –configure-services Note that the original error resulted because we were using a newer version of Java and […]


     
  Copyright © 2003 - 2013 Tom Kacperski (microdevsys.com). All rights reserved.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 Unported License