Hi Cezary, Yes we have compiled the kannel with mysql support and it shows the status "Compiled with SSL, MySql and native calloc.
below is the attached log of my bearerbox when we shutdown the modem. after this i will enable "dlr-storage = mysql" 2011-03-31 17:03:09 [12390] [0] WARNING: Killing signal or HTTP admin command received, shutting down... 2011-03-31 17:03:09 [12390] [0] DEBUG: Shutting down Kannel... 2011-03-31 17:03:09 [12390] [0] DEBUG: shutting down smsc 2011-03-31 17:03:09 [12390] [0] DEBUG: AT2[/dev/ttyS0]: Shutting down SMSCConn, slow 2011-03-31 17:03:09 [12390] [0] DEBUG: shutting down udp 2011-03-31 17:03:09 [12390] [10] DEBUG: Thread 10 (gw/bb_udp.c:udp_receiver) terminates. 2011-03-31 17:03:09 [12390] [8] DEBUG: Thread 8 (gw/bb_udp.c:udp_receiver) terminates. 2011-03-31 17:03:09 [12390] [11] DEBUG: Thread 11 (gw/bb_udp.c:udp_sender) terminates. 2011-03-31 17:03:09 [12390] [9] DEBUG: Thread 9 (gw/bb_udp.c:udp_sender) terminates. 2011-03-31 17:03:10 [12390] [7] DEBUG: Thread 7 (gw/bb_smscconn.c:sms_router) terminates. 2011-03-31 17:03:10 [12390] [4] DEBUG: Thread 4 (gw/bb_boxc.c:sms_to_smsboxes) terminates. 2011-03-31 17:03:10 [12390] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run) terminates. 2011-03-31 17:03:10 [12390] [0] INFO: All flow threads have died, killing core 2011-03-31 17:03:10 [12390] [0] DEBUG: Waiting for 2 (gwlib/http.c:server_thread) to terminate 2011-03-31 17:03:10 [12390] [3] DEBUG: HTTP: No clients with requests, quitting. 2011-03-31 17:03:10 [12390] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run) terminates. 2011-03-31 17:03:10 [12390] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread) terminates. 2011-03-31 17:03:10 [12390] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) terminates. 2011-03-31 17:03:10 [12390] [0] DEBUG: final clean-up for SMSCConn 2011-03-31 17:03:10 [12390] [0] DEBUG: smsbox MO concatenated message handling cleaned up 2011-03-31 17:03:10 [12390] [0] INFO: Total WDP messages: received 0, sent 0 2011-03-31 17:03:10 [12390] [0] INFO: Total SMS messages: received 0, sent 0 2011-03-31 17:03:10 [12390] [0] DEBUG: Immutable octet strings: 219. still the bearerbox log is same. i think due to changes in core group bearerbox not start. and if i comment "dlr-storage = mysql" then bearerebox will work fine see log 2011-03-31 17:07:04 [12460] [0] INFO: Added logfile `/var/log/kannel/bearerbox.log' with level `0'. 2011-03-31 17:07:04 [12460] [0] INFO: Started access logfile `/var/log/kannel/access.log'. 2011-03-31 17:07:04 [12460] [0] INFO: HTTP: Opening server at port 13000. 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 1 (gwlib/fdset.c:poller) 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 2 (gwlib/http.c:server_thread) 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 3 (gw/bb_http.c:httpadmin_run) 2011-03-31 17:07:04 [12460] [0] DEBUG: starting smsbox connection module 2011-03-31 17:07:04 [12460] [0] INFO: BOXC: 'smsbox-max-pending' not set, using default (100). 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 4 (gw/bb_boxc.c:sms_to_smsboxes) 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 5 (gw/bb_boxc.c:smsboxc_run) 2011-03-31 17:07:04 [12460] [0] INFO: Set SMS resend frequency to 60 seconds. 2011-03-31 17:07:04 [12460] [0] INFO: SMS resend retry set to unlimited. 2011-03-31 17:07:04 [12460] [0] DEBUG: smsbox MO concatenated message handling enabled 2011-03-31 17:07:04 [12460] [0] INFO: DLR rerouting for smsc id <(null)> disabled. 2011-03-31 17:07:04 [12460] [0] INFO: Added logfile `/var/log/kannel/modem.log' with level `0'. 2011-03-31 17:07:04 [12460] [0] INFO: AT2[/dev/ttyS0]: configuration shows modemtype <siemens_mc52i> 2011-03-31 17:07:04 [12460] [0] DEBUG: AT2[/dev/ttyS0]: Reading modem definitions from </etc/kannel/kannel.conf> 2011-03-31 17:07:04 [12460] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run) maps to pid 12460. 2011-03-31 17:07:04 [12460] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run) maps to pid 12460. 2011-03-31 17:07:04 [12460] [0] DEBUG: Loading include file `/etc/kannel/modems.conf' (on line 55 of file /etc/kannel/kannel.conf). 2011-03-31 17:07:04 [12460] [0] DEBUG: AT2[/dev/ttyS0]: Found <15> modems in config 2011-03-31 17:07:04 [12460] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread) maps to pid 12460. 2011-03-31 17:07:04 [12460] [4] DEBUG: Thread 4 (gw/bb_boxc.c:sms_to_smsboxes) maps to pid 12460. 2011-03-31 17:07:04 [12460] [0] INFO: AT2[/dev/ttyS0]: read modem definition for <Siemens MC52i> 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 6 (gw/smsc/smsc_at.c:at2_device_thread) 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 7 (gw/bb_smscconn.c:sms_router) 2011-03-31 17:07:04 [12460] [0] DEBUG: starting UDP sender/receiver module 2011-03-31 17:07:04 [12460] [0] INFO: Adding interface * 2011-03-31 17:07:04 [12460] [0] DEBUG: udpc_create: Bound to UDP <0.0.0.0:9200> 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 8 (gw/bb_udp.c:udp_receiver) 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 9 (gw/bb_udp.c:udp_sender) 2011-03-31 17:07:04 [12460] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) maps to pid 12460. 2011-03-31 17:07:04 [12460] [7] DEBUG: Thread 7 (gw/bb_smscconn.c:sms_router) maps to pid 12460. 2011-03-31 17:07:04 [12460] [0] DEBUG: udpc_create: Bound to UDP <0.0.0.0:9201> 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 10 (gw/bb_udp.c:udp_receiver) 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 11 (gw/bb_udp.c:udp_sender) 2011-03-31 17:07:04 [12460] [0] DEBUG: starting wapbox connection module 2011-03-31 17:07:04 [12460] [0] ERROR: Missing wapbox-port variable, cannot start WAP 2011-03-31 17:07:04 [12460] [0] DEBUG: starting WDP router 2011-03-31 17:07:04 [12460] [0] DEBUG: Started thread 12 (gw/bearerbox.c:wdp_router) 2011-03-31 17:07:04 [12460] [0] INFO: ---------------------------------------- 2011-03-31 17:07:04 [12460] [0] INFO: Kannel bearerbox II version 1.4.3 starting 2011-03-31 17:07:04 [12460] [0] INFO: MAIN: Start-up done, entering mainloop 2011-03-31 17:07:04 [12460] [0] DEBUG: AT2[/dev/ttyS0]: start called 2011-03-31 17:07:04 [12460] [8] DEBUG: Thread 8 (gw/bb_udp.c:udp_receiver) maps to pid 12460. 2011-03-31 17:07:04 [12460] [10] DEBUG: Thread 10 (gw/bb_udp.c:udp_receiver) maps to pid 12460. 2011-03-31 17:07:04 [12460] [11] DEBUG: Thread 11 (gw/bb_udp.c:udp_sender) maps to pid 12460. 2011-03-31 17:07:04 [12460] [9] DEBUG: Thread 9 (gw/bb_udp.c:udp_sender) maps to pid 12460. 2011-03-31 17:07:04 [12460] [12] DEBUG: Thread 12 (gw/bearerbox.c:wdp_router) maps to pid 12460. 2011-03-31 17:07:04 [12460] [12] DEBUG: udp_die: removing producers from udp-lists 2011-03-31 17:07:04 [12460] [12] DEBUG: Thread 12 (gw/bearerbox.c:wdp_router) terminates. 2011-03-31 17:07:04 [12460] [6] DEBUG: Thread 6 (gw/smsc/smsc_at.c:at2_device_thread) maps to pid 12460. 2011-03-31 17:07:04 [12460] [6] INFO: Logging thread `6' to logfile `/var/log/kannel/modem.log' with level `0'. 2011-03-31 17:07:04 [12460] [5] INFO: Client connected from <127.0.0.1> 2011-03-31 17:07:04 [12460] [5] DEBUG: Started thread 13 (gw/bb_boxc.c:function) 2011-03-31 17:07:04 [12460] [13] DEBUG: Thread 13 (gw/bb_boxc.c:function) maps to pid 12460. 2011-03-31 17:07:04 [12460] [13] DEBUG: Started thread 14 (gw/bb_boxc.c:boxc_sender) 2011-03-31 17:07:04 [12460] [14] DEBUG: Thread 14 (gw/bb_boxc.c:boxc_sender) maps to pid 12460. From: Cezary Siwek <cza...@thebestisp.co.uk> To: users@kannel.org Date: 03/31/2011 04:01 PM Subject: Re: Facing issue with DLR using MySql Sent by: users-boun...@kannel.org Hi, Have you compiled the kannel with mysql support? what logs says when you start the kannel with "dlr-storage = mysql"? BR, Cezary On 31/03/2011 11:25, Deepak Kumar wrote: > Dear Team, > > My system information is as follow : > > Operating system and version. Ubantu V10.10 > Kannel version. 1.4.3 > Libxml version. 2.30.0 > Used client : SMS Client (I am using GSM modem Cinterion MC52i) > Single or multi processor machine. Multi Processor > Attach Kannel configuration file > > We are facing an issue while configuring the DLR storage. Whenever we > used "dlr-storage = mysql" the kannel will stop to work and smsc will > not work. after removing the above statement "dlr-storage = mysql" the > kannel will work fine and i am able to send and receive sms on my Modem. > > I have also check that our kannel is compiled with mysql support. > > Find my kannel and dlr, mysql database setting with this mail. > > > > > we are struggling from a week with this problem. Please help us. > > In case of any query please let us know. > > > > Regards > > Deepak > > # > " 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." > # # " 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." #
