~~I have a similar problem as @elRadix. Mine is:
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~~
Issue was needing 64-bit sqlite3.dll. See previous page for solution.
For everyone on Mac, I got this to run weekly using an app called LaunchControl.
Settings I used in it:
Program to run:
python PlexEmail.py
Working Directory (Depends where your PlexEmail folder is):
/Applications/PlexEmail/scripts
Start Calendar interval (Depends when you want it to run, i chose fridays at 5pm):
Friday 17:00
Then you just have to save it and load the job.
I see this is a few months old at this point but I have a question. Is there anyway to point this to a qnap install of plex? If not is there another way of doing this?
@NeoAoshi said:
I see this is a few months old at this point but I have a question. Is there anyway to point this to a qnap install of plex? If not is there another way of doing this?
I myself have a QNAP running PMS, but unfortunately I haven’t found any instructions on how to get either plexWatch or PlexEmail to run on it. I’ve been able to SSH into the device and find the actual file folders, but that’s only half the battle.
Thanks for this script! I got it working perfectly on Windows Server 2012 R2, however there is one thing I still haven’t been able to sort out. When you click a media title, it’s supposed to redirect to media’s location on my server, but it just says “The server you’re trying to access doesn’t seem to exist.”
I compared the link to my server from the email/website to the address in the webapp, and the server identifier string is different. Is there a place to specify this in the config? I would paste the full links here but I’m not sure if there’s any harm in doing that.
installation question. It says to copy contents of web to web folder. I found web folder here: C:\Windows\Web
Is this the correct location running windows 8?
@quhectic24 said:
installation question. It says to copy contents of web to web folder. I found web folder here: C:\Windows\WebIs this the correct location running windows 8?
If your are not running your own Apache server then ignore that part (and it’s actually a different folder).
The web folder would actually be something like this 'C:\\xampp\\htdocs\\'
You would set this in the config file web_enabled = False and email_use_web_images = False
And use cloudinary for the images instead.
@foebik said:
And use cloudinary for the images instead.
ok so forget the web folder. I cloned the repo, now what?. Sorry for any dumb questions
@quhectic24 said:
ok so forget the web folder. I cloned the repo, now what?. Sorry for any dumb questions
No worries.
Make sure you have all the Prerequisites installed. Some of them you will already have like Python.
Then go into the config file and update it to suite your needs; you’ll have to make a free account on cloudinary too. And yes, clone the repo somewhere simple like C:\Plexemail
To test, just open a cmd promt to the script folder and run the .py file and add this to the end before hitting enter -t. This will let you run a test email that will only go out to yourself.
Most of the other questions I think you will come up with have been asked in this thread (I know its long) so check it out.
Ill check later to see if you got sorted out, wife is yelling at me to go. Good luck.
REQUEST - BCC -
I know it’s been mentioned once or twice, and answers were given on how to prevent need of BCC, but the way I want to use PlexEmail doesn’t match current methods without BCC.
I want to send one email with images attached, to multiple people, without having them see each other.
BCC would allow me to do this.
Without BCC, PlexEmail requires I send multiple emails, and requires some hosting or I end up sending 15 people the same images per email. (waste/use of resources not needed if BCC were used and one email)
Thanks!
First thanks so much for this as its one feature that I have been dying for and jsut happened to stumble upon it after getting my PlexPy installed after moving from PlexNotify > PlexWatchWeb > PlexPy.
So I have some issues currently but I will try and be detailed as possible so that I can try and get this running.
So here is what I am currently Running:
Windows Server 2008 R2 64Bit
PMS 0.9.12.12
Python 2.7.10
WAMP Server (64BIT & PHP 5.5) 2.5
So the first thing that went wrong in step #2 "Windows - 32 bit DLL for SQLite version 3.8.8.3 - http://www.sqlite.org/2015/sqlite-dll-win32-x86-3080803.zip (Put this into the DLLs folder of the Python installation) I took those DLL’s and placed them in my Python folder adn then my PlexPy broke and wouldn’t load up. So I didnt move forward and did some reading in this thread seeing that TNightster tried the following which didnt break my PlexPy
Here was my solution:
I renamed the copy of sqlite3.dll in the Python\DLL’s folder as sqlite3.dll.OLD
I copied the file sqlite3.dll from “C:\Program Files (x86)\Plex\Plex Media Server” and copied it over to “C:\Python27\DLLs”
I also need to know if this was the correct action for step #3 R_**equests 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**_
I took just the “requests” folder from that tar file and placed that folder into the Lib folder as below:
I copied the scripts into C:\PlexEmail\ as shown below:
I then made modifications to my config file and entered in all the Cloudinary fields for API and such. I then made some email entries and saved my file and launched and got the following errors I am hoping someone can help with? Mind you I am a bit tech savvy but coding is certainly not my forte. I am hoping to get this running and making a Dummies Version Install guide for people using Win2008 R2 64Bit and PlexPy as well. Thanks in advance to anyone that can help.
EDIT: 9/29/2015 So after I rebooted my server for the recent PMS update the above changes broke my PlexPy again and I ended up having to revert back changes made in Python with adding the DLL’s and also backing out the “requests” folder in python to bring PlexPy back to life. At this point I dont know if it has to do with what version of Python is running on Windows or not. If anyone is Running Windows Server 2008 R2 64BIT and has this working with PlexPy any help would be greatly appreciated as I really want to use this feature. Thanks in advance.
@JamminR said:
REQUEST - BCC -
I know it’s been mentioned once or twice, and answers were given on how to prevent need of BCC, but the way I want to use PlexEmail doesn’t match current methods without BCC.
I want to send one email with images attached, to multiple people, without having them see each other.
BCC would allow me to do this.
Without BCC, PlexEmail requires I send multiple emails, and requires some hosting or I end up sending 15 people the same images per email. (waste/use of resources not needed if BCC were used and one email)
Thanks!
1+ on this feature as I don’t want everyone seeing everyone either. Thanks.
@rickcab1 - make sure you’re wanting it for the same reason.
There are ways to use this without people seeing each other, but only if you use the multiple individual emails method, and with that, likely better to use cloud host the images so you don’t send all of them repeatedly.
I simply request this because I want one email, and to attach the images myself, not use the cloud to store them.
@JamminR said:
rickcab1 - make sure you’re wanting it for the same reason.
There are ways to use this without people seeing each other, but only if you use the multiple individual emails method, and with that, likely better to use cloud host the images so you don’t send all of them repeatedly.
I simply request this because I want one email, and to attach the images myself, not use the cloud to store them.
Got it! Then it should work the way it is for me. I just don’t want them to see each other in the to: fields. I don’t mind hosting the images. But I will test all for that as soon as I am able to get it all working. Thanks for the insight.
Does anyone using this app have SSL enabled and working for Gmail?
I’ve tried 587 and get a different/protocol unknown error.
email_from = 'myusername@gmail.com'
email_from_name = 'MyName'
email_smtp_address = 'smtp.gmail.com'
email_smtp_port = 465
email_use_ssl = True #Port must be an SSL port i.e. 465
email_username = 'myusername@gmail.com'
email_password = 'my_properly_case_typed_password'
I always get the following error
Traceback (most recent call last):
File "D:\PlexCache\PlexEmail\plexEmail.py", line 1048, in <module>
sendMail(email)
File "D:\PlexCache\PlexEmail\plexEmail.py", line 371, in sendMail
server.login(gmail_user, gmail_pwd)
File "D:\PlexCache\Python\lib\smtplib.py", line 622, in login
raise SMTPAuthenticationError(code, resp)
smtplib.SMTPAuthenticationError: (534, '5.7.14 <https://accounts.google.com/ContinueSignIn?sarp=1&scc=1&plt=AKgnsbsX4
5
.7.14 bayNyvDFg2Ez4VV03Z0-Fo-Tp9GBlaHBlaH5hlcIQ4gDLBUYhn3XJW3
5.7.14 ICgMlMSwd1HtYLwz1nfI1hRSDokNJgLCdVE
xlKIGH_Cjw2ifTGVqbcsOVlbctOoBesT4Xq
5.7.14 zFlF1YjS710jxuxaCV7BlaHBlaHBlaHBlaHIXc1qbYKy5AkqCD9yfgpq2RUEbiEvr
5.7.
14 O6vrz9yzHiZjOolDN8Y0wr8oHv1M> Please log in via your web browser and
5.7.14 then try again.
5.7.14 Learn more at
5.7.14 https://support.google.com/mail/answer/78754 u204sm10947528ywa.17 - gsmtp')I have it running on 465 and it works.
Anyone running Windows 2008 R2 64Bit and PlexPy having the same issues I am in a few posts before this one?
@rickcab1 said:
Anyone running Windows 2008 R2 64Bit and PlexPy having the same issues I am in a few posts before this one?
I dont have that version of Windows, but line 1 that is failing first is for this import sqlite3.
So I think you are still having issues there and would focus on that.
From your previous post it looks like you were using the 32bit version on a 64bit system. Try the 64bit version if you haven’t already 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_
@foebik said:
_Windows 64 bit: If you need 64 bit python, this was just found and works: http://synopse.info/files/SQLite3-64.7z_
Thanks I will give it another shot if I have some time tomorrow. Thanks for chiming in!m If I am successful I will try and simplify it and post results.
@timstephens24 said:
I have it running on 465 and it works.
Thanks. Tinkering another hour or two I finally got an email from Google stating security unknown device blah blah, which had a link that said “Turn off advanced security” or something like that.
Once I did that, started working.
Basically from what I can find, Google wants to use TLS now instead of SSL. I presume turning off that feature in my google account allows the older less secure SSL.
