Are you sure that for records in the OUT table, you've set: 1) The "gateway_id" to "*" value? 2) The "status" to "U"?
On Mar 20, 6:36 pm, vijayjain <[email protected]> wrote: > Hi, > > I have created the tables as mentiond in below > linkhttp://smslib.org/doc/smsserver/interfaces/database/ > > Still i am not able to send messege, when i am starting SMSserver it > save all my SIM card 5 (stored in SIM) messeges to smssvr_in table > but no messege goes out (no entery in smssvr_out table) their is no > exception also runing perfectly fine. when i am sending new message > from mobile it again store in smssvr_in table but not in smssvr_out > table. my configuration is below. > > Please tell that any other configration is required to send messege > out like XML etc......or in congig file. > > gateway.0=*, SerialModem > *.port=COM4 > *.baudrate=115200 > *.manufacturer=WAVECOM MODEM > *.model=MULTIBAND 900E 1800 > *.protocol=PDU > *.pin=0000 > *.inbound=yes > *.outbound=yes > *.init_string=ATZ\rATZ\rATZ\r > > interface.0=db1, Database > db1.type=mysql > db1.url=jdbc:mysql://localhost:3306/smslib?autoReconnect=true > db1.driver=com.mysql.jdbc.Driver > db1.username=smslib > db1.password=smslib > db1.tables.sms_in=smssvr_in > db1.tables.sms_out=smssvr_out > db1.tables.calls=smssvr_calls > db1.batch_size=50 > db1.retries=5 > db1.update_outbound_on_statusreport=yes > > On Mar 20, 2:16 pm, Thanasis <[email protected]> wrote: > > > The database structure and special field values is explained > > here:http://smslib.org/doc/smsserver/interfaces/database/ > > > On Mar 20, 6:36 am, vijayjain <[email protected]> wrote: > > > > Hi Thanasis, > > > > I am not using any XML file for this and below is DDL of out table : > > > > CREATE TABLE `smslib`.`smssvr_out` ( > > > `id` int(11) NOT NULL AUTO_INCREMENT, > > > `recipient` char(16) NOT NULL, > > > `text` varchar(1000) NOT NULL, > > > `create_date` datetime NOT NULL, > > > `originator` char(16) NOT NULL, > > > `encoding` char(1) NOT NULL, > > > `status_report` int(1) NOT NULL, > > > `flash_sms` int(1) NOT NULL, > > > `src_port` int(11) NOT NULL, > > > `dst_port` int(11) NOT NULL, > > > `sent_date` datetime NOT NULL, > > > `ref_no` char(64) NOT NULL, > > > `priority` int(1) NOT NULL, > > > `status` varchar(10) NOT NULL, > > > `errors` int(1) NOT NULL, > > > `gateway_id` char(64) NOT NULL, > > > PRIMARY KEY (`id`) > > > ) > > > > Please look into this. > > > Thanks > > > Vijay > > > > On Mar 19, 3:57 pm, Thanasis <[email protected]> wrote: > > > > > Do you see any errors? Or nothing gets sent silently? > > > > > The current v3.3.3 version has a bug which supresses database > > > > structural errors. So please check once more that all fields of the > > > > OUT table are in place. > > > > > On Mar 19, 12:11 pm, vijayjain <[email protected]> wrote: > > > > > > Hi, > > > > > > I am trying to send SMS using modem. I created In and out table in > > > > > mysql . my SIM card hold 5 messeges and when i am runing smsserver all > > > > > 5 messages entry goes to In table but no entry in out table and no > > > > > messege goes. my configuration is below. > > > > > > gateway.0=*, SerialModem > > > > > *.port=COM4 > > > > > *.baudrate=115200 > > > > > *.manufacturer=WAVECOM MODEM > > > > > *.model=MULTIBAND 900E 1800 > > > > > *.protocol=PDU > > > > > *.pin=0000 > > > > > *.inbound=yes > > > > > *.outbound=yes > > > > > *.init_string=ATZ\rATZ\rATZ\r > > > > > > interface.0=db1, Database > > > > > db1.type=mysql > > > > > db1.url=jdbc:mysql://localhost:3306/smslib?autoReconnect=true > > > > > db1.driver=com.mysql.jdbc.Driver > > > > > db1.username=smslib > > > > > db1.password=smslib > > > > > db1.tables.sms_in=smssvr_in > > > > > db1.tables.sms_out=smssvr_out > > > > > db1.tables.calls=smssvr_calls > > > > > db1.batch_size=50 > > > > > db1.retries=5 > > > > > db1.update_outbound_on_statusreport=yes- Hide quoted text - > > > > > - Show quoted text -- Hide quoted text - > > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SMSLib User Group" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/SMSLib?hl=en -~----------~----~----~----~------~----~------~--~---
