LazyLibrarian in 9.2

[Chris Cameron]

minor correction to the chown command:

Code:

service lazylibrarian onestop
rm -r /usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian
fetch --no-verify-peer "https://github.com/DobyTang/LazyLibrarian/archive/master.tar.gz"
tar xzf master.tar.gz
mv LazyLibrarian-master /usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian
chown -R media:media /usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian
rm master.tar.gz
service lazylibrarian start

 

[Rudi Pittman]

Is this plugin still being updated? I ask because it appears the python in the jail need to be upgraded. It can no longer self update because it cannot talk to Github which now requires https to support TLS>1.0. Apparently other plugins(sickrage, couchpotato etc) will eventually require this as well since Github has been warning they will be going to https only for quite some time. At least that's what the devs for LazyLibrarian indicated.

 

[Joshua Parker Ruehlig]

I haven't needed to update it for years. But if this is an issue I assume it affects all the python based, auto-update plugins as you mentioned.
It looks like my sickrage is still updating, I believe because I build some of the plugins with the option "WITH_OPENSSL_PORT=yes". I think if I do the same with LazyLibrarian auto-update should continue to work.

 

[Joshua Parker Ruehlig]

It looks like the only plugins I need to add the option to are Maraschino and LazyLibrarian. No wonder my Maraschino instance stopped looking for updates.

 

[Rudi Pittman]

Thanks Joshua. Appreciate you keeping things working for us!

 

[Chris Cameron]

It looks like the only plugins I need to add the option to are Maraschino and LazyLibrarian. No wonder my Maraschino instance stopped looking for updates.

Hi Joshua - LazyLibrarian has moved to GitLab https://gitlab.com/LazyLibrarian/LazyLibrarian

Would it be possible for you to update the plugin to reflect this?

I tried this is in the existing jail (with minor URL correction from instructions here), it broke, so I rolled it back from snapshot:

Code:

fetch --no-verify-peer "https://gitlab.com/LazyLibrarian/LazyLibrarian/-/archive/master/LazyLibrarian-master.tar.gz"
tar xzf LazyLibrarian-master.tar.gz
service lazylibrarian onestop
rm -r /usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian
mv LazyLibrarian-master /usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian
chown -R media:media /usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian
service lazylibrarian onestart
rm LazyLibrarian-master.tar.gz

Kept getting a warning from urllib when the service was starting, then it would report not running.

Code:

/usr/lib/python2.7/site-packages/urllib3/connectionpool.py:852: InsecureRequestWarning: Unverified HTTPS request is being made. Adding certificate verification is strongly advised. See:  https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings

I tried updating the various SSL modules as suggested here, but it didn't help.

Code:

pip install -U pycrypto
pip install -U pyasn1
pip install -U cryptography
pip install -U ndg-httpsclient
pip install -U "requests[security]"

I also tried just updating to the latest version from Github from the commands in previous post & run into all sorts config.ini/KeyErrors/DataTable warnings. Same result if I

Code:

cd /usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian
git pull

At this point I was stuck on:

Code:

Repo: https://github.com/dobytang/lazylibrarian : Branch: master : Updated: Fri Jan 12 19:19:51 2018
Current Version: 0a51cb90f788fba0364f31b3f88d850ef7e6b123 : Latest Version: Not_Available_From_GitHUB

Apparently restarting the jail alleviates some of the errors I was running into above.

I finally cloned the new repo...

Code:

service lazylibrarian onestop
cd
git clone https://gitlab.com/LazyLibrarian/LazyLibrarian.git
rm -r /usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian
mv LazyLibrarian /usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian
chown -R media:media /usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian
service lazylibrarian start

& it seems to be running OK, except for all of these database errors/module warnings:

Show

Code:

Timestamp    Level    Message
2019-01-22 16:11:40    ERROR    Failed query: [SELECT AuthorImg,AuthorName,LastBook,LastDate,Status,AuthorLink,LastLink,HaveBooks,UnignoredBooks,AuthorID,LastBookID from authors where Status != "Ignored" order by AuthorName COLLATE NOCASE]
2019-01-22 16:11:40    ERROR    Database OperationalError: no such column: LastBookID
2019-01-22 16:11:29    ERROR    Failed query: [SELECT AuthorImg,AuthorName,LastBook,LastDate,Status,AuthorLink,LastLink,HaveBooks,UnignoredBooks,AuthorID,LastBookID from authors where Status != "Ignored" order by AuthorName COLLATE NOCASE]
2019-01-22 16:11:29    ERROR    Database OperationalError: no such column: LastBookID
2019-01-22 16:11:22    ERROR    Unhandled exception in database upgrade: Traceback (most recent call last): File "/usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian/lazylibrarian/dbupgrade.py", line 257, in dbupgrade upgrade_function(myDB, upgradelog) File "/usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian/lazylibrarian/dbupgrade.py", line 1259, in db_v37 myDB.action('INSERT INTO issues SELECT Title,IssueID,IssueAcquired,IssueDate,IssueFile FROM temp_table') File "/usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian/lazylibrarian/database.py", line 50, in action return self._action(query, args, suppress) File "/usr/pbi/lazylibrarian-amd64/share/lazylibrarian/LazyLibrarian/lazylibrarian/database.py", line 62, in _action sqlResult = self.connection.execute(query) OperationalError: foreign key mismatch - "issues" referencing "magazines"
2019-01-22 16:11:22    ERROR    Failed query: [INSERT INTO issues SELECT Title,IssueID,IssueAcquired,IssueDate,IssueFile FROM temp_table]
2019-01-22 16:11:22    ERROR    Database OperationalError: foreign key mismatch - "issues" referencing "magazines"
2019-01-22 16:11:22    ERROR    Database integrity check: ok
2019-01-22 16:11:21    WARNING    pyOpenSSL: module missing
2019-01-22 16:11:21    WARNING    tls: missing required functionality. Try upgrading to v1.2 or newer. You have tls: TLS 1.0
2019-01-22 16:11:21    WARNING    urllib3: missing
2019-01-22 16:11:20    ERROR    Failed query: [select comicid from comicissues except select comicid from comics]
2019-01-22 16:11:20    ERROR    Database OperationalError: no such table: comics
2019-01-22 16:11:20    ERROR    Failed query: [select genreid from genrebooks except select genreid from genres]
2019-01-22 16:11:20    ERROR    Database OperationalError: no such table: genres
2019-01-22 16:11:20    ERROR    Failed query: [select GenreID, (select count(*) as counter from genrebooks where genres.genreid = genrebooks.genreid) as cnt from genres where cnt = 0]
2019-01-22 16:11:20    ERROR    Database OperationalError: no such table: genres

 

[naq90]

& it seems to be running OK, except for all of these database errors/module warnings:

Hey, is this still running well for you? I'm thinking about following your instructions and trying it out in a new jail in 11.2.