Mailing List Archive: MythTV: Users

MythWeb still won't sort and filter with auth enabled (was: Bug in MythWeb)

Index | Next | Previous | View Threaded

jra at baylink

Oct 24, 2007, 8:02 PM

Post #1 of 18 (1239 views)
Permalink

MythWeb still won't sort and filter with auth enabled (was: Bug in MythWeb)

Xris wrote:
> [ quoting Pam ]
> > if you filter by the drop-down list to one show - say Jeopardy - and
> > then you sort again - say by file size - it will sort, but
> > it reverts back to All Programs.
>
> Not a mythweb bug. Your cookies aren't working properly. Either set up
> authentication (details in the .htaccess file), which bypasses cookies,
> or figure out what's not right about your browser or mythweb domain info
> that's preventing your cookies from being saved.

Well, I've finally gotten around to enabling htauth on this server.
Same problem. I did use basic instead of digest, as the person who
wrote up the step-by-step on the wiki did, and perhaps that's the
problem.

To reproduce:

1) Recorded Programs
2) Choose a program title from Show Recordings
(Boston Legal, 4 eps)
3) Observe that the programs are displayed in reverse order by
airdate.
4) Click the column header Subtitle
5) Expected: same 4 episodes, sorted alpha ascending by
subtitle
6) Observed: Show Recordings reverts to All Recordings, all
programs in fact display... sorted alpha ascending by
subtitle.

This is from a package named

mythweb-0.20.2-2

retrieved from Packman, built for SuSE 10.2 with a uname -a of

Linux potato 2.6.18.8-0.5-default #1 SMP Fri Jun 22 12:17:53 UTC 2007
i686 athlon i386 GNU/Linux

If there's any further information I can provide, please let me know.

Cheers,
-- jra
--
Jay R. Ashworth Baylink jra [at] baylink
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com '87 e24
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

vitaminjoe at gmail

Oct 24, 2007, 8:34 PM

Post #2 of 18 (1203 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled (was: Bug in MythWeb) [In reply to]

On 10/24/07, Jay R. Ashworth <jra [at] baylink> wrote:

> Well, I've finally gotten around to enabling htauth on this server.
> Same problem. I did use basic instead of digest, as the person who
> wrote up the step-by-step on the wiki did, and perhaps that's the
> problem.
>
> To reproduce:
>
> 1) Recorded Programs
> 2) Choose a program title from Show Recordings
> (Boston Legal, 4 eps)
> 3) Observe that the programs are displayed in reverse order by
> airdate.
> 4) Click the column header Subtitle
> 5) Expected: same 4 episodes, sorted alpha ascending by
> subtitle
> 6) Observed: Show Recordings reverts to All Recordings, all
> programs in fact display... sorted alpha ascending by
> subtitle.
>
> This is from a package named
>
> mythweb-0.20.2-2

I'm using SVN 14580 of MythWeb. The sort function works as expected
(i.e. I see the results you want in (5)). I don't think the sortby
code has changed in quite a while. There must still be something
weird going on with your cookies or saved sessions.

Have you tried clearing the mythweb_sessions table of the database?

--
Joe Ripley
vitaminjoe [at] gmail
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

jra at baylink

Oct 24, 2007, 9:15 PM

Post #3 of 18 (1210 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled (was: Bug in MythWeb) [In reply to]

On Wed, Oct 24, 2007 at 09:34:40PM -0600, Joe Ripley wrote:
> On 10/24/07, Jay R. Ashworth <jra [at] baylink> wrote:
> > 1) Recorded Programs
> > 2) Choose a program title from Show Recordings
> > (Boston Legal, 4 eps)
> > 3) Observe that the programs are displayed in reverse order by
> > airdate.
> > 4) Click the column header Subtitle
> > 5) Expected: same 4 episodes, sorted alpha ascending by
> > subtitle
> > 6) Observed: Show Recordings reverts to All Recordings, all
> > programs in fact display... sorted alpha ascending by
> > subtitle.
>
> I'm using SVN 14580 of MythWeb. The sort function works as expected
> (i.e. I see the results you want in (5)). I don't think the sortby
> code has changed in quite a while. There must still be something
> weird going on with your cookies or saved sessions.
>
> Have you tried clearing the mythweb_sessions table of the database?

No. Just DELETE FROM ?

Cheers,
-- jra
--
Jay R. Ashworth Baylink jra [at] baylink
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com '87 e24
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

vitaminjoe at gmail

Oct 25, 2007, 6:19 AM

Post #4 of 18 (1190 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled (was: Bug in MythWeb) [In reply to]

On 10/24/07, Jay R. Ashworth <jra [at] baylink> wrote:

> > Have you tried clearing the mythweb_sessions table of the database?
>
> No. Just DELETE FROM ?

Yep. That should do it. Of course, make sure you have a back up of
the database before messing with it. Just in case. :)

--
Joe Ripley
vitaminjoe [at] gmail
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

vitaminjoe at gmail

Oct 25, 2007, 10:25 PM

Post #5 of 18 (1192 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled (was: Bug in MythWeb) [In reply to]

On 10/25/07, Pamela J. Ashworth (webmail) <pashworth [at] mindspring> wrote:

> if you're in phpMyAdmin, and you find the mythweb sessions table, and you move your mouse over the Browse link and you get a big red X - does that mean that the table is already empty? (or were you trying to delete the table itself, not just the data?)

I'm not too sure about phpMyAdmin... never used it before. However,
don't delete the table itself, just delete the data in it. The
relevant SQL command would be:

DELETE FROM mythweb_sessions;

--
Joe Ripley
vitaminjoe [at] gmail
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

jra at baylink

Oct 26, 2007, 10:29 AM

Post #6 of 18 (1172 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled (was: Bug in MythWeb) [In reply to]

On Thu, Oct 25, 2007 at 11:25:11PM -0600, Joe Ripley wrote:
> On 10/25/07, Pamela J. Ashworth (webmail) <pashworth [at] mindspring> wrote:
> > if you're in phpMyAdmin, and you find the mythweb sessions table,
> > and you move your mouse over the Browse link and you get a big red X -
> > does that mean that the table is already empty? (or were you trying to
> > delete the table itself, not just the data?)
>
> I'm not too sure about phpMyAdmin... never used it before. However,
> don't delete the table itself, just delete the data in it. The
> relevant SQL command would be:
>
> DELETE FROM mythweb_sessions;

She may have already gotten it; it may have been empty; 0 rows affected.

Alas, it being empty doesn't fix the problem; we're still seeing the
same results when I follow those steps to reproduce.

Any other thoughts?

Cheers,
-- jra
--
Jay R. Ashworth Baylink jra [at] baylink
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com '87 e24
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Oct 26, 2007, 8:52 PM

Post #7 of 18 (1165 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled [In reply to]

On 10/26/2007 01:29 PM, Jay R. Ashworth wrote:
> On Thu, Oct 25, 2007 at 11:25:11PM -0600, Joe Ripley wrote:
>
>> DELETE FROM mythweb_sessions;
>>
> She may have already gotten it; it may have been empty; 0 rows affected.
>
> Alas, it being empty doesn't fix the problem; we're still seeing the
> same results when I follow those steps to reproduce.
>
> Any other thoughts?

Its being empty would mean it /won't/ work. In other words, the
question is whether it /stays/ empty after you log into MythWeb. If so,
that's definitely your problem and something in your Apache/browser/...
configuration is incorrect.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

jra at baylink

Oct 27, 2007, 10:50 AM

Post #8 of 18 (1155 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled [In reply to]

On Fri, Oct 26, 2007 at 11:52:07PM -0400, Michael T. Dean wrote:
> Its being empty would mean it /won't/ work. In other words, the
> question is whether it /stays/ empty after you log into MythWeb. If so,
> that's definitely your problem and something in your Apache/browser/...
> configuration is incorrect.

Then it's incorrect:

=================
mysql> select * from mythweb_sessions;
Empty set (0.00 sec)

[. log in, using the username and password I created the other day. ]

[ go to Recorded Programs ]

[ Choose a show with 5 recordings ]

[ See that it only shows those 5 ]

[ Ctrl-F5 for a hard reload ]

[. See that it *still* only shows that program and it's 5 recordings, but... ]

mysql> select * from mythweb_sessions;
Empty set (0.01 sec)
=================

Wonder what's broken here...

Cheers,
-- jra
--
Jay R. Ashworth Baylink jra [at] baylink
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com '87 e24
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Oct 28, 2007, 5:47 AM

Post #9 of 18 (1135 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled [In reply to]

On 10/27/2007 01:50 PM, Jay R. Ashworth wrote:
> On Fri, Oct 26, 2007 at 11:52:07PM -0400, Michael T. Dean wrote:
>
>> Its being empty would mean it /won't/ work. In other words, the
>> question is whether it /stays/ empty after you log into MythWeb. If so,
>> that's definitely your problem and something in your Apache/browser/...
>> configuration is incorrect.
>>
> Then it's incorrect:
>
...
> Wonder what's broken here...

Are you accessing it directly or through another ('Net facing) web
server that proxies the server running MythWeb? I've seen cookies
broken by incorrect mod_proxy configs quite often.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

pashworth at mindspring

Oct 28, 2007, 8:25 AM

Post #10 of 18 (1159 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled [In reply to]

-----Original Message-----
>From: "Michael T. Dean" <mtdean [at] thirdcontact>
>Sent: Oct 28, 2007 8:47 AM
>To: Discussion about mythtv <mythtv-users [at] mythtv>
>Subject: Re: [mythtv-users] MythWeb still won't sort and filter with auth enabled
>
>On 10/27/2007 01:50 PM, Jay R. Ashworth wrote:
>> On Fri, Oct 26, 2007 at 11:52:07PM -0400, Michael T. Dean wrote:
>>
>>> Its being empty would mean it /won't/ work. In other words, the
>>> question is whether it /stays/ empty after you log into MythWeb. If so,
>>> that's definitely your problem and something in your Apache/browser/...
>>> configuration is incorrect.
>>>
>> Then it's incorrect:
>>
>...
>> Wonder what's broken here...
>
>Are you accessing it directly or through another ('Net facing) web
>server that proxies the server running MythWeb? I've seen cookies
>broken by incorrect mod_proxy configs quite often.

I don't know if this will help, but, since I'm *inside* the house, I duplicated the experiment, withthe same results. i did use phpMyAdmin (running on the mythbox) to access the database. so unless the proxy is in WinXP, the linux machine myth is running on, or the cheap little router on the bookcase beside me... (which has changed since back when this used to wotk properly))

--
Pam from Boston
"You're going to have to explain it. Bear with the rest of us mortals as we stumble blindly along in your shadow." -- Stacy, in Sy's House fanfic "Of a Thursday"
http://www.fanfiction.net/s/2399047/7/
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

jra at baylink

Oct 28, 2007, 8:30 AM

Post #11 of 18 (1153 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled [In reply to]

On Sun, Oct 28, 2007 at 08:47:34AM -0400, Michael T. Dean wrote:
> > Wonder what's broken here...
>
> Are you accessing it directly or through another ('Net facing) web
> server that proxies the server running MythWeb? I've seen cookies
> broken by incorrect mod_proxy configs quite often.

Nope; live and in color. NATted through an Ativa, but that's all.

Cheers,
-- jra
--
Jay R. Ashworth Baylink jra [at] baylink
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com '87 e24
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

vitaminjoe at gmail

Oct 28, 2007, 9:34 PM

Post #12 of 18 (1125 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled [In reply to]

On 10/28/07, Jay R. Ashworth <jra [at] baylink> wrote:
> On Sun, Oct 28, 2007 at 08:47:34AM -0400, Michael T. Dean wrote:
> > > Wonder what's broken here...
> >
> > Are you accessing it directly or through another ('Net facing) web
> > server that proxies the server running MythWeb? I've seen cookies
> > broken by incorrect mod_proxy configs quite often.
>
> Nope; live and in color. NATted through an Ativa, but that's all.

The mythweb_sessions table is updated by the sess_write() function in
the includes/session.php file. This function is called by the PHP
session save handler whenever the session is updated. Session support
must be working properly before any of the session handling functions
(including sess_write()) will work.

--
Joe Ripley
vitaminjoe [at] gmail
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

jra at baylink

Oct 29, 2007, 4:52 AM

Post #13 of 18 (1133 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled [In reply to]

On Sun, Oct 28, 2007 at 10:34:03PM -0600, Joe Ripley wrote:
> On 10/28/07, Jay R. Ashworth <jra [at] baylink> wrote:
> > On Sun, Oct 28, 2007 at 08:47:34AM -0400, Michael T. Dean wrote:
> > > > Wonder what's broken here...
> > >
> > > Are you accessing it directly or through another ('Net facing) web
> > > server that proxies the server running MythWeb? I've seen cookies
> > > broken by incorrect mod_proxy configs quite often.
> >
> > Nope; live and in color. NATted through an Ativa, but that's all.
>
> The mythweb_sessions table is updated by the sess_write() function in
> the includes/session.php file. This function is called by the PHP
> session save handler whenever the session is updated. Session support
> must be working properly before any of the session handling functions
> (including sess_write()) will work.

Does the fact that after I select a specific program, and it works
properly on that... and I then Ctrl-F5 and I *still* see only that
program, not imply that sessions are working?

I'll take a look at it tonight, and make sure I'm seeing cookies and
check the HTTP requests with Firebug, and the like.

Cheers,
-- jra
--
Jay R. Ashworth Baylink jra [at] baylink
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com '87 e24
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

jra at baylink

Oct 31, 2007, 8:47 PM

Post #14 of 18 (1104 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled - bump; paging Xris [In reply to]

On Mon, Oct 29, 2007 at 07:52:35AM -0400, Jay R. Ashworth wrote:
> On Sun, Oct 28, 2007 at 10:34:03PM -0600, Joe Ripley wrote:
> > On 10/28/07, Jay R. Ashworth <jra [at] baylink> wrote:
> > > On Sun, Oct 28, 2007 at 08:47:34AM -0400, Michael T. Dean wrote:
> > > > > Wonder what's broken here...
> > > >
> > > > Are you accessing it directly or through another ('Net facing) web
> > > > server that proxies the server running MythWeb? I've seen cookies
> > > > broken by incorrect mod_proxy configs quite often.
> > >
> > > Nope; live and in color. NATted through an Ativa, but that's all.
> >
> > The mythweb_sessions table is updated by the sess_write() function in
> > the includes/session.php file. This function is called by the PHP
> > session save handler whenever the session is updated. Session support
> > must be working properly before any of the session handling functions
> > (including sess_write()) will work.
>
> Does the fact that after I select a specific program, and it works
> properly on that... and I then Ctrl-F5 and I *still* see only that
> program, not imply that sessions are working?
>
> I'll take a look at it tonight, and make sure I'm seeing cookies and
> check the HTTP requests with Firebug, and the like.

In authenticated mode, I don't see any cookies, as I gather I
shouldn't, but I'm not sure where I *should* see parameters, if
anywhere; they don't seem to be showing up in the sessions table,
either.

Anyone got time to do a little more debugging with me on this?

Cheers,
-- jra
--
Jay R. Ashworth Baylink jra [at] baylink
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com '87 e24
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

vitaminjoe at gmail

Nov 1, 2007, 8:45 AM

Post #15 of 18 (1106 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled - bump; paging Xris [In reply to]

On Oct 31, 2007 9:47 PM, Jay R. Ashworth <jra [at] baylink> wrote:

> In authenticated mode, I don't see any cookies, as I gather I
> shouldn't, but I'm not sure where I *should* see parameters, if
> anywhere; they don't seem to be showing up in the sessions table,
> either.
>
> Anyone got time to do a little more debugging with me on this?

You should still see cookies in your browser for authenticated mode
(at least I do it Firefox). Check your file system to see if you have
any PHP session files kicking around. They're usually called
'sess_*'. On my SuSE 10.2 installation, these session files live in
'/var/lib/php5'.

You can also check your php.ini file to make sure that sessions are
enabled, and that cookies are enabled. Look specifically for these
options:

session.save_handler = files
session.save_path = "/var/lib/php5" (or where you want your sessions saved)
session.use_cookies = 1

Hopefully this helps a bit.

--
Joe Ripley
vitaminjoe [at] gmail
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

lists at forevermore

Nov 1, 2007, 10:05 AM

Post #16 of 18 (1089 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled - bump; paging Xris [In reply to]

Joe Ripley wrote:
> You should still see cookies in your browser for authenticated mode
> (at least I do it Firefox).

This is the key point. You should still see a cookie -- if not, there
is a good chance that something else is going wrong that might be the
root cause of both problems.

> Check your file system to see if you have
> any PHP session files kicking around. They're usually called
> 'sess_*'. On my SuSE 10.2 installation, these session files live in
> '/var/lib/php5'.

You shouldn't have any for MythWeb. I use database-based sessions, and
it's all controlled with MythWeb itself and overrides any php.ini setting.

Then again, I'm assuming you're running MythTV 0.19 or later, too.

-Chris

Attachments:

signature.asc (0.18 KB)

vitaminjoe at gmail

Nov 1, 2007, 10:49 AM

Post #17 of 18 (1112 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled - bump; paging Xris [In reply to]

On Nov 1, 2007 11:05 AM, Chris Petersen <lists [at] forevermore> wrote:

> > Check your file system to see if you have
> > any PHP session files kicking around. They're usually called
> > 'sess_*'. On my SuSE 10.2 installation, these session files live in
> > '/var/lib/php5'.
>
> You shouldn't have any for MythWeb. I use database-based sessions, and
> it's all controlled with MythWeb itself and overrides any php.ini setting.
>
> Then again, I'm assuming you're running MythTV 0.19 or later, too.

You are correct. My sess_* files were all stale, and by the looks of
them, weren't generated by MythWeb, but some of my own PHP code.

--
Joe Ripley
vitaminjoe [at] gmail
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

jra at baylink

Nov 2, 2007, 11:32 PM

Post #18 of 18 (1070 views)
Permalink

Re: MythWeb still won't sort and filter with auth enabled - bump; paging Xris [In reply to]

On Thu, Nov 01, 2007 at 10:05:29AM -0700, Chris Petersen wrote:
> Joe Ripley wrote:
> > You should still see cookies in your browser for authenticated mode
> > (at least I do it Firefox).
>
> This is the key point. You should still see a cookie -- if not, there
> is a good chance that something else is going wrong that might be the
> root cause of both problems.

I see 3 cookies, while a session is active; one with no name for
/mythweb/tv; session. One is cookie_test; session.

And one is mythweb_id, which appears to have an expiration date a
couple minutes *before* just now. Its content is a big scarey base 36
hash. Roughly, its expire time is the login time of the session.

It's actually still there in Firefox's list, even though it *says* it
should be expired...

> > Check your file system to see if you have
> > any PHP session files kicking around. They're usually called
> > 'sess_*'. On my SuSE 10.2 installation, these session files live in
> > '/var/lib/php5'.
>
> You shouldn't have any for MythWeb. I use database-based sessions, and
> it's all controlled with MythWeb itself and overrides any php.ini setting.
>
> Then again, I'm assuming you're running MythTV 0.19 or later, too.

0.20.2, from Packman SuSE RPMs; SuSE 10.2 with all the standard package
revs; everything's from RPM.

Cheers,
-- jra
--
Jay R. Ashworth Baylink jra [at] baylink
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com '87 e24
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads