You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by chaloo banda <ch...@hotmail.com> on 2001/09/13 09:20:37 UTC
RE: please help me with mysql !!!
good morning !
today i started mysql as a service(having acquired admin privileges for
my comp.! ) ,did " NET START mysql " , changed the database user name to
root and password "" ....
...and now i am able access whatever entries i had put manually in the
database...i am even able to edit the user details ( a confirmation mail and
the confirmation key page also comes...)...
but still when i try to create new user....it takes me to the home
page...and in my jetspeed.log , following appears...
[Thu Sep 13 12:26:41 GMT+05:30 2001] -- INFO -- PSML-Man: calculated
resource:anon\html\en\US\default.psml. Base:
E:\tom1\webapps\jetspeed\WEB-INF\psml
[Thu Sep 13 12:26:41 GMT+05:30 2001] -- INFO -- CastorPsmlManager: about to
return null doc:
[Thu Sep 13 12:26:41 GMT+05:30 2001] -- INFO -- PSML-Man: calculated
resource:anon\html\en\default.psml. Base:
E:\tom1\webapps\jetspeed\WEB-INF\psml
[Thu Sep 13 12:26:41 GMT+05:30 2001] -- DEBUG -- JetspeedTemplatePage:
requested template = NewAccount.vm
[Thu Sep 13 12:26:41 GMT+05:30 2001] -- DEBUG -- template exists:
E:\tom1\webapps\jetspeed\WEB-INF\templates\vm\screens\html\NewAccount.vm
returning /html/NewAccount.vm
[Thu Sep 13 12:26:41 GMT+05:30 2001] -- DEBUG -- JetspeedTemplatePage:
calculated template = /html/NewAccount.vm
[Thu Sep 13 12:26:41 GMT+05:30 2001] -- DEBUG -- template exists:
E:\tom1\webapps\jetspeed\WEB-INF\templates\vm\layouts\html\default.vm
returning /html/default.vm
[Thu Sep 13 12:26:41 GMT+05:30 2001] -- DEBUG -- JetspeedTemplatePage:
layoutTemplate is finally /html/default.vm
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- INFO -- PSML-Man: calculated
resource:anon\html\en\US\default.psml. Base:
E:\tom1\webapps\jetspeed\WEB-INF\psml
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- INFO -- CastorPsmlManager: about to
return null doc:
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- INFO -- PSML-Man: calculated
resource:anon\html\en\default.psml. Base:
E:\tom1\webapps\jetspeed\WEB-INF\psml
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- SELECT
TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE,
TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL,
TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED,
TURBINE_USER.LASTLOGIN, TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE
(TURBINE_USER.LOGIN_NAME='pavan')
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- SELECT
TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE,
TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL,
TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED,
TURBINE_USER.LASTLOGIN, TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE
(TURBINE_USER.LOGIN_NAME='pavan')
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- INFO -- Forced id retrieval - no
available vector
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- JetspeedTemplatePage:
requested template = Error.vm
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- template exists:
E:\tom1\webapps\jetspeed\WEB-INF\templates\vm\screens\html\Error.vm
returning /html/Error.vm
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- JetspeedTemplatePage:
calculated template = /html/Error.vm
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- template exists:
E:\tom1\webapps\jetspeed\WEB-INF\templates\vm\layouts\html\default.vm
returning /html/default.vm
[Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- JetspeedTemplatePage:
layoutTemplate is finally /html/default.vm
[Thu Sep 13 12:27:11 GMT+05:30 2001] -- INFO -- DaemonThread -> PROCESSING
daemon -> feeddaemon
[Thu Sep 13 12:27:11 GMT+05:30 2001] -- INFO -- Jetspeed: FeedDaemon --
BEGIN --
[Thu Sep 13 12:27:11 GMT+05:30 2001] -- INFO -- Jetspeed: FeedDaemon --
END --
[Thu Sep 13 12:27:11 GMT+05:30 2001] -- INFO -- DaemonThread -> *DONE*
PROCESSING daemon -> feeddaemon
[Thu Sep 13 12:27:12 GMT+05:30 2001] -- INFO -- DaemonThread -> PROCESSING
daemon -> diskcachedaemon
[Thu Sep 13 12:27:12 GMT+05:30 2001] -- INFO -- parsing out document store
[Thu Sep 13 12:27:12 GMT+05:30 2001] -- INFO -- Calling JetspeedDiskCache
getEntries
[Thu Sep 13 12:27:12 GMT+05:30 2001] -- INFO -- DaemonThread -> *DONE*
PROCESSING daemon -> diskcachedaemon
any idea , where else do i have to modify ???
thanking you for all your support.
CB
>From: Rajeswari Venkatachalam <rv...@eforceglobal.com>
>To: 'chaloo banda ' <ch...@hotmail.com>
>Subject: RE: please help me with mysql !!!
>Date: Wed, 12 Sep 2001 09:01:19 -0700
>
>
>how do you start mysql? I start it like this:
> > net start mysql
>
>-Raje
>
>-----Original Message-----
>From: chaloo banda
>To: rvenkatachalam@eforceglobal.com
>Sent: 9/12/01 8:45 AM
>Subject: RE: please help me with mysql !!!
>
>hi !
> i did as you said but with the same output. i am indeed not able to
>telnet.in my task manager i have one mysqld-nt.exe process and another
>winmysqladmin.e process.
>
>my winmysqladmin1.3 (GUI tool) shows the following
>
>#This File was made using the WinMySQLAdmin 1.3 Tool
>#9-9-01 4:47:25 PM
>
>#Uncomment or Add only the keys that you know how works.
>#Read the MySQL Manual for instructions
>
>[mysqld]
>basedir=C:/mysql
>bind-address=53.248.60.53
>datadir=C:/mysql/data
>#language=E:/mysql/share/your language directory
>#slow query log#=
>tmpdir=C:/temp/
>port=3306
>#set-variable=key_buffer=16M
>[WinMySQLadmin]
>Server=C:/mysql/bin/mysqld-nt.exe
>user=ranjanwa
>password=password
>
>mysql is being run in the stand-alone mode.
>
>please advise,
>
>CB
>
>
> >From: Rajeswari Venkatachalam <rv...@eforceglobal.com>
> >To: 'chaloo banda ' <ch...@hotmail.com>
> >Subject: RE: please help me with mysql !!!
> >Date: Wed, 12 Sep 2001 08:25:18 -0700
> >
> >
> >This could be remnants from previous run. So kill mysql processes using
> >taskmanager and then start a new copy. After that, try to telnet to
>this
> >port.
> >
> >-raje
> >
> >-----Original Message-----
> >From: chaloo banda
> >To: rvenkatachalam@eforceglobal.com
> >Sent: 9/12/01 8:12 AM
> >Subject: RE: please help me with mysql !!!
> >
> >
> >a great many thanks for your reply !
> >
> >u r right...when i do "telent localhost 3306 "...i get connection
>failed
> >.
> >
> >but also when i do "netstat -na" i get the following....
> >TCP 53.248.60.53:3306 0.0.0.0:0 LISTENING
> >
> >can u please explain the above?
> >
> >thanking you
> >
> >CB
> >
> > >From: Rajeswari Venkatachalam <rv...@eforceglobal.com>
> > >To: 'chaloo banda ' <ch...@hotmail.com>
> > >Subject: RE: please help me with mysql !!!
> > >Date: Wed, 12 Sep 2001 07:53:26 -0700
> > >
> > > 1. Here is the URL that I use for mysql:
> > > database.default.url=jdbc:mysql://localhost:3306/mysql
> > >On yours I noticed you use jetspeed database. Did you explicitly
>create
> >
> > >that
> > >database???? I used the default mysql database.
> > >
> > >2. To make sure mysql is up and running try this:
> > > > telnet localhost 3306
> > > If you get error, then this service has not been started properly.
> >look
> > >at
> > >it.
> > >
> > >-Raje
> > >
> > >
> > >
> > >-----Original Message-----
> > >From: chaloo banda
> > >To: fth4mura@yahoo.com
> > >Sent: 9/12/01 7:44 AM
> > >Subject: please help me with mysql !!!
> > >
> > >hello sir !
> > > i found your id in the mailing list. please help me with the
> > >following .
> > >
> > > i am trying to use mysql as the database for jetspeed.
> > > i have configured the TR.P as under...
> > >
> > >database.default.driver=org.gjt.mm.mysql.Driver
> > >database.default.url=jdbc:mysql://localhost:3306/jetspeed
> > >
> > >database.default.username=ranjanwa
> > >database.default.password=password
> > >(i have checked with mysqladmin that my database runs with the above
> > >user
> > >name and password ! )
> > >
> > >database.adaptor=DBMM
> > >database.adaptor.DBMM=org.gjt.mm.mysql.Driver
> > >
> > >database.idbroker.cleverquantity=true
> > >
> > >next i created all the tables as given in
> > >src/sql/external/turbine-mysql.sql
> > >and populated them with the values given in populate-mysql.sql
> > >(these i did manually...and checked that the tables exist and are
> > >populated.)
> > >
> > >i have mm.mysql-2.0.4-bin (jar file) in jetspeed/web-inf/lib and in
> > >web-inf/db . i also have mm.mysql-2.0.4(not bin !) in my tomcat/lib.
> > >
> > >now i start mysql(i have tried to run it in stand-alone as well as in
> > >service mode !), start jetspeed .the first page comes well. but when
>i
> > >try
> > >to access any of the default user (admin or turbine ) or try to
>create
> > >new
> > >user it takes me to the home page(and not the expected confirmation
>key
> > >page
> > >! )...and my jetspeed.log gives the following error....
> > >
> > >Wed Sep 12 16:49:20 GMT+05:30 2001] -- ERROR --
> >Turbine.handleException:
> > >
> > >Error in BasePeer.initTableSchema(TURBINE_USER): Cannot connect to
> >MySQL
> > >
> > >server on localhost:3306. Is there a MySQL server running on the
> > >machine/port you are trying to connect to?
>(java.net.ConnectException)
> > >[Wed Sep 12 16:49:20 GMT+05:30 2001] -- ERROR --
> > > Exception: java.lang.Error: Error in
> > >BasePeer.initTableSchema(TURBINE_USER): Cannot connect to MySQL
>server
> > >on
> > >localhost:3306. Is there a MySQL server running on the machine/port
>you
> > >are
> > >trying to connect to? (java.net.ConnectException)
> > > Stack Trace follows:
> > > java.lang.Error: Error in
> > >BasePeer.initTableSchema(TURBINE_USER): Cannot
> > >connect to MySQL server on localhost:3306. Is there a MySQL server
> > >running
> > >on the machine/port you are trying to connect to?
> > >(java.net.ConnectException)
> > > 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>(TurbineUse
> >r
> > >Peer.java)
> > > at
> >
> >org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserMa
> >n
> > >ager.java:158)
> > > at
> >
> >org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserMa
> >n
> > >ager.java:246)
> > > at
> >
> >org.apache.turbine.services.security.BaseSecurityService.getAuthenticat
> >e
> > >dUser(BaseSecurityService.java:313)
> > > at
> >
> >org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUs
> >e
> > >r(TurbineSecurity.java:199)
> > > at
> >
> >org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:1
> >0
> > >3)
> > > at org.apache.turbine.modules.Action.perform(Action.java:87)
> > >
> > >and ...
> > >
> > >[Wed Sep 12 17:01:51 GMT+05:30 2001] -- INFO -- Entering JLoginUser
> > >action
> > >[Wed Sep 12 17:01:51 GMT+05:30 2001] -- ERROR --
> > >Turbine.handleException:
> > >null
> > >[Wed Sep 12 17:01:51 GMT+05:30 2001] -- ERROR --
> > > Exception: java.lang.NoClassDefFoundError
> > > Stack Trace follows:
> > > java.lang.NoClassDefFoundError
> > > at
> >
> >org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserMa
> >n
> > >ager.java:158)
> > > at
> >
> >org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserMa
> >n
> > >ager.java:246)
> > > at
> >
> >org.apache.turbine.services.security.BaseSecurityService.getAuthenticat
> >e
> > >dUser(BaseSecurityService.java:313)
> > > at
> >
> >org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUs
> >e
> > >r(TurbineSecurity.java:199)
> > > at
> >
> >org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:1
> >0
> > >3)
> > > at org.apache.turbine.modules.Action.perform(Action.java:87)
> > > at
> > >org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
> > > at
> >
> >org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.jav
> >a
> > >:143)
> > > 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.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405
> >)
> > > at org.apache.tomcat.core.Handler.service(Handler.java:287)
> > > at
> >
> >org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> > > at
> >
> >org.apache.tomcat.core.ContextManager.internalService(ContextManager.ja
> >v
> > >a:797)
> > > at
> >
> >org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
> > >
> > >i am simply at my wits end trying to find out where did i go wrong.
> > >is this a problem of wrong mysql installation(but i followed the
>manual
> > >!)as
> > >with hsql i had my jetspeed running real smooth.
> > >
> > >or is this some permission mismatch for mysql ?
> > >
> > >in my jetspeed/web-inf/db i have the attached files. please have a
>look
> > >at
> > >them and suggest.
> > >
> > > i am using mysql3.23.41
> > > jetspeed(latest)
> > > tomcat 3.2.2
> > > apache 1.3.11
> > > windows NT 4.0 workstation
> > >
> > >I apologize for sending so long a mail and that too with attachments
>!
> > >
> > >please accept my thanx in advance,
> > >
> > >CB
> > >
> > >_________________________________________________________________
> > >Get your FREE download of MSN Explorer at
> > >http://explorer.msn.com/intl.asp
> > > <<jetspeed.backup>> <<jetspeed.data>> <<jetspeed.properties>>
> > ><<jetspeed.script>> <<manageDB.bat>> <<mm.mysql-2.0.4-bin.jar>>
> >
> >
> >_________________________________________________________________
> >Get your FREE download of MSN Explorer at
> >http://explorer.msn.com/intl.asp
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at
>http://explorer.msn.com/intl.asp
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
RE: please help me with mysql !!!
Posted by David Sean Taylor <da...@bluesunrise.com>.
im not sure what the problem is
it seems to be working fine from the log
go to http://www.bluesunrise.com/jetspeed and see if it works the same as on
your system
> -----Original Message-----
> From: chaloo banda [mailto:chaloo_banda@hotmail.com]
> Sent: Thursday, September 13, 2001 12:21 AM
> To: rvenkatachalam@eforceglobal.com
> Subject: RE: please help me with mysql !!!
>
>
>
> good morning !
> today i started mysql as a service(having acquired admin
> privileges for
> my comp.! ) ,did " NET START mysql " , changed the database
> user name to
> root and password "" ....
>
> ...and now i am able access whatever entries i had put
> manually in the
> database...i am even able to edit the user details ( a
> confirmation mail and
> the confirmation key page also comes...)...
>
> but still when i try to create new user....it takes me to the home
> page...and in my jetspeed.log , following appears...
>
> [Thu Sep 13 12:26:41 GMT+05:30 2001] -- INFO -- PSML-Man: calculated
> resource:anon\html\en\US\default.psml. Base:
> E:\tom1\webapps\jetspeed\WEB-INF\psml
> [Thu Sep 13 12:26:41 GMT+05:30 2001] -- INFO --
> CastorPsmlManager: about to
> return null doc:
> [Thu Sep 13 12:26:41 GMT+05:30 2001] -- INFO -- PSML-Man: calculated
> resource:anon\html\en\default.psml. Base:
> E:\tom1\webapps\jetspeed\WEB-INF\psml
> [Thu Sep 13 12:26:41 GMT+05:30 2001] -- DEBUG --
> JetspeedTemplatePage:
> requested template = NewAccount.vm
> [Thu Sep 13 12:26:41 GMT+05:30 2001] -- DEBUG -- template exists:
> E:\tom1\webapps\jetspeed\WEB-INF\templates\vm\screens\html\New
> Account.vm
> returning /html/NewAccount.vm
> [Thu Sep 13 12:26:41 GMT+05:30 2001] -- DEBUG --
> JetspeedTemplatePage:
> calculated template = /html/NewAccount.vm
> [Thu Sep 13 12:26:41 GMT+05:30 2001] -- DEBUG -- template exists:
> E:\tom1\webapps\jetspeed\WEB-INF\templates\vm\layouts\html\default.vm
> returning /html/default.vm
> [Thu Sep 13 12:26:41 GMT+05:30 2001] -- DEBUG --
> JetspeedTemplatePage:
> layoutTemplate is finally /html/default.vm
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- INFO -- PSML-Man: calculated
> resource:anon\html\en\US\default.psml. Base:
> E:\tom1\webapps\jetspeed\WEB-INF\psml
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- INFO --
> CastorPsmlManager: about to
> return null doc:
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- INFO -- PSML-Man: calculated
> resource:anon\html\en\default.psml. Base:
> E:\tom1\webapps\jetspeed\WEB-INF\psml
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- SELECT
> TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME,
> TURBINE_USER.PASSWORD_VALUE,
> TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL,
> TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED,
> TURBINE_USER.CREATED,
> TURBINE_USER.LASTLOGIN, TURBINE_USER.OBJECTDATA FROM
> TURBINE_USER WHERE
> (TURBINE_USER.LOGIN_NAME='pavan')
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- SELECT
> TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME,
> TURBINE_USER.PASSWORD_VALUE,
> TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL,
> TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED,
> TURBINE_USER.CREATED,
> TURBINE_USER.LASTLOGIN, TURBINE_USER.OBJECTDATA FROM
> TURBINE_USER WHERE
> (TURBINE_USER.LOGIN_NAME='pavan')
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- INFO -- Forced id
> retrieval - no
> available vector
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG --
> JetspeedTemplatePage:
> requested template = Error.vm
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- template exists:
> E:\tom1\webapps\jetspeed\WEB-INF\templates\vm\screens\html\Error.vm
> returning /html/Error.vm
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG --
> JetspeedTemplatePage:
> calculated template = /html/Error.vm
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG -- template exists:
> E:\tom1\webapps\jetspeed\WEB-INF\templates\vm\layouts\html\default.vm
> returning /html/default.vm
> [Thu Sep 13 12:27:08 GMT+05:30 2001] -- DEBUG --
> JetspeedTemplatePage:
> layoutTemplate is finally /html/default.vm
> [Thu Sep 13 12:27:11 GMT+05:30 2001] -- INFO -- DaemonThread
> -> PROCESSING
> daemon -> feeddaemon
> [Thu Sep 13 12:27:11 GMT+05:30 2001] -- INFO -- Jetspeed:
> FeedDaemon --
> BEGIN --
> [Thu Sep 13 12:27:11 GMT+05:30 2001] -- INFO -- Jetspeed:
> FeedDaemon --
> END --
> [Thu Sep 13 12:27:11 GMT+05:30 2001] -- INFO -- DaemonThread
> -> *DONE*
> PROCESSING daemon -> feeddaemon
> [Thu Sep 13 12:27:12 GMT+05:30 2001] -- INFO -- DaemonThread
> -> PROCESSING
> daemon -> diskcachedaemon
> [Thu Sep 13 12:27:12 GMT+05:30 2001] -- INFO -- parsing out
> document store
> [Thu Sep 13 12:27:12 GMT+05:30 2001] -- INFO -- Calling
> JetspeedDiskCache
> getEntries
> [Thu Sep 13 12:27:12 GMT+05:30 2001] -- INFO -- DaemonThread
> -> *DONE*
> PROCESSING daemon -> diskcachedaemon
>
> any idea , where else do i have to modify ???
>
> thanking you for all your support.
> CB
>
>
> >From: Rajeswari Venkatachalam <rv...@eforceglobal.com>
> >To: 'chaloo banda ' <ch...@hotmail.com>
> >Subject: RE: please help me with mysql !!!
> >Date: Wed, 12 Sep 2001 09:01:19 -0700
> >
> >
> >how do you start mysql? I start it like this:
> > > net start mysql
> >
> >-Raje
> >
> >-----Original Message-----
> >From: chaloo banda
> >To: rvenkatachalam@eforceglobal.com
> >Sent: 9/12/01 8:45 AM
> >Subject: RE: please help me with mysql !!!
> >
> >hi !
> > i did as you said but with the same output. i am indeed
> not able to
> >telnet.in my task manager i have one mysqld-nt.exe process
> and another
> >winmysqladmin.e process.
> >
> >my winmysqladmin1.3 (GUI tool) shows the following
> >
> >#This File was made using the WinMySQLAdmin 1.3 Tool
> >#9-9-01 4:47:25 PM
> >
> >#Uncomment or Add only the keys that you know how works.
> >#Read the MySQL Manual for instructions
> >
> >[mysqld]
> >basedir=C:/mysql
> >bind-address=53.248.60.53
> >datadir=C:/mysql/data
> >#language=E:/mysql/share/your language directory
> >#slow query log#=
> >tmpdir=C:/temp/
> >port=3306
> >#set-variable=key_buffer=16M
> >[WinMySQLadmin]
> >Server=C:/mysql/bin/mysqld-nt.exe
> >user=ranjanwa
> >password=password
> >
> >mysql is being run in the stand-alone mode.
> >
> >please advise,
> >
> >CB
> >
> >
> > >From: Rajeswari Venkatachalam <rv...@eforceglobal.com>
> > >To: 'chaloo banda ' <ch...@hotmail.com>
> > >Subject: RE: please help me with mysql !!!
> > >Date: Wed, 12 Sep 2001 08:25:18 -0700
> > >
> > >
> > >This could be remnants from previous run. So kill mysql
> processes using
> > >taskmanager and then start a new copy. After that, try to telnet to
> >this
> > >port.
> > >
> > >-raje
> > >
> > >-----Original Message-----
> > >From: chaloo banda
> > >To: rvenkatachalam@eforceglobal.com
> > >Sent: 9/12/01 8:12 AM
> > >Subject: RE: please help me with mysql !!!
> > >
> > >
> > >a great many thanks for your reply !
> > >
> > >u r right...when i do "telent localhost 3306 "...i get connection
> >failed
> > >.
> > >
> > >but also when i do "netstat -na" i get the following....
> > >TCP 53.248.60.53:3306 0.0.0.0:0 LISTENING
> > >
> > >can u please explain the above?
> > >
> > >thanking you
> > >
> > >CB
> > >
> > > >From: Rajeswari Venkatachalam <rv...@eforceglobal.com>
> > > >To: 'chaloo banda ' <ch...@hotmail.com>
> > > >Subject: RE: please help me with mysql !!!
> > > >Date: Wed, 12 Sep 2001 07:53:26 -0700
> > > >
> > > > 1. Here is the URL that I use for mysql:
> > > > database.default.url=jdbc:mysql://localhost:3306/mysql
> > > >On yours I noticed you use jetspeed database. Did you explicitly
> >create
> > >
> > > >that
> > > >database???? I used the default mysql database.
> > > >
> > > >2. To make sure mysql is up and running try this:
> > > > > telnet localhost 3306
> > > > If you get error, then this service has not been
> started properly.
> > >look
> > > >at
> > > >it.
> > > >
> > > >-Raje
> > > >
> > > >
> > > >
> > > >-----Original Message-----
> > > >From: chaloo banda
> > > >To: fth4mura@yahoo.com
> > > >Sent: 9/12/01 7:44 AM
> > > >Subject: please help me with mysql !!!
> > > >
> > > >hello sir !
> > > > i found your id in the mailing list. please help me with the
> > > >following .
> > > >
> > > > i am trying to use mysql as the database for jetspeed.
> > > > i have configured the TR.P as under...
> > > >
> > > >database.default.driver=org.gjt.mm.mysql.Driver
> > > >database.default.url=jdbc:mysql://localhost:3306/jetspeed
> > > >
> > > >database.default.username=ranjanwa
> > > >database.default.password=password
> > > >(i have checked with mysqladmin that my database runs
> with the above
> > > >user
> > > >name and password ! )
> > > >
> > > >database.adaptor=DBMM
> > > >database.adaptor.DBMM=org.gjt.mm.mysql.Driver
> > > >
> > > >database.idbroker.cleverquantity=true
> > > >
> > > >next i created all the tables as given in
> > > >src/sql/external/turbine-mysql.sql
> > > >and populated them with the values given in populate-mysql.sql
> > > >(these i did manually...and checked that the tables exist and are
> > > >populated.)
> > > >
> > > >i have mm.mysql-2.0.4-bin (jar file) in
> jetspeed/web-inf/lib and in
> > > >web-inf/db . i also have mm.mysql-2.0.4(not bin !) in my
> tomcat/lib.
> > > >
> > > >now i start mysql(i have tried to run it in stand-alone
> as well as in
> > > >service mode !), start jetspeed .the first page comes
> well. but when
> >i
> > > >try
> > > >to access any of the default user (admin or turbine ) or try to
> >create
> > > >new
> > > >user it takes me to the home page(and not the expected
> confirmation
> >key
> > > >page
> > > >! )...and my jetspeed.log gives the following error....
> > > >
> > > >Wed Sep 12 16:49:20 GMT+05:30 2001] -- ERROR --
> > >Turbine.handleException:
> > > >
> > > >Error in BasePeer.initTableSchema(TURBINE_USER): Cannot
> connect to
> > >MySQL
> > > >
> > > >server on localhost:3306. Is there a MySQL server running on the
> > > >machine/port you are trying to connect to?
> >(java.net.ConnectException)
> > > >[Wed Sep 12 16:49:20 GMT+05:30 2001] -- ERROR --
> > > > Exception: java.lang.Error: Error in
> > > >BasePeer.initTableSchema(TURBINE_USER): Cannot connect to MySQL
> >server
> > > >on
> > > >localhost:3306. Is there a MySQL server running on the
> machine/port
> >you
> > > >are
> > > >trying to connect to? (java.net.ConnectException)
> > > > Stack Trace follows:
> > > > java.lang.Error: Error in
> > > >BasePeer.initTableSchema(TURBINE_USER): Cannot
> > > >connect to MySQL server on localhost:3306. Is there a
> MySQL server
> > > >running
> > > >on the machine/port you are trying to connect to?
> > > >(java.net.ConnectException)
> > > > 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>(
> TurbineUse
> > >r
> > > >Peer.java)
> > > > at
> > >
> >
> >org.apache.turbine.services.security.db.DBUserManager.retriev
> e(DBUserMa
> > >n
> > > >ager.java:158)
> > > > at
> > >
> >
> >org.apache.turbine.services.security.db.DBUserManager.retriev
> e(DBUserMa
> > >n
> > > >ager.java:246)
> > > > at
> > >
> >
> >org.apache.turbine.services.security.BaseSecurityService.getA
> uthenticat
> > >e
> > > >dUser(BaseSecurityService.java:313)
> > > > at
> > >
> >
> >org.apache.turbine.services.security.TurbineSecurity.getAuthe
> nticatedUs
> > >e
> > > >r(TurbineSecurity.java:199)
> > > > at
> > >
> >
> >org.apache.turbine.modules.actions.LoginUser.doPerform(LoginU
> ser.java:1
> > >0
> > > >3)
> > > > at org.apache.turbine.modules.Action.perform(Action.java:87)
> > > >
> > > >and ...
> > > >
> > > >[Wed Sep 12 17:01:51 GMT+05:30 2001] -- INFO -- Entering
> JLoginUser
> > > >action
> > > >[Wed Sep 12 17:01:51 GMT+05:30 2001] -- ERROR --
> > > >Turbine.handleException:
> > > >null
> > > >[Wed Sep 12 17:01:51 GMT+05:30 2001] -- ERROR --
> > > > Exception: java.lang.NoClassDefFoundError
> > > > Stack Trace follows:
> > > > java.lang.NoClassDefFoundError
> > > > at
> > >
> >
> >org.apache.turbine.services.security.db.DBUserManager.retriev
> e(DBUserMa
> > >n
> > > >ager.java:158)
> > > > at
> > >
> >
> >org.apache.turbine.services.security.db.DBUserManager.retriev
> e(DBUserMa
> > >n
> > > >ager.java:246)
> > > > at
> > >
> >
> >org.apache.turbine.services.security.BaseSecurityService.getA
> uthenticat
> > >e
> > > >dUser(BaseSecurityService.java:313)
> > > > at
> > >
> >
> >org.apache.turbine.services.security.TurbineSecurity.getAuthe
> nticatedUs
> > >e
> > > >r(TurbineSecurity.java:199)
> > > > at
> > >
> >
> >org.apache.turbine.modules.actions.LoginUser.doPerform(LoginU
> ser.java:1
> > >0
> > > >3)
> > > > at org.apache.turbine.modules.Action.perform(Action.java:87)
> > > > at
> > >
> >org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
> > > > at
> > >
> >
> >org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLog
> inUser.jav
> > >a
> > > >:143)
> > > > 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.tomcat.core.ServletWrapper.doService(ServletWrappe
> r.java:405
> > >)
> > > > at org.apache.tomcat.core.Handler.service(Handler.java:287)
> > > > at
> > >
> >
> >org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.
> java:372)
> > > > at
> > >
> >
> >org.apache.tomcat.core.ContextManager.internalService(Context
> Manager.ja
> > >v
> > > >a:797)
> > > > at
> > >
> >
> >org.apache.tomcat.core.ContextManager.service(ContextManager.
> java:743)
> > > >
> > > >i am simply at my wits end trying to find out where did
> i go wrong.
> > > >is this a problem of wrong mysql installation(but i followed the
> >manual
> > > >!)as
> > > >with hsql i had my jetspeed running real smooth.
> > > >
> > > >or is this some permission mismatch for mysql ?
> > > >
> > > >in my jetspeed/web-inf/db i have the attached files.
> please have a
> >look
> > > >at
> > > >them and suggest.
> > > >
> > > > i am using mysql3.23.41
> > > > jetspeed(latest)
> > > > tomcat 3.2.2
> > > > apache 1.3.11
> > > > windows NT 4.0 workstation
> > > >
> > > >I apologize for sending so long a mail and that too with
> attachments
> >!
> > > >
> > > >please accept my thanx in advance,
> > > >
> > > >CB
> > > >
> > > >_________________________________________________________________
> > > >Get your FREE download of MSN Explorer at
> > > >http://explorer.msn.com/intl.asp
> > > > <<jetspeed.backup>> <<jetspeed.data>> <<jetspeed.properties>>
> > > ><<jetspeed.script>> <<manageDB.bat>> <<mm.mysql-2.0.4-bin.jar>>
> > >
> > >
> > >_________________________________________________________________
> > >Get your FREE download of MSN Explorer at
> > >http://explorer.msn.com/intl.asp
> >
> >
> >_________________________________________________________________
> >Get your FREE download of MSN Explorer at
> >http://explorer.msn.com/intl.asp
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org