Hi,
Maybe you have misunderstood purpose of the dlr-storage?
The internal DLR mechanism doesn't store incoming messages a database.
If you want to do so, have a look on sqlbox.
Regards,
Cezary
On 05/04/2011 10:05, Deepak Kumar wrote:
Dear All,
Now Kannel is running fine with dlr-storage = mysql but it will not
able to store the data into data base, when kannel receive any sms it
will not store any more in data base. the smsbox will have following log.
2011-04-05 14:30:28 [9340] [0] DEBUG: Started thread 4
(gw/smsbox.c:obey_request_thread)
2011-04-05 14:30:28 [9340] [0] DEBUG: Started thread 5
(gw/smsbox.c:url_result_thread)
2011-04-05 14:30:28 [9340] [0] DEBUG: Started thread 6
(gw/smsbox.c:http_queue_thread)
2011-04-05 14:30:28 [9340] [0] INFO: Connected to bearerbox at
localhost port 13001.
2011-04-05 14:30:28 [9340] [0] DEBUG: Started thread 7
(gw/heartbeat.c:heartbeat_thread)
2011-04-05 14:30:28 [9340] [3] DEBUG: Thread 3
(gw/smsbox.c:sendsms_thread) maps to pid 9340.
2011-04-05 14:30:28 [9340] [2] DEBUG: Thread 2
(gwlib/http.c:server_thread) maps to pid 9340.
2011-04-05 14:30:28 [9340] [4] DEBUG: Thread 4
(gw/smsbox.c:obey_request_thread) maps to pid 9340.
2011-04-05 14:30:28 [9340] [7] DEBUG: Thread 7
(gw/heartbeat.c:heartbeat_thread) maps to pid 9340.
2011-04-05 14:30:28 [9340] [6] DEBUG: Thread 6
(gw/smsbox.c:http_queue_thread) maps to pid 9340.
2011-04-05 14:30:28 [9340] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller)
maps to pid 9340.
2011-04-05 14:30:28 [9340] [5] DEBUG: Thread 5
(gw/smsbox.c:url_result_thread) maps to pid 9340.
2011-04-05 14:30:30 [9360] [0] INFO: Added logfile
`/var/log/kannel/smsbox.log' with level `0'.
2011-04-05 14:30:30 [9360] [0] INFO: HTTP: Opening server at port 13131.
2011-04-05 14:30:30 [9360] [0] ERROR: bind failed
2011-04-05 14:30:30 [9360] [0] ERROR: System error 98: Address already
in use
2011-04-05 14:30:30 [9360] [0] PANIC: Failed to open HTTP socket
2011-04-05 14:30:30 [9360] [0] PANIC: smsbox(gw_panic+0xcd) [0x808897d]
2011-04-05 14:30:30 [9360] [0] PANIC: smsbox(main+0x1344) [0x80543c4]
2011-04-05 14:30:30 [9360] [0] PANIC:
/lib/libc.so.6(__libc_start_main+0xe7) [0x275ce7]
2011-04-05 14:30:30 [9360] [0] PANIC: smsbox() [0x80528d1]
2011-04-05 14:30:31 [9361] [0] INFO: Added logfile
`/var/log/kannel/smsbox.log' with level `0'.
2011-04-05 14:30:31 [9361] [0] INFO: HTTP: Opening server at port 13131.
2011-04-05 14:30:31 [9361] [0] ERROR: bind failed
2011-04-05 14:30:31 [9361] [0] ERROR: System error 98: Address already
in use
2011-04-05 14:30:31 [9361] [0] PANIC: Failed to open HTTP socket
2011-04-05 14:30:31 [9361] [0] PANIC: smsbox(gw_panic+0xcd) [0x808897d]
2011-04-05 14:30:31 [9361] [0] PANIC: smsbox(main+0x1344) [0x80543c4]
2011-04-05 14:30:31 [9361] [0] PANIC:
/lib/libc.so.6(__libc_start_main+0xe7) [0x4f3ce7]
2011-04-05 14:30:31 [9361] [0] PANIC: smsbox() [0x80528d1]
Here is my data base conf
host = 127.0.0.1
username = xx
password = xx
port = 3306
database = dlr
max-connections = 10
#Data base properties
group = dlr-db
id = mydlr
table = storedlr
field-smsc = smsc
field-timestamp = timestamp
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
My data base table info is that
data base name is dlr table name is storedlr
Any idea ?? why this problem occur ?
----- Forwarded by Deepak Kumar/DEL/ORGA on 04/05/2011 02:17 PM -----
From: Deepak Kumar/DEL/ORGA
To: [email protected]
Date: 04/05/2011 12:51 PM
Subject: dlr storage problem-urgent help needed
------------------------------------------------------------------------
Dear All,
When i used the dlr-storage=mysql
bearer box give the following problem
2011-04-05 12:44:04 [6916] [3] PANIC: /lib/libpthread.so.0(+0x5cc9)
[0x74ecc9]
2011-04-05 12:44:04 [6916] [3] PANIC: /lib/libc.so.6(clone+0x5e)
[0xa5e6ae]
2011-04-05 12:44:04 [6921] [0] INFO: Added logfile
`/var/log/kannel/bearerbox.lo g' with level `0'.
2011-04-05 12:44:04 [6921] [0] INFO: Started access logfile
`/var/log/kannel/acc ess.log'.
2011-04-05 12:44:04 [6921] [0] INFO: HTTP: Opening server at port 13000.
2011-04-05 12:44:04 [6921] [0] ERROR: bind failed
2011-04-05 12:44:04 [6921] [0] ERROR: System error 98: Address already
in use
2011-04-05 12:44:04 [6921] [0] DEBUG: Started thread 1
(gw/bb_http.c:httpadmin_r un)
2011-04-05 12:44:04 [6921] [1] DEBUG: Thread 1
(gw/bb_http.c:httpadmin_run) maps to pid 6921.
2011-04-05 12:44:04 [6921] [1] DEBUG: HTTP: No clients with requests,
quitting.
2011-04-05 12:44:04 [6921] [1] DEBUG: Thread 1
(gw/bb_http.c:httpadmin_run) term inates.
2011-04-05 12:44:04 [6921] [0] DEBUG: starting smsbox connection module
2011-04-05 12:44:04 [6921] [0] INFO: BOXC: 'smsbox-max-pending' not
set, using d efault (100).
2011-04-05 12:44:04 [6921] [0] DEBUG: Started thread 2
(gw/bb_boxc.c:sms_to_smsb oxes)
2011-04-05 12:44:04 [6921] [2] DEBUG: Thread 2
(gw/bb_boxc.c:sms_to_smsboxes) ma ps to pid 6921.
2011-04-05 12:44:04 [6921] [0] DEBUG: Started thread 3
(gw/bb_boxc.c:smsboxc_run )
2011-04-05 12:44:04 [6921] [3] DEBUG: Thread 3
(gw/bb_boxc.c:smsboxc_run) maps t o pid 6921.
2011-04-05 12:44:04 [6921] [3] ERROR: bind failed
2011-04-05 12:44:04 [6921] [3] ERROR: System error 98: Address already
in use
2011-04-05 12:44:04 [6921] [0] INFO: Set SMS resend frequency to 60
seconds.
2011-04-05 12:44:04 [6921] [3] PANIC: Could not open smsbox port 13001
2011-04-05 12:44:04 [6921] [0] INFO: SMS resend retry set to unlimited.
2011-04-05 12:44:04 [6921] [0] DEBUG: smsbox MO concatenated message
handling en abled
2011-04-05 12:44:04 [6921] [0] INFO: DLR rerouting for smsc id
<(null)> disabled .
2011-04-05 12:44:04 [6921] [3] PANIC: bearerbox(gw_panic+0xcd)
[0x80d088d]
2011-04-05 12:44:04 [6921] [3] PANIC: bearerbox() [0x8058438]
2011-04-05 12:44:04 [6921] [0] INFO: Added logfile
`/var/log/kannel/modem.log' w ith level `0'.
2011-04-05 12:44:04 [6921] [3] PANIC: bearerbox() [0x80c70cd]
2011-04-05 12:44:04 [6921] [3] PANIC: /lib/libpthread.so.0(+0x5cc9)
[0xbdfcc9]
2011-04-05 12:44:04 [6921] [3] PANIC: /lib/libc.so.6(clone+0x5e)
[0xa916ae]
Yesterday i have again compiled installed kannel 1.4.3 with mysql
support but still having the same problem, is this is the problem is
code ??or somewhere i m lacking in my configuration. see below my
modem setting..
*group = mysql-connection*
id = mydlr
host = localhost
username = root
password = root
port = 3306
database = dlr
max-connections = 1
#Data base properties
group = dlr-db
id = mydlr
*table = storedlr*
field-smsc = smsc
field-timestamp = timestamp
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxcid = boxcid
log-file = "/var/log/kannel/dlr-mysql.log"
group = core
admin-port = 13000
smsbox-port = 13001
box-allow-ip = "127.0.0.1"
admin-password = xx
#status-passwortd = xx
#admin-deny-ip = "*.*.*.*"
admin-allow-ip = "127.0.0.1"
#wapbox-port = 13002
wdp-interface-name = "*"
#log-file = "/tmp/kannel/bearerbox.log"
#access-log = "/tmp/kannel/access.log"
log-file = "/var/log/kannel/bearerbox.log"
access-log = "/var/log/kannel/access.log"
#log-level = 4
*dlr-storage = mysql*
#box-deny-ip = "*.*.*.*"
#box-allow-ip = "127.0.0.1"
#group = wapbox
#bearerbox-host = localhost
#log-file = "/var/log/kannel/wapbox.log"
# Siemens Modem
group = smsc
smsc = at
modemtype = siemens_mc52i
device = /dev/ttyS0
speed = 9600
log-file = "/var/log/kannel/modem.log"
# SMSBOX SETUP
group = smsbox
bearerbox-host = localhost
sendsms-port = 13131
sendsms-chars = "0123456789 +-"
log-file = "/var/log/kannel/smsbox.log"
#log-level = 4
#log-file = "/tmp/kannel/smsbox.log"
group = sendsms-user
username = UTE
password = cattest
include = "/etc/kannel/modems.conf"
*include = "/etc/kannel/dlr-mysql.conf"*
*Please suggest some possible solution. *
#
" Ce courriel et les documents qui lui sont joints peuvent contenir des informations
confidentielles ou ayant un caractère privé. S'ils ne vous sont pas destinés, nous vous
signalons qu'il est strictement interdit de les divulguer, de les reproduire ou d'en
utiliser de quelque manière que ce soit le contenu. Si ce message vous a été transmis par
erreur, merci d'en informer l'expéditeur et de supprimer immédiatement de votre système
informatique ce courriel ainsi que tous les documents qui y sont attachés."
******
" This e-mail and any attached documents may contain confidential or proprietary
information. If you are not the intended recipient, you are notified that any
dissemination, copying of this e-mail and any attachments thereto or use of their
contents by any means whatsoever is strictly prohibited. If you have received this e-mail
in error, please advise the sender immediately and delete this e-mail and all attached
documents from your computer system."
#
