OpenID Provider for the Mailman data with Use Case

June 25, 2010 at 1:24 am | Posted in FOSS/Linux/ | Leave a comment
Tags: , ,

    Malveeka’s last year code produced the Postgresql Adaptor for Mailman that could store the pickle file data into Postgresql.The first and foremost priority will be for the existing users of the Mailman that have been members of the mailing list , moving it completely to the new database so that it is not dependent on the existing pickle data files and rather on the database.
    Now as the database are being populated every time the query processes and actions such as new list creation, postage, change in the user membership info , bounce list change, it will be reflected in the database .

As , discussed above solution to try adding one more table for the membership which will be stored in the lists database or the alternate is to add another membership database itself with the fields like the username , passwords , user_info, membership_info which will be able to retrieve the data and anywhere to be used like for the CMS, Wiki. Ther table will be centrally used for the other applications as well as so that the things become more simpler and easier without being able to make changes to the requests that needs to retrieve the credentials every time .

Now for the Open ID implementation we could have a Open ID Provider that will run simultaneously with the Mailman daemon script on the server. which will accept the use of membership table that we are creating for the retrieval and fetching the queries for the credentials to be used. A user who comes to join the Mailing List of Systers and submits her Credentials with the Email Address she chooses, the Name and the Password . There could be many number of list that happens to be on the server and if she joins more than the one list , then it might be possible with the different passwords . Now here the preference would be to store the password in the common database , apart from the dlist database and also to use the email id as the primary key to match the corresponding id to be used in the relational database . The question arises which password to be used as the primary one for the OpenID.

How to switch to other list option page

Let us suppose that a new user comes to the , she subscribes to a Mailing List ‘A’ and also subscribes to mailing List ‘B’ , now what we can have is to either use the Mailing List ‘A’ Password to be used as primary and use ther password for the OpenID Authentication. There will be an identifier which will be primarily using Email as the user identifier that will be created as the user supplies her email id while subscribing and it will be notified to the user about her OpenID identifier . Now as she comes to the CGI which will be using as the Open ID relying party which will be verifying with the Provider by redirecting and taking him to the

The user will be redirected to her options page and from there on he could visit the list of ML’s and also to switch to other ML’s without supplying password for each list , although she can change the passwords that will be secondary and of only use when she decides not to use her OpenID. For the Relying Party, CGI will be inculcated to redirect from any of the Mailing Lists.

The Python Open-ID API’s is used forthe OpenID Provider as well as  relying party.


Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at
Entries and comments feeds.

%d bloggers like this: