Re: smsc name inside mysql dlr

[Anand Gupta]

Hi Seik,

seik wrote:
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.
  
The same thing is beating the hell out of me ;)
I am using debian deb, not compiled from source.
in general kannel reads once the configuration variables
what encoding is your configuration file ?
  
Can you please explain what does this mean ?
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 ...
  
Here is the log entry

2007-06-23 21:18:36 [3454] [6] DEBUG: sql: SELECT mask, service, url, 
source, destination, boxc FROM dlr WHERE smsc='EF' AND ts='5802';

See in the initial Insert, kannel inserted 'BCDEF', however incase of 
Select, its looking for 'EF' and this caused it to fail to register the 
delivery of the message.
P.S.
move to posgtresql asap :)
very handy especially for MT charging based services ..
  
Would you mind sharing the postgresql setup part ? I will try that out.

Thanks again for all the help, appreciate it.
-----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.
    



  

--
regards,

Anand Gupta