How to reset MariaDB root login to use unix socket authentication

Published on February 18th 2024 - Listed in MariaDB Linux Databases - 0 comments

MySQL (Community) server upgrade 5.7 to 8.0 failed, packages have unmet dependencies

Published on November 23rd 2023 - Listed in MySQL Linux Databases - 0 comments

ERROR 3105 (HY000) at line 554: The value specified for generated column 'column' in table 'table' is not allowed

Published on October 23rd 2023 - Listed in MySQL Databases MariaDB - 0 comments

How to fix a broken MySQL / MariaDB replication (Relay log read failure) after a crash on the slave server

Published on July 26th 2023 - Listed in MySQL MariaDB Databases Linux - 0 comments

Adding performance data to dbstats action of check_postgres monitoring plugin

Published on July 12th 2023 - Listed in Databases PostgreSQL Monitoring Perl - 0 comments

MSSQL Available Space alert: How to manually grow the database file with SSMS

Published on July 11th 2023 - Listed in Monitoring Databases Windows - 0 comments

How to monitor PostgreSQL databases with check_postgresl.pl, managed through Puppet

Published on June 30th 2023 - last updated on July 3rd 2023 - Listed in Databases PostgreSQL Monitoring - 0 comments

Notes for double LTS upgrade: Ubuntu 18.04 to 22.04 and MariaDB 10.3 to 10.6

Published on June 20th 2023 - last updated on September 7th 2023 - Listed in MariaDB Database Linux - 0 comments

APT upgrade error while upgrading Galera cluster node from MariaDB 10.3 to MariaDB 10.4

Published on June 20th 2023 - Listed in Galera Database MariaDB - 0 comments

mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping table

Published on June 6th 2023 - Listed in MySQL Databases MariaDB - 0 comments

Galera garbd terminated: Group requested gcs_proto_ver: 2, max supported by this node: 0

Published on May 31st 2023 - Listed in Galera Database MariaDB - 0 comments

How to monitor PostgreSQL database size in AWS RDS

Published on April 28th 2023 - Listed in Monitoring AWS PostgreSQL Databases Cloud - 0 comments

How to create databases, users (roles) and install extensions in AWS RDS PostgreSQL

Published on April 27th 2023 - last updated on May 8th 2023 - Listed in AWS Cloud Postgres Databases - 0 comments

How to do TAG filtering in InfluxDB (SHOW TAG VALUES with a WHERE clause)

Published on February 21st 2023 - Listed in Influx Database Grafana - 0 comments

How to delete (old) monitoring data in InfluxDB with WHERE condition

Published on February 17th 2023 - last updated on February 20th 2023 - Listed in Icinga Influx Database - 0 comments

(Performance) Comparison of different compression methods used in combination with mysqldump

Published on February 8th 2023 - Listed in MySQL MariaDB Databases Linux - 0 comments

ERROR: relation table does not exist during PostgreSQL maintenance tasks (VACUUM, REINDEX)

Published on January 25th 2023 - Listed in Databases PostgreSQL - 0 comments

New version of check_mysql_slavestatus released: Bugfix when using both -H and -S (socket) parameters

Published on January 3rd 2023 - Listed in Monitoring MySQL MariaDB Databases - 0 comments

Ansible and the problem to reset the MySQL root password (unable to connect to database, check login_user and login_password are correct)

Published on August 18th 2022 - Listed in Ansible Linux MySQL MariaDB Databases - 0 comments

After Confluence copy: java.sql.SQLException: The user specified as a definer does not exist

Published on August 17th 2022 - last updated on February 15th 2023 - Listed in Atlassian MySQL MariaDB Databases - 2 comments

check_mysql_write 1.6 available: Plugin now creates monitoring table by itself

Published on June 21st 2022 - Listed in MySQL MariaDB Database Monitoring - 0 comments

How to append additional key value pair to a JSON object in MySQL or MariaDB

Published on May 13th 2022 - Listed in MySQL MariaDB Database Linux Coding - 0 comments

Invoice Ninja v5: How to make the Account Management setting available to additional (admin) users

Published on April 29th 2022 - Listed in Internet Personal Databases - 0 comments

MySQL / MariaDB mysqldump error: Cannot load from mysql.proc. The table is probably corrupted (1728)

Published on March 17th 2022 - Listed in MySQL MariaDB Database Linux Backup - 1 comments

Icingaweb2 error: Base table or view not found (rememberme does not exist)

Published on March 15th 2022 - last updated on January 31st 2023 - Listed in Icinga Icingaweb MySQL Databases - 1 comments

Python coding: Why query results of mysql.connector are in brackets and how to print real values

Published on March 10th 2022 - Listed in Coding Python MySQL Databases - 0 comments

New version of check_couchdb_replication: Rewrite and improvements

Published on February 24th 2022 - Listed in Monitoring CouchDB Databases - 0 comments

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table

Published on January 26th 2022 - last updated on January 28th 2022 - Listed in MySQL MariaDB Database Linux Backup - 0 comments

MySQL / MariaDB not logging errors (log_error file empty) on Ubuntu

Published on October 20th 2021 - Listed in MySQL MariaDB Database Linux - 0 comments

How to fix data corruption and strange characters in InfluxDB measurements and series names

Published on October 8th 2021 - Listed in Influx Database - 1 comments

MySQL syntax error when inserting empty values using PHP (not automatically assigned NULL)

Published on September 22nd 2021 - Listed in PHP MySQL MariaDB Database Coding - 0 comments

Confluence upgrade from 7.7 to 7.13 fails with SQL error on replicated MySQL database

Published on September 6th 2021 - last updated on November 13th 2023 - Listed in Atlassian MySQL Database - 0 comments

Modify InfluxDB subscription to send data to multiple subscribers (asynchronous data replication)

Published on June 28th 2021 - Listed in Influx Database - 0 comments

Galera Cluster wsrep sst crash when trying to sync table without PK (Primary Key)

Published on May 7th 2021 - Listed in MySQL Database MariaDB Galera - 0 comments

MySQL replication out of sync: How to do a full database restore and solve error 1032 (could not execute update_rows)

Published on April 23rd 2021 - last updated on January 31st 2022 - Listed in MySQL Database Database - 7 comments

How to do bulk/mass changes on DNS records in PowerDNS with MySQL backend

Published on March 2nd 2021 - Listed in DNS PowerDNS Linux Coding Shell MySQL Database - 0 comments

How to create a user and grant privileges in MySQL 8.x using GRANT

Published on November 23rd 2020 - Listed in MySQL Database Database - 0 comments

MySQL and MariaDB multi source replication and how to monitor them with check_mysql_slavestatus

Published on September 30th 2020 - Listed in Monitoring MySQL MariaDB Database - 7 comments

Convert database and tables from utf8 to utf8mb4 and solve collation errors in Jira and Confluence

Published on September 29th 2020 - last updated on February 23rd 2022 - Listed in Atlassian Database MySQL - 11 comments

Atlassian Jira not starting, shows setup page in browser and database is not yet configured in logs

Published on September 8th 2020 - Listed in Atlassian Database MySQL - 0 comments

How to install MySQL 5.7 on Ubuntu 20.04 focal (and properly avoid MySQL 8.0 packages)

Published on August 31st 2020 - last updated on February 4th 2022 - Listed in MySQL Database Linux Ubuntu - 9 comments

Error on Tomcat start java.sql.SQLException: The server time zone value CEST is unrecognized after updating MySQL JDBC connector

Published on August 11th 2020 - last updated on August 12th 2020 - Listed in Tomcat Atlassian Database - 0 comments

Speed comparison PHP 7.0 vs. 7.2 vs. 7.4 using MySQL PDO connection

Published on July 21st 2020 - Listed in PHP Linux Database - 0 comments

check_mongodb returns python error on MongoDB 4.x database size check

Published on May 14th 2020 - Listed in Monitoring Database MongoDB - 0 comments

Galera node unable to sync from donor: Requesting state transfer failed: -113(No route to host)

Published on April 21st 2020 - last updated on December 22nd 2020 - Listed in MySQL Database Galera - 2 comments

PostgreSQL returns password authentication failed for user although password is correct

Published on February 14th 2020 - Listed in PostgreSQL Database - 1 comments

Galera cluster unable to sync SST: xtrabackup checkpoints missing, failed innobackupex on donor

Published on September 23rd 2019 - last updated on December 22nd 2020 - Listed in MariaDB Database Galera - 0 comments

Monitoring plugin check_mysql_slavestatus now supports mysql option file, socket (and more updates)

Published on August 22nd 2019 - Listed in MySQL MariaDB Database Monitoring - 0 comments

Comparing Galera cluster wsrep sst methods rsync vs. mariabackup

Published on August 20th 2019 - last updated on December 22nd 2020 - Listed in Database MySQL MariaDB Galera - 0 comments

How to monitor MySQL or MariaDB Galera Cluster writes and avoid deadlocks

Published on May 24th 2019 - last updated on December 22nd 2020 - Listed in Database MySQL Monitoring Galera - 0 comments

InfluxDB backup on localhost fails with error: failed copy backup to file: err=

Published on March 14th 2019 - last updated on March 14th 2019 - Listed in Database Influx - 0 comments

How to solve Rancher 1.x service stuck in removing (in progress)

Published on February 13th 2019 - last updated on March 13th 2019 - Listed in Rancher Docker Linux Database MySQL - 1 comments

How to create a new admin user in a clustered CouchDB

Published on November 21st 2018 - Listed in CouchDB Database - 0 comments

Creating an InfluxDB asynchronous replication using subscription service

Published on November 13th 2018 - last updated on February 20th 2023 - Listed in Database Influx Monitoring Icinga - 1 comments

MariaDB Galera Cluster: When the data is in sync but the query results differ

Published on November 9th 2018 - Listed in MySQL MariaDB Database Galera - 0 comments

Fix table increment counter in MariaDB or MySQL after manual row deletion

Published on July 24th 2018 - Listed in PHP MySQL MariaDB Database - 0 comments

Freeing up disk space from CouchDB - do not forget the views!

Published on July 19th 2018 - Listed in CouchDB Database DB Linux - 3 comments

Rancher 1.6: Github user not able to login (Internal Server Error)

Published on May 31st 2018 - Listed in Docker Rancher Linux DB Database MySQL Git - 0 comments

Quickly show character sets and collations of all tables in a MySQL database

Published on May 30th 2018 - last updated on September 29th 2020 - Listed in DB Database MySQL - 0 comments

How to build a generic Icinga2 service graph in Grafana using InfluxDB

Published on May 11th 2018 - Listed in Icinga Monitoring Grafana Influx Database - 2 comments

Galera node on Ubuntu 14.04 Trusty not joining after update to MariaDB 10.0.34

Published on April 25th 2018 - last updated on December 22nd 2020 - Listed in MySQL MariaDB Database DB Galera - 0 comments

New version of check_couchdb_replication allows check of all replications

Published on March 26th 2018 - Listed in Database DB CouchDB Nagios Icinga Monitoring - 0 comments

New monitoring plugin check couchdb replication to monitor CouchDB replications

Published on January 8th 2018 - Listed in Nagios Icinga Monitoring Database CouchDB - 0 comments

New version of check_es_system plugin fixes authentication problems

Published on January 5th 2018 - Listed in Monitoring Nagios Icinga Elasticsearch DB Database - 0 comments

Recover a crashed MySQL or MariaDB InnoDB database from ibd files

Published on December 13th 2017 - Listed in Database DB MySQL MariaDB - 2 comments

Create separate measurement tables in InfluxDB for Icinga 2 NRPE checks

Published on December 12th 2017 - last updated on February 20th 2023 - Listed in Icinga Monitoring Influx Database - 3 comments

Automatically cleaning up archived WAL files on a PostgreSQL server

Published on October 27th 2017 - Listed in DB Postgres PGSQL Database PostgreSQL - 7 comments

check_mssql_health: Monitoring MSSQL with SQL query and negative thresholds

Published on July 28th 2017 - Listed in Windows Monitoring Database DB - 0 comments

How to monitor a PostgreSQL replication

Published on July 26th 2017 - last updated on June 15th 2021 - Listed in DB Postgres Database Monitoring Icinga Nagios - 3 comments

Unable to delete application link in JIRA (NullPointerException: consumer)

Published on April 3rd 2017 - Listed in Linux Database Windows Atlassian - 0 comments

Galera Arbitrator garbd not starting: Exception in creating receive loop

Published on March 29th 2017 - last updated on December 22nd 2020 - Listed in MySQL DB Database MariaDB Galera - 1 comments

Tackling Confluence migration issues (Windows+MSSQL to Linux+MariaDB)

Published on March 24th 2017 - Listed in Linux Database MySQL Windows Atlassian - 0 comments

MySQL InnoDB: Operating system error number 13 in a file operation

Published on February 21st 2017 - Listed in Linux Database MySQL - 0 comments

Update MySQL table by appending text to existing column value

Published on October 6th 2016 - Listed in MySQL DB Database - 0 comments

How to measure the data size (usage) of single tables or databases in MariaDB or MySQL

Published on January 27th 2016 - last updated on February 6th 2023 - Listed in Database MySQL MariaDB - 1 comments

It is 2015 and we still should not use MongoDB (POV of a Systems Engineer)

Published on September 15th 2015 - last updated on February 11th 2023 - Listed in Database MongoDB DB - 0 comments

MongoDB 3.x: Create log rotation script

Published on July 6th 2015 - Listed in DB MongoDB Database - 4 comments

Allow user to execute eval() command on MongoDB 3.x

Published on May 26th 2015 - Listed in DB MongoDB Database - 1 comments

Authentication on MongoDB 3.x fails with mechanism MONGODB-CR

Published on May 20th 2015 - Listed in MongoDB Database - 6 comments

MySQL replication not working - but in SHOW SLAVE STATUS everything is OK

Published on January 16th 2015 - Listed in MySQL Database Solaris Nagios Monitoring - 0 comments

MySQL Galera cluster not starting (failed to open channel)

Published on July 14th 2014 - last updated on December 22nd 2020 - Listed in MySQL Database Galera - 3 comments

How to do a Redis Master Slave switch/failover

Published on April 24th 2014 - last updated on May 26th 2021 - Listed in Database Linux Redis - 0 comments

check_mysql_slavestatus now works with MySQL 5.6

Published on January 6th 2014 - Listed in MySQL Database - 0 comments

How to change the collation of a MySQL database

Published on December 11th 2013 - Listed in MySQL Database - 1 comments

check_mysql_slavestatus plugin now handles IO Running in Connecting state

Published on October 17th 2013 - Listed in Nagios MySQL Database Monitoring - 0 comments

New version of check_mysql_slave released (minor bugfixes)

Published on September 27th 2013 - Listed in Nagios MySQL Database Monitoring - 0 comments

You have an error in your SQL syntax - single quote in text issue

Published on September 19th 2013 - Listed in PHP MySQL Database - 2 comments

MySQL: Created table did not inherit default collation of database

Published on August 29th 2013 - Listed in Database MySQL - 0 comments

First steps with MongoDB: Create a real admin user (DBA)

Published on July 24th 2013 - last updated on February 1st 2022 - Listed in MongoDB Database - 0 comments

MySQL replication stopped due to crashed table (Error no 144)

Published on July 18th 2013 - Listed in MySQL Database Unix - 0 comments

MySQL (Percona) replication stopped due to corrupt innodb ibd file

Published on June 18th 2013 - Listed in MySQL Solaris SmartOS Unix Database - 0 comments

Updated check_mysql_slavestatus plugin and documentation

Published on April 28th 2013 - Listed in Nagios MySQL Database Monitoring - 0 comments

SmartOS: svcs: Could not bind to repository server. Finding the cause.

Published on January 9th 2013 - Listed in Solaris Shell Database SmartOS Unix - 8 comments

MySQL: Cannot create or drop Stored Procedures when binary logs active

Published on January 7th 2013 - Listed in Database Linux MySQL - 0 comments

Weird case: MySQL causing high disk IO when ZFS filesystem shrinks

Published on December 18th 2012 - Listed in BSD Database Shell MySQL ZFS Rant - 1 comments

Get MySQL Status - but only some values

Published on November 28th 2012 - Listed in Database Linux Shell MySQL - 2 comments

Some notes on a MySQL downgrade 5.1 to 5.0

Published on August 16th 2012 - Listed in Linux Database MySQL - 0 comments

Basic math calculations with fields in MySQL query (output in new column)

Published on March 7th 2012 - Listed in Linux Database MySQL - 0 comments

Upgrade of VPS server (Xen) from Debian Lenny to Squeeze (MySQL problems)

Published on February 4th 2012 - Listed in Linux MySQL Database - 0 comments

Minor update of Nagios plugin check_mysql_slavestatus

Published on December 27th 2011 - Listed in Nagios Database MySQL Monitoring - 0 comments

SLES11SP1 asks for db-devel - but there isn't any

Published on November 21st 2011 - Listed in Linux Database - 2 comments

How to install perl DBD::Oracle on SLES10 (without CPAN)

Published on September 27th 2011 - Listed in Linux Database - 0 comments

How to dump and restore a Postgres database

Published on June 24th 2011 - Listed in Linux Database Postgres - 0 comments

Perfdata now in check_mysql_slavestatus

Published on June 22nd 2011 - Listed in Linux Nagios Database MySQL Monitoring - 0 comments

Howto change default MySQL privileges/permissions in Confixx

Published on May 24th 2011 - Listed in Linux Internet Database MySQL - 0 comments

HowTo Change Confixx email account password in Roundcube

Published on August 14th 2010 - Listed in Internet Linux PHP Database MySQL Roundcube - 0 comments

Wrong latin1 Umlaut entries with phpMyAdmin 3.1.0

Published on December 4th 2008 - Listed in PHP Database MySQL - 0 comments

Cleanup Confixx after a server transfer

Published on October 21st 2008 - Listed in Linux MySQL Database - 0 comments

Update of Nagios Plugin check_mysql_slavestatus.sh

Published on October 16th 2008 - Listed in Nagios Shell MySQL Monitoring Database - 0 comments

RSS feed

Blog Tags:

  AWS   Android   Ansible   Apache   Apple   Atlassian   BSD   Backup   Bash   Bluecoat   CMS   Chef   Cloud   Coding   Consul   Containers   CouchDB   DB   DNS   Database   Databases   Docker   ELK   Elasticsearch   Filebeat   FreeBSD   Galera   Git   GlusterFS   Grafana   Graphics   HAProxy   HTML   Hacks   Hardware   Icinga   Icingaweb   Icingaweb2   Influx   Internet   Java   KVM   Kibana   Kodi   Kubernetes   LVM   LXC   Linux   Logstash   Mac   Macintosh   Mail   MariaDB   Minio   MongoDB   Monitoring   Multimedia   MySQL   NFS   Nagios   Network   Nginx   OSSEC   OTRS   Office   PGSQL   PHP   Perl   Personal   PostgreSQL   Postgres   PowerDNS   Proxmox   Proxy   Python   Rancher   Rant   Redis   Roundcube   SSL   Samba   Seafile   Security   Shell   SmartOS   Solaris   Surveillance   Systemd   TLS   Tomcat   Ubuntu   Unix   VMWare   VMware   Varnish   Virtualization   Windows   Wireless   Wordpress   Wyse   ZFS   Zoneminder   


Update cookies preferences