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 |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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.
--
regards,
Anand Gupta
