ya i tried tables again same issue occurs, but xml interface works fine for me,
pls help me out to fix mysql issue pls find my table schema below CREATE TABLE IF NOT EXISTS `calls_table` ( `id` int(11) NOT NULL auto_increment, `call_date` datetime NOT NULL, `gateway_id` char(64) NOT NULL, `caller_id` char(16) NOT NULL, PRIMARY KEY (`id`) ) -- -- Table structure for table `in_table` -- CREATE TABLE IF NOT EXISTS `in_table` ( `id` int(11) NOT NULL auto_increment, `process` int(11) NOT NULL, `originator` char(16) NOT NULL, `type` char(1) NOT NULL, `encoding` char(1) NOT NULL, `message_date` datetime NOT NULL, `receive_date` datetime NOT NULL, `text` char(255) NOT NULL, `original_ref_no` char(64) NOT NULL, `original_receive_date` datetime NOT NULL, `gateway_id` char(64) NOT NULL, `status` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) -- -- Table structure for table `out_table` -- CREATE TABLE IF NOT EXISTS `out_table` ( `id` int(11) NOT NULL auto_increment, `recipient` char(16) NOT NULL, `text` char(255) NOT NULL, `create_date` datetime NOT NULL, `originator` char(16) NOT NULL, `encoding` char(1) NOT NULL, `status_report` int(1) NOT NULL, `flash_sms` int(1) NOT NULL, `src_port` int(11) NOT NULL, `dst_port` int(11) NOT NULL, `sent_date` datetime NOT NULL, `ref_no` char(64) NOT NULL, `priority` int(1) NOT NULL, `status` varchar(10) NOT NULL, `errors` int(1) NOT NULL, `gateway_id` char(64) NOT NULL, PRIMARY KEY (`id`) ) On Mar 11, 11:46 pm, Thanasis <[email protected]> wrote: > 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 > > ... > > 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 -~----------~----~----~----~------~----~------~--~---
