the normal state of the dlr storage table is empty
once the final state of the requested dlr is received the record will deleted
..
set the dlr mask to 31 , set the logs to be in debug mode, and check the logs
example:
2007-08-07 04:17:04 [21623] [6] DEBUG: DLR[pgsql]: Adding DLR smsc=BTC,
ts=291233444, src=1912, dst=+359885100407, mask=31, boxc=
2007-08-07 04:17:04 [21623] [6] DEBUG: sql: INSERT INTO dlr (smsc, ts, source,
destination, service, url, mask, boxc, status) VALUES ('BTC', '291233444',
'1912', '+359885100407', 'ZULU',
'http://localhost/dlr.pgsql.php?smscID=%i&dlr=%d&answer=%A&to=%p&from=%P&ts=%T&smsID=14ef2db77a4987c88f67e4753d1d2dc7&charset=%C&kannel_id=%I',
'31', '', '0');
2007-08-07 04:17:04 [21623] [6] DEBUG: SMSC[BTC]: creating DLR message
2007-08-07 04:17:04 [21623] [6] DEBUG: SMSC[BTC]: DLR =
http://localhost/dlr.pgsql.php?smscID=%i&dlr=%d&answer=%A&to=%p&from=%P&ts=%T&smsID=14ef2db77a4987c88f67e4753d1d2dc7&charset=%C&kannel_id=%I
2007-08-07 04:17:09 [21623] [7] DEBUG: SMPP[BTC] handle_pdu, got DLR
2007-08-07 04:17:09 [21623] [7] DEBUG: SMPP[BTC]: Couldnot parse DLR string
sscanf way,fallback to old way. Please report!
2007-08-07 04:17:09 [21623] [7] DEBUG: DLR[pgsql]: Looking for DLR smsc=BTC,
ts=291233444, dst=359885100407, type=1
2007-08-07 04:17:09 [21623] [7] DEBUG: sql: SELECT mask, service, url, source,
destination, boxc FROM dlr WHERE smsc='BTC' AND ts='291233444' LIMIT 1;
2007-08-07 04:17:09 [21623] [7] DEBUG: Found entry, col1=31, col2=ZULU,
col3=http://localhost/dlr.pgsql.php?smscID=%i&dlr=%d&answer=%A&to=%p&from=%P&ts=%T&smsID=14ef2db77a4987c88f67e4753d1d2dc7&charset=%C&kannel_id=%I,
col4=1912, col5=+359885100407 col6=
2007-08-07 04:17:09 [21623] [7] DEBUG: DLR[pgsql]: created DLR message for URL
<http://localhost/dlr.pgsql.php?smscID=%i&dlr=%d&answer=%A&to=%p&from=%P&ts=%T&smsID=14ef2db77a4987c88f67e4753d1d2dc7&charset=%C&kannel_id=%I>
2007-08-07 04:17:09 [21623] [7] DEBUG: removing DLR from database
2007-08-07 04:17:09 [21623] [7] DEBUG: sql: DELETE FROM dlr WHERE oid = (SELECT
oid FROM dlr WHERE smsc='BTC' AND ts='291233444' LIMIT 1);
cheers
-----Original Message-----
From: Tulga.G [EMAIL PROTECTED]
Sent: 07 Август 2007 г.
To: seik
Subject:DLR and MySQL
> Did you add dlr-storage = mysql line to core group?
> On 8/7/07, Nicholas Amorim <[EMAIL PROTECTED] > wrote:
> Hello people! I'm new on this Kannel/SMS stuff, but I managed
> Kannel to work 100% with what I need (send SMS through a sms center using
> smpp).
> But I still got one problem, I set it all in kannel.conf to use
> mysql as a dlr storage, but the table still empty. Nothing seems to
> be wrong in the log. My conf below:
> group = mysql-connection
> id = mydlr
> host = localhost
> username = kannel
> password = somepassword
> database = dlr
> max-connections = 1
> group = dlr-db
> id = mydlr
> table = dlr
> field-smsc = smsc
> field-timestamp = ts
> field-destination = destination
> field-source = source
> field-service = service
> field-url = url
> field-mask = mask
> field-status = status
> field-boxc-id = boxc
> Nicholas Amorim.
