@jskala said:
@xxrazorxx said:
I’m using sql express as well. Thanks!Here is what I am using fill in the values for you. IE server, username, and password.
“Data Source=SERVER\SQLEXPRESS;Initial Catalog=PlexSentry;Persist Security Info=True;User ID=USERNAME;Password=PASSWORD”;
Which file did you place this connection string in?
@xxrazorxx said:
@jskala said:
@xxrazorxx said:
I’m using sql express as well. Thanks!Here is what I am using fill in the values for you. IE server, username, and password.
“Data Source=SERVER\SQLEXPRESS;Initial Catalog=PlexSentry;Persist Security Info=True;User ID=USERNAME;Password=PASSWORD”;Which file did you place this connection string in?
That is in database.plex.aspx
I also have one in plexsentry.exe.config that looks like so
Data Source=SERVER\SQLExpress;Initial Catalog=PlexSentry;Integrated Security=True;"
Does this go into this line?
sqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings[“PlexSentry”].ConnectionString;
@xxrazorxx said:
Does this go into this line?sqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings[“PlexSentry”].ConnectionString;
yes so the whole line is
sqlConnection.ConnectionString = “Data Source=SERVERNAME\SQLEXPRESS;Initial Catalog=PlexSentry;Persist Security Info=True;User ID=USERNAME;Password=PASSWORD”;
@random.server said:
Can you explain what the Min- Video and Min - Audio is for?
Alright! After getting my connection string correct, it seems the orphan issue is gone. I now have the ui appearing correctly. One note, I had to make my connection string like the following
sqlConnection.ConnectionString = @’“Data Source=SERVERNAME\SQLEXPRESS;Initial Catalog=PlexSentry;Persist Security Info=True;User ID=USERNAME;Password=PASSWORD’”;
Without the @ symbol, I was getting an escape error due to the backslash. Also I had to add another user to SQL Express with mixed security enabled to get it to connect. Otherwise I received an error with the user password being wrong.
Thanks!
@xxrazorxx said:
Alright! After getting my connection string correct, it seems the orphan issue is gone. I now have the ui appearing correctly. One note, I had to make my connection string like the followingsqlConnection.ConnectionString = @“Data Source=SERVERNAME\SQLEXPRESS;Initial Catalog=PlexSentry;Persist Security Info=True;User ID=USERNAME;Password=PASSWORD”;
Without the @ symbol, I was getting an escape error due to the backslash. Also I had to add another user to SQL Express with mixed security enabled to get it to connect. Otherwise I received an error with the user password being wrong.
Thanks!
I had a hard time getting my string to work. Think I went through 6 variations. Glad you got it to work.
You two have been busy!
sqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings[“PlexSentry”].ConnectionString;
When I set mine up, I set it up directly in IIS with the name “PlexSentry”; Server=.\sql2014;Database=PlexSentry;Integrated Security=true
@random.server said:
You two have been busy!
Can you explain the min-video and min-audio values and what they do?
@jskala said:
@random.server said:
You two have been busy!Can you explain the min-video and min-audio values and what they do?
It’s for syncs, minimum audio/video quality. It’ll prevent your shared users from transcoding during syncs as well.
@random.server said:
@jskala said:
@random.server said:
You two have been busy!Can you explain the min-video and min-audio values and what they do?
It’s for syncs, minimum audio/video quality. It’ll prevent your shared users from transcoding during syncs as well.
Thank you for that. Do you have the logging version yet? I have androids being killed and chrome clients for reasons I can’t understand. I have all options checked for the users and prior they didn’t have issues. and Really now way to get to the bottom of why.
I’m still getting the same issues as well. Oddly enough, the samsung tv plex app world without being killed as an orphan.
@xxrazorxx said:
I’m still getting the same issues as well. Oddly enough, the samsung tv plex app world without being killed as an orphan.
Only thing I can get working is my local chrome client … Everything else is killed quickly.
Decided to give this a try (all kinda new to me)
Edited the PlexSentry (SQLite).exe config like this
“PlexSentryDB” value=“Data Source=D:\PlexSentry\PlexSentry (SQLite)\PlexSentry-sqllite.db;Version=3;Timeout=100;journal_mode=WAL;” />
Now the server name value should that be the local ip?
I’ve also edited these lines in script-Plex-common:
var server_address_external = “http://externalip:32400”//external address of server
var server_address_internal = “http://internalip”//external address of server
var server_address_internal_port = “32400”//external address of server
var tokenKey = “plextoken”;
var server_id = “name of server”;
var user_name = “plex username”;
var user_password = “plex password”;
In the cmd window is see this:
Program has started, loading configuration Retrieving authorization token from plex.tv Retrieving server info from local server Retrieving stored server info from database Accessing server variables from database Updating database with local server info Updating shared users list from plex.tv to database Updating shared users list from plex.tv to database 2015-12-14 21:07:35- Starting timer to check status at a interval of 5 seconds Accessing user list from database Checking for currently connected clients Connected clients-: 0 Checking for currently playing sessions Current sessions-: 1 Checking for previous sessions Previous Sessions -: 1
Not seeing any connected users & wondering if anyone can spot the error i’ve made?
Thanks for looking.
@lorrebreaker said:
Decided to give this a try (all kinda new to me)
Edited the PlexSentry (SQLite).exe config like this“PlexSentryDB” value=“Data Source=D:\PlexSentry\PlexSentry (SQLite)\PlexSentry-sqllite.db;Version=3;Timeout=100;journal_mode=WAL;” />
Now the server name value should that be the local ip?
I’ve also edited these lines in script-Plex-common:
var server_address_external = “http://externalip:32400”//external address of server
var server_address_internal = “http://internalip”//external address of server
var server_address_internal_port = “32400”//external address of servervar tokenKey = “plextoken”;
var server_id = “name of server”;
var user_name = “plex username”;
var user_password = “plex password”;In the cmd window is see this:
Program has started, loading configuration Retrieving authorization token from plex.tv Retrieving server info from local server Retrieving stored server info from database Accessing server variables from database Updating database with local server info Updating shared users list from plex.tv to database Updating shared users list from plex.tv to database 2015-12-14 21:07:35- Starting timer to check status at a interval of 5 seconds Accessing user list from database Checking for currently connected clients Connected clients-: 0 Checking for currently playing sessions Current sessions-: 1 Checking for previous sessions Previous Sessions -: 1Not seeing any connected users & wondering if anyone can spot the error i’ve made?
Thanks for looking.
What does your Plexsentry.exe.config file look like. That is important.
In my script-plex-common.js I have this
var tokenKey = “”;
var server_id = “”;
var user_name = “”;
var user_password = “”;
Because those values are in the Plexsentry.exe.config.
@jskala said:
What does your Plexsentry.exe.config file look like. That is important.
In my script-plex-common.js I have this
var tokenKey = “”;
var server_id = “”;
var user_name = “”;
var user_password = “”;
Because those values are in the Plexsentry.exe.config.
Thanks jskala
These are my settings
I have now removed the ones from script-plex-common.js
<appSettings> <add key="PlexSentryDB" value="Data Source=D:\PlexSentry\PlexSentry (SQLite)\PlexSentry-sqllite.db;Version=3;Timeout=100;journal_mode=WAL;" /> <!-- SQL connection string --> <add key="masterName" value="plexusername" /> <!-- Owner User ID --> <add key="masterEmail" value="mygmail@gmail.com" /> <!-- Owner EMail --> <add key="masterPassword" value="plexpassword" /> <!-- Owner Password --> <add key="serverName" value="http://192.168.0.4" /> <!-- Plex Server Domain Name or IP --> <add key="serverPort" value="32400" /> <!-- Plex Server Port -->
@lorrebreaker said:
@jskala said:
What does your Plexsentry.exe.config file look like. That is important.
In my script-plex-common.js I have this
var tokenKey = “”;
var server_id = “”;
var user_name = “”;var user_password = “”;
Because those values are in the Plexsentry.exe.config.
Thanks jskala
These are my settings
I have now removed the ones from script-plex-common.js
<appSettings> <add key="PlexSentryDB" value="Data Source=D:\PlexSentry\PlexSentry (SQLite)\PlexSentry-sqllite.db;Version=3;Timeout=100;journal_mode=WAL;" /> <!-- SQL connection string --> <add key="masterName" value="plexusername" /> <!-- Owner User ID --> <add key="masterEmail" value="mygmail@gmail.com" /> <!-- Owner EMail --> <add key="masterPassword" value="plexpassword" /> <!-- Owner Password --> <add key="serverName" value="http://192.168.0.4" /> <!-- Plex Server Domain Name or IP --> <add key="serverPort" value="32400" /> <!-- Plex Server Port -->
I don’t have http in the servername field just my local ip 192.168.2.30
The rest of this appears ok. what happens if you get rid of http and run the command.
@jskala said:
I don’t have http in the servername field just my local ip 192.168.2.30
The rest of this appears ok. what happens if you get rid of http and run the command.
Thanks for taking the time to look at this
Same message, 2 current sessions but no users connected (can see them conected in now playing via plex)
@lorrebreaker said:
@jskala said:
I don’t have http in the servername field just my local ip 192.168.2.30
The rest of this appears ok. what happens if you get rid of http and run the command.Thanks for taking the time to look at this
Same message, 2 current sessions but no users connected (can see them conected in now playing via plex)
So when you run plexsentry.exe you see the command window running and scrolling.? I am assuming your issue is related to the web interface? If that is the case what does the screen look like? Do you just see it with no data? if so and you are using chrome hit F12 will give you the dev console then click network and you can refresh and see what is giving you issues.
