LTI and Moodle

LTI database tables

 
Picture of Andrew Shipley
LTI database tables
 

Tried and tried to find a table containing the LTI Name, Cartridge URL and Shared Secret and failed! Can anyone help please

 
Average of ratings: -
Picture of John Okely
Re: LTI database tables
Core developersParticularly helpful MoodlersPlugin developersTesters

Are you looking for the tables for the consumer (the "External tool" module) or the provider ("Shared as LTI tool" enrolment plugin)?

For the consumer it will be the _lti table. But you may have to check _lti_types mdl_lti_tool_proxies if you used the proxy / auto configure to create it.

_enrol_lti_lti2_consumer is the table for the enrol provider.

I'm interested to know why you need access to the tables. Generally everything you need to do should be doable from the interface.

 
Average of ratings: -
Picture of Andrew Shipley
Re: LTI database tables
 

I'm looking to build a report showing

custom instance name - cartridge url - secret

but can only find the secret within the LTI tables for me to build the SQL statement required

 
Average of ratings: -