You need to make following chain via ports connection: BBOX <-> SQLBOX <-> SMSBOX
Should make smsbox connect to sqlbox in order to get incoming SMS into sqlbox table. On Mon, Feb 1, 2016 at 8:45 PM, joe schacher <[email protected]> wrote: > Ok thank you. Unfortunately, incoming messages are not appearing in > sent_sms. Outgoing works well. > > I can see that messages are being retrieved from sim card memory in > bearer_box, but they are not transferred to mysql database. > > I am also receiving the error sms_list is empty! I tried setting > sim_buffering to false, and the error went away, but then i didn't receive > any messages at all, so I set it back to true. > > I'm not sure if it is necessary to run smsbox. Is it ok to run sqlbox and > bearerbox and do everything through the database? > > Thank you very much for the help! > > ----------smskannel.conf----------------- > > > group = core > admin-port = 13000 > smsbox-port = 13002 > admin-password = bar > status-password = foo > log-file = "/tmp/kannel.log" > log-level = 0 > box-deny-ip = "*.*.*.*" > box-allow-ip = "127.0.0.1" > dlr-storage=mysql > > > group = smsc > smsc-id = modem-gsm > smsc = at > modemtype = auto > device=/dev/ttyUSB0 > my-number = 2269381968 > connect-allow-ip = 127.0.0.1 > log-level = 0 > sim-buffering=true > # if sim has pin > # pin = 6524 > > > group = modems > id = huawei-e303 > detect-string = "E303" > message-storage = sm > message-start = 0 > enable-hwhs= > #hardware-flow-control = false > init-string = "AT+CNMI=2,1,2,2,0" > > group = smsbox > smsbox-id=mysmsbox > bearerbox-host = 127.0.0.1 > sendsms-port = 13013 > bearerbox-port=13005 > global-sender = myphonenumberishere > log-level = 0 > > group = sendsms-user > username = sms-app > password = app125 > concatenation= true > max-messages = 10 > > group = mysql-connection > id = mydlr > host = 127.0.0.1 > username = kannel > password = ************* > database = kannel > max-connections = 10 > > > 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 > > group = sms-service > keyword = nop > text = "you asked for nothing and i did it!" > catch-all=true > > group=sms-service > keyword=default > get-url="http://localhost/receivesms?phone=%p&text=%a"; > > > > ------sqlbox.conf---------- > > > # SQL BOX CONFIG > group = sqlbox > id = sqlbox-db > smsbox-id = sqlsmsbox > global-sender = "" > bearerbox-host = 127.0.0.1 > bearerbox-port = 13002 > smsbox-port = 13005 > smsbox-port-ssl = false > sql-log-table = sent_sms > sql-insert-table = send_sms > > group = mysql-connection > id = sqlbox-db > > username = kannel > password = ************** > database = kannel > host = 127.0.0.1 > max-connections=1 > > >
