search

CDilshanMadusanka / smslib

Automatically exported from code.google.com/p/smslib
0 stars 0 forks source link

Doubt in Smserver.conf #399

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Hi, I have installed my Airtel USB modem (port and I'm trying to configure 
SMSlib with database interfaces with PostgreSQL database (8.4.2 Version). So, 
the i made the SMSServer.conf look like this,

interface.0=db1, Database
db1.url=jdbc:postgresql://192.168.11.25:5432/impeldev
db1.driver= org.postgresql.Driver
db1.username=postgres
db1.password=post123
db1.type=pgsql
db1.tables.sms_in=smssvr_in
db1.tables.sms_out=smssvr_out
db1.tables.calls=smssvr_calls
db1.batch_size=50
db1.retries=2
db1.update_outbound_on_statusreport=yes

And i try to run this in command prompt I'm getting this as output:

C:\Documents and Settings\Administrator\Desktop\smslib-v3.4.6\dist\classes>java
-Dsmslib.debug -Dsmsserver.configfile=SMSServer.conf org.smslib.smsserver.SMSSer
ver
SMSLib: A Java API library for sending and receiving SMS via a GSM modem or othe
r supported gateways.
This software is distributed under the terms of the Apache v2.0 License.
Web Site: http://smslib.org

SMSLib API version: 3.4.6
SMSServer version: 3.4.6
0      2010-10-27 13:11:39,218 [main] INFO  org.smslib.helper.Logger  - SMSLib:
A Java API library for sending and receiving SMS via a GSM modem or other suppor
ted gateways.
This software is distributed under the terms of the Apache v2.0 License.
Web Site: http://smslib.org
0      2010-10-27 13:11:39,218 [main] INFO  org.smslib.helper.Logger  - Version:
 3.4.6
0      2010-10-27 13:11:39,218 [main] INFO  org.smslib.helper.Logger  - JRE Vers
ion: 1.6.0_22
16     2010-10-27 13:11:39,234 [main] INFO  org.smslib.helper.Logger  - JRE Impl
 Version: 17.1-b03
16     2010-10-27 13:11:39,234 [main] INFO  org.smslib.helper.Logger  - O/S: Win
dows XP / x86 / 5.1
16     2010-10-27 13:11:39,234 [main] DEBUG org.smslib.helper.Logger  - Initiali
zed.
16     2010-10-27 13:11:39,234 [DelayQueueManager] DEBUG org.smslib.helper.Logge
r  - Running...
16     2010-10-27 13:11:39,234 [DelayQueueManager] DEBUG org.smslib.helper.Logge
r  - DelayQueueManager running...
16     2010-10-27 13:11:39,234 [main] DEBUG org.smslib.helper.Logger  - Initiali
zed.
16     2010-10-27 13:11:39,234 [NotifyQueueManager] DEBUG org.smslib.helper.Logg
er  - Running...
16     2010-10-27 13:11:39,234 [NotifyQueueManager] DEBUG org.smslib.helper.Logg
er  - NotifyQueueManager running...
32     2010-10-27 13:11:39,250 [main] INFO  org.smslib.helper.Logger  - SMSServe
r: added interface db1 / Default database interface. / INOUTBOUND
578    2010-10-27 13:11:39,796 [main] ERROR org.smslib.helper.Logger  - SQL fail
ure, will retry in 1 seconds...
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, comman
ds ignored until end of transaction block
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:374)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:302)
        at org.smslib.smsserver.interfaces.Database.stop(Database.java:92)
        at org.smslib.smsserver.SMSServer.stopInterfaces(SMSServer.java:321)
        at org.smslib.smsserver.SMSServer.run(SMSServer.java:335)
        at org.smslib.smsserver.SMSServer.main(SMSServer.java:543)
1594   2010-10-27 13:11:40,812 [main] ERROR org.smslib.helper.Logger  - SQL fail
ure, will retry in 1 seconds...
org.postgresql.util.PSQLException: ERROR: relation "smssvr_out" does not exist
  Position: 8
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:374)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:302)
        at org.smslib.smsserver.interfaces.Database.stop(Database.java:92)
        at org.smslib.smsserver.SMSServer.stopInterfaces(SMSServer.java:321)
        at org.smslib.smsserver.SMSServer.run(SMSServer.java:335)
        at org.smslib.smsserver.SMSServer.main(SMSServer.java:543)
2641   2010-10-27 13:11:41,859 [main] ERROR org.smslib.helper.Logger  - SQL fail
ure, will retry in 1 seconds...
org.postgresql.util.PSQLException: ERROR: relation "smssvr_out" does not exist
  Position: 8
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:374)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:302)
        at org.smslib.smsserver.interfaces.Database.stop(Database.java:92)
        at org.smslib.smsserver.SMSServer.stopInterfaces(SMSServer.java:321)
        at org.smslib.smsserver.SMSServer.run(SMSServer.java:335)
        at org.smslib.smsserver.SMSServer.main(SMSServer.java:543)
3672   2010-10-27 13:11:42,890 [main] ERROR org.smslib.helper.Logger  - SQL fail
ure, will retry in 1 seconds...
org.postgresql.util.PSQLException: ERROR: relation "smssvr_out" does not exist
  Position: 8
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:374)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:302)
        at org.smslib.smsserver.interfaces.Database.stop(Database.java:92)
        at org.smslib.smsserver.SMSServer.stopInterfaces(SMSServer.java:321)
        at org.smslib.smsserver.SMSServer.run(SMSServer.java:335)
        at org.smslib.smsserver.SMSServer.main(SMSServer.java:543)
4703   2010-10-27 13:11:43,921 [main] ERROR org.smslib.helper.Logger  - SQL fail
ure, will retry in 1 seconds...
org.postgresql.util.PSQLException: ERROR: relation "smssvr_out" does not exist
  Position: 8
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:374)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:302)
        at org.smslib.smsserver.interfaces.Database.stop(Database.java:92)
        at org.smslib.smsserver.SMSServer.stopInterfaces(SMSServer.java:321)
        at org.smslib.smsserver.SMSServer.run(SMSServer.java:335)
        at org.smslib.smsserver.SMSServer.main(SMSServer.java:543)
5750   2010-10-27 13:11:44,968 [main] ERROR org.smslib.helper.Logger  - SQL fail
ure, will retry in 1 seconds...
org.postgresql.util.PSQLException: ERROR: relation "smssvr_out" does not exist
  Position: 8
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:374)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:302)
        at org.smslib.smsserver.interfaces.Database.stop(Database.java:92)
        at org.smslib.smsserver.SMSServer.stopInterfaces(SMSServer.java:321)
        at org.smslib.smsserver.SMSServer.run(SMSServer.java:335)
        at org.smslib.smsserver.SMSServer.main(SMSServer.java:543)
.....

Actually, the output clearly says there is no table "smssvr_out" like that, 
However I created the table in impeldev database and I don't know why it's not 
working and please look at the output whether I have to do something else to 
fix other errors or missing something.Please look at the SMSserver.conf which 
is attached which is old one we use for smslib 3.3.0 in that we had given 
device (USB device) details whereas, not in the case of this database interface 
level smslibv-3.4.6 why ?. I don't know whether I should give it or not. Please 
derive the new SMSServer.conf here for me to use my Smslib with database 
interface. It will be greatly thankful if you do that.

Original issue reported on code.google.com by vijaytre...@gmail.com on 27 Oct 2010 at 7:54

Attachments:

GoogleCodeExporter commented 8 years ago 
Anyways, I fixed this myself. Thanks once again. The problem is different now. 
I don't know how to trigger outbound sms from database interface.

Original comment by vijaytre...@gmail.com on 27 Oct 2010 at 2:36

GoogleCodeExporter commented 8 years ago

Original comment by T.Delenikas on 27 Oct 2010 at 7:31