30 May 2019, 21:03

Running 18.04.4 and for some reason self registered accounts to institutions have stopped being added to the system once approved. The accounts vanish and can be requested again. It appears they never make it into the user database (PostgreSQL v9.5.17).

I have checked the logs for the database and server with no issues reported. 

20 November 2019, 8:54

Hi Patric,

I've tested on postgres v9.5.19 with a 18.04.4 site and am not able to replicate the problem.

Normally when a user self-registers to an institution that doesn't require approval and confirms via the email link their account is created in the 'No institution' institution.

And an administrator get an email about them and can add them to the correct institution.

So things to check:

1) Is the pending registration being saved correctly in the db 'usr_registration' table

2) Is the self-register user getting the confirm email

3) On confirm - is the admin getting the 'requested membership' email

4) Does the usr_registration table have the following structure:

   Column    |            Type             |                           Modifiers                           
-------------+-----------------------------+---------------------------------------------------------------
 id          | bigint                      | not null default nextval('usr_registration_id_seq'::regclass)
 institution | character varying(255)      | not null
 firstname   | text                        | not null
 lastname    | text                        | not null
 email       | text                        | not null
 lang        | text                        |
 key         | character varying(16)       | not null
 expiry      | timestamp without time zone | not null
 pending     | smallint                    | not null default 0
 reason      | text                        |
 extra       | text                        |
 authtype    | character varying(255)      | not null default 'internal'::character varying
Indexes:
    "usrregi_id_pk" PRIMARY KEY, btree (id)
    "usrregi_aut_ix" btree (authtype)
    "usrregi_ins_ix" btree (institution)
Foreign-key constraints:
    "usrregi_aut_fk" FOREIGN KEY (authtype) REFERENCES auth_installed(name)
    "usrregi_ins_fk" FOREIGN KEY (institution) REFERENCES institution(name)

Cheers

Robert