Been struggling with this for a few days. Got IIS role installed on my server and it seems to be running alright, ( is see the iis homepage) and the sqllite is running fine because it’s checking ever 5 seconds and finding people. But I can’t get the web page to boot up. I tried putting it in root or a subdirectory, and when I try to access:
localhost:7000/plexsentry/index-sqlite.aspx
I just get a 404.3 - Not found, I enabled directory browsing just to figure out if there was a permission issue but in the plexsentry folder I can see all the files. My first thought maybe my DB strings weren’t correct in the js or aspx but seeing as I get a file not found I’m begining to think there is something more I need to do besides “turn on” iis.
@random.server
I am trying to set this up with sqlite but it is very unclear on what to do and where to do them. Is there some other How-to documentation besides your 5 vague lignes in the OP? i opened the *.config file and filled it out but have no idea if im putting the right info or not or what is need to fill out.
Maybe some clearer comments in the config file would help and some actual step by step for those that arent familar with SQL. This addition to plex looks great but with such poor setup instructions very little poeple will want to use it.
Small, mostly behind the scenes updated mentioned in the first post. Testing the library removal method again, now that they’ve updated the IOS app. Also now that I have 6 months of user data, changes will be coming to the UI (charted data) now that I have something worthwhile to work with.
Hmm, Obviously doing something squiffy, all I get is a blank page, view source has code in it but not rendering at all.
Ignore me, did a bit of debugging, forgot to “” my server value! Doh!.. Long day at work I blame! Only issue I have now is the Images for the media objects aren’t loaded, I get 404’s on the media items
http://PlexSentryServer/PlexSentry/PublicPlexServerName/Library/metadata/ItemNumber/thumb?X-Plex-Token=TokenNumber
Any ideas?..
In fact ignore, noticed my mistake… external address needs the http:// and the :32400 on it. All sorted, might nock up a quick HowTo guide for the less initiated.
@mavermc said:
Been struggling with this for a few days. Got IIS role installed on my server and it seems to be running alright, ( is see the iis homepage) and the sqllite is running fine because it’s checking ever 5 seconds and finding people. But I can’t get the web page to boot up. I tried putting it in root or a subdirectory, and when I try to access:
localhost:7000/plexsentry/index-sqlite.aspx
I just get a 404.3 - Not found, I enabled directory browsing just to figure out if there was a permission issue but in the plexsentry folder I can see all the files. My first thought maybe my DB strings weren’t correct in the js or aspx but seeing as I get a file not found I’m begining to think there is something more I need to do besides “turn on” iis.
In IIS Features you need the .net ones setup, could try the following from a cmd
pkgmgr /iu:IIS-WebServerRole;IIS-WebServer;IIS-CommonHttpFeatures;IIS-StaticContent;IIS-DefaultDocument;IIS-DirectoryBrowsing;IIS-HttpErrors;IIS-ApplicationDevelopment;IIS-ASPNET;IIS-NetFxExtensibility;IIS-ISAPIExtensions;IIS-ISAPIFilter;IIS-HealthAndDiagnostics;IIS-HttpLogging;IIS-LoggingLibraries;IIS-RequestMonitor;IIS-Security;IIS-RequestFiltering;IIS-HttpCompressionStatic;IIS-WebServerManagementTools;IIS-ManagementConsole;WAS-WindowsActivationService;WAS-ProcessModel;WAS-NetFxEnvironment;WAS-ConfigurationAPI
(or the equivalent DISM.EXE /enable-feature /online /featureName: subset if on a Windows10/SVR2012r2)
Thanks charlas, which version are you using?
Proper SQL, can’t be faffed with MySql when I have a SQL2014 Active/Active running on the lan 
I’ll whip a guide together, for the MS Sql, one at least
Oh thank god. I hate the SQLite version, I only bothered with it because people kept nagging me about it. What most people don’t realize is that it’s crap in a network drive situation. If you’re using forms auth off a sql backend, I can pass you along the common code I use for that as well.
Could you replace the SQLite version with MySql eventually? I only have WSUS running in SQL and i will be removing in the near future but i also have MySQL for other stuff.
I’ll make you a deal, I’ll look into it if you tell me what the mysql version of the following is (I don’t know, I’ve only used MySql with Kodi\XBMC).
SQLite -:
select max(strftime(’%Y-%m-%d’,playerStart)), min(strftime(’%Y-%m-%d’,playerStart)) from sessions
SQLServer -:
select max(format(playerStart,‘yyyy-MM-dd’)), min(format(playerStart,‘yyyy-MM-dd’)) from sessions
Not quite, by version I meant equivalent.
@random.server said:
Not quite, by version I meant equivalent.
Oh i understand now…sorry i wouldnt know. Yes i do use mysql but i just use it to hold my JMM(Japanese media manager) which i use for anime. I was thinking of moving to SQL express but i think JMM only supports 2008 and i didnt want to have to run 2 sql apps on my machine
I’m only using MySQL for KODI, I used to use it for the centralized DB, but since I moved to the PleXmbc add on, I’m only using that for music. And once I sit down and add recently played music to my branch of Plexmbc (and some other enhancements), I’ll be able to stop using the MySQL completely.
@random.server said:
I’m only using MySQL for KODI, I used to use it for the centralized DB, but since I moved to the PleXmbc add on, I’m only using that for music. And once I sit down and add recently played music to my branch of Plexmbc (and some other enhancements), I’ll be able to stop using the MySQL completely.
Yeah I used to use it also for Kodi but then I moved to emby and then to plex but my music is in emby. I also used plexbmc but the lack of banner support in the current beta is annoying.
@random.server said:
I’ll make you a deal, I’ll look into it if you tell me what the mysql version of the following is (I don’t know, I’ve only used MySql with Kodi\XBMC).
SQLite -:
select max(strftime(‘%Y-%m-%d’,playerStart)), min(strftime(‘%Y-%m-%d’,playerStart)) from sessions
SQLServer -:
select max(format(playerStart,‘yyyy-MM-dd’)), min(format(playerStart,‘yyyy-MM-dd’)) from sessions
I’m not sure how other DBs do it, but in MySQL, formatting inside MAX and MIN will cause the ‘DATE_FORMAT’ method to run on every single row first, then apply the min/max. I assume the “session” table is never huge, so the inefficiency would not be noticed…but oh well.
I would do it like this in MySQL:
SELECT DATE_FORMAT(MAX(playerStart), ‘%Y-%m-%d’), DATE_FORMAT(MIN(playerStart), ‘%Y-%m-%d’) FROM sessions;
@tylerversion2 said:
SELECT DATE_FORMAT(MAX(playerStart), ‘%Y-%m-%d’), DATE_FORMAT(MIN(playerStart), ‘%Y-%m-%d’) FROM sessions;
Huh. Good call, I’ll replace that in all the code.
this looks great
but can anyone help a SQL noob to actually get this working?
All prerequisites are installed, but could someone post a sample .config?
Hi
Installed SQL Express 2014 on Server 2012
Thanks
