I believe that you need write permission if you want to use all the features available such as scheduling recordings.
Joel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Metro Sent: Thursday, May 03, 2007 5:38 PM To: L-mvpmc-users Subject: Re: [Mvpmc-users] SQL access Mark Smith wrote: > There seems to be some features (e.g. New Live TV) that require direct access > to the MythTV MySQL database. ... > Is it not (easily) possible to provide the functionality using the Myth > protocol? When I was looking into documenting the command line settings, I asked some similar questions and didn't get any answers as to what features make use of the direct database connection and why it is needed. > I realise that this can be done by granting > access to the necessary tables, but what I'm not sure is: > > *What tables it requires access to > *What username mvpmc runs as (root?) > *What password it will use to access the database I believe you'll need to specify these items as command line options, as documented here: http://mvpmc.wikispaces.com/commandline You don't specify specific tables, but the name of the database, instead. If you're curious as to what tables mvpmc happens to access, you'll need to examine the source. The user name and password credentials used my mvpmc should be the same as those used my MythTV. You'll typically find those in the file /etc/mythtv/mysql.txt. If you wanted to boost security, you could create a new MySQL user specifically for mvpmc and grant it read-only access to the MythTV database. (I assume mvpmc doesn't write to the database.) -Tom ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Mvpmc-users mailing list Mvpmc-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mvpmc-users mvpmc wiki: http://mvpmc.wikispaces.com/ ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Mvpmc-users mailing list Mvpmc-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mvpmc-users mvpmc wiki: http://mvpmc.wikispaces.com/
