plexSentry (20160511 Update)

Could not load file or assembly 'System.Data.SQLite.DLL' or one of its dependencies. The specified module could not be found.
 

Looks like i have some problem with IIS x86 or x64bit sqllite. Running this on Win2012r2. What is the version of sqlite provided from you?

If i set appool to "enable 32bit" i get the following extra msg:

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Glennois, did you make sure you installed the VS 2012 x64 redistributal?

Glennois, did you make sure you installed the VS 2012 x64 redistributal?

Yup, even tried the 2010 x86 and x64, and multiple reboots etc.

Ah, you know what? If you're not running this as a root site, but as a subfolder, you'll need to move the contents of the bin folder (the SQLite dlls) to a bin folder at the root folder level. I ran into this issue as well

\root (web site)\bin

\root (web site)\plexsentry

or

\root (plexsentry)\bin

\root (plexsentry)\

random.server: Are you still developing this? I don't know if you saw my post but i cannot get your latest version to work. Only the original one "works".

I really want to start using this for real but the version that works has your users in the sqlite database and i'd rather not use that one.

Yes still developing. Are you getting any type of error message? Are you using the same configuration from the version that worked?

Yes i am using the same configuration file as before and i was sure i modified it but looks like i missed the database filename.

I feel so stupid now...I will try again

How did it work out? I've added some UI features, but it's not worth updating at the moment. I've been running the SQL build with no crashes for the past couple of weeks.

I have to wait until server is empty before i run it because by default the program kicks people out that are transcoding. Once they are off i will run it and configure these users to have transcoding rights.

Would be nice if by default everything is allowed and then someone can run it without the fear of booting people out when you really didn't want to.

Feature suggestion would also be to allow customization of the email sent to users when they are breaking the rules...

That’s an issue with the SQLite database, not Sql server. I looked at it for a moment, but to be honest I don’t care about the SQLite version at all, it’s a courtesy for the forum.

Will this run on a separate VM? as i have my main server running Ubuntu. Seems like it will check all the boxes for what I want! 

That's an issue with the SQLite database, not Sql server. I looked at it for a moment, but to be honest I don't care about the SQLite version at all, it's a courtesy for the forum.

Man i am truly staring to feel dumb... When i first saw you needed MS SQL Server instead of MySQL, i was taken aback because not many home users have that installed due to the prohibitive cost but i just clicked that your app probably works with SQL Server Express... That i wouldn't mind installing... Am i right in saying SQL Server Express is supported?

Man i am truly staring to feel dumb... When i first saw you needed MS SQL Server instead of MySQL, i was taken aback because not many home users have that installed due to the prohibitive cost but i just clicked that your app probably works with SQL Server Express... That i wouldn't mind installing... Am i right in saying SQL Server Express is supported?

Yes, it'll work, but to be honest, i use SQL because of other projects, so that works for me. I'd stick to SQLite, except for that one issue, it has code parity with the SQL version (unless you'd also like to use a calibre site I set up). If i actually had a reason to use php for another project, I'd code that and eliminate the php requirement. It's more likely that i'd code a self hosted c# then that.

Will this run on a separate VM? as i have my main server running Ubuntu. Seems like it will check all the boxes for what I want! 

Yes, as long as it can access the server over the network it's good to go.

OK i installed SQL Server Express and i have the backend running fine but i don't know where to put my connection string in database.plex.aspx

My connection string is Data Source=CNS-MOVIESERVER\SQLEXPRESS;Initial Catalog=PlexSentry; Integrated Security=SSPI;

I can't use SQlite because that small issue of kicking everyone off until i give them rights is a showstopper for me.

You can add it in one of two places, replace the variable declaration with your string (everything right of equal)

sqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings[“PlexSentry”].ConnectionString;

Or add a connection string in IIS named PlexSentry. Holy ■■■■, I needed better directions.

Holy ####, I needed better directions.

Tell me about it ;)

I tried this in the aspx:

sqlConnection.ConnectionString = "Data Source=CNS-MOVIESERVER\SQLEXPRESS;Initial Catalog=PlexSentry; Integrated Security=SSPI;"

That didn't work

I created a connection string called PlexSentry in IIS with a custom string:

Data Source=CNS-MOVIESERVER\SQLEXPRESS;Initial Catalog=PlexSentry; Integrated Security=SSPI;

That didn't work (Yes i put the aspx back to it's original)

I also tried the IIS connection string:

Server=.\SQLEXPRESS;Database=PlexSentry;Integrated Security=true

or

Server=CNS-MOVIESERVER\SQLEXPRESS;Database=PlexSentry;Integrated Security=true

And still no luck... I get 5 "Query has failed" errors

Are you making sure the name of the connection string is PlexSentry?

In your web.config, you'll have something like this

   
      Server=.\SQLEXPRESS;Database=PlexSentry;Integrated Security=true" name="PlexSentry" />
   

Hi

Can anyone make this working in linux?

Hi

Can anyone make this working in linux?

You can run the backend on any computer with a windows os that has network access to your Plex box. The frontend would require Mono