All settings in TurbineResource.properties are correct. I have never used jisql before, I think I need to find out how to use it.
----- Original Message ----- From: "Brekke, Jeff" <[EMAIL PROTECTED]> To: "'Turbine Users List'" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 9:45 PM Subject: RE: Connect to Sybase on Linux > Doesn't look look like your connecting to sybase at all, are your > url/username/password correct? > Can you connect to sybase using the same url/uname/pass with jisql? > > ----------------------------------------------------------------- > Jeffrey D. Brekke Quad/Graphics > [EMAIL PROTECTED] http://www.qg.com > ----------------------------------------------------------------- > > > > > -----Original Message----- > > From: KL Tse [mailto:[EMAIL PROTECTED]] > > Sent: Friday, December 07, 2001 7:13 AM > > To: Turbine Users List > > Subject: Re: Connect to Sybase on Linux > > > > > > The corresponding sybase settings are : > > database.default.driver=com.sybase.jdbc2.jdbc.SybDriver > > database.default.url=jdbc:sybase:Tds:www.server.com:7100/jm > > database.default.username=sa > > database.default.password=2528sallmanns5079 > > > > database.adaptor=DBSybase > > database.adaptor.DBSybase=com.sybase.jdbc2.jdbc.SybDriver > > > > The following is the relevant log section, any ideas about it ? > > > > > > [Fri Dec 07 21:15:52 HKT 2001] -- WARN -- IDBroker is being > > used with db: > > default > > which does not support transactions. It is possible to > > generate duplicate keys, if multiple JVM's are used or other > > means are used to write to the database. > > [Fri Dec 07 21:15:52 HKT 2001] -- ERROR -- > > Exception: java.sql.SQLException: JZ006: Caught IOException: > > java.net.ConnectException: Connection refused > > Stack Trace follows: > > java.sql.SQLException: JZ006: Caught IOException: > > java.net.ConnectException: Connection refused > > at > > com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:467) > > at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:2919) > > at com.sybase.jdbc2.tds.Tds.login(Tds.java:393) > > at > > com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:219) > > at > > com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnecti > > on.java:195) > > at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174) > > at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126) > > at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:173) > > at java.sql.DriverManager.getConnection(DriverManager.java:517) > > at java.sql.DriverManager.getConnection(DriverManager.java:177) > > at org.apache.turbine.util.db.adapter.DB.getConnection(DB.java:153) > > at > > org.apache.turbine.util.db.pool.ConnectionPool.getNewConnectio > > n(ConnectionPo > > ol.java:498) > > at > > org.apache.turbine.util.db.pool.ConnectionPool.getConnection(C > > onnectionPool. > > java:339) > > at > > org.apache.turbine.services.db.TurbinePoolBrokerService.getCon > > nection(Turbin > > ePoolBrokerService.java:171) > > at > > org.apache.turbine.services.db.TurbinePoolBrokerService.getCon > > nection(Turbin > > ePoolBrokerService.java:145) > > at > > org.apache.turbine.services.db.TurbineDB.getConnection(Turbine > > DB.java:169) > > at > > org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:217) > > at > > org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:194) > > at > > org.apache.turbine.om.security.peer.TurbineUserPeer.<clinit>(T > > urbineUserPeer > > .java) > > at > > org.apache.turbine.services.security.db.DBUserManager.retrieve > > (DBUserManager > > .java:158) > > at > > org.apache.turbine.services.security.db.DBUserManager.retrieve > > (DBUserManager > > .java:246) > > at > > org.apache.turbine.services.security.BaseSecurityService.getAu > > thenticatedUse > > r(BaseSecurityService.java:313) > > at > > org.apache.turbine.services.security.TurbineSecurity.getAuthen > > ticatedUser(Tu > > rbineSecurity.java:199) > > at > > org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUs > > er.java:103) > > at org.apache.turbine.modules.Action.perform(Action.java:87) > > at > > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) > > at org.apache.turbine.Turbine.doGet(Turbine.java:393) > > at org.apache.turbine.Turbine.doPost(Turbine.java:537) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > > er(Application > > FilterChain.java:247) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > > cationFilterCh > > ain.java:193) > > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > > rapperValve.ja > > va:255) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 66) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > ine.java:472) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardC > > ontextValve.ja > > va:225) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 66) > > at > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Aut > > henticatorBase > > .java:472) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 64) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > ine.java:472) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > at > > org.apache.catalina.core.StandardContext.invoke(StandardContex > > t.java:2252) > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > > Valve.java:164 > > ) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 66) > > at > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > > e.java:446) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 64) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > ine.java:472) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > > gineValve.java > > :163) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 66) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > ine.java:472) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > at > > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > > rocessor.java: > > 875) > > at > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > > ssor.java:952) > > at java.lang.Thread.run(Thread.java:484) > > > > [Fri Dec 07 21:15:52 HKT 2001] -- ERROR -- > > Turbine.handleException: Error in > > BasePeer.initTableSchema(TURBINE_USER): JZ006: Caught IOException: > > java.net.ConnectException: Connection refused > > [Fri Dec 07 21:15:52 HKT 2001] -- ERROR -- > > Exception: java.lang.Error: Error in > > BasePeer.initTableSchema(TURBINE_USER): JZ006: Caught IOException: > > java.net.ConnectException: Connection refused > > Stack Trace follows: > > java.lang.Error: Error in > > BasePeer.initTableSchema(TURBINE_USER): JZ006: > > Caught IOException: java.net.ConnectException: Connection refused > > at > > org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:232) > > at > > org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:194) > > at > > org.apache.turbine.om.security.peer.TurbineUserPeer.<clinit>(T > > urbineUserPeer > > .java) > > at > > org.apache.turbine.services.security.db.DBUserManager.retrieve > > (DBUserManager > > .java:158) > > at > > org.apache.turbine.services.security.db.DBUserManager.retrieve > > (DBUserManager > > .java:246) > > at > > org.apache.turbine.services.security.BaseSecurityService.getAu > > thenticatedUse > > r(BaseSecurityService.java:313) > > at > > org.apache.turbine.services.security.TurbineSecurity.getAuthen > > ticatedUser(Tu > > rbineSecurity.java:199) > > at > > org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUs > > er.java:103) > > at org.apache.turbine.modules.Action.perform(Action.java:87) > > at > > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) > > at org.apache.turbine.Turbine.doGet(Turbine.java:393) > > at org.apache.turbine.Turbine.doPost(Turbine.java:537) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > > er(Application > > FilterChain.java:247) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > > cationFilterCh > > ain.java:193) > > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > > rapperValve.ja > > va:255) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 66) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > ine.java:472) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardC > > ontextValve.ja > > va:225) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 66) > > at > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Aut > > henticatorBase > > .java:472) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 64) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > ine.java:472) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > at > > org.apache.catalina.core.StandardContext.invoke(StandardContex > > t.java:2252) > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > > Valve.java:164 > > ) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 66) > > at > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > > e.java:446) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 64) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > ine.java:472) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > > gineValve.java > > :163) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > ipeline.java:5 > > 66) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > ine.java:472) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > at > > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > > rocessor.java: > > 875) > > at > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > > ssor.java:952) > > at java.lang.Thread.run(Thread.java:484) > > > > ----- Original Message ----- > > From: "Colm McCartan" <[EMAIL PROTECTED]> > > To: "Turbine Users List" <[EMAIL PROTECTED]> > > Sent: Friday, December 07, 2001 8:11 PM > > Subject: Re: Connect to Sybase on Linux > > > > > > > > > > > > > KL Tse wrote: > > > > > > > Dear All, > > > > I have problem in connecting to sybase on Linux. I have > > already created > > the > > > > database and tables. I believes that Database Url and > > Driver settings > > are > > > > correct. After I have input the user name and password of > > the newapp, > > the > > > > center is displayed an error at the middle with menu on > > the left side. > > > > > > > > > Whats in the error logs? > > > > > > Have you added not only your database connection variables in > > > TurbineResources.properties but also the correct adapter lines? e.g. > > > > > > database.default.driver=org.postgresql.Driver > > > database.default.url=jdbc:postgresql://127.0.0.1/dbname > > > database.default.username=turbine > > > database.default.password=****** > > > > > > database.adaptor=DBPostgres > > > database.adaptor.DBPostgres=org.postgresql.Driver > > > > > > c > > > > > > > > > > > > > > > -- > > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > > _________________________________________________________ > > > > Do You Yahoo!? > > > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
