Increase the "db1.batch_size" a bit - set it to 10. You don't have to restart anything. Once there are new records in the OUT table (with status = 'U'), SMSServer will pick them up every "settings.outbound_interval" seconds.
The status field is handled automatically by SMSServer. All you have to do is to ensure that new records are added as 'U'. On Jul 16, 8:25 am, Vivek <[email protected]> wrote: > Sorry Thanasis. > > I send wrong configuration file. > Actual file i am sending now. > > my queries are > > 1.How to send messages continuously from SMSSERVER_OUT table(Without any > restarting the SMSServer) > > 2.There is column in status SMSSERVER_OUT table. > Which is having 'Q' status .How to use Q status. > > --------------------------------------------------------------------------- > ----------------- > # Set a different balancer than the default. > smsserver.balancer=RoundRobinLoadBalancer > > #Set a different router than the default. > #smsserver.router=NumberPoolRouter > > # Lets add a modem > gateway.0=modem1, SerialModem > modem1.port=COM5 > modem1.baudrate=115200 > modem1.manufacturer=aa > modem1.model=6310i > modem1.protocol=PDU > modem1.pin=0000 > modem1.inbound=yes > modem1.outbound=yes > modem1.smsc_number= > modem1.init_string=ATZ\rATZ\rATZ\r > > # Here is an example of an Oracle database interface. > interface.0=db1, Database > db1.url=jdbc:oracle:thin:dpnew/dp...@localhost:1521/XE > db1.driver=oracle.jdbc.OracleDriver > db1.username=dpnew > db1.password=dpnew > db1.type=oracle > db1.tables.sms_in=SMSSERVER_IN > db1.tables.sms_out=SMSSERVER_OUT > db1.tables.calls=SMSSERVER_CALLS > db1.batch_size=1 > db1.retries=2 > db1.update_outbound_on_statusreport=no > > #Interval for processing inbound messages (in seconds) > settings.inbound_interval=10 > #Interval for processing outbound queues (in seconds) > settings.outbound_interval=10 > > #After reading, should SMSServer delete the processed messages from the > gateways? > #Default is "no" for safety. Set to "yes" if you wish to delete messages. > #If you leave it to "no", SMSServer will process the same messages over and > over again! > settings.delete_after_processing=no > > # Should SMSServer work in sync or async sending mode? > # Async mode forwards messages to gateway queues. > # Values can be "sync" and "async". > settings.send_mode =sync > > # Allowed dispatch time-fames per priority > settings.timeframe.low=0900-2200 > settings.timeframe.normal=0000-2359 > settings.timeframe.high=0000-2359 > --------------------------------------------------------------------------- > --------------------- > > urs, > nandu > > > > On Thu, Jul 16, 2009 at 10:43 AM, Thanasis <[email protected]> wrote: > > > First of all, all database definitions in your config file are > > remarked... You won't have any database activity (IN or OUT) this way. > > You should define an Oracle database link first. > > > The "inbound_internal" is set to 10 seconds. Its pretty low (i.e. > > fast). > > > On Jul 16, 7:04 am, Vivek <[email protected]> wrote: > > > Hi , > > > I am sending you the SMSServer.conf fil. > > > --------------------------------------------------------------------------- > > -------------- > > > # Set a different balancer than the default. > > > smsserver.balancer=RoundRobinLoadBalancer > > > > #Set a different router than the default. > > > #smsserver.router=NumberPoolRouter > > > > # Lets add a modem > > > gateway.0=modem1, SerialModem > > > modem1.port=COM5 > > > modem1.baudrate=115200 > > > modem1.manufacturer=aa > > > modem1.model=6310i > > > modem1.protocol=PDU > > > modem1.pin=0000 > > > modem1.inbound=yes > > > modem1.outbound=yes > > > modem1.smsc_number= > > > modem1.init_string=ATZ\rATZ\rATZ\r > > > > # Dummy gateways used for testing. > > > #gateway.1=Test1, TestGateway > > > #Test1.inbound=yes > > > #Test1.outbound=yes > > > #gateway.2=Test2, TestGateway > > > #Test2.inbound=no > > > #Test2.outbound=yes > > > #gateway.3=Test3, TestGateway > > > #Test3.inbound=no > > > #Test3.outbound=yes > > > #gateway.4=Test4, TestGateway > > > #Test4.inbound=no > > > #Test4.outbound=yes > > > #gateway.5=Test5, TestGateway > > > #Test5.inbound=no > > > #Test5.outbound=yes > > > #gateway.6=Test6, TestGateway > > > #Test6.inbound=no > > > #Test6.outbound=yes > > > #gateway.7=Test7, TestGateway > > > #Test7.inbound=no > > > #Test7.outbound=yes > > > #gateway.8=Test8, TestGateway > > > #Test8.inbound=no > > > #Test8.outbound=yes > > > > # Here is an example of a Microsoft SQL Server database interface. > > > #interface.0=db1, Database > > > #db1.url=jdbc:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=s > > mslib > > > #db1.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver > > > #db1.username=smslib > > > #db1.password=smslib > > > #db1.type=mssql > > > #db1.tables.sms_in= > > > #db1.tables.sms_out= > > > #db1.tables.calls= > > > #db1.batch_size=50 > > > #db1.retries=2 > > > #db1.update_outbound_on_statusreport=no > > > > # Here is an example of an Oracle database interface. > > > #interface.0=db1, Database > > > #db1.url=jdbc:oracle:thin:smslib/sms...@localhost:1521/XE > > > #db1.driver=oracle.jdbc.OracleDriver > > > #db1.username=smslib > > > #db1.password=smslib > > > #db1.type=oracle > > > #db1.tables.sms_in= > > > #db1.tables.sms_out= > > > #db1.tables.calls= > > > #db1.batch_size=50 > > > #db1.retries=2 > > > #db1.update_outbound_on_statusreport=no > > > > # Here is an example of a MySQL database interface. > > > #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= > > > #db1.tables.sms_out= > > > #db1.tables.calls= > > > #db1.batch_size=50 > > > #db1.retries=2 > > > #db1.update_outbound_on_statusreport=yes > > > > # Here is an example of a SimpleInboundFileLogger interface. > > > #interface.1=file1, SimpleInboundFileLogger, inbound > > > #file1.filename=f:/logger.txt > > > > # Here is an example of a XML interface. > > > #interface.2=xml1, Xml, outbound > > > #xml1.in=c:/temp/in > > > #xml1.out=c:/temp/out > > > > # Here is an example of a JMX interface. > > > #interface.3=jmx1, Jmx > > > #jmx1.registry_port=1988 > > > #jmx1.url=service:jmx:rmi:///jndi/rmi://localhost:1988/SMSlib > > > #jmx1.object_name=org.smslib:name=SMSServer > > > > # Here is an example of a Email interface. > > > #interface.4=email1, Email > > > #email1.mailbox_protocol=pop3 > > > #email1.mailbox_host=host > > > #email1.mailbox_port=110 > > > #email1.mailbox_user=user > > > #email1.mailbox_password=password > > > #email1.mailbox_name=INBOX > > > #[email protected] > > > #[email protected] > > > #email1.smtp_host=host > > > #email1.smtp_port=25 > > > #email1.smtp_user=user > > > #email1.smtp_password=password > > > #email1.message_subject=SMS from %originator% > > > #email1.message_body=emailbody.html.tpl > > > > # Here is an example of a HTTP interface. > > > #interface.5=http1, Http > > > #http1.get_url= > >http://192.168.1.1/test.php?gatewayId=%gatewayId%&text=%text%&origina... > > > #http1.dlr_url= > >http://192.168.1.1/dlr.php?gatewayId=%gatewayId%&text=%text%&from=%fr... > > > #http1.method=GET > > > > #interface.6=httpServer, HttpServer > > > #httpServer.port=8080 > > > #httpServer.password.read=0000 > > > #httpServer.password.send=1111 > > > > #Interval for processing inbound messages (in seconds) > > > settings.inbound_interval=10 > > > #Interval for processing outbound queues (in seconds) > > > settings.outbound_interval=10 > > > > #After reading, should SMSServer delete the processed messages from the > > > gateways? > > > #Default is "no" for safety. Set to "yes" if you wish to delete messages. > > > #If you leave it to "no", SMSServer will process the same messages over > > and > > > over again! > > > settings.delete_after_processing=no > > > > # Should SMSServer work in sync or async sending mode? > > > # Async mode forwards messages to gateway queues. > > > # Values can be "sync" and "async". > > > settings.send_mode = sync > > > > # Allowed dispatch time-fames per priority > > > settings.timeframe.low=0900-2200 > > > settings.timeframe.normal=0000-2359 > > > settings.timeframe.high=0000-2359 > > > --------------------------------------------------------------------------- > > ---------------- > > > > My doubt is can we send messages from SMSSERVER_OUT table continuously . > > > urs, > > > nandu > > > > On Thu, Jul 16, 2009 at 1:12 AM, Thanasis <[email protected]> wrote: > > > > > I guess that the "settings.outbound_interval" in your SMSServer.conf > > > > is high. Can you check its value? > > > > > On Jul 15, 10:27 pm, Vivek <[email protected]> wrote: > > > > > HI Thanasis, > > > > > > I configured SMSServer with oracle 10g. > > > > > SMSServer is storing messages in SMSSERVER_IN table. > > > > > SMSServer sending messages from SMSSERVER_OUT table only when we > > > > > started SMSServer . > > > > > > After that i am inserting some more records in SMSSERVER_OUT table. > > > > > (SMSServer not at stopped). > > > > > But SMSServer not sending these inserted records. > > > > > To send these messages we have to stop the SMSServer and start. > > > > > > I want to send these messages without re-starting SMSServer. > > > > > > Plz send me solution for that. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
