SparkFun Forums

[fgcity]

Hi everyone.

I want to do the following:

I have a MY SQL database setup on a server i have here locally, connected to the internet.

I have a few tables with osme numbers in the database.

I want to be able to read those numbers from the GE863 module through GPRS and do whatever i want with them.

Can i do this ?

What would be the steps on setting this up on my Module side and what would the general steps of acquiring the data from the database be ?

Any help would be really appreciated, i never worked with GPRS on this module (or any module) so i need all the help i can get here.

[incognico]

You would need to have some software on the server that receives the requests from your 863, does the SQL lookups, formats as required, and sends the data back.

This is fairly trivial to do with a custom application, or a website with server-side scripting (asp etc).

[fgcity]

tnx, i appriciate the reply

[fgcity]

ok

I'm trying to connect with PPP to GPRS


the PPP script is:

/dev/ttyS2
9600
connect 'chat -e -f /etc/ppp/gprs.chat'
noccp
defaultroute
usepeerdns
noauth
ipcp-accept-remote
ipcp-accept-local
noipdefault


the Chat script is:

ABORT ERROR
'' AT
OK AT+CPIN=1234
OK \d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\dAT+CGDCONT=1,"IP","cytamobile","0.0.0.0",0,0
OK AT+CGQMIN=1,0,0,0,0,0
OK AT#USERID="user"
OK AT#PASSW="pass"
OK AT#GPRS=1
OK ATD*99***1#
SAY "Connected"



if i use "OK ATD*99***1#" then i get an IP but when i do "ifconfig" then no "ppp0" appears
if i do :

AT#SD = 3 , 0 , 80 , “www.telit.com”

then i get the "ppp0" in "ifconfig" for a while and then it quits

co what am i missing here?

why can't i get the ppp to connect and stay connected so i could surf the web ?
PLEASE help


i did the same thing with: CONNECT ' '

and still the same thing
please help out here

all the commands respond with "OK" so it's something else
please help


this is what the responce is :
(from pppd)
AT
OK
AT+CPIN=1234
OK
AT+CGDCONT=1,"IP","cytamobile","0.0.0.0",0,0
OK
AT+CGQMIN=1,0,0,0,0,0
AT#USERID="user"
OK
AT#PASSW="pass"
OK
AT#GPRS=1
+IP: 10.160.6.2
OK
and then:
Connect script failed

[fgcity]

I’ve got to the point where I set the GPRS to 1

I get back an IP

But after that

No matter what I send I donn’t get a “CONNECT’


Here is the reply from the ppp script:

Jan 1 00:00:43 gumstix-custom-verdex local2.info chat[707]: AT#SGACT=1,1,"user","pass"^M^M
Jan 1 00:00:43 gumstix-custom-verdex local2.info chat[707]: #SGACT: 10.160.7.238^M
Jan 1 00:00:43 gumstix-custom-verdex local2.info chat[707]: ^M
Jan 1 00:00:43 gumstix-custom-verdex local2.info chat[707]: OK
Jan 1 00:00:43 gumstix-custom-verdex local2.info chat[707]: -- got it
Jan 1 00:00:43 gumstix-custom-verdex local2.info chat[707]: send (AT#SD=1,0,80,"www.google.com",0,0^M^M)
Jan 1 00:00:44 gumstix-custom-verdex local2.info chat[707]: expect (CONNECT)
Jan 1 00:00:44 gumstix-custom-verdex local2.info chat[707]: ^M
Jan 1 00:01:29 gumstix-custom-verdex local2.info chat[707]: alarm
Jan 1 00:01:29 gumstix-custom-verdex local2.info chat[707]: Failed
Jan 1 00:01:29 gumstix-custom-verdex daemon.err pppd[705]: Connect script failed
Jan 1 00:01:29 gumstix-custom-verdex daemon.info pppd[705]: Exit.


My 2 script are:

“PPP”

noipdefault
/dev/ttyS2
9600
connect 'chat -e -v -f /etc/ppp/gprs.chat'
defaultroute
usepeerdns
name user
debug

“CHAT”

'' AT
OK AT#SKTRST
OK AT+CGDCONT=1,"IP","cytamobile","0.0.0.0",0,0
OK AT#SCFG=1,1,0,90,600,50
OK AT#SGACT=1,1,"user","pass"
OK AT#SD=1,0,80,"www.google.com",0,0
CONNECT ''



PLEASE help out here
What could be the problem?

[fgcity]

but with this sim i can access GPRS with a MObile Phone