problems loading data into MySQL db

View: New views
20 Messages — Rating Filter:   Alert me  
< Prev | 1 - 2 | Next >

problems loading data into MySQL db

by Lacey Sanderson :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I have set up gbrowse on Ubuntu Intrepid. When I try to add my data to  
the database using bp_seqfeature_load I get an access denied error  
even though I have granted permission to that user. Any ideas what  
might be causing this?

Thanks,
Lacey

This is what I have done:
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -u  
root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.0.67-0ubuntu6 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all privileges on Medicago.* to dbadmin@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on Medicago.* to nobody@localhost;
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye

dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ls
attributes.idx  chr01_1_33214707.gff3  features.bdb  indexes  
locations.idx  names.idx  notes.idx  parentage.bdb  types.idx

dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$  
bp_seqfeature_load.pl -c -f -d Medicago ./ chr01_1_33214707.gff3
loading ./...

Building object tree... 0.00s
Loading bulk data into database...DBD::mysql::db do failed: Access  
denied for user 'dbadmin'@'localhost' (using password: NO) at /usr/
local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 510.

-------------------- EXCEPTION --------------------
MSG: Access denied for user 'dbadmin'@'localhost' (using password: NO)
STACK Bio::DB::SeqFeature::Store::DBI::mysql::_finish_bulk_update /usr/
local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:510
STACK Bio::DB::SeqFeature::Store::finish_bulk_update /usr/local/share/
perl/5.10.0/Bio/DB/SeqFeature/Store.pm:1300
STACK Bio::DB::SeqFeature::Store::GFF3Loader::finish_load /usr/local/
share/perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:378
STACK Bio::DB::SeqFeature::Store::GFF3Loader::load_fh /usr/local/share/
perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:345
STACK Bio::DB::SeqFeature::Store::GFF3Loader::load /usr/local/share/
perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:242
STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:81
-------------------------------------------

dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$  
bp_seqfeature_load.pl -c -f -p **** -d Medicago ./ chr01_1_33214707.gff3
DBI connect('Medicago','',...) failed: Access denied for user  
'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/
5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
Can't call method "do" on an undefined value at /usr/local/share/perl/
5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.

dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -u  
root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 5.0.67-0ubuntu6 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all privileges on Medicago.* to 'dbadmin'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$  
bp_seqfeature_load.pl -c -f -p **** -d Medicago ./ chr01_1_33214707.gff3
DBI connect('Medicago','',...) failed: Access denied for user  
'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/
5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
Can't call method "do" on an undefined value at /usr/local/share/perl/
5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.





------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Lacey,

You need to grant that user file permission separately (that is, "all"
doesn't really mean "all").  See:

  http://gmod.org/wiki/GBrowse_Install_HOWTO#Populating_the_Database_.28MySQL.29

Scott


On Tue, Oct 13, 2009 at 11:50 AM, Lacey Sanderson
<laceyanne_sanderson@...> wrote:

> I have set up gbrowse on Ubuntu Intrepid. When I try to add my data to
> the database using bp_seqfeature_load I get an access denied error
> even though I have granted permission to that user. Any ideas what
> might be causing this?
>
> Thanks,
> Lacey
>
> This is what I have done:
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -u
> root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 12
> Server version: 5.0.67-0ubuntu6 (Ubuntu)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> grant all privileges on Medicago.* to dbadmin@localhost;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> grant select on Medicago.* to nobody@localhost;
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> quit
> Bye
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ls
> attributes.idx  chr01_1_33214707.gff3  features.bdb  indexes
> locations.idx  names.idx  notes.idx  parentage.bdb  types.idx
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
> bp_seqfeature_load.pl -c -f -d Medicago ./ chr01_1_33214707.gff3
> loading ./...
>
> Building object tree... 0.00s
> Loading bulk data into database...DBD::mysql::db do failed: Access
> denied for user 'dbadmin'@'localhost' (using password: NO) at /usr/
> local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 510.
>
> -------------------- EXCEPTION --------------------
> MSG: Access denied for user 'dbadmin'@'localhost' (using password: NO)
> STACK Bio::DB::SeqFeature::Store::DBI::mysql::_finish_bulk_update /usr/
> local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:510
> STACK Bio::DB::SeqFeature::Store::finish_bulk_update /usr/local/share/
> perl/5.10.0/Bio/DB/SeqFeature/Store.pm:1300
> STACK Bio::DB::SeqFeature::Store::GFF3Loader::finish_load /usr/local/
> share/perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:378
> STACK Bio::DB::SeqFeature::Store::GFF3Loader::load_fh /usr/local/share/
> perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:345
> STACK Bio::DB::SeqFeature::Store::GFF3Loader::load /usr/local/share/
> perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:242
> STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:81
> -------------------------------------------
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
> bp_seqfeature_load.pl -c -f -p **** -d Medicago ./ chr01_1_33214707.gff3
> DBI connect('Medicago','',...) failed: Access denied for user
> 'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/
> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
> Can't call method "do" on an undefined value at /usr/local/share/perl/
> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -u
> root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 18
> Server version: 5.0.67-0ubuntu6 (Ubuntu)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> grant all privileges on Medicago.* to 'dbadmin'@'localhost';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> quit
> Bye
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
> bp_seqfeature_load.pl -c -f -p **** -d Medicago ./ chr01_1_33214707.gff3
> DBI connect('Medicago','',...) failed: Access denied for user
> 'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/
> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
> Can't call method "do" on an undefined value at /usr/local/share/perl/
> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.
>
>
>
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> 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

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Lacey,

Sorry, that isn't right: I was giving advice for use with
Bio::DB::GFF.  When using a Bio::DB::SeqFeature::Store database, you
don't need to grant "file" permission.  I'm still looking into what
might be wrong.  What version of BioPerl are you using?

Scott


On Tue, Oct 13, 2009 at 1:05 PM, Scott Cain <scott@...> wrote:

> Hi Lacey,
>
> You need to grant that user file permission separately (that is, "all"
> doesn't really mean "all").  See:
>
>  http://gmod.org/wiki/GBrowse_Install_HOWTO#Populating_the_Database_.28MySQL.29
>
> Scott
>
>
> On Tue, Oct 13, 2009 at 11:50 AM, Lacey Sanderson
> <laceyanne_sanderson@...> wrote:
>> I have set up gbrowse on Ubuntu Intrepid. When I try to add my data to
>> the database using bp_seqfeature_load I get an access denied error
>> even though I have granted permission to that user. Any ideas what
>> might be causing this?
>>
>> Thanks,
>> Lacey
>>
>> This is what I have done:
>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -u
>> root -p
>> Enter password:
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 12
>> Server version: 5.0.67-0ubuntu6 (Ubuntu)
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>
>> mysql> grant all privileges on Medicago.* to dbadmin@localhost;
>> Query OK, 0 rows affected (0.00 sec)
>>
>> mysql> grant select on Medicago.* to nobody@localhost;
>> Query OK, 0 rows affected (0.01 sec)
>>
>> mysql> quit
>> Bye
>>
>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ls
>> attributes.idx  chr01_1_33214707.gff3  features.bdb  indexes
>> locations.idx  names.idx  notes.idx  parentage.bdb  types.idx
>>
>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
>> bp_seqfeature_load.pl -c -f -d Medicago ./ chr01_1_33214707.gff3
>> loading ./...
>>
>> Building object tree... 0.00s
>> Loading bulk data into database...DBD::mysql::db do failed: Access
>> denied for user 'dbadmin'@'localhost' (using password: NO) at /usr/
>> local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 510.
>>
>> -------------------- EXCEPTION --------------------
>> MSG: Access denied for user 'dbadmin'@'localhost' (using password: NO)
>> STACK Bio::DB::SeqFeature::Store::DBI::mysql::_finish_bulk_update /usr/
>> local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:510
>> STACK Bio::DB::SeqFeature::Store::finish_bulk_update /usr/local/share/
>> perl/5.10.0/Bio/DB/SeqFeature/Store.pm:1300
>> STACK Bio::DB::SeqFeature::Store::GFF3Loader::finish_load /usr/local/
>> share/perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:378
>> STACK Bio::DB::SeqFeature::Store::GFF3Loader::load_fh /usr/local/share/
>> perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:345
>> STACK Bio::DB::SeqFeature::Store::GFF3Loader::load /usr/local/share/
>> perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:242
>> STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:81
>> -------------------------------------------
>>
>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
>> bp_seqfeature_load.pl -c -f -p **** -d Medicago ./ chr01_1_33214707.gff3
>> DBI connect('Medicago','',...) failed: Access denied for user
>> 'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/
>> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
>> Can't call method "do" on an undefined value at /usr/local/share/perl/
>> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.
>>
>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -u
>> root -p
>> Enter password:
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 18
>> Server version: 5.0.67-0ubuntu6 (Ubuntu)
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>
>> mysql> grant all privileges on Medicago.* to 'dbadmin'@'localhost';
>> Query OK, 0 rows affected (0.00 sec)
>>
>> mysql> quit
>> Bye
>>
>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
>> bp_seqfeature_load.pl -c -f -p **** -d Medicago ./ chr01_1_33214707.gff3
>> DBI connect('Medicago','',...) failed: Access denied for user
>> 'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/
>> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
>> Can't call method "do" on an undefined value at /usr/local/share/perl/
>> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>> is the only developer event you need to attend this year. Jumpstart your
>> developing skills, take BlackBerry mobile applications to market and stay
>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> http://p.sf.net/sfu/devconference
>> _______________________________________________
>> 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
>



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

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Lacey,

Are you sure the password you are using for the dbadmin user is
correct?  Can you do this on the command line:

  $ mysql -u dbadmin Medicago

Scott

On Tue, Oct 13, 2009 at 11:50 AM, Lacey Sanderson
<laceyanne_sanderson@...> wrote:

> I have set up gbrowse on Ubuntu Intrepid. When I try to add my data to
> the database using bp_seqfeature_load I get an access denied error
> even though I have granted permission to that user. Any ideas what
> might be causing this?
>
> Thanks,
> Lacey
>
> This is what I have done:
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -u
> root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 12
> Server version: 5.0.67-0ubuntu6 (Ubuntu)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> grant all privileges on Medicago.* to dbadmin@localhost;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> grant select on Medicago.* to nobody@localhost;
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> quit
> Bye
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ls
> attributes.idx  chr01_1_33214707.gff3  features.bdb  indexes
> locations.idx  names.idx  notes.idx  parentage.bdb  types.idx
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
> bp_seqfeature_load.pl -c -f -d Medicago ./ chr01_1_33214707.gff3
> loading ./...
>
> Building object tree... 0.00s
> Loading bulk data into database...DBD::mysql::db do failed: Access
> denied for user 'dbadmin'@'localhost' (using password: NO) at /usr/
> local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 510.
>
> -------------------- EXCEPTION --------------------
> MSG: Access denied for user 'dbadmin'@'localhost' (using password: NO)
> STACK Bio::DB::SeqFeature::Store::DBI::mysql::_finish_bulk_update /usr/
> local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:510
> STACK Bio::DB::SeqFeature::Store::finish_bulk_update /usr/local/share/
> perl/5.10.0/Bio/DB/SeqFeature/Store.pm:1300
> STACK Bio::DB::SeqFeature::Store::GFF3Loader::finish_load /usr/local/
> share/perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:378
> STACK Bio::DB::SeqFeature::Store::GFF3Loader::load_fh /usr/local/share/
> perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:345
> STACK Bio::DB::SeqFeature::Store::GFF3Loader::load /usr/local/share/
> perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:242
> STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:81
> -------------------------------------------
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
> bp_seqfeature_load.pl -c -f -p **** -d Medicago ./ chr01_1_33214707.gff3
> DBI connect('Medicago','',...) failed: Access denied for user
> 'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/
> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
> Can't call method "do" on an undefined value at /usr/local/share/perl/
> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -u
> root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 18
> Server version: 5.0.67-0ubuntu6 (Ubuntu)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> grant all privileges on Medicago.* to 'dbadmin'@'localhost';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> quit
> Bye
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
> bp_seqfeature_load.pl -c -f -p **** -d Medicago ./ chr01_1_33214707.gff3
> DBI connect('Medicago','',...) failed: Access denied for user
> 'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/
> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
> Can't call method "do" on an undefined value at /usr/local/share/perl/
> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.
>
>
>
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> 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

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Parent Message unknown Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Lacey,

Please keep your responses on the mailing list so they can be archived.

I still don't know what is wrong: I'm using BioPerl 1.6 and MySQL 5.0  
and it is working just fine for a normal user with a password as  
described in the wiki, and just like you outlined in your email.  I'm  
not a mysql person, though.  Does anyone know if MySQL differentiates  
between connections on the command line and those coming from perl (I  
realize that is not the default thing to do, but is there a setting  
that might cause this)?  I know that PostgreSQL does, so access has to  
be granted for both.  Perhaps there is a setting for the MySQL server  
that is causing this problem.

Scott


On Oct 13, 2009, at 1:40 PM, Lacey Sanderson wrote:

> Hi Scott,
>
> Is this the information you need?
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ perl -
> MBio::Root::Version -e 'print $Bio::Root::Version::VERSION,"\n"'
> 1.005002102
>
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$  perl -
> MBio::Root::Version -e 'printf "%vd\n", $Bio::Root::Version::VERSION'
> 49.46.48.48.53.48.48.50.49.48.50
>
> Thanks!
> Lacey
>
> On 13-Oct-09, at 11:22 AM, Scott Cain wrote:
>
>> Hi Lacey,
>>
>> Sorry, that isn't right: I was giving advice for use with
>> Bio::DB::GFF.  When using a Bio::DB::SeqFeature::Store database, you
>> don't need to grant "file" permission.  I'm still looking into what
>> might be wrong.  What version of BioPerl are you using?
>>
>> Scott
>>
>>
>> On Tue, Oct 13, 2009 at 1:05 PM, Scott Cain <scott@...>  
>> wrote:
>>> Hi Lacey,
>>>
>>> You need to grant that user file permission separately (that is,  
>>> "all"
>>> doesn't really mean "all").  See:
>>>
>>>  http://gmod.org/wiki/GBrowse_Install_HOWTO#Populating_the_Database_.28MySQL.29
>>>
>>> Scott
>>>
>>>
>>> On Tue, Oct 13, 2009 at 11:50 AM, Lacey Sanderson
>>> <laceyanne_sanderson@...> wrote:
>>>> I have set up gbrowse on Ubuntu Intrepid. When I try to add my  
>>>> data to
>>>> the database using bp_seqfeature_load I get an access denied error
>>>> even though I have granted permission to that user. Any ideas what
>>>> might be causing this?
>>>>
>>>> Thanks,
>>>> Lacey
>>>>
>>>> This is what I have done:
>>>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql  
>>>> -u
>>>> root -p
>>>> Enter password:
>>>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>>>> Your MySQL connection id is 12
>>>> Server version: 5.0.67-0ubuntu6 (Ubuntu)
>>>>
>>>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>>>
>>>> mysql> grant all privileges on Medicago.* to dbadmin@localhost;
>>>> Query OK, 0 rows affected (0.00 sec)
>>>>
>>>> mysql> grant select on Medicago.* to nobody@localhost;
>>>> Query OK, 0 rows affected (0.01 sec)
>>>>
>>>> mysql> quit
>>>> Bye
>>>>
>>>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ls
>>>> attributes.idx  chr01_1_33214707.gff3  features.bdb  indexes
>>>> locations.idx  names.idx  notes.idx  parentage.bdb  types.idx
>>>>
>>>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
>>>> bp_seqfeature_load.pl -c -f -d Medicago ./ chr01_1_33214707.gff3
>>>> loading ./...
>>>>
>>>> Building object tree... 0.00s
>>>> Loading bulk data into database...DBD::mysql::db do failed: Access
>>>> denied for user 'dbadmin'@'localhost' (using password: NO) at /usr/
>>>> local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line  
>>>> 510.
>>>>
>>>> -------------------- EXCEPTION --------------------
>>>> MSG: Access denied for user 'dbadmin'@'localhost' (using  
>>>> password: NO)
>>>> STACK  
>>>> Bio::DB::SeqFeature::Store::DBI::mysql::_finish_bulk_update /usr/
>>>> local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:510
>>>> STACK Bio::DB::SeqFeature::Store::finish_bulk_update /usr/local/
>>>> share/
>>>> perl/5.10.0/Bio/DB/SeqFeature/Store.pm:1300
>>>> STACK Bio::DB::SeqFeature::Store::GFF3Loader::finish_load /usr/
>>>> local/
>>>> share/perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:378
>>>> STACK Bio::DB::SeqFeature::Store::GFF3Loader::load_fh /usr/local/
>>>> share/
>>>> perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:345
>>>> STACK Bio::DB::SeqFeature::Store::GFF3Loader::load /usr/local/
>>>> share/
>>>> perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:242
>>>> STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:81
>>>> -------------------------------------------
>>>>
>>>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
>>>> bp_seqfeature_load.pl -c -f -p **** -d Medicago ./  
>>>> chr01_1_33214707.gff3
>>>> DBI connect('Medicago','',...) failed: Access denied for user
>>>> 'dbadmin'@'localhost' (using password: YES) at /usr/local/share/
>>>> perl/
>>>> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
>>>> Can't call method "do" on an undefined value at /usr/local/share/
>>>> perl/
>>>> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.
>>>>
>>>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql  
>>>> -u
>>>> root -p
>>>> Enter password:
>>>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>>>> Your MySQL connection id is 18
>>>> Server version: 5.0.67-0ubuntu6 (Ubuntu)
>>>>
>>>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>>>
>>>> mysql> grant all privileges on Medicago.* to 'dbadmin'@'localhost';
>>>> Query OK, 0 rows affected (0.00 sec)
>>>>
>>>> mysql> quit
>>>> Bye
>>>>
>>>> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
>>>> bp_seqfeature_load.pl -c -f -p **** -d Medicago ./  
>>>> chr01_1_33214707.gff3
>>>> DBI connect('Medicago','',...) failed: Access denied for user
>>>> 'dbadmin'@'localhost' (using password: YES) at /usr/local/share/
>>>> perl/
>>>> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
>>>> Can't call method "do" on an undefined value at /usr/local/share/
>>>> perl/
>>>> 5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Come build with us! The BlackBerry(R) Developer Conference in SF,  
>>>> CA
>>>> is the only developer event you need to attend this year.  
>>>> Jumpstart your
>>>> developing skills, take BlackBerry mobile applications to market  
>>>> and stay
>>>> ahead of the curve. Join us from November 9 - 12, 2009. Register  
>>>> now!
>>>> http://p.sf.net/sfu/devconference
>>>> _______________________________________________
>>>> 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
>>>
>>
>>
>>
>> --
>> ------------------------------------------------------------------------
>> Scott Cain, Ph. D.                                   scott at  
>> scottcain dot net
>> GMOD Coordinator (http://gmod.org/)                     216-392-3087
>> Ontario Institute for Cancer Research
>
> ---------------------------------
> Lacey Sanderson
> Bioinformaticist
> Pulse Crop Breeding and Genetics
> Department of Plant Sciences
> University of Saskatchewan.
>

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





------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Parent Message unknown Re: problems loading data into MySQL db

by Lacey Sanderson :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Yes I'm sure the password is correct and yes entering "mysql -u dbadmin Medicago" brings me to the MySQL prompt. 

Also Bioperl version 1.5.2
MySQL version 5.0

Thanks!
Lacey

On 13-Oct-09, at 11:37 AM, Scott Cain wrote:

mysql -u dbadmin Medicago

On 13-Oct-09, at 11:22 AM, Scott Cain wrote:

Hi Lacey,

Sorry, that isn't right: I was giving advice for use with
Bio::DB::GFF.  When using a Bio::DB::SeqFeature::Store database, you
don't need to grant "file" permission.  I'm still looking into what
might be wrong.  What version of BioPerl are you using?

Scott


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Lacey,

That is a pretty old version of BioPerl.  Would it be possible to try  
1.6 or 1.6.1?

Scott


On Oct 15, 2009, at 11:14 AM, Lacey Sanderson wrote:

> Yes I'm sure the password is correct and yes entering "mysql -u  
> dbadmin Medicago" brings me to the MySQL prompt.
>
> Also Bioperl version 1.5.2
> MySQL version 5.0
>
> Thanks!
> Lacey
>
> On 13-Oct-09, at 11:37 AM, Scott Cain wrote:
>
>> mysql -u dbadmin Medicago
>
> On 13-Oct-09, at 11:22 AM, Scott Cain wrote:
>
>> Hi Lacey,
>>
>> Sorry, that isn't right: I was giving advice for use with
>> Bio::DB::GFF.  When using a Bio::DB::SeqFeature::Store database, you
>> don't need to grant "file" permission.  I'm still looking into what
>> might be wrong.  What version of BioPerl are you using?
>>
>> Scott
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart  
> your
> developing skills, take BlackBerry mobile applications to market and  
> stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference_______________________________________________
> 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





------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Parent Message unknown Re: problems loading data into MySQL db

by Lacey Sanderson :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

This loading into the database problem was solved by using sudo infront of the bp_seqfeature_load.pl 

Problem 2:
Could not open database because "Can't locate Bio/DB/SeqFeature/Store/dbi/mysql.pm in @INC ...." even though I could locate mysql.pm except that it was in /DBI instead of /dbi

Solution:
DBI is case sensitive in the .conf file thus changing it to the following fixed the problem:
db_adaptor    = Bio::DB::SeqFeature::Store
db_args       = -adaptor DBI::mysql
                #-dir '/var/www/gbrowse/databases/Medicago/'                                                                                                                                          
-dsn DBI:mysql:database=Medicago
-user www-data

Problem 3:

Could not open database.

Can't call method "prepare_cached" on an undefined value at /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 1424.

Unsure as to why I am getting this error... However, I am in the process of upgrading to Bioperl 1.6.0 (I was using 1.5.2 because that was the version in Ubuntu Intrepid packages) in the hopes that this will solve it. If not at least I'm using a more current, hopefully more stable release :)

Lacey

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Parent Message unknown Re: problems loading data into MySQL db

by Lacey Sanderson :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

problem 3 changed after upgrading Bioperl: Now I am getting
Could not open database.

-------------------- EXCEPTION --------------------
MSG: Unknown MySQL server host 'mysql' (1)
STACK Bio::DB::SeqFeature::Store::DBI::mysql::init /usr/local/share/
perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
STACK Bio::DB::SeqFeature::Store::new /usr/local/share/perl/5.10.0/Bio/
DB/SeqFeature/Store.pm:360
STACK (eval) /usr/local/lib/perl/5.10.0/Bio/Graphics/Browser/Util.pm:185
STACK Bio::Graphics::Browser::Util::open_database /usr/local/lib/perl/
5.10.0/Bio/Graphics/Browser/Util.pm:185
STACK toplevel /usr/lib/cgi-bin/gbrowse:162
-------------------------------------------

Lacey

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Lacey,

The fact that you needed sudo to get data into the database means
there is something wrong that needs to be fixed, and probably explains
the problems you are having down the line.  Unfortunately, I have no
idea what could be wrong that would be fixed by using sudo for this
command.

Scott


On Thu, Oct 15, 2009 at 5:44 PM, Lacey Sanderson
<laceyanne_sanderson@...> wrote:

> This loading into the database problem was solved by using sudo infront of
> the bp_seqfeature_load.pl
> Problem 2:
> Could not open database because "Can't locate
> Bio/DB/SeqFeature/Store/dbi/mysql.pm in @INC ...." even though I could
> locate mysql.pm except that it was in /DBI instead of /dbi
> Solution:
> DBI is case sensitive in the .conf file thus changing it to the following
> fixed the problem:
> db_adaptor    = Bio::DB::SeqFeature::Store
> db_args       = -adaptor DBI::mysql
>                 #-dir '/var/www/gbrowse/databases/Medicago/'
>
>
> -dsn DBI:mysql:database=Medicago
> -user www-data
> Problem 3:
>
> Could not open database.
>
> Can't call method "prepare_cached" on an undefined value at
> /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 1424.
>
> Unsure as to why I am getting this error... However, I am in the process of
> upgrading to Bioperl 1.6.0 (I was using 1.5.2 because that was the version
> in Ubuntu Intrepid packages) in the hopes that this will solve it. If not at
> least I'm using a more current, hopefully more stable release :)
>
> Lacey
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> 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

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Are you using a separate machine for your database server?  Because
this error message is looking for a server named 'mysql' (as opposed
to 'localhost', which is what you would use if you are using the same
machine for the database server).

Scott


On Thu, Oct 15, 2009 at 6:35 PM, Lacey Sanderson
<laceyanne_sanderson@...> wrote:

> problem 3 changed after upgrading Bioperl: Now I am getting
> Could not open database.
>
> -------------------- EXCEPTION --------------------
> MSG: Unknown MySQL server host 'mysql' (1)
> STACK Bio::DB::SeqFeature::Store::DBI::mysql::init /usr/local/share/
> perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
> STACK Bio::DB::SeqFeature::Store::new /usr/local/share/perl/5.10.0/Bio/
> DB/SeqFeature/Store.pm:360
> STACK (eval) /usr/local/lib/perl/5.10.0/Bio/Graphics/Browser/Util.pm:185
> STACK Bio::Graphics::Browser::Util::open_database /usr/local/lib/perl/
> 5.10.0/Bio/Graphics/Browser/Util.pm:185
> STACK toplevel /usr/lib/cgi-bin/gbrowse:162
> -------------------------------------------
>
> Lacey
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> 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

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Parent Message unknown Re: problems loading data into MySQL db

by Lacey Sanderson :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I am using an Ubuntu server version that I can only connect to via  
ssh. The gbrowse was working with the berkeley database behind it,  
however, now I have too much data for that database. Thus the upgrade  
to mysql. Could it be a problem with the database adaptor? has it been  
tested on Ubuntu? Or is it more likely to be a permissions problem?  
I'm completely lost on this one!

Thanks
Lacey

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Lacey,

Please describe your set up a little more clearly: when you say you
can only connect to the server via ssh, is this a server that is
running both GBrowse/apache and mysql on the same box?  What exactly
is the nature of the problem?  Are you still getting the message "MSG:
Unknown MySQL server host 'mysql' (1)"?

Scott


On Fri, Oct 16, 2009 at 10:38 AM, Laceys World
<laceyanne_sanderson@...> wrote:

> I am using an Ubuntu server version that I can only connect to via
> ssh. The gbrowse was working with the berkeley database behind it,
> however, now I have too much data for that database. Thus the upgrade
> to mysql. Could it be a problem with the database adaptor? has it been
> tested on Ubuntu? Or is it more likely to be a permissions problem?
> I'm completely lost on this one!
>
> Thanks
> Lacey
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> 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

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Parent Message unknown Re: problems loading data into MySQL db

by Lacey Sanderson :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Yes both Gbrowse/apache and mysql are on the same computer and I am  
still getting the unknown mysql server host 'mysql'. I installed mysql  
using the ubuntu package for it. Initially I had problems with the  
permissions for the database (it would not let me log in as root) but  
that has since been fixed. I created a database names 'Medicago' which  
is the same name including case of my Gbrowse instance. I then added  
the permissions:

mysql> grant all privileges on Medicago.* to dbadmin@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on Medicago.* to nobody@localhost;
Query OK, 0 rows affected (0.01 sec)

Later I also added the permissions to www-data as apparently this is  
used by Ubuntu rather than nobody

mysql> grant select on Medicago.* to 'www-data'@localhost;
Query OK, 0 rows affected (0.01 sec)



> Could not open database.
>
> -------------------- EXCEPTION --------------------
> MSG: Unknown MySQL server host 'mysql' (1)
> STACK Bio::DB::SeqFeature::Store::DBI::mysql::init /usr/local/share/
> perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
> STACK Bio::DB::SeqFeature::Store::new /usr/local/share/perl/5.10.0/
> Bio/
> DB/SeqFeature/Store.pm:360
> STACK (eval) /usr/local/lib/perl/5.10.0/Bio/Graphics/Browser/Util.pm:
> 185
> STACK Bio::Graphics::Browser::Util::open_database /usr/local/lib/perl/
> 5.10.0/Bio/Graphics/Browser/Util.pm:185
> STACK toplevel /usr/lib/cgi-bin/gbrowse:162
> -------------------------------------------

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Lacey,

Is the server's hostname 'mysql'?  Generally, when the webserver and
the database server are the same machine, you should use 'localhost'
for the host name.

Scott


On Fri, Oct 16, 2009 at 11:18 AM, Laceys World
<laceyanne_sanderson@...> wrote:

> Yes both Gbrowse/apache and mysql are on the same computer and I am
> still getting the unknown mysql server host 'mysql'. I installed mysql
> using the ubuntu package for it. Initially I had problems with the
> permissions for the database (it would not let me log in as root) but
> that has since been fixed. I created a database names 'Medicago' which
> is the same name including case of my Gbrowse instance. I then added
> the permissions:
>
> mysql> grant all privileges on Medicago.* to dbadmin@localhost;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> grant select on Medicago.* to nobody@localhost;
> Query OK, 0 rows affected (0.01 sec)
>
> Later I also added the permissions to www-data as apparently this is
> used by Ubuntu rather than nobody
>
> mysql> grant select on Medicago.* to 'www-data'@localhost;
> Query OK, 0 rows affected (0.01 sec)
>
>
>
>> Could not open database.
>>
>> -------------------- EXCEPTION --------------------
>> MSG: Unknown MySQL server host 'mysql' (1)
>> STACK Bio::DB::SeqFeature::Store::DBI::mysql::init /usr/local/share/
>> perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
>> STACK Bio::DB::SeqFeature::Store::new /usr/local/share/perl/5.10.0/
>> Bio/
>> DB/SeqFeature/Store.pm:360
>> STACK (eval) /usr/local/lib/perl/5.10.0/Bio/Graphics/Browser/Util.pm:
>> 185
>> STACK Bio::Graphics::Browser::Util::open_database /usr/local/lib/perl/
>> 5.10.0/Bio/Graphics/Browser/Util.pm:185
>> STACK toplevel /usr/lib/cgi-bin/gbrowse:162
>> -------------------------------------------
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> 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

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Parent Message unknown Re: problems loading data into MySQL db

by Lacey Sanderson :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I also just attempted to load gbrowse through ssh using w3m (text  
browser) and it gives me the same error message. ie:

An internal error has occurred

Could not open database.

-------------------- EXCEPTION --------------------
MSG: Unknown MySQL server host 'mysql' (1)
STACK Bio::DB::SeqFeature::Store::DBI::mysql::init /usr/local/share/
perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
STACK Bio::DB::SeqFeature::Store::new /usr/local/share/perl/5.10.0/Bio/
DB/SeqFeature/Store.pm:360
STACK (eval) /usr/local/lib/perl/5.10.0/Bio/Graphics/Browser/Util.pm:185
STACK Bio::Graphics::Browser::Util::open_database /usr/local/lib/perl/
5.10.0/Bio/Graphics/Browser/Util.pm:185
STACK toplevel /usr/lib/cgi-bin/gbrowse:162
-------------------------------------------

Where is the server's hostname defined?

Lacey

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Wait: you're trying to load it through ssh?  Do you mean that you are
running the load command locally (that is, on "your" machine, trying
to have it connect to the remote server)?  If you can only connect
through ssh and it doesn't have mysql ports open, that won't work
(well, it might work through ssh tunneling, but you haven't indicated
that you're trying that).  Why don't you scp the data to the remote
machine, log into it via ssh and run the command on the remote
machine?

Also, it would probably be helpful if you showed us exactly what the
command you are using that is causing the problem.

For names, your computer has to be able to resolve the hostname either
via DNS or your hosts file (typically /etc/hosts for Linux or Mac,
though if you're using Windows, you're on your own :-)  If you can't
ping the hostname you are using, the command won't work.

Scott


On Fri, Oct 16, 2009 at 11:35 AM, Laceys World
<laceyanne_sanderson@...> wrote:

> I also just attempted to load gbrowse through ssh using w3m (text
> browser) and it gives me the same error message. ie:
>
> An internal error has occurred
>
> Could not open database.
>
> -------------------- EXCEPTION --------------------
> MSG: Unknown MySQL server host 'mysql' (1)
> STACK Bio::DB::SeqFeature::Store::DBI::mysql::init /usr/local/share/
> perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
> STACK Bio::DB::SeqFeature::Store::new /usr/local/share/perl/5.10.0/Bio/
> DB/SeqFeature/Store.pm:360
> STACK (eval) /usr/local/lib/perl/5.10.0/Bio/Graphics/Browser/Util.pm:185
> STACK Bio::Graphics::Browser::Util::open_database /usr/local/lib/perl/
> 5.10.0/Bio/Graphics/Browser/Util.pm:185
> STACK toplevel /usr/lib/cgi-bin/gbrowse:162
> -------------------------------------------
>
> Where is the server's hostname defined?
>
> Lacey
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> 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

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Lincoln Stein-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Did you give the dbadmin user "file" privileges? You have to do this in a global fashion: "grant file on *.* to dbadmin@localhost"

Lincoln

On Tue, Oct 13, 2009 at 11:50 AM, Lacey Sanderson <laceyanne_sanderson@...> wrote:
I have set up gbrowse on Ubuntu Intrepid. When I try to add my data to
the database using bp_seqfeature_load I get an access denied error
even though I have granted permission to that user. Any ideas what
might be causing this?

Thanks,
Lacey

This is what I have done:
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -u
root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.0.67-0ubuntu6 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all privileges on Medicago.* to dbadmin@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on Medicago.* to nobody@localhost;
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye

dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ls
attributes.idx  chr01_1_33214707.gff3  features.bdb  indexes
locations.idx  names.idx  notes.idx  parentage.bdb  types.idx

dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
bp_seqfeature_load.pl -c -f -d Medicago ./ chr01_1_33214707.gff3
loading ./...

Building object tree... 0.00s
Loading bulk data into database...DBD::mysql::db do failed: Access
denied for user 'dbadmin'@'localhost' (using password: NO) at /usr/
local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 510.

-------------------- EXCEPTION --------------------
MSG: Access denied for user 'dbadmin'@'localhost' (using password: NO)
STACK Bio::DB::SeqFeature::Store::DBI::mysql::_finish_bulk_update /usr/
local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:510
STACK Bio::DB::SeqFeature::Store::finish_bulk_update /usr/local/share/
perl/5.10.0/Bio/DB/SeqFeature/Store.pm:1300
STACK Bio::DB::SeqFeature::Store::GFF3Loader::finish_load /usr/local/
share/perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:378
STACK Bio::DB::SeqFeature::Store::GFF3Loader::load_fh /usr/local/share/
perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:345
STACK Bio::DB::SeqFeature::Store::GFF3Loader::load /usr/local/share/
perl/5.10.0/Bio/DB/SeqFeature/Store/GFF3Loader.pm:242
STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:81
-------------------------------------------

dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
bp_seqfeature_load.pl -c -f -p **** -d Medicago ./ chr01_1_33214707.gff3
DBI connect('Medicago','',...) failed: Access denied for user
'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/
5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
Can't call method "do" on an undefined value at /usr/local/share/perl/
5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.

dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -u
root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 5.0.67-0ubuntu6 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all privileges on Medicago.* to 'dbadmin'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
bp_seqfeature_load.pl -c -f -p **** -d Medicago ./ chr01_1_33214707.gff3
DBI connect('Medicago','',...) failed: Access denied for user
'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/
5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 208
Can't call method "do" on an undefined value at /usr/local/share/perl/
5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 424.





------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
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@...>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Parent Message unknown Re: problems loading data into MySQL db

by Lacey Sanderson :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Lincoln Stein:

I think I had already but I did it again just to make sure and it did not solve the problem.

Scott Cain:
The data I am trying to load is on the same computer as the mySql database and the gbrowse installation. I have coppied my exact workflow below to show exactly what I am doing when I try to load it into the database. Notice that "dbadmin@pev024-desktop:" is the remote machine with the gbrowse installation.

Terminal Output:
=======================================
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ls
chr01_1_33214707.gff3
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -uroot -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 45
Server version: 5.0.67-0ubuntu6 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant file on *.* to dbadmin@localhost
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> grant file on *.* to dbadmin@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ bp_seqfeature_load.pl -c -f -p -d Medicago ./ chr01_1_33214707.gff3
DBI connect('test','',...) failed: Access denied for user 'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 212

-------------------- EXCEPTION --------------------
MSG: Access denied for user 'dbadmin'@'localhost' (using password: YES)
STACK Bio::DB::SeqFeature::Store::DBI::mysql::init /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
STACK Bio::DB::SeqFeature::Store::new /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store.pm:360
STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:77
-------------------------------------------
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ bp_seqfeature_load.pl -c -f -p dru3ebru -d Medicago ./ chr01_1_33214707.gff3
DBI connect('Medicago','',...) failed: Access denied for user 'dbadmin'@'localhost' (using password: YES) at /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 212

-------------------- EXCEPTION --------------------
MSG: Access denied for user 'dbadmin'@'localhost' (using password: YES)
STACK Bio::DB::SeqFeature::Store::DBI::mysql::init /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
STACK Bio::DB::SeqFeature::Store::new /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store.pm:360
STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:77
-------------------------------------------
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ sudo bp_seqfeature_load.pl -c -f -p dru3ebru -d Medicago ./ chr01_1_33214707.gff3
loading ./...
Building object tree... 0.00s                                                                              
Loading bulk data into database... 0.00s
load time:  0.03s
loading chr01_1_33214707.gff3...
Building object tree...14.78s.54s                                                                                                          
Loading bulk data into database...21.68s
load time: 469.32s
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
=======================================

However even after the loading the data into the database as above when I go to http://128.233.29.40/cgi-bin/gbrowse/Medicago/ I get the following:

An internal error has occurred

Could not open database.

-------------------- EXCEPTION --------------------
MSG: Unknown MySQL server host 'mysql' (1)
STACK Bio::DB::SeqFeature::Store::DBI::mysql::init /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
STACK Bio::DB::SeqFeature::Store::new /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store.pm:360
STACK (eval) /usr/local/lib/perl/5.10.0/Bio/Graphics/Browser/Util.pm:185
STACK Bio::Graphics::Browser::Util::open_database /usr/local/lib/perl/5.10.0/Bio/Graphics/Browser/Util.pm:185
STACK toplevel /usr/lib/cgi-bin/gbrowse:162
-------------------------------------------

Please contact this site's maintainer (webmaster@...) for assistance.


$Id: Medicago.conf,v 1.8.8.1.2.4 2008/08/07 16:00:08 scottcain Exp $

Note: This page uses cookies to save and restore preference information. No information is shared.
Generic genome browser version Bio::Graphics::Browser=HASH(0xa838c70)



I also went to /etc/hosts and pinged the hostnames within and the IP address I am using to access gbrowse. Any idea why gbrowse is looking for the MySQL server host 'mysql'? If it should be looking for localhost or 128.233.29.40 how do I tell it that (ie: where is that configured)?

Terminal Output
=======================================
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ping localhost
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.040 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.033 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.049 ms
64 bytes from localhost (127.0.0.1): icmp_seq=4 ttl=64 time=0.035 ms
64 bytes from localhost (127.0.0.1): icmp_seq=5 ttl=64 time=0.034 ms
64 bytes from localhost (127.0.0.1): icmp_seq=6 ttl=64 time=0.033 ms
64 bytes from localhost (127.0.0.1): icmp_seq=7 ttl=64 time=0.032 ms
64 bytes from localhost (127.0.0.1): icmp_seq=8 ttl=64 time=0.032 ms
64 bytes from localhost (127.0.0.1): icmp_seq=9 ttl=64 time=0.035 ms
64 bytes from localhost (127.0.0.1): icmp_seq=10 ttl=64 time=0.036 ms
64 bytes from localhost (127.0.0.1): icmp_seq=11 ttl=64 time=0.035 ms
^C
--- localhost ping statistics ---
11 packets transmitted, 11 received, 0% packet loss, time 9998ms
rtt min/avg/max/mdev = 0.032/0.035/0.049/0.008 ms
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ping mysql
ping: unknown host mysql
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ emacs /etc/hosts
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ping pev024-desktop
PING pev024-desktop (127.0.1.1) 56(84) bytes of data.
64 bytes from pev024-desktop (127.0.1.1): icmp_seq=1 ttl=64 time=0.044 ms
64 bytes from pev024-desktop (127.0.1.1): icmp_seq=2 ttl=64 time=0.032 ms
64 bytes from pev024-desktop (127.0.1.1): icmp_seq=3 ttl=64 time=0.033 ms
64 bytes from pev024-desktop (127.0.1.1): icmp_seq=4 ttl=64 time=0.033 ms
^C
--- pev024-desktop ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 2998ms
rtt min/avg/max/mdev = 0.032/0.035/0.044/0.007 ms
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ping 128.233.29.40
PING 128.233.29.40 (128.233.29.40) 56(84) bytes of data.
64 bytes from 128.233.29.40: icmp_seq=1 ttl=64 time=0.146 ms
64 bytes from 128.233.29.40: icmp_seq=2 ttl=64 time=0.127 ms
64 bytes from 128.233.29.40: icmp_seq=3 ttl=64 time=0.124 ms
64 bytes from 128.233.29.40: icmp_seq=4 ttl=64 time=0.130 ms
64 bytes from 128.233.29.40: icmp_seq=5 ttl=64 time=0.124 ms
^C
--- 128.233.29.40 ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4015ms
rtt min/avg/max/mdev = 0.124/0.130/0.146/0.010 ms
dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ 

=======================================

Sorry for all the terminal output! Thanks for any help

Lacey

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

Re: problems loading data into MySQL db

by Scott Cain-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Lacey,

Please send the GBrowse configuraiton file that you are using.  It
must be a configuration problem.

Scott


On Fri, Oct 16, 2009 at 5:39 PM, Lacey Sanderson
<laceyanne_sanderson@...> wrote:

> Lincoln Stein:
> I think I had already but I did it again just to make sure and it did not
> solve the problem.
> Scott Cain:
> The data I am trying to load is on the same computer as the mySql database
> and the gbrowse installation. I have coppied my exact workflow below to show
> exactly what I am doing when I try to load it into the database. Notice that
> "dbadmin@pev024-desktop:" is the remote machine with the gbrowse
> installation.
> Terminal Output:
> =======================================
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ls
> chr01_1_33214707.gff3
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ mysql -uroot -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 45
> Server version: 5.0.67-0ubuntu6 (Ubuntu)
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> mysql> grant file on *.* to dbadmin@localhost
>     -> ;
> Query OK, 0 rows affected (0.00 sec)
> mysql> grant file on *.* to dbadmin@localhost;
> Query OK, 0 rows affected (0.00 sec)
> mysql> quit
> Bye
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
> bp_seqfeature_load.pl -c -f -p -d Medicago ./ chr01_1_33214707.gff3
> DBI connect('test','',...) failed: Access denied for user
> 'dbadmin'@'localhost' (using password: YES) at
> /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 212
> -------------------- EXCEPTION --------------------
> MSG: Access denied for user 'dbadmin'@'localhost' (using password: YES)
> STACK Bio::DB::SeqFeature::Store::DBI::mysql::init
> /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
> STACK Bio::DB::SeqFeature::Store::new
> /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store.pm:360
> STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:77
> -------------------------------------------
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
> bp_seqfeature_load.pl -c -f -p dru3ebru -d Medicago ./ chr01_1_33214707.gff3
> DBI connect('Medicago','',...) failed: Access denied for user
> 'dbadmin'@'localhost' (using password: YES) at
> /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 212
> -------------------- EXCEPTION --------------------
> MSG: Access denied for user 'dbadmin'@'localhost' (using password: YES)
> STACK Bio::DB::SeqFeature::Store::DBI::mysql::init
> /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
> STACK Bio::DB::SeqFeature::Store::new
> /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store.pm:360
> STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:77
> -------------------------------------------
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ sudo
> bp_seqfeature_load.pl -c -f -p dru3ebru -d Medicago ./ chr01_1_33214707.gff3
> loading ./...
> Building object tree... 0.00s
>
> Loading bulk data into database... 0.00s
> load time:  0.03s
> loading chr01_1_33214707.gff3...
> Building object tree...14.78s.54s
>
> Loading bulk data into database...21.68s
> load time: 469.32s
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
> =======================================
> However even after the loading the data into the database as above when I go
> to http://128.233.29.40/cgi-bin/gbrowse/Medicago/ I get the following:
>
> An internal error has occurred
>
> Could not open database.
>
> -------------------- EXCEPTION --------------------
> MSG: Unknown MySQL server host 'mysql' (1)
> STACK Bio::DB::SeqFeature::Store::DBI::mysql::init
> /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store/DBI/mysql.pm:212
> STACK Bio::DB::SeqFeature::Store::new
> /usr/local/share/perl/5.10.0/Bio/DB/SeqFeature/Store.pm:360
> STACK (eval) /usr/local/lib/perl/5.10.0/Bio/Graphics/Browser/Util.pm:185
> STACK Bio::Graphics::Browser::Util::open_database
> /usr/local/lib/perl/5.10.0/Bio/Graphics/Browser/Util.pm:185
> STACK toplevel /usr/lib/cgi-bin/gbrowse:162
> -------------------------------------------
>
> Please contact this site's maintainer (webmaster@localhost) for assistance.
>
> ________________________________
>
> $Id: Medicago.conf,v 1.8.8.1.2.4 2008/08/07 16:00:08 scottcain Exp $
>
> Note: This page uses cookies to save and restore preference information. No
> information is shared.
> Generic genome browser version Bio::Graphics::Browser=HASH(0xa838c70)
>
> I also went to /etc/hosts and pinged the hostnames within and the IP address
> I am using to access gbrowse. Any idea why gbrowse is looking for the MySQL
> server host 'mysql'? If it should be looking for localhost or 128.233.29.40
> how do I tell it that (ie: where is that configured)?
> Terminal Output
> =======================================
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ping localhost
> PING localhost (127.0.0.1) 56(84) bytes of data.
> 64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.040 ms
> 64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.033 ms
> 64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.049 ms
> 64 bytes from localhost (127.0.0.1): icmp_seq=4 ttl=64 time=0.035 ms
> 64 bytes from localhost (127.0.0.1): icmp_seq=5 ttl=64 time=0.034 ms
> 64 bytes from localhost (127.0.0.1): icmp_seq=6 ttl=64 time=0.033 ms
> 64 bytes from localhost (127.0.0.1): icmp_seq=7 ttl=64 time=0.032 ms
> 64 bytes from localhost (127.0.0.1): icmp_seq=8 ttl=64 time=0.032 ms
> 64 bytes from localhost (127.0.0.1): icmp_seq=9 ttl=64 time=0.035 ms
> 64 bytes from localhost (127.0.0.1): icmp_seq=10 ttl=64 time=0.036 ms
> 64 bytes from localhost (127.0.0.1): icmp_seq=11 ttl=64 time=0.035 ms
> ^C
> --- localhost ping statistics ---
> 11 packets transmitted, 11 received, 0% packet loss, time 9998ms
> rtt min/avg/max/mdev = 0.032/0.035/0.049/0.008 ms
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ping mysql
> ping: unknown host mysql
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ emacs /etc/hosts
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ping
> pev024-desktop
> PING pev024-desktop (127.0.1.1) 56(84) bytes of data.
> 64 bytes from pev024-desktop (127.0.1.1): icmp_seq=1 ttl=64 time=0.044 ms
> 64 bytes from pev024-desktop (127.0.1.1): icmp_seq=2 ttl=64 time=0.032 ms
> 64 bytes from pev024-desktop (127.0.1.1): icmp_seq=3 ttl=64 time=0.033 ms
> 64 bytes from pev024-desktop (127.0.1.1): icmp_seq=4 ttl=64 time=0.033 ms
> ^C
> --- pev024-desktop ping statistics ---
> 4 packets transmitted, 4 received, 0% packet loss, time 2998ms
> rtt min/avg/max/mdev = 0.032/0.035/0.044/0.007 ms
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$ ping
> 128.233.29.40
> PING 128.233.29.40 (128.233.29.40) 56(84) bytes of data.
> 64 bytes from 128.233.29.40: icmp_seq=1 ttl=64 time=0.146 ms
> 64 bytes from 128.233.29.40: icmp_seq=2 ttl=64 time=0.127 ms
> 64 bytes from 128.233.29.40: icmp_seq=3 ttl=64 time=0.124 ms
> 64 bytes from 128.233.29.40: icmp_seq=4 ttl=64 time=0.130 ms
> 64 bytes from 128.233.29.40: icmp_seq=5 ttl=64 time=0.124 ms
> ^C
> --- 128.233.29.40 ping statistics ---
> 5 packets transmitted, 5 received, 0% packet loss, time 4015ms
> rtt min/avg/max/mdev = 0.124/0.130/0.146/0.010 ms
> dbadmin@pev024-desktop:/var/www/gbrowse/databases/Medicago$
> =======================================
> Sorry for all the terminal output! Thanks for any help
> Lacey
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> 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

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Gmod-gbrowse mailing list
Gmod-gbrowse@...
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
< Prev | 1 - 2 | Next >