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

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

samudaya Nanayakkara -
回帖数：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

平均分： -
回复samudaya Nanayakkara

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

Tim Hunt -
Core developers的头像 Documentation writers的头像 Particularly helpful Moodlers的头像 Peer reviewers的头像 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.

平均分： -
回复Tim Hunt

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

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

平均分： -
回复samudaya Nanayakkara

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

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

平均分： -
回复samudaya Nanayakkara

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

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.

微笑

平均分： -