[oscg-general] Integrating Open Source Applications
From Lussier, Denis Mar 18, 2011 6:22 AM
Hello Kennedy, The simple/generic strategy OpenSCG recommends for integrating applications, such as these, is as follows: #1) Create a single PostgreSQL master database with a matching user & schema for each of your applications. #2) Install each of your applications and make sure that it works independently. #3) Designate the appropriate one of your applications as the master application where you will always add/change/delete users from. #4) Use triggers on the user table, for your master application, to keep the users tables of the other applications in sync. #5) You will now be always able to login to any of the applications with the exact same user-id and password. #6) As a final optional (and challenging) step, you could work on sharing cookies across the applications so that you don't have to manually login/logout of each application seperately. --Luss On Fri, Mar 18, 2011 at 3:12 AM, Kennedy Yegon <kennyegon@gmail.com> wrote: > Hello friends, > I have gained alot from this forum lately. am currently customazing moodle > lms for our use in some training programmes. I need assistance in > integrating moodle,alfresco and Phpbb forums anyone there who can give me > the script.am running on suse Linux 11.3. the settings are as below > > http://127.0.0.1/moodle > http://127.0.0.1/alfresco > http://127.0.0.1/forum > > > Kindly assist > > > Best Regards, > > Kennedy > >
Hello Kennedy,<div><br></div><div>The simple/generic strategy OpenSCG recommends for integrating applications, such as these, is as follows:</div><div><br></div><div>#1) Create a single PostgreSQL master database with a matching user & schema for each of your applications.</div> <div><br></div><div>#2) Install each of your applications and make sure that it works independently.</div><div><br></div><div>#3) Designate the appropriate one of your applications as the master application where you will always add/change/delete users from.</div> <div><br></div><div>#4) Use triggers on the user table, for your master application, to keep the users</div><div>tables of the other applications in sync.</div><div><br></div><div>#5) You will now be always able to login to any of the applications with the exact same user-id and password.</div> <div><br></div><div>#6) As a final optional (and challenging) step, you could work on sharing cookies across the applications so that you don't have to manually login/logout of each application seperately. </div><div> <br></div><div>--Luss</div><div><br></div><div><br></div><div><br><div class="gmail_quote">On Fri, Mar 18, 2011 at 3:12 AM, Kennedy Yegon <span dir="ltr"><<a href="mailto:kennyegon@gmail.com">kennyegon@gmail.com</a>></span> wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hello friends,<br>I have gained alot from this forum lately. am currently customazing moodle lms for our use in some training programmes. I need assistance in integrating moodle,alfresco and Phpbb forums anyone there who can give me the <a href="http://script.am" target="_blank">script.am</a> running on suse Linux 11.3. the settings are as below<br> <br><a href="http://127.0.0.1/moodle" target="_blank">http://127.0.0.1/moodle</a><br><a href="http://127.0.0.1/alfresco" target="_blank">http://127.0.0.1/alfresco</a><br><a href="http://127.0.0.1/forum" target="_blank">http://127.0.0.1/forum</a><br> <br><br>Kindly assist<br> <br><br>Best Regards,<br><font color="#888888"><br>Kennedy</font><div><div></div><div class="h5"><br></div></div></blockquote></div></div>
