[Gmod-help] Re: [Gmod-gbrowse] mysql permissions

[Keiran Raine]

Hi all,

I've just received this error also, what does not quite make sense is  
that this was not occurring under 1.99x of gBrowse and I have not  
changed the mysql db since then, just the gBrowse install to 2.00.

Regards,

Keiran Raine
Senior Computer Biologist
The Cancer Genome Project
Ext: 2100
kr2 at sanger.ac.uk

The Wellcome Trust Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.



On 5 Feb 2010, at 23:52, Dave Clements, GMOD Help Desk wrote:

> Hi Andreas,
>
> If this reappears, see
> http://article.gmane.org/gmane.science.biology.gmod.gbrowse/3163/match=insert+command+denied+reset+gbrowse+2
> for a possible explanation and fix.
>
> Dave C
>
> On Thu, Feb 4, 2010 at 7:38 AM, Andreas Kuntzagk
> <andreas.kuntzagk at mdc-berlin.de> wrote:
>> Hi,
>>
>> the problem just disappeared. Don't know why or how. This is  
>> annoying!
>>
>> Andreas
>>
>> Andreas Kuntzagk wrote:
>>> Hi,
>>>
>>> I got another problem (Gbrowse tries to drive me insane I think):
>>> When I switch on an additional database GBrowse complains that it  
>>> needs
>>> "INSERT" rights. I'd rather not do this.
>>> What makes this even more interesting is that other users don't  
>>> see this
>>> error.
>>>
>>> [Thu Feb 04 12:45:11 2010] [error] [client 141.80.188.52] INSERT  
>>> command
>>> denied to user 'wwwuser'@'localhost' for table 'locationlist' at
>>> /usr/local/share/perl/5.8.8/Bio/DB/SeqFeature/Store/DBI/mysql.pm  
>>> line
>>> 1466., referer:
>>> http://bbc/cgi-bin//gbrowse/smed_test/?name=id:114005;dbid=scaffolds:database
>>>
>>>
>>> regards, Andreas
>>>
>>> ------------------------------------------------------------------------------
>>> The Planet: dedicated and managed hosting, cloud storage, colocation
>>> Stay online with enterprise data centers and the best network in  
>>> the business
>>> Choose flexible plans and management services without long-term  
>>> contracts
>>> Personal 24x7 support from experience hosting pros just a phone  
>>> call away.
>>> http://p.sf.net/sfu/theplanet-com
>>> _______________________________________________
>>> Gmod-gbrowse mailing list
>>> Gmod-gbrowse at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
>>
>>
>> ------------------------------------------------------------------------------
>> The Planet: dedicated and managed hosting, cloud storage, colocation
>> Stay online with enterprise data centers and the best network in  
>> the business
>> Choose flexible plans and management services without long-term  
>> contracts
>> Personal 24x7 support from experience hosting pros just a phone  
>> call away.
>> http://p.sf.net/sfu/theplanet-com
>> _______________________________________________
>> Gmod-gbrowse mailing list
>> Gmod-gbrowse at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
>>
>
>
>
> -- 
> Please keep responses on the list!
> http://gmod.org/wiki/2010_GMOD_Summer_School_-_Americas
> http://gmod.org/wiki/GMOD_News
> Was this helpful? http://gmod.org/wiki/Help_Desk_Feedback
>
> ------------------------------------------------------------------------------
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the  
> business
> Choose flexible plans and management services without long-term  
> contracts
> Personal 24x7 support from experience hosting pros just a phone call  
> away.
> http://p.sf.net/sfu/theplanet-com
> _______________________________________________
> Gmod-gbrowse mailing list
> Gmod-gbrowse at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse



-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.