@GOPLEX2.TV said:
eadwyn wrote on June 23 2015, 6:16 PM: »I’ll have to add a new config option whether or not authentication should be used. I’ll try to get you something later when I get home from work.
Sorry for nagging, understand you have alot to do:)
Just want to verify if you have this in your pipeline for a fix soon?
Sincerly
Sorry for the long delay, just learned that the forums were back online. Please try this file out and let me know if it works for you.
Hi eadwyn. Is it possible to change TV episodes so they give better information? For example, Adding “Original Airdate” for the tv episode would be great. Also, can you change S2 E6: Name of Episode to Season 2 Episode 6: Name of Episode? Lastly, is it possible to have your script check TheTVdb.com for “next airdate” and whether the series is in production, cancelled or completed?
Thanks
@eadwyn - first off big thank you for contributing this tool to the Plex community. super cool and i’ve set it up and configured on my Mac Mini Plex Server, serving content and unspeakable family video to my family.
i’ve taken this one as far as i can and wondering if i can get help setting up a cron job to execute the plexEmail.py python script. as you know, when you start a cron job any environment variables and user settings don’t apply. i am able to run the script in terminal by
cd /Applications/PlexEmail-0.6.0/scripts/
python plexEmail.py
if i set up that up as a cron job it reports being unable to import certain modules, which have been installed and set up. the cron job set to run every minute (for testing) looks like
*/1 * * * * * cd /Applications/PlexEmail-0.6.0/scripts/ && python plexEmail.py
so, my question is based in a lack of education in python, is there a way to set an environment or python variable whereby the path gets set to /Applications/PlexEmail-0.6.0/ when it’s run? is that even an environment variable or is there a path import function in Python?
again, thank you for this contribution and in advance for your assistance.
cheers
ben
Hi:
I have a problem, I read this forum and I have this error
Traceback (most recent call last):
File “plexEmail.py”, line 656, in
cur.execute(‘SELECT machine_identifier FROM remote_servers WHERE url LIKE “http://127.0.0.1%”;’)
sqlite3.DatabaseError: file is encrypted or is not a database
In SO --> centos 6.5
the folder /Plexmedai-master is in root,
this folder is same user and groupuser that plexmedia (user is plex)
I execute this command with sudo and without sudo and root.
Can you help me pls?
K.Regards
@freebeer said:
Hi eadwyn. Is it possible to change TV episodes so they give better information? For example, Adding “Original Airdate” for the tv episode would be great. Also, can you change S2 E6: Name of Episode to Season 2 Episode 6: Name of Episode? Lastly, is it possible to have your script check TheTVdb.com for “next airdate” and whether the series is in production, cancelled or completed?Thanks
Right now it is only obtaining data from what Plex has grabbed and stored in the DB and airdate is not part of that. Maybe in the future I can integrate it with another service, but that currently is outside the scope of this script. For the naming, I will try to get that in a future release, but for now you can modify line 996 to change it to what you want.
@itsrainingben said:
eadwyn - first off big thank you for contributing this tool to the Plex community. super cool and i’ve set it up and configured on my Mac Mini Plex Server, serving content and unspeakable family video to my family.i’ve taken this one as far as i can and wondering if i can get help setting up a cron job to execute the plexEmail.py python script. as you know, when you start a cron job any environment variables and user settings don’t apply. i am able to run the script in terminal by
cd /Applications/PlexEmail-0.6.0/scripts/ python plexEmail.pyif i set up that up as a cron job it reports being unable to import certain modules, which have been installed and set up. the cron job set to run every minute (for testing) looks like
*/1 * * * * * cd /Applications/PlexEmail-0.6.0/scripts/ && python plexEmail.pyso, my question is based in a lack of education in python, is there a way to set an environment or python variable whereby the path gets set to /Applications/PlexEmail-0.6.0/ when it’s run? is that even an environment variable or is there a path import function in Python?
again, thank you for this contribution and in advance for your assistance.
cheers
ben
Could you try changing the cron job to /path/to/python/you/want/to/use/python /Applications/PlexEmail-0.6.0/scripts/plexEmail.py and see if that works?
@jcp2015 said:
Hi:I have a problem, I read this forum and I have this error
Traceback (most recent call last):
File “plexEmail.py”, line 656, in
cur.execute(‘SELECT machine_identifier FROM remote_servers WHERE url LIKE “http://127.0.0.1%”;’)
sqlite3.DatabaseError: file is encrypted or is not a databaseIn SO → centos 6.5
the folder /Plexmedai-master is in root,
this folder is same user and groupuser that plexmedia (user is plex)
I execute this command with sudo and without sudo and root.Can you help me pls?
K.Regards
Have you tried following the CentOS install instructions?
https://forums.plex.tv/topic/151619-plexemail-in-development/page-7#entry879778
Hello, I have been running PlexEmail for months now and all of a sudden it has stopped working. I have gone through the forum and have tried all the suggestions and I am still having the same problem. I have a cron job that runs every Friday at 8pm. Ran last week fine (have th email of course). This week nothing came. I was curious and ran the -t command and received this error:
Traceback (most recent call last):
File “plexEmail.py”, line 656, in
cur.execute(‘SELECT machine_identifier FROM remote_servers WHERE url LIKE “http://127.0.0.1%”;’)
sqlite3.OperationalError: unable to open database file
I am using Ubuntu 14.
Python verison is 2.7.6
sqlite3.version = 2.6.0
sqlite3.sqlite_version = 3.8.2
I do all the update when Ubuntu asks me and I have also updated to the latest Plex server (version 0.9.12.8).
Any help is greatly appreciated as I really love this!
Cheers,
-Chris
Just wanted to say this script is awesome! I was able to set it up on my MacMini Plex Server running 10.7.5. I think I only had to install the Python Requests module and any trouble I had was with configuring my settings correctly.
@eadwyn said:
https://forums.plex.tv/topic/151619-plexemail-in-development/page-7#entry879778
Hi:
I follow manual, I go to install all rightly. But in last step I see the same error.
I go to python I import sqlite3
import sqlite3
sqlite3.version
‘2.4.1’
sqlite3.sqlite_version
‘3.6.20’
[root@ns364190 scripts]# export LPATH_BAK=$LD_LIBRARY_PATH ; export PATH_BAK=$PATH &&
export LD_LIBRARY_PATH=/opt/mono/lib:/opt/sqlite3.8.5/lib &&
export PATH=/opt/mono/bin:/opt/sqlite3.8.5/bin:$PATH &&
python2.7 ./plexEmail.py ;
export PATH=$PATH_BAK ; export LD_LIBRARY_PATH=$LPATH_BAK
Traceback (most recent call last):
File “./plexEmail.py”, line 656, in
cur.execute(‘SELECT machine_identifier FROM remote_servers WHERE url LIKE “http://127.0.0.1%”;’)
sqlite3.DatabaseError: file is encrypted or is not a database
Can you say me that I do bad?
K.Regards
any suggestions?
K.Regards
I suggest going over this part of the instructions again and see if that helps.
Prerequisites
Python 2.7 - Windows: 32 bit - https://www.python.org/ftp/python/2.7.9/python-2.7.9.msi
32 bit DLL for SQLite version 3.8.8.3
Windows - http://www.sqlite.org/2015/sqlite-dll-win32-x86-3080803.zip (Put this into the DLLs folder of the Python installation)
Windows 64 bit: If you need 64 bit python, this was just found and works: http://synopse.info/files/SQLite3-64.7z
Mac (Most likely already installed) - http://www.sqlite.org/2015/sqlite-shell-osx-x86-3080803.zip (Put this into the /usr/lib/python2.7 directory - default location)
Requests module for Python. pip install requests or download it here and put it in the LIb folder of your Python installation: https://pypi.python.org/packages/source/r/requests/requests-2.5.3.tar.gz#md5=23bf4fcc89ea8d353eb5353bb4a475b1
@foebik said:
I suggest going over this part of the instructions again and see if that helps.Prerequisites
Python 2.7 - Windows: 32 bit - https://www.python.org/ftp/python/2.7.9/python-2.7.9.msi32 bit DLL for SQLite version 3.8.8.3
Windows - http://www.sqlite.org/2015/sqlite-dll-win32-x86-3080803.zip (Put this into the DLLs folder of the Python installation)Windows 64 bit: If you need 64 bit python, this was just found and works: http://synopse.info/files/SQLite3-64.7z
Mac (Most likely already installed) - http://www.sqlite.org/2015/sqlite-shell-osx-x86-3080803.zip (Put this into the /usr/lib/python2.7 directory - default location)
Requests module for Python. pip install requests or download it here and put it in the LIb folder of your Python installation: https://pypi.python.org/packages/source/r/requests/requests-2.5.3.tar.gz#md5=23bf4fcc89ea8d353eb5353bb4a475b1
Thank you, but I use centos6 and I have in folder python the request…
I will wait
Ok I fixed the issue. Main issue was that I wasn’t running the test command as root. The second problem was that was trying to email was larger than what Google allows.
@nogardvfx said:
Ok I fixed the issue. Main issue was that I wasn’t running the test command as root. The second problem was that was trying to email was larger than what Google allows.
Interesting, how many movies/TV shows did you have that caused it to be so big?
I’m running debian 8, I’m getting this error:
root@xxx:/opt/PlexEmail/scripts# python plexEmail.py
Traceback (most recent call last):
File “plexEmail.py”, line 656, in
cur.execute(‘SELECT machine_identifier FROM remote_servers WHERE url LIKE “http://127.0.0.1%”;’)
sqlite3.OperationalError: locking protocol
what's the solution here?
@foebik said:
Interesting, how many movies/TV shows did you have that caused it to be so big?
Apparently a lot. I always adding new movies. I narrowed it down to the amount of films I have recently added (the attached images are what caused the issue).
-Chris
Is there a setting to show the TV show’s cover art instead of the episode’s thumbnail in the email/website?
I think one really nice feature would be maintenance emails. If I ever need to bring down my server, I would like to send out a maintenance start/end email. Otherwise, great work!
@majora2007 said:
I think one really nice feature would be maintenance emails. If I ever need to bring down my server, I would like to send out a maintenance start/end email. Otherwise, great work!
I agree that this would be nice as I now manually do this myself. But the question is how easy would it be for PlexEmail in its current state? Currently, after initial setup of the config files it is mostly a hands off experience. But for maintenance emails that will decidedly be a more hands on experience. You will most likely need some kind of interface (Web?) to be able to type up your comments about the work being done and what not. Which currently doesn’t exist.
But hey, if the author is up to the challenge I am all about testing it out 
I think it would be a great addition.
