Hi Thanasis, I started using the DB interface. But I am getting a sql exception as below. Its a driver problem . Does it needs the drivers for mysql? If so where should I copy those drivers to?
*********************************************LOGS***************************************************** # /home/sandeep/Download/SMS/jdk1.5.0_17/bin/java -Dsmslib.debug - Dsmsserver.configdir=/home/sandeep/Download/SMS/SMSLib/src/java/org/ smslib/smsserver/ org.smslib.smsserver.SMSServer SMSLib: A Java API library for sending and receiving SMS via a GSM modem or other 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 1 [main] INFO org.smslib - SMSLib: A Java API library for sending and receiving SMS via a GSM modem or other supported gateways. This software is distributed under the terms of the Apache v2.0 License. Web Site: http://smslib.org 4 [main] INFO org.smslib - Version: 3.3.3 5 [main] INFO org.smslib - JRE Version: 1.5.0_17 5 [main] INFO org.smslib - JRE Impl Version: 1.5.0_17-b04 5 [main] INFO org.smslib - O/S: Linux / i386 / 2.6.27.5-117.fc10.i686 153 [main] INFO org.smslib - SMSServer: set balancer to: LeastLoadLoadBalancer 494 [main] INFO org.smslib - SMSServer: added gateway modem1 / Default Serial Modem Gateway. 593 [main] INFO org.smslib - SMSServer: added interface db1 / Default database interface. / INOUTBOUND 612 [main] ERROR org.smslib - SMSServer: Database Interface: error! java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java: 545) at java.sql.DriverManager.getConnection(DriverManager.java: 171) at org.smslib.smsserver.interfaces.Database.getDbConnection (Database.java:319) at org.smslib.smsserver.interfaces.Database.stop(Database.java: 78) 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) 648 [main] INFO org.smslib - SMSServer: interface: org.smslib.smsserver.interfaces.Database stopped. 648 [main] INFO org.smslib - GTW: modem1: Stopping gateway... 652 [main] INFO org.smslib - GTW: modem1: Closing: /dev/ttyS2 @115200 659 [main] INFO org.smslib - GTW: modem1: Gateway stopped. 659 [main] INFO org.smslib - SMSServer exiting normally. 667 [Thread-0] INFO org.smslib - SMSServer shutting down, please wait... 667 [Thread-0] ERROR org.smslib - SMSServer: Database Interface: error! java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java: 545) at java.sql.DriverManager.getConnection(DriverManager.java: 171) at org.smslib.smsserver.interfaces.Database.getDbConnection (Database.java:319) at org.smslib.smsserver.interfaces.Database.stop(Database.java: 78) at org.smslib.smsserver.SMSServer.stopInterfaces (SMSServer.java:313) at org.smslib.smsserver.SMSServer$Shutdown.run(SMSServer.java: 106) 668 [Thread-0] INFO org.smslib - SMSServer: interface: org.smslib.smsserver.interfaces.Database stopped. 668 [Thread-0] INFO org.smslib - GTW: modem1: Stopping gateway... 668 [Thread-0] INFO org.smslib - GTW: modem1: Closing: /dev/ttyS2 @115200 668 [Thread-0] INFO org.smslib - GTW: modem1: Gateway stopped. ************************************************************************************************ ************************************************CONFIG****************************************** smsserver.balancer=LeastLoadLoadBalancer gateway.0=modem1, SerialModem modem1.port=/dev/ttyS2 modem1.baudrate=115200 modem1.manufacturer=Airtel modem1.model=Globetrotter EDGE modem1.protocol=PDU modem1.pin=0000 modem1.inbound=yes modem1.outbound=yes modem1.init_string=ATZ\rATZ\rATZ\r interface.0=db1, Database db1.url=jdbc:mysql://localhost:3306/smslib?autoReconnect=true db1.driver=com.mysql.jdbc.Driver db1.username=smslib db1.password=smslib db1.type=mysql db1.tables.sms_in=smsserver_in db1.tables.sms_out=smsserver_out db1.tables.calls=smsserver_calls db1.batch_size=50 db1.retries=2 db1.update_outbound_on_statusreport=no settings.inbound_interval=600 settings.outbound_interval=10 settings.delete_after_processing=yes settings.send_mode = sync settings.timeframe.low=0900-2200 settings.timeframe.normal=0000-2359 settings.timeframe.high=0000-2359 ********************************************************************************************* On Apr 1, 10:30 pm, Thanasis <[email protected]> wrote: > Hi, > > I am sorry, but I have decided to drop the support for the email > interface (together with the jmx and xml). > Seehttp://smslib.googlecode.com/svn/smslib/tags/v3.4.0/RELEASE-NOTES.html > > Please use the db interface. > > On Apr 1, 3:58 pm,sandeep<[email protected]> wrote: > > > > > Hi Thanasis, > > > Please do help me on this. > > > I have a problem with the email interface. I am able to send SMS to > > the recipient when a new mail comes. But the SMS i am recieving is > > different from the mail content. > > > Actual mail body(mail content): "Hello SMSLib." > > > SMS recieved: "javax.mail.internet.mimemultip...@183f74d" > > > I am really Lost in search of a solution for this problem. Kindly help > > me in resolving it. Given below is the config file, email_body.tpl > > file and logs for your reference. > > > ***********************************CONFIG********************************** > > *********** > > smsserver.balancer=LeastLoadLoadBalancer > > > gateway.0=modem1, SerialModem > > modem1.port=/dev/ttyS2 > > modem1.baudrate=115200 > > modem1.manufacturer=Airtel > > modem1.model=Globetrotter EDGE > > modem1.protocol=TEXT > > modem1.pin=0000 > > modem1.inbound=no > > modem1.outbound=yes > > modem1.init_string=ATZ\rATZ\rATZ\r > > > interface.0=email1, Email > > email1.mailbox_protocol=imap > > email1.mailbox_host=mail.app.com > > email1.mailbox_port=143 > > email1.mailbox_user=sandy.p > > email1.mailbox_password=******* > > email1.mailbox_name=INBOX > > [email protected] > > [email protected] > > email1.smtp_host=mail.app.com > > email1.smtp_port=25 > > email1.smtp_user=sandy.p > > email1.smtp_password=******** > > email1.message_subject=SMS from %originator% > > email1.message_body=/home/sandeep/Download/SMS/SMSLib/emailbody.tpl > > > settings.inbound_interval=600 > > settings.outbound_interval=10 > > > settings.delete_after_processing=yes > > > settings.send_mode = sync > > > settings.timeframe.low=0900-2200 > > settings.timeframe.normal=0000-2359 > > settings.timeframe.high=0000-2359 > > > *******************************END > > CONFIG*************************************** > > > ************************email_body.tpl************************************* > > ****** > > %gatewayId% > > %encoding% > > %date% > > %text% > > %pduUserData% > > %originator% > > %memIndex% > > %mpMemIndex% > > ************************************END************************************ > > ********* > > > ***************************LOG******************************* > > > # /home/sandeep/Download/SMS/jdk1.5.0_17/bin/java -Dsmslib.debug - > > Dsmsserver.configdir=/home/sandeep/Download/SMS/SMSLib/src/java/org/ > > smslib/smsserver/ org.smslib.smsserver.SMSServer > > SMSLib: A Java API library for sending and receiving SMS via a GSM > > modem or other 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] INFO org.smslib - SMSLib: A Java API library for sending and > > receiving SMS via a GSM modem or other supported gateways. > > This software is distributed under the terms of the Apache v2.0 > > License. > > Web Site:http://smslib.org > > 6 [main] INFO org.smslib - Version: 3.3.3 > > 6 [main] INFO org.smslib - JRE Version: 1.5.0_17 > > 11 [main] INFO org.smslib - JRE Impl Version: 1.5.0_17-b04 > > 11 [main] INFO org.smslib - O/S: Linux / i386 / > > 2.6.27.5-117.fc10.i686 > > 29 [main] INFO org.smslib - SMSServer: set balancer to: > > LeastLoadLoadBalancer > > 90 [main] INFO org.smslib - SMSServer: added gateway modem1 / Default > > Serial Modem Gateway. > > 382 [main] INFO org.smslib - SMSServer: added interface email1 / > > Interface for Email communication. / INOUTBOUND > > 507 [main] INFO org.smslib - SMSServer: interface: > > org.smslib.smsserver.interfaces.Email started. > > 513 [SMSLib-WatchDog] DEBUG org.smslib - WatchDog started. > > 513 [SMSLib-WatchDog] INFO org.smslib - WatchDog running... > > 519 [Thread-2] INFO org.smslib - GTW: modem1: Starting gateway, using > > Generic AT Handler. > > 519 [Thread-2] INFO org.smslib - GTW: modem1: Opening: /dev/ttyS2 > > @115200 > > Experimental: JNI_OnLoad called. > > Stable Library > > ========================================= > > Native lib Version = RXTX-2.1-7 > > Java lib Version = RXTX-2.1-7 > > 632 [Thread-2] DEBUG org.smslib - GTW: modem1: ModemDriver: KeepAlive > > thread started. > > 638 [Thread-2] DEBUG org.smslib - GTW: modem1: ModemReader thread > > started. > > 659 [Thread-2] DEBUG org.smslib - GTW: modem1: AsyncNotifier thread > > started. > > 674 [Thread-2] DEBUG org.smslib - GTW: modem1: AsyncMessageProcessor > > thread started. > > 674 [Thread-2] DEBUG org.smslib - GTW: modem1: clearBuffer() called. > > 1679 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :(27) > > 1880 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :+++ > > 2082 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :ATZ > > 2284 [Thread-2] DEBUG org.smslib - GTW: modem1: clearBuffer() called. > > 3284 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :ATZ(cr) > > 3487 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :ATE0(cr) > > 3689 [Thread-2] DEBUG org.smslib - GTW: modem1: clearBuffer() called. > > 4689 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :ATZ(cr)ATZ(cr) > > ATZ(cr)(cr) > > 4692 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :ATE0(cr) > > 4894 [Thread-2] DEBUG org.smslib - GTW: modem1: clearBuffer() called. > > 5894 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :AT+CPIN?(cr) > > 5924 [Thread-2] DEBUG org.smslib - GTW: modem1: BUFFER: +CPIN: READY > > 5925 [Thread-2] DEBUG org.smslib - GTW: modem1: RECV :+CPIN: READY > > (cr) > > 5925 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :ATE0(cr) > > 6130 [Thread-2] DEBUG org.smslib - GTW: modem1: clearBuffer() called. > > 7130 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :AT+CLIP=1(cr) > > 7133 [Thread-2] DEBUG org.smslib - GTW: modem1: BUFFER: OK > > 7134 [Thread-2] DEBUG org.smslib - GTW: modem1: RECV :OK(cr) > > 7134 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :AT+COPS=0(cr) > > 7161 [Thread-2] DEBUG org.smslib - GTW: modem1: BUFFER: OK > > 7162 [Thread-2] DEBUG org.smslib - GTW: modem1: RECV :OK(cr) > > 7162 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :ATE0(cr) > > 7364 [Thread-2] DEBUG org.smslib - GTW: modem1: clearBuffer() called. > > 8364 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :AT+CREG?(cr) > > OK72 [Thread-2] DEBUG org.smslib - GTW: modem1: BUFFER: +CREG: 0,1 > > 8373 [Thread-2] DEBUG org.smslib - GTW: modem1: RECV :+CREG: 0,1(cr)OK > > (cr) > > 8374 [Thread-2] INFO org.smslib - GTW: modem1: GSM: Registered to > > home network. > > 8383 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :AT+CMEE=1(cr) > > 8405 [Thread-2] DEBUG org.smslib - GTW: modem1: BUFFER: OK > > 8405 [Thread-2] DEBUG org.smslib - GTW: modem1: RECV :OK(cr) > > 8405 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :AT+CPMS?(cr) > > OK32 [Thread-2] DEBUG org.smslib - GTW: modem1: BUFFER: +CPMS: "SM", > > 0,25,"SM",0,25,"SM",0,25 > > 8433 [Thread-2] DEBUG org.smslib - GTW: modem1: RECV :+CPMS: "SM", > > 0,25,"SM",0,25,"SM",0,25(cr)OK(cr) > > 8434 [Thread-2] INFO org.smslib - GTW: modem1: MEM: Storage Locations > > Found: SM > > 8434 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :AT+CNMI=?(cr) > > OK57 [Thread-2] DEBUG org.smslib - GTW: modem1: BUFFER: +CNMI: (2), > > (0-3),(0-3),(0-2),(0,1) > > 8457 [Thread-2] DEBUG org.smslib - GTW: modem1: RECV :+CNMI: (2), > > (0-3),(0-3),(0-2),(0,1)(cr)OK(cr) > > 8458 [Thread-2] DEBUG org.smslib - CNMI: Found best match: 2 > > 8458 [Thread-2] DEBUG org.smslib - CNMI: Found best match: 1 > > 8458 [Thread-2] DEBUG org.smslib - CNMI: Found best match: 0 > > 8458 [Thread-2] DEBUG org.smslib - CNMI: Found best match: 2 > > 8458 [Thread-2] DEBUG org.smslib - CNMI: Found best match: 0 > > 8458 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :AT > > +CNMI=2,1,0,2,0(cr) > > 8479 [Thread-2] DEBUG org.smslib - GTW: modem1: BUFFER: OK > > 8479 [Thread-2] DEBUG org.smslib - GTW: modem1: RECV :OK(cr) > > 8479 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :AT+CMGF=1(cr) > > 8500 [Thread-2] DEBUG org.smslib - GTW: modem1: BUFFER: OK > > 8501 [Thread-2] DEBUG org.smslib - GTW: modem1: RECV :OK(cr) > > 8501 [Thread-2] DEBUG org.smslib - GTW: modem1: SEND :AT > > +CSCS="8859-1"(cr) > > 8521 [Thread-2] DEBUG org.smslib - GTW: modem1: BUFFER: OK > > 8522 [Thread-2] DEBUG org.smslib - GTW: modem1: RECV :OK(cr) > > 8524 [Thread-2] DEBUG org.smslib - GTW: modem1: CNMIEmulatorProcessor > > thread started. > > 8527 [SMSLib-QueueManager] INFO org.smslib - GTW: modem1: Starting > > Queue Manager. > > 8527 [SMSLib-QueueManager] INFO org.smslib - GTW: modem1: > > QueueManager stopped. > > 8531 [Thread-2] INFO org.smslib - GTW: modem1: Gateway started. > > 9526 [SMSServer - InboundPollingThread] DEBUG org.smslib - > > InboundPollingThread() run. > > 9530 [SMSServer - OutboundPollingThread] DEBUG org.smslib - > > OutboundPollingThread() run. > > 9923 [SMSServer - OutboundPollingThread] INFO org.smslib - SMSServer: > > sending synchronously... > > 11531 [SMSLib-CNMIEmulator : modem1] DEBUG org.smslib - GTW: modem1: > > SEND :AT+CPMS="SM"(cr) > > OK566 [SMSLib-CNMIEmulator : modem1] DEBUG org.smslib - GTW: modem1: > > BUFFER: +CPMS: 0,25,0,25,0,25 > > 11567 [SMSLib-CNMIEmulator : modem1] DEBUG org.smslib - GTW: modem1: > > RECV :+CPMS: 0,25,0,25,0,25(cr)OK(cr) > > 11567 [SMSLib-CNMIEmulator : modem1] DEBUG org.smslib - GTW: modem1: > > SEND :AT+CMGL="ALL"(cr) > > 11595 [SMSLib-CNMIEmulator : modem1] DEBUG org.smslib - GTW: modem1: > > BUFFER: OK > > 11598 [SMSLib-CNMIEmulator : modem1] DEBUG org.smslib - GTW: modem1: > > RECV :OK(cr) > > 15513 [SMSLib-WatchDog] INFO org.smslib - WatchDog running... > > 19924 [SMSServer - OutboundPollingThread] DEBUG org.smslib - > > OutboundPollingThread() run. > > 20037 [SMSServer - OutboundPollingThread] INFO org.smslib - > > SMSServer: > > ... > > read more »- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
