#dbadmin — Public Fediverse posts

Setup #fail2ban to stop some random IP from hitting my #postgres server again and again. It would never have been able to authenticate, but not going to let that keep happening.

#selfhosting #dbadmin

@Aschenbrenner any #dba #dbadmin #mssql should be aware 🤓

Do not run databases in containers, if possible - do not run them in virtual machines either. Databases love bare metal :sql:

In fact, one evil red company even instructs bare metal deployment of their database for performance reasons :catroll:

If you ever see container image of an application packed together with database - use it for development purposes only!

You'll thank me later :blobcatfluffhappy:

#sysadmin #dbadmin #virtualization #protip

If phpMyAdmin gives you “Error text: OK (rejected)” … ✅🕵️😊

https://www.joho.se/2024/03/12/if-phpmyadmin-gives-you-error-text-ok-rejected

#phpmyadmin #errormessage #mysql #mariadb #percona #dbadmin #php #devops #phpdev #developers #programming

If phpMyAdmin gives you “Error text: OK (rejected)” … ✅🕵️😊

https://www.joho.se/2024/03/12/if-phpmyadmin-gives-you-error-text-ok-rejected

#phpmyadmin #errormessage #mysql #mariadb #percona #dbadmin #php #devops #phpdev #developers #programming

If phpMyAdmin gives you “Error text: OK (rejected)” … ✅🕵️😊

https://www.joho.se/2024/03/12/if-phpmyadmin-gives-you-error-text-ok-rejected

#phpmyadmin #errormessage #mysql #mariadb #percona #dbadmin #php #devops #phpdev #developers #programming

If phpMyAdmin gives you “Error text: OK (rejected)” … ✅🕵️😊

https://www.joho.se/2024/03/12/if-phpmyadmin-gives-you-error-text-ok-rejected

#phpmyadmin #errormessage #mysql #mariadb #percona #dbadmin #php #devops #phpdev #developers #programming

If phpMyAdmin gives you “Error text: OK (rejected)” … ✅🕵️😊

https://www.joho.se/2024/03/12/if-phpmyadmin-gives-you-error-text-ok-rejected

#phpmyadmin #errormessage #mysql #mariadb #percona #dbadmin #php #devops #phpdev #developers #programming

It may be common knowledge but my mind was blown. :amaze:

We're using CentOS and my DBAD (Database Admin) instructor hinted at the option to make user input variables in some of the new dictionary views we learned this module and using WHERE name = UPPER('&NAME') in the select statement.

I had no idea you could prompt for user input... I was in the middle of making 3 profiles, 9 roles,
16 users, granting them roles and/or privileges as I went, editing a text file in gedit with the new user data and pasting it into the terminal.

It may not actually be faster but it feels faster (I may be biased because I love database). The &UNLIMITED_QUOTA_TABLESPACE variable name is not the best and very long, use &QUOTA_TABLESPACE or something shorter, and the size can be changed to &SIZE_APPEND_M so you can enter 20M but we were using unlimited for the lab.

#CentOS #Oracle #SQL #DBA #OracleSQL #Database #DBAdmin #DBAD #CentOS5 #Oracle12c

It may be common knowledge but my mind was blown. :amaze:

We're using CentOS and my DBAD (Database Admin) instructor hinted at the option to make user input variables in some of the new dictionary views we learned this module and using WHERE name = UPPER('&NAME') in the select statement.

I had no idea you could prompt for user input... I was in the middle of making 3 profiles, 9 roles,
16 users, granting them roles and/or privileges as I went, editing a text file in gedit with the new user data and pasting it into the terminal.

It may not actually be faster but it feels faster (I may be biased because I love database). The &UNLIMITED_QUOTA_TABLESPACE variable name is not the best and very long, use &QUOTA_TABLESPACE or something shorter, and the size can be changed to &SIZE_APPEND_M so you can enter 20M but we were using unlimited for the lab.

#CentOS #Oracle #SQL #DBA #OracleSQL #Database #DBAdmin #DBAD #CentOS5 #Oracle12c

It may be common knowledge but my mind was blown. :amaze:

We're using CentOS and my DBAD (Database Admin) instructor hinted at the option to make user input variables in some of the new dictionary views we learned this module and using WHERE name = UPPER('&NAME') in the select statement.

I had no idea you could prompt for user input... I was in the middle of making 3 profiles, 9 roles,
16 users, granting them roles and/or privileges as I went, editing a text file in gedit with the new user data and pasting it into the terminal.

It may not actually be faster but it feels faster (I may be biased because I love database). The &UNLIMITED_QUOTA_TABLESPACE variable name is not the best and very long, use &QUOTA_TABLESPACE or something shorter, and the size can be changed to &SIZE_APPEND_M so you can enter 20M but we were using unlimited for the lab.

#CentOS #Oracle #SQL #DBA #OracleSQL #Database #DBAdmin #DBAD #CentOS5 #Oracle12c

Episode 101 - Devart's DbForge Studio will come out 1st of January 2022 at 5pm CET.

Happy New Year to All of You

Article:
https://blog.tsr-podcast.com​

Audio:
https://tsr-podcast.com​

#sql #dbforge #databases #dbadmin

#ElasticSearch, one of the targets of the #MeowDbAttack, has long had ZARRO authentication and security features in its free version.

(Security was added in release 6.8, in May 2019 https://www.elastic.co/guide/en/elasticsearch/reference/6.8/release-notes-6.8.0.html)

ElasticSearch is "trusted, used, and loved by" #Bayer, #Adobe, #Lenovo, #WalMart, and #Kroeger and is the featured search utility on #AmazonAWS (https://www.elastic.co/elasticsearch/)

https://arstechnica.com/information-technology/2020/07/more-than-1000-databases-have-been-nuked-by-mystery-meow-attack/

I'd really like to hear from #ElasticNV or founder/CEO #ShayBanon

For now, crickets:

https://twitter.com/kimchy
https://twitter.com/elastic

HN: https://news.ycombinator.com/item?id=23957510
SO: https://stackoverflow.com/questions/63067062/elastic-search-indexes-gets-deleted-frequently

#sysadmin #dbadmin #infosec #schadenfreude

#ElasticSearch, one of the targets of the #MeowDbAttack, has long had ZARRO authentication and security features in its free version.

(Security was added in release 6.8, in May 2019 https://www.elastic.co/guide/en/elasticsearch/reference/6.8/release-notes-6.8.0.html)

ElasticSearch is "trusted, used, and loved by" #Bayer, #Adobe, #Lenovo, #WalMart, and #Kroeger and is the featured search utility on #AmazonAWS (https://www.elastic.co/elasticsearch/)

https://arstechnica.com/information-technology/2020/07/more-than-1000-databases-have-been-nuked-by-mystery-meow-attack/

I'd really like to hear from #ElasticNV or founder/CEO #ShayBanon

For now, crickets:

https://twitter.com/kimchy
https://twitter.com/elastic

HN: https://news.ycombinator.com/item?id=23957510
SO: https://stackoverflow.com/questions/63067062/elastic-search-indexes-gets-deleted-frequently

#sysadmin #dbadmin #infosec #schadenfreude