Re: Fgnokii-smsd-pgsql

[DAKSHINA MURTHY KAKUNURI]

Well

I started working on it.
copied the source of gnokii-0.6.12 into my pc.
Applied the patch to pq.c
                  
data->smsc_time.minute, data->smsc_time.second, text,
phnStr->str);
                     
g_print ("%s\n", buf->str);
                   g_free (text);
followed the steps
gnokii makes use of autoconf/automake which allows you to configure the
source tree for your system by typing

./configure

You can also run the script with the --help flag to get a list of available

options.  There are about a dozen or so that are specific to gnokii.

Once you've run ./configure successfully, you should be able to simply do a
make and make install to compile and install your binaries respectively.

make

make install
After experimenting with gnokii-smsd following is the screen output.

address@hidden gnokii-0.6.12]# gnokii --identify
GNOKII Version 0.6.12
LOG: xdebug mask is 0x1
IMEI         : 354686000356467
Manufacturer : WAVECOM MODEM
Model        : MULTIBAND  900E  1800
Revision     : 651b09gg.Q2406A 1481016 112405 18:09

address@hidden gnokii-0.6.12]# gnokii-smsd --db rsis -i 10
LOG: xdebug mask is 0x1
Initializing connection...
fbusinit: error 0
Version: MULTIBAND  900E  1800
Model: unknown
Revision:
Phone connected. Starting monitoring...
RefreshSMS is running...
1. Airtelcare   2006-07-10 12:32:39+05 Super value RC 350!!
Recharge today with RC 350 & enjoy Rs.210 regular Talktime with 30
days validity.
136: INSERT INTO public.inbox failed.
Error: ERROR:  invalid input syntax for integer: "Super"
CONTEXT:  PL/pgSQL function "UpdateResData" line 38 at assignment

Inserting Event: 1
Processing Event: 1
RefreshSMS is running...
GN_OP_GetSMSStatus at line 432 in file lowlevel.c returns error 1
Entering dumb mode.RefreshSMS is running...
1. 1   2006-07-10 15:40:10+00 10 1234.00 5454 3456 111
Inserting Event: 1
RefreshSMS is running...
Processing Event: 1
1. 1   2006-07-10 15:40:10+00 10 1234.00 5454 3456 111
136: INSERT INTO public.inbox failed.
Error: ERROR:  duplicate key violates unique constraint "reservoirdata_pkey"
CONTEXT:  SQL statement "insert into reservoirdata values( $1 , $2
, $3 , $4 ,'06:00', $5 , $6 , $7 , $8 ,'K.Dakshina Murthy',now())"
PL/pgSQL function "UpdateResData" line 43 at SQL statement

Inserting Event: 1
Processing Event: 1
RefreshSMS is running...
RefreshSMS is running...
RefreshSMS is running...

FINAL RESULT is that the phone number is not updated in inbox.

Hope this information is sufficient to find out the bug and fix it..
Thanking you and sorry for troubling you.

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

On Sat, 8 Jul 2006, DAKSHINA MURTHY KAKUNURI wrote:

> Once again I mention the platform for your convenience. fedora core 4, i386
> version 12 gnokii-smsd.

Sorry, I don't use Fedora.

jan

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