PlexEmail - Email Recently Added Media

Dev Community Dev/API Corner
21

after 20min it was delivered fine !!!

Thanks !

one problem is with the email with utf8 characters it is displayed as N#ON7N= ON1N9N=N/N1 B+N'ONN,ON;O ON7

Checking the email through outlook it looks good but thourgh iphone/mobile the layout isnt very nice but the utf8 text are displayed fine

22

Sent you a PM with my email.  Would you mind sending me the email so I can troubleshoot it?

23

after 20min it was delivered fine !!!

Thanks !

one problem is with the email with utf8 characters it is displayed as N#ON7N= ON1N9N=N/N1 B+N'ONN,ON;O ON7

Checking the email through outlook it looks good but thourgh iphone/mobile the layout isnt very nice but the utf8 text are displayed fine

Put in a fix that should address this: https://github.com/jakewaldron/PlexEmail/archive/v0.1.5.zip

24

Release v0.2.0

  • The latest release now support Linux (tested) and Mac (not tested).
  • Added ability to configure sorting for each section
  • Cleaned up code a bit
25

I get the e-mail but didn;t see any images running it on linux

26

I get the e-mail but didn;t see any images running it on linux

Hey, could you give me some more information to help troubleshoot?

Are you using the web portion of the script as well?  If so, are you using the images hosted on your web server or attaching it to the email directly?

Relevant config values:

web_enabled

email_use_web_images

27

Hmm, when I tested in on linux I did have issues with images showing up in gmail (it was due to the gmail image proxy and ssl issues on my server), but it looks like you are sending it from and to your server and the images are showing fine on your server.  Did the images show up when you added them to the headers?

Also, if you want the web portion formatted correctly you will need to put the files in the web folder into plexemail.

If you wouldn't mind, could you send an email using email_use_web_images = True (I'll PM you my email)

28

Cannot get this to work on Linux due to sqlite version mismatches.

Don't want to break python on my system so didn't try much to resolve. Only the very latest versions of Linux have sqlite 3.8.8.3 bundled, Centos 6.6 which I use only has sqlite 3.6.20.

I see Plex keeps their own version of Python in the /usr/lib/plexmediaserver/Resources folder. Any idea how to use this version to run the script?

29

I send you the email

30

hey eadwyn is it possible if you have many emails to be sent individual and not as cc to all ?

thanks

31

Just to explain my previous issue.

Here is trying to access plugins.db with bundled sqlite3:

[root@vulcan scripts]# sqlite3 /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
Error: file is encrypted or is not a database
sqlite> .quit
 

Here is with latest downloaded binary:

[root@vulcan scripts]# sqlite3.8.8.3 /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db
SQLite version 3.8.8.3 2015-02-25 13:29:11
Enter ".help" for usage hints.
sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /var/lib/plexmediaserver/Library/Application Support/Plex 
sqlite> .quit

I'll take a look at the code during the week and see if I can rather interface with the XML API instead of connecting directly to the db.

32

I send you the email

Thanks. Do you have the following values configured in the config file:

web_domain

web_path

33

Just to explain my previous issue.

Here is trying to access plugins.db with bundled sqlite3:

[root@vulcan scripts]# sqlite3 /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
Error: file is encrypted or is not a database
sqlite> .quit
 

Here is with latest downloaded binary:

[root@vulcan scripts]# sqlite3.8.8.3 /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db
SQLite version 3.8.8.3 2015-02-25 13:29:11
Enter ".help" for usage hints.
sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /var/lib/plexmediaserver/Library/Application Support/Plex 
sqlite> .quit

I'll take a look at the code during the week and see if I can rather interface with the XML API instead of connecting directly to the db.

Taking a look now to see an easy way to use an alternative version of python without messing up the default version.  Testing it now with make altinstall and virtualenv

34

Taking a look now to see an easy way to use an alternative version of python without messing up the default version.  Testing it now with make altinstall and virtualenv

Thanks appreciate it. I'm sure many people that run Linux servers will run into this same problem.

35

Thanks appreciate it. I'm sure many people that run Linux servers will run into this same problem.

Could you also give me your current version of python: 

python -V

And version of the python sqlite: 

python
import sqlite3
sqlite3.version
sqlite3.sqlite_version

Thanks!

36

Could you also give me your current version of python: 

python -V

And version of the python sqlite: 

python
import sqlite3
sqlite3.version
sqlite3.sqlite_version

Thanks!

Here you go:

[root@vulcan ~]# python --version
Python 2.6.6
[root@vulcan ~]# python
Python 2.6.6 (r266:84292, Jan 22 2014, 09:37:14) 
[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.version
'2.4.1'
>>> sqlite3.sqlite_version
'3.6.20'
37

drzoidberg33: Could you try the following:

Install virtualenv if you don't have it:

sudo pip install virtualenv

Then download and altinstall python 2.7.9:

cd ~/downloads
wget https://www.python.org/ftp/python/2.7.9/Python-2.7.9.tgz
tar -xvf Python-2.7.9.tgz
cd Python-2.7.9
./configure
make
sudo make altinstall

Then make a new virtualenv:

cd ~/plexemail/scripts (or wherever your scripts folder is for plexemail)
sudo virtualenv --python=/usr/local/bin/python2.7 pevenv

Lastly try running the script again:

pevenv/bin/python ./plexEmail.py
38

I send you the email

I think I figured it out.  Could you add http:// to the start of web_domain?

39

hey eadwyn is it possible if you have many emails to be sent individual and not as cc to all ?

thanks

Hey, there is a new config value in the latest release: https://github.com/jakewaldron/PlexEmail/archive/v0.2.4.zip

email_individually

40

didn't see that ... amazing !! thanks!!