plexWatch/Web - A web front-end for plexWatch

Sweeet, thanks :)

So i have not been able to get all of plexwatch web working for more then a day....

i have been trying everything i can to get the database file to work in my synology install but cant seem to get it 100%.

i started with using cloud station method, then .bat method, and even manually moving the database file but nothing works right. just says failed to access the db file on all stats pages. myplex area works.

 

i have currently set php string to :/volume1/web/pww/DB/

the db location in my config file is /volume1/web/pww/DB/plexWatch.db

 

does the database owner matter? is it always corrupt no matter what i do? im at a complete loss on how any other synology user can get this working. i can run joomla, phpmyadmin, C.O.P.S. book manager, and other web content no problem.

i followed all the instruction provided as written. if your thinking i missed anything.

plexwatch 1.8, web 1.4 

I have tried both instruction sets from the wiki page, and other configurations i thought might work but no luck.

 

any way i might get a detailed breakdown of everything any synology user has setup such as directories, settings, what user is setup, what type of connection to your synology are you using, and any permissions for anything? maybe i missed something.

 

any successful synology users or anyone who thinks of something to try, i appreciate all help thank you

So....  I've done quite a bit lately and still have the issue where only ONE item shows up in "Recently Added"....  I added about 40 files today and I get only ONE showing on my site.

I have a public URL  http://plex.bd.to       

If I go to my Plex/Web page for my server I can see over 9 pages of "Recently Added" items.....PlexWatch page....not so much!  :(

If anyone has any ideas, I would greatly appreciate it.  

Carl

So....  I've done quite a bit lately and still have the issue where only ONE item shows up in "Recently Added"....  I added about 40 files today and I get only ONE showing on my site.

I have a public URL  http://plex.bd.to       

If I go to my Plex/Web page for my server I can see over 9 pages of "Recently Added" items.....PlexWatch page....not so much!   :(

If anyone has any ideas, I would greatly appreciate it.  

Carl

Not to sure what to tell you on this one. Maybe it's worth re-downloading from GitHub and overwriting all files to ensure there are no file corruption issues. Are there any errors in your web server error logs after browing the index page?

If you browse to the recentlyAdded url below, are you seeing more than one item in the response?

So i have not been able to get all of plexwatch web working for more then a day....

i have been trying everything i can to get the database file to work in my synology install but cant seem to get it 100%.

i started with using cloud station method, then .bat method, and even manually moving the database file but nothing works right. just says failed to access the db file on all stats pages. myplex area works.

 

i have currently set php string to :/volume1/web/pww/DB/

the db location in my config file is /volume1/web/pww/DB/plexWatch.db

 

does the database owner matter? is it always corrupt no matter what i do? im at a complete loss on how any other synology user can get this working. i can run joomla, phpmyadmin, C.O.P.S. book manager, and other web content no problem.

i followed all the instruction provided as written. if your thinking i missed anything.

plexwatch 1.8, web 1.4 

I have tried both instruction sets from the wiki page, and other configurations i thought might work but no luck.

 

any way i might get a detailed breakdown of everything any synology user has setup such as directories, settings, what user is setup, what type of connection to your synology are you using, and any permissions for anything? maybe i missed something.

 

any successful synology users or anyone who thinks of something to try, i appreciate all help thank you

You shouldn't need to edit the PHP open_basedir line if you are placing the database file inside of /volume1/web/ since that folder is already readable by the web server user. 

  • Try creating a new share called "plexWatch" which will be (/volume1/plexWatch/), remove what you previously put in your PHP open_basedir line and add the following to the end:
  • :/volume1/plexWatch
    
  • Apply it and restart the web server.
  • Next copy your plexWatch.db file over to that new share as admin
  • Edit your plexWatch/Web db setting to: /volume1/plexWatch/plexWatch.db

I must have messed something up when I edited the index.php page to add my top section.  I replaced the default file and 'recently added' increased.

I've thrown the page into my "Help" page as an iFrame so it's one stop shopping now for my users.

http://plexhelp.bd.to

First tab is for assistance, second tab is the PlexWatch!

Sorry for so many posts about my issues wwith plexWatch web....

So i have tried :/volume1/plexWatch, and i removed all duplicate :/volume1/web/* entries.

i have both cloudstation setup to update the shared folder plexWatch in volume1, and i turned that off and tried a .bat script to do the same, which both work and copy the plexWatch.db from c:/plexWatch/db/ to /volume1/plexWatch.

i have the config.php looking at /volume1/plexWatch/plexWatch.db

now, just to be sure i have all other web services disabled, and i restarted web station before testing with each setting change.

i dont always get any specific error, normally just says database can not be found in some way or  another and to check my web server and config.php settings.

However, when i do get an error, it would always be this one: Warning: SQLite3::query(): Unable to execute statement: database disk image is malformed in /volume1/web/pww/history.php on line 113 Failed to access plexWatch database. Please check your settings.

There will be differences when i click each section, regarding what "malformed "page.php line #whatever" but from what i can tell, the database is corrupt whenever it is copied to the synology. i think thats where i need to know how to resolve. i'm trying to be as helpful as i can to explain this so i can be of the best help for anyone who might know whats wrong. thanks for all your help here. 

The database plexWatch.db is owned by admin when its copied to the synology. The files default permissions are set to Owner: read/write. Group: read, and Other: read.

Cloud Station, and the plexWatch directory are set (no index, no encryption, and the folder is Read, Write, Execute permission for Owner, Group and Other.

PlexWatch - Web is installed to /volume1/web/pww/ (pww = plexWatch Web)

my plexpass works, and is the only thing displaying on plexWatch web.

I have also attached pictures.

I have also tried fresh database, deleting the .db, and all files from the synology and the windows source directory, and having plexWatch remake them after the .vbs executes. I have only gotten as far as 1 day of history before it has a problem.

i'm trying to be as helpful as i can to explain this so i can be of the best help for anyone who might know whats wrong. thanks for all your help here. 

this is really cool!

great idea to add the requests. I am doing that with a separate google spreadsheet, but like your implementation better - 1-stop-shop!

How are you doing that - i.e. once your users login (and what are they logging into?) is the form filling in a db of sorts?

Thx - cool to see things extended like this!

Dan 

I must have messed something up when I edited the index.php page to add my top section.  I replaced the default file and 'recently added' increased.

I've thrown the page into my "Help" page as an iFrame so it's one stop shopping now for my users.

http://plexhelp.bd.to

First tab is for assistance, second tab is the PlexWatch!

this is really cool!
great idea to add the requests. I am doing that with a separate google spreadsheet, but like your implementation better - 1-stop-shop!

How are you doing that - i.e. once your users login (and what are they logging into?) is the form filling in a db of sorts?

Thx - cool to see things extended like this!
Dan


I could be wrong but it looks like Spiceworks to me.

this is really cool!

great idea to add the requests. I am doing that with a separate google spreadsheet, but like your implementation better - 1-stop-shop!

How are you doing that - i.e. once your users login (and what are they logging into?) is the form filling in a db of sorts?

Thx - cool to see things extended like this!

Dan 

Dan,

eleese is correct.  It is a Spiceworks installation on my system that drives the form and submission process.  The customer facing portal is customized to add the tab for my PlexWatch instance in an iFrame.  Spiceworks is configured locally and a port forward on my router and a nice little DNS entry to give it a public name.  I use the Spiceworks mobile app on my iPad and iPhone to monitor the tickets that come in and then RSS feed into uTorrent to get whatever is requested.  If my bandwidth holds up at home, I can get a standard show or movie into the queue in about 15 minutes.....keeps the minions happy!  :D

Carl

Dan, I just took it another step further since your post reminded me to look at the page this morning....  I consolidated it all to one tab.....looks much better in my opinion!

Thoughts, ideas?

http://plexhelp.bd.to

VERY clean! Great look.

Hmmmm - getting me to think this would be a cool way to have a front-end portal for my users. Even extend the "recently added" do they can see what has been added in last week or so. Really like the form submission ability and will look into Spiceworks soon.

I sometimes send reports showing my kids, etc. how much they have used the system to remind them of how much they have saved by "cutting the cable" :)

VERY cool!

Thx!

Dan, I just took it another step further since your post reminded me to look at the page this morning....  I consolidated it all to one tab.....looks much better in my opinion!

Thoughts, ideas?

http://plexhelp.bd.to

A couple of things:

  • I'll need to look at an alternative to Spiceworks :(  As cool as it looks, I need a Linux or Web-based solution.....
    • Any suggestions from anyone? I see these as possibilities:
      • MantisBT
      • Zoho Support?
      • SysAid Free Edition
      • WebHelpDesk
      • HESK
  • This guy has added a couple of interesting features to his"front-end" (Network Monitor - and his live site here) that might be cool to include. I especially like the load and the bandwidth monitors

DCP, I've seen the work done by the individual you posted and I want to incorporate the bandwidth monitor piece on my site as well.  The problem is making it 'simple' enough that anyone can use it.  I installed dd-wrt on my router and I'm working on a way to pull that data out and display it on the site.

There are a couple of possibilities, but making it so simple that anyone can do (similar to PlexWatch) is the hard part.  I'll keep you posted as I move forward with it or you can keep an eye on my site for when it appears.  Hopefully I can get it running in the next couple of weeks.  Those bass turds over at Comcast just capped our monthly data to 300GB.....I've been running at 750GB to 1TB a month....OUCH!!  It's greatly limited my ability to download whatever I wanted for the server.

I will keep my eyes open for both - an alternative as well as on your site.

Ouch as far as the cap! CoxCable here and they just gave us a very nice bump ('free' so far) in speed, but still have a cap that I have to live with....

DCP, I've seen the work done by the individual you posted and I want to incorporate the bandwidth monitor piece on my site as well.  The problem is making it 'simple' enough that anyone can use it.  I installed dd-wrt on my router and I'm working on a way to pull that data out and display it on the site.

There are a couple of possibilities, but making it so simple that anyone can do (similar to PlexWatch) is the hard part.  I'll keep you posted as I move forward with it or you can keep an eye on my site for when it appears.  Hopefully I can get it running in the next couple of weeks.  Those bass turds over at Comcast just capped our monthly data to 300GB.....I've been running at 750GB to 1TB a month....OUCH!!  It's greatly limited my ability to download whatever I wanted for the server.

Comcast just capped our monthly data to 300GB.

Somewhat off topic for this thread, but want to make sure all the geeks like me who pay attention due to Comcast's recent enforcement not really encouraging use of Plex for remote viewing -

Pay CLOSE attention to your Comcast online meter versus your router's usage report. If you don't have a router that gives a total monthly usage, build one, find one, or find a router who's firmware you can do custom on.

Comcast has been saying I've been using 10-15GB over what my router and my PRTG (commercial Win version of MRTG) installation have been saying I've been using for the past 3 months.

My fear is that they're counting every bit that rolls across the modem, even if it's dropped at the router.

I'm not a happy camper.

Now, back to your normally scheduled programming.

Rock on PlexWatch, PlexWatch/Web and all the project ideas they're spawning.

Alright so here's an update after my last 12 hours of getting plexWatch web to work;

i got the interface working. and after rebuilding all the plexWatch files and database, and setting the source directory to a UNC path, just to get the best option to have a non damaged database, however the stats areas do not fill out. but i dont have any errors now.

still unsure if its permissions or something else to get 100% working.

Alright so here's an update after my last 12 hours of getting plexWatch web to work;

i got the interface working. and after rebuilding all the plexWatch files and database, and setting the source directory to a UNC path, just to get the best option to have a non damaged database, however the stats areas do not fill out. but i dont have any errors now.

still unsure if its permissions or something else to get 100% working.

Give it a day of activity and then report back on whether or not the history stats populate.

I'm just curious, are you watching a lot of channel based content or is it all local?

Sure, I will report back in 24 hours. All content is local or remote users my library is shared with. So far Plex watch has reported 6 watched shows and 4 new adds. With 2 watching as of this post. Myplex shows working. Stats all blank. Will update soon.

I have a little webpage myself that gives shortcuts to various services I´m running with 4-5 subpages and one of the subpages I currently just have a twitter feed for the recently added items. What I would love to have instead is just having the option of a lightweight, public guest version of the PlexWatchWeb that would not display sensitive information, such as user IP's/platforms and the users and settings page. Just who's watching what right now, recently added and top Charts.

You know, just in case you needed yet another feature request  :rolleyes: