RE: PSML Import Problem with MySQL

2005-04-05 Thread Roel van Dijk
an: jetspeed-user@jakarta.apache.org > CC: David Sean Taylor > Onderwerp: Re: PSML Import Problem with MySQL > > > Hello, > > is there nobody who can help me with that? How do you guys do it? First > you create a schema for the new tables, then you run 'maven to

Re: PSML Import Problem with MySQL

2005-04-05 Thread Sven Richter
new tables. But how do I do that? Please help me if you can, Thanks a lot, Sven. --- Weitergeleitete Nachricht --- Von: "Sven Richter" <[EMAIL PROTECTED]> An: "Jetspeed Users List" Betreff: Re: AW: PSML Import Problem with MySQL Datum: Sun, 03 Apr 2005 15:56:

Re: AW: PSML Import Problem with MySQL

2005-04-03 Thread Sven Richter
OM-Classes? Thanks a lot, Sven. Am Wed, 30 Mar 2005 09:30:05 -0800 schrieb David Sean Taylor <[EMAIL PROTECTED]>: OK, Im going to try real quick to summarize MySQL and PSML importing. I sent these instructions to Sven, and they really need to go out to everyone on the list: I am speakin

AW: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4)

2005-03-31 Thread Danny Gehl
I don't think so. > -Ursprüngliche Nachricht- > Von: Roel van Dijk [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 31. März 2005 15:26 > An: Jetspeed Users List > Betreff: RE: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4) > > > > I had this same bug

RE: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4)

2005-03-31 Thread Roel van Dijk
I had this same bug in 1.6-dev recently. Has it been fixed in CVS? Roel > -Oorspronkelijk bericht- > Van: Stefano Bianchi [mailto:[EMAIL PROTECTED] > Verzonden: Thursday, March 31, 2005 11:27 AM > Aan: Jetspeed Users List > Onderwerp: Re: Problem with MySQL 4.1 and Jetp

Re: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4)

2005-03-31 Thread Stefano Bianchi
g for J1.5? Bye Stefano - Original Message - From: "Danny Gehl" <[EMAIL PROTECTED]> To: "'Jetspeed Users List'" Sent: Thursday, March 31, 2005 10:56 AM Subject: AW: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4) > The Problem is, that some 

AW: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4)

2005-03-31 Thread Danny Gehl
> An: Jetspeed Users List > Betreff: Re: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4) > > > Dear Danny, > we had the same problem. > We tried to generate again all the scripts but they do not work. > Could it be a problem with MySQL version (we use 4.1.9)? > Until th

Re: AW: PSML Import Problem with MySQL

2005-03-30 Thread David Sean Taylor
OK, Im going to try real quick to summarize MySQL and PSML importing. I sent these instructions to Sven, and they really need to go out to everyone on the list: I am speaking here about version 1.6(-dev) You need to generate the DDL for the PSML. As described on the online docs, you need to: 1

Re: AW: PSML Import Problem with MySQL

2005-03-30 Thread David Sean Taylor
Daniel Brose wrote: Hi Dmitriy! Attempts to import PSML into DB keeps causing errors, even though I modified properties files (attached) to use MySQL settings instead of HSQL. I tried both MySQL drivers and ensured that they are in the CLASSPATH. Still I get the problem that you can see in

Re: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4)

2005-03-30 Thread Stefano Bianchi
Dear Danny, we had the same problem. We tried to generate again all the scripts but they do not work. Could it be a problem with MySQL version (we use 4.1.9)? Until this is not solved we can not let users to create a new account. I already posted this but I did not find any solution yet. It would

AW: PSML Import Problem with MySQL

2005-03-30 Thread Daniel Brose
Hi Dmitriy! > Attempts to import PSML into DB keeps causing errors, even though I > modified properties files (attached) to use MySQL settings instead of > HSQL. I tried both MySQL drivers and ensured that they are in the > CLASSPATH. Still I get the problem that you can see in att

Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4)

2005-03-29 Thread Danny Gehl
Hello, we have encountered a serious problem while updating our MySQL DB server to version 4.1. When a new User is created, the fields CREATED and PASSWORD_CHANGED in the TURBINE_USER table are set to '-00-00 00:00:00'. When Jetspeed attempts to read this user later, the following e

RE: PSML Import Problem with MySQL

2005-03-28 Thread Dmitriy Kruglyak
#targetPackage = org.apache.jetspeed.om.torque #torque.retrievableInterface = org.apache.fulcrum.intake.Retrievable #torque.database.url = jdbc:hsqldb:hsql://localhost #torque.database.driver = org.hsqldb.jdbcDriver #torque.database.user = sa #torque.database.password = database = mysql targetPackage

PSML Import Problem with MySQL

2005-03-28 Thread Dmitriy Kruglyak
Title: Message Hello,   I am using Jetspeed 1.5 FINAL, MySQL 4.1.9 andTomcat 5.0.16.   Attempts to import PSML into DB keeps causing errors, even though I modified properties files (attached) to use MySQL settings instead of HSQL. I tried both MySQL drivers and ensured that they are in

Re: using MySQL with J2 - setup problem

2005-02-28 Thread Scott T. Weaver
eds to be jdbc:mysql://127.0.0.1:3306/j2 or jdbc:mysql://localhost/j2, (mysql can be picky about IP usage and I am not sure about the port you specified). Randy Thanks, Randy :) I modified jetspeed.xml file using the one from a working HSQL J2M2 installation as an example and copied it into the /con

Re: using MySQL with J2 - setup problem

2005-02-27 Thread Marina
f your j2 DB is not setup, nothing will work > anyway, so we are back to > the failing maven build... you did use "maven > quickStart", no? > > Also, your DB URL probably needs to be > > jdbc:mysql://127.0.0.1:3306/j2 > > or > > jdbc:mysql://localhost

Re: using MySQL with J2 - setup problem

2005-02-27 Thread watler
Marina: If your j2 DB is not setup, nothing will work anyway, so we are back to the failing maven build... you did use "maven quickStart", no? Also, your DB URL probably needs to be jdbc:mysql://127.0.0.1:3306/j2 or jdbc:mysql://localhost/j2, (mysql can be picky about IP usage an

Re: using MySQL with J2 - setup problem

2005-02-27 Thread Marina
Thanks, Randy :) I modified jetspeed.xml file using the one from a working HSQL J2M2 installation as an example and copied it into the /conf/Catalina/localhost dir. I also copied a security.xml file from the HSQLDB J2M2 installation and adjusted the docBase value. Unfortunately, when I started Tom

Re: using MySQL with J2 - setup problem

2005-02-27 Thread watler
Marina, > 3. jetspeed.xml > there was no jetspeed.xml in the > =/conf/Catalina/localhost dir > The only jetspeed.xml files in the J2-project-home > directory that I found were: > maven-plugin/target/classes/plugin-resources/jetspeed.xml > portal/src/resources/jetspeed.xml > Should I manually edit

Re: using MySQL with J2 - setup problem

2005-02-27 Thread Marina
Randy, I double checked my config files and verified the following: Verified: 1. JVM version used by maven - added 'java -version' command to the 'show.maven.props' goal: C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL>maven show.maven.props __ __ | \/ |__ _Apach

Re: using MySQL with J2 - setup problem

2005-02-26 Thread watler
Marina, I know you probably have most of this down cold, but please verify: - you have a copy of mysql-connector-java-3.0.16-ga-bin.jar in /shared/lib. - that the com.mysql.jdbc.Driver class exists in mysql-connector-java-3.0.16-ga-bin.jar. - if you are manually copying the jetspeed.war into

Re: using MySQL with J2 - setup problem

2005-02-26 Thread Marina
org.apache.jetspeed.test.database.driver = com.mysql.jdbc.Driver org.apache.jetspeed.test.database.user = admin org.apache.jetspeed.test.database.password = admin org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar org.apache.jetspeed.test.database.default.name

Re: using MySQL with J2 - setup problem

2005-02-25 Thread watler
Marina, These settings have always worked for me, (note that I do not set the ojb.platform property): org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16.jar org.apache.jetspeed.test.database.default.name=mysql

Re: using MySQL with J2 - setup problem

2005-02-25 Thread Marina
Thank you, Hema! Yes, that was it - the default name had to be set to 'mysql'. Once I did that, the build script finished all DB setup work fine but it failed at a later point: java:compile: [echo] Compiling to C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api/targ

Re: using MySQL with J2 - setup problem

2005-02-24 Thread Hema Menon
Marina, What I meant to say is that, I believe the default name should be the type of database name, so in your build script it should be mysql instead of j2 and j2test. If you look at the sample build properties, it contains hsql for both test and production default database name

Re: using MySQL with J2 - setup problem

2005-02-24 Thread Hema Menon
ROTECTED]> wrote: > Hi, > > I finally got around to switch from HSQLDB to MySQL > and ran into a build problem. > I setup MySQL DB schema and users per J2 instructions > (created 'j2test' and 'j2' schemas and the 'jetspeed2' > user that

using MySQL with J2 - setup problem

2005-02-24 Thread Marina
Hi, I finally got around to switch from HSQLDB to MySQL and ran into a build problem. I setup MySQL DB schema and users per J2 instructions (created 'j2test' and 'j2' schemas and the 'jetspeed2' user that has all writes for those schemas). I have also modified J2&#

MySQL scripts (request)

2005-02-17 Thread Stefano Bianchi
Dear ALL, could any good guy provide me with a working version of sql scripts to generate the DB for MySQL? It seems mine can't work properly (e.g. they have an IDENTITY property that is not recognized by MySQL, and they lack a PASSWORD_CHANGED column...). I'm still messi

Re: [J1] Jetspeed 1.6 MySQL PSML problem

2005-02-16 Thread Daniel Brose
.path=/etc/drivers/jdbc/mysql- > connector-java-3.0.8-stable-bin.jar That's it! I just imported all the stuff and it works fine! Thanks a lot, you made my day!! Regards Daniel - To unsubscribe, e-mail: [EMAIL PROTECTED]

Re: AW: [J1] Jetspeed 1.6 MySQL PSML problem

2005-02-16 Thread David Sean Taylor
) # services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanage r.db.DatabasePsmlManagerService again, it looks to me like you have both uncommented just select one And yes, I changed my Torque.properties and rebuild. I'm already using MySQL for users. Here are my settings for

AW: [J1] Jetspeed 1.6 MySQL PSML problem

2005-02-15 Thread Daniel Brose
smlmanage r.db.DatabasePsmlManagerService And yes, I changed my Torque.properties and rebuild. I'm already using MySQL for users. Here are my settings for my db in my Torque.properties: torque.database.default=default torque.database.default.adapter=mysql torque.dsfactory.default.connection.driver = org.gjt.m

Re: [J1] Jetspeed 1.6 MySQL PSML problem

2005-02-15 Thread David Sean Taylor
Daniel Brose wrote: Hi all, I already use MySQL (version 3) for security like users and stuff, now I want to use it for the PSML registry. I followed the steps in http://portals.apache.org/jetspeed-1/psml_db.html. It worked for me up to the "maven import". Maven tells me that the

[J1] Jetspeed 1.6 MySQL PSML problem

2005-02-15 Thread Daniel Brose
Hi all, I already use MySQL (version 3) for security like users and stuff, now I want to use it for the PSML registry. I followed the steps in http://portals.apache.org/jetspeed-1/psml_db.html. It worked for me up to the "maven import". Maven tells me that the build was successful

Re: Migrating to MySQL without rebuild

2005-01-30 Thread Stefano Bianchi
Thank you David. I'm not sure what you are talking about, *** but is there anybody out there with something ready for MySQL? *** Anyway, I'll start playing around with Maven... Stefano - Original Message - From: "David Sean Taylor" <[EMAIL PROTECTED]> To: &

Re: Migrating to MySQL without rebuild

2005-01-29 Thread David Sean Taylor
Stefano Bianchi wrote: Dear ALL, is there a way to migrate to MySql for J1.5 without rebuilding with Maven? Just .properties configurations and MySQL scripts? Never used Maven before... Would be nice. Thats my biggest complaint about the 1.x codebase: You have to rebuild to switch databases I have

Migrating to MySQL without rebuild

2005-01-28 Thread Stefano Bianchi
Dear ALL, is there a way to migrate to MySql for J1.5 without rebuilding with Maven? Just .properties configurations and MySQL scripts? Never used Maven before... Thank you Stefano Ing. Stefano Bianchi Softeco Sismat S.p.A. Via De Marini, 1 - WTC Tower 16149 Genoa (ITALY) e-mail: [EMAIL

Re: J2M1 binary and mysql

2004-12-12 Thread Randy Watler
Nope: http://www.apache.org/dist/portals/jetspeed-2/JETSPEED-2.0-M1-README.txt Note that older versions of MySQL, as in 3.X, may not work Certainly, 4.1 has been tested and has been verified on both windows and lunix platforms! Randy News Hunter wrote: how can i use mysql with j2m1? must i

J2M1 binary and mysql

2004-12-12 Thread News Hunter
how can i use mysql with j2m1? must i build it? --- -News Hunter- --- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

MySQL PSML Problem

2004-11-21 Thread orchard
Hi I'm using MySQL as DB for the PSML files. Since I changed I cannot access the group PSML as admin over the PSML Browser. I simply get told that access has been denied. Is this because of the DB? Any ideas? Thanks

building jetspeed-2 with mysql

2004-11-09 Thread nafise hassani
hi I want to deploy jetspeed-2 into tomcat 5.0.28 and use "mysql" as databasa instead of "hsql" i do all the instruction from "getting started" page of jetspeed-2 home but I don't know where should I put my "mysql" driver So by chance I put it in %ma

problems with mysql

2004-10-27 Thread Michael McElligott
Hi everyone, just having a problem with using mysql as the database backing jetspeed. Specifically redeployment doesn't work, and I often have to issue a db.recreate via maven. The only message that seems as though it might be related is, during startup: [DEFAULT] WARN: [PlatformFa

Jetspeed 1.5 with MySQL 4.1.6-gamma problem

2004-10-16 Thread Yayati Kasralikar
Hi all, I have successfully used MySQL 4.1.1-alpha and MySQL 5.0.0a-alpha with jetspeed 1.5. When I try to use MySQL 4.1.6-gamma with jetspeed 1.5 I get following exception when I try to login. The first page (anon user) is showing up correctly. java.sql.SQLException: There were 7 rows updated

MySQL and Tutorials

2004-09-23 Thread orchard
Hi I changed everything so I can run MySQL. How do I now generate the SQL files? Also, everytime I want to build the tutorials with maven, I get the same annoying error: maven-torque-plugin-3.2/plugin.jelly Any Ideas? Cheers Greg

getting Jetspeed 1.5 working on mysql / fc2 / jdk1.4.2 /tc 5.0.28

2004-09-07 Thread Pat O'Neil
Hey Y'all, To get jetspeed 1.5 to work out-of-the-box on Fedora Core 2 & jdk1.4.2 & tomcat-5.0.28 with mysql I had to jump through the following hoops, so here's hoping this will help someone else: 1) edit src/sql/external/turbine-mysql.sql thusly: - replace IDENTITY w

Re: MySQL SQLException

2004-09-03 Thread Eric L. Wittle
Raghdan Rabah wrote: Hello, I have jetspeed on WIN2000. I did install mysql-4.1.3b and MySQL ODBC 3.51. Then I have built jetspeed database using: - turbine-mysql.sql - dbpsml-schema.sql - populate-mysql.sql Also, in Torque.properties, i added: ### #R

MySQL SQLException

2004-09-01 Thread Raghdan Rabah
Hello, I have jetspeed on WIN2000. I did install mysql-4.1.3b and MySQL ODBC 3.51. Then I have built jetspeed database using: - turbine-mysql.sql - dbpsml-schema.sql - populate-mysql.sql Also, in Torque.properties, i added: ### #R

Re: jetspeed 1.5 & mysql configuration problem

2004-08-27 Thread Roger Ruttimann
The exception results from the fact that the user info can't be extracted from the database. Make sure that the database exists and it is correctly populated. Make sure that the database name, user and pwd in the Torque.properties match with the MySQL settings. Check as well that the dat

Re: jetspeed 1.5 & mysql configuration problem

2004-08-27 Thread chitselb
here I came up with the turbine database. I also read on an earlier thread that the problem might be that the tomcat user isn't authorized to access mySQL on the host. This was a stock mysql install where root has full mySQL privileges, and tomcat is running as root (I know, not recommended, bu

Re: jetspeed 1.5 & mysql configuration problem

2004-08-27 Thread David Sean Taylor
[EMAIL PROTECTED] wrote: Dear List, I am trying to configure Jetspeed 1.5 (Tomcat 5; SuSE Linux 9.1 pro) to work with mySQL 4.0.18 and am experiencing a problem. It started with me getting the same NullPointer error when trying to deploy my application, but I wanted to be sure it was Jetspeed-1.5

jetspeed 1.5 & mysql configuration problem

2004-08-26 Thread chitselb
Dear List, I am trying to configure Jetspeed 1.5 (Tomcat 5; SuSE Linux 9.1 pro) to work with mySQL 4.0.18 and am experiencing a problem. It started with me getting the same NullPointer error when trying to deploy my application, but I wanted to be sure it was Jetspeed-1.5 before I posted, so I

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-22 Thread Maruthi
e. When you done some more testing, send the logs, we'll have a look at it. -Stijn - Original Message - From: "Maruthi" To: "Jetspeed Users List" Sent: Monday, June 21, 2004 7:21 PM Subject: Re: Not able to find JSP Portlet ...Problem with mysql database > Dear

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Stijn de Witt
PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Monday, June 21, 2004 7:21 PM Subject: Re: Not able to find JSP Portlet ...Problem with mysql database > Dear Stijn, > > Thanks for your your suggestions.I changed the code accordingly and one tip i do

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Maruthi
; To: "Jetspeed Users List" Sent: Monday, June 21, 2004 5:24 PM Subject: Re: Not able to find JSP Portlet ...Problem with mysql database > Hello StijnThe home page i was telling is after logging as "Admin" only.Here i am pasting my JSP and Action class.

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Stijn de Witt
- Original Message - From: "Maruthi" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Monday, June 21, 2004 5:24 PM Subject: Re: Not able to find JSP Portlet ...Problem with mysql database > Hello StijnThe home page i was

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Maruthi
Hello StijnThe home page i was telling is after logging as "Admin" only.Here i am pasting my JSP and Action class. Thanks for your patience. Maruthi. = JSP:: RegistrationJSPTemplate.jsp = <%@ page

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Stefano Bianchi
e to find JSP Portlet ...Problem with mysql database > Hi Stefano, > > I logged as admin and i i could see the preview of my portlet (with title,security id:owner only,The security for this portlet is currently defined as system default,skin:default,decoration:default,and up/down or right

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Maruthi
portal, but there should be at least a "user view admin all" option. Hope it helps Stefano - Original Message - From: "Maruthi" To: "Jetspeed Users List" Sent: Monday, June 21, 2004 4:19 PM Subject: Re: Not able to find JSP Portlet ...Problem with mysql

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Stijn de Witt
ijn - Original Message - From: "Maruthi" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Monday, June 21, 2004 4:19 PM Subject: Re: Not able to find JSP Portlet ...Problem with mysql database > Hello Mr.Stefano, > > I

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Stefano Bianchi
From: "Maruthi" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Monday, June 21, 2004 4:19 PM Subject: Re: Not able to find JSP Portlet ...Problem with mysql database > Hello Mr.Stefano, > > I logged into Jetspeed as "

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Maruthi
Not able to find JSP Portlet ...Problem with mysql database Hello all, I read somewhere in the mailing list as Torque will not support "com.mysql.jdbc.Driver" ..is it true?.Now i am trying to connect mysql from JSP Portlet by using "org.gjt.mm.mysql.Driver" then i could log-in in

Re: Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Stefano Bianchi
bject: Not able to find JSP Portlet ...Problem with mysql database Hello all, I read somewhere in the mailing list as Torque will not support "com.mysql.jdbc.Driver" ..is it true?.Now i am trying to connect mysql from JSP Portlet by using "org.gjt.mm.mysql.Driver" then i c

Not able to find JSP Portlet ...Problem with mysql database

2004-06-21 Thread Maruthi
Hello all,   I read somewhere in the mailing list as Torque will not support "com.mysql.jdbc.Driver" ..is it true?.Now i am trying to connect mysql from JSP Portlet by using "org.gjt.mm.mysql.Driver" then i could log-in into jetspeed but in the cutomization pane when i pre

Re: hello christoph...Anything wrong in mysql Database configuration?..

2004-06-21 Thread Stefan Rennick Egglestone
uot;,""); In Torque.Properties:: torque.database.default=default torque.database.default.adapter=mysql torque.dsfactory.default.connection.driver = com.mysql.jdbc.Driver torque.dsfactory.default.connection.url =Jdbc:mysql://ravuri/Thesiswork torque.dsfactory.default.connection.user =//? torque.dsfactory.def

RE: ***SPAM*** hello christoph...Anything wrong in mysql Database configuration?..

2004-06-21 Thread Floßmann Christoph
peed Users List Subject: ***SPAM*** hello christoph...Anything wrong in mysql Database configuration?.. Hello chris.. Thanks for your reply.I changed the thngs like this as per your suggestion:: In the JSP action :: Class.forName("com.mysql.jdbc.Driver"); Connection con=Driver

hello christoph...Anything wrong in mysql Database configuration?..

2004-06-21 Thread Maruthi
ue.Properties:: torque.database.default=default torque.database.default.adapter=mysql torque.dsfactory.default.connection.driver = com.mysql.jdbc.Driver torque.dsfactory.default.connection.url =Jdbc:mysql://ravuri/Thesiswork torque.dsfactory.default.connection.user =//? torque.dsfactory.defaul

RE: Anything wrong in mysql Database configuration?..

2004-06-21 Thread Floßmann Christoph
thing you got to to fix. You don't use any user in your Torque.properties. HTH Chris -Original Message- From: Maruthi [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 6:41 PM To: [EMAIL PROTECTED] Subject: ***SPAM*** Anything wrong in mysql Database configuration?.. Hello Every

Re: Error Migrating from Hypersonic-SQL to MySQL database

2004-06-18 Thread John & Emer Jennings
he other script turbine-mysql.sql, which does fix the problem. So I believe there is an issue with the turbine-mysql-4.sql script. However, I noticed that turbine-mysql.sql doesn't fix an issue in the Create date field whereby new accounts are populated with 00. Is this an issue

Anything wrong in mysql Database configuration?..

2004-06-18 Thread Maruthi
Hello Everybody, Can anybody check my whether there is anything wrong in my MYSQL configuration.I am using MYSQL 3.51 Driver to connect JDBC to mySQL .My DSN name is ravuriand my Database Name is "Thesiswork".I populated the SQL scripts in the source. Please see be

Re: Hello Stijn..again problems with .sql scripts ( Re: JSP Portlet ->Mysql ->Connection Problem)

2004-06-18 Thread Stijn de Witt
7;,7,7.99,1,2); INSERT INTO COFFEES VALUES(4,'HazelNutGrade',8,7.99,1,2); INSERT INTO COFFEES VALUES(5,'VanillaGrade',9,7.99,1,2); INSERT INTO COFFEES VALUES(6,'JavaGrade',10,7.99,1,2); INSERT INTO COFFEES VALUES(7,'IndonesianGrade',11,7.99,1,2); INSERT INTO

Re: Error Migrating from Hypersonic-SQL to MySQL database

2004-06-18 Thread Stijn de Witt
No that shouldn't matter (I'm assuming you are running on mysql 4... :p ) Maybe you have made a mistake in your db configuration... Check webapp/WEB-INF/conf/torque.properties. Here are my settings for mysql: torque.database.default=default torque.database.default.adapter=mysql

Hello Stijn..again problems with .sql scripts ( Re: JSP Portlet ->Mysql ->Connection Problem)

2004-06-18 Thread Maruthi
x27;s Suggestion in the list (see .. http://www.mail-archive.com/[EMAIL PROTECTED]/msg12369.html ) i changed IDENTITY to AUTO_INCREMENT and BINARY to BLOB.After that i am getting these errors:: Errors for turbine-mysql :: ERROR 1075: Incorrect table definition; There can only be one auto column and it

Re: Error Migrating from Hypersonic-SQL to MySQL database

2004-06-17 Thread John & Emer Jennings
Thanks for your fast response Stijn, I did populate and the database is all there as per the scripts with 3 users, jetspeed, tommy and anon, and I can query them via a PHP web page using the configured account details. I did however use the turbine-mysql-4.sql script, would that make any

Re: Error Migrating from Hypersonic-SQL to MySQL database

2004-06-17 Thread Stijn de Witt
Check if the turbine tables are created. use the commands use ; show tables; in mysql. If it does not show a table named turbine user, that explains it. If that is the case, you need to execute the scripts src/sql/external/turbine-mysql.sql and src/sql/external/populate-mysql.sql. Also, look

Error Migrating from Hypersonic-SQL to MySQL database

2004-06-17 Thread John & Emer Jennings
Hi, Im getting the following error migrating from Hypersonic-SQL to MySQL database org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException I noted some other users with the same problem but I couldn't see any response or suggestions. Re The Mail Archive

Re: JSP Portlet ->Mysql ->Connection Problem

2004-06-17 Thread Stijn de Witt
ternal/populate-mysql.sql. Also look here: http://portals.apache.org/jetspeed-1/database.html Hope it helps, -Stijn - Original Message - From: Maruthi To: [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 7:09 PM Subject: JSP Portlet ->Mysql ->Connection Problem Hello Everybody, I

JSP Portlet ->Mysql ->Connection Problem

2004-06-17 Thread Maruthi
Hello Everybody,   I want to connect to JSP portlet to mysql database...when i deployed i am getting the following error.I am using mysql database and the driver is mysql Odbc 3.51 driver to connect to mysql from Java..My database name is "Thesi

Re: How to change from hsqldb to mysql?

2004-06-05 Thread David Sean Taylor
On Jun 5, 2004, at 4:13 AM, Stijn de Witt wrote: Looking at the SQL in turbine-mysql.sql, it seems to be for the wrong database type. Maybe a mixup? It looks like this (just the first two tables): patch applied to CVS head, try again and let us know if that works for you -

Re: How to change from hsqldb to mysql?

2004-06-05 Thread David Sean Taylor
x27;t review the patch closely enough Sorry about that, I'll get that fixed In the meantime look at the turbine-mysql-4.sql script - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: How to change from hsqldb to mysql?

2004-06-05 Thread Jeremy K
Stijn - indeed, same problem here. Of course, there appear to be no real solid test matrices online for releases, so it probably isn't you - it is probably just untested. (I know one of the major developers uses only Oracle .. probably leaves MySQL as a lower priority.) I think I attac

Re: How to change from hsqldb to mysql?

2004-06-05 Thread Stijn de Witt
Message - From: "Stijn de Witt" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Saturday, June 05, 2004 12:59 PM Subject: How to change from hsqldb to mysql? > Hi, > > I had previously changed the jetspeed user database from hsq

How to change from hsqldb to mysql?

2004-06-05 Thread Stijn de Witt
Hi, I had previously changed the jetspeed user database from hsqldb to mysql. However on jetspeed 1.5 I get errors running the turbine-mysql.sql script: Anybody know what they are (and how to fix them)? -Stijn - mysql> use codamo; Database changed mysql> source C:/bit/dev/project/be

error on jetspeed mysql configuration

2004-05-27 Thread \(¯`·._ \(¯`·._-=- BOBPULEY -=-_.·`¯\) _.· `¯\)
hallo, i' ve changed the torque.properties file, for use mysql, like official istruction. After tomcat restart, i' ve called jetspeed from browser and i ave encountered this error: org.apache.turbine.util.TurbineException: Error rendering Velocity template: /contro

RE: Moving jetspeed to mysql

2004-05-14 Thread Mark Orciuch
ny Musse [mailto:[EMAIL PROTECTED] > 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

Re: Moving jetspeed to mysql

2004-05-14 Thread Anony Musse
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 sch

RE: Moving jetspeed to mysql

2004-05-14 Thread Daniel SELAM
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=

Re: Moving jetspeed to mysql

2004-05-13 Thread Jeremy Kuhnash
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 le

Moving jetspeed to mysql

2004-05-13 Thread Daniel SELAM
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 DataS

RE: mysql - no new user Entries

2004-05-12 Thread Floßmann Christoph
27;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 >appropri

Re: mysql - no new user Entries

2004-05-12 Thread Stefan Rennick Egglestone
pages to be in your /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 i

Re: mysql - no new user Entries

2004-05-12 Thread Stefan Rennick Egglestone
t 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

Re: mysql - no new user Entries

2004-05-12 Thread Robin Antony
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

mysql - no new user Entries

2004-05-12 Thread Floßmann Christoph
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

Re: mysql db

2004-03-11 Thread scott
tabase, which you > should set to mysql. If you look in the ant build scripts, you can > actually just call the target to generate the SQL scripts, instead of > rebuilding everything. > > Regards, > Brian > > On Saturday 06 March 2004 04:00 pm, scott wrote: > > Not sur

Re: Mysql 4.1 with Jetspeed

2004-03-09 Thread Stefan Kuhn
Am Tuesday 09 March 2004 02:38 schrieb Bryan K. Cantwell: > Any reason MySQL 4.1 won't work with Jetspeed? I just want to know > before I try myself if it is OK... > I'm using mysql 4.1 in production and there are no pro

RE: Mysql 4.1 with Jetspeed

2004-03-09 Thread Jeremy Ford
I haven't had any problems. Jeremy Ford [EMAIL PROTECTED] -Original Message- From: Bryan K. Cantwell [mailto:[EMAIL PROTECTED] Sent: Monday, March 08, 2004 7:39 PM To: 'Jetspeed Users List' Subject: Mysql 4.1 with Jetspeed Any reason MySQL 4.1 won't work with Jets

Mysql 4.1 with Jetspeed

2004-03-08 Thread Bryan K. Cantwell
Any reason MySQL 4.1 won't work with Jetspeed? I just want to know before I try myself if it is OK... - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: mysql db

2004-03-07 Thread Brian Rowe
A rebuild will fix it, as the database scripts are generated via Torque. When building, Torque will look for the property torque.database, which you should set to mysql. If you look in the ant build scripts, you can actually just call the target to generate the SQL scripts, instead of

Re: mysql db

2004-03-06 Thread scott
Not sure what you mean. The scripts for every other database are fine, just the mysql script is empty. I am not sure a recompile will fix the scipt. On Saturday 06 March 2004 12:57 pm, [EMAIL PROTECTED] wrote: > hi, > I think you need to recompile the source code of jetspeed using

Re: mysql db

2004-03-06 Thread robin.antony
hi, I think you need to recompile the source code of jetspeed using ant by changing the database parameters to mysql then it will create the script file which you enter into your database. Cheers, Robin Antony [EMAIL PROTECTED] > I am attempting to setup jetspeed/turbine to use mysql.

mysql db

2004-03-05 Thread scott
I am attempting to setup jetspeed/turbine to use mysql. The turbine-mysql.sql script I have in my source directory is empty and I am unable to find a new one. Does anyone know where I can get the correct script from? Thanks -- Scott A. Macri Software Engineer/Director Macri Solutions, LLC

  1   2   3   4   >