i got it the problem is the table name db1.tables.sms_in=sms_in db1.tables.sms_out=sms_out
i changed table as below db1.tables.sms_in=in db1.tables.sms_out=out now it connecting to mysql but thowring mysql error as below E:\test\smslib\dist>java -Dsmsserver.configfile=SMSServer.conf org.smslib.smsser ver.SMSServer -runonce 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.3.3 SMSServer version: 3.3.3 0 [main] ERROR org.smslib - SMSServer Error: java.sql.SQLException: Syntax error or access violation, message from server: " You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out set status = 'U' wher e status = 'Q'' at line 1" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1153) at com.mysql.jdbc.Connection.execSQL(Connection.java:2048) at com.mysql.jdbc.Connection.execSQL(Connection.java:2005) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198) at org.smslib.smsserver.interfaces.Database.stop(Database.java: 82) at org.smslib.smsserver.SMSServer.stopInterfaces (SMSServer.java:313) at org.smslib.smsserver.SMSServer.run(SMSServer.java:327) at org.smslib.smsserver.SMSServer.main(SMSServer.java:480) 47 [Thread-0] ERROR org.smslib - Shutdown hook error. java.sql.SQLException: Syntax error or access violation, message from server: " You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out set status = 'U' wher e status = 'Q'' at line 1" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1153) at com.mysql.jdbc.Connection.execSQL(Connection.java:2048) at com.mysql.jdbc.Connection.execSQL(Connection.java:2005) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198) at org.smslib.smsserver.interfaces.Database.stop(Database.java: 82) at org.smslib.smsserver.SMSServer.stopInterfaces (SMSServer.java:313) at org.smslib.smsserver.SMSServer$Shutdown.run(SMSServer.java: 106) java.sql.SQLException: Syntax error or access violation, message from server: " You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out set status = 'U' wher e status = 'Q'' at line 1" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1153) at com.mysql.jdbc.Connection.execSQL(Connection.java:2048) at com.mysql.jdbc.Connection.execSQL(Connection.java:2005) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198) at org.smslib.smsserver.interfaces.Database.stop(Database.java: 82) at org.smslib.smsserver.SMSServer.stopInterfaces (SMSServer.java:313) at org.smslib.smsserver.SMSServer$Shutdown.run(SMSServer.java: 106) E:\test\smslib\dist>java -Dsmsserver.configfile=SMSServer.conf org.smslib.smsser ver.SMSServer -runonce 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.3.3 SMSServer version: 3.3.3 0 [main] ERROR org.smslib - SMSServer Error: java.sql.SQLException: Syntax error or access violation, message from server: " You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out set status = 'U' wher e status = 'Q'' at line 1" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1153) at com.mysql.jdbc.Connection.execSQL(Connection.java:2048) at com.mysql.jdbc.Connection.execSQL(Connection.java:2005) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198) at org.smslib.smsserver.interfaces.Database.stop(Database.java: 82) at org.smslib.smsserver.SMSServer.stopInterfaces (SMSServer.java:313) at org.smslib.smsserver.SMSServer.run(SMSServer.java:327) at org.smslib.smsserver.SMSServer.main(SMSServer.java:480) 47 [Thread-0] ERROR org.smslib - Shutdown hook error. java.sql.SQLException: Syntax error or access violation, message from server: " You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out set status = 'U' wher e status = 'Q'' at line 1" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1153) at com.mysql.jdbc.Connection.execSQL(Connection.java:2048) at com.mysql.jdbc.Connection.execSQL(Connection.java:2005) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198) at org.smslib.smsserver.interfaces.Database.stop(Database.java: 82) at org.smslib.smsserver.SMSServer.stopInterfaces (SMSServer.java:313) at org.smslib.smsserver.SMSServer$Shutdown.run(SMSServer.java: 106) java.sql.SQLException: Syntax error or access violation, message from server: " You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out set status = 'U' wher e status = 'Q'' at line 1" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1153) at com.mysql.jdbc.Connection.execSQL(Connection.java:2048) at com.mysql.jdbc.Connection.execSQL(Connection.java:2005) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198) at org.smslib.smsserver.interfaces.Database.stop(Database.java: 82) at org.smslib.smsserver.SMSServer.stopInterfaces (SMSServer.java:313) at org.smslib.smsserver.SMSServer$Shutdown.run(SMSServer.java: 106) pls help me to fix this Saravanan N On Mar 11, 12:27 am, Thanasis <[email protected]> wrote: > v3.3.3 has an issue where it suppresses some errors coming out of the > database. > Since your config file looks ok, can you please double check your > database definition? Maybe you missed a field or something... > > On Mar 10, 8:11 pm, Webdev <[email protected]> wrote: > > > my config file (windows, xampp server) > > ============================ > > # Set a different balancer than the default. > > smsserver.balancer=LeastLoadLoadBalancer > > > #Set a different router than the default. > > #smsserver.router=NumberPoolRouter > > > # Lets add a modem > > gateway.0=modem1, SerialModem > > modem1.port=COM9 > > modem1.baudrate=19200 > > modem1.manufacturer=Nokia > > modem1.model=6100 > > modem1.protocol=PDU > > modem1.pin=0000 > > modem1.inbound=yes > > modem1.outbound=yes > > modem1.init_string=ATZ\rATZ\rATZ\r > > > interface.0=db1, Database > > db1.type=mysql > > db1.url=jdbc:mysql://localhost:3306/sms?autoReconnect=true > > db1.driver=com.mysql.jdbc.Driver > > db1.username=root > > db1.password= > > db1.tables.sms_in=sms_in > > db1.tables.sms_out=sms_out > > db1.tables.calls=sms_calls > > db1.batch_size=50 > > db1.retries=2 > > db1.update_outbound_on_statusreport=yes > > > settings.inbound_interval=5 > > settings.outbound_interval=5 > > settings.delete_after_processing=yes > > settings.send_mode = async > > settings.timeframe.low=0900-2200 > > settings.timeframe.normal=0000-2359 > > settings.timeframe.high=0000-2359 > > =================================== > > > C:\Program Files\Java\jre1.6.0_07\lib\ext>java - > > Dsmsserver.configfile=SMSServer. > > conf org.smslib.smsserver.SMSServer -runonce > > 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.3.3 > > SMSServer version: 3.3.3 > > Stable Library > > ========================================= > > Native lib Version = RXTX-2.1-7 > > Java lib Version = RXTX-2.1-7 > > > when i tried with above command it not throwing any error and not > > inserting the local mysql also > > > pls help me out to solve this > > > Thanks in advance --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
