Where is trustedUsers

itachi_0x0 · January 7, 2024, 11:15am

i was trying to setup elastic search (finally I thought …yeah its a necessary thing) everything is running fine but how can i add my self in trusted users because according to documents i cannot find any array name trustedUser here

is there any different method to do that or am I missing something ?

mr_monkey · January 12, 2024, 5:17pm

For reference if anyone else has the same question, this was answered on IRC:

Hi! Those instructions are outdated, as we just recently stopped using the trusted users array thing in favor of a real admin system.
There is currently no super-duper easy way to set it up yet, but you can modify the database directly to give your user admin privileges.
Find your user id, and in the editor table set your privs as the number 31:

github.com

metabrainz/bookbrainz-site/blob/master/sql/schemas/bookbrainz.sql#L44


      
          	name VARCHAR(64) NOT NULL UNIQUE CHECK (name <> ''),
          	metabrainz_user_id INTEGER CHECK (metabrainz_user_id >= 0),
          	cached_metabrainz_name VARCHAR(64),
          	reputation INT NOT NULL DEFAULT 0,
          	bio TEXT NOT NULL DEFAULT '',
          	created_at TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT timezone('UTC'::TEXT, now()),
          	active_at TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT timezone('UTC'::TEXT, now()),
          	type_id INT NOT NULL,
          	gender_id INT,
          	area_id INT,
          	privs INT NOT NULL DEFAULT 1,
          	revisions_applied INT NOT NULL DEFAULT 0 CHECK (revisions_applied >= 0),
          	revisions_reverted INT NOT NULL DEFAULT 0 CHECK (revisions_reverted >= 0),
          	total_revisions INT NOT NULL DEFAULT 0 CHECK (total_revisions >= 0),
          	title_unlock_id INT
          );
          ALTER TABLE bookbrainz.editor ADD FOREIGN KEY (gender_id) REFERENCES musicbrainz.gender (id) DEFERRABLE;
          ALTER TABLE bookbrainz.editor ADD FOREIGN KEY (type_id) REFERENCES bookbrainz.editor_type (id);
          ALTER TABLE bookbrainz.editor ADD FOREIGN KEY (area_id) REFERENCES musicbrainz.area (id) DEFERRABLE;
          
          CREATE TABLE bookbrainz.editor__language (