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....
