User Account Pushed by Another Database (What are the tables?)

User Account Pushed by Another Database (What are the tables?)

by samudaya Nanayakkara -
Number of replies: 6

Dear Friends,

I have integrated Moodle with another database (MySQL) for authentication (auth=db). However I want to push the user profile from our Students Management System to Moodle. If Students Management System pushes the data, Which Tables it has to use? That mean what the Tables effected by Auto user account creation by external database based authentication?

 

Thanks and Best Regards

Samu

Average of ratings: -
In reply to samudaya Nanayakkara

Re: User Account Pushed by Another Database (What are the tables?)

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Most of the data is in the 'user' table. (That will normally have a prefix, and so be called mdl_user.)

Some other bits are stored as 'Custom user profile fields' which are in separate tables, but the name also begins user_ so it should be easy to work out what is going on.

In reply to Tim Hunt

Re: User Account Pushed by Another Database (What are the tables?)

by samudaya Nanayakkara -

Hi Tim,

Thanks for your quick reply. When I examine the database when user account is creating, it will affect to the the following tables too;

mdl_context
mdl_user_preferences
mdl_cache_flags

What are the purpose of these tables and Do I have to push information to those tables?

 

Thanks and Best Regards

Samu

In reply to samudaya Nanayakkara

Re: User Account Pushed by Another Database (What are the tables?)

by samudaya Nanayakkara -

Hi All, I am using Moodle Version is 2.5. I want to push user account from another system to my Moodle system. Is there any API for push? OR Is it enough to push the information on database level to only user (mdl_user) table?

 Thank you very much.

Samu

In reply to samudaya Nanayakkara

Re: User Account Pushed by Another Database (What are the tables?)

by Itamar Tzadok -

Check out docs on authentication methods and the Authentication forum.

P.S. This forum is not related to DB issues but to an activity module that happens to be called database. Depending on the issue, other forums may be more useful for such queries.

smile