Hi Sandeep
You can get the mysql driver in the follow link
http://www.mysql.com/products/connector/j/
Vacuela
On Thu, Apr 2, 2009 at 11:50 PM, sandeep <[email protected]>wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
