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 |
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? ------------------------------------------------------------------------------ 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 |
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, ------------------------------------------------------------------------------ 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 |
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:
------------------------------------------------------------------------------ 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 |
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
------------------------------------------------------------------------------ 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 |
Free forum by Nabble | Edit this page |