# Fix LircSocket in mythtv database
  SOCKET=`mysql -u mythtv -pmythtv -B --skip-column-names -h "${dbhost}" -D mythconverg -e \
         "SELECT data FROM settings WHERE value = 'LircSocket' AND hostname = '${hostname}';"`
    if [ "${SOCKET}" != "/var/run/lirc/lircd" ]; then
      mysql -u mythtv -pmythtv -B --skip-column-names -h "${dbhost}" -D mythconverg -e \
      "UPDATE settings SET data = '/var/run/lirc/lircd' WHERE value = 'LircSocket' AND hostname = '${hostname}';"
    else
      echo ">>>"
      echo ">>> ATTENTION! ATTENTION! ATTENTION!"
      echo ">>> Unable to connect the the MySQL database to make needed"
      echo ">>> changes to the LIRC socket."
      echo ">>> LIRC now uses /var/run/lirc/lircd and /dev/lirc is now"
      echo ">>> obsolete. Update your MythTV settings to reflect this."
      echo ">>>"
    fi