Re: SQLBox make error

2011-02-06 Thread Scott Geller
, -- Alex Guerrieri On 06/02/2011, at 06:05, Scott Geller geller.subscr...@gmail.com wrote: I'd appreciate some help in configuring and installing SQLBox. This is with the most current version of SQLBox - I just downloaded it tonight from svn Thanks in advance! Scott [root

SQLBox make error

2011-02-05 Thread Scott Geller
I'd appreciate some help in configuring and installing SQLBox. This is with the most current version of SQLBox - I just downloaded it tonight from svn Thanks in advance! Scott [root@localhost sqlbox]# make make all-recursive make[1]: Entering directory `/root/Downloads/sqlbox' Making all in

Re: Kannel Mysql connectivity

2010-09-12 Thread Scott Geller
What exactly do you need in the database? I've had lots of luck with sqlbox capturing all data I need On 9/11/10, Harbhag Singh Sohal harbhag.so...@gmail.com wrote: 2010/9/11 Nikos Balkanas nbalka...@gmail.com: Hi, DLRs are in there. Read User's guide about dlr-storage. I was reading the

Re: Unwanted characters in sender phone number escape code output %q and %p

2010-07-24 Thread Scott Geller
*, , + are meaningfull to the shell, and it is not a bad idea to urlencode them. Perl has zillions of functions to urldecode text. Just use one of them. You can also try: exec = perl test.pl %p %k BR, Nikos - Original Message - From: Scott Geller To: users Sent: Saturday, July 24, 2010 6:10 AM

Unwanted characters in sender phone number escape code output %q and %p

2010-07-23 Thread Scott Geller
Hi All I'm getting unusual output in my escape codes %q and %p and I'd appreciate some help if possible from my conf file: group = sms-service keyword = test exec = perl test.pl %q %k omit-empty = true (I know it's a bad idea to execute - i'll look into URL once I get this working) From my

SMS Conditional Responses

2010-07-09 Thread Scott Geller
Hello I'm trying to figure out the best way to change the SMS response based on the number of times a message is received from a single user. In other words, suppose a message that meets a specific criteria (has correct keyword) comes in four times from the same phone number, how can I configure

Re: can sqlbox record all MT and MO ?

2010-07-09 Thread Scott Geller
I've tried this and did not have luck... how exactly would you set it up 'in between'? Thanks Scott On Fri, Jul 9, 2010 at 4:35 PM, Rene Kluwen rene.klu...@chimit.nl wrote: If you setup sqlbox in between bearerbox and smsbox, then also it logs messages in between them. == Rene

Re: getting MO and MT data into a database

2010-06-14 Thread Scott Geller
don't. Be aware, some SMScs do not send DLRs even in the case of MTs to modems, especially if they are mobile phones. BR, Nikos - Original Message - From: Scott Geller To: Nikos Balkanas Cc: users@kannel.org Sent: Sunday, June 13, 2010 6:59 PM Subject: Re: getting MO

Re: getting MO and MT data into a database

2010-06-14 Thread Scott Geller
according to their specified DLR-mask. MOs don't. Be aware, some SMScs do not send DLRs even in the case of MTs to modems, especially if they are mobile phones. BR, Nikos - Original Message - From: Scott Geller To: Nikos Balkanas Cc: users@kannel.org Sent: Sunday, June 13

Re: getting MO and MT data into a database

2010-06-13 Thread Scott Geller
version do you have? BR, Nikos - Original Message - From: Scott Geller To: users@kannel.org Sent: Saturday, June 12, 2010 7:00 AM Subject: getting MO and MT data into a database Guys, I've been working on this for days and cant get it working. I'm trying to get the data from

getting MO and MT data into a database

2010-06-11 Thread Scott Geller
Guys, I've been working on this for days and cant get it working. I'm trying to get the data from kannel into postgres... either with sqlbox or with BB. *regarding sqlbox:* I have sqlbox working and when I insert a line into the send_sms table, everything works on the MT side. But I'm under

sqlbox: PGSQL: could not connect to server

2010-06-08 Thread Scott Geller
Hi Kannel Users I'm new to Kannel and trying to get sqlbox running (I have bearerbox and smsbox running with no problems)... when I run sqlbox, I'm getting the following errors: 2010-06-08 20:25:48 [12785] [0] ERROR: PGSQL: connection to database 'dlr' failed! 2010-06-08 20:25:48 [12785] [0]

Beginners Question on SMS environment build

2010-04-18 Thread Scott Geller
I have a total beginners question I'm in the US, which from what I've read make things more complicated. I want to enable an SMS environment where customers would send a text to a 5-digit number (like twitter uses 40404). Contained in that text would be their name. I would also like to message