hi,
in a view to avoid the time issue, set the validity field to 1440 - i.e. 24 hours.
could you please paste here the full sql you use to insert ?
and, whats the db encoding ?
and, do you have default settings in the sql box config?:)
is it standalone ?
have to say, i run not the recent kannel version
with standalone sqlbox from Jul 8 2006 from http://www.kannel.org/~mconte/sqlbox/:
Kannel bearerbox version `cvs-20060723'.
Build `Aug 29 2006 00:38:52', compiler `4.0.1 20050727 (Red Hat 4.0.1-5)'.
System Linux, release 2.6.14-1.1637_FC4smp, version #1 SMP Wed Nov 9 18:34:11 EST 2005, machine i686.
Hostname DL360-1.mtel.net, IP 127.0.0.1.
Libxml version 2.6.20.
Using OpenSSL 0.9.7f 22 Mar 2005.
Using native malloc.
Regards
seik
-----Original Message-----
From: Fourat Zouari [EMAIL PROTECTED]
Sent: Wednesday, December 13, 2006
To: seik
Subject:[sqlbox] MT is allways sent as flash message.
|
> |
Hi Thanks for your help, i've tryed these, i got the correct values i want in "mclass" column of the log table of sqlbox but the message is allways sent as flash. here's a log snapshot : (another thing, i got a problem with sending the MT, kannel is affecting the "timetoleave" value on the operator SMS-C and letting it reject the MT cause the "timetoleave" is in past (equal to the kannel's server date), to temporary resolve this, i put the date on my server to later date and all works, i need to know why kannel does send the server's date ?) -[BEGIN: log snapshot]----------------------------------- 2006-12-13 13:18:38 [2554] [15] DEBUG: boxc_receiver: sms received 2006-12-13 13:18:38 [2554] [15] DEBUG: send_msg: sending msg to boxc: <smsbox-01> 2006-12-13 13:18:38 [2522] [6] DEBUG: SMPP[SMPP-01-FT]: Sending PDU: 2006-12-13 13:18:38 [2522] [6] DEBUG: SMPP PDU 0x82202e0 dump: 2006-12-13 13:18:38 [2522] [6] DEBUG: type_name: submit_sm 2006-12-13 13:18:38 [2522] [6] DEBUG: command_id: 4 = 0x00000004 2006-12-13 13:18:38 [2522] [6] DEBUG: command_status: 0 = 0x00000000 2006-12-13 13:18:38 [2522] [6] DEBUG: sequence_number: 55 = 0x00000037 2006-12-13 13:18:38 [2522] [6] DEBUG: service_type: NULL 2006-12-13 13:18:38 [2522] [6] DEBUG: source_addr_ton: 2 = 0x00000002 2006-12-13 13:18:38 [2522] [6] DEBUG: source_addr_npi: 1 = 0x00000001 2006-12-13 13:18:38 [2522] [6] DEBUG: source_addr: "16700" 2006-12-13 13:18:38 [2522] [6] DEBUG: dest_addr_ton: 1 = 0x00000001 2006-12-13 13:18:38 [2522] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 2006-12-13 13:18:38 [2522] [6] DEBUG: destination_addr: "3368485483" 2006-12-13 13:18:38 [2522] [6] DEBUG: esm_class: 3 = 0x00000003 2006-12-13 13:18:38 [2522] [6] DEBUG: protocol_id: 0 = 0x00000000 2006-12-13 13:18:38 [2522] [6] DEBUG: priority_flag: 0 = 0x00000000 2006-12-13 13:18:38 [2522] [6] DEBUG: schedule_delivery_time: "061213131838000+" 2006-12-13 13:18:38 [2522] [6] DEBUG: validity_period: "061213131838000+" 2006-12-13 13:18:38 [2522] [6] DEBUG: registered_delivery: 1 = 0x00000001 2006-12-13 13:18:38 [2522] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2006-12-13 13:18:38 [2522] [6] DEBUG: data_coding: 216 = 0x000000d8 2006-12-13 13:18:38 [2522] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2006-12-13 13:18:38 [2522] [6] DEBUG: sm_length: 4 = 0x00000004 2006-12-13 13:18:38 [2522] [6] DEBUG: short_message: "test 2006-12-13 13:18:38 [2522] [6] DEBUG: SMPP PDU dump ends. 2006-12-13 13:18:39 [2522] [6] DEBUG: SMPP[SMPP-01-FT]: Got PDU: 2006-12-13 13:18:39 [2522] [6] DEBUG: SMPP PDU 0x82202e0 dump: 2006-12-13 13:18:39 [2522] [6] DEBUG: type_name: submit_sm_resp 2006-12-13 13:18:39 [2522] [6] DEBUG: command_id: 2147483652 = 0x80000004 2006-12-13 13:18:39 [2522] [6] DEBUG: command_status: 0 = 0x00000000 2006-12-13 13:18:39 [2522] [6] DEBUG: sequence_number: 55 = 0x00000037 2006-12-13 13:18:39 [2522] [6] DEBUG: message_id: "74df3f8" 2006-12-13 13:18:39 [2522] [6] DEBUG: SMPP PDU dump ends. 2006-12-13 13:18:39 [2522] [6] DEBUG: DLR[pgsql]: Adding DLR smsc=SMPP-01-FT, ts=74df3f8, src="" dst=+3368485483, mask=31, boxc= 2006-12-13 13:18:39 [2522] [6] DEBUG: sql: INSERT INTO dlr (smsc, date, soa, da, service, url, mask, boxcid, status) VALUES ('SMPP-01-FT', '74df3f8', '16700', '+3368485483', '', ' http://localhost/kg/prvservlet/recdlr.php?&status=%d&answer=%A&ts=%t&msgid=3', '31', '', '0'); 2006-12-13 13:18:39 [2522] [6] DEBUG: SMSC[SMPP-01-FT]: creating DLR message 2006-12-13 13:18:39 [2522] [6] DEBUG: SMSC[SMPP-01-FT]: DLR = http://localhost/kg/prvservlet/recdlr.php?&status=%d&answer=%A&ts=%t&msgid=31 2006-12-13 13:18:39 [2582] [18] DEBUG: send_msg: sending msg to box: <127.0.0.1> 2006-12-13 13:18:39 [2582] [18] DEBUG: boxc_sender: sent message to <127.0.0.1> 2006-12-13 13:18:39 [2580] [17] DEBUG: boxc_receiver: got ack 2006-12-13 13:18:39 [2518] [2] DEBUG: HTTP: Creating HTTPClient for `127.0.0.1'. 2006-12-13 13:18:39 [2518] [2] DEBUG: HTTP: Created HTTPClient area 0x821f968. 2006-12-13 13:18:39 [2519] [3] DEBUG: sql: SELECT count(*) FROM dlr; 2006-12-13 13:18:39 [2519] [3] DEBUG: HTTP: Destroying HTTPClient area 0x821f968. 2006-12-13 13:18:39 [2519] [3] DEBUG: HTTP: Destroying HTTPClient for `127.0.0.1'. 2006-12-13 13:18:39 [2518] [2] DEBUG: HTTP: Creating HTTPClient for `127.0.0.1'. 2006-12-13 13:18:39 [2518] [2] DEBUG: HTTP: Created HTTPClient area 0x8220ee8. 2006-12-13 13:18:39 [2519] [3] DEBUG: sql: SELECT count(*) FROM dlr; 2006-12-13 13:18:39 [2519] [3] DEBUG: HTTP: Destroying HTTPClient area 0x8220ee8. 2006-12-13 13:18:39 [2519] [3] DEBUG: HTTP: Destroying HTTPClient for `127.0.0.1'. -[END: log snapshot]-------------------------------------- On 12/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi Fourat, I use sqlbox only for MT traffic no problems so far except WAP PUSH messages - cant deal with that so far for wap push and MT MSS in non Latin encoding - i use xml post anyway, i preset the bellow values for plain text Latin SMS before insert in pgsql db: $mclass=-1; $mwi=-1; $sms_type=0; $coding=0; $sms_type=0; try with these ... On Tue, Dec 12, 2006 at 06:53:45PM +0100, Fourat Zouari wrote: > I'm using sqlbox and it's sending MT and receiving MO, only one > problem is that the MTs are sent as flash message. > tryed to set the mclass field to 0,1,2 and 3, the message is allways a > flash one. > The message is stored in "sql-log-table" with those mclass values, so > nothing goes wrong, except it's a flash message. |
