Differences

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

dev:gsoc2008_msg_plans [2008/05/31 14:27]
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** 
-    - Write a sample script to read incoming message and parse the input properly, something like "login <user> <pass>" +       * SMS Login takes place in CURL sessions. 
-    - Invoke a script to do that, and separate each input item, encrypt the password. +       * Emulate Session handling by Cookies for each "senders caller id" as a "key" and store in DB 
-    - Invoke DB transaction to check if user exists and return true or false.+       * 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** 
 +    - Invoke a script to do that, and separate each input item, encrypt the password.-- **Small Prototype DONE** 
 +    - Invoke DB transaction to check if user exists and return true or false. **Small Prototype DONE**
    - Doing this will help achieve a running prototype of the main idea behind any login system     - Doing this will help achieve a running prototype of the main idea behind any login system
    - Upon success, extend its implementation on to Sahana login system.     - Upon success, extend its implementation on to Sahana login system.
-    - Temporary mapping in DB of Login Name & Caller ID i.e. Cellphone number of user should be created+    - Temporary mapping in DB of Login Name & Caller ID i.e. Cellphone number of user should be created -- **lib_sms_session.inc**
    - 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
Line 68: Line 91:
In order to have our application communicate over SMS and take it as an input too we need both incoming and outgoing SMS transmission capabilities on the GSM Phone to be used. Hence, I am compiling this list to assist in further documentation. In order to have our application communicate over SMS and take it as an input too we need both incoming and outgoing SMS transmission capabilities on the GSM Phone to be used. Hence, I am compiling this list to assist in further documentation.
-==== List of phones that support AT Commands to both Send and Receive SMS ==== +**List goes here:** 
- +  * [[dev:msg_archi | Messaging Architecture ]
- +  * [[dev:msg_kannel_comp | Kannel Compatibility ]] 
-=== Nokia: === +  * [[dev:msg_smstools_comp | SMSTools Compatibility ]] 
- +  * [[dev:msg_gnokii_comp | gnokii Compatibility ]]
- +
-Series 40 [1] +
- +
-    * 6230 +
-    * 6230i +
-    * 6233 +
- +
-Uncategorised: [2][3+
- +
-    * 5110 +
-    * 71xx +
-    * 62xx +
-    * Nokia 3100 +
-    * Nokia 3100b/3120b +
-    * Nokia 3220 +
-    * Nokia 5110 +
-    * Nokia 5140 +
-    * Nokia 5140i +
-    * Nokia 6020 +
-    * Nokia 6021 +
-    * Nokia 6030 +
-    * Nokia 6070 +
-    * Nokia 6101 / 6100 +
-    * Nokia 6136 +
-    * Nokia 6170 +
-    * Nokia 6210 +
-    * Nokia 6230 +
-    * Nokia 6230i +
-    * Nokia 6250 +
-    * Nokia 6300 +
-    * Nokia 6310 +
-    * Nokia 6310i +
-    * Nokia 6510 +
-    * Nokia 6610i +
-    * Nokia Premicell (aka 09i) +
-    * Symbian s60 (Nokia 6600, 6260) +
- +
-=== Older Nokia Phones: === +
- +
-    * 6110 +
-    * 6130 +
-    * 6150 +
-    * 6190 +
-    * 5110 +
-    * 5130 +
-    * 5190 +
-    * 3210 +
-    * 3310 +
-    * 3330 +
-    * 3360 +
-    * 3390 +
-    * 3410 +
-    * 8210 +
-    * 8250 +
-    * 8290 +
-    * 8850 +
-    * RPM-1 +
- +
-=== Other Manufacturers: === +
- +
- +
-    * iTegno 3000 +
-    * LG U8120 (partial support) +
-    * Motorola +
-    * Sagem my W-8 (partial support, improved since gnokii 0.6.24) +
-    * Samsung SGH-X680 (partial support) +
-    * Siemens TC35i Revision 02.07 +
-    * Sony Ericsson K750i (partial support) +
-    * Sony Ericsson t68i (partial support) +
- +
-**Source:** +
- +
-   1. http://discussion.forum.nokia.com/forum/showthread.php?t=91489 +
-   2. http://discussion.forum.nokia.com/forum/showthread.php?t=561 +
-   3. http://wiki.gnokii.org/index.php/Config+

Navigation
  • Navigate