man i have no idea what can invoke such strange inserts,
from the logs i can tell its event triggered,
i hope its environment issue,in case you have no patches implemented on the
initial kannel source.
in general kannel reads once the configuration variables
what encoding is your configuration file ?
and, whats the lines coming from
fgrep -i select kannel.log | grep 5802
i.e. does kannel use the proper SMSC value when DLR comes ...
regards
seik
P.S.
move to posgtresql asap :)
very handy especially for MT charging based services ..
-----Original Message-----
From: Anand Gupta [EMAIL PROTECTED]
Sent: 23 Юни 2007 г.
To: seik
Subject:smsc name inside mysql dlr
> Hi Seik,
> Thanks for the reply.
> Here is the output as you asked.
> seik wrote:
> whats the output of
mysql>> show create table your_mysql_dlr_table
>
> +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
> | Table | Create Table
> & nbsp;
> & nbsp; |
> +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
> | dlr | CREATE TABLE `dlr` (
> `smsc` varchar(100) default NULL,
> `ts` varchar(100) default NULL,
> `destination` varchar(100) default NULL,
> `source` varchar(100) default NULL,
> `service` varchar(100) default NULL,
> `url` varchar(255) default NULL,
> `mask` int(10) default NULL,
> `status` int(10) default NULL,
> `boxc` varchar(40) default NULL
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
> +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
> 1 row in set (0.00 sec)
> i am using pgsql storage atm, but used to have mysql based as well
> can you paste several lines from that:
> fgrep -i insert path_to_logs/kannel.log
>
> My Provider is called ABCDEF inside smsc-id option of kannel.conf
> 2007-06-23 21:18:35 [3454] [6] DEBUG: sql: INSERT INTO dlr (smsc,
> ts, source, destination, service, url, mask, boxc, status) VALUES
> ('BCDEF', '5802', 'xxxxx', 'xxxxxx', 'xxxxx',
> 'http://www.xxxxx?type=%d&slid=25&uid=1', '31', '', '0');
> 2007-06-23 21:18:35 [3454] [6] DEBUG: sql: INSERT INTO dlr (smsc,
> ts, source, destination, service, url, mask, boxc, status) VALUES
> ('CDEF', '5803', 'xxxxxx', 'xxxxx', 'xxxxxx',
> 'http://www.xxxxxxx?type=%d&slid=26&uid=1', '31', '', '0');
> 2007-06-23 21:18:35 [3454] [6] DEBUG: sql: INSERT INTO dlr (smsc,
> ts, source, destination, service, url, mask, boxc, status) VALUES
> ('DEF', '5804', 'xxxxxx', 'xxxxxx', 'xxxxx',
> 'http://www.xxxxxxx?type=%d&slid=27&uid=1', '31', '', '0');
> 2007-06-23 21:18:35 [3454] [6] DEBUG: sql: INSERT INTO dlr (smsc,
> ts, source, destination, service, url, mask, boxc, status) VALUES
> ('EF', '5805', 'xxxxx', 'xxxxxx', 'xxxx',
> 'http://www.xxxxxxxx?type=%d&slid=28&uid=1', '31', '', '0');
> I also plan to move to postgresql, but would prefer to first resolve the
> above problem.
