Yes, this version requires a windows box, but that box can be remote of the plex install.
Required
-IIS Server
-C# Compiler
-SQL Server
Install Steps
-Fill in the variables at the top of program.cs
Use the command list in 'SQL Creation Commands.txt' to build your database
-Compile and run from any computer with network access
-fill in the external server variable in script.plexmonitor.js
Just asking... Why install a full sql server as opposed to using sqlite for the database access?
Honestly because in my environment sqllite is more of a hassle than SQL Server that I already have. i know it's not ideal, but there are lightweight versions of SQL Server
I would gladly see a version for linux (debian/ubuntu), would that be possible?
I am already running plexwatch/web on a linux small server box (synology).
Natively? I doubt it. You probably could run the lite version (since that's all you need since you use plexwatch) in Wine
Honestly because in my environment sqllite is more of a hassle than SQL Server that I already have. i know it's not ideal, but there are lightweight versions of SQL Server
OK... I'll bite then...
I installed xampp for my sql server and in 'following' your install instructions, I am stuck on the portion relating to creating my database... "Use the command list in 'SQL Creation Commands.txt' to build your database"...
OK... I'll bite then...
I installed xampp for my sql server and in 'following' your install instructions, I am stuck on the portion relating to creating my database... "Use the command list in 'SQL Creation Commands.txt' to build your database"...
MySQL is not the same thing as MS SQL, which I believe is what the OP is requiring for this to work,
OK... I'll bite then...
I installed xampp for my sql server and in 'following' your install instructions, I am stuck on the portion relating to creating my database... "Use the command list in 'SQL Creation Commands.txt' to build your database"...
OP mistakenly left this out of the most recently posted build..
Here it is.
create database PlexMonitor; go use PlexMonitor;create table sessions
(
uniqueID varchar(50) not null primary key,
mediaTitleShow varchar(max) null,
mediaTitle varchar(max) not null,
mediaType varchar(max) not null,
mediaID INTEGER not NULL,
mediaSession INTEGER not NULL,
mediaYear INTEGER not NULL,
mediaTimeLength INTEGER not NULL,
mediaTimeStart INTEGER not NULL,
mediaTimeCurrent INTEGER not NULL,
mediaTimeWatched as mediaTimeCurrent - mediaTimeStart,
mediaSize INTEGER not NULL,
mediaBitrate INTEGER not NULL,
userID INTEGER not NULL,
userName varchar(max) not null,
playerID varchar(max) not null,
playerPlatform varchar(max) not null,
playerProduct varchar(max) not null,
playerTitle varchar(max) not null,
playerLocation varchar(max) not null,
playerState varchar(max) not null,
transcodeID varchar(max) null,
transcodeVideo varchar(max) null,
transcodeAudio varchar(max) null,
playerStart datetime not null,
playerEnd datetime null,
streamCount integer default 1 not null,
killStatus integer default 0 not null,
mediaIDSeason integer default 0 null,
mediaSeason integer default 0 null,
mediaEpisode integer default 0 null,
mediaCodec varChar(50) not null
);create table users
(
id integer not null primary key,
name varchar(max) not null,
email varchar(max) not null,
canTranscode bit not null default 0,
canTranscodeSecondary bit not null default 0,
streamLimit INTEGER not null default 1,
dateStart date not null,
notifyStart bit not null default 1,
notifyEnd bit not null default 1,
notifySync bit not null default 1,
);create table serverData
(
serverID varchar(100) not null primary key,
serverToken varchar(100) not null,
userName varchar(max) not null,
userPassword varchar(max) not null,
serverName varchar(max) not null,
serverPlatform varchar(max) not null,
serverProduct varchar(max) not null,
serverVersion varchar(max) not null,
serverLocation varchar(max) not null,
serverPort integer not null,
notifyStart bit not null default 1,
notifyEnd bit not null default 1,
notifySync bit not null default 1
);
Hmmm... This is starting to be a bit over my head...
In attempting to create the DB in phpmyadmin by simply 'cutting and pasting' the command sets into the query portion, I get an error.
Is there (Don't everyone jump in and say how easy it is...), a 'better' way to create the database using phpmyadmin?
Never used phpmyadmin. What error are you getting?
Never used phpmyadmin. What error are you getting?
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'max) null,
mediaTitle varchar(max) not null,
mediaType varchar(max) not nu' at line 4
I believe I can import into the DB via a variety of methods (SQL, CSV, Open DOcument, XML, etc)...
Anyone care to simply attach their DB and I can try to import?
I could maybe tonight..
Why not just install SQL Server express? That's what I'm using..
I may give installing this in my windows 7 virtual machine a shot this weekend. Development is going fairly quick on this :)
Jarkle, thanks for your help, I've been stuck on another project.
I'm about to publish sync monitoring, wondering if anyone cares about applying limits to the number of audio and photo syncs?
I'm about to publish sync monitoring, wondering if anyone cares about applying limits to the number of audio and photo syncs?
I'm not sure I would ever care about Photo syncing, but audio I might.
I was just covering my bases, but it seems like having a separate limit would per audio video would be best.
For those that are following, I have a new version coming out this week that adds the ability to log and apply limits (minimum quality, # of items for video or audio) to Syncs, as well as avoiding run time errors when plex.tv goes down. If anyone has any suggestions, now would be the time to put them out there while I hone the UI.
For those of us on limited upload rates, were you ever able to figure out how to force certain transcodes settings?
