This is not logical... Increase the "batch_size" and try once more. Increasing the batch_size will increase your sending rate.
By the way, I don't know what you mean "immediately" but you will not get "real-time" performance with SMSServer. As said before, SMSServer polls the database for new messages every now and then as define by the "settings.outbound_interval" setting. On Jul 16, 8:39 am, Vivek <[email protected]> wrote: > db1.batch_size =1(it is my requirement.On arrival of new out bound message i > have to send immediately ) > > I am adding record to SMSSERVER_OUT table by using SQL plus through insert > query with 'U' status. > > SMSServer is not sending from SMSSERVER_OUT table automatically. > > urs, > nandu > > > > On Thu, Jul 16, 2009 at 11:02 AM, Thanasis <[email protected]> wrote: > > > 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? > > ... > > read more » --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
