<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi Francesco,<div class=""><br class=""></div><div class="">Looks like your pipeline is using the user anonymous to connect to the database.</div><div class=""><br class=""></div><div class="">I would suggest that you add the skip option within your runnable.</div><div class=""><br class=""></div><div class="">Which analysis is actually failing?</div><div class=""><br class=""></div><div class="">Cheers,</div><div class=""><br class=""></div><div class="">Mateus.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div><blockquote type="cite" class=""><div class="">On 8 Nov 2017, at 17:36, Francesco Lamanna <<a href="mailto:francesco.lamanna@gmail.com" class="">francesco.lamanna@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class=""><div class=""><div class=""><div class="">Hello,<br class=""><br class=""></div>I am trying to apply the ProteinTrees pipeline to a set of Ensembl and non-Ensembl genomes. <br class=""><br class="">When running the pipeline without a master database (via <a href="http://beekeeper.pl/" class="">beekeeper.pl</a>) I get the following error:<br class=""><br class="">ensembl_compara_90 ncbi_taxa_node | sed "s/ENGINE=MyISAM/ENGINE=InnoDB/" | mysql -h127.0.0.1 -P3306 -uroot -p$EHIVE_TMP_PASSWORD_0 hd_cc141_test_protein_trees_no_master_90' resulted in an error code=2<br class="">stderr is: mysql: [Warning] Using a password on the command line interface can be insecure.<br class="">mysqldump: Got error: 1044: Access denied for user 'anonymous'@'%' to database 'ensembl_compara_90' when doing LOCK TABLES <br class=""><br class=""><br class=""></div>Is there a way to pass --skip-lock-tables to the pipeline (e.g. in the conf file) in order to be able to dump the database?<br class=""><br class=""></div>Thanks,<br class=""></div>Francesco.<br class=""><div class=""><div class=""><div class=""><br class=""><br class=""></div></div></div></div>
_______________________________________________<br class="">Dev mailing list <a href="mailto:Dev@ensembl.org" class="">Dev@ensembl.org</a><br class="">Posting guidelines and subscribe/unsubscribe info: <a href="http://lists.ensembl.org/mailman/listinfo/dev" class="">http://lists.ensembl.org/mailman/listinfo/dev</a><br class="">Ensembl Blog: <a href="http://www.ensembl.info/" class="">http://www.ensembl.info/</a><br class=""></div></blockquote></div><br class=""></div></body></html>