<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><span style="font-size: 14px;" class="">Hi Jeff, looking at the logs in your gist the locale column doesn't exist on the actor.usr table. This is causing the cstore call to fail which returns a 500 error to the auth service which just returns a generic login failure to you. This column is added in the 3.8.0-3.9.0 upgrade script which I believe failed because the 3.7.1-3.8.0 script likely also failed.</span><div class=""><span style="font-size: 14px;" class=""><br class=""></span></div><div class=""><span style="font-size: 14px;" class="">I noticed you mentioned upgrading from 3.7.2 to 3.9.0 and running the 3.7.1-3.8.0 and 3.8.0-3.9.0 scripts to perform the upgrade. Unless you edited it, the 3.7.1-3.8.0 script will have failed because 12 of the changes between 3.7.1 and 3.8.0 were already been applied during the 3.7.1-3.7.2 upgrade. Upgrade scripts 1266, 1268, 1269, 1270, 1272, 1273, 1279, 1282, 1283, 1294, 1302, and 1303 were already applied in the 3.7.1-3.7.2 upgrade script and are also applied in the 3.7.1-3.8.0 upgrade script. You can finish the 3.7.2-3.8.0 upgrade by manually applying the 1260, 1267, 1271, 1274, 1275, 1276, 1277, 1278, 1280, 1281, 1284, 1285, 1286, 1287, 1288, 1289, 1290, 1291, 1292, 1293, 1295, 1296, 1297, 1298, 1299, 1300, 1301, 1304, 1305, and 1306 scripts from the Open-ILS/src/sql/Pg/upgrade/ directory. You'll also need to define the eg_version psql variable when applying them,</span><span style="font-size: 14px;" class=""> like so:</span></div><div class=""><span style="font-size: 14px;" class="">psql -v "eg_version='3.8.0'" -f xxxx.....sql</span></div><div class=""><span style="font-size: 14px;" class="">Once those scripts have been applied the 3.8.0-3.9.0 script can be run again and this time it should succeed.</span></div><div class=""><span style="font-size: 14px;" class=""><br class=""></span></div><div class=""><span style="font-size: 14px;" class="">What likely happened is that the 3.8.0-3.9.0 script depended on something existing that was added in the failed 3.7.1-3.8.0 script and when that was missing the whole upgrade script failed because it all takes place in 1 big transaction.</span></div><div class=""><span style="font-size: 14px;" class=""><br class=""></span></div><div class=""><div class=""><span style="font-size: 14px;" class="">Jason<br class=""></span><div><span style="font-size: 14px;" class=""><br class=""></span><blockquote type="cite" class=""><div class=""><span style="font-size: 14px;" class="">On Jun 2, 2022, at 8:50 PM, Jeffrey G via Evergreen-dev <<a href="mailto:evergreen-dev@list.evergreen-ils.org" class="">evergreen-dev@list.evergreen-ils.org</a>> wrote:</span></div><span style="font-size: 14px;" class=""><br class="Apple-interchange-newline"></span><div class=""><div class=""><span style="font-size: 14px;" class="">I upgraded from 3.7.2 to 3.9.0 today.<br class=""><br class="">I stopped all services, followed the install instructions for 3.9.0,<br class="">then ran the 3.7.1-3.8.0-upgrade-db.sql and 3.8.0-3.9.0-upgrade-db.sql<br class="">scripts, then restarted all services.<br class=""><br class="">I tried to login through srfsh, which failed, so I rebooted and tried<br class="">again; it still continues to fail with:<br class=""><br class=""> Received Data: {<br class=""> "ilsevent":1000,<br class=""> "textcode":"LOGIN_FAILED",<br class=""> "desc":"User login failed",<br class=""> "pid":7392,<br class=""> "stacktrace":"oils_auth.c:733"<br class=""> }<br class=""><br class="">Web logins are failing as well.<br class=""><br class="">The results from settings-tester.pl appear OK to me.<br class=""><br class="">I've created a GitHub gist some more output, both .conf files, and the<br class="">log files here:<br class=""><br class=""> <a href="https://gist.github.com/jdgoettsch/cf20ed49ddca577564b5153a688c7983" class="">https://gist.github.com/jdgoettsch/cf20ed49ddca577564b5153a688c7983</a><br class=""><br class="">Any ideas where things went wrong? Any help is appreciated.<br class=""><br class="">-- <br class="">Jeff Goettsch<br class="">Agricultural and Resource Economics<br class="">530-752-2219<br class=""><a href="https://are.ucdavis.edu/" class="">https://are.ucdavis.edu/</a><br class="">_______________________________________________<br class="">Evergreen-dev mailing list<br class="">Evergreen-dev@list.evergreen-ils.org<br class="">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev<br class=""></span></div></div></blockquote></div><br class=""></div></div></body></html>