[mythtv] Backend AutoDiscovery

[spam]

Rob Smith wrote:
> On 9/15/07, spam <spam at sma2.rain.com> wrote:
>   
>> With only one mysql password you are giving every remote station full
>> admin access to mythconverg. With mysql auth is possible to only grant
>> "DROP,GRANT,SET PASSWORD, ..." to secure hosts and not every wireless
>> laptop.
>>     
>
> you can have multiple entries for a single user/password that is for a
> single host.
>
> You can have
>
> Host User Pass
> 192.168.1.1 mythtv mythtv
> 194.524.5.3 mythtv mythtv
>
> without giving it to 'every wireless laptop'
>
> ~Rob
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>   
If distinct "host user password" sets are passed from the frontends to 
the mysql server to gain access (current model) that's good. I don't 
think it's a good idea to have the PIN return one access set for 
everybody because the first thing mc.sql does is GRANT ALL for "mythtv 
mythtv" and so do the remote access examples. It's easy to have 
user/password sets with lower/read-only access to the database. With 
dynamic DHCP handing out random IPs, per host access can get tricky for 
remote access.