February, 21 of 2024

I tried to set up my connection to Bologna with Luca, but for some reason, my Google OTP Token isn't working...


We spent the day trying, without success.

The flight in Miami was changed, but it won't impact the already planned trip.


We had a conversation with Christian about monitoring using the Event Console of Check_MK, instead of the scripts previously used by their with AMSO there. And I believe they will accept our solution because it works well and is less complex than their scripts.


I'll also try to implement monitoring for Corrupted Blocks in Oracle. From what I saw on the pages and manuals of Check_MK, this hasn't been implemented. We're considering the possibility of doing it via "oracle_sql" - Custom SQL:

Werk #7095: oracle_sql: New check for monitoring custom SQLs

Component
Checks & agents
Title
oracle_sql: New check for monitoring custom SQLs
Date
Jan 22, 2019
Checkmk Edition
Checkmk Raw (CRE)
Checkmk Version
Level
Trivial Change
Class
New Feature
Compatibility
Compatible - no manual interaction needed
The mk_oracle allows the execution of parametrizable custom SQLs. Note that the following configuration is not bakeable.

First of all you have to register sections and configure their options. This can be done in the {{mk_oracle.cfg}} via SQLS_SECTIONS=sec_a,... sec_a () { #OPTIONS }

In general there are two types of check plugins which handle the output of the custom SQLs:

  1. {{oracle_sql}} for generic custom SQLs
  2. own check plugins if {{SQLS_SECTION_NAME}} is used (see below)
The following configuration variables can be stated globally or locally (within a section definition; this overwrites the global variable). SQLS_SIDS=sid1,sid2,... (comma separated) SQLS_DIR=/path/to/dir (no trailing '/') SQLS_SQL=name.sql (the SQL name which must exist in SQLS_DIR) SQLS_PARAMETERS=params (parameters as string, double quotes are removed) SQLS_MAX_CACHE_AGE=X (x in seconds) SQLS_SECTION_NAME=sec_name (optional, for own check plugins; if not stated, 'oracle_sql' is used; generic check plugin) SQLS_SECTION_SEP=separator (optional; only useful if SQLS_SECTION_NAME is stated; ASCII code, eg. '58' means ':')

  • {{SQLS_SIDS}: For which SIDs the SQL is executed.
  • {{SQLS_DIR}}: The folder of the SQLs.
  • {{SQLS_SQL}}: The SQL name within SQLS_DIR.
  • {{SQLS_PARAMETERS}}: Declare parameters if needed. Mostly they are declare within double quotes. In this case you have to escape them if yu need them as characters within the parameters.
  • {{SQLS_MAX_CACHE_AGE}}: How long the cached data is recent enough.
  • {{SQLS_SECTION_NAME}}: The output of the SQL is stored below this section. That means you have to build your own check plugin.
  • {{SQLS_SECTION_SEP}}: At which character the output is separated.
If the generic {{oracle_sql}} section header is used then the item within the custom SQL service can be influenced by {{SQLS_ITEM_NAME}}: SQLS_ITEM_NAME=item_name (optional, if not stated, sql name is used) Otherwise the SQL name {{SQLS_SQL}} is used.

I got an invitation from Dea to join BlueSky. Honestly, I didn't even remember that, but I'll try it out since "Xuiter" is not for me anymore... Ellon Musk really ruined it!
There were several power outages in the area today... So I had to step 11 floors of stairs when I returned from the market for some small groseries, still helping an old man carrying a bag of plaster up to the third floor. I stopped on the 5th, caught my breath, another stop on the 8th, and finally got home. Due to the power outage, the internet router turned off and my IP changed...
Leading to that problem discussed yesterday with Abdul, about accessing the VPN from Egypt... 🤦Let's leave it alone for now since I don't need to access it there... 👀

Later, Rodrigo and Lau's husband came here to install the bathroom sink...

the bedroom curtain,

and replace the flush engine of the other bathroom's toilet.

In the meantime, I had to go to the nearby tools shop to buy a tail rope for the sink to the pipe, a silicone tube (to seal the bathroom sink), and I took the opportunity to buy a new gas regulator to replace the one in the kitchen gas cylinder that has been asking for a replacement has been some time already.

At night, I watched the match between Sport Recife vs Fortaleza. Until halfway through the second half, the score was Fortaleza 1 x 0 Sport, and I went to bed frustrated because Sport was playing much better. The final score was 1 x 1, still unfair in my humble opinion...

Comentários

Postar um comentário

Postagens mais visitadas deste blog

Data Protector Cannot connect to the SCM (Service Control Manager)

Imagem
Antigamente meus backups de BD (Banco de Dados) se resumiam a cópias em disco que iam para HDs externos e tal. Há quase 6 meses eu venho trabalhando com uma ferramenta de backup de verdade, com biblioteca de fitas LTO, robô de mudança de fitas e toda aquela parafernália que faz com que o tempo de recuperação de um backup caia de 7 horas para 3 (ou até menos). Afinal, quando o BD para ninguém quer saber como você vai fazer para recuperá-lo, apenas querem que o faça o mais rápido possível. Bastante razoável. Essa ferramenta (HP Data Protector 6.20) consiste basicamente em um Servidor (Cell Manager) que conversa com o Cliente (local onde estão os dados que será feito backup ou onde você deseja restaurar o backup). Cada Servidor pode também ser um "Installation Server", ou seja, conter os aplicativos de instalação, evitando que toda vez que você precisar adicionar um novo cliente, ter que ir lá ao mesmo, fisicamente, com um DVD na mão e um manual embaixo do braço para fazer a di...
Leia mais

March, 22 of 2024

Imagem
I worked on configuring the mk_oracle plugin to update the mk_oracle.cfg file to ensure that an update to the plugin wouldn't overwrite (remove) the changes for using Custom SQL, since these configurations are done manually on the host. We found a Check_MK Werk that brings us a solution to this problem: Which I documented promptly: This is a guide to deploy Custom SQLs checks for Oracle Agent. As there still isn't how to configure this in the GUI, and the Agent Bakery will overwrite the changes made directly into the mk_oracle.cfg file, this document will guide to do a safe configuration and thus avoid the overwriting of the mk_oracle.cfg file. 1) Make a directory "mk_oracle.d" inside the $MK_CONFDIR directory. Usually its /etc/check_mk     #mkdir mk_oracle.d 2) Also create a directory where yours .sql files will be placed, into the same $MK_CONFDIR     #mkdir sqldir 3) The sql script ouput must be as following:     details: here is a breaf description over...
Leia mais

Eu Quero um Pug!

Imagem
wee funny looking black and white dog on out of focus black and white floorboards , upload feito originalmente por gorbot. . Para aqueles que não sabem, um "Pug" é uma raça de cachorro que se acredita ser originária da China. São cães de pequeno porte, agradáveis, companheiros, brincalhões e dóceis, com um coração muito maior que seu pequeno tamanho. Ideais para serem criados em apartamentos, já que não gostam de ficar sozinhos fora da casa e sofrem com mudanças bruscas de temperaturas. Para ajudar na visualização de como seria um Pug, além da foto acima, vocês podem lembrar no filme Homens de Preto, aquele cãozinho sem noção, o Frank. Confesso que só passei a conhecer a raça após o filme, mas o cão Pug surgiu por volta de 400 A.C. Com o tempo ele tornou-se um grande companheiro da Baixa Realeza. Uma história publicada em 1618 pelo Sir Roger William conta um incidente em que um Pug salvou William, O Silencioso. Relatos indicam que o fato ocorreu entre 1571 e 1573, quando um a...
Leia mais