Hi, I have created the tables as mentiond in below link http://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 -~----------~----~----~----~------~----~------~--~---
