Mailing List Archive: can't run optimize_mythdb.pl from command line

can't run optimize_mythdb.pl from command line

Jan 13, 2020, 7:40 PM

Post #1 of 4 (650 views)

Looking for an answer to Greg Oliver's question, I realized I cannot run
optimize_mythdb.pl from command line on OpenSuse 15.1, mythtv version
29-fixes, and I'd like to put it into cron. I get this error:

Base class package "IO::Socket::INET6" is empty.
(Perhaps you need to 'use' the module which defines that package first,
or make that module available in @INC (@INC contains:
/usr/lib/perl5/site_perl/5.26.1/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.26.1
/usr/lib/perl5/vendor_perl/5.26.1/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.26.1
/usr/lib/perl5/5.26.1/x86_64-linux-thread-multi /usr/lib/perl5/5.26.1
/usr/lib/perl5/site_perl).
at /usr/lib/perl5/vendor_perl/5.26.1/IO/Socket/INET/MythTV.pm line 14.
BEGIN failed--compilation aborted at
/usr/lib/perl5/vendor_perl/5.26.1/IO/Socket/INET/MythTV.pm line 14.
Compilation failed in require at
/usr/lib/perl5/vendor_perl/5.26.1/MythTV.pm line 14.
BEGIN failed--compilation aborted at
/usr/lib/perl5/vendor_perl/5.26.1/MythTV.pm line 14.
Compilation failed in require at ./optimize_mythdb.pl line 15.
BEGIN failed--compilation aborted at ./optimize_mythdb.pl line 15.

As to IPV6, I don't run that at all, I disable it completely. I've never
worked at all with Perl, so I'm not exactly sure what to do. @INC, from
the error message, already contains the Perl I have installed.

However, it seems like I don't have "DBI" and "MythTV" defined
correctly, but I don't know how to correctly define them in Perl.

Thank you, and I apologize in advance for the silly question.

Re: can't run optimize_mythdb.pl from command line [ In reply to ]

mtdean at thirdcontact

Jan 13, 2020, 8:05 PM

Post #2 of 4 (650 views)

Permalink

On 01/13/2020 10:40 PM, Jeremy D. Eiden wrote:
>
> Looking for an answer to Greg Oliver's question, I realized I cannot
> run optimize_mythdb.pl from command line on OpenSuse 15.1, mythtv
> version 29-fixes, and I'd like to put it into cron. I get this error:
>
> Base class package "IO::Socket::INET6" is empty.
> (Perhaps you need to 'use' the module which defines that package
> first,
> or make that module available in @INC (@INC contains:
> /usr/lib/perl5/site_perl/5.26.1/x86_64-linux-thread-multi
> /usr/lib/perl5/site_perl/5.26.1
> /usr/lib/perl5/vendor_perl/5.26.1/x86_64-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.26.1
> /usr/lib/perl5/5.26.1/x86_64-linux-thread-multi /usr/lib/perl5/5.26.1
> /usr/lib/perl5/site_perl).
> at /usr/lib/perl5/vendor_perl/5.26.1/IO/Socket/INET/MythTV.pm line 14.
> BEGIN failed--compilation aborted at
> /usr/lib/perl5/vendor_perl/5.26.1/IO/Socket/INET/MythTV.pm line 14.
> Compilation failed in require at
> /usr/lib/perl5/vendor_perl/5.26.1/MythTV.pm line 14.
> BEGIN failed--compilation aborted at
> /usr/lib/perl5/vendor_perl/5.26.1/MythTV.pm line 14.
> Compilation failed in require at ./optimize_mythdb.pl line 15.
> BEGIN failed--compilation aborted at ./optimize_mythdb.pl line 15.
>
> As to IPV6, I don't run that at all, I disable it completely. I've
> never worked at all with Perl, so I'm not exactly sure what to do.
> @INC, from the error message, already contains the Perl I have installed.
>
> However, it seems like I don't have "DBI" and "MythTV" defined
> correctly, but I don't know how to correctly define them in Perl.
>
> Thank you, and I apologize in advance for the silly question.
>

Looks like you're missing some of the prerequisite Perl modules for the
MythTV Perl bindings--specifically you need IO::Socket::INET6. I don't
know what package that would be for OpenSuse, but likely something to
the effect of perl-IO-Socket-INET6. Even if you're not using IPv6, you
need the module installed for the bindings--it's actually used for IPv4
and IPv6.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org

Re: can't run optimize_mythdb.pl from command line [ In reply to ]

oliver.greg at gmail

Jan 13, 2020, 8:07 PM

Post #3 of 4 (650 views)

Permalink

On Mon, Jan 13, 2020 at 9:42 PM Jeremy D. Eiden <theonlyrealperson@gmail.com>
wrote:

> Looking for an answer to Greg Oliver's question, I realized I cannot run
> optimize_mythdb.pl from command line on OpenSuse 15.1, mythtv version
> 29-fixes, and I'd like to put it into cron. I get this error:
>

Thanks for looking into my question :)

Base class package "IO::Socket::INET6" is empty.

> (Perhaps you need to 'use' the module which defines that package first,
> or make that module available in @INC (@INC contains:
> /usr/lib/perl5/site_perl/5.26.1/x86_64-linux-thread-multi
> /usr/lib/perl5/site_perl/5.26.1
> /usr/lib/perl5/vendor_perl/5.26.1/x86_64-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.26.1
> /usr/lib/perl5/5.26.1/x86_64-linux-thread-multi /usr/lib/perl5/5.26.1
> /usr/lib/perl5/site_perl).
> at /usr/lib/perl5/vendor_perl/5.26.1/IO/Socket/INET/MythTV.pm line 14.
> BEGIN failed--compilation aborted at
> /usr/lib/perl5/vendor_perl/5.26.1/IO/Socket/INET/MythTV.pm line 14.
> Compilation failed in require at
> /usr/lib/perl5/vendor_perl/5.26.1/MythTV.pm line 14.
> BEGIN failed--compilation aborted at
> /usr/lib/perl5/vendor_perl/5.26.1/MythTV.pm line 14.
> Compilation failed in require at ./optimize_mythdb.pl line 15.
> BEGIN failed--compilation aborted at ./optimize_mythdb.pl line 15.
>
> As to IPV6, I don't run that at all, I disable it completely. I've never
> worked at all with Perl, so I'm not exactly sure what to do. @INC, from
> the error message, already contains the Perl I have installed.
>
> However, it seems like I don't have "DBI" and "MythTV" defined correctly,
> but I don't know how to correctly define them in Perl.
>
> Thank you, and I apologize in advance for the silly question.
>

You do not really need to run that myth provided script. It is just
running a few MySQL / MariadDB commands. This bash should get it done
(change your user/pass and host as necessary):

for i in $(echo "show tables;" |mysql -u mythtv -pmythtv -h mysql
mythconverg) ; do for j in repair optimize analyze ; do echo "$j table
$i;"|mysql -u mythtv -pmythtv -h mysql mythconverg; done ; done

echo "ALTER TABLE `recordedseek` ORDER BY chanid, starttime, type;"|mysql
-u mythtv -pmythtv -h mysql mythconverg

echo "ALTER TABLE `program` ORDER BY starttime, chanid;"|mysql -u mythtv
-pmythtv -h mysql mythconverg

echo "ALTER TABLE `filemarkup` ORDER BY filename;"|mysql -u mythtv
-pmythtv -h mysql mythconverg

Re: can't run optimize_mythdb.pl from command line [ In reply to ]

theonlyrealperson at gmail

Jan 13, 2020, 8:23 PM

Post #4 of 4 (647 views)

Permalink

Thank you to you and Greg Oliver. Sorry I couldn't find your answer Mr.
Oliver.

For those, if any, that are running OpenSuse 15.1 with MythTV 29-fixes,
just install:

perl-IO-Socket-INET6

and you are good.

thank you both!

On 1/13/20 10:05 PM, Michael T. Dean wrote:
> On 01/13/2020 10:40 PM, Jeremy D. Eiden wrote:
>>
>> Looking for an answer to Greg Oliver's question, I realized I cannot
>> run optimize_mythdb.pl from command line on OpenSuse 15.1, mythtv
>> version 29-fixes, and I'd like to put it into cron. I get this error:
>>
>> Base class package "IO::Socket::INET6" is empty.
>> (Perhaps you need to 'use' the module which defines that package
>> first,
>> or make that module available in @INC (@INC contains:
>> /usr/lib/perl5/site_perl/5.26.1/x86_64-linux-thread-multi
>> /usr/lib/perl5/site_perl/5.26.1
>> /usr/lib/perl5/vendor_perl/5.26.1/x86_64-linux-thread-multi
>> /usr/lib/perl5/vendor_perl/5.26.1
>> /usr/lib/perl5/5.26.1/x86_64-linux-thread-multi /usr/lib/perl5/5.26.1
>> /usr/lib/perl5/site_perl).
>> at /usr/lib/perl5/vendor_perl/5.26.1/IO/Socket/INET/MythTV.pm line 14.
>> BEGIN failed--compilation aborted at
>> /usr/lib/perl5/vendor_perl/5.26.1/IO/Socket/INET/MythTV.pm line 14.
>> Compilation failed in require at
>> /usr/lib/perl5/vendor_perl/5.26.1/MythTV.pm line 14.
>> BEGIN failed--compilation aborted at
>> /usr/lib/perl5/vendor_perl/5.26.1/MythTV.pm line 14.
>> Compilation failed in require at ./optimize_mythdb.pl line 15.
>> BEGIN failed--compilation aborted at ./optimize_mythdb.pl line 15.
>>
>> As to IPV6, I don't run that at all, I disable it completely. I've
>> never worked at all with Perl, so I'm not exactly sure what to do.
>> @INC, from the error message, already contains the Perl I have
>> installed.
>>
>> However, it seems like I don't have "DBI" and "MythTV" defined
>> correctly, but I don't know how to correctly define them in Perl.
>>
>> Thank you, and I apologize in advance for the silly question.
>>
>
> Looks like you're missing some of the prerequisite Perl modules for
> the MythTV Perl bindings--specifically you need IO::Socket::INET6. I
> don't know what package that would be for OpenSuse, but likely
> something to the effect of perl-IO-Socket-INET6. Even if you're not
> using IPv6, you need the module installed for the bindings--it's
> actually used for IPv4 and IPv6.
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org