{"id":2256,"date":"2019-10-18T15:41:40","date_gmt":"2019-10-18T15:41:40","guid":{"rendered":"http:\/\/salientsoft.co.uk\/?p=2256"},"modified":"2019-10-18T15:41:40","modified_gmt":"2019-10-18T15:41:40","slug":"500-error-when-connecting-to-database-from-mantis-and-2intandem","status":"publish","type":"post","link":"https:\/\/salientsoft.co.uk\/?p=2256","title":{"rendered":"500 error when connecting to database from Mantis and 2intandem"},"content":{"rendered":"<p>I received 500 errors from both Mantis and 2intandem, giving this kind of error:-<br \/>\n<em>The server requested authentication method unknown to the client [mysql_old_password]<\/em><\/p>\n<p>In the case of 2intandem it was just a straight 500 unable to connect to database error, so the error was not so clear. However once I had fixed mantis, I suspected the issue was the same and indeed it was.<\/p>\n<p>This post\u00a0<a href=\"https:\/\/serverfault.com\/a\/933877\">here<\/a>\u00a0indicated that this was due to a change in the password salt length\/old\/legacy salt issue, and that simply changing the password would resolve the issue.<\/p>\n<p>This fixed the issue for both &#8211; just a password change. Even changing to the same password fixed the issue. In one case I actually changed the password so therefore also had to update the password in the relevant config.php file.<\/p>\n<p>One issue on doing this was that I spent some time finding out where to change DB users\/passwords in CPanel, thinking it was in PHPMyAdmin screen per some posts on this.<br \/>\nHowever it is not done there but under the MySQLDatabases icon in CPanel &#8211; this allows user maintenance including password changing etc.<\/p>\n<p>This resolved the issues for both Mantis and the 2intandem hosted web site.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I received 500 errors from both Mantis and 2intandem, giving this kind of error:- The server requested authentication method unknown to the client [mysql_old_password] In the case of 2intandem it was just a straight 500 unable to connect to database error, so the error was not so clear. However once I had fixed mantis, I [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[125],"tags":[],"_links":{"self":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/2256"}],"collection":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2256"}],"version-history":[{"count":1,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/2256\/revisions"}],"predecessor-version":[{"id":2257,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/2256\/revisions\/2257"}],"wp:attachment":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}