database

(tag)

  • MythTV add-on for Kodi hangs at 0%

    Around about the 26/3/2021 the Windows 10 MythTV add-on for Kodi stopped working. I had seen similar problem before, Kodi MythTV addon fails to load except this time it didn’t load at all whereas previously it was stuck loading at around 40%. This time around it didn’t seem to connect to the MythTV server at… read more…

    MythTV add-on for Kodi hangs at 0%
  • Monitor all queries to MariaDB

    Want to see what is being run against your MariaDB this is what to do. Firstly you need to enable logging to a file of all queries. You do this by running: SET GLOBAL general_log=1; SET GLOBAL general_log_file=’/var/opt/rh/rh-mariadb102/log/mariadb/maria_general.log’; Problem is you need special permissions and in practical terms the easiest way is to run it… read more…

    Monitor all queries to MariaDB
  • Resetting a PostgreSQL root password

    Recently I upgraded to the latest Postgres version. I had a number of pain points doing this including not being able to start the DBs because the version upgrade was too big – had to export from old version and import to new. But one of the problems was that for some reason my password… read more…

    Resetting a PostgreSQL root password