Hi,
Below I am pasting my query:
insert into send_sms
(momt,sender,receiver,msgdata,smsc_id,boxc_id,udhdata,coding,service) values
('MT','58787','919888888888','024a3a5d1d85e585d1c9a404004d1ec49821821661841b
61821841861861849b6186164166162146146164164164186166146166162146144146164184
166186166146142000','mysmpp','dlrbox','06050415811581',2,'hungama');
I tried with coding = 1 also but then sqlbox is adding 3 before every
character in data and UDH. When I used coding=2 the data part got trimmed
after it encountered a "00". This ia also happening in sqlbox-standalone
also the UDH got trimmed when I used UHD="06050415810000", I changed "0000"
to "1581" then it was accepted successfully. But I think this is a bug
because when we will try to send multipart messages we are definitely going
to put "00" in the UDH and also the data part is going to contain "00"
somewhere.
Please help me with this. If u have got anything like this before.
Thanks and regards,
Tushar Chauhan
_____
From: Alejandro Guerrieri [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2008 8:09 PM
To: users@kannel.org
Subject: Re: problem with sqlbox
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: users@kannel.org
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: users@kannel.org
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: users@kannel.org
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
