[ensembl-dev] Region report tool / Registry - only works for mysql users without password?
Kieron Taylor
ktaylor at ebi.ac.uk
Mon Apr 30 16:28:20 BST 2012
Hi Nick, I'm glad to see someone is using the Region report tool from
the command line.
There is a bug that we know of in the secondary host connection code,
which is being fixed, but there are a couple of things we have noticed
in your parameter specification.
Firstly, pointing the tool at the same server twice redundant. The
feature is in place to assist in situations (such as on our main public
servers) where data must be spread across several hosts. Hopefully you
are just masking your true connection settings.
Secondly, MySQL behaves badly with "localhost" as a target. It tends to
assume socket connections instead of by http, which can cause no end of
connection issues. Sockets are treated differently for valid users and
authentication than through HTTP. Try feeding it 127.0.0.1 as a host
instead.
Kieron
On 30/04/12 16:00, Nick Langridge wrote:
> Hi,
>
> I'm trying to use the region report tool but it seems to ignore the
> mysql password that I supply in the options:
>
> perl region_report.pl --species=Anopheles_gambiae --input=/tmp/inputfile
> --include=gt --report --host=localhost --port=3306 --db_version=66
> --user=myuser --password=mypass --secondaryhost=localhost
> --secondaryport=3306 --db_version=66 --secondaryuser=myuser
> --secondarypassword=mypass --output=/tmp/outputfile
>
> I see error:
>
> connect: DBI:mysql:host=localhost;port=3306 myuser at
> /ensembl/www-live/VB-2012-03/ensembl/modules/Bio/EnsEMBL/Registry.pm
> line 1566.
> DBI connect('host=localhost;port=3306','myuser',...) failed: Access
> denied for user 'myuser'@'localhost' (using password: NO) at
> /ensembl/www-live/VB-2012-03/ensembl/modules/Bio/EnsEMBL/Registry.pm
> line 1567
>
> -------------------- EXCEPTION --------------------
> MSG: Cannot connect to the Ensembl MySQL server at localhost:3306; check
> your settings & DBI error message: Access denied for user
> 'myuser'@'localhost' (using password: NO)
> STACK Bio::EnsEMBL::Registry::load_registry_from_db
> /ensembl/www-live/VB-2012-03/ensembl/modules/Bio/EnsEMBL/Registry.pm:1567
> STACK Bio::EnsEMBL::Registry::load_registry_from_multiple_dbs
> /ensembl/www-live/VB-2012-03/ensembl/modules/Bio/EnsEMBL/Registry.pm:2296
> STACK toplevel
> /ensembl/www-live/VB-2012-03/ensembl-tools/scripts/region_reporter/region_report.pl:176
>
> Ensembl API version = 66
> ---------------------------------------------------
>
> As far as I can see, the region report script calls
> Bio::Ensembl::Registry->load_registry_from_multiple_dbs() with the
> password present, but the registry seems to ignore it.
>
> Is this the expected behaviour?
>
> Cheers,
> Nick
>
>
>
> _______________________________________________
> Dev mailing list Dev at ensembl.org
> List admin (including subscribe/unsubscribe):
> http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/
More information about the Dev
mailing list