[ensembl-dev] DB access for EnsemblMetazoa [EXT]

[Keiran Raine]

Hi Andy,

Thanks for confirming the cause.  I've requested the latest API be installed centrally as Sanger.

Happy holidays!

Keiran Raine, M.Sc., MBCS
Principal Software Developer
Cancer, Ageing and Somatic Mutation
Wellcome Sanger Institute
 
kr2 at sanger.ac.uk
Office: D3-19
Ext: 4983
 
Please note that due to childcare requirements due to covid restrictions I am generally not available after 4pm.

On 09/12/2020, 09:22, "Dev on behalf of Andy Yates" <dev-bounces at ensembl.org on behalf of ayates at ebi.ac.uk> wrote:

    Hi Keiran,
    
    There's a simple answer here, that the e100 version non-vert databases are missing from the public sql server. We're looking into the why,  what we can do to recover this and get you back on track. In the intermediate time if there's a particular database you're after, you can download and load the e100 (same as release 47) metazoan DBs from here:
    
    https://urldefense.proofpoint.com/v2/url?u=ftp-3A__ftp.ensemblgenomes.org_pub_release-2D47_metazoa_mysql_&d=DwICAg&c=D7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=0l44_2npVb7te0dQGjE0Xw&m=y-le7lQPDN2b3IonGqEXqPEPvB5FsoYBUNuIy8CNG3M&s=Nr0l6i7RD1ciUuxdRYofKRgcWM9e3hf1ya368-eBoME&e= 
    
    Or switch to a later version such as 101 or 102. Obviously if you're wanting something from all release 100 metazoa DBs, then any of those last 3 options won't be a viable.
    
    Andy
    
    ------------
    Andrew Yates - Genomics Technology Infrastructure Team Leader
    The European Bioinformatics Institute (EMBL-EBI)
    Wellcome Genome Campus
    Hinxton, Cambridge
    CB10 1SD, United Kingdom
    Tel: +44-(0)1223-492538
    Fax: +44-(0)1223-494468
    Skype: andy.yates.ebi
    https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ebi.ac.uk_&d=DwICAg&c=D7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=0l44_2npVb7te0dQGjE0Xw&m=y-le7lQPDN2b3IonGqEXqPEPvB5FsoYBUNuIy8CNG3M&s=xswdWJ8JAWz-AhhRs2YDacUmALGvcPgX_f-5LV7mqgw&e= 
    https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ensembl.org_&d=DwICAg&c=D7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=0l44_2npVb7te0dQGjE0Xw&m=y-le7lQPDN2b3IonGqEXqPEPvB5FsoYBUNuIy8CNG3M&s=iFmmMa_wjyv3agCquxoBk81O9YUvzGn2rWMadBLujUI&e= 
    
    > On 8 Dec 2020, at 17:00, Keiran Raine <kr2 at sanger.ac.uk> wrote:
    > 
    > Hi,
    >  
    > I'm looking for some assistance reading data from the ensembl mysql instance for EnsemblMetazoa.
    >  
    > I have a very simple API script based on examples from the official documentation (attached), it works fine for listing the available DB adaptors via "get_all_DBAdaptors" if I point it at the vertebrate instance, but for the non-vertebrate genomes I get an empty list (registry as described here).
    >  
    > If nothing else, I'm just looking for someone to confirm they see the same behaviour as me when using the documented connection details.
    >  
    > P.s. the general ensembl instance is very slow, it was usable earlier today, not so much now.  I also did a host lookup of the database hosts, both derive down to the same IP address via a chain of aliases, so it looks like it's the port that is more important.
    >  
    > Thanks,
    >  
    > Keiran Raine, M.Sc., MBCS
    > Principal Software Developer
    > Cancer, Ageing and Somatic Mutation
    > Wellcome Sanger Institute
    >  
    > kr2 at sanger.ac.uk
    > Office: D3-19
    > Ext: 4983
    >  
    > Please note that due to childcare requirements due to covid restrictions I am generally not available after 4pm.
    > <ensembl_issue.pl>_______________________________________________
    > Dev mailing list    Dev at ensembl.org
    > Posting guidelines and subscribe/unsubscribe info: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.ensembl.org_mailman_listinfo_dev-5Fensembl.org&d=DwICAg&c=D7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=0l44_2npVb7te0dQGjE0Xw&m=y-le7lQPDN2b3IonGqEXqPEPvB5FsoYBUNuIy8CNG3M&s=2fghhMhgY3qX27_Xyy_iWTqKmBWY3hcAEuyQ3pmOKYo&e= 
    > Ensembl Blog: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ensembl.info_&d=DwICAg&c=D7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=0l44_2npVb7te0dQGjE0Xw&m=y-le7lQPDN2b3IonGqEXqPEPvB5FsoYBUNuIy8CNG3M&s=xqmn2xQy4DO_3eYPYVTqyl3Hg6oTJgY2TNZQa-LH7GY&e= 
    
    
    _______________________________________________
    Dev mailing list    Dev at ensembl.org
    Posting guidelines and subscribe/unsubscribe info: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.ensembl.org_mailman_listinfo_dev-5Fensembl.org&d=DwICAg&c=D7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=0l44_2npVb7te0dQGjE0Xw&m=y-le7lQPDN2b3IonGqEXqPEPvB5FsoYBUNuIy8CNG3M&s=2fghhMhgY3qX27_Xyy_iWTqKmBWY3hcAEuyQ3pmOKYo&e= 
    Ensembl Blog: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ensembl.info_&d=DwICAg&c=D7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=0l44_2npVb7te0dQGjE0Xw&m=y-le7lQPDN2b3IonGqEXqPEPvB5FsoYBUNuIy8CNG3M&s=xqmn2xQy4DO_3eYPYVTqyl3Hg6oTJgY2TNZQa-LH7GY&e=