[Gmod-help] Re: [Gmod-gbrowse] INSERT command denied on Reset, GBrowse 2

[Tom Conlin]

Hi Dave

I never did find a design document
but if someone knows if this interpretation is wrong
(perhaps over constrained) I would like to hear about it

http://ix.cs.uoregon.edu/~tomc/schemaSpy_gff/relationships.html

However, a static portrait does nothing to suggest
why gbrowse would be exhibiting quantum effects in use.

Tom

(that link does have a half life)

Dave Clements, GMOD Help Desk wrote:
> Hi Neil,
> 
> I can't find any explanation of what is going on here either.  As I
> read the documentation, I don't think that GBrowse should require
> insert access at run time either.
> 
> Does anyone on the list know if there is design documentation anywhere
> for the database schema used by SeqFeature::Store?  That might help
> solve the mystery.
> 
> Dave C.
> 
> On Thu, Sep 10, 2009 at 10:45 PM, Neil Saunders <neilfws at gmail.com> wrote:
>> Just noticed something new on a GBrowse 2 installation (CVS, SVN
>> Bioperl, Ubuntu 9.04, Apache 2.2.11, MySQL 5.0.75).
>>
>> Clicking the 'reset' link gives an incompletely rendered initial display
>> and this error in the Apache log:
>>
>> INSERT command denied to user 'genome'@'localhost' for table
>> 'locationlist' at
>> /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 1466.
>>
>> My impression was that the MySQL user needs only SELECT privilege. Why
>> is this INSERT appearing?
>>
>> thanks
>> Neil Saunders
>> --
>>  Statistical Bioinformatics - Health
>>  CSIRO Mathematical and Information Sciences
>>  Locked Bag 17, North Ryde, NSW 1670, Australia
>>
>> http://friendfeed.com/neilfws
>>
>> ------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
>> trial. Simplify your report design, integration and deployment - and focus on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> Gmod-gbrowse mailing list
>> Gmod-gbrowse at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
>>
> 
> 
> 

-- 
           ... nice weather     eh          tomc at cs.uoregon.edu