Libretime 3.0.0 upgrade - Unable to logon to the web interface

Get Help
1

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

2022-12-05T15:11:01+00:00 INFO (6): 134.209.85.27 Registered Component: 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.

2

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

3

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…

4

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.

5

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…

6

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.

7

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…

8

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

9

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…

10

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
11

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…

12

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?

13

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.

14

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…

15

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.

16

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…

17

Hi Joola

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

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,

18

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 ?

20

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
Screenshot 2022-12-22 at 14.16.561330×1276 147 KB

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

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):

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…

21

Please keep digging:

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

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 ?