Hi,
Below is the status, I am using sqlbox-standalone:
Kannel bearerbox version `cvs-20070722'. Build `Jun 3 2008 15:39:44',
compiler `3.4.4 20050721 (Red Hat 3.4.4-2)'. System Linux, release
2.6.9-22.ELsmp, version #1 SMP Mon Sep 19 18:32:14 EDT 2005, machine i686.
Hostname webserver, IP 127.0.0.1. Libxml version 2.6.16. Using OpenSSL
0.9.7a Feb 19 2003. Compiled with MySQL 4.1.12, using MySQL 4.1.12. Using
native malloc.
Status: running, uptime 0d 0h 15m 5s
WDP: received 0 (0 queued), sent 0 (0 queued)
SMS: received 6 (0 queued), sent 3 (0 queued), store size 0
SMS: inbound 0.01 msg/sec, outbound 0.00 msg/sec
DLR: 8 queued, using mysql storage
Box connections:
smsbox:smsbox, IP 127.0.0.1 (0 queued), (on-line 0d 0h 15m 3s)
smsbox:(none), IP 127.0.0.1 (0 queued), (on-line 0d 0h 15m 1s)
SMSC connections:
mysmpp SMPP:1xx.2xx.1xx.1xx:xxxx/xxxx:test2:VMA (online 904s, rcvd 6,
sent 3, failed 0, queued 0 msgs)
Thanks and regards,
Tushar Chauhan
-----Original Message-----
From: Kashif Ali Bukhari [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2008 6:31 PM
To: Tushar
Cc: [email protected]
Subject: Re: problem with sqlbox
Dear Tushar!
Please send the output of lynx http://localhost:13000/status .
Best regards
Kashif Ali Bukhari
Tushar wrote:
> Hi all,
>
> Any updates on this problem. I went through the mysql link but I am
> confused.
>
>
> Thanks and regards,
>
> Tushar Chauhan
>
> -----Original Message-----
> From: Thomas Göttgens [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 30, 2008 11:57 PM
> To: Alejandro Guerrieri
> Cc: [email protected]
> Subject: Re[2]: problem with sqlbox
>
> Hello Alejandro and all,
>
> i have come across this before, the same problem, strings terminating
after
> a NULL character. From what i have found out, the strings are handled
> correctly as octstr in the code, but the actual mysql insert does not
encode
> the payload to a binary insert and hence the 00 clipping occurs within the
> mysql driver.
>
> There is no easy fix because the representation of data needs to be
> converted to a binary safe syntax for the mysql insert. That's where i
> stopped, cause i am not that firm in c, and used the method of repeating
the
> port in the UDH sequence like described earlier.
>
> a pointer for fixing this in sqlbox would be
> http://dev.mysql.com/doc/refman/5.0/en/hexadecimal-values.html
>
> Thursday, May 29, 2008, 4:38:48 PM, you wrote:
>
> The hex values as a string? Could you paste a sample query of what you're
> doing?
>
> Regards,
>
> Alejandro
>
>
> On Thu, May 29, 2008 at 6:42 AM, Tushar <[EMAIL PROTECTED]> wrote:
>
>
> I tried with sqlbox-standalone also but the same thing happened again.
> Can u tell me in what form I should submit the udhdata and msgdata into
> database. Currently I am inserting the hex values only.
>
>
>
> Thanks and regards,
>
> Tushar Chauhan
>
>
> From: Alejandro Guerrieri [mailto:[EMAIL PROTECTED]
>
> Sent: Thursday, May 29, 2008 10:52 AM
> To: [email protected]
> Subject: Re: problem with sqlbox
>
> Well, looks a lot like a bug. Maybe the string is treated as a null
> terminated C string instead of an Octstr somewhere on sqlbox code. That
> would explain that behaviour, but more testings are needed to confirm
that.
>
> Furthermore, the sqlbox patch is quite outdated and deprecated, you should
> try running the sqlbox-standalone package along with latest stable kannel
> (the cvs branch is quite stable as well). sqlbox-standalone works
> independently from kannel, so no patching is necessary on kannel's tree.
>
> Maybe the problem was fixed on newer releases, try updating and if the
> problem persists then let us know.
>
> Regards,
>
> Alejandro
> On Thu, May 29, 2008 at 2:15 AM, Tushar <[EMAIL PROTECTED]> wrote:
> I have already done that
. After putting 1581 instead of 0000 I got the
UDH
> right but the message data part was still trimmed after "00" as I have
shown
> below.
> I need to send the full message. Please help me with this/
>
>
> Thanks and regards,
>
> Tushar Chauhan
>
>
> From: Alejandro Guerrieri [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 28, 2008 8:46 PM
> To: [email protected]
>
> Subject: Re: problem with sqlbox
>
> Try putting 1581, instead of 0000, should work...
>
> Regards,
>
> Alejandro
> On Wed, May 28, 2008 at 11:34 AM, Tushar <[EMAIL PROTECTED]> wrote:
>
>
> No my sms is not exceeding 160 chars. The size of the message pasted below
> is also 91. so I don't think there is any problem with the size of the
> message.
> Moreover the same message is getting delivered when I send it thru' the
http
> url of kannel.
>
>
> Tushar Chauhan
>
>
> From: Kashif Ali Bukhari [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 28, 2008 6:41 PM
> To: Tushar
> Cc: [email protected]
> Subject: Re: problem with sqlbox
>
> may be you sms is exceeding 160 characters and telco doesn't support
> concatenation .
>
> Tushar wrote:
> Hello all,
>
> I am running kannel version 1.4.1 with sqlbox patch and TLV
> patch. I am having following problem with sqlbox :
>
>
> Whenever I am trying to submit monotone or any other binary message with
> UDH, e.g, let us consider a monotone with
>
> UDH = 06050415810000
> And
> DATA=
>
024A3A515195C9940400791CC512495412424E314492550490938C512495412424E314488498
>
498518520552560520498498498518520552560520498939039038C512612814494812824E20
> E4144985205D855A51A55849854A00
>
> Now whenever I am trying to send this message through sqlbox. I am getting
> nothing on my phone when I checked the logs I found out that
> Sqlbox sent the message with following details:
>
> UDH= 0605041581
> And
> DATA = 024A3A515195C99404
>
> I don't know what's happening but I think sqlbox is removing everything
> after it gets "00" in UDH or data part.
> If somebody got the same problem, Please help me to fix this.
>
>
>
> Thanks and regards,
>
> Tushar Chauhan
>
>
>
>
>
>
>
>
>
