Jeang, David - ARS | 27 Jul 2012 22:01
Favicon

Re: establishing chado connections


Scott, I said before it WAS a permission problem and it was solved...

David Jeang
-----Original Message-----
From: Scott Cain [mailto:scott@...]
Sent: Friday, July 27, 2012 2:28 PM
To: Raymond Wan
Cc: Jeang, David - ARS; gmod-gbrowse@...
Subject: Re: [Gmod-gbrowse] establishing chado connections

Hi Ray,

Thanks, though in this case I don't think that is the problem.  The error message was that it couldn't find cv,
not that it had a permission problem.

Scott

On Fri, Jul 27, 2012 at 1:32 PM, Raymond Wan <rwan@...> wrote:
>
> Hi Scott/David,
>
> It's been a while ago, but for what it's worth, when I set up GBrowse
> + Chado, cv was one of the tables (perhaps the only table) which
> didn't have permissions granted to it.  I had to grant the permissions
> manually.  I never investigated what the reason was, though.
>
> Ray
>
>
(Continue reading)

Scott Cain | 27 Jul 2012 22:13
Favicon

Re: establishing chado connections

Oh <blush> forgot that you wrote that.  Thanks for pointing it out.

Scott

On Fri, Jul 27, 2012 at 4:01 PM, Jeang, David - ARS
<David.Jeang@...> wrote:
>
> Scott, I said before it WAS a permission problem and it was solved...
>
> David Jeang
> -----Original Message-----
> From: Scott Cain [mailto:scott@...]
> Sent: Friday, July 27, 2012 2:28 PM
> To: Raymond Wan
> Cc: Jeang, David - ARS; gmod-gbrowse@...
> Subject: Re: [Gmod-gbrowse] establishing chado connections
>
> Hi Ray,
>
> Thanks, though in this case I don't think that is the problem.  The error message was that it couldn't find
cv, not that it had a permission problem.
>
> Scott
>
>
> On Fri, Jul 27, 2012 at 1:32 PM, Raymond Wan <rwan@...> wrote:
>>
>> Hi Scott/David,
>>
>> It's been a while ago, but for what it's worth, when I set up GBrowse
(Continue reading)

shu ms | 28 Jul 2012 03:30
Picon

Re: establishing chado connections

Hi,

May I know is it the chado is another option for mysql database?

If yes, which one better?

i have upload the seq into mysql but it doesnt appear when i click the gene....

thank you




On Sat, Jul 28, 2012 at 4:13 AM, Scott Cain <scott-XkniDE3L5z0cWVvVuXF20w@public.gmane.org> wrote:
Oh <blush> forgot that you wrote that.  Thanks for pointing it out.

Scott


On Fri, Jul 27, 2012 at 4:01 PM, Jeang, David - ARS
<David.Jeang-yPPU2dwoW2ufRvmTrFJqzg@public.gmane.org> wrote:
>
> Scott, I said before it WAS a permission problem and it was solved...
>
> David Jeang
> -----Original Message-----
> From: Scott Cain [mailto:scott <at> scottcain.net]
> Sent: Friday, July 27, 2012 2:28 PM
> To: Raymond Wan
> Cc: Jeang, David - ARS; gmod-gbrowse-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> Subject: Re: [Gmod-gbrowse] establishing chado connections
>
> Hi Ray,
>
> Thanks, though in this case I don't think that is the problem.  The error message was that it couldn't find cv, not that it had a permission problem.
>
> Scott
>
>
> On Fri, Jul 27, 2012 at 1:32 PM, Raymond Wan <rwan-0/wyVZ4TESw+M+u0nzDfMQ@public.gmane.org> wrote:
>>
>> Hi Scott/David,
>>
>> It's been a while ago, but for what it's worth, when I set up GBrowse
>> + Chado, cv was one of the tables (perhaps the only table) which
>> didn't have permissions granted to it.  I had to grant the permissions
>> manually.  I never investigated what the reason was, though.
>>
>> Ray
>>
>>
>> On Thursday, July 26, 2012 11:49 PM, Scott Cain wrote:> Hi David,
>>>
>>> I agree that using ALTER USER should do the trick.  What happens when
>>> you use the psql shell on the command line as that user?  You could
>>> try a simple query like SELECT
>>> count(*) FROM cv; to see if it finds the cv table.  If that appears
>>> to work, we should ask on the tripal mailing list, since they more
>>> experience with this sort of thing.
>>>
>>> Scott
>>
>>
>> -------------------------------------------------
>> This e-mail is sent by CUHK WebMail http://webmail.cuhk.edu.hk
>>
>
>
>
> --
> ------------------------------------------------------------------------
> Scott Cain, Ph. D.                                   scott at scottcain dot net
> GMOD Coordinator (http://gmod.org/)                     216-392-3087
> Ontario Institute for Cancer Research
>
>
>
>
>
> This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.
>



--
------------------------------------------------------------------------
Scott Cain, Ph. D.                                   scott at scottcain dot net
GMOD Coordinator (http://gmod.org/)                     216-392-3087
Ontario Institute for Cancer Research

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse-5NWGOfrQmnc@public.gmane.orgurceforge.net
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse



--
Shuhaila Binti Mat Sharani
BSc (Hons) Bioinformatics
Graduate Student
Universiti Kebangsaan Malaysia
43600 Bangi
Selangor, Malaysia.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
Raymond Wan | 28 Jul 2012 07:16
Picon
Favicon

Re: establishing chado connections


Hi,

Quoting shu ms <shuhaila129@...>:

> May I know is it the chado is another option for mysql database?
> 
> If yes, which one better?

Chado is a database schema; MySQL is a DBMS (database management system).  A
database schema specifies how the data is stored (what tables are there and how
the tables relate to each other).  A DBMS such as MySQL is a program that
creates tables (etc.) according to a schema for storing data.

So, they aren't the same and, actually, work together.  You can replace MySQL
with another DBMS such as PostgreSQL.  You can also replace Chado with
something else (though I have never tried).

I don't know if this is up to date, but this gives a summary of your choices:

http://gmod.org/wiki/GBrowse#About_Databases

IMHO, getting Chado to work is a bit complex.  But if you are using something
else and the "con" in that table bothers you, then it might be worth trying
another option such as Chado.

If you're new to GBrowse, I'd pick the option with the most help documentation
and when you've got it figured out, then try the options you would have wanted
to try.  :-)

> i have upload the seq into mysql but it doesnt appear when i click the
> gene....

That sounds like a problem with something else such as how GBrowse is connected
to your database.  If you can load sequences fine but are unable to click on
genes, it is possible you haven't loaded the gene annotations yet?

Ray

-------------------------------------------------
This e-mail is sent by CUHK WebMail http://webmail.cuhk.edu.hk

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Scott Cain | 29 Jul 2012 21:26
Favicon

Re: establishing chado connections

Hi Ray and Shuhaila,

Ray, thanks for the excellent summary.  I would agree that Chado would
not be the first choice when using GBrowse unless you had a good
reason to be using Chado for other things as well.  Additionally, we
don't support Chado with MySQL.  Finally, I agree with Ray that the
problem associated with upload difficulties is almost certainly not
related to what database schema you are using; it is more likely a
problem related to file and directory permissions, or something
misconfigured in the GBrowse conf file.

Scott

On 7/28/12, Raymond Wan <rwan@...> wrote:
>
> Hi,
>
>
> Quoting shu ms <shuhaila129@...>:
>
>> May I know is it the chado is another option for mysql database?
>>
>> If yes, which one better?
>
>
> Chado is a database schema; MySQL is a DBMS (database management system).
> A
> database schema specifies how the data is stored (what tables are there and
> how
> the tables relate to each other).  A DBMS such as MySQL is a program that
> creates tables (etc.) according to a schema for storing data.
>
> So, they aren't the same and, actually, work together.  You can replace
> MySQL
> with another DBMS such as PostgreSQL.  You can also replace Chado with
> something else (though I have never tried).
>
> I don't know if this is up to date, but this gives a summary of your
> choices:
>
> http://gmod.org/wiki/GBrowse#About_Databases
>
> IMHO, getting Chado to work is a bit complex.  But if you are using
> something
> else and the "con" in that table bothers you, then it might be worth trying
> another option such as Chado.
>
> If you're new to GBrowse, I'd pick the option with the most help
> documentation
> and when you've got it figured out, then try the options you would have
> wanted
> to try.  :-)
>
>
>> i have upload the seq into mysql but it doesnt appear when i click the
>> gene....
>
>
> That sounds like a problem with something else such as how GBrowse is
> connected
> to your database.  If you can load sequences fine but are unable to click
> on
> genes, it is possible you haven't loaded the gene annotations yet?
>
> Ray
>
>
>
>
> -------------------------------------------------
> This e-mail is sent by CUHK WebMail http://webmail.cuhk.edu.hk
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Gmod-gbrowse mailing list
> Gmod-gbrowse@...
> https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
>

--

-- 
------------------------------------------------------------------------
Scott Cain, Ph. D.                                   scott at scottcain dot net
GMOD Coordinator (http://gmod.org/)                     216-392-3087
Ontario Institute for Cancer Research

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Raymond Wan | 30 Jul 2012 18:17
Picon
Favicon

Re: establishing chado connections


Hi Scott,

Quoting Scott Cain <scott@...>:

> Ray, thanks for the excellent summary.  I would agree that Chado would
> not be the first choice when using GBrowse unless you had a good
> reason to be using Chado for other things as well.  Additionally, we
> don't support Chado with MySQL.  Finally, I agree with Ray that the

Thanks!  Actually, I didn't know that Chado didn't work with MySQL.  I used
PostgreSQL with Chado and I thought my choice was 'arbitrary'.  Thanks for
mentioning this explicitly or else I wouldn't have known/noticed!

Ray

-------------------------------------------------
This e-mail is sent by CUHK WebMail http://webmail.cuhk.edu.hk

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Jeang, David - ARS | 1 Aug 2012 21:55
Favicon

establishing chado connections: Working out the tracks in conf

My Gbrowse is now officially connected to the chado database, extracting the data with conf tracks is
taking a little effort to get through.

I've started off with a simple track:

[CG12567]
feature      = mRNA
glyph        = span
height       = 5
description  = 1
key          = CG12567

After finally removing all permission problems from the database and its functions, I'm now left with a
blank browser and the error log says:

[Wed Aug 01 12:01:53 2012] [error] [client 10.12.20.67] Use of uninitialized value in subtraction (-) at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/Render/HTML.pm
line 2025., referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
[Wed Aug 01 12:01:53 2012] [error] [client 10.12.20.67] Can't locate object method "score" via package
"Bio::DB::Das::Chado::Segment" at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Karyotype.pm line
362., referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
[Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] , referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
[Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] 11 12 13 76, referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
[Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] , referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
[Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of uninitialized value in join or string at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/Region.pm
line 385., referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
[Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of uninitialized value in join or string at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/RegionSearch.pm
line 314., referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
[Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of uninitialized value in join or string at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/Region.pm
line 167., referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/

I'm a little stumped on where to go from here. Any suggestions?

David Jeang

This electronic message contains information generated by the USDA solely for the intended recipients.
Any unauthorized interception of this message or the use or disclosure of the information it contains may
violate the law and subject the violator to civil or criminal penalties. If you believe you have received
this message in error, please notify the sender and delete the email immediately.

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Scott Cain | 1 Aug 2012 22:47
Favicon

Re: establishing chado connections: Working out the tracks in conf

Hi David,

Many times the "uninit in a subtraction" is due to not having a
properly defined reference sequence.  What does the GFF look like that
defines the chromosome and the mRNA features?

Scott

On Wed, Aug 1, 2012 at 3:55 PM, Jeang, David - ARS
<David.Jeang@...> wrote:
> My Gbrowse is now officially connected to the chado database, extracting the data with conf tracks is
taking a little effort to get through.
>
> I've started off with a simple track:
>
> [CG12567]
> feature      = mRNA
> glyph        = span
> height       = 5
> description  = 1
> key          = CG12567
>
> After finally removing all permission problems from the database and its functions, I'm now left with a
blank browser and the error log says:
>
> [Wed Aug 01 12:01:53 2012] [error] [client 10.12.20.67] Use of uninitialized value in subtraction (-) at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/Render/HTML.pm
line 2025., referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:01:53 2012] [error] [client 10.12.20.67] Can't locate object method "score" via package
"Bio::DB::Das::Chado::Segment" at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Karyotype.pm line
362., referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] , referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] 11 12 13 76, referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] , referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of uninitialized value in join or string at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/Region.pm
line 385., referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of uninitialized value in join or string at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/RegionSearch.pm
line 314., referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of uninitialized value in join or string at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/Region.pm
line 167., referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
>
>
> I'm a little stumped on where to go from here. Any suggestions?
>
> David Jeang
>
>
>
>
> This electronic message contains information generated by the USDA solely for the intended recipients.
Any unauthorized interception of this message or the use or disclosure of the information it contains may
violate the law and subject the violator to civil or criminal penalties. If you believe you have received
this message in error, please notify the sender and delete the email immediately.
>

--

-- 
------------------------------------------------------------------------
Scott Cain, Ph. D.                                   scott at scottcain dot net
GMOD Coordinator (http://gmod.org/)                     216-392-3087
Ontario Institute for Cancer Research

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Jeang, David - ARS | 2 Aug 2012 17:44
Favicon

Re: establishing chado connections: Working out the tracks in conf

How would I go about finding the gffs? In my schema, I have tables, views, sequences, and functions.

Is there a SQL command I can use on the tripal database?

David Jeang

-----Original Message-----
From: Scott Cain [mailto:scott@...] 
Sent: Wednesday, August 01, 2012 4:48 PM
To: Jeang, David - ARS
Cc: gmod-gbrowse@...
Subject: Re: establishing chado connections: Working out the tracks in conf

Hi David,

Many times the "uninit in a subtraction" is due to not having a properly defined reference sequence.  What
does the GFF look like that defines the chromosome and the mRNA features?

Scott

On Wed, Aug 1, 2012 at 3:55 PM, Jeang, David - ARS
<David.Jeang@...> wrote:
> My Gbrowse is now officially connected to the chado database, extracting the data with conf tracks is
taking a little effort to get through.
>
> I've started off with a simple track:
>
> [CG12567]
> feature      = mRNA
> glyph        = span
> height       = 5
> description  = 1
> key          = CG12567
>
> After finally removing all permission problems from the database and its functions, I'm now left with a
blank browser and the error log says:
>
> [Wed Aug 01 12:01:53 2012] [error] [client 10.12.20.67] Use of 
> uninitialized value in subtraction (-) at 
> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphic
> s/Browser2/Render/HTML.pm line 2025., referer: 
> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:01:53 2012] [error] [client 10.12.20.67] Can't locate 
> object method "score" via package "Bio::DB::Das::Chado::Segment" at 
> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphic
> s/Karyotype.pm line 362., referer: 
> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] , referer: 
> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] 11 12 13 76, 
> referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] , referer: 
> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of 
> uninitialized value in join or string at 
> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphic
> s/Browser2/Region.pm line 385., referer: 
> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of 
> uninitialized value in join or string at 
> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphic
> s/Browser2/RegionSearch.pm line 314., referer: 
> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of 
> uninitialized value in join or string at 
> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphic
> s/Browser2/Region.pm line 167., referer: 
> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
>
>
> I'm a little stumped on where to go from here. Any suggestions?
>
> David Jeang
>
>
>
>
> This electronic message contains information generated by the USDA solely for the intended recipients.
Any unauthorized interception of this message or the use or disclosure of the information it contains may
violate the law and subject the violator to civil or criminal penalties. If you believe you have received
this message in error, please notify the sender and delete the email immediately.
>

--
------------------------------------------------------------------------
Scott Cain, Ph. D.                                   scott at scottcain dot net
GMOD Coordinator (http://gmod.org/)                     216-392-3087
Ontario Institute for Cancer Research

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Scott Cain | 2 Aug 2012 19:05
Favicon

Re: establishing chado connections: Working out the tracks in conf

Hi David,

How did you originally load the database?  The typical way is to use
GFF and a loader, either the one that comes with Tripal or the one
that comes with Chado.

Scott

On Thu, Aug 2, 2012 at 11:44 AM, Jeang, David - ARS
<David.Jeang@...> wrote:
> How would I go about finding the gffs? In my schema, I have tables, views, sequences, and functions.
>
> Is there a SQL command I can use on the tripal database?
>
> David Jeang
>
> -----Original Message-----
> From: Scott Cain [mailto:scott@...]
> Sent: Wednesday, August 01, 2012 4:48 PM
> To: Jeang, David - ARS
> Cc: gmod-gbrowse@...
> Subject: Re: establishing chado connections: Working out the tracks in conf
>
> Hi David,
>
> Many times the "uninit in a subtraction" is due to not having a properly defined reference sequence.  What
does the GFF look like that defines the chromosome and the mRNA features?
>
> Scott
>
>
> On Wed, Aug 1, 2012 at 3:55 PM, Jeang, David - ARS
<David.Jeang@...> wrote:
>> My Gbrowse is now officially connected to the chado database, extracting the data with conf tracks is
taking a little effort to get through.
>>
>> I've started off with a simple track:
>>
>> [CG12567]
>> feature      = mRNA
>> glyph        = span
>> height       = 5
>> description  = 1
>> key          = CG12567
>>
>> After finally removing all permission problems from the database and its functions, I'm now left with a
blank browser and the error log says:
>>
>> [Wed Aug 01 12:01:53 2012] [error] [client 10.12.20.67] Use of
>> uninitialized value in subtraction (-) at
>> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphic
>> s/Browser2/Render/HTML.pm line 2025., referer:
>> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
>> [Wed Aug 01 12:01:53 2012] [error] [client 10.12.20.67] Can't locate
>> object method "score" via package "Bio::DB::Das::Chado::Segment" at
>> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphic
>> s/Karyotype.pm line 362., referer:
>> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
>> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] , referer:
>> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
>> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] 11 12 13 76,
>> referer: http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
>> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] , referer:
>> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
>> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of
>> uninitialized value in join or string at
>> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphic
>> s/Browser2/Region.pm line 385., referer:
>> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
>> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of
>> uninitialized value in join or string at
>> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphic
>> s/Browser2/RegionSearch.pm line 314., referer:
>> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
>> [Wed Aug 01 12:02:34 2012] [error] [client 10.12.20.67] Use of
>> uninitialized value in join or string at
>> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphic
>> s/Browser2/Region.pm line 167., referer:
>> http://i5k.nal.usda.gov/cgi-bin/gb2/gbrowse/chado/
>>
>>
>> I'm a little stumped on where to go from here. Any suggestions?
>>
>> David Jeang
>>
>>
>>
>>
>> This electronic message contains information generated by the USDA solely for the intended
recipients. Any unauthorized interception of this message or the use or disclosure of the information it
contains may violate the law and subject the violator to civil or criminal penalties. If you believe you
have received this message in error, please notify the sender and delete the email immediately.
>>
>
>
>
> --
> ------------------------------------------------------------------------
> Scott Cain, Ph. D.                                   scott at scottcain dot net
> GMOD Coordinator (http://gmod.org/)                     216-392-3087
> Ontario Institute for Cancer Research
>
>

--

-- 
------------------------------------------------------------------------
Scott Cain, Ph. D.                                   scott at scottcain dot net
GMOD Coordinator (http://gmod.org/)                     216-392-3087
Ontario Institute for Cancer Research

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Jeang, David - ARS | 9 Aug 2012 18:02
Favicon

Missing Digest:SHA

Gbrowse was working last week, and now I have an error.

Can't locate loadable object for module Digest::SHA in  <at> INC ( <at> INC contains:
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8
/usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/SendMail.pm
line 8.

But I do have Digest::SHA installed. I even remaked, but still nothing. Does anyone know what's up?

David Jeang

This electronic message contains information generated by the USDA solely for the intended recipients.
Any unauthorized interception of this message or the use or disclosure of the information it contains may
violate the law and subject the violator to civil or criminal penalties. If you believe you have received
this message in error, please notify the sender and delete the email immediately.

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Lincoln Stein | 9 Aug 2012 18:16
Picon
Gravatar

Re: Missing Digest:SHA

I don't know what's up. Any chance that one of the directories in the <at> INC library path has had its permissions changed such that GBrowse can't access it when running as the web server user? Try sudoing to the web server user and loading the module:


 sudo -u www-data perl -MDigest::SHA -e 'print "loaded ok\n"'

If this fails, then it is a good indication that you have a permissions problem.

Lincoln

On Thu, Aug 9, 2012 at 12:02 PM, Jeang, David - ARS <David.Jeang-yPPU2dwoW2ufRvmTrFJqzg@public.gmane.org> wrote:
Gbrowse was working last week, and now I have an error.

Can't locate loadable object for module Digest::SHA in <at> INC ( <at> INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/SendMail.pm line 8.

But I do have Digest::SHA installed. I even remaked, but still nothing. Does anyone know what's up?

David Jeang




This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse-5NWGOfrQmnc@public.gmane.orgurceforge.net
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse



--
Lincoln D. Stein
Director, Informatics and Biocomputing Platform
Ontario Institute for Cancer Research
101 College St., Suite 800
Toronto, ON, Canada M5G0A3
416 673-8514
Assistant: Renata Musa <Renata.Musa-O2sQSXo6EZOw5LPnMra/2Q@public.gmane.org>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
Jeang, David - ARS | 9 Aug 2012 19:12
Favicon

Re: Missing Digest:SHA

Uh, it says unknown user www-data. What should I put instead?

 

David Jeang

 

From: Lincoln Stein [mailto:lincoln.stein-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org]
Sent: Thursday, August 09, 2012 12:16 PM
To: Jeang, David - ARS
Cc: gmod-gbrowse-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject: Re: [Gmod-gbrowse] Missing Digest:SHA

 

I don't know what's up. Any chance that one of the directories in the <at> INC library path has had its permissions changed such that GBrowse can't access it when running as the web server user? Try sudoing to the web server user and loading the module:

 

 sudo -u www-data perl -MDigest::SHA -e 'print "loaded ok\n"'

 

If this fails, then it is a good indication that you have a permissions problem.

 

Lincoln

On Thu, Aug 9, 2012 at 12:02 PM, Jeang, David - ARS <David.Jeang-yPPU2dwoW2ufRvmTrFJqzg@public.gmane.org> wrote:

Gbrowse was working last week, and now I have an error.

Can't locate loadable object for module Digest::SHA in <at> INC ( <at> INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/SendMail.pm line 8.

But I do have Digest::SHA installed. I even remaked, but still nothing. Does anyone know what's up?

David Jeang




This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse-5NWGOfrQmnc@public.gmane.orgurceforge.net
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse



 

--
Lincoln D. Stein
Director, Informatics and Biocomputing Platform
Ontario Institute for Cancer Research
101 College St., Suite 800
Toronto, ON, Canada M5G0A3
416 673-8514
Assistant: Renata Musa <Renata.Musa-O2sQSXo6EZOw5LPnMra/2Q@public.gmane.org>

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
Lincoln Stein | 9 Aug 2012 19:33
Picon
Gravatar

Re: Missing Digest:SHA

For the purposes of the mailing list (since you found and fixed the problem using a different tack), "www-data" should be replaced by the name of the account under which the web server runs.


Lincoln

On Thu, Aug 9, 2012 at 1:12 PM, Jeang, David - ARS <David.Jeang-yPPU2dwoW2ufRvmTrFJqzg@public.gmane.org> wrote:

Uh, it says unknown user www-data. What should I put instead?

 

David Jeang

 

From: Lincoln Stein [mailto:lincoln.stein-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org]
Sent: Thursday, August 09, 2012 12:16 PM
To: Jeang, David - ARS
Cc: gmod-gbrowse-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject: Re: [Gmod-gbrowse] Missing Digest:SHA

 

I don't know what's up. Any chance that one of the directories in the <at> INC library path has had its permissions changed such that GBrowse can't access it when running as the web server user? Try sudoing to the web server user and loading the module:

 

 sudo -u www-data perl -MDigest::SHA -e 'print "loaded ok\n"'

 

If this fails, then it is a good indication that you have a permissions problem.

 

Lincoln

On Thu, Aug 9, 2012 at 12:02 PM, Jeang, David - ARS <David.Jeang-yPPU2dwoW2ufRvmTrFJqzg@public.gmane.org> wrote:

Gbrowse was working last week, and now I have an error.

Can't locate loadable object for module Digest::SHA in <at> INC ( <at> INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/SendMail.pm line 8.

But I do have Digest::SHA installed. I even remaked, but still nothing. Does anyone know what's up?

David Jeang




This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse



 

--
Lincoln D. Stein
Director, Informatics and Biocomputing Platform
Ontario Institute for Cancer Research
101 College St., Suite 800
Toronto, ON, Canada M5G0A3
416 673-8514
Assistant: Renata Musa <Renata.Musa-O2sQSXo6EZOw5LPnMra/2Q@public.gmane.org>


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse-5NWGOfrQmnc@public.gmane.orgurceforge.net
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse




--
Lincoln D. Stein
Director, Informatics and Biocomputing Platform
Ontario Institute for Cancer Research
101 College St., Suite 800
Toronto, ON, Canada M5G0A3
416 673-8514
Assistant: Renata Musa <Renata.Musa-O2sQSXo6EZOw5LPnMra/2Q@public.gmane.org>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
Jeang, David - ARS | 9 Aug 2012 19:21
Favicon

Re: Missing Digest:SHA

Nevermind, a library was missing and fixed. Working again.

 

David Jeang

 

From: Lincoln Stein [mailto:lincoln.stein-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org]
Sent: Thursday, August 09, 2012 12:16 PM
To: Jeang, David - ARS
Cc: gmod-gbrowse-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject: Re: [Gmod-gbrowse] Missing Digest:SHA

 

I don't know what's up. Any chance that one of the directories in the <at> INC library path has had its permissions changed such that GBrowse can't access it when running as the web server user? Try sudoing to the web server user and loading the module:

 

 sudo -u www-data perl -MDigest::SHA -e 'print "loaded ok\n"'

 

If this fails, then it is a good indication that you have a permissions problem.

 

Lincoln

On Thu, Aug 9, 2012 at 12:02 PM, Jeang, David - ARS <David.Jeang-yPPU2dwoW2ufRvmTrFJqzg@public.gmane.org> wrote:

Gbrowse was working last week, and now I have an error.

Can't locate loadable object for module Digest::SHA in <at> INC ( <at> INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bio/Graphics/Browser2/SendMail.pm line 8.

But I do have Digest::SHA installed. I even remaked, but still nothing. Does anyone know what's up?

David Jeang




This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse-5NWGOfrQmnc@public.gmane.orgurceforge.net
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse



 

--
Lincoln D. Stein
Director, Informatics and Biocomputing Platform
Ontario Institute for Cancer Research
101 College St., Suite 800
Toronto, ON, Canada M5G0A3
416 673-8514
Assistant: Renata Musa <Renata.Musa-O2sQSXo6EZOw5LPnMra/2Q@public.gmane.org>

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Gmane