dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Uhh, yeah, sorry about that Paulo.  We have had some issues with people
changing the password on the demo servers, so have put some measures in
place to prevent this.

If you want to be able to change the password, just execute these command
on the database.

DROP TRIGGER IF EXISTS prevent_changing_password ON users;
DROP FUNCTION IF EXISTS cant_touch_this();

Regards,
Jason



On Tue, Jun 21, 2016, 21:00 Paulo Grácio <paulogracio@xxxxxxxxx> wrote:

> Is this familiar to anyone? Getting this error using latest trunk and 2.23
>
> dhis2-database | ERROR:  Hammertime!
> dhis2-database | STATEMENT:  update users set uid=$1, code=$2, created=$3,
> lastUpdated=$4, creatoruserid=$5, username=$6, password=$7,
> externalauth=$8, openid=$9, ldapid=$10, passwordLastUpdated=$11,
> lastLogin=$12, restoreToken=$13, restoreCode=$14, restoreExpiry=$15,
> selfRegistered=$16, invitation=$17, disabled=$18 where userid=$19
> dhis2-database | ERROR:  current transaction is aborted, commands ignored
> until end of transaction block
> dhis2-database | STATEMENT:  SELECT NULL AS TABLE_CAT, n.nspname AS
> TABLE_SCHEM, c.relname AS TABLE_NAME,  CASE n.nspname ~ '^pg_' OR n.nspname
> = 'information_schema'  WHEN true THEN CASE  WHEN n.nspname = 'pg_catalog'
> OR n.nspname = 'information_schema' THEN CASE c.relkind   WHEN 'r' THEN
> 'SYSTEM TABLE'   WHEN 'v' THEN 'SYSTEM VIEW'   WHEN 'i' THEN 'SYSTEM INDEX'
>   ELSE NULL   END  WHEN n.nspname = 'pg_toast' THEN CASE c.relkind   WHEN
> 'r' THEN 'SYSTEM TOAST TABLE'   WHEN 'i' THEN 'SYSTEM TOAST INDEX'   ELSE
> NULL   END  ELSE CASE c.relkind   WHEN 'r' THEN 'TEMPORARY TABLE'   WHEN
> 'i' THEN 'TEMPORARY INDEX'   WHEN 'S' THEN 'TEMPORARY SEQUENCE'   WHEN 'v'
> THEN 'TEMPORARY VIEW'   ELSE NULL   END  END  WHEN false THEN CASE
> c.relkind  WHEN 'r' THEN 'TABLE'  WHEN 'i' THEN 'INDEX'  WHEN 'S' THEN
> 'SEQUENCE'  WHEN 'v' THEN 'VIEW'  WHEN 'c' THEN 'TYPE'  WHEN 'f' THEN
> 'FOREIGN TABLE'  WHEN 'm' THEN 'MATERIALIZED VIEW'  ELSE NULL  END  ELSE
> NULL  END  AS TABLE_TYPE, d.description AS REMARKS  FROM
> pg_catalog.pg_namespace n, pg_catalog.pg_class c  LEFT JOIN
> pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0)  LEFT
> JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND
> dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON
> (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog')  WHERE c.relnamespace
> = n.oid  AND c.relname LIKE 'PROBABLYNOT' AND (false  OR ( c.relkind = 'r'
> AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) )  ORDER BY
> TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
> dhis2-web   | * WARN  2016-06-21 18:58:22,978 SQL Error: 0, SQLState:
> P0001 (SqlExceptionHelper.java [http-apr-8080-exec-10])
> dhis2-web   | * ERROR 2016-06-21 18:58:22,979 ERROR: Hammertime!
> (SqlExceptionHelper.java [http-apr-8080-exec-10])
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>