General help

Moodle and Google Apps for education

 
Picture of Paul Langdon
Moodle and Google Apps for education
 

Hi Moodlers

we are currently considering a migration to Google apps foe Education. So a few questions if you could help please.

 

Has anybody done this?

  1. What issues did you come across?
  2. Was it a wise move?
  3. How did it impact upon your Moodle use?

 

Many thanks in advance guys

 

Paul

 

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers
Hi

I believe you mean these: http://www.google.ch/intx/en/enterprise/apps/education/products.html.

But I don't see how they educate. Or to put it another way: Instead of what?

What is the connection of those things to Moodle use?
 
Average of ratings:Useful (2)
Picture of Paul Langdon
Re: Moodle and Google Apps for education
 

You sound as though this is new to you? Where have you been ?  surprise

This gives you an idea of the scale of change that is going on...

http://www.edudemic.com/report-vast-majority-of-top-u-s-schools-use-google-apps/

In a nutshell - 

Switching to it as opposed to school servers - so going 100% cloud. No more computer suites.

They don't 'teach' - G Apps is a tool like Office or other software that teachers use.

 

Further to my original post then:

 

Anybody in here migrated recently and how did it impact (if at all) upon your Moodle use? I hear you can use a single log in on Moodle to access it - anybody set this up yet?

 

Thanks

 

Paul

 

 
Average of ratings: -
Picture of Marcus Green
Re: Moodle and Google Apps for education
Group Particularly helpful MoodlersGroup Plugin developers

It seems to me that Google Apps for Education is Google Apps with the word Education put on the end. Something of interest to anyone who needs office functionality but with little overlap/connection with education specific software (such as Moodle). The good news is that they offer security and privacy at Google Apps.

 

 
Average of ratings:Useful (2)
Picture of Ken Task
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers

Actually, Moodle tools in and of themselves don't 'teach' either.  How an instructor/teacher uses them, however, is the key.   That also applies to Google.

There is a list for Google Apps Admins.   Sorry don't have a URL right now, but one should be able to Google for it.  Example of how not to use Google: discussion on using Google sheets for test.   To me, that's a primary  example of taking a rather large step *backwards* ... just for the sake of using Google's easy to use forms.

Think you might have to wrap mind around authentications and look at your entire systems ... got MS AD and LDAP?   Use that right now with Moodle?  Accurate syncing appears to be an issue from time to time - impression from list discussion.

Hidden cost ...  upstream data pipe.   The more an entity relies upon the 'cloud' the more bandwidth is needed.  Bandwidth is usually one of the highest budget items.

'spirit of sharing', Ken

 
Average of ratings:Useful (2)
Picture of AL Rachels
Re: Moodle and Google Apps for education
Group Core developersGroup Particularly helpful MoodlersGroup Plugin developersGroup Testers

Not only "The more an entity relies upon the 'cloud' the more bandwidth is needed," but the more that link is needed too. On one occasion, a construction worker dug out about thirty feet of fiber optic cable with a backhoe, that isolated our school for about six weeks, before it could be replaced. (nationwide shortage of fiber optic cable) On another occasion a farmer chopped through a fiber optic cable that isolated our whole town for a couple of days.

Using "normal" software, my students and I kept right on working both times.

AL

 
Average of ratings:Useful (1)
Picture of Visvanath Ratnaweera
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers
Hi Paul

> You sound as though this is new to you? Where have you been ? [surprise]

I just looked away. Luckily others were watching!
smile

> This gives you an idea of the scale of change that is going on...
> http://www.edudemic.com/report-vast-majority-of-top-u-s-schools-use-google-apps/

That is interesting. "New Google Schools"? I see a list of elite US universities!

> In a nutshell -
> Switching to it as opposed to school servers - so going 100% cloud. No more computer suites.
> They don't 'teach' - G Apps is a tool like Office or other software that teachers use.

I'm confused again:
- "opposed to school servers"
You mean file storage for the users?

- "Computer suites"
Never heard of such thing, unless you have a dress codex for the computer lab!

- "Office or other software that teachers use"
Now I see, you are talking about https://en.wikipedia.org/wiki/Office_suites. But such software is known even in the secondary schools these days. I expect the "schools" in that blog-post to be more advanced.

Well, this I understood: "So what does ‘going Google’ actually mean? Typically, it means schools and districts will start using Gmail, Google Drive, Google Calendar, and Google Sites. Each classroom will typically set up a Google Site for collaboration purposes, an account can help turn in homework via Google Drive, and of course Gmail goes without saying. While it’s not cheap, the ability to migrate all of this kind of work to Google’s cloud services could mean a lot less stress over your IT infrastructure (both financial and otherwise)."

Unfortunately the "Learn more" link takes me to Apple iTunes. No idea why.
 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

"> This gives you an idea of the scale of change that is going on...
http://www.edudemic.com/report-vast-majority-of-top-u-s-schools-use-google-apps/

That is interesting. "New Google Schools"? I see a list of elite US universities!"

You see a list of elite US universities because that's what's being report on. Could be I'm having a bad day by I don't think I've read a more fragmented message for a while. I can't tell what side you're on or what you're stating most of the time.

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers
'One side of what? The other side of what?' thought Alice to herself.

'Of the mushroom,' said the Caterpillar, just as if she had asked it aloud; and in another moment it was out of sight.

Alice remained looking thoughtfully at the mushroom for a minute, trying to make out which were the two sides of it; and as it was perfectly round, she found this a very difficult question.

(Alice: Advice from a Caterpillar)
 
Average of ratings: -
Matt Bury
Re: Moodle and Google Apps for education
Group Particularly helpful MoodlersGroup Plugin developers

Hi Paul,

This is a bit late but still relevant to everyone using drop-boxes, drives, file repositories, or whatever you want to call them in place of an LMS or integrated with an LMS. The paper takes its position from a pedagogical and social learning perspective: http://patricklowenthal.com/death-to-the-digital-dropbox-rethinking-student-privacy-and-public-performance/

Some of the principles described here would also apply to using the Workshop module for peer review assignments. I've found using forums where you'd normally use assignments or workshops to be more collaborative, more supportive, have a faster feedback process and turnaround, and it tends to result in stronger "social presence." Social presence strongly correlates with higher learning outcomes, deeper learning, and lower drop out rates.

For supporting evidence and more specific details see: https://coi.athabascau.ca/publications/social-presence/

I hope this helps! smile

 
Average of ratings:Useful (1)
Picture of Visvanath Ratnaweera
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers
This is not April 1, still I wonder whether BBC means those Google Schools: "Google halts student Gmail advertisement scans" http://www.bbc.com/news/technology-27223079 ?
 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

Google allows Google Apps for Education users to turn off advertisements for all users.  If they have been scanning accounts in my school district, it has been for nothing,  We have had adverts disabled since 2009.

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

There's a good deal of well-intentioned misinformation in this thread. We've been on Google Apps for Education for about six years and have largely migrated faculty and students away from MS Office suite, due to cost and mostly due to security. There's no better way to collaborate than through Google Drive. In point of fact, at least for us and all the North American schools of which I'm aware, internet bandwidth is wayyy down the list of costs for IT. Infrastructure, build and maintain is way up on the list and this is summarily reduced going to Google Apps. I'm not yet with those who say you don't need an LMS if you have Google Apps, I don't think all the pieces are there nor the glue to bind them but they've grown tremendously over the time we've had Google Apps. We did a very tight integration between Moodle and Google Apps because we weren't satisfied by the Google Apps repo that comes with Moodle. Our integration Assigns a Google account to each course with G-Drive and calendar associated. All events for the course go into the course's google calendar.  Read-only and student-writeable folders are automatically created from which an instructor can share their documents. Permissions are automatically updated according to role in course. Has been working well for 2-1/2 years.

 
Average of ratings:Useful (3)
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

We SSO from Moodle to Google Apps.  Like Bob, we are on year six of the integration.  Both the Moodle side and Google side compliment each other nicely.  Google Apps does not have the management features at this time to stand on its own for large scale use.

Bob, have you released the code of your custom integration to the community?  I would love to get access to it.

 
Average of ratings:Useful (1)
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

I'd prepare it and put it on Github but not without partner institutions. Not wanting to maintain it myself alone for other schools.

 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

Does that mean it will remain secret?

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

No... I'd very much like to release it -- just waiting for some folks to offer to assist in maintenance if it turns out they like it.

 
Average of ratings: -
Picture of Ken Task
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers

Am confused ... how can one decide to offer to assist in maintenance IF they've not seen it? smile

'spirit of sharing', Ken

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

"...just waiting for some folks to offer to assist in maintenance if it turns out they like it."

I'll put it out there if somebody says, "Yes they'd consider sharing the maintenance burden if they found they liked it.

 
Average of ratings: -
Picture of Ken Task
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers

Am not a programmer, so if that what 'sharing the maintenance burden' means, then I wouldn't be much help.  If a demo system on another network would help, think I might be able to provide that - and maintain that system (or I'd least be willing to try).   Might be able to enlist the aide of TCEA - they are an official Google Apps Training organization.

'spirit of sharing', Ken

 

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

I'm glad to post the modules but unless some programmers come forth to assist I'm not going to support them in the wild. Will take a little time to package them properly on my github.

 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

Short of posting your code, please tell us the features.  Right now I know it creates an account for each course.  What else does it do?  I am wondering if it is a compliment to, or a replacement of the SSO integration from New Zealand schools.

 
Average of ratings: -
Picture of Ken Task
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers

+1 to that.  I'd really be happy just to get authentications working for the schools domain.  The small schools am working with don't need much more than that (even though they could use more advanced features).

'spirit of sharing', Ken

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

"We did a very tight integration between Moodle and Google Apps because we weren't satisfied by the Google Apps repo that comes with Moodle. Our integration Assigns a Google account to each course with G-Drive and calendar associated. All events for the course go into the course's google calendar.  Read-only and student-writeable folders are automatically created from which an instructor can share their documents. Permissions are automatically updated according to role in course. Has been working well for 2-1/2 years."

This does nothing with authentication so it would likely be a compliment to NZ.

 
Average of ratings: -
Picture of Mark Glynn
Re: Moodle and Google Apps for education
 

All,

 

This link provides access to a Google doc that outlines a level of integration that we are hoping to develop within our university

https://docs.google.com/document/d/1fa_IXZyCmswEQfnOjx2WlLyGRGA4DLcidmTEoQmBGVs/edit?usp=sharing

This is at the very early stages but if successful we would aim to release it to the community. Before developing it I would appreciate your input to determine if we have missed out on any functionality that you would recommend or if it contains fundamental flaws. Obviously if you have tried to instigate something like this before I would really appreciate your insight

 

Thanks for your help in advance

 

Kind regards

 

Mark

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

"This link provides access to a Google doc that outlines a level of integration that we are hoping to develop within our university"

I can tell you right now you'll run aground of Google's unreliability of updating group-assigned doc permissions. If members are added to the group after docs are shared they will very likely not be able to see the docs shared with the group. I'd urge you to test it out for yourself before committing too much to your plan. We've implemented a tight integration between Moodle and Google and continue to encounter this issue, so we don't rely on group permissions. You're welcome to our code though it comes with no warranty, has been in production for 2-1/2 years.

 
Average of ratings: -
Picture of Bud Hunt
Re: Moodle and Google Apps for education
 
We'd be interested in this code, also.
 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

I have a video conference with some large schools in California this coming week to talk about this project. If one or more sign on to assist in maintenance/ enhancement/ support I'll release the code into the wild. Otherwise I only have time to support it for my own school which has required almost no time over the past year (that's about what I have, 'no time').

 
Average of ratings: -
Picture of Ken Task
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers

Have any data to share as well?  Just out of curiosity, how much of a pipe do you have upstream?  Granted there is E-Rate in NA.  If one could not get E-Rate on circuits, what would be the cost?

And +1 for Rob's request!!! ;)

Know of two small schools districts in South Texas that have begun the journey and have Moodle.  In these small districts, IT is a one person shop ... they do it all and could use some help.   That's why am asking.

'spirit of sharing', Ken

 
Average of ratings:Useful (1)
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

We currently have 250 mb fiber to the outside.  This is the most we could get under E-Rate.   Much of our use takes place off campus, however.  Our Moodle traffic peaks between 8 and 10 p.m. local time.  My district is in suburban Los Angeles, and our students have almost universal access to the Internet from home.

Our student surveys show an increase in GApps use by students over the past few years.  In 2010, 35% of students used Google Docs over MS Office.  In June 2013, that number was 78%.  Students like that it saves for them and docs are available worldwide.  From an admin point of view, the support (phone and email) provided by Google is a weight taken off of our understaffed IT department.  Getting teachers to let go of MS Office has been the biggest challenge.

In response to your other reply, I am currently using the integration from New Zealand schools.  We began with the original package for Moodle 1.9 developed by MoodleRooms.  The later integrations have been buggy in some areas.  New Users do not sync properly without hacking some code, and logging out of Moodle does not log the user out of Google without hacking code.

 
Average of ratings: -
Picture of Ken Task
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers

Thanks, Rob.   One school of which I spoke has 25mb pipe but it's a small school (300?) and the IT person has had to use a bandwidth shaper from time to time.   One thing for sure ... if the pipe is there, they'll use it! ;)

Thanks for the info on GApps usage also.

Now a question about the NZ schools package ... did you download, extract, then move into your 2 the pieces needed (like auth plugin)?   Or is it more involved than that ... you mentioned hacking code.

Thanks, in advance ... 'spirit of sharing', Ken

 
Average of ratings: -
Picture of Ken Task
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers

For Rob also ...

New Zealand put together a moodle package that did some things for their schools - Google being one.

Am wondering why the heck NA (USA) schools couldn't do the same?

'spirit of sharing', Ken

 
Average of ratings: -
Picture of Hansruedi (Lori) Lorenz
Re: Moodle and Google Apps for education
 

Great to see some Googling Moodlers.

For a long time I try to write a workbook template in Google Drive. The idea is that the template cannot be altered, however students should be able to add to it, entre photographs and so on and share it. I tried the form app, but this is not sufficient . Any other idea? 

 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

For templates, I advise that teachers set the document visibility to "Anyone with the link can view."  They don't make it a template in Google Apps itself.  The link is then posted to the teachers's Moodle course page.  Students open it, and use "Make a copy" in hte GApps file menu.  They then can alter the document without changing the original.

If you want all students to be able to edit the same document, post the link to your course as "Anyone with the link can edit."  If you are using Google Apps for Education, there is a setting that forces them to be logged in to their accounts withing your institution.  This way they show up in the doc's revision history.

 
Average of ratings:Useful (1)
Picture of Hansruedi (Lori) Lorenz
Re: Moodle and Google Apps for education
 

Now this is clever   big grin.

Thank you so much Rob

 
Average of ratings: -
Picture of Ken Task
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers

Decided not to wait ... have just installed (for small ISD) addons for accessing Google ISD Domain.

Discovered this link could be added to the drop down menu of the templates while fooling around with it:

[GoogleDomain] Google Drive|https://drive.google.com/a/[googledomain[/#all" target="_new

Replace the [] items to suit.

Displays all the users Google Drive.

While it would be nice to have SSO, calendaring, etc.. am finding it might not be necessary to attempt to 'control' Google from Moodle.  Probably best not to try!

Did find the Moodle docs a little out-dated as Google has changed their interface ... but one can find the tools (eventually).

'spriit of sharing', Ken

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

"am finding it might not be necessary to attempt to 'control' Google from Moodle.  Probably best not to try!"

Guess I'd strongly disagree... that's precisely why Google has APIs. We're a 2600 fte college in NA and control ALL of our classroom scheduling using Google calendar and Google's APIs

 
Average of ratings: -
Picture of Ken Task
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers

Well, comparing your situation and the situation of a one person IT shop in a small rural school district who isn't a programmer ... yes, of course, you'd say that!  Let's remember that not all of us are true 'programmers'.   Yeah, Google has API's - documentation is for programmers - not mere mortals.  More power to ya, Bob! ;)

'spirit of sharing', Ken

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

The video conference did not produce results so I'm making the code available with no warranty or support. Will take me about a week to package up to my git repo.

 
Average of ratings: -
Picture of William Beazley
Re: Moodle and Google Apps for education
Group Particularly helpful Moodlers

Note: TXGOO is SOLD OUT:

https://sites.google.com/a/huntsville-isd.org/gootx/

Amy Mayer gave a great presentation on Google Docs at TCEA 2014.  She had a bunch of people in the audience on a meetup as a live demo.  Very convincing.

 
Average of ratings: -
Picture of Kimber Warden
Re: Moodle and Google Apps for education
 

Thanks, Bob! Looking forward to seeing it! Is it close to ready?


Kimber

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

Got stalled but its on my calendar for this week.

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

This is now on my github:

Also, I have a some documents, though mostly front-end in a publicly shared Google folder:


 
Average of ratings:Useful (1)
Picture of Kevin Bruton
Re: Moodle and Google Apps for education
Group Core developers

I'm looking for a way to integrate Google Apps for Education and Moodle. We are already using both and finding a way to synchronize users, and calendars would be very useful. 

Looks like there was a plugin, but according to the documentation, for some reason, it is not applicable to Moodle versions later than 2.4 (http://docs.moodle.org/27/en/Google_Apps_Integration). We have already upgraded to 2.7 and downgrading just isn't an option.

Integrating the repository for Google Drive has been very useful, and I'm confident I can get the calendars synchronized (I hope), but I'm unsure about synchronizing users (to avoid having to create accounts twice everytime). 

Does anyone know if the info in Moodle Docs on Google Apps Intregation is unapplicable because it just doesn't work anymore or is there only parts that have changed?

Maybe I'm missing something but I couldn't find anything on Google Apps Integration in Bob's Git and only a graphic on Google API in the Google Drive link.

 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

There are 2.5 and 2.6 integrations available at http://www.moodleinschools.org.nz/download.  I bet they will at a 2.7 version before too long.

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

Not interest in trying the code listed below? Sounds like it does just what you're looking for.

 
Average of ratings: -
Picture of Kevin Bruton
Re: Moodle and Google Apps for education
Group Core developers

I've been trying out the http://www.moodleinschools.org.nz version of Moodle with the Google Integration plugins already incorporated. However, I'm unable to get the integration working. I find the installation and configuration instructions very scarce and noone has posted anything in their tech forum for over a year.

The documentation for the plugins seem to refer to the Moodle plugins already published in moodle.org that have eliminated entries for all Moodle versions after 2.4.

Bob, Rob or anyone... If you're willing to publish code and instructions sufficient for me to get  Google Integration working with 2.7, I'm willing to help with testing and maintenance or whatever to help others get it going as well.

I've found the Google Drive Repostitory plugin really easy to get working. I think we need something like that to be able to integrate Google accounts right from the login page of Moodle, not just when you want to upload something. Help!

 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

The instructions for earlier versions should apply to 2.7.  For the record, I have not used the integration beyond 2.6.

  • Have you generated certificates and uploaded to Google and pasted the text into the gsaml auth page?
  • Have you turned on SSO in the GApps control panel
  • Are you seeing errors?
Below are the set up instructions from the gsaml settings page on my 2.4 production site.  I have been testing 2.6 on my dev box, and it is working fine.

  1. Set the Domain Name to your google service domain name then click Save Changes

  2. In a new window open Google Apps Control Panel page as admin (Link to Google Settings)

  3. Click the Advanced tools tab.

  4. Click the Set up single sign-on (SSO) link next to Authentication.

  5. First check the Enable Single Sign-on box.

  6. Now insert this url into the Sign-in page URL text field.
    http://yourdomian/login/index.php

  7. Insert this url into the Sign-out page URL text field.
    http://yourdomian/login/logout.php

  8. Insert this url into the Change password URL text field.
    http://yourdomian/login/change_password.php

  9. Generate and upload a Verification certificate to Google (X.509 certificate containing the public key)

  10. Upload the privatekey and certificate to Moodle as well and then click Save Changes

 
Average of ratings:Useful (1)
Picture of Kevin Bruton
Re: Moodle and Google Apps for education
Group Core developers

Thanks very much for your reply, Rob.

I've done a new install and followed all the steps, including putting the certificates in the right place etc., etc. 

After I do all of this, and I logout, then I am unable to login again. When I try to do so it says "Error reading from database", following the link on more information, it tells me it is an "error/moodle/dmlreadexception". 

The only way I can login again is setting $CFG->auth = ''; in config.php.

If I go to the Google SAML diagnostics page is shows me the private key, the domainname I've set, the certificate, and then:


Any ideas?

 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

Hi Kevin,

Please turn on debugging and post the stack trace for the error message you see.  That may give us better information.

Is your account authenticated using "Manual accounts?"   I am not sure why setting the Gauth would break log ins.

 
Average of ratings: -
Picture of Kevin Bruton
Re: Moodle and Google Apps for education
Group Core developers

Hi Rob,

I've turned debugging on and now I receive a different error message:


Table "block_gdata_gapps" does not exist

More information about this error

Debug info: 
Error code: ddltablenotexist

Stack trace:
  • line 585 of /lib/dml/moodle_database.php: dml_exception thrown
  • line 1426 of /lib/dml/moodle_database.php: call to moodle_database->where_clause()
  • line 59 of /auth/gsaml/auth.php: call to moodle_database->get_record()
  • line 4487 of /lib/moodlelib.php: call to auth_plugin_gsaml->user_authenticated_hook()
  • line 140 of /login/index.php: call to authenticate_user_login()

It doesn't let me change the login authentication to anything else but "Manual" for the admin account. I've been able to change it to Google SAML for another user, but when I try to login with that user, I still get the same error.

I've examined the database and it's true that the said table doesn't exist, nor with nor without the prefix. Does that mean I'm missing some plugin? or a part of one?

 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

In the original integration for 1.9, there was a Google Sync block.  That is the missing table in the stack trace.  It looks like Moodle in NZ schools removed it from their 2.6 and 2.7 forks.  The 2.6.2 site I am testing has the table because I upgraded from 2.4.  Even though the table exists on my site, I don't use the block anymore.  I have the 2.4 version in my blocks folder, but it is hidden on my test site.  It has been buggy in the 2.x versions.  I had to hack it to sync newly created users.

Since you are working with a fresh installation, try the attached file.  It contains the block from the Moodle in NZ 2.5 version.  I don't think it changed much since the 2.x rewrite.  The gdata folder gets unzipped into the blocks folder.  There will be settings to complete.  After the installation, you can hide the block if you don't use it.  Post back the results.


 
Average of ratings:Useful (2)
Picture of Kevin Bruton
Re: Moodle and Google Apps for education
Group Core developers

Wow! After installing the Google Sync block it actually seems to work!

Thanks so much for your help Rob!

As you've noted, the block is quite buggy. The only thing that works on it is "Settings" and "Status". Trying to click on "Users being synced" or "Add users to sync" causes havoc (= a page of coding errors), but at least SSO is working. I'll keep testing Google-Moodle integration before introducing it into my production site, but at least it's on the way.

 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

That is good news.  Have you tried the Gmail block?  Over the past weekend, Google seems to have changed something that broke the blocks ability to pull a users Atom feed from Gmail.  I posted about it here.

 
Average of ratings: -
Picture of Kevin Bruton
Re: Moodle and Google Apps for education
Group Core developers

I haven't had any luck with the Gmail block either. I set it up with the OAuth Consumer secret etc., and the block just displays "sorry couldn't obtain mail".
The stack trace reports the following:

Deprecated: Function split() is deprecated in /var/www/moodle/blocks/gmail/block_gmail.php on line 243

Gmail feed (for admin@... ) failed with:
Unauthorized
Error 401

  • line 267 of /blocks/gmail/block_gmail.php: call to debugging()
  • line 138 of /blocks/gmail/block_gmail.php: call to block_gmail->obtain_gmail_feed()
  • line 773 of /blocks/moodleblock.class.php: call to block_gmail->get_content()
  • line 236 of /blocks/moodleblock.class.php: call to block_list->formatted_contents()
  • line 993 of /lib/blocklib.php: call to block_base->get_content_for_output()
  • line 1045 of /lib/blocklib.php: call to block_manager->create_block_contents()
  • line 353 of /lib/blocklib.php: call to block_manager->ensure_content_created()
  • line 5 of /theme/nz_schools/layout/frontpage.php: call to block_manager->region_has_content()
  • line 877 of /lib/outputrenderers.php: call to include()
  • line 807 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
  • line 101 of /index.php: call to core_renderer->header()
 
Average of ratings: -
Picture of Francesc Delis
Re: Moodle and Google Apps for education
 

Hi!

I have a problem trying to use the google sync bloc

Authentication with Google Apps was successful

But when I want to add users to syncronize the message shown is not so successful

Coding error detected, it must be fixed by a programmer: PHP catchable fatal error

More information about this error

Debug info: Argument 2 passed to html_writer::start_tag() must be of the type array, boolean given, called in [dirroot]/lib/outputrenderers.php on line 2753 and defined
Error code: codingerror
Stack trace:
line 393 of /lib/setuplib.php: coding_exception thrown
line 1027 of /lib/outputcomponents.php: call to default_error_handler()
line 2753 of /lib/outputrenderers.php: call to html_writer::start_tag()
line 544 of /blocks/gdata/block_gdata.php: call to core_renderer->box_start()
line 471 of /blocks/gdata/block_gdata.php: call to block_gdata->display_user_table()
line 276 of /blocks/gdata/block_gdata.php: call to block_gdata->addusers_display()
line ? of unknownfile: call to block_gdata::view()
line 1671 of /lib/blocklib.php: call to call_user_func()
line 35 of /blocks/gdata/index.php: call to block_method_result()
Output buffer: <form class="userform" id="userformid" action="http://xxx.yyy/blocks/gdata/index.php" method="post"><div class="paging">Page:  1  <a href="http://xxx.yyy/blocks/gdata/index.php?hook=addusers&amp;pagesize=50&amp;page=1">2</a> ...

Even more, I can see the inbox's message in the gmail block but when I try to acces another annoying message is shown

SAML Auth Code Failed turn debugging on for more information

The same message is also shown if I try to acces with the google apps block.

To achieve the google-moodle integration I have installed in my previous moodle 2.7 installation the part of the code from http://www.moodleinschools.org.nz/download regarding this feature, I mean, auth->gauth, gsaml, blocks->gaccess, gdata, gmail. Did I need anything else?

Please, any ideas about how I can solve it?

Thank you very much!

 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

I notice in the stack trace there is a reference to calling output renderer.  This is just a guess, but does the error clear if you switch to another theme?

 
Average of ratings: -
Picture of Francesc Delis
Re: Moodle and Google Apps for education
 

Hi Rob!

I only have the clean theme installed. I can install another one and try with it.

Any other ideas?

Thank you!

 
Average of ratings: -
Picture of Roger Pàmies
Re: Moodle and Google Apps for education
 

Hello Francesc,

I has the same error, I found the line conflict in blocks/gdata/block_gdata.php line 544

print $OUTPUT->box_start('boxaligncenter boxwidthwide', '', true); //fail

print $OUTPUT->box_start();

I replaced these lines with:

print $OUTPUT->box(''); //change start_box call - new
print $OUTPUT->box_start();
print '<div class="boxaligncenter boxwidthwide">'; //insert div form container align - new

finally, I add "print '</div>';" before the line "print $OUTPUT->box_end(true);" 

Refresh and the form show ok.

roger.

 
Average of ratings:Useful (2)
Detlef Anschlag
Re: Moodle and Google Apps for education
 

Hello Roger,

your Bugfix works for me too. I'am actually using moodle 2.6.1.

Thank you so much for the code fix!

Regards,

Detlef

Tracker: https://tracker.moodle.org/browse/CONTRIB-4933

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

My github address is listed below. I can assure you my integration is VERY integrated -- syncing calendars, folder permissions with enrollments, etc.

 
Average of ratings: -
Picture of Rob Johnson
Re: Moodle and Google Apps for education
 

Hi Bob,

Does your integration provide SSO and user provisioning?  If I remember from when this thread was more active, it is more of an integration with calendar and Drive.

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

It doesn't provide user provisioning or SSO. It creates a repo, a block, syncs calendar items and provides read-only and student-writeable folders for sharing docs. Also provides Sites for the course. Maintains enrollments synchronization. Haven't been interested in either SSO or user provisioning of Google accounts through Moodle.

 
Average of ratings: -
Picture of Kevin Bruton
Re: Moodle and Google Apps for education
Group Core developers

Hi Bob!

I've been trying out Morsle. The functionality it offers seems very interesting indeed, however I haven't been able to get it going  too well. I wasn't too sure how to install it. I installed mod_morsle, block_morsle and repository_morsle, but I'm not sure how the authentication works or if I'm missing some other modules a part from those, because it's obviously not working for me the way it should. I'm not sure if there's a particular document where the installation of Morsle is explained? Many thanks.

 
Average of ratings: -
Picture of Bob Puffer
Re: Moodle and Google Apps for education
Group Plugin developersGroup Testers

Morsle currently requires admin account credentials to GAPPs domain. These are hashed and stored. In addition it requires two-legged OAuth to be enabled for the domain with the secret hashed and stored also. Am having a student worker upgrade auth to OAuth 2 because the current system will go away 7/2015.

 
Average of ratings:Useful (1)