Visvanath Ratnaweera

Hi Howard,

That is more an IRC! Thanks!!

No, I was just too exicted, and logged in to the wrong server!


In the real one, id=2 was indeed missing:

mysql> select * from mdl_config where name="siteadmins";

+----+------------+-------------+

| id | name       | value       |

+----+------------+-------------+

| 19 | siteadmins | 108,102,116 |

+----+------------+-------------+

Ran the update command and got:

| 19 | siteadmins | 2,108,102,116 |

But this admin is still "weak". Even a logout/login didn't help. I am still investigating.

Mary

That would have been too nice. This weak 'admin' can not kick open anything under mysite/admin/ !


Let me see whether Howard's interrogation would do. Still good to know that you are only minutes away.

I thought, that was it! But still missing:

mysql> select * from mdl_config where name="siteadmins";

+----+------------+-------+

| id | name       | value |

+----+------------+-------+

| 19 | siteadmins | 2     |

+----+------------+-------+

So my admin with id=2 is there?

Still something is wrong. I know that there is another systemwide admin. Will check.

The user 'admin' of a 2.7 site doesn't get the Site-administration menu. Trying https://example.com/admin/ throws "Sorry, but you do not currently have permissions to do that (Change site configuration)" pointing to https://docs.moodle.org/27/en/error/moodle/nopermissions.

I don't know the history of the site, but I have no reason to believe that the owners have tampered with roles and permissions.

I checked the table mdl_user and there is nothing unusual in the record with id=2:

| id | auth   | confirmed | policyagreed | deleted | suspended | mnethostid | username | password ...

|  2 | manual |         1 |            0 |       0 |         0 |          1 | admin    | [gibberish] ...

Am I missing something obvious?

Hallo Markus

Du schreibst:
> Das LDAP Enrollment kann man wohl nicht so ohne weiteres bei uns nutzen.

Wenn schon LDAP (AD), der saubere Weg ist genau das, wie hier https://docs.moodle.org/en/LDAP_enrolment beschrieben. Alles andere ist gebastel.