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/
