Hi You need to store to your db by yourself within your app. The table defined in kannel config is only for temporary store of dlr. It usually stays empty
Regards Alvaro On 9/12/13, Faizan Mirza <efuz...@gmail.com> wrote: > Hello, > > I am sending you email because i have read your posts about Kannel SMS > Gateway. I hope i will get my answers here... > > Actually i want to run an Small SMS site for localhost, since long i was > using windows based server with ActiveXpert but now i want to play with > ubuntu i liked the interface and want to make sms gateway in ubuntu. I have > installed Kannel and extras but i dont know what is wrong with my > settings... > > *1. My Kannel.conf file is:* > > # CONFIGURATION FOR USING SMS KANNEL WITH RAPIDSMS > # > # For any modifications to this file, see Kannel User Guide > # If that does not help, see Kannel web page (http://www.kannel.org) and > # various online help and mailing list archives > # > # Notes on those who base their configuration on this: > # 1) check security issues! (allowed IPs, passwords and ports) > # 2) groups cannot have empty rows inside them! > # 3) read the user guide > > include = "/etc/kannel/modems.conf" > > #--------------------------------------------- > # CORE > # > # There is only one core group and it sets all basic settings > # of the bearerbox (and system). You should take extra notes on > # configuration variables like 'store-file' (or 'store-dir'), > # 'admin-allow-ip' and 'access.log' > > group = core > admin-port = 13000 > smsbox-port = 13001 > admin-password = bar > status-password = foo > dlr-storage = mysql > box-deny-ip = "*.*.*.*" > box-allow-ip = "127.0.0.1" > log-file = "/var/log/kannel/bearerbox.log" > log-level = 0 > > # DLR with MySQL support configuration > > group = mysql-connection > id = mydlr > host = localhost > username = root > password = xxxxx > database = kannel > > 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 > > #--------------------------------------------- > # SMSC CONNECTIONS > # > # SMSC connections are created in bearerbox and they handle SMSC specific > # protocol and message relying. You need these to actually receive and send > # messages to handset, but can use GSM modems as virtual SMSCs > # Here is a sample SMSC for use with the /usr/lib/kannel/test/fakesmsc > command > > > group = smsc > smsc = at > modemtype = auto > device=/dev/ttyUSB1 > my-number = xxxxxxxxxxxxx > sms-center= xxxxxxxxxxxxx > connect-allow-ip = 127.0.0.1 > log-level = 0 > > #--------------------------------------------- > # SMSBOX SETUP > # > # Smsbox(es) do higher-level SMS handling after they have been received > from > # SMS centers by bearerbox, or before they are given to bearerbox for > delivery > > group = smsbox > smsbox-id = mysmsc > bearerbox-host = 127.0.0.1 > sendsms-port = 13013 > global-sender = xxxxxxxxxxxxx > log-file = "/var/log/kannel/smsbox.log" > log-level = 0 > access-log = "/var/log/kannel/access.log" > http-request-retry = 3 > http-queue-delay = 10 > > # SEND-SMS USERS > # > # These users are used when Kannel smsbox sendsms interface is used to > # send PUSH sms messages, i.e. calling URL like > # http://localhost:13013/cgi-bin/sendsms?username=tester&password=foobar... > > # This is the username and password that RapidSMS uses to deliver SMSes to > # Kannel. It must also set the 'smsc' variable in the query string, so > that > # Kannel knows which SMSC to use to route the message. > > > group = sendsms-user > username = kannel > password = kannel > concatenation= true > > #--------------------------------------------- > # SERVICES > # > # These are 'responses' to sms PULL messages, i.e. messages arriving from > # handsets. The response is based on message content. Only one sms-service > is > # applied, using the first one to match. > > # The 'ping-kannel' service let's you check to see if Kannel is running, > # even if RapidSMS is offline for some reason. > > group = sms-service > keyword = default > catch-all = true > accept-x-kannel-headers = true > max-messages = 0 > get-url = "http://localhost/kannel/receivesms.php?sender=%p&text=%b"; > > *2. My Sqlbox.conf file Is: > > *group = sqlbox > id = sqlbox-db > smsbox-id = sqlbox > global-sender = "xxxxxxxxxx" > bearerbox-host = localhost > bearerbox-port = 13005 > smsbox-port = 13001 > smsbox-port-ssl = false > sql-log-table = sent_sms > sql-insert-table = send_sms > log-file = "/var/log/kannel/kannel-sqlbox.log" > log-level = 0 > #ssl-client-certkey-file = "" > #ssl-server-cert-file = "" > #ssl-server-key-file = "" > #ssl-trusted-ca-file = "" > > # Database connection examples. Please uncomment as needed > > # Example MYSQL Connection > group = mysql-connection > id = sqlbox-db > host = localhost > username = root > password = xxxxxxx > database = kannel > max-connections = 10* > > * > *3. Issues: > > * > Now when i send SMS to my device it does not come in mysql in both like DLR > and also in Kannel database.,.. > > When i send message through: > http://localhost:13013/cgi-bin/sendsms?username=kannel&password=kannel&to=xxxxxxxxx&text=hi%20buddy > ! > > > It send SMS but not adding in database... I have created service for smsbox > and bearerbox, when i start my server both services starts in background > and work fine just dont know why it has database issues and also when i try > to start sqlbox it shows: > > 2013-09-12 16:10:37 [16231] [0] INFO: MYSQL: Connected to server at > localhost. > 2013-09-12 16:10:37 [16231] [0] INFO: MYSQL: server version > 5.5.32-0ubuntu0.12.04.1, client version 5.5.32. > 2013-09-12 16:10:37 [16231] [0] DEBUG: Started thread 1 > (sqlbox.c:sql_to_bearerbox) > 2013-09-12 16:10:37 [16231] [0] ERROR: bind failed > 2013-09-12 16:10:37 [16231] [0] ERROR: System error 98: Address already in > use > 2013-09-12 16:10:37 [16231] [0] PANIC: Could not open sqlbox port 13001 > 2013-09-12 16:10:37 [16231] [0] PANIC: sqlbox(gw_panic+0xd2) [0x80745d2] > 2013-09-12 16:10:37 [16231] [0] PANIC: sqlbox(main+0x5c0) [0x8050a40] > 2013-09-12 16:10:37 [16231] [0] PANIC: > /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6e7e4d3] > 2013-09-12 16:10:37 [16231] [0] PANIC: sqlbox() [0x8050ad5] > > Please tell me where i am wrong? I am using Ubuntu 12.04 LTS. If you will > help me for an PHP sms form too i shall be thankful. Where users write > their name recipient number and message and press send sms go to recipient > number and also save in database.... > -- |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.NET www.smsglobal.com.mx y www.pravcom.com
