Ed Wong wrote: > As an addendum, I found the only mention of "kallitheavhost" > and that was with my celery line in the configuration. > > celery.broker_url = redis://<usr>:<pwd>@<host>:<ip>/kallitheavhost > > I'm wondering if I actually got this url string correct. >
Sorry for the noise, looks like it's a PEBCAK again. ;/ The redis url is actually: redis://<host>:<port>/0 But even after reading the celery doc from https://docs.celeryq.dev/en/stable/getting-started/backends-and-brokers/redis.html, I'm unsure if this is even right as when I set that, I get a 'better' response: 2024-11-21 09:13:48.762 INFO [sqlalchemy.engine.base.Engine] (9, 2) 2024-11-21 09:13:48.762 DEBUG [sqlalchemy.engine.base.Engine] Col ('user_followings_user_following_id', 'user_followings_user_id', 'user_followings_follows_repository_id', 'user_followings_follows_user_id', 'user_followings_follows_from') 2024-11-21 09:13:48.762 DEBUG [sqlalchemy.engine.base.Engine] Row (8, 2, 9, None, '2024-11-21 09:13:48.275526') 2024-11-21 09:13:48.763 DEBUG [kallithea.lib.auth] Checking access for user <AuthUser 2: 'ewong'> @ SummaryController:index 2024-11-21 09:13:48.763 INFO [kallithea.lib.auth] user <AuthUser 2: 'ewong'> authenticated with regular auth @ SummaryController:index 2024-11-21 09:13:48.763 DEBUG [kallithea.lib.auth] checking HasRepoPermissionLevelDecorator permissions (['read'],) for <kallithea.controllers.summary.SummaryController object at 0xb11c48c8> <AuthUser 2: 'ewong'> 2024-11-21 09:13:48.763 DEBUG [kallithea.lib.auth] Getting repository permissions for <AuthUser 2: 'ewong'> 2024-11-21 09:13:48.767 INFO [sqlalchemy.engine.base.Engine] SELECT repo_to_perm.repo_to_perm_id AS repo_to_perm_repo_to_perm_id, repo_to_perm.user_id AS repo_to_perm_user_id, repo_to_perm.permission_id AS repo_to_perm_permission_id, repo_to_perm.repository_id AS repo_to_perm_repository_id, repositories_1.user_id AS repositories_1_user_id, repositories_1.statistics AS repositories_1_statistics, repositories_1.downloads AS repositories_1_downloads, repositories_1.landing_revision AS repositories_1_landing_revision, repositories_1.changeset_cache AS repositories_1_changeset_cache, repositories_1.repo_id AS repositories_1_repo_id, repositories_1.repo_name AS repositories_1_repo_name, repositories_1.repo_state AS repositories_1_repo_state, repositories_1.clone_uri AS repositories_1_clone_uri, repositories_1.repo_type AS repositories_1_repo_type, repositories_1.private AS repositories_1_private, repositories_1.description AS repositories_1_description, repositories_1.created_on AS repositories_1_created_on, repositories_1.updated_on AS repositories_1_updated_on, repositories_1.fork_id AS repositories_1_fork_id, repositories_1.group_id AS repositories_1_group_id, permissions_1.permission_id AS permissions_1_permission_id, permissions_1.permission_name AS permissions_1_permission_name FROM repo_to_perm LEFT OUTER JOIN repositories AS repositories_1 ON repositories_1.repo_id = repo_to_perm.repository_id LEFT OUTER JOIN permissions AS permissions_1 ON permissions_1.permission_id = repo_to_perm.permission_id WHERE repo_to_perm.user_id = ? 2024-11-21 09:13:48.767 INFO [sqlalchemy.engine.base.Engine] (1,) 2024-11-21 09:13:48.767 DEBUG [sqlalchemy.engine.base.Engine] Col ('repo_to_perm_repo_to_perm_id', 'repo_to_perm_user_id', 'repo_to_perm_permission_id', 'repo_to_perm_repository_id', 'repositories_1_user_id', 'repositories_1_statistics', 'repositories_1_downloads', 'repositories_1_landing_revision', 'repositories_1_changeset_cache', 'repositories_1_repo_id', 'repositories_1_repo_name', 'repositories_1_repo_state', 'repositories_1_clone_uri', 'repositories_1_repo_type', 'repositories_1_private', 'repositories_1_description', 'repositories_1_created_on', 'repositories_1_updated_on', 'repositories_1_fork_id', 'repositories_1_group_id', 'permissions_1_permission_id', 'permissions_1_permission_name') 2024-11-21 09:13:48.768 DEBUG [sqlalchemy.engine.base.Engine] Row (1, 1, 3, 1, 2, 0, 0, 'rev:tip', b'{"short_id": "49c6cbd0f7a4", "raw_id": "49c6cbd0f7a4a3d85189c428a0989b3491680cd7", "revision": 15665, "message": "Bug 1432027 - Update pdf.js to version 2.0.288. r=bdahl", "date": "2018-01-21T22:46:41", "author": "Ryan VanderMeulen <[email protected]>"}', 1, 'code/release/mozilla-release', 'repo_state_created', 'https://foss.heptapod.net/seamonkey/mozilla-release', 'hg', 0, 'mozilla-release', '2024-02-29 08:35:22.345017', '2018-01-21 22:46:41.000000', None, 3, 3, 'repository.read') 2024-11-21 09:13:48.768 DEBUG [sqlalchemy.engine.base.Engine] Row (2, 1, 3, 2, 2, 0, 0, 'rev:tip', b'{"short_id": "67dc920d4b4d", "raw_id": "67dc920d4b4d8428e5edcd7b39d359c763eb2895", "revision": 21760, "message": "close obsolete gloda-facet branch", "date": "2022-02-07T06:05:58", "author": "Frank-Rainer Grahl <[email protected]>"}', 2, 'code/release/comm-release', 'repo_state_created', 'https://foss.heptapod.net/seamonkey/comm-release', 'hg', 0, 'comm-release', '2024-02-29 08:39:35.175544', '2022-02-07 06:05:58.000000', None, 3, 3, 'repository.read') 2024-11-21 09:13:48.768 DEBUG [sqlalchemy.engine.base.Engine] Row (3, 1, 3, 3, 2, 0, 0, 'rev:tip', b'{"short_id": "f80b925f6772", "raw_id": "f80b925f6772c19f2eb2b0957af71c2a7b5a6c44", "revision": 43112, "message": "Bug 1928953 - Improve performance ... (113 characters truncated) ... erential Revision: https://phabricator.services.mozilla.com/D227822";, "date": "2024-11-19T13:49:56", "author": "John Bieling <[email protected]>"}', 3, 'code/central/comm-central', 'repo_state_created', 'https://hg.mozilla.org/comm-central', 'hg', 0, 'comm-central', '2024-02-29 09:17:07.681246', '2024-11-19 13:49:56.000000', None, 2, 3, 'repository.read') 2024-11-21 09:13:48.769 DEBUG [sqlalchemy.engine.base.Engine] Row (4, 1, 3, 4, 2, 0, 0, 'rev:tip', b'{"short_id": "c845f3207181", "raw_id": "c845f32071817c81069390d3ba4f06b0ee270c20", "revision": 762863, "message": "Backed out 3 changesets (bug 1928 ... (136 characters truncated) ... bug 1928734)\\nBacked out changeset a9f66c1d560d (bug 1928734)", "date": "2024-11-19T07:49:22", "author": "Butkovits Atila <[email protected]>"}', 4, 'code/central/mozilla-central', 'repo_state_created', 'https://hg.mozilla.org/mozilla-central', 'hg', 0, 'mozilla-central', '2024-02-29 09:19:57.337581', '2024-11-19 07:49:22.000000', None, 2, 3, 'repository.read') 2024-11-21 09:13:48.769 DEBUG [sqlalchemy.engine.base.Engine] Row (5, 1, 3, 5, 2, 0, 0, 'rev:tip', b'{"short_id": "55b82abe7eeb", "raw_id": "55b82abe7eeb77fb5d847d45f4c7532559f9980e", "revision": 3911, "message": "remove leading / from dirs\\n", "date": "2024-11-13T08:57:47", "author": "Edmund Wong <[email protected]>"}', 5, 'infrastructure/tools', 'repo_state_created', '', 'git', 0, 'tools', '2024-02-29 10:30:20.170808', '2024-11-13 08:57:47.000000', None, 4, 3, 'repository.read') 2024-11-21 09:13:48.769 DEBUG [sqlalchemy.engine.base.Engine] Row (10, 1, 3, 7, 2, 0, 0, 'rev:tip', None, 7, 'code/central/patches/mcpatches', 'repo_state_created', None, 'hg', 0, 'code/central/patches/mcpatches repository', '2024-03-01 08:42:47.382856', '2024-03-01 08:42:47.382865', None, 5, 3, 'repository.read') 2024-11-21 09:13:48.769 DEBUG [sqlalchemy.engine.base.Engine] Row (11, 1, 3, 8, 2, 0, 0, 'rev:tip', b'{"short_id": "b30147a58521", "raw_id": "b30147a5852119bb67d99c7713a060b1ffadd8b5", "revision": 0, "message": "Initial Commit some patches", "date": "2024-03-01T16:32:04", "author": "Edmund Wong <[email protected]>"}', 8, 'code/central/patches/ccpatches', 'repo_state_created', None, 'hg', 0, 'code/central/patches/ccpatches repository', '2024-03-01 08:43:26.757363', '2024-03-01 16:32:04.000000', None, 5, 3, 'repository.read') 2024-11-21 09:13:48.769 DEBUG [sqlalchemy.engine.base.Engine] Row (15, 1, 3, 9, 2, 0, 0, 'rev:tip', None, 9, 'patches/ccpatches', 'repo_state_created', '', 'git', 0, 'ccpatches', '2024-11-21 09:13:48.258741', '2024-11-21 09:13:48.258749', None, 6, 3, 'repository.read') 2024-11-21 09:13:48.770 DEBUG [kallithea.lib.auth] Checking if user 'ewong' can 'read' repo 'patches/ccpatches' (None): True (has 'repository.admin') 2024-11-21 09:13:48.770 DEBUG [kallithea.lib.auth] Permission granted for <kallithea.controllers.summary.SummaryController object at 0xb11c48c8> <AuthUser 2: 'ewong'> 2024-11-21 09:13:48.770 INFO [kallithea.lib.webutils] Flash warning: There are no changesets yet 2024-11-21 09:13:48.773 INFO [sqlalchemy.engine.base.Engine] SELECT statistics.stat_id AS statistics_stat_id, statistics.repository_id AS statistics_repository_id, statistics.stat_on_revision AS statistics_stat_on_revision, statistics.commit_activity AS statistics_commit_activity, statistics.commit_activity_combined AS statistics_commit_activity_combined, statistics.languages AS statistics_languages FROM statistics WHERE ? = statistics.repository_id 2024-11-21 09:13:48.773 INFO [sqlalchemy.engine.base.Engine] (9,) 2024-11-21 09:13:48.773 DEBUG [sqlalchemy.engine.base.Engine] Col ('statistics_stat_id', 'statistics_repository_id', 'statistics_stat_on_revision', 'statistics_commit_activity', 'statistics_commit_activity_combined', 'statistics_languages') but it repeats without going anywhere. So I gave up and disabled celery. Now it's working. Has anyone here setup Celery + redis? If so, was I supposed to somehow create a DB? It doesn't mention anything creating a DB. using redis-cli, "INFO keyspace" shows that there is a db0. No clue if it defaults to readwrite; but from what I gather, default is read/write. Thanks and sorry for the noise. Edmund _______________________________________________ kallithea-general mailing list [email protected] https://lists.sfconservancy.org/mailman/listinfo/kallithea-general
