from:"Alejandro Guerrieri"

Looks like you're missing the libclntsh.so library, or Kannel is searching
for it on the wrong place.

Check if it's installed, you told Kannel to search for it on
/instaclient_10_2 is that the place where the libs are?

Regards,

Alex

On Fri, Apr 15, 2011 at 3:36 AM, Francisco Oliveira 
fran.mb.olive...@gmail.com wrote:

  Hello, Alex, Nikos and everybody,

 Many thanks for responding my posts.

 I had to reinstall everything from scratch.
 Now I have oracle's instant client on the same account I'm installing
 Kannel.
 Oracle database is running on the same machine under a different account.

 So, when I run

 ./configure --with-oracle
 --with-oracle-includes=/instantclient_10_2/sdk/include
 --with-oracle-libs=/instantclient_10_2

 I get:
 ...

 Configuring DB support ...
 checking whether to compile with MySQL support... disabled
 checking whether to compile with LibSDB support... disabled
 checking whether to compile with SQLite2 support... disabled
 checking whether to compile with SQLite3 support... disabled
 checking whether to compile with Oracle support... searching
 checking for oci.h ... yes
 checking for OCIEnvCreate in -lclntsh... no
 checking for OCIEnvCreate in -lclntsh... (cached) no

 What should I do?

 Best wishes,

 Fran

 On Apr 13, 2011, at 7:48 PM, Nikos Balkanas wrote:

  Hi,
 
  Could also be at compile time iconv is not in the user's library path. In
 Linux it is defined in /etc/ld.so.conf and in Solaris in LD_LIBRARY_PATH.
 Not sure what is in Mac.
 
  BR,
  Nikos
  - Original Message - From: Alejandro Guerrieri
  To: Francisco Oliveira
  Cc: us...@vm1.kannel.org
  Sent: Wednesday, April 13, 2011 4:13 PM
  Subject: Re: Re: Compile problems - any Mac OS X 10.6 users?
 
 
  There must be some previous complain on configure I guess? This is what I
 get when compiling on Snow Leopard:
 
 
  checking for iconv... yes
  checking for working iconv... yes
  checking how to link with libiconv... -liconv
  checking for iconv declaration...
 extern size_t iconv (iconv_t cd, char * *inbuf, size_t
 *inbytesleft, char * *outbuf, size_t *outbytesleft);
 
 
  Is the /usr/bin/iconv command available? What about running it with the
 -l switch? You should get a list of supported charsets.
 
 
  Anyway, check if you have the iconv libraries.
 
 
  Regards,
 
 
  Alex
 
 
 
  On Wed, Apr 13, 2011 at 12:51 PM, Francisco Oliveira 
 fran.mb.olive...@gmail.com wrote:
 
  Hi everyone,
  I'm having a problem very similar to the one Hujumuju had posted.
  Was it solved?
  Please let me know.
  Many thanks in advance and all the best,
  Francisco Oliveira (Fran)
  Here's your original post:
  Hello.
 
  I am trying to compile Kannel under Mac OS X 10.6 (Snow Leopard). I have
  Xcode 3.2 for Mac OS X 10.6 Snow Leopard + MacPorts
 
  configure goes fine and i have attached config,log to this message.
 
  Anyway, make fails:
 
  gcc -std=gnu99 -D_REENTRANT=1 -I. -Igw -g -O2 -DDARWIN=1
  -L/Developer/SDKs/MacOSX10.5.sdk/usr/lib
  -I/Developer/SDKs/MacOSX10.5.sdk/usr/include -D_LARGE_FILES=
  -I/usr/include/libxml2 -I/usr/include/openssl -L/opt/local/lib -o
  wmlscript/wmlsc wmlscript/wmlsc.o libgw.a libwmlscript.a libwap.a
  libgwlib.a -lssl -lresolv -lm  -lpthread -lxml2 -lz -lpthread -licucore
  -lm -L/usr/lib -lcrypto -lssl
  Undefined symbols:
   _iconv_close, referenced from:
   _charset_convert in libgwlib.a(charset.o)
   _iconv, referenced from:
   _charset_convert in libgwlib.a(charset.o)
   _iconv_open, referenced from:
   _charset_convert in libgwlib.a(charset.o)
  ld: symbol(s) not found
  collect2: ld returned 1 exit status
  make: *** [wmlscript/wmlsc] Error 1
 
  Does anyone have experience with Max OS X? I've compile kannel
  sucesfully before on 10.5 (Leopard) machine.
 
  Thanks for any tips in advance.

Re: Slow RX incoming

Is the issue constant, or only happens at some specific times during the
day?

Do you have DLR's enabled? DB-backed? Maybe the issue happens when you're
getting lots of them?

Perhaps a long shot, but might be worth checking: try doing a packet trace
and verify you're not getting TCP zero win errors.

Regards,

Alex

On Thu, Apr 14, 2011 at 7:27 AM, Rapture supp...@ims.co.ke wrote:

  Hi guys,



 We’ve been running a campaign averaging 350,000 messages a day. Lately I
 noticed kannel does not retrieve them as fast as it needs to hence  a
 backlog builds on the operator’s end. This is only affecting one of the
 operators. On calling them, they insisted that it is Kannel which determines
 how many RX messages to pull. I tried an old SMPP client software I’d
 written in Delphi and it cleared all the backlog in less than 5 mins and
 continues to do so in real time. All data is dumped into the same mysql
 table. I’ve tried using throughput in kannel with no success. I’ve even
 opened upto 15 channels to the same operator without success.



 What could be the issue? How can I speed up my intake of messages?



 Distraught,



 TR

Re: Compile problems - any Mac OS X 10.6 users?

.so won't work on Mac (I didn't know/missed that you were using Mac).

Kind of messy, but If the files are there, you might get away by symlinking
them from /usr/lib and see if that helps.

Regards,

Alex

On Fri, Apr 15, 2011 at 1:41 PM, Francisco Oliveira 
fran.mb.olive...@gmail.com wrote:

 Many thanks Alex and Nikos,

 Here's my situation:

 I have downloaded Oracle's instant client for Mac OS X Version 10.2.0.4
 (This is the one available at Oracle's website) and installed it
 at /instantclient_10_2.
 There, we don't have  libclntsh.so nor libclientsh.so
 However, we do have libclntsh.dylib and libclntsh.dylib.10.1
 So, when I run:

 $ nm  libclntsh.dylib  | grep OCIEnvCreate
 I get:

 0016aa89 T _OCIEnvCreate

 and when I run:

 $ nm  libclntsh.dylib.10.1  | grep OCIEnvCreate
 I also get :

 0016aa89 T _OCIEnvCreate

 I've  created links to these libraries:

 $ ln libclntsh.dylib.10.1 libclientsh.so
 $ ln libclntsh.dylib.10.1  libclntsh.so

 and run

 ./configure --with-oracle
 --with-oracle-includes=/instantclient_10_2/sdk/include
 --with-oracle-libs=/instantclient_10_2

 However, I still get the error:

 Configuring DB support ...
 checking whether to compile with MySQL support... disabled
 checking whether to compile with LibSDB support... disabled
 checking whether to compile with SQLite2 support... disabled
 checking whether to compile with SQLite3 support... disabled
 checking whether to compile with Oracle support... searching
 checking for oci.h ... yes
 checking for OCIEnvCreate in -lclntsh... no
 checking for OCIEnvCreate in -lclntsh... (cached) no

 There's also  a lib, libocci.dylib.10.1, that when I run:

 $ nm  libocci.dylib.10.1  | grep OCIEnvCreate

 I get:

 U _OCIEnvCreate

 I've also created

 $ ln libocci.dylib.10.1  libclntsh.so
 $ ln libocci.dylib.10.1  libclientsh.so

 and run:

 ./configure --with-oracle
 --with-oracle-includes=/instantclient_10_2/sdk/include
 --with-oracle-libs=/instantclient_10_2

 and still got the error:

 Configuring DB support ...
 checking whether to compile with MySQL support... disabled
 checking whether to compile with LibSDB support... disabled
 checking whether to compile with SQLite2 support... disabled
 checking whether to compile with SQLite3 support... disabled
 checking whether to compile with Oracle support... searching
 checking for oci.h ... yes
 checking for OCIEnvCreate in -lclntsh... no
 checking for OCIEnvCreate in -lclntsh... (cached) no.

 Any other suggestions before trying to find an older Oracle Instant Client?

 All the best,

 Fran


 On Apr 15, 2011, at 6:09 AM, Alejandro Guerrieri wrote:

 Looks like you're missing the libclntsh.so library, or Kannel is searching
 for it on the wrong place.

 Check if it's installed, you told Kannel to search for it on
 /instaclient_10_2 is that the place where the libs are?

 Regards,

 Alex

 On Fri, Apr 15, 2011 at 3:36 AM, Francisco Oliveira 
 fran.mb.olive...@gmail.com wrote:

  Hello, Alex, Nikos and everybody,

 Many thanks for responding my posts.

 I had to reinstall everything from scratch.
 Now I have oracle's instant client on the same account I'm installing
 Kannel.
 Oracle database is running on the same machine under a different account.

 So, when I run

 ./configure --with-oracle
 --with-oracle-includes=/instantclient_10_2/sdk/include
 --with-oracle-libs=/instantclient_10_2

 I get:
 ...

 Configuring DB support ...
 checking whether to compile with MySQL support... disabled
 checking whether to compile with LibSDB support... disabled
 checking whether to compile with SQLite2 support... disabled
 checking whether to compile with SQLite3 support... disabled
 checking whether to compile with Oracle support... searching
 checking for oci.h ... yes
 checking for OCIEnvCreate in -lclntsh... no
 checking for OCIEnvCreate in -lclntsh... (cached) no

 What should I do?

 Best wishes,

 Fran

 On Apr 13, 2011, at 7:48 PM, Nikos Balkanas wrote:

  Hi,
 
  Could also be at compile time iconv is not in the user's library path.
 In Linux it is defined in /etc/ld.so.conf and in Solaris in LD_LIBRARY_PATH.
 Not sure what is in Mac.
 
  BR,
  Nikos
  - Original Message - From: Alejandro Guerrieri
  To: Francisco Oliveira
  Cc: us...@vm1.kannel.org
  Sent: Wednesday, April 13, 2011 4:13 PM
  Subject: Re: Re: Compile problems - any Mac OS X 10.6 users?
 
 
  There must be some previous complain on configure I guess? This is what
 I get when compiling on Snow Leopard:
 
 
  checking for iconv... yes
  checking for working iconv... yes
  checking how to link with libiconv... -liconv
  checking for iconv declaration...
 extern size_t iconv (iconv_t cd, char * *inbuf, size_t
 *inbytesleft, char * *outbuf, size_t *outbytesleft);
 
 
  Is the /usr/bin/iconv command available? What about running it with the
 -l switch? You should get a list of supported charsets.
 
 
  Anyway, check if you have the iconv libraries.
 
 
  Regards,
 
 
  Alex
 
 
 
  On Wed, Apr 13, 2011 at 12:51

Re: Slow RX incoming

Make a packet trace and check if you get zero win errors. If you get tons
of DLR's and your DB is not fast enough that would explain the problem.

Art you using a regular Kannel or did you apply any patches to it?

Regards,

Alex

On Fri, Apr 15, 2011 at 2:35 PM, Rapture supp...@ims.co.ke wrote:

  Hi Alex,



 The issue is persistent but all has been well till about 3 weeks ago when I
 started receiving huge bursts of messages. DLR is enabled and DB is ok as
 other application is working properly.


 Regards,



 Rapture



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Friday, April 15, 2011 12:14 PM

 *To:* Rapture
 *Cc:* users@kannel.org
 *Subject:* Re: Slow RX incoming



 Is the issue constant, or only happens at some specific times during the
 day?



 Do you have DLR's enabled? DB-backed? Maybe the issue happens when you're
 getting lots of them?



 Perhaps a long shot, but might be worth checking: try doing a packet trace
 and verify you're not getting TCP zero win errors.



 Regards,



 Alex

 On Thu, Apr 14, 2011 at 7:27 AM, Rapture supp...@ims.co.ke wrote:

 Hi guys,



 We’ve been running a campaign averaging 350,000 messages a day. Lately I
 noticed kannel does not retrieve them as fast as it needs to hence  a
 backlog builds on the operator’s end. This is only affecting one of the
 operators. On calling them, they insisted that it is Kannel which determines
 how many RX messages to pull. I tried an old SMPP client software I’d
 written in Delphi and it cleared all the backlog in less than 5 mins and
 continues to do so in real time. All data is dumped into the same mysql
 table. I’ve tried using throughput in kannel with no success. I’ve even
 opened upto 15 channels to the same operator without success.



 What could be the issue? How can I speed up my intake of messages?



 Distraught,



 TR

Re: Slow RX incoming

You can do a packet trace using tcpdump:

sudo tcpdump -s 65000 -w kannel_trace.pcap host smsc ip and port smsc
port

You can then open it with ethereal.

Hope it helps,

Alex

On Fri, Apr 15, 2011 at 2:51 PM, Rapture supp...@ims.co.ke wrote:

  Regular Kannel.



 I’m not familiar with  a packet trace or zero win errors…



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Friday, April 15, 2011 3:47 PM

 *To:* Rapture
 *Cc:* users@kannel.org
 *Subject:* Re: Slow RX incoming



 Make a packet trace and check if you get zero win errors. If you get tons
 of DLR's and your DB is not fast enough that would explain the problem.



 Art you using a regular Kannel or did you apply any patches to it?



 Regards,



 Alex

 On Fri, Apr 15, 2011 at 2:35 PM, Rapture supp...@ims.co.ke wrote:

 Hi Alex,



 The issue is persistent but all has been well till about 3 weeks ago when I
 started receiving huge bursts of messages. DLR is enabled and DB is ok as
 other application is working properly.


 Regards,



 Rapture



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Friday, April 15, 2011 12:14 PM


 *To:* Rapture
 *Cc:* users@kannel.org
 *Subject:* Re: Slow RX incoming



 Is the issue constant, or only happens at some specific times during the
 day?



 Do you have DLR's enabled? DB-backed? Maybe the issue happens when you're
 getting lots of them?



 Perhaps a long shot, but might be worth checking: try doing a packet trace
 and verify you're not getting TCP zero win errors.



 Regards,



 Alex

 On Thu, Apr 14, 2011 at 7:27 AM, Rapture supp...@ims.co.ke wrote:

 Hi guys,



 We’ve been running a campaign averaging 350,000 messages a day. Lately I
 noticed kannel does not retrieve them as fast as it needs to hence  a
 backlog builds on the operator’s end. This is only affecting one of the
 operators. On calling them, they insisted that it is Kannel which determines
 how many RX messages to pull. I tried an old SMPP client software I’d
 written in Delphi and it cleared all the backlog in less than 5 mins and
 continues to do so in real time. All data is dumped into the same mysql
 table. I’ve tried using throughput in kannel with no success. I’ve even
 opened upto 15 channels to the same operator without success.



 What could be the issue? How can I speed up my intake of messages?



 Distraught,



 TR

Re: Re: Compile problems - any Mac OS X 10.6 users?

2011-04-13 Thread Alejandro Guerrieri

There must be some previous complain on configure I guess? This is what I
get when compiling on Snow Leopard:

checking for iconv... yes
checking for working iconv... yes
checking how to link with libiconv... -liconv
checking for iconv declaration...
 extern size_t iconv (iconv_t cd, char * *inbuf, size_t
*inbytesleft, char * *outbuf, size_t *outbytesleft);

Is the /usr/bin/iconv command available? What about running it with the -l
switch? You should get a list of supported charsets.

Anyway, check if you have the iconv libraries.

Regards,

Alex


On Wed, Apr 13, 2011 at 12:51 PM, Francisco Oliveira 
fran.mb.olive...@gmail.com wrote:

 Hi everyone,

 I'm having a problem very similar to the one Hujumuju had posted.

 Was it solved?

 Please let me know.

 Many thanks in advance and all the best,

 Francisco Oliveira (Fran)

 Here's your original post:

 Hello.

 I am trying to compile Kannel under Mac OS X 10.6 (Snow Leopard). I have
 Xcode 3.2 for Mac OS X 10.6 Snow Leopard + MacPorts

 configure goes fine and i have attached config,log to this message.

 Anyway, make fails:

 gcc -std=gnu99 -D_REENTRANT=1 -I. -Igw -g -O2 -DDARWIN=1
 -L/Developer/SDKs/MacOSX10.5.sdk/usr/lib
 -I/Developer/SDKs/MacOSX10.5.sdk/usr/include -D_LARGE_FILES=
 -I/usr/include/libxml2 -I/usr/include/openssl -L/opt/local/lib -o
 wmlscript/wmlsc wmlscript/wmlsc.o libgw.a libwmlscript.a libwap.a
 libgwlib.a -lssl -lresolv -lm  -lpthread -lxml2 -lz -lpthread -licucore
 -lm -L/usr/lib -lcrypto -lssl
 Undefined symbols:
_iconv_close, referenced from:
_charset_convert in libgwlib.a(charset.o)
_iconv, referenced from:
_charset_convert in libgwlib.a(charset.o)
_iconv_open, referenced from:
_charset_convert in libgwlib.a(charset.o)
 ld: symbol(s) not found
 collect2: ld returned 1 exit status
 make: *** [wmlscript/wmlsc] Error 1

 Does anyone have experience with Max OS X? I've compile kannel
 sucesfully before on 10.5 (Leopard) machine.

 Thanks for any tips in advance.

Re: smpp throughput

2011-04-12 Thread Alejandro Guerrieri

The SVN trunk is rock solid, actually more stable than 1.4.3 for what
matters.

We've been using the SVN head for ages in production, handling _lots_ of
traffic and never had any issues with it.

Regards,

Alex

On Tue, Apr 12, 2011 at 8:34 PM, Konstantin Vayner pon...@appcell.netwrote:

 1.4.3 :(

 And i do have a problem upgrading production environment to SVN / 1.5.0 -
 the client is not going to like the fact it's not *stable* release.


 On Tue, Apr 12, 2011 at 6:08 PM, Juan Nin jua...@gmail.com wrote:

 What Kannel version are you using?

 I believe that up until 1.4.3 there were still issues with throughput
 which were finally fixed on CVS (now SVN)


 On Tue, Apr 12, 2011 at 2:13 AM, Konstantin Vayner pon...@appcell.net
 wrote:
  Hi List,
  When configuring thoughput for smpp connections, what may lead Kannel to
  send more submit_sm per second than the configured limit?
  Sometimes i see it trying to send up to 80 mps when configured to 50.
 (the
  counts are done by analyzing the logfile, since i dont see any normal
 way of
  doing this)
  And then - when it goes higher than the limit - it hits throttling error
  from the operator and the speed falls to the ground for a couple of
 seconds.
  Which overall results in us not being able to use the limit fully,
 because
  the setback after throttling error.
  Regards,
Konstantin

Re: NoSQL and Kannel

2011-03-24 Thread Alejandro Guerrieri

I've been playing with kannel and memcached a little bit, but nothing worth
posting so far. The unreliable nature of memcached (because of its
unreplicated horizontal scaling) doesn't make it very suitable for DLR's in
fact (e.g., a node going down and zapping all the dlrs stored in it).

Other noSQL engines would make more sense.

Regards,

Alex

On Thu, Mar 24, 2011 at 8:12 PM, Toby Phipps toby.phi...@nexmedia.com.sgwrote:

 Hi all,



 Has anyone put any thought into implementing Kannel DLR storage (and the
 basics of sqlbox MT injection) in a NoSQL datastore?  We are using Redis (
 http://redis.io) for other projects and are very happy with it. Its
 key-based storage/retrieval and strong support for arrays as atomic queues
 would make it perfect for Kannel, especially given the transient nature of
 this data and Redis’ memory speed with disk backing.



 The main advantages in my mind are that during heavy loads disk access
 would be minimized, DB polling would disappear (to be replaced with blocking
 array pops) and the SQL overhead would be removed replaced with set/fetch by
 keys.



 No particular reason this would need to be Redis – memcached, MongoDB,
 Cassandra etc. would also probably work well assuming they have the
 array/queue support.



 Any thoughts? It wouldn’t be a small project, but basing the code on the
 existing implementations of SQL DLRs and sqlbox would mean  a big jump
 start…



 Toby.

Re: How to stop bearerbox and smsbox

2011-03-08 Thread Alejandro Guerrieri

Use the --daemonize switch to detach from the console.

To kill the processes, you can identify the process id's and kill -9 them, or 
do a killall by process name.

Check the user guide for the finer details.

Anyway, I'd recommend you to use an init script, there's some examples for 
RedHat/CentOS and other distros floating around, google a little bit and you'll 
find out.

Regards,
--
Alex Guerrieri

On 09/03/2011, at 07:50, Jalal Uddin jalal@gmail.com wrote:

 Hello,
 
 I am new with kannel. I usually run kannel (bearerbox , smsbox) from command 
 prompt. Like below:
 
  
 
 Terminal 1
 
 $ cd /etc/kannel
 
 $ Bearerbox kannel.conf
 
  
 
 Terminal 2
 
 $ cd /etc/kannel
 
 $ Smsbox kannel.conf
 
  
 
 And everything starts up and I can send sms from the browser using url. The 
 problem is when I start kannel like that it hangs the terminal as it 
 continuously listens to the service. But that is not a problem. The problem 
 is when I need to shut down the server. I need to stop those two bearerbox 
 and smsbox.
 
  
 
 So say I apply Ctrl+z and they stop. Then I close the terminals, and restart 
 the pc.  But after that when I try to start bearerbox and smsbox, I can’t do 
 that. It says the ports are already in use. If I restart kannel (well server 
 restart should do that as well I guess) it still says port is in use and 
 nothing works. So I have to open kannel.conf and change the port and then 
 again the bearerbox and smsbox work. Interesting is I can’t use the old ports 
 never ever. So this is a problem that every time I need to change kannel.conf 
 or restart kannel or server. I have to apply a brand new port. I understand 
 this is very silly and should be the case. I feel like all my previous runs 
 are still running in the pc. But I don’t know how to stop them and can use 
 the same port next time. I have searched hard in internet but I hardly see 
 anyone facing such silly problem, so I wonder what I am missing.
 
  
 
 I will be very thankful if someone can point out what I am missing, like what 
 is the perfect way to restart kannel and how can I use the previous ports 
 again.
 
  
 
 Thank you

Re: Kannel HTTP locking up

2011-02-22 Thread Alejandro Guerrieri

We use CentOS since 3.x (latest is 5.x) with very good results, but any
recent distro should work fine.

Regards,

Alex

On Tue, Feb 22, 2011 at 3:47 PM, Richard Crawshaw 
richard.craws...@callparents.com wrote:

 OK, many thanks.  That means that we need a Linux box to run Kannel on.
  However, I'm not really familiar with Linux, is there a recommended
 distribution that Kannel runs best on, or any that are best avoided?

 Regards
 Richard


 -Original Message-
 From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf
 Of Stipe Tolj
 Sent: 21 February 2011 16:47
 Cc: users@kannel.org
 Subject: Re: Kannel HTTP locking up

 Am 21.02.2011 13:58, schrieb Richard Crawshaw:
  Hi
 
  I'm having a problem that looks like Kannel's SMS box HTTP listener is
 locking up.
 
  I've been running some load tests on Kannel, sending out 30K messages
 over a
  short space of time.
 
  I am running Kannel version 1.5.0 under Windows using Cygwin.  I have no
 problem
  if it is running on my Windows 7 laptop, 32 bit 2.68G RAM, 2.53GHz.
  However,
  when it is running on one of our servers it locks up after about 24K
 messages.
  The server is Windows Server 2003 R2 Enterprise x64 Edition SP2, 2GHz
 with 8G RAM.
 
  The only difference between the two is the Kannel configuration file
 which
  points the log files to different places in the file system.  Both
 instances of
  Kannel were compiled from the same source code on the target machines
 using the
  latest version of Cygwin.
 
  The server isn't under a heavy load.  It is also running IIS.
 
  After Kannel locks up there are no further entries added to its log files
 and
  from what I've found the only solution is to stop and restart it.  There
 doesn't
  appear to be anything additional logged from the server that isn't logged
 from
  my laptop.
 
  Has anyone else seen anything like this before?  Any clues to what may be
 the
  cause or possible solutions would be greatly appreciated.
 
  I can post logs and config file if needed.

 Cygin's pthreads, which Kannel uses heavily is NOT(!) stable. That's the
 simple
 reason. This is BTW also the reason why Cygwin never packaged the mysql
 server.
 So, there is NO way to use Kannel on Cygwin for real production use.

 Stipe

 --
 ---
 Kölner Landstrasse 419
 40589 Düsseldorf, NRW, Germany

 tolj.org system architecture  Kannel Software Foundation (KSF)
 http://www.tolj.org/  http://www.kannel.org/

 mailto:st_{at}_tolj.org   mailto:stolj_{at}_kannel.org
 ---

Re: Odd DLR msg ID from operator

2011-02-18 Thread Alejandro Guerrieri

Yes, I've seen this kind of mess many times before... and shockingly it's
not contrary to the spec.

The spec is really blurry on DLR's, it only provides an example of what a
DLR would look like, but it doesn't enforce any particular format.

Kannel only accept a couple of the more popular formats, but definitely
needs help dealing with non-standard formats, specially when the id's
doesn't even match.

Perhaps a simpler approach would have been to regex-match for ^\d{2}\/ and
remove it if present?

Regards,

Alex

2011/2/18 Kyriacos Sakkas kyria...@netsmart.com.cy

 Hi All,

 This is definitely an SMPP connection, whether it actually it is SMPP,
 thats a different story :).

 I have already asked the relevant (big name) operator whether this is
 something they can change. To give you the full story we have multiple
 binds with this operator, each bind used to bill (MT billing) a
 different amount. Now the first issue I noticed is that no matter what
 bind you sent from, the DLR comes from the 0 rated bind. After asking
 them about this they replied that yes that's just how it is, so I edited
 the source files and chhanged the mysql dlr functions to handle this,
 while not breaking any other connections I have - I made the smsc field
 length=12 (any longer smsc-id names get truncated to 12 chars on insert)
 , put smsc=LEFT(?,12) in the queries to match the longer smsc-id s I use
 for this operator (which have to be unique in order for me to be able to
 specify which one the message goes out from).

 So that was fixed.. after fixing that I noticed that DLRs were not
 matching again, and spotted that they are changing the ID string along
 the way.

 So I can solve this by doing something similar to the above, chopping
 the first 2 chars in the mysql queries, but this one will not be easy to
 do and retain compatibility with the rest of the normally behaving binds
 to other operator that I have. Running a dedicated server for this guys
 is an option, I would just rather not if I can. I guess I could set a
 conf parameter that passes a flag to the dlr functions that tels them to
 change queries (like how MSISDNs are added to queries for EMI/UCP 
 SMPP) but that would just seriously brake my upstream compatibility,
 plus my programing skill are probably not up to it.

 So yep if someone things that this can be done with pure MYSQL triggers
 or something like that, which does not need heavy kannel changes, please
 let me know.

 Thanks,
 Kyriacos Sakkas

 On 18/02/2011 07:50, Nikos Balkanas wrote:
  Hi,
 
  I was asking for the raw logs, to verify that is indeed SMPP traffic,
  as stated from the PDU names. If it is, then it seems contrary to the
  spec. He could try talking to his SMSc about it.
 
  BR,
  Nikos
  - Original Message - From: Alan McNatty a...@catalyst.net.nz
  To: Alejandro Guerrieri alejandro.guerri...@gmail.com
  Cc: users users@kannel.org
  Sent: Thursday, February 17, 2011 11:36 PM
  Subject: Re: Odd DLR msg ID from operator
 
 
  Hi Alex,
 
  I wonder (just off the top of my head) .. if using DB DLR with stored
  procedure / trigger could work by stripping the prefix on insert?
 
  Just a random idea that could be worth looking into - possible/obvious
  performance implication.
 
  Cheers,
  Alan
 
 
  On 18/02/11 10:26, Alejandro Guerrieri wrote:
  Looks like the SMSC is doing fancy stuff with their DLR's.
 
  If that's the case, there's no easy fix, it's either asking your SMSC
  to change it (probably unlikely) or tweaking the code to ignore those
  two digits before the first /.
 
  Regards,
 
  Alex
 
  On Thu, Feb 17, 2011 at 10:30 AM, Kyriacos Sakkas
  kyria...@netsmart.com.cy mailto:kyria...@netsmart.com.cy wrote:
 
  Hi,
 
  Wondering if anyone can help with this.
  When I submit an sms I get the following ID in the submit_sm_resp:
  *01*//415ce0ae676d19fc/1231615516543
 
  When the message is delivered I get the following id in the
  deliver_sm:
  *04*/415ce0ae676d19fc/1231615516543
 
  As you can see those two numbers are not the same, leading to the
  query not matching.
 
  Any help will be greatly appreciated, I can provide further info
  if needed.
 
  Regards,
  Kyriacos Sakkas
 
  -- Kyriacos Sakkas
  Development Team
  Netsmart
  Tel: + 357 22 452565
  Fax: + 357 22 452566
  Email: kyria...@netsmart.com.cy mailto:kyria...@netsmart.com.cy
  http://www.netsmart.com.cy
 
  Taking Business to a New Level!
 
  ** Confidentiality Notice: The information contained in this email
  message may be privileged, confidential and protected from
  disclosure.
  If you are not the intended recipient, any dissemination,
  distribution,
  or copying of this  email message is strictly prohibited.
  If you think that you have received this email message in error,
  please
  email the sender at kyria...@netsmart.com.cy

Re: Odd DLR msg ID from operator

2011-02-18 Thread Alejandro Guerrieri

There might be a reason (or not) for them to do that kind of stuff, but I've
learned that your chances of getting them to change it are quite slim.

Even if they're willing to do it, rolling out that kind of infrastructure
change on a carrier-grade network would mean months of testing and
coordination.

I've tried, it's a waste of time ;)

Regards,

Alex

2011/2/18 Nikos Balkanas nbalka...@gmail.com

 Hi,


  So yep if someone things that this can be done with pure MYSQL triggers
 or something like that, which does not need heavy kannel changes, please
 let me know.


 It is a very light kannel change in gw/dlr_mysql.c, since you know the
 smsc-id, but even at that you branch off and in the future you will have to
 merge in any dlr_mysql.c changes. Why don't they change it? How can they be
 a big name operator and screw up DLRs for all their clients?

 BR,
 Nikos

 - Original Message - From: Kyriacos Sakkas 
 kyria...@netsmart.com.cy
 To: Nikos Balkanas nbalka...@gmail.com
 Cc: Alan McNatty a...@catalyst.net.nz; Alejandro Guerrieri 
 alejandro.guerri...@gmail.com; users us...@vm1.kannel.org; Kyriacos
 Sakkas kyria...@netsmart.com.cy
 Sent: Friday, February 18, 2011 11:35 AM

 Subject: Re: Odd DLR msg ID from operator


  Hi All,

 This is definitely an SMPP connection, whether it actually it is SMPP,
 thats a different story :).

 I have already asked the relevant (big name) operator whether this is
 something they can change. To give you the full story we have multiple
 binds with this operator, each bind used to bill (MT billing) a
 different amount. Now the first issue I noticed is that no matter what
 bind you sent from, the DLR comes from the 0 rated bind. After asking
 them about this they replied that yes that's just how it is, so I edited
 the source files and chhanged the mysql dlr functions to handle this,
 while not breaking any other connections I have - I made the smsc field
 length=12 (any longer smsc-id names get truncated to 12 chars on insert)
 , put smsc=LEFT(?,12) in the queries to match the longer smsc-id s I use
 for this operator (which have to be unique in order for me to be able to
 specify which one the message goes out from).

 So that was fixed.. after fixing that I noticed that DLRs were not
 matching again, and spotted that they are changing the ID string along
 the way.

 So I can solve this by doing something similar to the above, chopping
 the first 2 chars in the mysql queries, but this one will not be easy to
 do and retain compatibility with the rest of the normally behaving binds
 to other operator that I have. Running a dedicated server for this guys
 is an option, I would just rather not if I can. I guess I could set a
 conf parameter that passes a flag to the dlr functions that tels them to
 change queries (like how MSISDNs are added to queries for EMI/UCP 
 SMPP) but that would just seriously brake my upstream compatibility,
 plus my programing skill are probably not up to it.

 So yep if someone things that this can be done with pure MYSQL triggers
 or something like that, which does not need heavy kannel changes, please
 let me know.

 Thanks,
 Kyriacos Sakkas

 On 18/02/2011 07:50, Nikos Balkanas wrote:

 Hi,

 I was asking for the raw logs, to verify that is indeed SMPP traffic,
 as stated from the PDU names. If it is, then it seems contrary to the
 spec. He could try talking to his SMSc about it.

 BR,
 Nikos
 - Original Message - From: Alan McNatty a...@catalyst.net.nz
 To: Alejandro Guerrieri alejandro.guerri...@gmail.com
 Cc: users users@kannel.org
 Sent: Thursday, February 17, 2011 11:36 PM
 Subject: Re: Odd DLR msg ID from operator


  Hi Alex,

 I wonder (just off the top of my head) .. if using DB DLR with stored
 procedure / trigger could work by stripping the prefix on insert?

 Just a random idea that could be worth looking into - possible/obvious
 performance implication.

 Cheers,
 Alan


 On 18/02/11 10:26, Alejandro Guerrieri wrote:

 Looks like the SMSC is doing fancy stuff with their DLR's.

 If that's the case, there's no easy fix, it's either asking your SMSC
 to change it (probably unlikely) or tweaking the code to ignore those
 two digits before the first /.

 Regards,

 Alex

 On Thu, Feb 17, 2011 at 10:30 AM, Kyriacos Sakkas
 kyria...@netsmart.com.cy mailto:kyria...@netsmart.com.cy wrote:

Hi,

Wondering if anyone can help with this.
When I submit an sms I get the following ID in the submit_sm_resp:
*01*//415ce0ae676d19fc/1231615516543

When the message is delivered I get the following id in the
deliver_sm:
*04*/415ce0ae676d19fc/1231615516543

As you can see those two numbers are not the same, leading to the
query not matching.

Any help will be greatly appreciated, I can provide further info
if needed.

Regards,
Kyriacos Sakkas

-- Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax

Re: Odd DLR msg ID from operator

2011-02-18 Thread Alejandro Guerrieri

This is what the spec says (Appendix B):

   SMPP provides for return of an SMSC delivery receipt via the *deliver_sm
*or *data_sm *PDU, which indicates the delivery status of the message.

The informational content of an SMSC Delivery Receipt may be inserted into
the *short_message *parameter of the *deliver_sm *operation. The format for
this Delivery Receipt message is SMSC vendor specific but following is a
typical example of Delivery Receipt report.

“*id:II sub:SSS dlvrd:DDD submit date:YYMMDDhhmm done
date:YYMMDDhhmm stat:DDD err:E Text: . . . . . . . . .”*

The fields of the above delivery receipt example are explained in the
following table:

[table explaining the parameters from the example]

There's no reference to unique id's and it says The format for this
Delivery Receipt message is SMSC vendor specific.

In other words, the SMSC vendor could use whatever they fit convenient and
it wouldn't be breaking the spec at all.

Nonsense, I know, sadly the SMSC Developers Forum was disbanded in 2007 so
there's nowhere to go and propose a spec review,I guess.

Regards,

Alex




2011/2/18 Nikos Balkanas nbalka...@gmail.com

 Yes, I've seen this kind of mess many times before... and shockingly it's
 not contrary to the spec.


 But it is contrary to the spec. Although DLR format may be blurry, a
 unique ID is required and it should be the same in submit_sm_resp and
 deliver_sm (hex conversion notwithstanding).

 BR,
 Nikos
 - Original Message - From: Alejandro Guerrieri
 To: Kyriacos Sakkas
 Cc: Nikos Balkanas ; Alan McNatty ; users
 Sent: Friday, February 18, 2011 12:47 PM

 Subject: Re: Odd DLR msg ID from operator


 Yes, I've seen this kind of mess many times before... and shockingly it's
 not contrary to the spec.


 The spec is really blurry on DLR's, it only provides an example of what a
 DLR would look like, but it doesn't enforce any particular format.


 Kannel only accept a couple of the more popular formats, but definitely
 needs help dealing with non-standard formats, specially when the id's
 doesn't even match.


 Perhaps a simpler approach would have been to regex-match for ^\d{2}\/
 and remove it if present?


 Regards,


 Alex


 2011/2/18 Kyriacos Sakkas kyria...@netsmart.com.cy

 Hi All,

 This is definitely an SMPP connection, whether it actually it is SMPP,
 thats a different story :).

 I have already asked the relevant (big name) operator whether this is
 something they can change. To give you the full story we have multiple
 binds with this operator, each bind used to bill (MT billing) a
 different amount. Now the first issue I noticed is that no matter what
 bind you sent from, the DLR comes from the 0 rated bind. After asking
 them about this they replied that yes that's just how it is, so I edited
 the source files and chhanged the mysql dlr functions to handle this,
 while not breaking any other connections I have - I made the smsc field
 length=12 (any longer smsc-id names get truncated to 12 chars on insert)
 , put smsc=LEFT(?,12) in the queries to match the longer smsc-id s I use
 for this operator (which have to be unique in order for me to be able to
 specify which one the message goes out from).

 So that was fixed.. after fixing that I noticed that DLRs were not
 matching again, and spotted that they are changing the ID string along
 the way.

 So I can solve this by doing something similar to the above, chopping
 the first 2 chars in the mysql queries, but this one will not be easy to
 do and retain compatibility with the rest of the normally behaving binds
 to other operator that I have. Running a dedicated server for this guys
 is an option, I would just rather not if I can. I guess I could set a
 conf parameter that passes a flag to the dlr functions that tels them to
 change queries (like how MSISDNs are added to queries for EMI/UCP 
 SMPP) but that would just seriously brake my upstream compatibility,
 plus my programing skill are probably not up to it.

 So yep if someone things that this can be done with pure MYSQL triggers
 or something like that, which does not need heavy kannel changes, please
 let me know.

 Thanks,
 Kyriacos Sakkas


 On 18/02/2011 07:50, Nikos Balkanas wrote:

 Hi,

 I was asking for the raw logs, to verify that is indeed SMPP traffic,
 as stated from the PDU names. If it is, then it seems contrary to the
 spec. He could try talking to his SMSc about it.

 BR,
 Nikos
 - Original Message - From: Alan McNatty a...@catalyst.net.nz
 To: Alejandro Guerrieri alejandro.guerri...@gmail.com
 Cc: users users@kannel.org
 Sent: Thursday, February 17, 2011 11:36 PM
 Subject: Re: Odd DLR msg ID from operator


  Hi Alex,

 I wonder (just off the top of my head) .. if using DB DLR with stored
 procedure / trigger could work by stripping the prefix on insert?

 Just a random idea that could be worth looking into - possible/obvious
 performance implication.

 Cheers,
 Alan


 On 18/02/11 10:26, Alejandro Guerrieri wrote

Re: Odd DLR msg ID from operator

2011-02-17 Thread Alejandro Guerrieri

Looks like the SMSC is doing fancy stuff with their DLR's.

If that's the case, there's no easy fix, it's either asking your SMSC to
change it (probably unlikely) or tweaking the code to ignore those two
digits before the first /.

Regards,

Alex

On Thu, Feb 17, 2011 at 10:30 AM, Kyriacos Sakkas
kyria...@netsmart.com.cywrote:

  Hi,

 Wondering if anyone can help with this.
 When I submit an sms I get the following ID in the submit_sm_resp:
 *01*//415ce0ae676d19fc/1231615516543

 When the message is delivered I get the following id in the deliver_sm:
 *04*/415ce0ae676d19fc/1231615516543

 As you can see those two numbers are not the same, leading to the query not
 matching.

 Any help will be greatly appreciated, I can provide further info if needed.

 Regards,
 Kyriacos Sakkas

 --
 Kyriacos Sakkas
 Development Team
 Netsmart
 Tel: + 357 22 452565
 Fax: + 357 22 452566
 Email: kyria...@netsmart.com.cyhttp://www.netsmart.com.cy

 Taking Business to a New Level!

 ** Confidentiality Notice: The information contained in this email
 message may be privileged, confidential and protected from disclosure.
 If you are not the intended recipient, any dissemination, distribution,
 or copying of this  email message is strictly prohibited.
 If you think that you have received this email message in error, please
 email the sender at kyria...@netsmart.com.cy **

Re: DLR Concurrency Problem (got DLR but could not find message or was not interested in it)

2011-02-09 Thread Alejandro Guerrieri

It's not a concurrency bug, your aggregator is probably sending the DLR's
deliver_sm before sending the submit_sm_resp.

I've seen it happening on some aggregators (maybe because of their
load-balancers processing the messages on different nodes? Can't tell for
sure).

I have a simple patch that retries the dlr-find a given number of times, but
it poses a performance penalty and it's not intended to be used under heavy
traffic.

Regards,

Alex

On Wed, Feb 9, 2011 at 9:35 AM, Sayed Hadi Rastgou Haghi 
hadi.rast...@gmail.com wrote:

 Dear Kannel Developers,

 I found a concurrency BUG in DLR Code.


 2011-02-09 11:30:26 [29361] [27] DEBUG: DLR[mysql]: Looking for DLR
 smsc=mtn1, ts=1613732592, dst=989372474050, type=2
 2011-02-09 11:30:26 [29361] [27] DEBUG: sql: SELECT mask, service, url,
 source, destination, boxc FROM dlr WHERE smsc='SMSC' AND ts='1613732592';
 2011-02-09 11:30:26 [29361] [27] ERROR: SMPP[SMSC]: got DLR but could not
 find message or was not interested in it id1613732592 dstDST, type2
 2011-02-09 11:30:26 [29361] [26] DEBUG: DLR[mysql]: Adding DLR smsc=SMSC,
 ts=1613732592, src=SRC, dst=DST, mask=31, boxc=13013
 2011-02-09 11:30:26 [29361] [26] DEBUG: sql: INSERT INTO dlr (smsc, ts,
 source, destination, service, url, mask, boxc, status) VALUES (...);

 *dlr_find* method got calls before *dlr_add!*

 --
 Sincerely,

 Sayed Hadi Rastgou Haghi

Re: Kannel timer parameters

2011-02-08 Thread Alejandro Guerrieri

No, that's most probably your VPN renegotiating keys at the wrong time...

Regards,

Alex

On Tue, Feb 8, 2011 at 7:37 PM, ha...@aeon.pk ha...@aeon.pk wrote:

 Hi,

 I am running kannel v1.4.3 on a CENTOS installation, connected to operator
 SMSC over VPN. There are at least 30 SMSC connections in total. The problem
 is that all SMSC connections are reset in connectivity after every 3 or 4
 hours. They get into the state RECONNECTING for at least a minute and then
 get connected (ONLINE) again. Initially I thought there is something wrong
 with my VPN or it gets reset after every 3 or 4 hours. I spent a lot of time
 on troubleshooting it but discovered that VPN stays alive all the time.
 There is some timing parameter in kannel which is not working properly. In
 my configuration, I can observe following parameter related to some timeout
 value:

 enquire-link-interval = 60
 #wait-ack = 60
 #wait-ack-expire = 0x00

 Is there a way to fix this disconnectivity issue?

 Regards,
 Hamza

Re: SQLBox make error

2011-02-06 Thread Alejandro Guerrieri

You're trying to compile sqlbox using an incompatible version of kannel. You 
need to compile against a meta-data aware version (latest svn for instance).

Regards,
--
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@localhost sqlbox]# make
 make  all-recursive
 make[1]: Entering directory `/root/Downloads/sqlbox'
 Making all in gw
 make[2]: Entering directory `/root/Downloads/sqlbox/gw'
 gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES= -I/usr/include/libxml2 
 -I/usr/local/pgsql/include -MT sqlbox.o -MD -MP -MF .deps/sqlbox.Tpo -c -o 
 sqlbox.o sqlbox.c
 mv -f .deps/sqlbox.Tpo .deps/sqlbox.Po
 gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES= -I/usr/include/libxml2 
 -I/usr/local/pgsql/include -MT sqlbox_mssql.o -MD -MP -MF 
 .deps/sqlbox_mssql.Tpo -c -o sqlbox_mssql.o sqlbox_mssql.c
 mv -f .deps/sqlbox_mssql.Tpo .deps/sqlbox_mssql.Po
 gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES= -I/usr/include/libxml2 
 -I/usr/local/pgsql/include -MT sqlbox_mysql.o -MD -MP -MF 
 .deps/sqlbox_mysql.Tpo -c -o sqlbox_mysql.o sqlbox_mysql.c
 mv -f .deps/sqlbox_mysql.Tpo .deps/sqlbox_mysql.Po
 gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw-g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES= -I/usr/include/libxml2 
 -I/usr/local/pgsql/include -MT sqlbox_pgsql.o -MD -MP -MF 
 .deps/sqlbox_pgsql.Tpo -c -o sqlbox_pgsql.o sqlbox_pgsql.c
 sqlbox_pgsql.c: In function ‘pgsql_save_msg’:
 sqlbox_pgsql.c:153: error: ‘struct sms’ has no member named ‘meta_data’
 sqlbox_pgsql.c: In function ‘pgsql_fetch_msg’:
 sqlbox_pgsql.c:211: error: ‘struct sms’ has no member named ‘meta_data’
 make[2]: *** [sqlbox_pgsql.o] Error 1
 make[2]: Leaving directory `/root/Downloads/sqlbox/gw'
 make[1]: *** [all-recursive] Error 1
 make[1]: Leaving directory `/root/Downloads/sqlbox'
 make: *** [all] Error 2

Re: SQLBox make error

2011-02-06 Thread Alejandro Guerrieri

I'm glad it helped :)

Regards,

Alex

On Sunday, February 6, 2011, Scott Geller geller.subscr...@gmail.com wrote:
 Thanks Aliex.!!
 That fixed it

 On Sun, Feb 6, 2011 at 6:18 AM, Alejandro Guerrieri 
 alejandro.guerri...@gmail.com wrote:
 You're trying to compile sqlbox using an incompatible version of kannel. You 
 need to compile against a meta-data aware version (latest svn for instance).

 Regards,
 --
 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@localhost sqlbox]# make
 make  all-recursive
 make[1]: Entering directory `/root/Downloads/sqlbox'
 Making all in gw
 make[2]: Entering directory `/root/Downloads/sqlbox/gw'
 gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw    -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES= -I/usr/include/libxml2 
 -I/usr/local/pgsql/include -MT sqlbox.o -MD -MP -MF .deps/sqlbox.Tpo -c -o 
 sqlbox.o sqlbox.c
 mv -f .deps/sqlbox.Tpo .deps/sqlbox.Po
 gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw    -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES= -I/usr/include/libxml2 
 -I/usr/local/pgsql/include -MT sqlbox_mssql.o -MD -MP -MF 
 .deps/sqlbox_mssql.Tpo -c -o sqlbox_mssql.o sqlbox_mssql.c
 mv -f .deps/sqlbox_mssql.Tpo .deps/sqlbox_mssql.Po
 gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw    -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES= -I/usr/include/libxml2 
 -I/usr/local/pgsql/include -MT sqlbox_mysql.o -MD -MP -MF 
 .deps/sqlbox_mysql.Tpo -c -o sqlbox_mysql.o sqlbox_mysql.c
 mv -f .deps/sqlbox_mysql.Tpo .deps/sqlbox_mysql.Po
 gcc -DHAVE_CONFIG_H -I. -I.. -I../gw -I../gw    -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -I/usr/local/include/kannel -g -O2 -D_XOPEN_SOURCE=600 
 -D_BSD_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES= -I/usr/include/libxml2 
 -I/usr/local/pgsql/include -MT sqlbox_pgsql.o -MD -MP -MF 
 .deps/sqlbox_pgsql.Tpo -c -o sqlbox_pgsql.o sqlbox_pgsql.c
 sqlbox_pgsql.c: In function ‘pgsql_save_msg’:
 sqlbox_pgsql.c:153: error: ‘struct sms’ has no member named ‘meta_data’
 sqlbox_pgsql.c: In function ‘pgsql_fetch_msg’:
 sqlbox_pgsql.c:211: error: ‘struct sms’ has no member named ‘meta_data’
 make[2]: *** [sqlbox_pgsql.o] Error 1
 make[2]: Leaving directory `/root/Downloads/sqlbox/gw'
 make[1]: *** [all-recursive] Error 1
 make[1]: Leaving directory `/root/Downloads/sqlbox'
 make: *** [all] Error 2

Re: Problem with syslog (ERRATA)

2011-02-01 Thread Alejandro Guerrieri

Andrea,

Syslog only works for core logs, not the access logs so far.

Regards,

Alex

On Tue, Feb 1, 2011 at 8:00 PM, Andrea Gabellini 
andrea.gabell...@telecomitalia.sm wrote:

 Hello,

 I made a stupid mistake. Now I set syslog-level to 0 and not 7 and now I
 see syslog logging!!!

 What I need are the access-log items, but I don't see anythink of it.

 Is it not implemented or I made another mistake?

 Thanks,
 Andrea



 Il 01/02/2011 19:49, Andrea Gabellini ha scritto:
  Hello,
 
  I compiled and installed the development 1.5.0 version and I have a
  configuration that works perfectly.
 
  Now I need to configure syslog logging for bearerbox and smsbox, so I
  compiled the last svn version ( r4879 ).
 
  syslog is configured to log the daemon facility to /var/log/messages
 
  in the core and smsbox group I defined syslog-level = 7
 
  nothing is logged to syslog. I tried to modify syslog-level to debug,
  LOG_DEBUG without luck
 
  I tried also to change the syslog-facility to mail and LOG_MAIL (that
  logs to /var/log/maillog), but nothing!
 
  I think I miss something...
 
  Can you help me? this in the kannel config:
 
  group = core
  admin-port = 13000
  admin-password = x
  status-password = x
  admin-deny-ip = *.*.*.*
  admin-allow-ip = 1.2.3.4
  smsbox-port = 13001
  box-deny-ip = *.*.*.*
  box-allow-ip = 127.0.0.1
  udp-deny-ip = *.*.*.*
  udp-allow-ip = 127.0.0.1
  syslog-level = 7
  log-file = /var/log/kannel/bearerbox.log
  log-level = 0
  access-log = /var/log/kannel/bearerbox_access.log
  access-log-clean = true
  access-log-format = %t %l [SMSC:%i] [SVC:%n] [ACT:%A] [BINFO:%B]
  [FID:%F] [UUID:%I] [META:%D] [from:%p] [to:%P] [flags:%m:%c:%M:%C]
  [DLRMASK=%d] [DLRURL: %R] [msg:%L:%b] [udh:%U:%u]
  store-type = spool
  store-location = /var/spool/kannel
  sms-resend-retry = 120
  dlr-storage = mysql
 
  group = smsc
  smsc = fake
  smsc-id = FAKE
  port = 1
  unified-prefix = +39,39;+,00
  log-level = 1
 
  group = smsbox
  bearerbox-host = localhost
  bearerbox-port = 13001
  sendsms-port = 13013
  log-file = /var/log/kannel/smsbox.log
  log-level = 0
  access-log = /var/log/kannel/smsbox_access.log
  syslog-level = 7
 
  include = /usr/local/etc/kannel-mysql.conf
 
  include = /usr/local/etc/kannel-smsservices.conf
 
  include = /usr/local/etc/kannel-smsusers.conf
 
  Thanks in advance,
  Andrea
 
 
 

 --

 
 No matter how fast your computer system runs, you will eventually come to
 think of it as slow.
 

 Ing. Andrea Gabellini
 Email: andrea.gabell...@telecomitalia.sm
 Skype: andreagabellini
 Tel: (+378) 0549 886111
 Fax: (+378) 0549 886188

 Telecom Italia San Marino S.p.A.
 Strada degli Angariari, 3
 47891 Rovereta
 Republic of San Marino

 http://www.telecomitalia.sm

Re: How to set more than one metadata in the http request

2011-01-21 Thread Alejandro Guerrieri

You're using %3F to separate them, which is ? where you should use .
Your meta-data decodes as:

   ?smpp?session_info=00?service_op=2


Where it should be:


?smpp?session_info=00service_op=2

Which is encoded as:

   %3Fsmpp%3Fsession_info%3D00%26service_op%3D2


Hope it helps,


Alex
On Fri, Jan 21, 2011 at 11:18 AM, Kanchan K kathuria.kanc...@gmail.comwrote:

 I have to set ussd_service_op and its_session_info.Defined both in the
 config file.Sending the request as


 http://192.168.0.4:13013/cgi-bin/sendsms?to=2724from=text=testingusername=testerpassword=foobarmeta-data=%3Fsmpp%3Fsession_info%3D00%3Fservice_op%3D2

 If i give either of the TLV (either session_info or service_op) i am
 getting it correct.Also in the above request only the first TLV is set
 corerctly and the second one is being ignored.

 My question is -how do i make both of them work?


 On Fri, Jan 21, 2011 at 3:41 PM, Alejandro Guerrieri 
 alejandro.guerri...@gmail.com wrote:

 Please ellaborate? Attach logs, examples, etc.

 Regards,

 Alex


 On Fri, Jan 21, 2011 at 8:40 AM, Kanchan K kathuria.kanc...@gmail.comwrote:

 Hi,
 i need to set 2 optional paramanters in the send sms http request.Can
 anybody suggest how to set the same in the url?
 I have tried few combinations but only one is recognized and the other is
 being ignored or both of them are not recognized.

 Thanks in advance

Re: submit_sm_resp id and status

2011-01-19 Thread Alejandro Guerrieri

Command status, it's not available directly, but it'll affect the DLR
outcome (if it's not 0, it's an error and you'll get a NACK instead of an
ACK). On the SVN code you get the smpp dlr_err optional parameter as well.

message_id, it's the %F foreign_id parameter.

Regards,

Alex

On Wed, Jan 19, 2011 at 7:47 PM, Santiago Cattaneo santia...@gmail.comwrote:

 Hello, I'm trying to obtain from submit_sm_resp the highlighted data from C
 code of gwlib.

 command_id: 2147483652 = 0x8004
 command_status: 0 = 0x
 sequence_number: 7 = 0x0007
 message_id: 2B23AF36

 I know that exist the Msg structure, but I could't find on the web the
 field names for that, I found the Msg-sms structure with this information:

 MSG(sms,
 {
 OCTSTR(sender)
 OCTSTR(receiver)
 OCTSTR(udhdata)
 OCTSTR(msgdata)
 INTEGER(time)
 OCTSTR(smsc_id)
 OCTSTR(smsc_number)
 OCTSTR(foreign_id)
 OCTSTR(service)
 OCTSTR(account)
 UUID(id)
 INTEGER(sms_type)
 INTEGER(mclass)
 INTEGER(mwi)
 INTEGER(coding)
 INTEGER(compress)
 INTEGER(validity)
 INTEGER(deferred)
 INTEGER(dlr_mask)
 OCTSTR(dlr_url)
 INTEGER(pid)
 INTEGER(alt_dcs)
 INTEGER(rpi)
 OCTSTR(charset)
 OCTSTR(boxc_id)
 OCTSTR(binfo)
 INTEGER(msg_left)
 VOID(split_parts)
 INTEGER(priority)
 INTEGER(resend_try)
 INTEGER(resend_time)
 OCTSTR(meta_data)
 })

 I have to use dlr_mask??? Any Idea?

 Thanks a lot.

Re: Why does Kannel not use sar_total_segments and sar_segment_seqnum when sending concatenated sms?

2011-01-18 Thread Alejandro Guerrieri

It's not implemented afaik. Only the UDH method is supported.

Regards,

Alex

On Tue, Jan 18, 2011 at 10:47 AM, brett skinner
tatty.dishcl...@gmail.comwrote:

 Hi guys.

 Does anyone have an ideas to my question below?

 Thanks,


 On Thu, Jan 13, 2011 at 11:35 AM, brett skinner tatty.dishcl...@gmail.com
  wrote:

 Hi

 I was looking through the logs and saw that Kannel sends concatenated SMSs
 using UDH in the Short Message fields. From reading the SMPP spec I was
 under the impression that the same thing could be achieved by using
 sar_total_segments and sar_segment_seqnum. Did I misinterpret the spec or
 does Kannel not use these fields for another reason such as
 unreliable implementation on the receiving SMSC.

 Regards,

Re: Why does Kannel not use sar_total_segments and sar_segment_seqnum when sending concatenated sms?

2011-01-18 Thread Alejandro Guerrieri

It means that Kannel doesn't have the ability to re-assemble messages using
the sar method. I'm not sure about how extensively used is this method among
the carriers, I so far only encountered one case.

Regards,

Alex

On Tue, Jan 18, 2011 at 11:08 AM, brett skinner
tatty.dishcl...@gmail.comwrote:

 Do you mean as far as Kannel is concerned or that most SMSC don't use this
 method?
 So I did understand the spec correctly. It is just that everyone chooses to
 use the UDH method rather?

 On Tue, Jan 18, 2011 at 11:51 AM, Alejandro Guerrieri 
 alejandro.guerri...@gmail.com wrote:

 It's not implemented afaik. Only the UDH method is supported.

 Regards,

 Alex


 On Tue, Jan 18, 2011 at 10:47 AM, brett skinner 
 tatty.dishcl...@gmail.com wrote:

 Hi guys.

 Does anyone have an ideas to my question below?

 Thanks,


 On Thu, Jan 13, 2011 at 11:35 AM, brett skinner 
 tatty.dishcl...@gmail.com wrote:

 Hi

 I was looking through the logs and saw that Kannel sends concatenated
 SMSs using UDH in the Short Message fields. From reading the SMPP spec I 
 was
 under the impression that the same thing could be achieved by using
 sar_total_segments and sar_segment_seqnum. Did I misinterpret the spec or
 does Kannel not use these fields for another reason such as
 unreliable implementation on the receiving SMSC.

 Regards,

Re: [SOLVED] Change the log level of an smpp smsc group

2011-01-13 Thread Alejandro Guerrieri

loglevel: Set Kannel log-level of log-files while running. This allows you
to change the current log-level of the log-files on the fly.

Looks perfectly clear to me...

Regards,

Alex
On Thu, Jan 13, 2011 at 12:15 PM, Tshimanga Minkoka 
tshimanga.mink...@vodacom.cd wrote:

 Hi All,



 I confirm that the log-level http command resets the log level of all log
 files defined in the configuration, without restarting anything.

 That is exactly what I want.



 Unfortunately, the UG is not very specific on that.



 Thanks a lot for your help.



 *TSHIMANGA Minkoka*

 *VAS Manager*

 *È** **+243 814443113*

 *(** **+* *243 815560341 ext. 0583*

 *2**  **+243 813010373*

 *: **tshimanga.mink...@vodacom.cd*



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Thursday 13 January 2011 08:31
 *To:* Tshimanga Minkoka
 *Cc:* Rapture; users@kannel.org
 *Subject:* Re: Change the log level of an smpp smsc group



 The stop-smsc and start-smsc can be performed without restarting kannel, it
 will only reconnect the given smsc.



 Regards,

 --

 Alex Guerrieri


 On 13/01/2011, at 07:58, Tshimanga Minkoka tshimanga.mink...@vodacom.cd
 wrote:

 Hi Rapture,



 Sorry I had to specify that I needed it on the fly, without restarting
 kannel.



 Alex have answered specifying that the http command changes all the log
 levels (SMSCs included).



 I will give it a try, and feedback.



 Thanks to all.



 *TSHIMANGA Minkoka*

 *VAS Manager*

 *È** **+243 814443113*

 *(** **+* *243 815560341 ext. 0583*

 *2**  **+243 813010373*

 *: **tshimanga.mink...@vodacom.cd*

 image001.jpg



 *From:* Rapture [mailto:supp...@ims.co.ke]
 *Sent:* Wednesday 12 January 2011 17:25
 *To:* Tshimanga Minkoka; users@kannel.org
 *Subject:* RE: Change the log level of an smpp smsc group



 Hi,



 You need to modify the variable log-level in the group smsc and set it to
 the desired level. This you do per smcs

 Check user guide:



 log-level number 0..5

 Minimum level of log-file events logged. 0 is for ’debug’, 1 ’info’,2
 ’warning, 3 ’error’ and 4’panic’



 *From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On
 Behalf Of *Tshimanga Minkoka
 *Sent:* Wednesday, January 12, 2011 7:16 PM
 *To:* users@kannel.org
 *Subject:* Change the log level of an smpp smsc group



 Dear,



 How can I change the log level of an smpp smsc group?

 The HTTP administration command loglevel seems to only act on bearbox
 logging.

 Do I need to modify the configuration file, stop the smsc and then restart
 it?



 TIA.



 *TSHIMANGA Minkoka*

 *VAS Manager*

 *È** **+243 814443113*

 *(** **+* *243 815560341 ext. 0583*

 *2**  **+243 813010373*

 *: **tshimanga.mink...@vodacom.cd*

 image004.jpg

Re: mobile bookmarks and vcal message

Vijay,

Kannel could be used to send all kinds of OTA messages supported by the
receiver's phone, including ringtones, vcal, pictures, etc. There's actually
some examples on the contrib folder (on the source code).

Regarding the question about the folder/bookmark, it's not something related
to Kannel, you'll probably have to ask someplace else about that protocol's
capabilities. I don't believe you'd be able to modify the phone's filesystem
from an SMS (it would pose all sorts of security risks) but I'm just
guessing...

Regards,

Alex

On Tue, Jan 11, 2011 at 11:35 AM, Vijay Shanker Dubey
vijay.s...@gmail.comwrote:

 Hello friends,

 I have few questions about the capabilities of kannel.
 1. Can it help me sending to mobile bookmark with full path - e.g.
 including nonexisting folder, in other words: is it possible to create
 folder while sending bookmark to mobile ?
 2. sending vCal.

 Please give me some pointer to investigate my options.


 Regards,
 Vijay Shanker Dubey

Re: Kannel with SQL-Server SMS Spool

Santiago,

You'd need to modify sqlbox's queries to call stored procedures instead.
They're defined on macros on sqlbox_mssql.h

You'll probably need to tweak the code for the responses to match what your
stored procedure returns.

Hope it helps.

Alejandro

On Wed, Jan 12, 2011 at 4:37 PM, Santiago Cattaneo santia...@gmail.comwrote:

 Hello all, I new to Kannel and I'm trying to set it up on this way:

1. Connect to several SMPP gateways (no problem)
2. Insert MT and MO messages on a SQL-Server Spool Database
(problem!!!)

 I tried SQLBOX and it works very well, but, I need to use a Stored
 Procedure interface to access to the SQL-Server. (One SP for SELECT MT, one
 for UPDATE MT sent and one for INSERT MO).

 I wondering if it is possible to do that, I think maybe could use
 sms-service like this for INSERT MO:

 group = sms-service
 keyword = nop
 get-url = http://host/service?sender=%ptext=%r;

 But how to tell Kannel to read and update MTs?

 Thanks in advance

Re: Change the log level of an smpp smsc group

log-level works for the smsc's as well (it changes _all_ log levels at
once).

If you need to change a single smsc instance, you need to change the conf
and restart it.

Regards,

Alex

On Wed, Jan 12, 2011 at 5:16 PM, Tshimanga Minkoka 
tshimanga.mink...@vodacom.cd wrote:

 Dear,



 How can I change the log level of an smpp smsc group?

 The HTTP administration command loglevel seems to only act on bearbox
 logging.

 Do I need to modify the configuration file, stop the smsc and then restart
 it?



 TIA.



 *TSHIMANGA Minkoka*

 *VAS Manager*

 *È** **+243 814443113*

 *(** **+* *243 815560341 ext. 0583*

 *2**  **+243 813010373*

 *: **tshimanga.mink...@vodacom.cd*

Re: send cgi - Unknown request

You changed the sensms-url to be /sendsms, not /cgi-bin/sendsms...

Hope it helps.
--
Alex Guerrieri

On 12/01/2011, at 21:01, Daniel Camacho dcama...@promocionesacertadas.com 
wrote:

 Hi there,
 
 I have never used the http interface for sending sms, since I have
 installed the mysql box.
 
 From my browser Im trying to send some sms, with no Sent result, just the
 Unknown request.
 
 The log(0) says:
 
 2011-01-12 14:21:07 [3261] [2] DEBUG: HTTP: Creating HTTPClient for
 `10.27.1.226'.
 2011-01-12 14:21:07 [3261] [2] DEBUG: HTTP: Created HTTPClient area
 0x2c000b60.
 2011-01-12 14:21:07 [3261] [3] INFO: smsbox: Got HTTP request
 /cgi-bin/sendsms from 10.27.1.226
 2011-01-12 14:21:07 [3261] [3] DEBUG: Status: 404 Answer: Unknown request.
 2011-01-12 14:21:07 [3261] [3] DEBUG: HTTP: Resetting HTTPClient for
 `10.27.1.226'.
 
 I have various sms-service groups defined on the smsbox within two or
 three smsc.
 
 This is the url I am trying to use:
 http://kannelServer:13200/cgi-bin/sendsms?from=senderNumberto=cellphonesmsc=xxuser=userX=pass=passXtext=hello
 
 as my configuration is:
 
 ***
 smsbox.conf
 ***
 group = smsbox
 smsbox-id = smsbox1
 bearerbox-host = localhost
 bearerbox-port = 13003
 sendsms-url= /sendsms
 sendsms-port= 13200
 reply-requestfailed = Send HELP
 reply-emptymessage = Not Available
 reply-couldnotfetch = Not Available
 log-file = /var/log/kannel/smsbox.log
 log-level = 0
 mo-recode = 1
 http-request-retry = 100
 http-queue-delay = 18
 
 group= sendsms-user
 username= userX
 password= passX
 concatenation = true
 max-messages = 8
 
 group = sms-service
 name = whatever
 keyword-regex = .*
 allowed-receiver-prefix = sender
 accepted-smsc = xx
 catch-all = true
 get-url = http://webApps:/somepage.php?src=%pmsg=%a
 omit-empty = true
 accept-x-kannel-headers = true
 max-messages = 3
 concatenation = true
 
 **
 kannel.conf
 **
 group = core
 admin-port = 13000
 #wapbox-port = 13002
 smsbox-port = 13001
 admin-password = bar
 wdp-interface-name = *
 log-file = /var/log/kannel/core.log
 log-level = 0
 box-deny-ip = *.*.*.*
 box-allow-ip = 127.0.0.1;10.27.1.*,130.7.*.*,10.10.10.*
 access-log = /var/log/kannel/access.log
 unified-prefix = +502,00502,0;+,00
 dlr-storage = internal
 store-type = file
 store-file = /var/log/kannel/sms-log3.log
 #store-dump-freq = 1
 #smsbox-max-pending = 1000
 sms-outgoing-queue-limit = -1
 sms-incoming-queue-limit = 1
 sms-resend-freq = 15
 sms-resend-retry = -1
 sms-combine-concatenated-mo = 1
 sms-combine-concatenated-mo-timeout = 150
 
 group = mysql-connection
 id = mydlr
 host = localhost
 username = kannel
 password = kannel321
 database = sms
 max-connections = 10
 
 group = dlr-db
 id = mydlr
 table = dlr
 field-smsc = smsc
 field-timestamp = ts
 field-destination = destination
 field-source = source
 field-service = service
 field-url = url
 field-mask = mask
 field-status = status
 field-boxc-id = boxc
 
 include = /etc/kannel/modems.conf
 include = /etc/kannel/smsbox.conf
 
 group = smsc
 smsc-id= xx
 smsc = smpp
 host=a.b.c.d
 port = 5000
 smsc-username= usr1
 smsc-password= pass1
 system-type= type1
 source-addr-ton= 0
 source-addr-npi= 0
 dest-addr-ton= 0
 dest-addr-npi= 0
 throughput = 10
 wait-ack-expire = 1
 transceiver-mode= false
 source-addr-autodetect = true
 receive-port = 0
 msg-id-type = 0x01
 allowed-smsc-id = xx
 denied-smsc-id = yy;zz
 alt-charset = ISO-8859-1
 enquire-link-interval = 10
 reconnect-delay = 60
 validityperiod = 1000
 
 group = smsc
 smsc-id= yy
 smsc = smpp
 host=a.b.c.d
 port = 5001
 smsc-username= usr2
 smsc-password= pass2
 system-type= type2
 source-addr-ton= 0
 source-addr-npi= 0
 dest-addr-ton= 0
 dest-addr-npi= 0
 throughput = 10
 wait-ack-expire = 1
 transceiver-mode= false
 source-addr-autodetect = true
 receive-port = 0
 msg-id-type = 0x01
 allowed-smsc-id = yy
 denied-smsc-id = xx;zz
 alt-charset = ISO-8859-1
 enquire-link-interval = 10
 reconnect-delay = 60
 validityperiod = 1000
 
 
 **
 am I missing something?
 
 -- 
 Gerdaniels
 
 
 
 -- 
 This message has been scanned for viruses and
 dangerous content by MailScanner, and is
 believed to be clean.

Re: Change the log level of an smpp smsc group

The stop-smsc and start-smsc can be performed without restarting kannel, it 
will only reconnect the given smsc.

Regards,

--
Alex Guerrieri

On 13/01/2011, at 07:58, Tshimanga Minkoka tshimanga.mink...@vodacom.cd wrote:

 Hi Rapture,
 
  
 
 Sorry I had to specify that I needed it on the fly, without restarting kannel.
 
  
 
 Alex have answered specifying that the http command changes all the log 
 levels (SMSCs included).
 
  
 
 I will give it a try, and feedback.
 
  
 
 Thanks to all.
 
  
 
 TSHIMANGA Minkoka
 VAS Manager
 
 È +243 814443113
 
 ( + 243 815560341 ext. 0583
 
 2  +243 813010373
 
 : tshimanga.mink...@vodacom.cd
 
 image001.jpg
 
  
 
 From: Rapture [mailto:supp...@ims.co.ke] 
 Sent: Wednesday 12 January 2011 17:25
 To: Tshimanga Minkoka; users@kannel.org
 Subject: RE: Change the log level of an smpp smsc group
 
  
 
 Hi,
 
  
 
 You need to modify the variable log-level in the group smsc and set it to the 
 desired level. This you do per smcs
 
 Check user guide:
 
  
 
 log-level number 0..5
 
 Minimum level of log-file events logged. 0 is for ’debug’, 1 ’info’,2 
 ’warning, 3 ’error’ and 4’panic’
 
  
 
 From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of 
 Tshimanga Minkoka
 Sent: Wednesday, January 12, 2011 7:16 PM
 To: users@kannel.org
 Subject: Change the log level of an smpp smsc group
 
  
 
 Dear,
 
  
 
 How can I change the log level of an smpp smsc group?
 
 The HTTP administration command loglevel seems to only act on bearbox logging.
 
 Do I need to modify the configuration file, stop the smsc and then restart it?
 
  
 
 TIA.
 
  
 
 TSHIMANGA Minkoka
 VAS Manager
 
 È +243 814443113
 
 ( + 243 815560341 ext. 0583
 
 2  +243 813010373
 
 : tshimanga.mink...@vodacom.cd
 
 image004.jpg

Re: DLR mysql not supported

2011-01-11 Thread Alejandro Guerrieri

You need the mysql-dev package, not just the client application. Depending
on your platform OS, it usuall involves installing an rpm or deb package.

Regards,

Alex

On Tue, Jan 11, 2011 at 10:00 AM, Atul Rastogi atulra...@gmail.com wrote:

 Hi
 Thanks for reply
 But I recompiled the gateway as per option mentioned by you

 in last line it gives Configure error Unable to find mysql client libraries



 whereas i have checked mysql is installed  and is working




 Pl suggest  what to do


 Thanks

 Atul


 On Mon, Jan 10, 2011 at 2:04 AM, Kiran Reddy ki...@uniceltech.com wrote:

 Hi,

 You didn't provide any error log any way.

 Did you compile kannel with mysql option.

 if not recompile again and try.

 ./configure --with-mysql



 On Sunday 09 January 2011 11:47 PM, Atul Rastogi wrote:

 I am running gateway150 with centos 5.5 in test setup

 while trying to setup for DLR storage
 I am getting message DLR storage type mysql not supported

 when running ./bearerbox -v 1 smskannel.conf

 file contains following and dlr-storage = mysql in core group

 group = mysql-connection
 id = mydlr
 host = localhost
 username = root
 database = dlr
 max-connections = 1

 group = dlr-db
 id = mydlr
 table = dlr
 field-smsc = smsc
 field-timestamp = ts
 field-destination = destination
 field-source = source
 field-url = url
 field-mask = mask
 field-status = status
 field-boxc-id = boxc



 Pl help


 Thanks
 Atul

Re: DLR mysql not supported

2011-01-11 Thread Alejandro Guerrieri

It should work perfectly fine with any mysql version, as long as you have
the proper packages and client libraries in place.

Regards,

Alex

On Tue, Jan 11, 2011 at 2:20 PM, Kazi M m.a.a.z.k.a@gmail.com wrote:


 Dear Atul ,

 if after installing the devel package ... the problems still persists then
 try downloading lower versions of mysql i m using 4.22



 Atul Rastogi wrote:
 
  I am running gateway150 with centos 5.5 in test setup
 
  while trying to setup for DLR storage
  I am getting message DLR storage type mysql not supported
 
  when running ./bearerbox -v 1 smskannel.conf
 
  file contains following and dlr-storage = mysql in core group
 
  group = mysql-connection
  id = mydlr
  host = localhost
  username = root
  database = dlr
  max-connections = 1
 
  group = dlr-db
  id = mydlr
  table = dlr
  field-smsc = smsc
  field-timestamp = ts
  field-destination = destination
  field-source = source
  field-url = url
  field-mask = mask
  field-status = status
  field-boxc-id = boxc
 
 
 
  Pl help
 
 
  Thanks
  Atul
 
 
 

 --
 View this message in context:
 http://old.nabble.com/DLR-mysql-not-supported-tp30628434p30643513.html
 Sent from the Kannel - User mailing list archive at Nabble.com.

Re: Kannel Config Help

2010-12-23 Thread Alejandro Guerrieri

Seems like if you're missing the smsbox-user group where you define the user
and password to use.

Read the user guide for more details.

Regards,

Alex

On Thu, Dec 23, 2010 at 1:27 PM, David Ige: Cellulant 
da...@cellulant.com.ng wrote:

 Hello,


 I have installed an Elite SMS Gateway software which also installed Kannel
 along with it on a centOS server.

 Each time i try to send SMS using the sendsms url it gives Authorization
 failed for sendsms.

 Below is my config,



 
 bearerbox.conf

 ---

 include=/opt/vsmsc/etc/kannel_include.conf

 group=vsmsc-config
 path=/opt/vsmsc/etc/vsmsc_bbox.conf

 group=rr-list
 id=rr-db
 table=users
 key-field=username
 value-field=throughput

 group=mysql-connection
 id=rr-db
 host=localhost
 username=xx
 password=x
 database=x
 max-connections=1

 --

 
 kannel_include.conf

 ---

 group = core
 admin-port = 13000
 smsbox-port = 13001
 admin-password = foobar
 #box-deny-ip = *.*.*.*
 #box-allow-ip = 127.0.0.1
 box-allow-ip = *.*.*.*
 log-file=/opt/vsmsc/logs/bearerbox.log
 log-level=0
 admin-deny-ip = *.*.*.*
 admin-allow-ip = 127.0.0.1


 group = mysql-connection
 id = kannel_dlr
 host = localhost
 username = xx
 password = xx
 database = xx
 max-connections = 5

 group = dlr-db
 id = kannel_dlr
 table = kannel_dlr
 field-smsc = smsc
 field-timestamp = ts
 field-destination = destination
 field-source = source
 field-service = service
 field-url = url
 field-mask = mask
 field-status = status
 field-boxc-id = boxc

 #-
 # SMSC CONNECTIONS
 #-

 include=/opt/vsmsc/etc/smsc.d/
 #include=/etc/kannel/smsc.d/mo_relay.conf

 #-
 # SMSBOX SETUP
 #-

 group = smsbox
 smsbox-id=VSMSC_HTTP
 bearerbox-host = 127.0.0.1
 sendsms-port = 13013
 log-file=/opt/vsmsc/logs/smsbox.log
 log-level=0
 access-log = /tmp/access.log

 #-
 # SEND-SMS USERS
 #-



 #-
 # SERVICES
 #-

 group = sms-service
 keyword = default
 catch-all=yes
 exec=/opt/vsmsc/sbin/mo_processor.php /opt/vsmsc/logs/mo_debug.log %p %P %C
 %b %F
 omit-empty=yes
 send-sender=yes

 ---


 
 smsbox.conf

 ---

 include=/opt/vsmsc/etc/kannel_include.conf

 group=vsmsc-config
 path=/opt/vsmsc/etc/vsmsc_sbox.conf

 # SEND-SMS USERS
 group = sendsms-user
 username = tester
 password = foobar
 #user-deny-ip = 
 #user-allow-ip = 


 -

 
 vsmsc_bbox.conf

 ---

 group=vsmsc
 id=vsmsc-primary
 smsc-db=vsmsc
 smsc-table=smscs
 user-db=vsmsc
 user-table=users
 http-port=16000
 mode=1
 bearerbox-status-url=http://localhost:13000/status.xml?password=foobar;
 num-tables=10
 server-id=1
 transactions-db=vsmsc
 transactions-table=user_transactions
 messages-db=vsmsc
 messages-table=user_messages
 status-db=vsmsc
 status-table=status_queue
 numbers-db=vsmsc
 numbers-table=numbers
 keywords-db=vsmsc
 keywords-table=number_keywords
 smpp-smsbox-id=VSMSC_SMPP
 http-smsbox-id=VSMSC_HTTP
 mo-db=vsmsc
 mo-table=mo_messages
 profile-db=vsmsc
 profile-table=routing_profiles
 batch-db=vsmsc
 batch-table=user_batches
 batch-tracking-db=vsmsc
 batch-tracking-table=user_batch_tracking_codes
 opt-out-words=stop
 block-db=vsmsc
 block-table=blocked_numbers


 

 
 vsmsc_sbox.conf

 ---

 group=mysql-connection
 id=vsmsc-primary
 host=localhost
 username=xx
 password=xx
 database=xx
 max-connections=5


 group=vsmsc
 id=vsmsc-primary
 smsc-db=vsmsc
 smsc-table=smscs
 user-db=vsmsc
 user-table=users
 http-port=17000
 mode=2
 bearerbox-status-url=http://localhost:13000/status.xml?password=foobar;
 num-tables=10

Re: DLR storage in kannel 1.4.3

2010-12-21 Thread Alejandro Guerrieri

Try googling a little bit about the error, it's probably something already
discussed.

If you're still out of luck, please post detailed information about the
error and your configuration files.

Regards,

Alex

On Tue, Dec 21, 2010 at 11:04 AM, Rapture supp...@ims.co.ke wrote:

  Let me get the error :) I thought the responses would be something like
 ‘1.4.3 has issues with mysql’



 Rapture



 *From:* Mohammed Saleem [mailto:mohammedsl...@gmail.com]
 *Sent:* Tuesday, December 21, 2010 1:02 PM
 *To:* Rapture
 *Cc:* users@kannel.org
 *Subject:* Re: DLR storage in kannel 1.4.3



 If we don't know the error we won't be able to help :)


 post your config files + error logs


  Best Regards,
 Mohammed M I Sleem

 http://www.abusleem.net  - Personal blog

 http://www.freakle.com - The Search Freak



  On Tue, Dec 21, 2010 at 11:54 AM, Rapture supp...@ims.co.ke wrote:

 Hi



 I’m using kannel 1.4.3. I tried to set my dlr engine to mysql but kept
 getting an error. I am using CentOS 5.5 64bit edition. What could be the
 issue?



 Kind Regards,



 Rapture

Re: Give outgoing messages priority over incoming

2010-12-16 Thread Alejandro Guerrieri

Yep, my patch is barely a workaround and it definitely impact performance,
specially on transceiver mode.

If you can use TX + RX instead of TRX, much better. Anyway the patch is not
intended to be used under heavy load at all.

Regards,

Alex
On Thu, Dec 16, 2010 at 10:26 AM, Nikos Balkanas nbalka...@gmail.comwrote:

Same logic also in transceiver mode. However, I thought you were talking
about svn kannel. Alex's patch is a different story. It will delay receiving
thread using sleep(), which can also cause ACKs on the transmitting thread
to be delayed, conceivably affecting both operations at the same time. For
more info on that, you need to talk to Alex.

BR,
Nikos

On Thu, Dec 16, 2010 at 9:27 AM, Mohammed Saleem
mohammedsl...@gmail.comwrote:

Hi Nikos,

Does this apply on transceiver SMPP connections on 1.4.3? coz I
doubt it, I applied a patch once by Alex for the DLRs coming too early
(before the message is ACKed) which lets the IO thread to sleep and waits
for the DLR to get inserted into the DB, I clearly saw that when the thread
sleeps, the traffic stops...

Thanks

Best Regards,
Mohammed M I Sleem

http://www.abusleem.net - Personal blog

http://www.freakle.com - The Search Freak

2010/12/16 Nikos Balkanas nbalka...@gmail.com

Hi,

That should not be your problem. MOs (including DLRs) run on a different
thread than your MTs, even use completely different queues and structures.
Even network traffic is on a seperate cable (assuming full duplex
operation). The presence of one shouldn't affect the other.

BR,
Nikos
- Original Message - From: JimSG jimmy.gar...@laprensa.hn
To: users@kannel.org
Sent: Wednesday, December 15, 2010 7:15 PM
Subject: Give outgoing messages priority over incoming

Hello,

We activated the dlr a while ago and it works, but we have come with a
next
situation:

Example:

A user sends 30,000 sms and a couple of minutes later another user sends
20,000 sms, it sends a couple thousands sms but it stops because it
starts
receving the dlr and then it starts sending againg and than it stops to
recieve and so on... Im using a dlr mask = 19

Can i give priority to outgoing messages over incoming messages?
--
View this message in context:
http://old.nabble.com/Give-outgoing-messages-priority-over-incoming-tp30465870p30465870.html
Sent from the Kannel - User mailing list archive at Nabble.com.

Re: Kannel

You need to configure those parameters as meta-data, and pass them on the
request.

Read the meta-data section on the UG for the details.

Regards,

Alex

On Wed, Dec 15, 2010 at 5:26 PM, Paul Harrison c...@austin.rr.com wrote:

 I get the following error:

 2010-12-15 10:56:34 [30493] [7] WARNING: SMPP: PDU NULL terminated string
 (message_id) has no NULL.

 2010-12-15 10:56:34 [30493] [7] ERROR: SMPP[psms]: SMSC returned error code
 0x042a (Vendor-specific error, please refer to your SMPP provider) in
 response to submit_sm.

 I talked to mblox and they said I’m not passing the operator and billing
 information to them. I doubt they are getting the MBserviceid and MBProgram
 either.  Mblox now requires the tag program=stdrt.

 How do I fix this?



 UG?



 Thanks,

 Paul



 *From:* Abdul Basit [mailto:basit.e...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 10:15 AM
 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Good. keep on reading UG.

 On Wed, Dec 15, 2010 at 9:10 PM, Paul Harrison c...@austin.rr.com wrote:

 I start kannel using the following code.



 /usr/local/sbin/bearerbox -v 1 --pid-file /var/run/kannel.pid
 /usr/local/etc/smskannel.conf 

 sleep 5

 /usr/local/sbin/smsbox -v 1 /usr/local/etc/smskannel.conf 



 Thanks,

 Paul



 *From:* Paul Harrison [mailto:c...@austin.rr.com]
 *Sent:* Wednesday, December 15, 2010 10:02 AM
 *To:* users@kannel.org
 *Subject:* Kannel



 Hi Team,



 I downloaded Kannel using the following options.
 SVN access to source code... svn co 
 https://svn.kannel.org/project/trunkhttps://svn.kannel.org/%3cproject%3e/trunk

 Smskannel.conf file: http://www.curesport.com/smskannel.conf

 kannel.conf file: http://www.curesport.com/kannel.conf

 In the smskannel.conf. I defined the mblox parameters.

 url I’m using:
 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=12345text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrthttp://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt

 When I invoke the above url. I get the below error message :

 [r...@node01 etc]# 2010-12-15 10:56:34 [30507] [3] INFO: smsbox: Got HTTP
 request /cgi-bin/sendsms from 192.168.1.116

 2010-12-15 10:56:34 [30507] [3] INFO: sendsms used by tester

 2010-12-15 10:56:34 [30507] [3] INFO: sendsms sender:tester:53985
 (192.168.1.116) to:15126366987 msg:hello from local

 2010-12-15 10:56:34 [30493] [7] WARNING: SMPP: PDU NULL terminated string
 (message_id) has no NULL.

 2010-12-15 10:56:34 [30493] [7] ERROR: SMPP[psms]: SMSC returned error code
 0x042a (Vendor-specific error, please refer to your SMPP provider) in
 response to submit_sm.

 I talked to mblox and they said I’m not passing the operator and billing
 information to them. I doubt they are getting the MBserviceid and MBProgram
 either.  Mblox now requires the tag program=stdrt.

 Can someone please help me?  It would be greatly appreciated.

 Thanks,

 Paul








 --

 Regards,


 Abdul Basit | +92 32 1416 4196 | +92 30 0841 1445

Re: Kannel

Can you provide log entries showing the submit_sm PDU and surroundings?

Regards,

Alex
On Wed, Dec 15, 2010 at 6:50 PM, Paul Harrison c...@austin.rr.com wrote:

 I have been picking at this for a few days now. I have no clue why I keep
 getting that error as I’m passing the meta data in the request.



 *From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On
 Behalf Of *Paul Harrison
 *Sent:* Wednesday, December 15, 2010 10:38 AM
 *To:* 'Alejandro Guerrieri'
 *Cc:* users@kannel.org
 *Subject:* RE: Kannel



 I read the UG on that. I’m passing the meta-data but I still get the error
 from the below email in red.




 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=12345text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrthttp://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt





 Any help is greatly appreciated.



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 10:35 AM
 *To:* Paul Harrison
 *Cc:* Abdul Basit; users@kannel.org
 *Subject:* Re: Kannel



 You need to configure those parameters as meta-data, and pass them on the
 request.



 Read the meta-data section on the UG for the details.



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 5:26 PM, Paul Harrison c...@austin.rr.com wrote:

 I get the following error:

 2010-12-15 10:56:34 [30493] [7] WARNING: SMPP: PDU NULL terminated string
 (message_id) has no NULL.

 2010-12-15 10:56:34 [30493] [7] ERROR: SMPP[psms]: SMSC returned error code
 0x042a (Vendor-specific error, please refer to your SMPP provider) in
 response to submit_sm.

 I talked to mblox and they said I’m not passing the operator and billing
 information to them. I doubt they are getting the MBserviceid and MBProgram
 either.  Mblox now requires the tag program=stdrt.

 How do I fix this?



 UG?



 Thanks,

 Paul



 *From:* Abdul Basit [mailto:basit.e...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 10:15 AM
 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Good. keep on reading UG.

 On Wed, Dec 15, 2010 at 9:10 PM, Paul Harrison c...@austin.rr.com wrote:

 I start kannel using the following code.



 /usr/local/sbin/bearerbox -v 1 --pid-file /var/run/kannel.pid
 /usr/local/etc/smskannel.conf 

 sleep 5

 /usr/local/sbin/smsbox -v 1 /usr/local/etc/smskannel.conf 



 Thanks,

 Paul



 *From:* Paul Harrison [mailto:c...@austin.rr.com]
 *Sent:* Wednesday, December 15, 2010 10:02 AM
 *To:* users@kannel.org
 *Subject:* Kannel



 Hi Team,



 I downloaded Kannel using the following options.
 SVN access to source code... svn co 
 https://svn.kannel.org/project/trunkhttps://svn.kannel.org/%3cproject%3e/trunk

 Smskannel.conf file: http://www.curesport.com/smskannel.conf

 kannel.conf file: http://www.curesport.com/kannel.conf

 In the smskannel.conf. I defined the mblox parameters.

 url I’m using:
 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=12345text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrthttp://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt

 When I invoke the above url. I get the below error message :

 [r...@node01 etc]# 2010-12-15 10:56:34 [30507] [3] INFO: smsbox: Got HTTP
 request /cgi-bin/sendsms from 192.168.1.116

 2010-12-15 10:56:34 [30507] [3] INFO: sendsms used by tester

 2010-12-15 10:56:34 [30507] [3] INFO: sendsms sender:tester:53985
 (192.168.1.116) to:15126366987 msg:hello from local

 2010-12-15 10:56:34 [30493] [7] WARNING: SMPP: PDU NULL terminated string
 (message_id) has no NULL.

 2010-12-15 10:56:34 [30493] [7] ERROR: SMPP[psms]: SMSC returned error code
 0x042a (Vendor-specific error, please refer to your SMPP provider) in
 response to submit_sm.

 I talked to mblox and they said I’m not passing the operator and billing
 information to them. I doubt they are getting the MBserviceid and MBProgram
 either.  Mblox now requires the tag program=stdrt.

 Can someone please help me?  It would be greatly appreciated.

 Thanks,

 Paul








 --

 Regards,


 Abdul Basit | +92 32 1416 4196 | +92 30 0841 1445

Re: Kannel

Hrm, the meta-data seems to be all there. Can you post your smpp-tlv groups?

Regards,

Alex

On Wed, Dec 15, 2010 at 8:02 PM, Paul Harrison c...@austin.rr.com wrote:

 http://www.curesport.com/smsbox.log



 http://www.curesport.com/kannel_access_log.txt



 http://www.curesport.com/stdout.txt





 Please let me know if you need anything else.



 Thank You,

 Paul



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 12:09 PM

 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Can you provide log entries showing the submit_sm PDU and surroundings?



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 6:50 PM, Paul Harrison c...@austin.rr.com wrote:

 I have been picking at this for a few days now. I have no clue why I keep
 getting that error as I’m passing the meta data in the request.



 *From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On
 Behalf Of *Paul Harrison
 *Sent:* Wednesday, December 15, 2010 10:38 AM
 *To:* 'Alejandro Guerrieri'
 *Cc:* users@kannel.org
 *Subject:* RE: Kannel



 I read the UG on that. I’m passing the meta-data but I still get the error
 from the below email in red.




 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=12345text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrthttp://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt





 Any help is greatly appreciated.



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 10:35 AM
 *To:* Paul Harrison
 *Cc:* Abdul Basit; users@kannel.org
 *Subject:* Re: Kannel



 You need to configure those parameters as meta-data, and pass them on the
 request.



 Read the meta-data section on the UG for the details.



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 5:26 PM, Paul Harrison c...@austin.rr.com wrote:

 I get the following error:

 2010-12-15 10:56:34 [30493] [7] WARNING: SMPP: PDU NULL terminated string
 (message_id) has no NULL.

 2010-12-15 10:56:34 [30493] [7] ERROR: SMPP[psms]: SMSC returned error code
 0x042a (Vendor-specific error, please refer to your SMPP provider) in
 response to submit_sm.

 I talked to mblox and they said I’m not passing the operator and billing
 information to them. I doubt they are getting the MBserviceid and MBProgram
 either.  Mblox now requires the tag program=stdrt.

 How do I fix this?



 UG?



 Thanks,

 Paul



 *From:* Abdul Basit [mailto:basit.e...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 10:15 AM
 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Good. keep on reading UG.

 On Wed, Dec 15, 2010 at 9:10 PM, Paul Harrison c...@austin.rr.com wrote:

 I start kannel using the following code.



 /usr/local/sbin/bearerbox -v 1 --pid-file /var/run/kannel.pid
 /usr/local/etc/smskannel.conf 

 sleep 5

 /usr/local/sbin/smsbox -v 1 /usr/local/etc/smskannel.conf 



 Thanks,

 Paul



 *From:* Paul Harrison [mailto:c...@austin.rr.com]
 *Sent:* Wednesday, December 15, 2010 10:02 AM
 *To:* users@kannel.org
 *Subject:* Kannel



 Hi Team,



 I downloaded Kannel using the following options.
 SVN access to source code... svn co 
 https://svn.kannel.org/project/trunkhttps://svn.kannel.org/%3cproject%3e/trunk

 Smskannel.conf file: http://www.curesport.com/smskannel.conf

 kannel.conf file: http://www.curesport.com/kannel.conf

 In the smskannel.conf. I defined the mblox parameters.

 url I’m using:
 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=12345text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrthttp://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt

 When I invoke the above url. I get the below error message :

 [r...@node01 etc]# 2010-12-15 10:56:34 [30507] [3] INFO: smsbox: Got HTTP
 request /cgi-bin/sendsms from 192.168.1.116

 2010-12-15 10:56:34 [30507] [3] INFO: sendsms used by tester

 2010-12-15 10:56:34 [30507] [3] INFO: sendsms sender:tester:53985
 (192.168.1.116) to:15126366987 msg:hello from local

 2010-12-15 10:56:34 [30493] [7] WARNING: SMPP: PDU NULL terminated string
 (message_id) has no NULL.

 2010-12-15 10:56:34 [30493] [7] ERROR: SMPP[psms]: SMSC returned error code
 0x042a (Vendor-specific error, please refer to your SMPP provider) in
 response to submit_sm.

 I talked to mblox and they said I’m not passing the operator and billing
 information to them. I doubt they are getting the MBserviceid and MBProgram
 either

Re: Kannel

[FID:] [META:?smpp-tlv?MBoperator=3...

Ah! You're using smpp-tlv, change it for smpp:

?smpp?MBoperator...

The smpp-tlv groups seems to be fine, change that and tell me how it goes.

Regards,

Alex


On Wed, Dec 15, 2010 at 8:39 PM, Paul Harrison c...@austin.rr.com wrote:

 Smskannel.conf file: http://www.curesport.com/smskannel.conf

 kannel.conf file: http://www.curesport.com/kannel.conf

 In the smskannel.conf. I defined the mblox parameters(smpp-tlv).



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 1:22 PM

 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Hrm, the meta-data seems to be all there. Can you post your smpp-tlv
 groups?



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 8:02 PM, Paul Harrison c...@austin.rr.com wrote:

 http://www.curesport.com/smsbox.log



 http://www.curesport.com/kannel_access_log.txt



 http://www.curesport.com/stdout.txt





 Please let me know if you need anything else.



 Thank You,

 Paul



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 12:09 PM


 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Can you provide log entries showing the submit_sm PDU and surroundings?



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 6:50 PM, Paul Harrison c...@austin.rr.com wrote:

 I have been picking at this for a few days now. I have no clue why I keep
 getting that error as I’m passing the meta data in the request.



 *From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On
 Behalf Of *Paul Harrison
 *Sent:* Wednesday, December 15, 2010 10:38 AM
 *To:* 'Alejandro Guerrieri'
 *Cc:* users@kannel.org
 *Subject:* RE: Kannel



 I read the UG on that. I’m passing the meta-data but I still get the error
 from the below email in red.




 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=12345text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrthttp://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt





 Any help is greatly appreciated.



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 10:35 AM
 *To:* Paul Harrison
 *Cc:* Abdul Basit; users@kannel.org
 *Subject:* Re: Kannel



 You need to configure those parameters as meta-data, and pass them on the
 request.



 Read the meta-data section on the UG for the details.



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 5:26 PM, Paul Harrison c...@austin.rr.com wrote:

 I get the following error:

 2010-12-15 10:56:34 [30493] [7] WARNING: SMPP: PDU NULL terminated string
 (message_id) has no NULL.

 2010-12-15 10:56:34 [30493] [7] ERROR: SMPP[psms]: SMSC returned error code
 0x042a (Vendor-specific error, please refer to your SMPP provider) in
 response to submit_sm.

 I talked to mblox and they said I’m not passing the operator and billing
 information to them. I doubt they are getting the MBserviceid and MBProgram
 either.  Mblox now requires the tag program=stdrt.

 How do I fix this?



 UG?



 Thanks,

 Paul



 *From:* Abdul Basit [mailto:basit.e...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 10:15 AM
 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Good. keep on reading UG.

 On Wed, Dec 15, 2010 at 9:10 PM, Paul Harrison c...@austin.rr.com wrote:

 I start kannel using the following code.



 /usr/local/sbin/bearerbox -v 1 --pid-file /var/run/kannel.pid
 /usr/local/etc/smskannel.conf 

 sleep 5

 /usr/local/sbin/smsbox -v 1 /usr/local/etc/smskannel.conf 



 Thanks,

 Paul



 *From:* Paul Harrison [mailto:c...@austin.rr.com]
 *Sent:* Wednesday, December 15, 2010 10:02 AM
 *To:* users@kannel.org
 *Subject:* Kannel



 Hi Team,



 I downloaded Kannel using the following options.
 SVN access to source code... svn co 
 https://svn.kannel.org/project/trunkhttps://svn.kannel.org/%3cproject%3e/trunk

 Smskannel.conf file: http://www.curesport.com/smskannel.conf

 kannel.conf file: http://www.curesport.com/kannel.conf

 In the smskannel.conf. I defined the mblox parameters.

 url I’m using:
 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=12345text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrthttp://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt

 When I invoke the above url. I get the below error message :

 [r...@node01 etc]# 2010-12-15 10:56:34 [30507] [3] INFO: smsbox: Got HTTP
 request

Re: Kannel

Glad it helped :)

I don't believe the warning has nothing to do with the problem. Ask mblox
again, you might be missing some other parameter or sending the wrong
values.

Regards,

Alex

On Wed, Dec 15, 2010 at 9:14 PM, Paul Harrison c...@austin.rr.com wrote:

 WOW, that was is it…. It works!



 One other issue. If I pass the service id and program then it fails.




 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt





 2010-12-15 15:08:50 [865] [3] INFO: sendsms sender:tester:54322
 (192.168.1.116) to:1512333 msg:hello from local

 2010-12-15 15:08:50 [851] [7] WARNING: SMPP: PDU NULL terminated string
 (message_id) has no NULL.

 2010-12-15 15:08:50 [851] [7] ERROR: SMPP[psms]: SMSC returned error code
 0x042a (Vendor-specific error, please refer to your SMPP provider) in
 response to submit_sm.



 2010-12-15 15:08:50 send-SMS request added - sender:tester:54322
 192.168.1.116 target:1512333 request: 'hello from local'

 2010-12-15 15:08:50 FAILED Send SMS [SMSC:psms] [SVC:tester] [ACT:] [BINF:]
 [FID:]
 [META:?smpp?MBoperator=31003MBbilling=0MBserviceId=26330MBprogram=stdrt]
 [from:54322] [to:1512333] [flags:-1:0:-1:-1:-1] [msg:16:hello from
 local] [udh:0:



 Any idea why?



 Thanks,

 Paul



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 1:58 PM

 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 [FID:] [META:?smpp-tlv?MBoperator=3...



 Ah! You're using smpp-tlv, change it for smpp:

 ?smpp?MBoperator...



 The smpp-tlv groups seems to be fine, change that and tell me how it goes.

 Regards,

 Alex



 On Wed, Dec 15, 2010 at 8:39 PM, Paul Harrison c...@austin.rr.com wrote:

 Smskannel.conf file: http://www.curesport.com/smskannel.conf

 kannel.conf file: http://www.curesport.com/kannel.conf

 In the smskannel.conf. I defined the mblox parameters(smpp-tlv).



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 1:22 PM


 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Hrm, the meta-data seems to be all there. Can you post your smpp-tlv
 groups?



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 8:02 PM, Paul Harrison c...@austin.rr.com wrote:

 http://www.curesport.com/smsbox.log



 http://www.curesport.com/kannel_access_log.txt



 http://www.curesport.com/stdout.txt





 Please let me know if you need anything else.



 Thank You,

 Paul



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 12:09 PM


 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Can you provide log entries showing the submit_sm PDU and surroundings?



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 6:50 PM, Paul Harrison c...@austin.rr.com wrote:

 I have been picking at this for a few days now. I have no clue why I keep
 getting that error as I’m passing the meta data in the request.



 *From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On
 Behalf Of *Paul Harrison
 *Sent:* Wednesday, December 15, 2010 10:38 AM
 *To:* 'Alejandro Guerrieri'
 *Cc:* users@kannel.org
 *Subject:* RE: Kannel



 I read the UG on that. I’m passing the meta-data but I still get the error
 from the below email in red.




 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=12345text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrthttp://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt





 Any help is greatly appreciated.



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 10:35 AM
 *To:* Paul Harrison
 *Cc:* Abdul Basit; users@kannel.org
 *Subject:* Re: Kannel



 You need to configure those parameters as meta-data, and pass them on the
 request.



 Read the meta-data section on the UG for the details.



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 5:26 PM, Paul Harrison c...@austin.rr.com wrote:

 I get the following error:

 2010-12-15 10:56:34 [30493] [7] WARNING: SMPP: PDU NULL terminated string
 (message_id) has no NULL.

 2010-12-15 10:56:34 [30493] [7] ERROR: SMPP[psms]: SMSC returned error code
 0x042a (Vendor-specific error, please refer to your SMPP provider) in
 response to submit_sm.

 I talked to mblox and they said I’m not passing the operator and billing
 information to them. I doubt they are getting the MBserviceid and MBProgram
 either.  Mblox now requires the tag program=stdrt.

 How do I fix this?



 UG?



 Thanks,

 Paul



 *From:* Abdul

Re: Kannel

Yes, and you can access any TLV's mblox might send (assuming you defined
them on your config of course) by using the %D parameter.

I'm glad it helped :)

Regards,

Alex

On Wed, Dec 15, 2010 at 10:12 PM, Paul Harrison c...@austin.rr.com wrote:

 I got with mblox and it works now.



 Thank you so much!



 Real quick, messages coming from handset to kannel. This will stay the same
 correct? I can still use the below information in my smskannel.conf ?



 post-url =
 http://172.16.94.111/sms_response_parent.html?body=%aopid=%mtime=%tMSISDN=%precipient=%Pcing=%Fhttp://172.16.94.111/sms_response_parent.html?body=%25aopid=%25mtime=%25tMSISDN=%25precipient=%25Pcing=%25F





 Paul



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 2:28 PM

 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Glad it helped :)



 I don't believe the warning has nothing to do with the problem. Ask mblox
 again, you might be missing some other parameter or sending the wrong
 values.



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 9:14 PM, Paul Harrison c...@austin.rr.com wrote:

 WOW, that was is it…. It works!



 One other issue. If I pass the service id and program then it fails.




 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt





 2010-12-15 15:08:50 [865] [3] INFO: sendsms sender:tester:54322
 (192.168.1.116) to:1512333 msg:hello from local

 2010-12-15 15:08:50 [851] [7] WARNING: SMPP: PDU NULL terminated string
 (message_id) has no NULL.

 2010-12-15 15:08:50 [851] [7] ERROR: SMPP[psms]: SMSC returned error code
 0x042a (Vendor-specific error, please refer to your SMPP provider) in
 response to submit_sm.



 2010-12-15 15:08:50 send-SMS request added - sender:tester:54322
 192.168.1.116 target:1512333 request: 'hello from local'

 2010-12-15 15:08:50 FAILED Send SMS [SMSC:psms] [SVC:tester] [ACT:] [BINF:]
 [FID:]
 [META:?smpp?MBoperator=31003MBbilling=0MBserviceId=26330MBprogram=stdrt]
 [from:54322] [to:1512333] [flags:-1:0:-1:-1:-1] [msg:16:hello from
 local] [udh:0:



 Any idea why?



 Thanks,

 Paul



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 1:58 PM


 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 [FID:] [META:?smpp-tlv?MBoperator=3...



 Ah! You're using smpp-tlv, change it for smpp:

 ?smpp?MBoperator...



 The smpp-tlv groups seems to be fine, change that and tell me how it goes.

 Regards,

 Alex



 On Wed, Dec 15, 2010 at 8:39 PM, Paul Harrison c...@austin.rr.com wrote:

 Smskannel.conf file: http://www.curesport.com/smskannel.conf

 kannel.conf file: http://www.curesport.com/kannel.conf

 In the smskannel.conf. I defined the mblox parameters(smpp-tlv).



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 1:22 PM


 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Hrm, the meta-data seems to be all there. Can you post your smpp-tlv
 groups?



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 8:02 PM, Paul Harrison c...@austin.rr.com wrote:

 http://www.curesport.com/smsbox.log



 http://www.curesport.com/kannel_access_log.txt



 http://www.curesport.com/stdout.txt





 Please let me know if you need anything else.



 Thank You,

 Paul



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 12:09 PM


 *To:* Paul Harrison
 *Cc:* users@kannel.org
 *Subject:* Re: Kannel



 Can you provide log entries showing the submit_sm PDU and surroundings?



 Regards,



 Alex

 On Wed, Dec 15, 2010 at 6:50 PM, Paul Harrison c...@austin.rr.com wrote:

 I have been picking at this for a few days now. I have no clue why I keep
 getting that error as I’m passing the meta data in the request.



 *From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On
 Behalf Of *Paul Harrison
 *Sent:* Wednesday, December 15, 2010 10:38 AM
 *To:* 'Alejandro Guerrieri'
 *Cc:* users@kannel.org
 *Subject:* RE: Kannel



 I read the UG on that. I’m passing the meta-data but I still get the error
 from the below email in red.




 http://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=12345text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrthttp://192.168.1.103:13013/cgi-bin/sendsms?password=foobarsmsc=psmsto=1512333username=testerfrom=54322text=hello+from+localmeta-data=%3Fsmpp-tlv%3FMBoperator%3D31003%26MBbilling%3D0%26MBserviceId%3D26330%26MBprogram%3Dstdrt





 Any help is greatly appreciated.



 *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
 *Sent:* Wednesday, December 15, 2010 10:35

Re: SQLBox

2010-11-29 Thread Alejandro Guerrieri

on meta-data? Yes indeed.

Regards,

Alex

On Mon, Nov 29, 2010 at 8:07 PM, Kenny ken.bell...@gmail.com wrote:

 Hi Alex,

 If a custom field is included send_sms, would the value be moved to
 sent_sms ?

 --
 Regards
 Kenny




 On Thu, Nov 18, 2010 at 1:52 PM, Alejandro Guerrieri 
 alejandro.guerri...@gmail.com wrote:

 You should add an arbitrary id to your dlr-url, that's the usual way to do
 it.

 Hope it helps.

 Alex


 On Thu, Nov 18, 2010 at 11:43 AM, James E jam...@gmail.com wrote:

 Hi,

 Thanks for your replies.

 Is there a way when inserting into the Send_sms table, to match it to the
 DLR in the sent_sms?

 At the moment, I see no linking between the MT and DLR in the sent_sms
 table.

 Regards,
 J


 On Thu, Nov 18, 2010 at 5:14 PM, Alejandro Guerrieri 
 alejandro.guerri...@gmail.com wrote:

 James,

 No, it doesn't work like that. The DLR message actually comes from the
 carrier, so it'll insert only the information from that message. You'll get
 your BINFO on the sent_sms copy of the message you've sent, but not on the
 DLR's coming from the carrier. You could, however, pass the value you're
 storing on the BINFO as a parameter on the dlr-url, and that way you'll be
 able to get it when kannel hits the dlr-url.

 Hope it helps,

 Alex


 On Thu, Nov 18, 2010 at 7:10 AM, James E jam...@gmail.com wrote:

 Hi,

 I am just wondering, if I enter BINFO into the send_sms table, shouldnt
 it be carried and inserted into the sent_sms table as well in the DLR 
 info?

 In my attempts it isnt doing this.

 Regards,
 J

Re: SQLBox

2010-11-29 Thread Alejandro Guerrieri

No, the queries are static, it won't copy any fields not belonging to
sqlbox.

Regards,

Alex

On Mon, Nov 29, 2010 at 10:26 PM, Kenny ken.bell...@gmail.com wrote:

 not on metadata.. i mean adding a new table `field` to both send_sms and
 sent_sms


 --
 Regards
 Kenny




 On Mon, Nov 29, 2010 at 8:08 PM, Alejandro Guerrieri 
 alejandro.guerri...@gmail.com wrote:

 on meta-data? Yes indeed.

 Regards,

 Alex


 On Mon, Nov 29, 2010 at 8:07 PM, Kenny ken.bell...@gmail.com wrote:

 Hi Alex,

 If a custom field is included send_sms, would the value be moved to
 sent_sms ?

 --
 Regards
 Kenny




 On Thu, Nov 18, 2010 at 1:52 PM, Alejandro Guerrieri 
 alejandro.guerri...@gmail.com wrote:

 You should add an arbitrary id to your dlr-url, that's the usual way to
 do it.

 Hope it helps.

 Alex


 On Thu, Nov 18, 2010 at 11:43 AM, James E jam...@gmail.com wrote:

 Hi,

 Thanks for your replies.

 Is there a way when inserting into the Send_sms table, to match it to
 the DLR in the sent_sms?

 At the moment, I see no linking between the MT and DLR in the sent_sms
 table.

 Regards,
 J


 On Thu, Nov 18, 2010 at 5:14 PM, Alejandro Guerrieri 
 alejandro.guerri...@gmail.com wrote:

 James,

 No, it doesn't work like that. The DLR message actually comes from the
 carrier, so it'll insert only the information from that message. You'll 
 get
 your BINFO on the sent_sms copy of the message you've sent, but not on 
 the
 DLR's coming from the carrier. You could, however, pass the value you're
 storing on the BINFO as a parameter on the dlr-url, and that way you'll 
 be
 able to get it when kannel hits the dlr-url.

 Hope it helps,

 Alex


 On Thu, Nov 18, 2010 at 7:10 AM, James E jam...@gmail.com wrote:

 Hi,

 I am just wondering, if I enter BINFO into the send_sms table,
 shouldnt it be carried and inserted into the sent_sms table as well in 
 the
 DLR info?

 In my attempts it isnt doing this.

 Regards,
 J

Re: [resend] Sending SMS with UDH results in BinaryMessage

2010-11-24 Thread alejandro . guerrieri

Messages with UDH are actually binary in SMS terms. Maybe J2ME behaves the same?

Regards,

Alex
BlackBerry de movistar, allí donde estés está tu oficin@

-Original Message-
From: Peter Sabaini pe...@sabaini.at
Sender: users-boun...@kannel.org
Date: Wed, 24 Nov 2010 10:00:05 
To: users@kannel.org
Subject: [resend] Sending SMS with UDH results in BinaryMessage

Resending -- anyone with J2ME experience here? Thanks alot!\

 -- 
Hello list,

I use the sendsms interface to send SMS with a UDH to set the
destination port. Setting the port works, but one oddity remains -- the
J2ME platform returns a com.sun.midp.io.j2me.sms.BinaryObject instead of
a TextObject in this case. 

Does anyone know how this behaviour is triggered? The message body only
contains ASCII... 

Thanks,
peter.

-- 
http://sabaini.at
http://blog.sabaini.at

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Alejandro Guerrieri

Sqlbox now uses url-encode for msgdata and udhdata, this shouldn't be an
issue.

I'll try to reproduce the error locally and let you know what I find.

Are you using latest sqlbox and kannel?

Regards,

Alex

On Fri, Nov 19, 2010 at 11:24 AM, Peter p...@locosms.gr wrote:


 Willie.

 Thank u,
 the patch is not commited
 I tested  with the patch but still get

 2010-11-19 12:19:47 [14060] [3] DEBUG: smsbox_to_bearerbox: sms received
 2010-11-19 12:19:48 [14060] [4] ERROR: MYSQL: You have an error in your SQL
 syntax; check the manual that corresponds to your MySQL server version for
 the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
 date:1011191020 done date:1011191020 sta' at line 1
 2010-11-19 12:19:50 [14060] [4] ERROR: MYSQL: You have an error in your SQL
 syntax; check the manual that corresponds to your MySQL server version for
 the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
 date:1011191120 done date:1011191020 sta' at line 1

 ...

 Alejandro can you comment on that?

 Is there a way out.

 Στις 19-11-2010, ημέρα Παρ, και ώρα 17:05 +0700, ο/η Willy Mularto έγραψε:

 static Octstr *get_string_value_or_return_null(Octstr *str) { static Octstr
 *nul = NULL;
 if (str == NULL) { return octstr_create(NULL); } if
 (octstr_compare(str, octstr_imm()) == 0) { return
 octstr_create(NULL); } octstr_replace(str, octstr_imm(\\),
 octstr_imm()); octstr_replace(str, octstr_imm(\'),
 octstr_imm(\\\')); if (NULL == nul) { nul = octstr_create();
 octstr_append_char(nul, 0x00); } octstr_replace(str, nul,
 octstr_imm(\0)); return octstr_format(\'%S\', str); }

   --


 *Dr. Peter Kontopoulos*
 CTO

 *LOCOTEL SA*
 2, Parnassou St.
 10561 Athens, GREECE
 *T:* +30 210 3258 350 *F:* +30 210 3258 359
 www.locotel.grwww.locosms.gr
 --


 Email Disclaimer
 The information in this email is confidential and is intended solely for
 the addressee(s). If you have received this transmission in error, and you
 are not an intended recipient, be aware that any disclosure, copying,
 distribution or use of this transmission or its contents is prohibited.
 Furthermore, you are kindly requested to send us back the original message
 at the address portmas...@locotel.gr, and delete the message from your
 system immediately.
 Internet communications are not secure and therefore LOCOTEL SA does not
 accept legal responsibility for the contents of this message and for any
 damage whatsoever that is caused by viruses being passed. Any views or
 opinions presented are solely those of the author and do not necessarily
 represent those of LOCOTEL SA.
 Thank you,
 LOCOTEL SA
 *Think Before you Print*

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Alejandro Guerrieri

It should work fine now, I've tested it :)

2010/11/19 Kenny ken.bell...@gmail.com

 Alex...that's fantastic. :)

 Willy.. have you tested this with wappush? Am going to do that presently.

 --
 Regards
 Kenny



 2010/11/19 Alejandro Guerrieri alejandro.guerri...@gmail.com

 With the latest version, yes. It's mentioned on the UPGRADE file:

 
 * IMPORTANT NOTICE *

 If you're upgrading from a version BEFORE 2010-11-11 (0.7.x and
 lower), please note that the format for the msgdata and udhdata
 columns is now url-encoded. That probably means that if you use
 inserts on send_sms to send MT, YOU WILL NEED TO MODIFY YOUR
 CODE TO URLENCODE THE MESSAGES FIRST.
 
 Regards,

 Alex

 2010/11/19 Kenny ken.bell...@gmail.com

 Alex, Are you saying one has to url-encode before passing data into
 msgdata and udhdata? Please confirm.


 --
 Regards
 Kenny



 2010/11/19 Alejandro Guerrieri alejandro.guerri...@gmail.com

 Sqlbox now uses url-encode for msgdata and udhdata, this shouldn't be an
 issue.

 I'll try to reproduce the error locally and let you know what I find.

 Are you using latest sqlbox and kannel?

 Regards,

 Alex


 On Fri, Nov 19, 2010 at 11:24 AM, Peter p...@locosms.gr wrote:


 Willie.

 Thank u,
 the patch is not commited
 I tested  with the patch but still get

 2010-11-19 12:19:47 [14060] [3] DEBUG: smsbox_to_bearerbox: sms
 received
 2010-11-19 12:19:48 [14060] [4] ERROR: MYSQL: You have an error in your
 SQL syntax; check the manual that corresponds to your MySQL server version
 for the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
 date:1011191020 done date:1011191020 sta' at line 1
 2010-11-19 12:19:50 [14060] [4] ERROR: MYSQL: You have an error in your
 SQL syntax; check the manual that corresponds to your MySQL server version
 for the right syntax to use near ''id:1365419169 sub:001 dlvrd:001 submit
 date:1011191120 done date:1011191020 sta' at line 1

 ...

 Alejandro can you comment on that?

 Is there a way out.

 Στις 19-11-2010, ημέρα Παρ, και ώρα 17:05 +0700, ο/η Willy Mularto
 έγραψε:

 static Octstr *get_string_value_or_return_null(Octstr *str) { static
 Octstr *nul = NULL;
 if (str == NULL) { return octstr_create(NULL); }
 if (octstr_compare(str, octstr_imm()) == 0) { return
 octstr_create(NULL); } octstr_replace(str, octstr_imm(\\),
 octstr_imm()); octstr_replace(str, octstr_imm(\'),
 octstr_imm(\\\')); if (NULL == nul) { nul = octstr_create();
 octstr_append_char(nul, 0x00); } octstr_replace(str, nul,
 octstr_imm(\0)); return octstr_format(\'%S\', str); }

   --


 *Dr. Peter Kontopoulos*
 CTO

 *LOCOTEL SA*
 2, Parnassou St.
 10561 Athens, GREECE
 *T:* +30 210 3258 350 *F:* +30 210 3258 359
 www.locotel.grwww.locosms.gr
 --


 Email Disclaimer
 The information in this email is confidential and is intended solely
 for the addressee(s). If you have received this transmission in error, and
 you are not an intended recipient, be aware that any disclosure, copying,
 distribution or use of this transmission or its contents is prohibited.
 Furthermore, you are kindly requested to send us back the original message
 at the address portmas...@locotel.gr, and delete the message from your
 system immediately.
 Internet communications are not secure and therefore LOCOTEL SA does
 not accept legal responsibility for the contents of this message and for 
 any
 damage whatsoever that is caused by viruses being passed. Any views or
 opinions presented are solely those of the author and do not necessarily
 represent those of LOCOTEL SA.
 Thank you,
 LOCOTEL SA
 *Think Before you Print*

Re: SQLBox

James,

No, it doesn't work like that. The DLR message actually comes from the
carrier, so it'll insert only the information from that message. You'll get
your BINFO on the sent_sms copy of the message you've sent, but not on the
DLR's coming from the carrier. You could, however, pass the value you're
storing on the BINFO as a parameter on the dlr-url, and that way you'll be
able to get it when kannel hits the dlr-url.

Hope it helps,

Alex

On Thu, Nov 18, 2010 at 7:10 AM, James E jam...@gmail.com wrote:

 Hi,

 I am just wondering, if I enter BINFO into the send_sms table, shouldnt it
 be carried and inserted into the sent_sms table as well in the DLR info?

 In my attempts it isnt doing this.

 Regards,
 J

Re: SQLBox

You should add an arbitrary id to your dlr-url, that's the usual way to do
it.

Hope it helps.

Alex

On Thu, Nov 18, 2010 at 11:43 AM, James E jam...@gmail.com wrote:

 Hi,

 Thanks for your replies.

 Is there a way when inserting into the Send_sms table, to match it to the
 DLR in the sent_sms?

 At the moment, I see no linking between the MT and DLR in the sent_sms
 table.

 Regards,
 J


 On Thu, Nov 18, 2010 at 5:14 PM, Alejandro Guerrieri 
 alejandro.guerri...@gmail.com wrote:

 James,

 No, it doesn't work like that. The DLR message actually comes from the
 carrier, so it'll insert only the information from that message. You'll get
 your BINFO on the sent_sms copy of the message you've sent, but not on the
 DLR's coming from the carrier. You could, however, pass the value you're
 storing on the BINFO as a parameter on the dlr-url, and that way you'll be
 able to get it when kannel hits the dlr-url.

 Hope it helps,

 Alex


 On Thu, Nov 18, 2010 at 7:10 AM, James E jam...@gmail.com wrote:

 Hi,

 I am just wondering, if I enter BINFO into the send_sms table, shouldnt
 it be carried and inserted into the sent_sms table as well in the DLR info?

 In my attempts it isnt doing this.

 Regards,
 J

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

It's probably an issue with single quotes on dlr text.

Can you provide a full pdu dump for the DLR?

Regards,

Alex
On Thu, Nov 18, 2010 at 6:21 PM, Peter p...@locosms.gr wrote:

Dear friends,

I found that in the last patch still reproduces

2010-11-18 18:29:01 [10182] [3] DEBUG: smsbox_to_bearerbox: sms received
2010-11-18 18:29:01 [10182] [4] ERROR: MYSQL: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near ''id:1219071490 sub:001 dlvrd:001 submit
date:1011181629 done date:1011181629 sta' at line 1
2010-11-18 18:29:09 [10182] [4] ERROR: MYSQL: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near ''id:1219071490 sub:001 dlvrd:001 submit
date:1011181729 done date:1011181629 sta' at line 1

Can you verify that this is a problem of null (or something else?).

In this case dlrs are received by our application using
smssend == smsbox ==sqlbox==bearer box

but records are not inserted in mysql sent-sms table.

Please check.
Best regards
Peter Kontopoulos

Στις 14-11-2010, ημέρα Κυρ, και ώρα 19:45 +0700, ο/η Willy Mularto έγραψε:

I have used the latest SVN to work with Kannel early 2009 CVS version (1
version before 1.4.3 was released). I found it still reproduce my previous
error. I think I need to use the same Kannel SVN as well. So I re apply
patch from Rene :)

sangprabv
sangpr...@gmail.com

http://www.petitiononline.com/froyo/

On Nov 12, 2010, at 9:46 PM, Alejandro Guerrieri wrote:

Sure, let me give you a couple of hints:

* url-encode msgdata and udhdata, for example:

udh = %06%05%04%0B%84%23%F0

msgdata = %1B%06%01%AE%02%05%6A...

* You'll probably need to set alt_dcs = 1

Hope it helps,

Alex

On Fri, Nov 12, 2010 at 3:13 PM, Willy Mularto sangpr...@gmail.com
wrote:

Will play with it tonight and hope those errors disapear and hopefully
no need to use sendsms to send wap push anymore. Many thanks to Alex, Rene
and all Kannel project+addons developers.

sangprabv
sangpr...@gmail.com

http://www.petitiononline.com/froyo/

On Nov 12, 2010, at 9:03 PM, Alejandro Guerrieri wrote:

Yes, it url-encodes msgdata and udhdata when saving, and url-decodes when
reading.

It also allows wap pushes to work btw.

Regards,

Alex

On Fri, Nov 12, 2010 at 2:59 PM, Rene Kluwen rene.klu...@chimit.nl
wrote:

Does it also encode normal text messages? Because those are the case,
here.

== Rene

*From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com]
*Sent:* Friday, 12 November, 2010 14:06
*To:* Rene Kluwen
*Cc:* Willy Mularto; Kannel Users
*Subject:* Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

Can you try the latest revision? We applied a patch yesterday that
url-encodes msgdata and udhdata, I guess it should fix this issue as well.

Regards,

Alex

On Fri, Nov 12, 2010 at 1:52 PM, Rene Kluwen rene.klu...@chimit.nl
wrote:

This patch should solve the issue.

-Original Message-
From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf

Of Rene Kluwen
Sent: Friday, 12 November, 2010 13:45
To: 'Willy Mularto'; 'Kannel Users'
Subject: RE: SQLBox INSERT INTO MySQL Bug

It's not the ' character that is not escaped. Probably you are getting a
'\x00' byte in your delivery receipt.
I had the same issue with a client.

== Rene

-Original Message-
From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf
Of Willy Mularto
Sent: Friday, 12 November, 2010 02:00
To: Kannel Users
Subject: SQLBox INSERT INTO MySQL Bug

I found some errors in the log like this

ERROR: MYSQL: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
''id:1127445986 sub:001 dlvrd:001 submit date:1011120752 done
date:1011120752 sta' at line 1

I think SQLBox failed to escape the ' character when inserting new row. Is
there any patch against this error? Thanks.

sangprabv
sangpr...@gmail.com
http://www.petitiononline.com/froyo/

*Dr. Peter Kontopoulos*
CTO

*LOCOTEL SA*
2, Parnassou St.
10561 Athens, GREECE
*T:* +30 210 3258 350 *F:* +30 210 3258 359
www.locotel.grwww.locosms.gr
--

Email Disclaimer
The information in this email is confidential and is intended solely for
the addressee(s). If you have received this transmission in error, and you
are not an intended recipient, be aware that any disclosure, copying,
distribution or use of this transmission or its contents is prohibited.
Furthermore, you are kindly requested to send us back the original message
at the address portmas...@locotel.gr, and delete the message from your

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

Hrm, no, that DLR doesn't even include single quotes, that's an artifact
from the log.

On Thu, Nov 18, 2010 at 6:51 PM, Peter p...@locosms.gr wrote:

Alejandro,
I send you the requested dump plus typical log files

*...
*

Στις 18-11-2010, ημέρα Πεμ, και ώρα 18:31 +0100, ο/η Alejandro Guerrieri
έγραψε:

It's probably an issue with single quotes on dlr text.

Can you provide a full pdu dump for the DLR?

Regards,

Alex

On Thu, Nov 18, 2010 at 6:21 PM, Peter p...@locosms.gr wrote:

Dear friends,

I found that in the last patch still reproduces

Can you verify that this is a problem of null (or something else?).

In this case dlrs are received by our application using
smssend == smsbox ==sqlbox==bearer box

but records are not inserted in mysql sent-sms table.

Please check.
Best regards
Peter Kontopoulos

Στις 14-11-2010, ημέρα Κυρ, και ώρα 19:45 +0700, ο/η Willy Mularto έγραψε:

sangprabv
sangpr...@gmail.com
http://www.petitiononline.com/froyo/

On Nov 12, 2010, at 9:46 PM, Alejandro Guerrieri wrote:

Sure, let me give you a couple of hints:

* url-encode msgdata and udhdata, for example:

udh = %06%05%04%0B%84%23%F0
msgdata = %1B%06%01%AE%02%05%6A...

* You'll probably need to set alt_dcs = 1

Hope it helps,

Alex

On Fri, Nov 12, 2010 at 3:13 PM, Willy Mularto sangpr...@gmail.com
wrote:

Will play with it tonight and hope those errors disapear and hopefully no
need to use sendsms to send wap push anymore. Many thanks to Alex, Rene and
all Kannel project+addons developers.

sangprabv
sangpr...@gmail.com
http://www.petitiononline.com/froyo/

On Nov 12, 2010, at 9:03 PM, Alejandro Guerrieri wrote:

Yes, it url-encodes msgdata and udhdata when saving, and url-decodes when
reading.

It also allows wap pushes to work btw.

Regards,

Alex

On Fri, Nov 12, 2010 at 2:59 PM, Rene Kluwen rene.klu...@chimit.nl
wrote:

Does it also encode normal text messages? Because those are the case, here.

== Rene

Can you try the latest revision? We applied a patch yesterday that
url-encodes msgdata and udhdata, I guess it should fix this issue as well.

Regards,

Alex

On Fri, Nov 12, 2010 at 1:52 PM, Rene Kluwen rene.klu...@chimit.nl
wrote:

This patch should solve the issue.

-Original Message-
From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf

Of Rene Kluwen
Sent: Friday, 12 November, 2010 13:45
To: 'Willy Mularto'; 'Kannel Users'
Subject: RE: SQLBox INSERT INTO MySQL Bug

It's not the ' character that is not escaped. Probably you are getting a
'\x00' byte in your delivery receipt.
I had the same issue with a client.

== Rene

I found some errors in the log like this

I think SQLBox failed to escape the ' character when inserting new row. Is
there any patch against this error? Thanks.

sangprabv
sangpr...@gmail.com
http://www.petitiononline.com/froyo/

*Dr. Peter Kontopoulos*
CTO

*LOCOTEL SA*
2, Parnassou St.
10561 Athens, GREECE
*T:* +30 210 3258 350 *F:* +30 210 3258 359
www.locotel.grwww.locosms.gr
--

Re: SQLBox Sent SMS