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.

笑顔

評点平均: -