Sergio,
You are correct on the memory issues. Please read
see the dynamic patches I posted back in August. They
fix the issue the the chanid memory issues.
-Mike
--- John Doe <[EMAIL PROTECTED]> wrote:
---------------------------------
Hi,
I had the same issue using the mythconverg database
with mvpmc (for other reasons) and I solved it by
setting the following privilages in the user table:
Host:%
User:mythtv
Password:PASSWORD("mythtv")
Select_priv:"Y"
everything else set to "N". The error then dissapears.
I didn't have the patience to try more selective host
selectors but I do know that if I set any other
options to "Y" other than select I get errors.
I do agree with another posting I've seen in that the
implementation is not clean or stable. In a previous
posting I noted that the chanid could not reliably
used to index into an in-memory array because it can
contain flaky values over 1000 or 2000 depending on
the number or times a source is created then deleted
and finally assigned to a card. The implementation I
saw (and I must admit that I haven't pulled a recent
view because I'm too busy finalizing and testing a
live tv guide implememtation) used the chanid as an
index which will without a doubt trample memory.
All that being said, your problem is probably related
to how you've set your database permissions and the
best way to debug this is to use mysql -u<user>
-p<password> <database> from a host you've configured
and determine if the permissions are set properly.
Cheers...
Sergio
---------------------------------
From: "Gert-Jan Bilt, van de" <[EMAIL PROTECTED]>
To: <[email protected]>
Subject: Re: [Mvpmc-users] Mythtv Scheduling
Date: Tue, 29 Aug 2006 22:55:34 +0200
>I still have this database error on top of the screen
when I try to use the scheduling options with MythTV
v0.19 and a MySQL v4.1.12. Even though I have granted
all access to every host in my local subnet. I can see
however all recorded shows and play them flawlessly.
>
>Does one need to set the user, password etc. on the
commandline for starting the mvpmc application? I
noticed these options when I logged onto the MVP and
used "mvpmc --help".
>
> >>> Adrian W <[EMAIL PROTECTED]> 8/29/2006
14:26:31 >>>
>Thanks problem solved, it now works.
>
>I am finding scrolling up and down quickly causeing
>the mvpmc to reset, that said I am using a nightly
>build. though if can get more info in terms of loggs
>I will post them on the lists
>
>Many Thanks
>
>Adrian
>
>--- Michael Drons <[EMAIL PROTECTED]> wrote:
>
> > If this is your first frontend then you need to
> > follow
> > the directions in MythTV for remote frontends.
> >
> >
http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2
> >
> > Scroll down and follow the directions for
"Modifying
> > access to the MySQL database for multiple systems"
> >
>
>
>
>
>___________________________________________________________
>To help you stay safe and secure online, we've
developed the all new Yahoo! Security Centre.
http://uk.security.yahoo.com
>
>-------------------------------------------------------------------------
>Using Tomcat but need to do more? Need to support web
services, security?
>Get stuff done quickly with pre-integrated technology
to make your job easier
>Download IBM WebSphere Application Server v.1.0.1
based on Apache Geronimo
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>_______________________________________________
>Mvpmc-users mailing list
>[email protected]
>https://lists.sourceforge.net/lists/listinfo/mvpmc-users
>mvpmc wiki: http://mvpmc.wikispaces.com/
>
>
>-------------------------------------------------------------------------
>Using Tomcat but need to do more? Need to support web
services, security?
>Get stuff done quickly with pre-integrated technology
to make your job easier
>Download IBM WebSphere Application Server v.1.0.1
based on Apache Geronimo
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>_______________________________________________
>Mvpmc-users mailing list
>[email protected]
>https://lists.sourceforge.net/lists/listinfo/mvpmc-users
>mvpmc wiki: http://mvpmc.wikispaces.com/
>
-------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support
> web services, security?
> Get stuff done quickly with pre-integrated
> technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1
> based on Apache Geronimo
>
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642>
_______________________________________________
> Mvpmc-users mailing list
> [email protected]
>
https://lists.sourceforge.net/lists/listinfo/mvpmc-users
> mvpmc wiki: http://mvpmc.wikispaces.com/
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Mvpmc-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mvpmc-users
mvpmc wiki: http://mvpmc.wikispaces.com/
