[ensembl-dev] denied access to ensembl_compara alignment tables on public server

[Lel Eory]

Hi Stephen and Matthieu,

adding --lock-tables=false solved it.

Thanks,
Lel

On 09/03/2014 04:38 PM, Stephen Fitzgerald wrote:
> Hi Lel, populate_new_database.pl seems to use mysqldump as the first 
> step in the copying process, you can disable locking with:
>
> --single-transaction
> or
> --lock-tables=false
>
> Try adding this to the copy_dna_dna_alignements sub
>
> change " --skip-disable-keys --insert-ignore -t $old_dbname";
>
> to
>
> " --skip-disable-keys --insert-ignore --lock-tables=false -t 
> $old_dbname";
>
> See if it works.
>
> Cheers,
> Stephen.
>
>
> On Wed, 3 Sep 2014, Lel Eory wrote:
>
>> Dear Developers,
>>
>> I try to load some sequence alignments into a limited compara_master 
>> DB with the populate_new_database.pl script, but the public Ensembl 
>> mysql server does not allow me to do this. It returns with:
>> Got error: 1044: Access denied for user 'anonymous'@'%' to database 
>> 'ensembl_compara_75' when doing LOCK TABLES. Are the locks there on 
>> these tables to prevent overloading the system? Is there any other 
>> way to get alignment data with the populate_new_database.pl script 
>> (apart from setting-up a local instance of the compara DB limited to 
>> the alignments)?
>>
>> Thank you.
>>
>> Kind regards,
>> Lel
>>
>> -- 
>> The University of Edinburgh is a charitable body, registered in
>> Scotland, with registration number SC005336.
>>
>>
>> _______________________________________________
>> Dev mailing list    Dev at ensembl.org
>> Posting guidelines and subscribe/unsubscribe info: 
>> http://lists.ensembl.org/mailman/listinfo/dev
>> Ensembl Blog: http://www.ensembl.info/
>>
>>
>
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info: 
> http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/


-- 
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.