Are the "IN" and "OUT" names reserved in MySQL??? Can you rename the tables and retry?
On Mar 11, 4:19 pm, Webdev <[email protected]> wrote: > 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 > > ... > > 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 -~----------~----~----~----~------~----~------~--~---
