Re: [mythtv-users] Mythweb problem

[Dag Nygren]

> > that's not what the query looks like.  see here:
> > 
> > http://svn.mythtv.org/trac/browser/trunk/mythplugins/mythweb/includes/programs.php

Just diffed this file against mine and they are identical.
So nothing wrong with SVN :-)

Anyway the problem is the second USING() in here.

Thanks Chris for the feedback on my comments, it helped
a lot!

Dag


___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Dag Nygren]

> that's not what the query looks like.  see here:
> 
> http://svn.mythtv.org/trac/browser/trunk/mythplugins/mythweb/includes/programs.php
> 
> however, I think this is starting to look like a bug with subversion. 
> It seems almost like the ½ entity is being converted into the 
> actual 1/2 character (which shows up in your code as a ?) when it's 
> being downloaded.

It is not, but that copy paste was done from a print "$query" I
used to run it.

But anyway that query is the cuplrit.
I changed the LEFT JOIN programrating USING (chanid, starttime)
to a 
LEFT JOIN programrating ON program.chanid=programrating.chanid
AND program.chanid=programrating.starttime

And then I have a nice pogram listing as the result.

> however, I've checked my own http checkout of myth (since I usually 
> check out via ssh for editing), and it's fine.  So it seems like 
> something's funky in your particular install.

Indeed, now I have to find out what is wrong with SVN here.

Dag


___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Chris Petersen]

> Well, I think I figured out the reason for the message.
> As both program and oldrecorded has their own chanid the poor MySQL
> doesn't know which one to join the programrating to.
> 
> Now the question is: Why doesn't this happen to everyone?
> Is it my for a long tim updated/upgraded database?

ok, that certainly could be a mysql5 change...  I'll be poking at those 
joins tonight, anyway...  will make them explicit ON rather than USING, 
which should fix your problem, too.

-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Chris Petersen]

> The new query with parameters replaced and run from mysql generates the 
> following:
> 
> mysql> SELECT program.*, UNIX_TIMESTAMP(program.starttime) AS starttime_unix, 
> UNIX_TIMESTAMP(program.endtime) AS endtime_unix, CONCAT(repeat("*", 
> program.stars * 4), IF((program.stars * 4 * 10) % 10, "?", "")) AS 
> starstring, 
> IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") 
> AS 
> rating, oldrecorded.recstatus FROM program LEFT JOIN oldrecorded USING 
> (seriesid, programid) LEFT JOIN programrating USING (chanid, starttime) WHERE 
> program.chanid='5' AND program.starttime = FROM_UNIXTIME('1137693600') GROUP 
> BY program.chanid, program.starttime ORDER BY program.starttime;
> ERROR 1052 (23000): Column 'chanid' in from clause is ambiguous
> mysql>   
> 
> I figure this is the problem here but really cannot see the reason for the 
> error message.
> Is this a MySQL bug? Currently using version 5.0.15.

that's not what the query looks like.  see here:

http://svn.mythtv.org/trac/browser/trunk/mythplugins/mythweb/includes/programs.php

however, I think this is starting to look like a bug with subversion. 
It seems almost like the ½ entity is being converted into the 
actual 1/2 character (which shows up in your code as a ?) when it's 
being downloaded.

however, I've checked my own http checkout of myth (since I usually 
check out via ssh for editing), and it's fine.  So it seems like 
something's funky in your particular install.

And no, it's not mysql.  The ? replacement is from a library that I 
wrote and included in mythweb.

-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Dag Nygren]

> 
> > 
> > That's not what that query looks like...  remove the file and re-up svn.
> 
> Ok, did that.
> 
> The new query with parameters replaced and run from mysql generates the 
> following:
> 
> mysql> SELECT program.*, UNIX_TIMESTAMP(program.starttime) AS starttime_unix, 
> UNIX_TIMESTAMP(program.endtime) AS endtime_unix, CONCAT(repeat("*", 
> program.stars * 4), IF((program.stars * 4 * 10) % 10, "?", "")) AS 
> starstring, 
> IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") 
> AS 
> rating, oldrecorded.recstatus FROM program LEFT JOIN oldrecorded USING 
> (seriesid, programid) LEFT JOIN programrating USING (chanid, starttime) WHERE 
> program.chanid='5' AND program.starttime = FROM_UNIXTIME('1137693600') GROUP 
> BY program.chanid, program.starttime ORDER BY program.starttime;
> ERROR 1052 (23000): Column 'chanid' in from clause is ambiguous
> mysql>   
> 
> I figure this is the problem here but really cannot see the reason for the 
> error message.

Well, I think I figured out the reason for the message.
As both program and oldrecorded has their own chanid the poor MySQL
doesn't know which one to join the programrating to.

Now the question is: Why doesn't this happen to everyone?
Is it my for a long tim updated/upgraded database?

Dag


___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Dag Nygren]

> 
> That's not what that query looks like...  remove the file and re-up svn.

Ok, did that.

The new query with parameters replaced and run from mysql generates the 
following:

mysql> SELECT program.*, UNIX_TIMESTAMP(program.starttime) AS starttime_unix, 
UNIX_TIMESTAMP(program.endtime) AS endtime_unix, CONCAT(repeat("*", 
program.stars * 4), IF((program.stars * 4 * 10) % 10, "?", "")) AS starstring, 
IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") AS 
rating, oldrecorded.recstatus FROM program LEFT JOIN oldrecorded USING 
(seriesid, programid) LEFT JOIN programrating USING (chanid, starttime) WHERE 
program.chanid='5' AND program.starttime = FROM_UNIXTIME('1137693600') GROUP 
BY program.chanid, program.starttime ORDER BY program.starttime;
ERROR 1052 (23000): Column 'chanid' in from clause is ambiguous
mysql>   

I figure this is the problem here but really cannot see the reason for the 
error message.
Is this a MySQL bug? Currently using version 5.0.15.

Dag

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Chris Petersen]

> Anyway I am very close to a solution now.
> Down in programs.php the SQL produced in load_all_program_data() is bogus
> it contains 4 "?" marks and the query is only passed 3 parameters. I told PHP 
> to
> print the SQL statement in my case and got:
> query = SELECT program.*, UNIX_TIMESTAMP(program.starttime) AS 
> starttime_unix, 
> UNIX_TIMESTAMP(program.endtime) AS endtime_unix, CONCAT(repeat(?, 
> program.stars * ?), IF((program.stars * ? * 10) % 10, "?", "")) AS 
> starstring, 
> IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") 
> AS 
> rating, oldrecorded.recstatus FROM program LEFT JOIN oldrecorded USING 
> (seriesid, programid) LEFT JOIN programrating USING (chanid, starttime) WHERE 
> program.chanid='30' AND program.starttime = FROM_UNIXTIME('1137685500') GROUP 
> BY program.chanid, program.starttime ORDER BY program.starttime
> 
> The substituting parameters in the query are:
> star_character, max_stars, max_stars

That's not what that query looks like...  remove the file and re-up svn.

-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Dag Nygren]

> > Is there an operator === in PHP ?
> > 
> > I found a line:
> > if ($key === 'offset') {
> > in recording_schedules.php ?
> > 
> > It is not the reason for the problem, but anyway?
> 
> yes.  it means "equals, and of the same type".  In that case, if $key is 
> zero, 'offset' is evaluated as an integer, which is also zero, so they 
> match.  The === makes sure that 'offset' and $key are both the same type 
> (int != string).

OK, sorry for my bad PHP.

Anyway I am very close to a solution now.
Down in programs.php the SQL produced in load_all_program_data() is bogus
it contains 4 "?" marks and the query is only passed 3 parameters. I told PHP 
to
print the SQL statement in my case and got:
query = SELECT program.*, UNIX_TIMESTAMP(program.starttime) AS starttime_unix, 
UNIX_TIMESTAMP(program.endtime) AS endtime_unix, CONCAT(repeat(?, 
program.stars * ?), IF((program.stars * ? * 10) % 10, "?", "")) AS starstring, 
IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") AS 
rating, oldrecorded.recstatus FROM program LEFT JOIN oldrecorded USING 
(seriesid, programid) LEFT JOIN programrating USING (chanid, starttime) WHERE 
program.chanid='30' AND program.starttime = FROM_UNIXTIME('1137685500') GROUP 
BY program.chanid, program.starttime ORDER BY program.starttime

The substituting parameters in the query are:
star_character, max_stars, max_stars

Dag


___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Chris Petersen]

> Is there an operator === in PHP ?
> 
> I found a line:
> if ($key === 'offset') {
> in recording_schedules.php ?
> 
> It is not the reason for the problem, but anyway?

yes.  it means "equals, and of the same type".  In that case, if $key is 
zero, 'offset' is evaluated as an integer, which is also zero, so they 
match.  The === makes sure that 'offset' and $key are both the same type 
(int != string).

-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Dag Nygren]

> 
> > Will turn on the debugging and report back after some time.
> 
> Keep me posted.

The debugging didn't  reveal anything new as I found that it
has been on all the time.

Working deeper into the problem right now.

Is there an operator === in PHP ?

I found a line:
if ($key === 'offset') {
in recording_schedules.php ?

It is not the reason for the problem, but anyway?

Dag

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Chris Petersen]

> Exactly, but to get the right result it needs to be the name of the box that
> keeps the files, not the host where the Web stuff is working??

no, it needs to match up with the directory where the files are mounted 
on the box the web stuff is on.  If you don't mount the files on the web 
box, that setting is useless, anyway.

> Will turn on the debugging and report back after some time.

Keep me posted.

-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Dag Nygren]

> > Tried the new mythweb and like the layout.
> > 
> > There is a problem in my setup though:
> > 
> > The "tv" page is blank.
> > I suspect that this has something to do with the fact
> > that I am running Mythweb and the MySQL database
> > on a different machine than MythTV itself.
> > 
> > The previous versions of mythweb worked fine in this setup though
> 
> Previous as in how old?  Last week?  Last month?  .16?

Sorry for not being more specific.
The previous version was SVN from 16th Dec 2005

Dag


___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Dag Nygren]

> that was changed yesterday...  no /bin/ (or it won't work in windows), 
> and there is now an override hostname setting in .htaccess (it was also 
> removed from conf.php, which I'm slowly trying to eliminate).

Good.

> > For example the following from tv/recorded.php
> >$dir = $db->query_col('SELECT data
> >  FROM settings
> > WHERE value="RecordFilePrefix" AND 
> > hostname=?',
> >   hostname
> >  );
> > will need the hostname of the MythTV box.
> 
> no, it won't.  each host can have its own RecordFilePrefix.  MythWeb is 
> doing exactly what it's supposed to.  However, I'm probably missing some 
> config for this so it can easily be set from MythWeb

Exactly, but to get the right result it needs to be the name of the box that
keeps the files, not the host where the Web stuff is working??

But I will take your word for the hostname working part.

Just traced the problem with the white screen down to
the following part of  recording_schedules.php:

// Load all of the scheduled recordings.  We will need them at some point, so 
we
// might as well get it overwith here.
global $Scheduled_Recordings, $Num_Conflicts, $Num_Scheduled;
$Scheduled_Recordings = array();
foreach (get_backend_rows('QUERY_GETALLPENDING', 2) as $key => $program) {
// The offset entry
if ($key === 'offset') {
list($Num_Conflicts, $Num_Scheduled) = $program;
}
// Normal entry:  $Scheduled_Recordings[chanid][starttime][]
else {
$Scheduled_Recordings[$program[4]][$program[11]][] =& new 
Program($program);
}
}

But I couldn't catch exactly where it goes wrong after that yet.

Will turn on the debugging and report back after some time.

Dag


___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Chris Petersen]

> Tried the new mythweb and like the layout.
> 
> There is a problem in my setup though:
> 
> The "tv" page is blank.
> I suspect that this has something to do with the fact
> that I am running Mythweb and the MySQL database
> on a different machine than MythTV itself.
> 
> The previous versions of mythweb worked fine in this setup though

Previous as in how old?  Last week?  Last month?  .16?

If you upgraded from .18, did you read through the .htaccess file and 
configure your database variables?

Try enabling errors in php.ini and see if that helps shed some light on 
the situation (there's only so much I can trap for within mythweb itself).

-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Chris Petersen]

> I don't have any log errors either, just the blank page.
> I was a bit worried about the "hostname" variable as
> using "/bin/hostname" on the WEB server obviously
> will give you the wrong variable to use for in the SQL queries.

that was changed yesterday...  no /bin/ (or it won't work in windows), 
and there is now an override hostname setting in .htaccess (it was also 
removed from conf.php, which I'm slowly trying to eliminate).

> For example the following from tv/recorded.php
>$dir = $db->query_col('SELECT data
>  FROM settings
> WHERE value="RecordFilePrefix" AND 
> hostname=?',
>   hostname
>  );
> will need the hostname of the MythTV box.

no, it won't.  each host can have its own RecordFilePrefix.  MythWeb is 
doing exactly what it's supposed to.  However, I'm probably missing some 
config for this so it can easily be set from MythWeb

-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Dag Nygren]

> > Tried the new mythweb and like the layout.
> > 
> > There is a problem in my setup though:
> > 
> > The "tv" page is blank.
> > I suspect that this has something to do with the fact
> > that I am running Mythweb and the MySQL database
> > on a different machine than MythTV itself.
> > 
> > The previous versions of mythweb worked fine in this setup though
> > 
> 
> I have the same problem, and I am running mysql and mythweb on the same
> machine.  There have been posts about this to the -users and -dev lists
> in the past month.  The suggestions posted there have not worked for me.
>  I have tried both php4 and php5.  I do not get any php or http errors.
>  I read through the mythweb README very carefully and followed all the
> instructions.  Mythweb worked for me up until about a week ago.  I am
> using SVN (8623).

Thanks for confirming. Always nice to know that it is
not only me.

I don't have any log errors either, just the blank page.
I was a bit worried about the "hostname" variable as
using "/bin/hostname" on the WEB server obviously
will give you the wrong variable to use for in the SQL queries.
For example the following from tv/recorded.php
   $dir = $db->query_col('SELECT data
 FROM settings
WHERE value="RecordFilePrefix" AND hostname=?',
  hostname
 );
will need the hostname of the MythTV box.

On the other hand the hostname to direct the SQL queries to will
be the /bin/hostname.

I will look into this a bit more if no one beats me to it :-) 

Dag

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Mythweb problem

[Brian Stults]

Dag Nygren wrote:
> Tried the new mythweb and like the layout.
> 
> There is a problem in my setup though:
> 
> The "tv" page is blank.
> I suspect that this has something to do with the fact
> that I am running Mythweb and the MySQL database
> on a different machine than MythTV itself.
> 
> The previous versions of mythweb worked fine in this setup though
> 

I have the same problem, and I am running mysql and mythweb on the same
machine.  There have been posts about this to the -users and -dev lists
in the past month.  The suggestions posted there have not worked for me.
 I have tried both php4 and php5.  I do not get any php or http errors.
 I read through the mythweb README very carefully and followed all the
instructions.  Mythweb worked for me up until about a week ago.  I am
using SVN (8623).
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Mlists]

On Mon, 2005-19-12 at 14:40 -0800, Chris Petersen wrote:
> > Thats not what the error said to me.  It JUST said what I had sent in my
> > original post.
> 
> Then like I said, perhaps you need to update your svn checkout.
> 
> -Chris

Ok, I'm running 8111 to match my svn version that I'm running.

Norm

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Chris Petersen]

Thats not what the error said to me.  It JUST said what I had sent in my
original post.


Then like I said, perhaps you need to update your svn checkout.

-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Mlists]

> And the error page itself says:
> 
>  The database environment variables are not correctly set in the
>  included .htaccess file.  Please read through the comments included
>  in the file and set up the db_* environment variables correctly.
> 
>  Some possible solutions are to make sure that mod_env is enabled
>  in httpd.conf, as well as having followed the instructions in the
>  README about the AllowOverride settings.
> 
> Not sure how to be more explicit than this.  This has been in the code 
> since 11/07, so perhaps Mlists needs to upgrade his checkout.
> 
> -Chris

Thats not what the error said to me.  It JUST said what I had sent in my
original post.

Norm

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Chris Petersen]

Kevin Kuphal wrote:

Chris Petersen wrote:

Just a suggestion, but it would be better if that error message 
directed people to the README or said something other than "Your db 
variables are wrong" because, well, it may have nothing to do with 
the db variables.



it directs you to the .htaccess file, which as of 30 seconds ago 
reminds you to check for mod_env...


I got that same error when AllowOverrides was not set properly in the 
apache.conf


And the error page itself says:

The database environment variables are not correctly set in the
included .htaccess file.  Please read through the comments included
in the file and set up the db_* environment variables correctly.

Some possible solutions are to make sure that mod_env is enabled
in httpd.conf, as well as having followed the instructions in the
README about the AllowOverride settings.

Not sure how to be more explicit than this.  This has been in the code 
since 11/07, so perhaps Mlists needs to upgrade his checkout.


-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Mlists]

> Did you read the README and set up your httpd.conf AllowOverrides 
> section properly?
> 
> Kevin
> 

Odd, my reading skills must be diminished because I didn't see that part
of the readme... Only saw the REALLY important part :)  The
AllowOverride did the trick.

Thanks everyone for the help.

Norm

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Kevin Kuphal]

Chris Petersen wrote:

Just a suggestion, but it would be better if that error message 
directed people to the README or said something other than "Your db 
variables are wrong" because, well, it may have nothing to do with 
the db variables.



it directs you to the .htaccess file, which as of 30 seconds ago 
reminds you to check for mod_env...


I got that same error when AllowOverrides was not set properly in the 
apache.conf


Kevin

--
Looking for affordable webhosting?  http://www.sitecity.net

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Mlists]

No, it doesn't say anything about mod_env or AllowOverride.  
I will check on the AllowOverride option.  I know the db vars are
correct because I left them as default and its running on the same
machine.
Does it work if I set those variables as OS environment variables in the
default profile?

Thanks
Norm

On Mon, 2005-19-12 at 13:16 -0800, Chris Petersen wrote:
> > I checked and didn't have it loading so I did apache-modconf apache 
> > enable mod_env and that enabled it when I restarted the server.  
> > Unfortunately I'm getting the same error.
> 
> Dunno what to say.  You should only get that "db vars" error page if 
> server, database name or database password are blank (it allows you to 
> have a blank password).  The only way they're blank is if apache is set 
> up wrong.  All of this is covered on that page (you left off the second 
> half of the error message in your original post, which mentions both 
> mod_env and AllowOverride.
> 
> -Chris
> ___
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Chris Petersen]

I checked and didn't have it loading so I did apache-modconf apache 
enable mod_env and that enabled it when I restarted the server.  
Unfortunately I'm getting the same error.


Dunno what to say.  You should only get that "db vars" error page if 
server, database name or database password are blank (it allows you to 
have a blank password).  The only way they're blank is if apache is set 
up wrong.  All of this is covered on that page (you left off the second 
half of the error message in your original post, which mentions both 
mod_env and AllowOverride.


-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Chris Petersen]

Just a suggestion, but it would be better if that error message directed 
people to the README or said something other than "Your db variables are 
wrong" because, well, it may have nothing to do with the db variables.


it directs you to the .htaccess file, which as of 30 seconds ago reminds 
you to check for mod_env...


-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Kevin Kuphal]

Chris Petersen wrote:


Mlists wrote:


Hi all,

This is probably a dumb problem but this is my first attempt to get 
Mythweb working.  Whenever I browse to the web page I get the 
following error:


The database environment variables are not correctly set in the
included .htaccess file. Please read through the comments included
in the file and set up the db_* environment variables correctly.

I've checked the .htaccess file and it's correct.  I verified my 
php.ini file has the extension=mysql.so in it.  I've verified that I 
indeed have php4-mysql installed on my machine.



make sure that you have mod_env enabled in your apache config.

Just a suggestion, but it would be better if that error message directed 
people to the README or said something other than "Your db variables are 
wrong" because, well, it may have nothing to do with the db variables.


Kevin

--
Looking for affordable webhosting?  http://www.sitecity.net

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Mlists]

Chris Petersen wrote:


Mlists wrote:


Hi all,

This is probably a dumb problem but this is my first attempt to get 
Mythweb working.  Whenever I browse to the web page I get the 
following error:


The database environment variables are not correctly set in the
included .htaccess file. Please read through the comments included
in the file and set up the db_* environment variables correctly.

I've checked the .htaccess file and it's correct.  I verified my 
php.ini file has the extension=mysql.so in it.  I've verified that I 
indeed have php4-mysql installed on my machine.



make sure that you have mod_env enabled in your apache config.



I checked and didn't have it loading so I did apache-modconf apache 
enable mod_env and that enabled it when I restarted the server.  
Unfortunately I'm getting the same error.


Norm
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Chris Petersen]

Mlists wrote:

Hi all,

This is probably a dumb problem but this is my first attempt to get 
Mythweb working.  Whenever I browse to the web page I get the following 
error:


The database environment variables are not correctly set in the
included .htaccess file. Please read through the comments included
in the file and set up the db_* environment variables correctly.

I've checked the .htaccess file and it's correct.  I verified my php.ini 
file has the extension=mysql.so in it.  I've verified that I indeed have 
php4-mysql installed on my machine.


make sure that you have mod_env enabled in your apache config.

-Chris
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb Problem

[Kevin Kuphal]

Mlists wrote:


Hi all,

This is probably a dumb problem but this is my first attempt to get 
Mythweb working.  Whenever I browse to the web page I get the 
following error:


The database environment variables are not correctly set in the
included .htaccess file. Please read through the comments included
in the file and set up the db_* environment variables correctly.

I've checked the .htaccess file and it's correct.  I verified my 
php.ini file has the extension=mysql.so in it.  I've verified that I 
indeed have php4-mysql installed on my machine.


Is there a log file somewhere for php that I can look into?  Not sure 
where to find it...


Did you read the README and set up your httpd.conf AllowOverrides 
section properly?


Kevin

--
Looking for affordable webhosting?  http://www.sitecity.net

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] MythWeb problem permisssion error...

[Johan Venter]

A JM wrote:
 > 


*Warning* at /var/www/html/mythweb/includes/init.php, line 149:
mkdir() [function.mkdir ]: 
Permission denied



*Fatal Error* at /var/www/html/mythweb/includes/init.php, line 150:
Error creating path for image_cache: Please check permissions.


Create a directory in /var/www/html/mythweb called 'image_cache' and set 
its ownership and permissions such that the web server can write to it.


In my case I went:

  # mkdir image_cache
  # chown mythtv.www-data image_cache
  # chmod g+w image_cache

This is clearly pointed out in the instructions in the README file, have 
a browse through it if you have more trouble.


Johan.
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users