With regards to this, I just realized I forgot to install connectorJ.
Everything works perfectly. Thanks :-) David On Mon, Apr 13, 2009 at 7:58 AM, David Chua <[email protected]> wrote: > Thanks! that works now! > > I'm having another problem now though. > > I'm trying to run MySQL as my interface and in my SMSServer.conf I have: > > # Here is an example of a MySQL database interface. > interface.0=db1, Database > db1.type=mysql > db1.url=jdbc:mysql://localhost:3306/smsserver?autoReconnect=true > db1.driver=com.mysql.jdbc.Driver > db1.username=sms > db1.password=sms > 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=yes > > *But I get the following error: I've checked, in my src/... file I do have > the Database.java there. * > > 47 2009-04-13 07:52:41,187 [main] INFO org.smslib.helper.Logger - > SMSServer: added interface db1 / Default database interface. / INOUTBOUND > 47 2009-04-13 07:52:41,187 [main] ERROR org.smslib.helper.Logger - > 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:396) > at org.smslib.smsserver.interfaces.Database.stop(Database.java:83) > 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 2009-04-13 07:52:41,187 [main] INFO org.smslib.helper.Logger - > SMSServer: interface: org.smslib.smsserver.interfaces.Database stopped. > 63 2009-04-13 07:52:41,203 [main] ERROR org.smslib.helper.Logger - > SMSServer Error:java.lang.NullPointerException > at org.smslib.Service.stopService(Service.java:311) > at org.smslib.smsserver.SMSServer.run(SMSServer.java:328) > at org.smslib.smsserver.SMSServer.main(SMSServer.java:480) > 78 2009-04-13 07:52:41,218 [Thread-0] INFO org.smslib.helper.Logger - > SMSServer shutting down, please wait... > 78 2009-04-13 07:52:41,218 [Thread-0] ERROR org.smslib.helper.Logger - > 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:396) > at org.smslib.smsserver.interfaces.Database.stop(Database.java:83) > at > org.smslib.smsserver.SMSServer.stopInterfaces(SMSServer.java:313) > at org.smslib.smsserver.SMSServer$Shutdown.run(SMSServer.java:105) > 94 2009-04-13 07:52:41,234 [Thread-0] INFO org.smslib.helper.Logger - > SMSServer: interface: org.smslib.smsserver.interfaces.Database stopped. > 94 2009-04-13 07:52:41,234 [Thread-0] ERROR org.smslib.helper.Logger - > Shutdown hook error. > java.lang.NullPointerException > at org.smslib.Service.stopService(Service.java:311) > at org.smslib.smsserver.SMSServer$Shutdown.run(SMSServer.java:106) > java.lang.NullPointerException > at org.smslib.Service.stopService(Service.java:311) > at org.smslib.smsserver.SMSServer$Shutdown.run(SMSServer.java:106) > > On Mon, Apr 13, 2009 at 1:21 AM, Thanasis <[email protected]> wrote: > >> >> You can try this alternative with the "-Dlog4j.configuration": >> >> java -cp dist\lib\smsserver-3.4.0.jar -Dsmsserver.configdir=dist\ - >> Dlog4j.configuration="file:misc/Log4j Sample Configuration/ >> log4j.properties" org.smslib.smsserver.SMSServer >> >> I am run it from the "root" of the distro zip. >> >> On Apr 12, 7:45 pm, David Chua <[email protected]> wrote: >> > Still doesn't work. >> > >> > >> > >> > On Mon, Apr 13, 2009 at 12:38 AM, Thanasis <[email protected]> wrote: >> > >> > > What if you put it together with the ".jar" file of SMSServer? >> > >> > > On Apr 12, 7:35 pm, David Chua <[email protected]> wrote: >> > > > It doesn't work, the error file is still there. >> > >> > > > On Mon, Apr 13, 2009 at 12:34 AM, Thanasis <[email protected]> >> wrote: >> > >> > > > > No rebuild is required. >> > > > > This is an addon file. Try to copy it in the "current" directory >> from >> > > > > where you run the "java" command. >> > >> > > > > On Apr 12, 7:29 pm, David Chua <[email protected]> wrote: >> > > > > > Hi there, >> > >> > > > > > Where should it be going into? because I'm running my SMSServer >> from >> > > the >> > > > > > .jar, should the log file be in the src/ directories and >> rebuilt? >> > >> > > > > > java -cp >> D:\smslib3.4\smslib-v3.4.0-bin\dist\lib\smsserver-3.4.0.jar >> > >> > > >> -Dsmsserver.configdir=D:\smslib3.4\smslib-v3.4.0-bin\src\java\org\smslib\smsserver\ >> > > > > > org.smslib.smsserver.SMSServer >> > >> > > > > > Warmest regards, >> > > > > > David >> > >> > > > > > On Mon, Apr 13, 2009 at 12:09 AM, Thanasis <[email protected]> >> wrote: >> > >> > > > > > > Hello, >> > >> > > > > > > You are probably missing the log4j configuration file. Its not >> > > > > > > critical to SMSLib operation, its just that the logging will >> not >> > > work. >> > > > > > > For a quick solution, just copy the "log4j.properties" (found >> in >> > > "misc >> > > > > > > \Log4j Sample Configuration" directory) to the directory from >> where >> > > > > > > you are running the SMSLib apps. >> > >> > > > > > > On Apr 12, 4:50 pm, David Chua <[email protected]> wrote: >> > > > > > > > Hi everyone, >> > >> > > > > > > > I'm having some problems getting SMSServer 3.4.0 to run. >> > >> > > > > > > > I've installed the necessary pre-requisites (JavaComm >> etc...) >> > > > > including >> > > > > > > sl4j >> > > > > > > > as per instructions athttp://smslib.org/doc/installation/. >> > > > > > > > * >> > > > > > > > After successfully building SMSServer:* >> > > > > > > > D:\smslib3.4\smslib-v3.4.0-bin>ant build-smsserver >> > > > > > > > Buildfile: build.xml >> > >> > > > > > > > compile.smsserver: >> > >> > > > > > > > pre-build.smsserver: >> > >> > > > > > > > build.smsserver: >> > > > > > > > [jar] Building jar: >> > > > > > > > D:\smslib3.4\smslib-v3.4.0-bin\dist\lib\smsserver-3.4. >> > > > > > > > 0.jar >> > >> > > > > > > > build-smsserver: >> > >> > > > > > > > BUILD SUCCESSFUL >> > > > > > > > Total time: 0 seconds >> > >> > > > > > > > *I've attempted to run SMSServer but got the following >> error:* >> > >> > > > > > > > D:\smslib3.4\smslib-v3.4.0-bin>java -cp >> > > > > > > > D:\smslib3.4\smslib-v3.4.0-bin\dist\lib\smsserver-3.4.0.jar >> > >> > > >> -Dsmsserver.configdir=D:\smslib3.4\smslib-v3.4.0-bin\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.4.0 >> > > > > > > > SMSServer version: 3.4.0 >> > > > > > > > *log4j:WARN No appenders could be found for logger (smslib). >> > > > > > > > log4j:WARN Please initialize the log4j system properly.* >> > >> > > > > > > > My slj4log files are at: >> > >> > > > > > > > * Directory of C:\Program >> Files\Java\jdk1.5.0_10\jre\lib\ext* >> > >> > > > > > > > [.] [..] >> > > activation.jar >> > > > > > > > comm.jar commons-net-2.0.jar >> dnsns.jar >> > > > > > > > localedata.jar log4j-1.2.15.jar mail.jar >> > > > > > > > slf4j-api-1.5.6.jar slf4j-log4j12-1.5.6.jar >> > > > > sunjce_provider.jar >> > > > > > > > sunpkcs11.jar >> > >> > > > > > > > I got no idea what I'm missing, can someone enlighten me >> what I'm >> > > > > doing >> > > > > > > > wrong? >> > >> > > > > > > > Warmest regards, >> > > > > > > > David Chua- Hide quoted text - >> > >> > > > > > - Show quoted text -- Hide quoted text - >> > >> > > > - Show quoted text -- 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 -~----------~----~----~----~------~----~------~--~---
