Dear Rene, Thanks for your confirmation. Do you aware of any plan in making wapbox use sqlbox as bearerbox like smsbox does?
Best regards, Rayson Lee InnoAge Hong Kong Limited -----Original Message----- From: Rene Kluwen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 09, 2006 6:16 AM To: Rayson Lee; [email protected] Subject: RE: sqlbox does not log WAP Push traffic Rayson, You are not wrong. It is exactly like that. Rene Kluwen Chimit -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rayson Lee Sent: woensdag 8 maart 2006 21:58 To: [email protected] Subject: RE: sqlbox does not log WAP Push traffic Dear Coco, If I understand correctly, wapbox IS NOT sqlbox aware! It sends WAP Push message directly to bearerbox for delivery instead of going through smsbox, which is sqlbox aware. Therefore WAP Push traffic will not be logged. Please let me know if I'm wrong. Best regards, Rayson Lee InnoAge Hong Kong Limited -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Coco King Sent: Thursday, March 09, 2006 2:54 AM To: [email protected] Subject: RE: sqlbox does not log WAP Push traffic Dear list, I checked the CVS head source code of sqlbox and confirmed the field types are all correct. I also tried enable logging in the mysql_save_msg function (where data will be written to the SMS sent log) and found that the function was not triggered during WAP Push. So it seems the problem was not caused by database setting as Alejandro suspected. However I'm not familiar with the system and it's very difficult for me to trace the root cause. Any one can give me some hints? Thanks for your help in advance. Coco -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Coco King Sent: Wednesday, March 08, 2006 10:50 AM To: 'Alejandro Ramirez' Cc: [email protected] Subject: RE: sqlbox does not log WAP Push traffic Dear Alejandro, Thanks for your reply. I checked my database settings, msgdata and udhdata are already defined as blob and text. Would other field types matter? I have included the create table script below. Please help check against yours. CREATE TABLE `sent_sms` ( `sql_id` bigint(20) NOT NULL auto_increment, `momt` enum('MO','MT') default NULL, `sender` varchar(20) default NULL, `receiver` varchar(20) default NULL, `udhdata` blob, `msgdata` text, `time` bigint(20) default NULL, `smsc_id` varchar(255) default NULL, `service` varchar(255) default NULL, `account` varchar(255) default NULL, `id` bigint(20) default NULL, `sms_type` bigint(20) default NULL, `mclass` bigint(20) default NULL, `mwi` bigint(20) default NULL, `coding` bigint(20) default NULL, `compress` bigint(20) default NULL, `validity` bigint(20) default NULL, `deferred` bigint(20) default NULL, `dlr_mask` bigint(20) default NULL, `dlr_url` varchar(255) default NULL, `pid` bigint(20) default NULL, `alt_dcs` bigint(20) default NULL, `rpi` bigint(20) default NULL, `charset` varchar(255) default NULL, `boxc_id` varchar(255) default NULL, `binfo` varchar(255) default NULL, PRIMARY KEY (`sql_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Thanks & regards, Coco -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alejandro Ramirez Sent: Wednesday, March 08, 2006 12:12 AM To: [EMAIL PROTECTED] Cc: [email protected] Subject: Re: sqlbox does not log WAP Push traffic Coco, In my particular case i found out that what was happening is that i UPGRADED from previous SQLBOX version... so the msgdata, and udhdata fields existed already in table as varchar(255), and when installing from CVS head i did not create from scratch the table. So i just had to change the type of this fields into blob and text. Now all the msgs get logged! Hope this helps, Alejandro Ramirez Coco King wrote: >Hi, > >I tried download the latest CVS, problem still persist. Any one can help? > >Many thanks, > >Coco > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf >Of Alejandro Ramirez >Sent: Monday, January 23, 2006 10:38 PM >To: [EMAIL PROTECTED] >Cc: [email protected] >Subject: Re: sqlbox does not log WAP Push traffic > >Coco, > > I've read somewhere that the problem was that the UDH was >being saved into a type of field that was not correct for the size (or >type) of the UDH in a wap push. It was suppoused to be fixed, but i >built from CVS last week and also found the same problem. Maybe Rene can >help us out? > > >Greetings > >Alejandro > > >Coco King wrote: > > > >>Anyone knows why sqlbox is not logging WAP Push traffic? Is it a design >>problem or bug? Or something wrong in my setup? >> >>Thanks for your help in advance. >> >>Coco >> >>__________________________________________________ >>Do You Yahoo!? >>Tired of spam? Yahoo! Mail has the best spam protection around >>http://mail.yahoo.com >> >> >> >> >> >> >> > > > > >__________________________________________________ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam protection around >http://mail.yahoo.com > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
