# Libretime 3.0.0 upgrade - Unable to logon to the web interface

**URL:** <https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375>\
**Category:** Get Help\
**Created:** [December 5, 2022, 5:43pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375 "2022-12-05T17:43:40Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 5, 2022, 5:43pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/1 "2022-12-05T17:43:40Z")

</div>

Encountering challenges getting Libretime to run post upgrade.

**Describe The Problem**

I have recently attempted the upgrade to Libretine 3.0.0 from a pervious version and am encountered an issue accessing the LT console via the web interface.

**To Reproduce**

Upon entering my user credentials I’m redirected to the Oops! Something went wrong screen; selecting **Help**

I’m further directed to the repository; I’ve taken some time going through it with limited success.

**Expected Behaviour**

Upon authentication I’m expecting to be presented with the web UI/console.

**Relevant Log Output or Error Message**

I suspect the issue is potentially SQL related; find below an extract from /var/log/airtime/zendphp.log:

**2022-12-02T22:51:00+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”**

2022-12-03T00:41:12+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T02:55:53+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T04:32:42+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T06:54:57+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T07:01:15+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T07:13:27+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T07:15:09+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T07:20:57+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T07:32:09+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T07:55:16+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T08:02:58+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T08:17:10+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T08:25:22+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T08:38:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T08:47:22+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T08:53:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T09:14:04+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T09:24:04+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T09:27:34+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T09:57:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T10:35:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T10:41:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T10:42:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T10:47:58+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T10:55:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T11:01:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T11:02:58+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T11:04:34+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T11:45:52+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T12:16:04+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T12:38:22+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T12:43:28+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T13:05:10+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T13:06:16+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T13:32:16+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T13:58:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T14:06:28+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T14:28:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T15:02:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T15:04:10+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T15:28:58+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T15:46:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T15:54:28+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T15:56:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T17:26:04+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T17:39:28+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T17:54:58+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T18:03:34+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T18:41:10+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T18:43:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T19:47:34+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T20:06:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T20:26:52+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T20:47:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T21:27:04+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T21:54:16+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T22:00:22+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T22:17:16+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T22:28:10+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T22:30:34+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T22:42:52+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T22:54:28+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T23:18:58+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T23:27:28+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T23:30:52+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-03T23:31:28+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T00:26:58+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T00:36:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T00:46:04+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T01:37:22+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T01:37:58+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T02:17:34+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T02:31:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T02:35:04+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T02:47:46+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T02:49:04+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T03:00:10+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T03:08:22+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T03:11:52+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T03:37:58+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T03:55:22+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T03:58:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T04:34:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T04:35:28+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T04:42:04+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T04:45:28+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T05:02:22+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T05:38:22+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T05:42:34+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T05:59:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T06:38:40+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T06:42:52+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T07:42:10+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T08:36:17+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T08:39:11+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T08:59:59+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T09:16:23+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T09:40:35+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T10:00:41+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T10:15:23+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T10:20:47+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T11:06:47+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T11:20:41+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T11:26:53+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T12:00:41+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T12:04:23+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T12:51:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T13:17:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T13:30:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T13:40:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T14:00:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T14:31:36+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T14:47:18+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T14:50:42+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T15:12:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T15:30:54+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T15:40:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T16:02:00+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T16:02:18+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T16:05:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T16:08:12+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T16:22:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T16:35:36+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T16:41:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T16:42:30+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T16:48:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T17:11:12+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T17:21:18+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T17:41:18+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T18:32:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T18:49:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T19:23:00+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T19:41:48+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T19:43:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T20:09:30+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T20:26:36+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T21:06:54+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T21:12:12+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T21:19:42+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T21:33:30+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T22:03:36+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T22:04:54+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T22:14:00+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T22:52:42+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T22:54:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-04T23:12:48+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T00:50:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T01:00:42+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T01:19:30+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T01:45:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T01:53:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T02:01:00+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T02:21:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T02:22:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T02:28:12+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T02:45:12+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T02:58:36+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T03:05:12+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T03:23:54+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T03:44:00+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T03:48:30+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T05:14:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T05:15:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T05:15:42+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T05:31:42+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T05:51:48+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T05:54:36+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T05:59:06+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T06:05:36+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T06:09:30+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T06:14:42+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T06:21:54+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T06:44:48+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T06:49:18+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T06:50:48+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T07:05:54+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T07:09:24+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T07:16:18+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T07:19:30+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T07:29:30+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T07:35:00+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T07:36:00+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T07:56:01+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T08:12:13+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T08:16:07+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T08:36:13+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T09:09:55+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T10:25:49+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T10:27:07+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T11:10:31+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T11:12:55+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T11:26:49+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T14:03:00+00:00 INFO (6): 134.209.85.27 Notifying RabbitMQ to send message to pypo

2022-12-05T14:03:35+00:00 INFO (6): 134.209.85.27 Notifying RabbitMQ to send message to pypo

2022-12-05T14:03:35+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

2022-12-05T15:11:01+00:00 INFO (6): 134.209.85.27 Registered Component: [pypo@134.209.85.27](mailto:pypo@134.209.85.27)

2022-12-05T15:11:01+00:00 INFO (6): 134.209.85.27 Registered Component: [show-recorder@134.209.85.27](mailto:show-recorder@134.209.85.27)

2022-12-05T15:11:07+00:00 INFO (6): 134.209.85.27 Notifying RabbitMQ to send message to pypo

2022-12-05T15:11:10+00:00 WARN (4): 134.209.85.27 SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

**Libertime Version**

3.0.0.

**Installation Method and OS/Environment**

**OS:** Ubuntu 20.04 LTS

**Method** : Installation script

I’d really appreciate any help resolving my issue.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![robbt](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/robbt/32/15_2.png) [@robbt](https://discourse.libretime.org/u/robbt)\
**Post date:** [December 6, 2022, 3:09pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/2 "2022-12-06T15:09:44Z")

</div>

Are there any other errors as this usually isn’t a show stopper.

---

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 6, 2022, 4:17pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/3 "2022-12-06T16:17:24Z")

</div>

Hi Robbt,

Thanks for getting back to me.

No, that’s the only error I see; all the services are up and running.

I was wondering are there any other logs I should interrogate?

Regards…

---

<div class="post-metadata">

**Author:** ![joola](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@joola](https://discourse.libretime.org/u/joola)\
**Post date:** [December 7, 2022, 8:46am UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/4 "2022-12-07T08:46:05Z")

</div>

A lot of breaking change happen in the last releases, I highly recommend you to read the releases notes and the upgrades procedures.

The nginx logs might also give some more infos.

And also you should check the log for libretime, the log path you mentioned is outdated.

This might be a CORS / public\_url problem in the configuration.

---

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 7, 2022, 11:28am UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/5 "2022-12-07T11:28:09Z")

</div>

Hi Joola,

Thank you for your suggestions.

I did take the opportunity to review the version 3.0.0. documentation prior to embarking on the upgrade and for the most part everything seems to have been successful.

Taking your advice and have interrogated the logs below and found that they are empty:

access.log  
error.log  
libretime.error.log

The only log file that is populated is:  
libretime.access.log

This contains no error messages within the log file itself.

I will turn my attention to the CORS/public\_url problem you mentioned but in all honesty I’m not entirely sure what I’m looking for in terms or resolution.

Thanks for the invaluable insight.

Regards…

---

<div class="post-metadata">

**Author:** ![joola](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@joola](https://discourse.libretime.org/u/joola)\
**Post date:** [December 7, 2022, 11:41am UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/6 "2022-12-07T11:41:27Z")

</div>

If you don’t have any logs in /var/log/libretime/ and your UI is failing hard, your installation is broken.

Search for logs, you should have some traces/status somewhere.

> **[Troubleshooting | LibreTime](https://libretime.org/docs/admin-manual/troubleshooting/)**
>
> This guide walk you though the steps required to troubleshoot LibreTime.

---

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 8, 2022, 2:47pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/7 "2022-12-08T14:47:00Z")

</div>

Hi Joola,

Thanks for the help to date.

After hours of troubleshooting I decided to start from scratch and delete the old instance opting to do a clean install.

However I’ve now come across a new issues which centres around the installation of Postgresql and not having the appropriate permissions (see below):

╔══════════════════════════════════════════════════════════════════════════════╗  
║ PostgreSQL ║  
╚══════════════════════════════════════════════════════════════════════════════╝  
could not change directory to “/root/libretime”: Permission denied  
info: creating PostgreSQL user ‘libretime’  
could not change directory to “/root/libretime”: Permission denied  
could not change directory to “/root/libretime”: Permission denied  
ALTER ROLE  
could not change directory to “/root/libretime”: Permission denied  
info: creating PostgreSQL database ‘libretime’ with owner ‘libretime’  
could not change directory to “/root/libretime”: Permission denied

I’m not entirely sure whether I need to affect a change utilising chmod it would be helpful to get a steer for fear of messing things up installation wise.

Regards…

---

<div class="post-metadata">

**Author:** ![joola](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@joola](https://discourse.libretime.org/u/joola)\
**Post date:** [December 8, 2022, 3:01pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/8 "2022-12-08T15:01:44Z")

</div>

Those warnings can be ignored, unless it did stop the install script ?

---

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 8, 2022, 4:08pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/9 "2022-12-08T16:08:55Z")

</div>

Hi Joola,

I’m not entirely sure…

The db migrations are completed and services started and are functioning as you might expect.

I can access the console but can’t save any changes as I get the “oops something went wrong” error message.

Looking at the logs to find any discrepancies; nothing obvious though.

Regards…

---

<div class="post-metadata">

**Author:** ![joola](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@joola](https://discourse.libretime.org/u/joola)\
**Post date:** [December 8, 2022, 5:10pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/10 "2022-12-08T17:10:23Z")

</div>

Could you paste:

- your config, without the sensitive data
- the logs from `/var/log/libretime/legacy.log`
- the logs from `/var/log/nginx/libretime.error.log`

> **[Troubleshooting | LibreTime](https://libretime.org/docs/admin-manual/troubleshooting/#logs)**
>
> This guide walk you though the steps required to troubleshoot LibreTime.

---

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 9, 2022, 2:03pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/11 "2022-12-09T14:03:54Z")

</div>

Hi Joola,

Here is an extract of /var/log/libretime/legacy.log:

2022-12-08T14:13:42+00:00 WARN (4): SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_pref” does not exist  
LINE 1: SELECT \* FROM cc\_pref WHERE keystr=‘task\_manager\_lock’ LIMIT…  
^  
2022-12-08T14:13:47+00:00 WARN (4): SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_pref” does not exist  
LINE 1: SELECT \* FROM cc\_pref WHERE keystr=‘task\_manager\_lock’ LIMIT…  
^  
2022-12-08T14:13:52+00:00 WARN (4): SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_pref” does not exist  
LINE 1: SELECT \* FROM cc\_pref WHERE keystr=‘task\_manager\_lock’ LIMIT…  
^  
2022-12-08T14:13:57+00:00 WARN (4): SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_pref” does not exist  
LINE 1: SELECT \* FROM cc\_pref WHERE keystr=‘task\_manager\_lock’ LIMIT…  
^  
2022-12-08T14:13:59+00:00 INFO (6): Could not connect to database: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_pref” does not exist  
LINE 1: SELECT COUNT(\*) FROM cc\_pref WHERE keystr = $1  
^ in /usr/share/libretime/legacy/application/common/Database.php:26  
Stack trace:  
#0 /usr/share/libretime/legacy/application/common/Database.php(26): PDOStatement-\>execute()  
#1 /usr/share/libretime/legacy/application/models/Preference.php(173): Application\_Common\_Database::prepareAndExecute()  
#2 /usr/share/libretime/legacy/application/models/Preference.php(207): Application\_Model\_Preference::getValue()  
#3 /usr/share/libretime/legacy/application/controllers/IndexController.php(13): Application\_Model\_Preference::GetHeadTitle()  
#4 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action.php(516): IndexController-\>indexAction()  
#5 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Dispatcher/Standard.php(308): Zend\_Controller\_Action-\>dispatch()  
#6 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(954): Zend\_Controller\_Dispatcher\_Standard-\>dispatch()  
#7 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#8 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#9 /usr/share/libretime/legacy/application/airtime-boot.php(77): Zend\_Application-\>run()  
#10 /usr/share/libretime/legacy/public/index.php(56): require\_once(‘/usr/share/libr…’)  
#11 {main}

There is nothing in the /var/log/nginx/libretime.error.log

Regards…

---

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 9, 2022, 2:14pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/12 "2022-12-09T14:14:06Z")

</div>

Would I be right in assuming that the requisite tables may not have been created due to the appropriate permissions being in place to allow the install script to do its thing in terms of Postgresql set-up?

---

<div class="post-metadata">

**Author:** ![joola](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@joola](https://discourse.libretime.org/u/joola)\
**Post date:** [December 9, 2022, 2:59pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/13 "2022-12-09T14:59:46Z")

</div>

So it seems that database hasn’t been migrated (created).

If you don’t recall running `libretime-api migrate`, I recommend you to read the install documentation again, and make sure to read and follow every steps.

---

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 9, 2022, 3:20pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/14 "2022-12-09T15:20:43Z")

</div>

Hi Joola,

I did run the migrate command prior to initialising the services:

sudo -u libretime libretime-api migrated

And have ran it again:

Operations to perform:  
Apply all migrations: auth, contenttypes, legacy, sessions  
Running migrations:  
No migrations to apply.

Rest assured I read the complete documentation set before I started the clean install and followed the instructions implicitly so I’m at a loss to understand why I can’t get it to function as per your expectations.

Regards…

---

<div class="post-metadata">

**Author:** ![joola](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@joola](https://discourse.libretime.org/u/joola)\
**Post date:** [December 9, 2022, 3:41pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/15 "2022-12-09T15:41:09Z")

</div>

When I help people, they often do not read documentation thoroughly and I sometimes assume this has become the normal, sorry about that.

The logs you posted might have been generated between the installation step and the migration step, this short time lapse could have generated those logs;

So you should try to access libretime on the browser, and only capture the logs for that period.

Maybe you can post more information about your setup, such as your config, maybe the browser console logs show some informations. Or event the browser network console.

Maybe something is wrong with your configuration.

---

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 9, 2022, 3:56pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/16 "2022-12-09T15:56:49Z")

</div>

Hi Joola,

No need for an apology; you do great work!

I can imagine this can be frustrating from time to time so it’s perfectly understandable to provide a stock response given the number of queries you answer during the course of your day.

As suggested, I will interrogate the logs and come back to you.

Once again, thanks!

Regards…

---

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 9, 2022, 4:47pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/17 "2022-12-09T16:47:26Z")

</div>

Hi Joola

Here is the log from /var/log/libretime/legacy.log:

```auto
2022-12-09T15:38:07+00:00 ERR (3): [ErrorController.php:62 - errorAction()] - An internal application error has >
Stack trace:
#0 [internal function]: PhpAmqpLib\Connection\AbstractConnection->connection_close()
#1 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Channel/AbstractChannel.php(217): call_>
#2 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Channel/AbstractChannel.php(374): PhpAm>
#3 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(277):>
#4 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(236):>
#5 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AMQPStreamConnection.php(63)>
#6 /usr/share/libretime/legacy/application/check.php(120): PhpAmqpLib\Connection\AMQPStreamConnection->__constru>
#7 /usr/share/libretime/legacy/application/check.php(63): checkRMQConnection()
#8 /usr/share/libretime/legacy/application/views/scripts/systemstatus/index.phtml(7): checkExternalServices()
#9 /usr/share/libretime/legacy/vendor/zf1s/zend-view/library/Zend/View.php(157): include('/usr/share/libr...')
#10 /usr/share/libretime/legacy/vendor/zf1s/zend-view/library/Zend/View/Abstract.php(890): Zend_View->_run()
#11 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action/Helper/ViewRenderer.p>
#12 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action/Helper/ViewRenderer.p>
#13 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action/Helper/ViewRenderer.p>
#14 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action/HelperBroker.php(277)>
#15 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action.php(527): Zend_Contro>
#16 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Dispatcher/Standard.php(308)>
#17 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(954): Zend_Control>
#18 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(10>
#19 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend_Application>
#20 /usr/share/libretime/legacy/application/airtime-boot.php(77): Zend_Application->run()
#21 /usr/share/libretime/legacy/public/index.php(56): require_once('/usr/share/libr...')
#22 {main}

```

The log for /var/log/nginx/libretime.error.log still remains empty.

Regards,

---

<div class="post-metadata">

**Author:** ![joola](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@joola](https://discourse.libretime.org/u/joola)\
**Post date:** [December 12, 2022, 3:20pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/18 "2022-12-12T15:20:19Z")

</div>

Your logs seem to be truncated at the end.

Feel free to post the whole file.

Have you checked all the services are running ? Specially rabbitmq ?

What about your config file ?

---

<div class="post-metadata">

**Author:** ![Orogonalsoulbwoy](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Orogonalsoulbwoy](https://discourse.libretime.org/u/Orogonalsoulbwoy)\
**Post date:** [December 22, 2022, 5:10pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/20 "2022-12-22T17:10:31Z")

</div>

So once again, I decided to delete the instance and re-install version 3.0.1.

The installation has largely been successful; however, accessing the web UI status screen I note the following:

 ![Screenshot 2022-12-22 at 14.16.56](https://canada1.discourse-cdn.com/flex036/uploads/libretime/original/1X/b9932c397bb3e5632ac0281a79400fd64895f48e.png)

Following the dialog I ran the commands and noted the output from the CLI:

```auto
root@ubuntu-s-1vcpu-2gb-ams3-01:~/libretime# sudo rabbitmqctl list_users
Listing users ...
user tags
guest [administrator]
libretime []
root@ubuntu-s-1vcpu-2gb-ams3-01:~/libretime# sudo rabbitmqctl list_vhosts
Listing vhosts ...
name
/libretime
/
root@ubuntu-s-1vcpu-2gb-ams3-01:~/libretime# sudo rabbitmqctl list_exchanges
Listing exchanges for vhost / ...
name type
amq.match headers
amq.rabbitmq.trace topic
amq.topic topic
amq.fanout fanout
amq.headers headers
amq.direct direct
        direct

```

Reviewing the /var/log/libretime/legacy.log file access credentials (see attached):

```auto
2022-12-22T01:34:12+00:00 ERR (3): [ErrorController.php:28 - errorAction()] - Incorrect API key
2022-12-22T01:34:12+00:00 ERR (3): [ErrorController.php:29 - errorAction()] - #0 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(309): Zend_Controller_Plugin_Acl->preDispatch()
#1 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch()
#2 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#3 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend_Application_Bootstrap_Bootstrap->run()
#4 /usr/share/libretime/legacy/application/airtime-boot.php(77): Zend_Application->run()
#5 /usr/share/libretime/legacy/public/index.php(56): require_once('/usr/share/libr...')
#6 {main}
2022-12-22T01:34:12+00:00 ERR (3): [ErrorController.php:62 - errorAction()] - An internal application error has occurred.: Zend_Controller_Exception: Incorrect API key in /usr/share/libretime/legacy/application/controllers/plugins/Acl_plugin.php:137
Stack trace:
#0 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(309): Zend_Controller_Plugin_Acl->preDispatch()
#1 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch()
#2 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#3 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend_Application_Bootstrap_Bootstrap->run()
#4 /usr/share/libretime/legacy/application/airtime-boot.php(77): Zend_Application->run()
#5 /usr/share/libretime/legacy/public/index.php(56): require_once('/usr/share/libr...')
#6 {main}
2022-12-22T11:56:01+00:00 ERR (3): [check.php:128 - checkRMQConnection()] - ACCESS_REFUSED - Login was refused using authentication mechanism AMQPLAIN. For details see the broker logfile.(0, 0)
2022-12-22T12:17:42+00:00 INFO (6): Registered Component: pypo@MY_IP_ADDRESS
2022-12-22T12:17:47+00:00 INFO (6): Registered Component: show-recorder@MY_IP_ADDRESS
2022-12-22T12:17:49+00:00 INFO (6): Notifying RabbitMQ to send message to pypo
2022-12-22T12:17:49+00:00 ERR (3): [ErrorController.php:28 - errorAction()] - ACCESS_REFUSED - Login was refused using authentication mechanism AMQPLAIN. For details see the broker logfile.(0, 0)
2022-12-22T12:17:49+00:00 ERR (3): [ErrorController.php:29 - errorAction()] - #0 [internal function]: PhpAmqpLib\Connection\AbstractConnection->connection_close()
#1 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Channel/AbstractChannel.php(217): call_user_func()
#2 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Channel/AbstractChannel.php(374): PhpAmqpLib\Channel\AbstractChannel->dispatch()
#3 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(277): PhpAmqpLib\Channel\AbstractChannel->wait()
#4 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(236): PhpAmqpLib\Connection\AbstractConnection->connect()
#5 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AMQPStreamConnection.php(63): PhpAmqpLib\Connection\AbstractConnection->__construct()
#6 /usr/share/libretime/legacy/application/models/RabbitMq.php(24): PhpAmqpLib\Connection\AMQPStreamConnection->__construct()
#7 /usr/share/libretime/legacy/application/models/RabbitMq.php(57): Application_Model_RabbitMq::sendMessage()
#8 /usr/share/libretime/legacy/application/controllers/ApiController.php(1142): Application_Model_RabbitMq::SendMessageToPypo()
#9 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action.php(516): ApiController->rabbitmqDoPushAction()
#10 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#11 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#12 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#13 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend_Application_Bootstrap_Bootstrap->run()
#14 /usr/share/libretime/legacy/application/airtime-boot.php(77): Zend_Application->run()
#15 /usr/share/libretime/legacy/public/index.php(56): require_once('/usr/share/libr...')
#16 {main}
2022-12-22T12:17:49+00:00 ERR (3): [ErrorController.php:62 - errorAction()] - An internal application error has occurred.: PhpAmqpLib\Exception\AMQPConnectionClosedException: ACCESS_REFUSED - Login was refused using authentication mechanism AMQPLAIN. For details see the broker logfile.(0, 0) in /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php:779
Stack trace:
#0 [internal function]: PhpAmqpLib\Connection\AbstractConnection->connection_close()
#1 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Channel/AbstractChannel.php(217): call_user_func()
#2 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Channel/AbstractChannel.php(374): PhpAmqpLib\Channel\AbstractChannel->dispatch()
#3 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(277): PhpAmqpLib\Channel\AbstractChannel->wait()
#4 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(236): PhpAmqpLib\Connection\AbstractConnection->connect()
#5 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AMQPStreamConnection.php(63): PhpAmqpLib\Connection\AbstractConnection->__construct()
#6 /usr/share/libretime/legacy/application/models/RabbitMq.php(24): PhpAmqpLib\Connection\AMQPStreamConnection->__construct()
#7 /usr/share/libretime/legacy/application/models/RabbitMq.php(57): Application_Model_RabbitMq::sendMessage()
#8 /usr/share/libretime/legacy/application/controllers/ApiController.php(1142): Application_Model_RabbitMq::SendMessageToPypo()
#9 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action.php(516): ApiController->rabbitmqDoPushAction()
#10 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#11 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#12 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#13 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend_Application_Bootstrap_Bootstrap->run()
#14 /usr/share/libretime/legacy/application/airtime-boot.php(77): Zend_Application->run()
#15 /usr/share/libretime/legacy/public/index.php(56): require_once('/usr/share/libr...')
#16 {main}
2022-12-22T12:20:51+00:00 ERR (3): [check.php:128 - checkRMQConnection()] - ACCESS_REFUSED - Login was refused using authentication mechanism AMQPLAIN. For details see the broker logfile.(0, 0)
2022-12-22T13:07:37+00:00 ERR (3): [ErrorController.php:28 - errorAction()] - ACCESS_REFUSED - Login was refused using authentication mechanism AMQPLAIN. For details see the broker logfile.(0, 0)
2022-12-22T13:07:37+00:00 ERR (3): [ErrorController.php:29 - errorAction()] - #0 [internal function]: PhpAmqpLib\Connection\AbstractConnection->connection_close()
#1 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Channel/AbstractChannel.php(217): call_user_func()
#2 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Channel/AbstractChannel.php(374): PhpAmqpLib\Channel\AbstractChannel->dispatch()
#3 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(277): PhpAmqpLib\Channel\AbstractChannel->wait()
#4 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(236): PhpAmqpLib\Connection\AbstractConnection->connect()
#5 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AMQPStreamConnection.php(63): PhpAmqpLib\Connection\AbstractConnection->__construct()
#6 /usr/share/libretime/legacy/application/models/RabbitMq.php(24): PhpAmqpLib\Connection\AMQPStreamConnection->__construct()
#7 /usr/share/libretime/legacy/application/models/RabbitMq.php(57): Application_Model_RabbitMq::sendMessage()
#8 /usr/share/libretime/legacy/application/models/Preference.php(230): Application_Model_RabbitMq::SendMessageToPypo()
#9 /usr/share/libretime/legacy/application/controllers/PreferenceController.php(39): Application_Model_Preference::SetHeadTitle()
#10 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action.php(516): PreferenceController->indexAction()
#11 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#12 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#13 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#14 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend_Application_Bootstrap_Bootstrap->run()
#15 /usr/share/libretime/legacy/application/airtime-boot.php(77): Zend_Application->run()
#16 /usr/share/libretime/legacy/public/index.php(56): require_once('/usr/share/libr...')
#17 {main}
2022-12-22T13:07:37+00:00 ERR (3): [ErrorController.php:62 - errorAction()] - An internal application error has occurred.: PhpAmqpLib\Exception\AMQPConnectionClosedException: ACCESS_REFUSED - Login was refused using authentication mechanism AMQPLAIN. For details see the broker logfile.(0, 0) in /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php:779
Stack trace:
#0 [internal function]: PhpAmqpLib\Connection\AbstractConnection->connection_close()
#1 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Channel/AbstractChannel.php(217): call_user_func()
#2 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Channel/AbstractChannel.php(374): PhpAmqpLib\Channel\AbstractChannel->dispatch()
#3 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(277): PhpAmqpLib\Channel\AbstractChannel->wait()
#4 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(236): PhpAmqpLib\Connection\AbstractConnection->connect()
#5 /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AMQPStreamConnection.php(63): PhpAmqpLib\Connection\AbstractConnection->__construct()
#6 /usr/share/libretime/legacy/application/models/RabbitMq.php(24): PhpAmqpLib\Connection\AMQPStreamConnection->__construct()
#7 /usr/share/libretime/legacy/application/models/RabbitMq.php(57): Application_Model_RabbitMq::sendMessage()
#8 /usr/share/libretime/legacy/application/models/Preference.php(230): Application_Model_RabbitMq::SendMessageToPypo()
#9 /usr/share/libretime/legacy/application/controllers/PreferenceController.php(39): Application_Model_Preference::SetHeadTitle()
#10 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action.php(516): PreferenceController->indexAction()
#11 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#12 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#13 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#14 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend_Application_Bootstrap_Bootstrap->run()
#15 /usr/share/libretime/legacy/application/airtime-boot.php(77): Zend_Application->run()
#16 /usr/share/libretime/legacy/public/index.php(56): require_once('/usr/share/libr...')
#17 {main}
2022-12-22T13:19:59+00:00 ERR (3): [CORSHelper.php:13 - enableCrossOriginRequests()] - request origin 'MY_WEB_ADDRESS' is not in allowed 'http://MY_IP_ADDRESS, '!
2022-12-22T13:19:59+00:00 NOTICE (5): Trying to get property 'id' of non-object
2022-12-22T13:19:59+00:00 ERR (3): [ErrorController.php:28 - errorAction()] - Forbidden
2022-12-22T13:19:59+00:00 ERR (3): [ErrorController.php:29 - errorAction()] - #0 /usr/share/libretime/legacy/application/controllers/LoginController.php(24): CORSHelper::enableCrossOriginRequests()
#1 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action.php(516): LoginController->indexAction()
#2 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#3 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#4 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#5 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend_Application_Bootstrap_Bootstrap->run()
#6 /usr/share/libretime/legacy/application/airtime-boot.php(77): Zend_Application->run()
#7 /usr/share/libretime/legacy/public/index.php(56): require_once('/usr/share/libr...')
#8 {main}
2022-12-22T13:19:59+00:00 ERR (3): [ErrorController.php:62 - errorAction()] - An internal application error has occurred.: Zend_Controller_Action_Exception: Forbidden in /usr/share/libretime/legacy/application/common/CORSHelper.php:15
Stack trace:
#0 /usr/share/libretime/legacy/application/controllers/LoginController.php(24): CORSHelper::enableCrossOriginRequests()
#1 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action.php(516): LoginController->indexAction()
#2 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#3 /usr/share/libretime/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#4 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#5 /usr/share/libretime/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend_Application_Bootstrap_Bootstrap->run()
#6 /usr/share/libretime/legacy/application/airtime-boot.php(77): Zend_Application->run()
#7 /usr/share/libretime/legacy/public/index.php(56): require_once('/usr/share/libr...')
#8 {main}
2022-12-22T13:20:47+00:00 ERR (3): [check.php:128 - checkRMQConnection()] - ACCESS_REFUSED - Login was refused using authentication mechanism AMQPLAIN. For details see the broker logfile.(0, 0)
2022-12-22T13:21:23+00:00 ERR (3): [check.php:128 - checkRMQConnection()] - ACCESS_REFUSED - Login was refused using authentication mechanism AMQPLAIN. For details see the broker logfile.(0, 0)
2022-12-22T13:23:08+00:00 ERR (3): [check.php:128 - checkRMQConnection()] - ACCESS_REFUSED - Login was refused using authentication mechanism AMQPLAIN. For details see the broker logfile.(0, 0)

```

My assumption is that its RabbitMQ related but am unsure how I would resolve the messages.

Regards…

---

<div class="post-metadata">

**Author:** ![joola](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@joola](https://discourse.libretime.org/u/joola)\
**Post date:** [December 26, 2022, 3:50pm UTC](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375/21 "2022-12-26T15:50:35Z")

</div>

> [@Orogonalsoulbwoy](#):
>
> My assumption is that its RabbitMQ related but am unsure how I would resolve the messages.

Please keep digging:

```auto
PhpAmqpLib\Exception\AMQPConnectionClosedException: ACCESS_REFUSED - Login was refused using authentication mechanism AMQPLAIN. For details see the broker logfile.(0, 0) in /usr/share/libretime/legacy/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php:779

```

This line tells you to look in the rabbitmq logs. So, just like libretime, rabbitmq stores its logs in `/var/log`.

If you look inside the `/var/log/rabbitmq/` directory, you should find the logs of the running rabbitmq server that will help you understand the problem.

Understand that I don’t have any magic command to solve your problem, you will have to fix it yourself. I can just give you some pointers.

[https://www.rabbitmq.com/logging.html](https://www.rabbitmq.com/logging.html)

I just installed LibreTime 3.0.1 on ubuntu 20.04 LTS and it’s working as expected.

Also it seem like you are facing a different problem from the one you initially described ‘unable to logon’, and it seem you now start from a fresh install, without upgrading ?

[Next page](https://discourse.libretime.org/t/libretime-3-0-0-upgrade-unable-to-logon-to-the-web-interface/1375.md?page=2)