MythTV / mythtv

The official MythTV repository
https://www.mythtv.org
GNU General Public License v2.0
708 stars 346 forks source link

mythlink.pl/MythTV.pm "failed: Unknown MySQL server host 'HASH..." #653

Open dlasher opened 2 years ago

dlasher commented 2 years ago

MythTV Version : v31.0+fixes.202203040618.7e4ce1ba98~ubuntu20.04.1 /usr/sbin/mysqld Ver 8.0.30-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu))

Active user of the "mythlink.pl" script provided by "mythtv-backend/contrib/user_jobs" to share my mythtv content with my plex server. Didn't realize until recently the script was broken. Suspect it's been broken since my upgrade to 0.31, but not sure.

Output:

root@backend1:/usr/share/doc/mythtv-backend/contrib/user_jobs# perl ./mythlink.pl --link /raid/myth/TV.Shows/ --format '%T/Season %ss/%T-S%ssE%ep-%S'
DBI connect('database=mythconverg:host=HASH(0x559f734aa9e8);port=3306','mythtv',...) failed: Unknown MySQL server host 'HASH(0x559f734aa9e8)' (-2) at /usr/share/perl5/MythTV.pm line 373.
Cannot connect to database:

Database host is set by IP, like so:

  <Database>
    <Host>10.4.10.100<Host>

Everything else is working perfectly, not really sure how to troubleshoot this one.

(Is there a better way to create correctly named files/folders/seasons/etc from MythTV in 0.31?)

dlasher commented 2 years ago

perl debugger gives a tiny bit more data.

DBI connect('database=mythconverg:host=HASH(0x5601957ef448);port=3306','mythtv',...) failed: Unknown MySQL server host 'HASH(0x5601957ef448)' (-2) at /usr/share/perl5/MythTV.pm line 373.
 at /usr/lib/x86_64-linux-gnu/perl5/5.30/DBI.pm line 693.
        DBI::__ANON__[/usr/lib/x86_64-linux-gnu/perl5/5.30/DBI.pm:746](undef, undef) called at /usr/lib/x86_64-linux-gnu/perl5/5.30/DBI.pm line 748
        DBI::connect("DBI", "dbi:mysql:database=mythconverg:host=HASH(0x5601957ef448);port"..., "mythtvuser", "mythtvpass") called at /usr/share/perl5/MythTV.pm line 373
        MythTV::new("MythTV") called at mythlink.pl line 297
Debugged program terminated.  Use q to quit or R to restart,
dlasher commented 2 years ago

FWIW - upgraded to 0.32 - works, +1 for "are you running the latest version" and "reboot & call me in the morning"