Can anyone point me in the direction of where to download PlexSentry?
@wyseguy79 said:
Can anyone point me in the direction of where to download PlexSentry?
The download link is a zipped file at the bottom of the first post in this thread
Hoping this thread is still monitored.
Followed @charlas great installation instructions and was able to get my DB set up, the application running (I can tell because the DB is logging entries), and was able to get the webpage to load.
However, the webpage is blank, except for the header info (Users, Media History, Sync History, etc) and does not display any information.
I assume it isn’t pulling data correctly from the DB.
Anyone able to assist?
Thanks!
@alternativesurfer did you modify the variables in the Javascript file. Plexsentry is still alive, it’s just a project from my job has stolen all my free time
@random.server
Hi!
Glad to hear it, and I completely understand on the job front. Love the premise of this tool as I have a rather large group of friends who utilize my Plex server.
To answer your question, I assume you mean edited the script-Plex-common.js file?
I have edited the first 3 lines, to be:
var server_address_external = "http://MYPUBLICIP:32400" //external address (and port) of server var server_address_internal = "http://MYINTERNALIP" //internal address of server var server_address_internal_port = "32400" //internal port of server
Is this what I needed to edit?
(I am secretly hoping you say “no” and that I missed something else simple.
@alternativesurfer that looks right, did you make a connection string in iis to your db?
Pretty sure I did.
This is what my connection string looks like.
@alternativesurfer Huh. I’ve never seen a connection to the file like that, i thought it be something like, Server=.\sqlexpress2012;Database=PlexSentry;Integrated Security=true
Tried using your suggestion, and the one in this link: https://forums.plex.tv/discussion/156041/plexsentry-20151218-update/p15 but still no luck…
I tried but could not get the UI to work. back end was working and placing data into the DB.
Has anyone been able to get Plex Sentry to work on their server when requiring secure connections? It works if I have it set to preferred, but as soon as I change it to be required it doesn’t retrieve any data.
@iratepirate that’s a good question, let me check the code and see if I can fix that (I’m guessing there’s a flag that’ll tell me the user choice).
@iratepirate got that fix in for you
Awesome. Thanks @random.server I’ll test it out and let you know how it goes.
@iratepirate No, thank you. I switched over to “Required” secured from “Preferred” because of your request
@alternativesurfer I have exactly the same issue, were you able to fix it?
@alternativesurfer said:
Tried using your suggestion, and the one in this link: https://forums.plex.tv/discussion/156041/plexsentry-20151218-update/p15 but still no luck…
@make77 PM me your config file with the passwords cleared out and the top of the common js file
2 weeks of trying to set this up, and unable to get it working. there was a quick guide on page 9 in this thread i liked, explaining how to setup everything a little bit. which was quite helpful.
windows 10 professional
Installed default configuration of IIS, but not IIS hostable web core; nothing here said i need that.
Installed SQLExpress 2014 64 bit and sql 2014 management studio
ISS loads its splash page @ http://localhost
Database manager i have built the PlexSentry database using the included file for building the database.
I edited the config file with my plex info, and the js plex file with the ip address of my plex server.
i have 2 database connection strings listed under the website connection settings:
data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true
Data Source=localhost;Initial Catalog=PlexSentry;Integrated Security=SSPI;
The first one is LocalSQLServer, the 2nd one is PlexSentry are they correct?
loading plexsentry.exe from administrator command prompt kicks out errors and crashes. attached image.
Thanks for any additional assistance.
Okay, got the application working on my setup with help from @random.server Thanks!
Some changes that needed to be made, where the connection string i was using was incorrect.
i used: Data Source=localhost;Initial Catalog=PlexSentry;Integrated Security=SSPI from an example, but it should have been: Server=.\SQLExpress;Initial Catalog=PlexSentry;Integrated Security=SSPI;
that reflects a change due to my use of sqlexpress.
Another change that was made was to have PlexSentry user fixed as a login name for the database. @random.server did that, and i don’t know all the steps to describe what he did there. but the changes where made from the database file system.
additionally, some other items that where issues where things like the external url type, and changes to that where made in the js file for plex settings, same file mentioned in the tutorial spot on page 9 i believe.
After all that, there where some URL issues with accessing plex xml files, such as sessions. what google dev mode shows for me is this: http://externalurl.com/externalurl.com:32400/status/sessions/?X-Plex-Token=plextokenstringofcharacters
the link is written as externalurl.com:32400/status/sessions/?X-Plex-Token=plextokenstringofcharacters in the code, but the url is wrong, because it includes a double url in the actual follow link.
The 2nd link with the plex port its pulling is from the external url entered from the js file script-plex-common.js
so, any idea on how to correct that?
Quick FYI for those of you that were getting blank web UI’s (only headers showing); using chrome and F12 showed that there was a problem with IIS connecting to database.plex.aspx due to no access in SQL for the default app pool… i ran the following SQL query and everything started working…
CREATE LOGIN [IIS APPPOOL\DefaultAppPool] FROM WINDOWS
GO
–USE Table Name
GO
CREATE USER [IIS APPPOOL\DefaultAppPool] FOR LOGIN [IIS APPPOOL\DefaultAppPool]
GO
EXEC sp_addrolemember ‘db_datareader’, ‘IIS APPPOOL\DefaultAppPool’
GO
EXEC sp_addrolemember ‘db_datawriter’, ‘IIS APPPOOL\DefaultAppPool’
GO
