Self Contained Web Server / Interface (2 Viewers)

rr69

Portal Member
November 6, 2006
30
3
Home Country
Netherlands Netherlands
Hi jonolo,

I'm interested in testing your solution. I have a w2k3 server running iis6 + php5 and mysql5. I want to use the webinterface on regular pc's and on a pda phones 320x200.

Now the webinterface is running on its own server, and i have to set a seperate port for the tvwebserver and the iis server. When running it all on iis6 I can use "host headers" for identifying the correct website so multiple websites can run on port 80.

So count me in.. :D

Regards RR69
 

charli181

Retired Team Member
  • Premium Supporter
  • August 3, 2007
    800
    111
    Sydney
    Home Country
    Australia Australia
    Hi all

    I have just started to implement a web interface for apache with php. It should probably run on any web server supporting php but only tested on apache (v2.2.6).

    I am no gun at programming, but wouldn't it be simpler to build an isapi to connect to the existing webserver than redo the whole thing again for IIS/Apache?
     

    charli181

    Retired Team Member
  • Premium Supporter
  • August 3, 2007
    800
    111
    Sydney
    Home Country
    Australia Australia
    Running behind Apache - Reverse Proxy

    All,

    I have got this app to run behind my main apache server running on port 80. This now eliminates issues where firewalls block websites that do not run on the standard port.

    here are the steps....

    #Step 1 - in the httpd.conf file uncomment these modules

    LoadModule proxy_module modules/mod_proxy.so
    LoadModule proxy_http_module modules/mod_proxy_http.so
    LoadModule headers_module modules/mod_headers.so


    # Step 2 - at the end iof httd.conf file add these lines

    ProxyRequests off
    ProxyPass /tvepg/ http://garage10:8090/

    <Location /tvepg/>
    ProxyPassReverse /
    </Location>

    # Step 3 - restart Apache web server to instigate these changes
    # further infor can be found at http://www.apachetutor.org/admin/reverseproxies


    PS - just found out that this will not work if you use the loginID. A loginID must have the AutoLoginIP set to the address of the apache Webserver for it to work.

    To access the site with the above config, use http://yourapacheserver/tvepg/. MAKE SURE TO PUT THE LAST FORWARD SLASH
     

    peterk2007

    Portal Member
    April 7, 2007
    15
    4
    Home Country
    Hungary Hungary
    Installed, configured tried. Works like charm. :) Thanks Big_Kev for this nice piece of soft.

    There is one thing I noticed. If there is a newline in description (maybe other field too), the application should replace it with a "<br />", because now multiline desc-s are kind of hard to read.

    Btw, it is possible to somehow display a "short version" of the description in the guide? I created a custom view for program entries showing description below title. I'd like to show - let's say - the first 30 chars only with a "..." at the end, because i have shows with very long descriptions. It this possible?

    Edit: I found an other issue: If I use custom HTML for recorded and scheduled entries, the translation does not work (tried with or without "~~~"-s).
     

    freand

    New Member
    December 9, 2007
    3
    1
    Bromma
    Home Country
    Sweden Sweden
    Hello!

    I am trying to install the Web interface, but I can't get the connection to database to work. I am running a MySql-database on a Linux-machine, and the TvService can make a successful connection to this machine. If I interpret the messages correctly, it seems like the webserver is using the database-name "tvlibrary". The problem is that the TvServer set the database name to "TvLibrary". Linux is case sensitive when accessing files and other stuff, but Windows is usually case insensitive. So I think this is causing my problems.
    Is it possible to make the database name configurable in the .ini-file? In that case, I can test to change it and see if it solves the problem. Or are there other linux-users out there who have successfuly installed the Web interface?

    Another question: Is anyone working on a Swedish translation? Otherwise, I can do it when I get the interface up and running.

    /Fredrik
     

    Big_Kev

    Portal Pro
    June 8, 2007
    338
    186
    Home Country
    New Version 0.2.0.11

    Thank you for your suggestion Fredrik:D

    New Features:
    • Database Name is Configurable Now - See Database page in manager
    • Test Login Button - This will test the database details you have entered
    I hope this helps you Fredrik - let me know how it goes... I will take you up on your offer for the Swedish translation after Christmas holidays!

    Kev

    Installed, configured tried. Works like charm. :) Thanks Big_Kev for this nice piece of soft.

    There is one thing I noticed. If there is a newline in description (maybe other field too), the application should replace it with a "<br />", because now multiline desc-s are kind of hard to read.

    Btw, it is possible to somehow display a "short version" of the description in the guide? I created a custom view for program entries showing description below title. I'd like to show - let's say - the first 30 chars only with a "..." at the end, because i have shows with very long descriptions. It this possible?

    Edit: I found an other issue: If I use custom HTML for recorded and scheduled entries, the translation does not work (tried with or without "~~~"-s).
    I will have a look at the other issues later...

    For the length of the description, with custom HTML, just add the length you want in square brackets after the special tag.

    for example !!!Description!!![300] will limit the description to 300 characters. This is good in the "boxover" script option.

    TITLE="header=[!!!Title!!!] body=[!!!Description!!![300]]"

    Hope this helps.

    Kev

    Hi Kev,
    I have been on a version for a couple of months ago and have just upgraded to the latest today.
    Thanks again for all the efforts, they are greatly appreciated :)

    I have a couple of feature requests I thought I'd run by you.

    1) TV server status. Could this page be modified to be the server status? Where it would show not just the status of the service, but the memory usage (maybe just an average or not to often updated). To give more info on this page, you could return the disk space usage of the recording folders and the C drive. This would be a much richer view of the whole status of the server.

    2) Recorded Programs. instead of a single delete button for each program, would it be better to have check boxes and an option to delete all selected or to reset the watched status of all selected or any other thing along those lines.

    3) TV Card status. I'm not sure if it does this in the newest version, but in the older one, it displayed "Tuner Locked" when a card was in use. Is it possible to report this in the same way the "Manual" section does in the TV server config? IE, Timeshifting channel 9 and the name of the PC or recording schedule that has that card in use.

    4) logging. Is it possible to log access and if anyone adds or deletes a recording or schedule to log that as well?

    These are just all ideas. I have no idea if they are easy or hard to implement or even if you think it's worth it but I thought I'd run them by you anyway.

    Merry Christmas and hope to see you round again real soon.

    Cheers,
    Marcus.
    Hi Marcus,

    These are really good suggestions!

    I have been busy with some contracts, and now it is holiday season...

    I may not get into these until the new year.

    Kev
     

    Marcusb

    Retired Team Member
  • Premium Supporter
  • February 16, 2005
    1,995
    29
    Melbourne
    thanks for the answer. I hadn't seen you around for a while, so figured that Real Life may have gotten the better of you. Have fun,
    Marcus.
     

    riadmelb

    Portal Pro
    July 9, 2006
    218
    7
    Melbourne
    Home Country
    Hi Kev, I just noticed this program and it sounds promising. I also noticed that you have included EPG Downloader Service into it. Should I remove the standalone EPG Download Service and rely on the one included here? Are you planning to maintain both of them?

    Another question (might be silly) is how is this program different to Rule-based TvScheduler service?

    Your efforts are much appreciated,
    Riad
     

    MattyZee

    Portal Member
    November 23, 2007
    23
    0
    Adelaide
    Home Country
    Thanks Big Kev!

    I downloaded and installed the Interface. When i tried to add a recording i got the following error.
    Code:
    Error: [AnyDAC][Phys][ODBC][Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'directory', table 'TvLibrary.dbo.Schedule'; column does not allow nulls. INSERT fails.
    Any ideas on what i've done wrong or is a bug in the latest release?
     

    MattyZee

    Portal Member
    November 23, 2007
    23
    0
    Adelaide
    Home Country
    I ended up reinstalling EVERYTHING (not related to this problem) and now its works fine. Don't know what the difference was, i used the same installation files as before. Oh well, it works now.
    Great interface! Thanks SO much!!
     

    Users who are viewing this thread

    Top Bottom