Have you define the table and field in the configuration?
On Mar 31, 2011, at 6:56 PM, Deepak Kumar wrote: > 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." > # Willy Mularto F300HD+MR18DE (NLC1725)
