Tag: moodle – ServerOK

Moodle 3.2 site started showing error “Error reading from database”. I checked config.php, the database credentials are correct, i was able to login to Amazon AWS RDS PostgreSQL database with the credentaials and able to see the database tables with command \dt.

psql -h mydb.hwfckmarrpeo.ap-southeast-2.rds.amazonaws.com -p 5432 -U moodle_user -W

1	psql -h mydb.hwfckmarrpeo.ap-southeast-2.rds.amazonaws.com -p 5432 -U moodle_user -W

I enabled debug in DB with following SQL commands

select * from  mdl_config WHERE name = 'debug';
select * from  mdl_config WHERE name = 'debugdisplay';
UPDATE mdl_config SET VALUE = 2047 WHERE name = 'debug';
UPDATE mdl_config SET VALUE = 1 WHERE name = 'debugdisplay';

select * from mdl_config WHERE name = 'debug';

select * from mdl_config WHERE name = 'debugdisplay';

UPDATE mdl_config SET VALUE = 2047 WHERE name = 'debug';

UPDATE mdl_config SET VALUE = 1 WHERE name = 'debugdisplay';

But for […]