tag:help.appveyor.com,2012-11-13:/discussions/problems/28921-unchecked-emailpassword-in-allowed-authentication-methods-how-do-i-login-againAppVeyor: Discussion 2021-02-02T10:17:02Ztag:help.appveyor.com,2012-11-13:Comment/490078042021-02-01T16:07:32Z2021-02-01T16:07:33ZUnchecked Email/password in Allowed authentication methods. How do I login again?<div><p>Here is a screenshot...</p></div>alex.kontostag:help.appveyor.com,2012-11-13:Comment/490078042021-02-01T17:30:13Z2021-02-01T17:30:13ZUnchecked Email/password in Allowed authentication methods. How do I login again?<div><p>Is it installed on Windows or Linux?</p></div>Feodor Fitsnertag:help.appveyor.com,2012-11-13:Comment/490078042021-02-01T17:30:54Z2021-02-01T17:30:54ZUnchecked Email/password in Allowed authentication methods. How do I login again?<div><p>Linux, Ubuntu 20.04</p></div>alex.kontostag:help.appveyor.com,2012-11-13:Comment/490078042021-02-01T17:40:47Z2021-02-01T17:40:47ZUnchecked Email/password in Allowed authentication methods. How do I login again?<div><p>You can enable it in database using SQLite CLI. Download SQLite CLI from here: <a href="https://sqlite.org/download.html">https://sqlite.org/download.html</a> (<a href="https://sqlite.org/2021/sqlite-tools-linux-x86-3340100.zip">precompiled binary for Linux</a>). Guide for using CLI: <a href="https://sqlite.org/cli.html">https://sqlite.org/cli.html</a></p>
<p>Back (copy) AppVeyor database before doing all this please!</p>
<p>On Linux AppVeyor database is stored at <code>/var/opt/appveyor/server/appveyor-server.db</code>. You can enable username/password for specific account (all accounts if you ommit WHERE) with the query:</p>
<pre>
<code>UPDATE Accounts SET DisabledLoginMethods = NULL WHERE AccountID = '<account-name>'</code>
</pre>
<p>Let me know if that helped.</p></div>Feodor Fitsnertag:help.appveyor.com,2012-11-13:Comment/490078042021-02-02T10:16:49Z2021-02-02T10:16:49ZUnchecked Email/password in Allowed authentication methods. How do I login again?<div><p>Running <code>UPDATE Accounts SET DisabledLoginMethods = NULL;</code> worked, thank you!</p></div>alex.kontos