Host IP in bp_seqfeature_load.pl

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Host IP in bp_seqfeature_load.pl

Samy Jeevan Karloss Antony
I have to load GFF3 files into MySQL server using host ip address. How to mention the IP address in bp_seqfeature_load.pl?

Jeevan
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-gbrowse mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
Reply | Threaded
Open this post in threaded view
|

Re: Host IP in bp_seqfeature_load.pl

Josh Goodman
Hi Jeevan,

bp_seqfeature_load.pl takes a data source name (dsn) string as one of its options (-d or --dsn).  That dsn string allows you to specify a hostname, for MySQL see https://metacpan.org/pod/DBD::mysql#connect for the required format.

Regards,
Josh

On Thu Dec 18 2014 at 7:34:14 AM Samy Jeevan Karloss Antony <[hidden email]> wrote:
I have to load GFF3 files into MySQL server using host ip address. How to mention the IP address in bp_seqfeature_load.pl?

Jeevan
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-gbrowse mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-gbrowse mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
Reply | Threaded
Open this post in threaded view
|

Re: Host IP in bp_seqfeature_load.pl

Samy Jeevan Karloss Antony
Thanks, Josh. 

When I tried these commands below,

bp_seqfeature_load.pl -d ‘DBI:mysql:database=Test_161214;host=192.168.168.215' -f -c Test.gff3 Test_Chr_Unmasked.fasta

and 

bp_seqfeature_load.pl -d ‘DBI:mysql:database=Test_161214;host=192.168.168.215;port=3306' -f -c Test.gff3 Test_Chr_Unmasked.fasta

and 

bp_seqfeature_load.pl -d "DBI:mysql:database=Test_161214;host=192.168.168.215;port=3306" -f -c Test.gff3 Test_Chr_Unmasked.fasta



I am getting this error below. Any idea where things go wrong?

#############################################################################################################################################
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 72, near "$dbname qw(IndexIt TopLevel Local2Global)"
Global symbol "$tmp" requires explicit package name at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 84.
Global symbol "%self" requires explicit package name at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 86.
Global symbol "%self" requires explicit package name at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 88.
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 89, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 96, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 103, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 109, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 116, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 123, near "}"
/local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm has too many errors.
Compilation failed in require at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/GFF3Loader.pm line 73.
BEGIN failed--compilation aborted at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/GFF3Loader.pm line 73.
Compilation failed in require at /local/genome/packages/perl/5.18.2/bin/bp_seqfeature_load.pl line 20.
BEGIN failed--compilation aborted at /local/genome/packages/perl/5.18.2/bin/bp_seqfeature_load.pl line 20.
#############################################################################################################################################

Jeevan

On 18 Dec 2014, at 14:55, Josh Goodman <[hidden email]> wrote:

Hi Jeevan,

bp_seqfeature_load.pl takes a data source name (dsn) string as one of its options (-d or --dsn).  That dsn string allows you to specify a hostname, for MySQL see https://metacpan.org/pod/DBD::mysql#connect for the required format.

Regards,
Josh

On Thu Dec 18 2014 at 7:34:14 AM Samy Jeevan Karloss Antony <[hidden email]> wrote:
I have to load GFF3 files into MySQL server using host ip address. How to mention the IP address in bp_seqfeature_load.pl?

Jeevan
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-gbrowse mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse


------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-gbrowse mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
Reply | Threaded
Open this post in threaded view
|

Re: Host IP in bp_seqfeature_load.pl

Josh Goodman
Those errors are fairly severe and fatal, perhaps your install is corrupted?

What does this show?

/local/genome/packages/perl/5.18.2/bin/perl -c /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm

If it does not say "LoadHelper.pm syntax OK" then I would reinstall.  You may need to adjust your library paths with the '-I' flag.

e.g.

perl -c -I /path/to/my/additional/library/directory /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm

Josh

On Thu Dec 18 2014 at 9:31:13 AM Samy Jeevan Karloss Antony <[hidden email]> wrote:
Thanks, Josh. 

When I tried these commands below,

bp_seqfeature_load.pl -d ‘DBI:mysql:database=Test_161214;host=192.168.168.215' -f -c Test.gff3 Test_Chr_Unmasked.fasta

and 

bp_seqfeature_load.pl -d ‘DBI:mysql:database=Test_161214;host=192.168.168.215;port=3306' -f -c Test.gff3 Test_Chr_Unmasked.fasta

and 

bp_seqfeature_load.pl -d "DBI:mysql:database=Test_161214;host=192.168.168.215;port=3306" -f -c Test.gff3 Test_Chr_Unmasked.fasta



I am getting this error below. Any idea where things go wrong?

#############################################################################################################################################
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 72, near "$dbname qw(IndexIt TopLevel Local2Global)"
Global symbol "$tmp" requires explicit package name at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 84.
Global symbol "%self" requires explicit package name at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 86.
Global symbol "%self" requires explicit package name at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 88.
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 89, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 96, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 103, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 109, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 116, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 123, near "}"
/local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm has too many errors.
Compilation failed in require at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/GFF3Loader.pm line 73.
BEGIN failed--compilation aborted at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/GFF3Loader.pm line 73.
Compilation failed in require at /local/genome/packages/perl/5.18.2/bin/bp_seqfeature_load.pl line 20.
BEGIN failed--compilation aborted at /local/genome/packages/perl/5.18.2/bin/bp_seqfeature_load.pl line 20.
#############################################################################################################################################

Jeevan

On 18 Dec 2014, at 14:55, Josh Goodman <[hidden email]> wrote:

Hi Jeevan,

bp_seqfeature_load.pl takes a data source name (dsn) string as one of its options (-d or --dsn).  That dsn string allows you to specify a hostname, for MySQL see https://metacpan.org/pod/DBD::mysql#connect for the required format.

Regards,
Josh

On Thu Dec 18 2014 at 7:34:14 AM Samy Jeevan Karloss Antony <[hidden email]> wrote:
I have to load GFF3 files into MySQL server using host ip address. How to mention the IP address in bp_seqfeature_load.pl?

Jeevan
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-gbrowse mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse


------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-gbrowse mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse
Reply | Threaded
Open this post in threaded view
|

Re: Host IP in bp_seqfeature_load.pl

Scott Cain
In reply to this post by Samy Jeevan Karloss Antony
Hi Jeevan,

What version of BioPerl are you using? The line numbers in the error messages don't correspond to lines in the current version of that module. 

Scott


Sent from my iPad

On Dec 18, 2014, at 9:31 AM, Samy Jeevan Karloss Antony <[hidden email]> wrote:

Thanks, Josh. 

When I tried these commands below,

bp_seqfeature_load.pl -d ‘DBI:mysql:database=Test_161214;host=192.168.168.215' -f -c Test.gff3 Test_Chr_Unmasked.fasta

and 

bp_seqfeature_load.pl -d ‘DBI:mysql:database=Test_161214;host=192.168.168.215;port=3306' -f -c Test.gff3 Test_Chr_Unmasked.fasta

and 

bp_seqfeature_load.pl -d "DBI:mysql:database=Test_161214;host=192.168.168.215;port=3306" -f -c Test.gff3 Test_Chr_Unmasked.fasta



I am getting this error below. Any idea where things go wrong?

#############################################################################################################################################
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 72, near "$dbname qw(IndexIt TopLevel Local2Global)"
Global symbol "$tmp" requires explicit package name at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 84.
Global symbol "%self" requires explicit package name at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 86.
Global symbol "%self" requires explicit package name at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 88.
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 89, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 96, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 103, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 109, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 116, near "}"
syntax error at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm line 123, near "}"
/local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/LoadHelper.pm has too many errors.
Compilation failed in require at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/GFF3Loader.pm line 73.
BEGIN failed--compilation aborted at /local/genome/packages/perl/5.18.2/lib/site_perl/5.18.2/x86_64-linux/Bio/DB/SeqFeature/Store/GFF3Loader.pm line 73.
Compilation failed in require at /local/genome/packages/perl/5.18.2/bin/bp_seqfeature_load.pl line 20.
BEGIN failed--compilation aborted at /local/genome/packages/perl/5.18.2/bin/bp_seqfeature_load.pl line 20.
#############################################################################################################################################

Jeevan

On 18 Dec 2014, at 14:55, Josh Goodman <[hidden email]> wrote:

Hi Jeevan,

bp_seqfeature_load.pl takes a data source name (dsn) string as one of its options (-d or --dsn).  That dsn string allows you to specify a hostname, for MySQL see https://metacpan.org/pod/DBD::mysql#connect for the required format.

Regards,
Josh

On Thu Dec 18 2014 at 7:34:14 AM Samy Jeevan Karloss Antony <[hidden email]> wrote:
I have to load GFF3 files into MySQL server using host ip address. How to mention the IP address in bp_seqfeature_load.pl?

Jeevan
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-gbrowse mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-gbrowse mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-gbrowse mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse