Differences

This shows you the differences between two versions of the page.

dev:gsoc2008_msg_plans [2008/06/06 23:17]
ajay_kumar
dev:gsoc2008_msg_plans [2009/07/06 20:36] (current)
Line 7: Line 7:
This page is intended as a place to jot down the progress, post queries and document research findings as I make progress on my work and to post findings as a result of communication with the **main-dev**. This document is always work in progress and parts of this document will/can be moved on to the main documentation pages from time to time upon maturation as needed. This page is intended as a place to jot down the progress, post queries and document research findings as I make progress on my work and to post findings as a result of communication with the **main-dev**. This document is always work in progress and parts of this document will/can be moved on to the main documentation pages from time to time upon maturation as needed.
 +
====== Project Plans ====== ====== Project Plans ======
 +
 +
 +
 +
 +===== Progress Updates =====
 +  - [[dev:gsoc_2008_msg_sms_login|SMS Login Architecture]]
 +  - [[dev:gsoc2008_msg_plans#logical_brainstorming_for_deliverable|Pointers Needed Urgent]]
===== Development Environment ===== ===== Development Environment =====
Line 17: Line 25:
    - PHP - Version 5.2.5     - PHP - Version 5.2.5
  - **Windows**   - **Windows**
-    - Distro - XP Professional with SP2 +    - Distro - XP Professional with SP2 [Version 5.1 Build 2600 SP2 RTM] 
-    - Apache - Version  +    - Apache - Version 2.2.2 
-    - mySQL - Version  +    - mySQL - Version 5.0.21-community 
-    - PHP - Version+    - PHP - Version 5.1.4 
 +    - Using XAMPP for Windows Version 1.5.3a www.apachefriends.org 
 + 
 + 
Line 26: Line 38:
  - Login to Sahana via SMS   - Login to Sahana via SMS
  - Ability to Access Sahana Menu via SMS   - Ability to Access Sahana Menu via SMS
-  - Focus on implementing on SMSTools for now (for Win32 access on PortalApps version)+  - Focus on implementing on SMSTools for now (for Win32 access on Portable App version) 
 + 
Line 37: Line 51:
    - [[sql:messaging|Understand the Messaging Tables DB Schema | **Pointers Needed** |]] - [[dev:sqlschema|Docu Incomplete]]     - [[sql:messaging|Understand the Messaging Tables DB Schema | **Pointers Needed** |]] - [[dev:sqlschema|Docu Incomplete]]
      * See mod/msg/inst/dbcreate.sql       * See mod/msg/inst/dbcreate.sql
 +      * SQL files do give a lot of information.
 +      * Incoming message storing is fine. But messages sent from the system using SEND Console are not logged in a proper way
 +      * Solution is to have detailed logging. Possible use of tables like "msg_smstools_log" whose current usage is unclear. **Is it unused ?**
    - How do Pre-Registered Cell numbers get ACL Role assigned for Alerts? | **Pointers Needed** |     - How do Pre-Registered Cell numbers get ACL Role assigned for Alerts? | **Pointers Needed** |
      * Assign a cell# to a Sahana username, Role assigned to username as per normal       * Assign a cell# to a Sahana username, Role assigned to username as per normal
 +      * Done by creating 2 additional fields in the "users" tables for 2 mobile numbers. Since they act as a password & keeping security framework in mind, it is being kept aside of the normal messaging table.
 +      * Admin configurable in case 1==mod_msg
    - Analyse existing SMS Handler code/functioning     - Analyse existing SMS Handler code/functioning
    - **Under [[dev:msg_archi|dev:msg_archi]]**     - **Under [[dev:msg_archi|dev:msg_archi]]**
Line 45: Line 64:
        * Kannel plugin receives SMS via Kannel which POSTs results to handler_kannel.inc         * Kannel plugin receives SMS via Kannel which POSTs results to handler_kannel.inc
      - Auto-refreshing SM receiving interface - Has this anything to do with getting the SM updates via SMS?| **Pointers Needed** |       - Auto-refreshing SM receiving interface - Has this anything to do with getting the SM updates via SMS?| **Pointers Needed** |
-    - If incoming SMS is processed as Input, Any special format followed for such input ? +    - <del>If incoming SMS is processed as Input, Any special format followed for such input ?</del> **Dont think so** 
-    - Check ACL +    - Check ACL **Done** Ignoring AUTH at the moment. 
-    - [[dev:sqllibdbinc|Check SQL]] +    - [[dev:sqllibdbinc|Check SQL]] **Done** 
-  - **Sahana System Login via SMS:**+    - **Check Session handling/Current Login architecture** | **Pointers Needed** 
 +       * SMS Login takes place in CURL sessions. 
 +       * Emulate Session handling by Cookies for each "senders caller id" as a "key" and store in DB 
 +       * Also store last menu accessed by each "sender_id" 
 + 
 +  - **[[dev:gsoc_2008_msg_sms_login|Sahana System Login via SMS: Click to view details]]**
    - Write a sample script to read incoming message and parse the input properly, something like "login <user> <pass>" -- **DONE**     - Write a sample script to read incoming message and parse the input properly, something like "login <user> <pass>" -- **DONE**
    - Invoke a script to do that, and separate each input item, encrypt the password.-- **Small Prototype DONE**     - Invoke a script to do that, and separate each input item, encrypt the password.-- **Small Prototype DONE**
Line 57: Line 81:
    - Above helps in keeping track of last accessed menu/menu option by this cellphone     - Above helps in keeping track of last accessed menu/menu option by this cellphone
    - Maintaining a session cookie with Caller ID for session handling/expiration of Login session     - Maintaining a session cookie with Caller ID for session handling/expiration of Login session
-    - **In theory getting this deliverable helps materialise:**+    - **In theory getting this deliverable helps materialize:**
      - DB Interaction through SMS       - DB Interaction through SMS
      - Reading the SMS and triggering execution of separate script/function to perform a task based on input       - Reading the SMS and triggering execution of separate script/function to perform a task based on input
-      - Sending the acknowledgement/output via SMS to user+      - Sending the acknowledgment/output via SMS to user
- 
-===== Progress Updates ===== 
-  - [[dev:gsoc_2008_msg_sms_login|SMS Login Architecture]] 
===== Additional Device Compatibility List [to be verified] ===== ===== Additional Device Compatibility List [to be verified] =====

Navigation
  • Navigate