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