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
-~----------~----~----~----~------~----~------~--~---
