RE: Bug on kannel

Hi,

           I was able to solve the problem once i added the code you
provided to sql_mysql.c file. But i faced other problem when running the
sqlbox again.

          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 ''' at line 1

          I been getting this error when i try to pass in value of "%00"
instead of normal text. Was it because of other part of the code that was
not up to date? Was is possibly for u to email the whole set of ur
sqlbox-standalone .c file?

Regards,
SoNG
  -----Original Message-----
  From: Djiby SY [mailto:[email protected]]On Behalf Of Djiby SY
  Sent: Friday, February 15, 2008 7:33 PM
  To: [email protected]
  Cc: Andreas Fink; [email protected]
  Subject: Re: Bug on kannel


  When updating de mysql DB, the pointer msg->sms.msgdata was passed as
parametter of function and modified inside the function.
  This is why the MT message  has "\'" in the phone instead of "'".

  I have modified the function static Octstr
*get_string_value_or_return_null(Octstr *)  in sqlbox_mysql.c

  static Octstr *get_string_value_or_return_null(Octstr *str1)
  {
      Octstr *str;
      Octstr *result = NULL;
      str = octstr_duplicate(str1);
      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("\\\'"));
      result = octstr_format("\'%S\'", str);
      octstr_destroy(str);
      return result;

  }

  Hope it helps.

  Regards
  --
  Djiby


  [email protected] wrote :
    Hi,
                Yes, I been using sqlbox standalone version. Can you email
me the solution?

    Regards,
    SoNG
      -----Original Message-----
      From: [email protected] [mailto:[email protected]]On Behalf Of Djiby
SY
      Sent: Friday, February 15, 2008 5:18 PM
      To: [email protected]
      Cc: Andreas Fink; [email protected]
      Subject: Re: Bug on kannel


      Hi,

      Do you use sqlbox?
      I think this a bug in sqlbox, I have modified the source of sqlbox
long time ago and the problem is solved in my side.

      Regards
      --
      Djiby




      On Fri, Feb 15, 2008 at 7:40 AM, <[email protected]> wrote:

        Hi,

        My http sending format.
        http://localhost:13013/cgi-bin/sendsms?username=xxxxx&password=xxx
xxx&&fro
        m=xxxxxxxx&to=xxxxxxx&smsc=xx&coding=0&text=hi%27he

        I been using the stable version of kannel 1.4.1.

        2008-02-15 15:35:56 [15686] [3] INFO: sendsms
sender:<xxxxxx:xxxxxxx>
        (127.0.0.1) to:<xxxxxx> msg:<hi'he>
        2008-02-15 15:35:56 [15686] [3] DEBUG: Stored UUID
        9c00771a-500e-4aaf-9ef3-51ee481e6c3a
        2008-02-15 15:35:56 [15686] [3] DEBUG: message length 5, sending 1
        messages
        2008-02-15 15:35:56 [15686] [3] DEBUG: Status: 202 Answer: <Sent.>
        2008-02-15 15:35:56 [15686] [3] DEBUG: Delayed reply - wait for
bearerbox
        2008-02-15 15:35:56 [15686] [0] DEBUG: Got ACK (0) of
        9c00771a-500e-4aaf-9ef3-51ee481e6c3a

        The message received & stored fine into db. which is "hi'he" but
when
        received at my operator site. it become "hi\'he".

        Regards,
        SoNG


        -----Original Message-----
        From: Andreas Fink [mailto:[email protected]]
        Sent: Friday, February 15, 2008 3:18 PM
        To: <[email protected]>
        Cc: [email protected]
        Subject: Re: Bug on kannel


        how do you send it in HTTP?
        show us log?
        does it happen in CVS version?

        On 15.02.2008, at 05:10, <[email protected]> <[email protected]>
wrote:

        > Hi,
        >
        >       I found out this bug when i doing testing on sending out
sms.
        >
        >       Message send out = he'hi
        >
        >       Message received = he\'hi
        >
        >       I need to set the charset=UTF-8 and coding type to unicode
only i
        > will be
        > able to receive the correct sms. Can i know wat is the problem
that
        > cost
        > this to happen? As far as i know ' sign is not a unicode
character.
        >
        > Regard,
        > SoNG