Re: Fgnokii-smsd-pgsql

[DAKSHINA MURTHY KAKUNURI]

Hello Sir

On 7/13/06, Jan Derfinak <address@hidden> wrote:

Please show me description of table inbox.
> jan

rsis=# \d inbox
                                      
Table "public.inbox"
   Column  
|           
Type            
|                      
Modifiers
------------+-----------------------------+-------------------------------------------------------
 id        
|
integer                    
| not null default nextval('public.inbox_id_seq'::text)
 number     | character varying(20)       | not null
 smsdate    | timestamp without time zone | not null
 insertdate | timestamp without time zone | not null default now()
 text       | character varying(160)      |
 phone     
|
integer                    
|
 processed  |
boolean                    
| default false
Indexes:
    "inbox_pkey" PRIMARY KEY, btree (id)
Triggers:
    "SMSarrived" AFTER INSERT ON inbox FOR EACH ROW EXECUTE PROCEDURE "UpdateResData"()

rsis=#


Even when it is in file mode, I am not getting the phone number from whom SMS is sent

address@hidden Desktop]# gnokii-smsd -m file
You have not set spool directory, sms sending is disabled!
Number: 1, Date: 2006-07-13 17:09:19
Text:
12 269.45 776 817 16.11
GN_OP_GetSMSStatus at line 432 in file lowlevel.c returns error 1
Entering dumb mode.Number: 1, Date: 2006-07-13 17:10:30
Text:
12 269.45 776 817 16.11
Number: 1, Date: 2006-07-13 17:10:30
Text:
12 269.45 776 817 16.11
address@hidden Desktop]#

-- 
K.DAKSHINA MURTHY,
Project Manager,
Center for Good Governance,
Dr.MCRHRD Campus,
Jubilee Hills, Hyderabad.
+91 9246290441