Plex Notify

Dev Community Dev/API Corner
201

http://webvaultwiki.com.au/(S(iungfwenvz2f5c55pioeinil))/Default.aspx?Page=Create-Mysql-Database-User-Workbench&NS=&AspxAutoDetectCookieSupport=1

I found this. Create your database, input your connection string in Plex Notify http://www.connectionstrings.com/mysql/ and you should be all set. to test just start watching a show and if you get a notification it works.

ok, almost there, how do I reset to REALLY default PlexNotify settings (I used the go to previous state in add/remove programs once, made a mistake in string but now I never find a way to do a real uninstall, it always remember the settings)

Now it just crash on open 

log:

 
 
    Unable to connect to any of the specified MySQL hosts.
      at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PlexNotify.Databases.MySqlDB.Connect()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   at PlexNotify.DatabaseInterface.SetupDatabase()
   at PlexNotify.MainWindow..ctor()
   
   
 
202

ok, almost there, how do I reset to default PlexNotify settings (I used the go to previous state in add/remove programs once, made a mistake in string but now I never find a way to do a real uninstall, it always remember the settings)

Now it just crash on open 

log:

 
 
    Unable to connect to any of the specified MySQL hosts.
      at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PlexNotify.Databases.MySqlDB.Connect()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   at PlexNotify.DatabaseInterface.SetupDatabase()
   at PlexNotify.MainWindow..ctor()
   
   
 

oh it crashes on open thats a bug I have to fix that. In the meantime, you need to hunt your configuration file down again and change the setting in there. It seems you got your connection string wrong. 

203

ok, almost there, how do I reset to REALLY default PlexNotify settings (I used the go to previous state in add/remove programs once, made a mistake in string but now I never find a way to do a real uninstall, it always remember the settings)

Now it just crash on open 

log:

 
 
    Unable to connect to any of the specified MySQL hosts.
      at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PlexNotify.Databases.MySqlDB.Connect()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   at PlexNotify.DatabaseInterface.SetupDatabase()
   at PlexNotify.MainWindow..ctor()
   
   
 

your connection string should be something like:

Server=myServerAddress\myDataBase;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

so if your IP address is 127.0.0.1 and the database you created was plexnotify then your connection string will look something like this

Server=127.0.0.1\plexnotify;Database=plexnotify;Uid=myUsername;Pwd=myPassword;

alternatively 

Server=127.0.0.1;Database=plexnotify;Uid=myUsername;Pwd=myPassword;
204

oh it crashes on open thats a bug I have to fix that. In the meantime, you need to hunt your configuration file down again and change the setting in there. It seems you got your connection string wrong. 

ok, I'm getting close.

I think I'm connected on my MySQL but I can't enter the PMS information

logs

 
 
    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 '[Transcode_Id], [state] FROM [PNMonitoring] WHERE [PN_ID] = '26d5b166-f63f-4296-' at line 1
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   
   
 
 
I checked the database, no table, etc...
205

BTW, to make it work the string is now:

Server=192.168.1.10;Database=PlexNotify;Uid=sa;Pwd=plex;

Based on the SQL user I made.

206

To help, here is the logs with all MySQL related errors

https://dl.dropboxusercontent.com/u/5118921/Logs/PlexNotify.log.xml

207

ok, I'm getting close.

I think I'm connected on my MySQL but I can't enter the PMS information

logs

 
 
    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 '[Transcode_Id], [state] FROM [PNMonitoring] WHERE [PN_ID] = '26d5b166-f63f-4296-' at line 1
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   
   
 

Thats odd it does not like the SQL im only using basic TSQL commands as to make it as generic as possible, select insert and update statements and its giving an error. Makes me think the tables where not created. can you send me the whole log file, also go back into you MySql Workbench and verify that there are tables in the database you created. The database should match up to https://plexnotify.codeplex.com/wikipage?title=Database&referringTitle=Documentation

208

ok, I'm getting close.

I think I'm connected on my MySQL but I can't enter the PMS information

logs

 
 
    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 '[Transcode_Id], [state] FROM [PNMonitoring] WHERE [PN_ID] = '26d5b166-f63f-4296-' at line 1
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   
   
 

Thats odd it does not like the SQL im only using basic TSQL commands as to make it as generic as possible, select insert and update statements and its giving an error. Makes me think the tables where not created. can you send me the whole log file, also go back into you MySql Workbench and verify that there are tables in the database you created. The database should match up to https://plexnotify.codeplex.com/wikipage?title=Database&referringTitle=Documentation

209

Thats odd it does not like the SQL im only using basic TSQL commands as to make it as generic as possible, select insert and update statements and its giving an error. Makes me think the tables where not created. can you send me the whole log file, also go back into you MySql Workbench and verify that there are tables in the database you created. The database should match up to https://plexnotify.codeplex.com/wikipage?title=Database&referringTitle=Documentation

https://dl.dropboxusercontent.com/u/5118921/Logs/PlexNotify.log.xml

210

Ok I found the problem, MySql cannot deal with square brakets. I will put out an update. 

211

Ok I found the problem, MySql cannot deal with square brakets. I will put out an update. 

NICE!

I think this will be awesome (centralized database, etc...)

thanks, I'll let you know.

BTW, as a tip for others, to find the config file, etc..., best way is to open the process plexnotify.exe location from task manager while it runs

212

Just wanted to chip in and say excellent work, this project is exactly what I (and I'm sure many more) users have needed.

A little bit of feedback from my recent experiences, I'm running Windows 8.1 Pro (64bit) and The notify app seems to have created a dual instance in my notification centre (one blank icon) and the standard icon.  PlexNotify also seems to crash out after I configured Grown and Prowl to push the notifications to my iphone, everytime I start a movie or show the notify and growl apps kick in and tell me but the app auto crashes.

Keep up the good work

:-)

213

Just wanted to chip in and say excellent work, this project is exactly what I (and I'm sure many more) users have needed.

A little bit of feedback from my recent experiences, I'm running Windows 8.1 Pro (64bit) and The notify app seems to have created a dual instance in my notification centre (one blank icon) and the standard icon. PlexNotify also seems to crash out after I configured Grown and Prowl to push the notifications to my iphone, everytime I start a movie or show the notify and growl apps kick in and tell me but the app auto crashes.

Keep up the good work

:-)


Thanks for the positive feedback. I will definitely look into the crashes. Can you send me your log files?

Sent from my SM-N900P using Tapatalk
214

Thanks, I have linked the log file, I was attempting to uninstall then reinstall but after uninstalling from control pannel the app is still there!

http://www.wezsweb.com/web-clipart/PlexNotify.txt

215

Thanks, I have linked the log file, I was attempting to uninstall then reinstall but after uninstalling from control pannel the app is still there!

http://www.wezsweb.com/web-clipart/PlexNotify.txt


What version of Plex Notify are you running?

Sent from my SM-N900P using Tapatalk
216

I did update to the latest around a hour ago but where would it tell me, I must be missing the obvious but can't see an "About" section to check the version

217

I did update to the latest around a hour ago but where would it tell me, I must be missing the obvious but can't see an "About" section to check the version


Try closing and re- opening Plex Notify. Right click on the icon and click exit.

Sent from my SM-N900P using Tapatalk
218

tried that several times, apologies for being a noob but now it isn't even updating me a file is being played let alone crashing.

Is there a way I can do a clean install (remove the blank icon from the notification area and freshly install). PlexNotify is no longer in my control panel to select to uninstall

219

Ok just pushed a bug fix release. I am in the process now of adding Pushalot.

220

Ok just pushed a bug fix release. I am in the process now of adding Pushalot.

SQL is going much further now.

Except this (no notification)

 
 
    Table 'plexnotify.user' doesn't exist
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PlexNotify.Databases.MySqlDB.RunQuery(String sql, Dictionary`2 sqlParameters)
   
   
 
 
    Table 'plexnotify.transcodesession' doesn't exist
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   
   
 
 
    Transcode ID F36766033C27EF06DA015F9E09716F4F does not exist in TranscodeSession table
 
 
    Table 'plexnotify.transcodesession' doesn't exist
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   
   
 
 
    Specified cast is not valid.
      at PlexNotify.DatabaseHelper.GetStates(String transcodeID, DatabaseInterface dbi)
   at PlexNotify.DatabaseHelper.StoreMediaContainer(MediaContainer mc)
   at PlexNotify.MainWindow.BW_DoWork(Object sender, DoWorkEventArgs e)
   
   
 
 
    Table 'plexnotify.transcodesession' doesn't exist
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   
   
 
 
Seems to be missing tables...