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 Floßmann Christoph <Ch...@volke-muc.de> on 2004/05/12 12:41:37 UTC
mysql - no new user Entries
Here are my settings for the db connect:
torque.database.default=jetspeed
torque.database.jetspeed.adapter=mysql
torque.dsfactory.jetspeed.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
torque.dsfactory.jetspeed.pool.defaultMaxConnections=10
torque.dsfactory.jetspeed.pool.maxExpiryTime=3600
torque.dsfactory.jetspeed.pool.connectionWaitTimeout=10
### MySQL
torque.dsfactory.jetspeed.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.jetspeed.connection.url = jdbc:mysql://localhost:3306/jetspeed
torque.dsfactory.jetspeed.connection.user = portal
torque.dsfactory.jetspeed.connection.password =
My problem: The admin is unable to create new users.
After filling in the needed data, I click on the add user button and the table with all users is shown but the new one is missing.
Any solutions?
Kind regards
Chris
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: mysql - no new user Entries
Posted by Stefan Rennick Egglestone <sr...@Cs.Nott.AC.UK>.
There's this problem with the tommy turbine user that comes with the
database that jetspeed uses.
If you delete it, the admin servlet stops working! So this could be the
cause of your problem.
I've been looking into this a bit, because I was having a problem where
even thought I had added tommy back into the database, I still couldn't
use the admin servlet.
It turns out that not only do you need tommy turbine in your database,
you also need his psml pages to be in your <web app root>/WEB-INF/psml
directory. I'd deleted them. I think they're being used to create
default content when a new user is created.
Stef
Robin Antony wrote:
>Have you given access to the user portal in your mysql database? Because you
>are not logging into the database as root. Make sure you have given the
>appropriate permissions to user portal. Other than that is looks ok.
>
>Cheers,
>Robin Antony
>Software Engineer
>OpenSI.Net
>
>----- Original Message -----
>From: "Flomann Christoph" <Ch...@volke-muc.de>
>To: "Jetspeed Users List (E-Mail)" <je...@jakarta.apache.org>
>Sent: Wednesday, May 12, 2004 3:41 AM
>Subject: mysql - no new user Entries
>
>
>Here are my settings for the db connect:
>
>torque.database.default=jetspeed
>torque.database.jetspeed.adapter=mysql
>
>torque.dsfactory.jetspeed.factory=org.apache.torque.dsfactory.TorqueDataSour
>ceFactory
>torque.dsfactory.jetspeed.pool.defaultMaxConnections=10
>torque.dsfactory.jetspeed.pool.maxExpiryTime=3600
>torque.dsfactory.jetspeed.pool.connectionWaitTimeout=10
>### MySQL
>torque.dsfactory.jetspeed.connection.driver = org.gjt.mm.mysql.Driver
>torque.dsfactory.jetspeed.connection.url =
>jdbc:mysql://localhost:3306/jetspeed
>torque.dsfactory.jetspeed.connection.user = portal
>torque.dsfactory.jetspeed.connection.password =
>
>My problem: The admin is unable to create new users.
>After filling in the needed data, I click on the add user button and the
>table with all users is shown but the new one is missing.
>Any solutions?
>Kind regards
>Chris
>
>---------------------------------------------------------------------
>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
>
>
>
This message has been scanned but we cannot guarantee that it and any
attachments are free from viruses or other damaging content: you are
advised to perform your own checks. Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: mysql - no new user Entries
Posted by Stefan Rennick Egglestone <sr...@Cs.Nott.AC.UK>.
I sent the following earlier today, but it don't think it got through - stef
*********************************
There's this problem with the tommy turbine user that comes with the
database that jetspeed uses.
If you delete it, the admin servlet stops working! So this could be the
cause of your problem.
I've been looking into this a bit, because I was having a problem where
even thought I had added tommy back into the database, I still couldn't
use the admin servlet.
It turns out that not only do you need tommy turbine in your database,
you also need his psml pages to be in your <web app root>/WEB-INF/psml
directory. I'd deleted them. I think they're being used to create
default content when a new user is created.
Stef
*********************
Robin Antony wrote:
>Have you given access to the user portal in your mysql database? Because you
>are not logging into the database as root. Make sure you have given the
>appropriate permissions to user portal. Other than that is looks ok.
>
>Cheers,
>Robin Antony
>Software Engineer
>OpenSI.Net
>
>----- Original Message -----
>From: "Flomann Christoph" <Ch...@volke-muc.de>
>To: "Jetspeed Users List (E-Mail)" <je...@jakarta.apache.org>
>Sent: Wednesday, May 12, 2004 3:41 AM
>Subject: mysql - no new user Entries
>
>
>Here are my settings for the db connect:
>
>torque.database.default=jetspeed
>torque.database.jetspeed.adapter=mysql
>
>torque.dsfactory.jetspeed.factory=org.apache.torque.dsfactory.TorqueDataSour
>ceFactory
>torque.dsfactory.jetspeed.pool.defaultMaxConnections=10
>torque.dsfactory.jetspeed.pool.maxExpiryTime=3600
>torque.dsfactory.jetspeed.pool.connectionWaitTimeout=10
>### MySQL
>torque.dsfactory.jetspeed.connection.driver = org.gjt.mm.mysql.Driver
>torque.dsfactory.jetspeed.connection.url =
>jdbc:mysql://localhost:3306/jetspeed
>torque.dsfactory.jetspeed.connection.user = portal
>torque.dsfactory.jetspeed.connection.password =
>
>My problem: The admin is unable to create new users.
>After filling in the needed data, I click on the add user button and the
>table with all users is shown but the new one is missing.
>Any solutions?
>Kind regards
>Chris
>
>---------------------------------------------------------------------
>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
>
>
>
This message has been scanned but we cannot guarantee that it and any
attachments are free from viruses or other damaging content: you are
advised to perform your own checks. Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
RE: Moving jetspeed to mysql
Posted by Mark Orciuch <ma...@ngsltd.com>.
This is from the release 1.5 README file:
"The maven build is complete as of version 1.5. Tested with Maven 1.0 RC2."
Best regards,
Mark C. Orciuch
Next Generation Solutions, Ltd.
e-Mail: mark_orciuch@ngsltd.com
web: http://www.ngsltd.com
> -----Original Message-----
> From: Anony Musse [mailto:lists@empirion.homelinux.org]
> Sent: Friday, May 14, 2004 12:18 AM
> To: Jetspeed Users List
> Subject: Re: Moving jetspeed to mysql
>
>
> I had a thought - what do the current CVS committers do at this point?
> Would CVS be the best thing to use for Jetspeed-1 so that the tools like
> maven/ant could at least be verified to work with current CVS?
>
> I realized after I found maven rc1 and rc2 to act quite differently with
> the current Jetspeed 1.5 source, that perhaps it would be best to ask
> the basics - what version of external tools was the Jetspeed 1.5 source
> release built with? ( I assumed it worked on release date ...)
>
> Cheers,
> Jeremy
>
> Jeremy Kuhnash wrote:
>
> > Wanted to try and help ... possibly save some trouble:
> >
> > Basically use the attached schema like so -
> >
> > # mysql -u [username] -p [database] < portal_dump.sql
> >
> > Migrating to mysql with the new maven stuff seem to be very broken,
> > and the sql scripts in the distribution dont work for me (at least).
> > Luckily, I had a mysql database on a server that had the schema
> > installed but had never gotten jetspeed 1.4 to talk to it ... 1.5
> > talks to it but can't make the schema.
> >
> > Once you have that in place, your Torque.properties and whatever else
> > with the database stuff need changed, but after that it should work.
> >
> > I am currently working on getting PSML working against the database ..
> > probably a few more tweaks. Need to figure out how to do the initial
> > data population....
> >
> > Cheers,
> > Jeremy
>
>
>
> ---------------------------------------------------------------------
> 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
Re: Moving jetspeed to mysql
Posted by Anony Musse <li...@empirion.homelinux.org>.
I had a thought - what do the current CVS committers do at this point?
Would CVS be the best thing to use for Jetspeed-1 so that the tools like
maven/ant could at least be verified to work with current CVS?
I realized after I found maven rc1 and rc2 to act quite differently with
the current Jetspeed 1.5 source, that perhaps it would be best to ask
the basics - what version of external tools was the Jetspeed 1.5 source
release built with? ( I assumed it worked on release date ...)
Cheers,
Jeremy
Jeremy Kuhnash wrote:
> Wanted to try and help ... possibly save some trouble:
>
> Basically use the attached schema like so -
>
> # mysql -u [username] -p [database] < portal_dump.sql
>
> Migrating to mysql with the new maven stuff seem to be very broken,
> and the sql scripts in the distribution dont work for me (at least).
> Luckily, I had a mysql database on a server that had the schema
> installed but had never gotten jetspeed 1.4 to talk to it ... 1.5
> talks to it but can't make the schema.
>
> Once you have that in place, your Torque.properties and whatever else
> with the database stuff need changed, but after that it should work.
>
> I am currently working on getting PSML working against the database ..
> probably a few more tweaks. Need to figure out how to do the initial
> data population....
>
> Cheers,
> Jeremy
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
RE: Moving jetspeed to mysql
Posted by Daniel SELAM <da...@atosorigin.com>.
Thanks Jeremy for the script, but I've already built the jetspeed schema in
mySQL database.
My issue comes during the maven compilation (maven war).
Here is an extract of my torque.properties file :
torque.database.default=jetspeed
torque.database.jetspeed.adapter=mysql
torque.dsfactory.jetspeed.factory=org.apache.torque.dsfactory.TorqueDataSour
ceFactory
# The number of database connections to cache per ConnectionPool instance
(specified per database)
torque.dsfactory.jetspeed.pool.defaultMaxConnections=10
torque.dsfactory.jetspeed.pool.maxExpiryTime=3600
torque.dsfactory.jetspeed.pool.connectionWaitTimeout=10
### MySQL
torque.dsfactory.jetspeed.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.jetspeed.connection.url =
jdbc:mysql://localhost:3306/jetspeed
torque.dsfactory.jetspeed.connection.user = root
torque.dsfactory.jetspeed.connection.password =
Any help would be welcome,
Daniel.
-----Message d'origine-----
De : Jeremy Kuhnash [mailto:lists@empirion.homelinux.org]
Envoyé : vendredi 14 mai 2004 02:46
À : Jetspeed Users List
Objet : Re: Moving jetspeed to mysql
Wanted to try and help ... possibly save some trouble:
Basically use the attached schema like so -
# mysql -u [username] -p [database] < portal_dump.sql
Migrating to mysql with the new maven stuff seem to be very broken, and
the sql scripts in the distribution dont work for me (at least).
Luckily, I had a mysql database on a server that had the schema
installed but had never gotten jetspeed 1.4 to talk to it ... 1.5 talks
to it but can't make the schema.
Once you have that in place, your Torque.properties and whatever else
with the database stuff need changed, but after that it should work.
I am currently working on getting PSML working against the database ..
probably a few more tweaks. Need to figure out how to do the initial
data population....
Cheers,
Jeremy
Daniel SELAM wrote:
>Hi,
>
>I try to move jetspeed to mysql db following the online doc.
>I've changed project.properties and torque.properties accordingly, but get
>this error message during maven compilation :
>
>[junit] ERROR - Property: driver value: org.gjt.mm.mysql.Driver is not
>supported by DataSource:
>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS
>
>Any idea ?
>Thanks !
>
>Daniel.
>
>
>
>---------------------------------------------------------------------
>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
Re: Moving jetspeed to mysql
Posted by Jeremy Kuhnash <li...@empirion.homelinux.org>.
Wanted to try and help ... possibly save some trouble:
Basically use the attached schema like so -
# mysql -u [username] -p [database] < portal_dump.sql
Migrating to mysql with the new maven stuff seem to be very broken, and
the sql scripts in the distribution dont work for me (at least).
Luckily, I had a mysql database on a server that had the schema
installed but had never gotten jetspeed 1.4 to talk to it ... 1.5 talks
to it but can't make the schema.
Once you have that in place, your Torque.properties and whatever else
with the database stuff need changed, but after that it should work.
I am currently working on getting PSML working against the database ..
probably a few more tweaks. Need to figure out how to do the initial
data population....
Cheers,
Jeremy
Daniel SELAM wrote:
>Hi,
>
>I try to move jetspeed to mysql db following the online doc.
>I've changed project.properties and torque.properties accordingly, but get
>this error message during maven compilation :
>
>[junit] ERROR - Property: driver value: org.gjt.mm.mysql.Driver is not
>supported by DataSource:
>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS
>
>Any idea ?
>Thanks !
>
>Daniel.
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
>
Moving jetspeed to mysql
Posted by Daniel SELAM <da...@atosorigin.com>.
Hi,
I try to move jetspeed to mysql db following the online doc.
I've changed project.properties and torque.properties accordingly, but get
this error message during maven compilation :
[junit] ERROR - Property: driver value: org.gjt.mm.mysql.Driver is not
supported by DataSource:
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS
Any idea ?
Thanks !
Daniel.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: mysql - no new user Entries
Posted by Robin Antony <ro...@opensi.net>.
Have you given access to the user portal in your mysql database? Because you
are not logging into the database as root. Make sure you have given the
appropriate permissions to user portal. Other than that is looks ok.
Cheers,
Robin Antony
Software Engineer
OpenSI.Net
----- Original Message -----
From: "Floßmann Christoph" <Ch...@volke-muc.de>
To: "Jetspeed Users List (E-Mail)" <je...@jakarta.apache.org>
Sent: Wednesday, May 12, 2004 3:41 AM
Subject: mysql - no new user Entries
Here are my settings for the db connect:
torque.database.default=jetspeed
torque.database.jetspeed.adapter=mysql
torque.dsfactory.jetspeed.factory=org.apache.torque.dsfactory.TorqueDataSour
ceFactory
torque.dsfactory.jetspeed.pool.defaultMaxConnections=10
torque.dsfactory.jetspeed.pool.maxExpiryTime=3600
torque.dsfactory.jetspeed.pool.connectionWaitTimeout=10
### MySQL
torque.dsfactory.jetspeed.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.jetspeed.connection.url =
jdbc:mysql://localhost:3306/jetspeed
torque.dsfactory.jetspeed.connection.user = portal
torque.dsfactory.jetspeed.connection.password =
My problem: The admin is unable to create new users.
After filling in the needed data, I click on the add user button and the
table with all users is shown but the new one is missing.
Any solutions?
Kind regards
Chris
---------------------------------------------------------------------
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