Drupal 7 + Moodle 2.x

Dear Darshan,

thanks for the workaround for drupal & moodle integration.

I followed all the steps you described but when trying to sync users between drupal and moodle I get
ERROR: Login error!
I have sudo access and the only thing that didn't go 100% as you described in your guide is when creating the drupal user view. When I added Postal address in the view's fields list, it appears as a single field and not as 4 (first name, last name, city, country).

It would be great if you could guide me how to solve this.

Thanx,
lil_gusta

Nevermind, I sort it out. I was entering the server's static IP address in moodle drupalservices->Drupal hostname. It all worked when I changed the IP to localhost.

Hello,

Thanks for very useful module for us .

I have two links

localhost/moodle/ for Moodle
http://localhost/moodle/lms for Drupal

Issue on logout .. it is not Logout from Drupal automatically .

Sign up on moodle is not working .

Waiting for reply. Please help us

I have integrated them together. All works correctly. There is a small issue:
After I login Drupal, I have to click the link of moodle's login manually, then I could login in to Moodle.

My moodle version is 2.4, Drupal version is 7.17.

I do not know how to auto login to Moodle after I login to Drupal?

Hello Darshan,

Thanks for Sharing this, I am trying to follow the steps on the Drupal side installation. The step which I am not able to follow is
Click on Edit resources for the newly created service - moodle.

Enable index for View: Moodle users (muser).

I dont have this option available and as a result If I try the link "http://localhost:8888/drupal7/drupalservice/muser" its coming as a blank.

Please suggest where I am going wrong.

Thanks a lot for your time and help...

Hello Darshan

I am trying to integrate drupal 7 with Moodle 2.4 , I was glad to find your instruction and I followed it exactly moodle-drupalservices , I get drupal service to work

at localhost/school/drupalservice/muser I get json

[{"name":"rrr","uid":"1","firstname":"Rania","lastname":"hhh","country":"USA","email":"rrr@gmail.com","status":"1","City":"View"}]

but once I run this command : sudo php /Applications/mampstack-5.3.28-0/apache2/htdocs/moodle/auth/drupalservices/auth_drupalservices_sync_users.php

I got this error

RemoteAPI Object
(
[gateway] => http://localhost:8080/school
[endpoint] => /drupalservice
[status] => 1
[session] => SESS451390669235bb773ed6f1e3fb2dd775
[sessid] => KqpuX6jcrcX9xfCUsBdcrK48rT7fBq4wlC6K1TtsyGo
[CSRFToken] => uYzhsuxiDT88dRdye3JMf2SKOi_Qp3cjwjRwWwazNIY
)
User entries to update: 1
Updated user rania(1)
PHP Notice: Undefined property: stdClass::$city in /Applications/mampstack-5.3.28-0/apache2/htdocs/moodle/auth/drupalservices/auth.php on line 163

Notice: Undefined property: stdClass::$city in /Applications/mampstack-5.3.28-0/apache2/htdocs/moodle/auth/drupalservices/auth.php on line 163
!!! Error writing to database !!!

and no entry in the moodle database for drupal user , the drupal user I have it admin and remote-service privilege

SInce user registeration in drupal doesn't have lastname, firstname , city , country filed I used configuration/accountsetting/manag fields and I added
those filed , create the view and service .it is obvious in my drupalservice result ,

I noticed that those city and country field once I added them to the registeration fields , they are not added to drupal user table , they are added in new tables field_city , field_country , I wonder is that the reason , moodle when trying to get the user city it query only user database and not finding them and not query the other field database

I also tried to use the address field module as your instructions , but all fields failed including last name , first name , city , country

I would appreciate your solution , I would be so happy to see it working .

Thank you so much

Hi Darshan,

I am also getting the same error as adamtong

Please suggest a solution for this.

Thanks in advance.

You have need to set this file auth_drupalservices_sync_users.php in cron, you don't have need to run manually.

In your Drupal user list some user have no firstname , last name ,city and country so go on drupal user list and or block the user or give the these requirement then go Syn and run the cmd for syn user its working!

Just in case anyone else was wanting to do what I mentioned above and have new accounts be instantly added to Moodle rather than waiting for the next cron run, here is the method I used. It is awful in terms of performance and it would definitely be better if there was a method available to sync individual accounts rather than only having a single command available to sync the entire user database. I simply added the following to a custom Drupal module:

function hook_user_update(){
    $response = shell_exec("/path/to/php /path/to/moodle/auth/drupalservices/auth_drupalservices_sync_users.php");
    if(is_null($response)) $response = "An error occurred executing the update shell command.";
    watchdog("Module Name", $response, NULL, WATCHDOG_DEBUG);
}
function hook_user_insert(){
    $response = shell_exec("/path/to/php /path/to/moodle/auth/drupalservices/auth_drupalservices_sync_users.php");
    if(is_null($response)) $response = "An error occurred executing the update shell command.";
    watchdog("Module name", $response, NULL, WATCHDOG_DEBUG);
}

Of course, replace "hook" with your module name and the paths to PHP and to the auth_drupalservices_sync_users.php file with your own paths. The calls to watchdog can be taken out once it is working, but they definitely help with debugging your paths.

I still hope that a different method will be added to make this more acceptable performance-wise, but if you have a site with a relatively-small number of users and enough available server power, this works.

you will need to elaborate for anyone to help you. Else write your own integration module for Moodle.