Forum LAMS for Tech-Heads - General Forum: Re: Re: Re: LAMS Moodle Intergration Problems with 403 and 400 Errors


 
Search: 

5: Re: Re: Re: LAMS Moodle Intergration Problems with 403 and 400 Errors
In response to 4 11/28/05 10:53 PM
[ Reply | Forward ]
USE `lamsone`;



insert into `lamsone`.`ext_server_org_map` values (1,'neelix','neelix','neelix.cbhslewisham.nsw.edu.au','','','','',0,0);

Posted by Adam Taylor

7: Re: Re: Re: Re: LAMS Moodle Intergration Problems with 403 and 400 Errors
In response to 5 11/29/05 01:20 AM
[ Reply | Forward ]
Adam,

Yes, the stuff you inserted into the LAMS db is not going to fly.

Give me a day or so. We'll get a step-by-step integration instructions so we can you walkthru it

Ernie

Posted by Ernie Ghiglione

8: Re: Re: Re: Re: LAMS Moodle Intergration Problems with 403 and 400 Errors
In response to 5 11/29/05 06:01 PM
[ Reply | Forward ]
Hi Adam,

The SQL statement you posted won't work, the last digit '0' needs to be the id of the organisation in LAMS you intend to use for Moodle - there is no organisation with id=0. It's also missing a 'userinfo_url', which is what LAMS needs to respond to Moodle.

It should look something like this:

insert into ext_server_org_map (serverid, serverkey, servername, serverdesc, prefix, userinfo_url, timeout_url, disabled, orgid)
values ('neelix', 'neelix', 'neelix.cbhslewisham.nsw.edu.au', 'some description', 'choose a prefix, e.g. cb_', 'http://neelix.cbhslewisham.nsw.edu.au/moodle/mod/lams/userinfo.php?un=%username%&ts=%timestamp%&hs=%hash%', 'some timeout_url', 0, orgid);

The only items you need to get are the orgid and possibly the userinfo_url (your exact URL may be different, I just guessed it). And a prefix for your Moodle usernames. There's no need to manually enter an id for the row in ext_server_org_map, mysql will do that itself (it's also safer to let mysql do it, just in case you have another integrated server entry, and you overwrite it).

To get the orgid of the organisation you want to use:
1. login to LAMS and create an organisation, give it a name
2. login to mysql, and do 'select * from u_organisation'
3. find the row with the organisation name you just created - the column 'sid' is the id of the organisation you want to use.

Posted by Jun-Dir Liew

9: Re: Re: Re: Re: LAMS Moodle Intergration Problems with 403 and 400 Errors
In response to 5 11/29/05 11:56 PM
[ Reply | Forward ]
Adam,

We have just upgraded the LAMS integration configuration page to make it easier for people to understand what they need to do to get the LAMS integrations working. Please have a look here:

http://lamsfoundation.org/integration/lamsintegration/

Thanks,

Ernie

Posted by Ernie Ghiglione

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum