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 <[EMAIL PROTECTED]>
>To: 'chaloo banda ' <[EMAIL PROTECTED]>
>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: [EMAIL PROTECTED]
>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 <[EMAIL PROTECTED]>
> >To: 'chaloo banda ' <[EMAIL PROTECTED]>
> >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: [EMAIL PROTECTED]
> >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 <[EMAIL PROTECTED]>
> > >To: 'chaloo banda ' <[EMAIL PROTECTED]>
> > >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: [EMAIL PROTECTED]
> > >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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
