Hello Stijn, Thanks for your mail and files.I copied the files you sent and i tried again but something wrong in the syntax seems to be in the table email_inbox..i am getting this error.I didn't modified anything just copy & pasted as it is what you sent. ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '- - CREATE TABLE EMAIL_INBOX ( EMAIL_INBOX_ID integer(11 Can you check once please. Thank you. Maruhti:
Stijn de Witt <[EMAIL PROTECTED]> wrote: Hi Maruthi, The best thing you can do probably is to get the latest version of Jetspeed from the CVS, jetspeed-1.6-dev. That particular problem was fixed in 1.6. If you don't want to use a development version, or if you don't have access to CVS, here are the turbine-mysql.sql and populate-mysql.sql that are included in 1.6. You can probably just use those. -Stijn P.S. I'm just pasting them in the message, so they'll also be available in the list archives: turbine-mysql.sql ----- ---------------------------------------------------------------------------- - -- Copyright 2004 The Apache Software Foundation -- -- Licensed under the Apache License, Version 2.0 (the "License"); -- you may not use this file except in compliance with the License. -- You may obtain a copy of the License at -- -- http://www.apache.org/licenses/LICENSE-2.0 -- -- Unless required by applicable law or agreed to in writing, software -- distributed under the License is distributed on an "AS IS" BASIS, -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -- See the License for the specific language governing permissions and -- limitations under the License. ---------------------------------------------------------------------------- - # ----------------------------------------------------------------------- # TURBINE_USER # ----------------------------------------------------------------------- drop table if exists TURBINE_USER; CREATE TABLE TURBINE_USER ( USER_ID INTEGER NOT NULL AUTO_INCREMENT, LOGIN_NAME VARCHAR (32) NOT NULL, PASSWORD_VALUE VARCHAR (32) NOT NULL, FIRST_NAME VARCHAR (99) NOT NULL, LAST_NAME VARCHAR (99) NOT NULL, EMAIL VARCHAR (99), CONFIRM_VALUE VARCHAR (99), MODIFIED TIMESTAMP, CREATED TIMESTAMP, LAST_LOGIN TIMESTAMP, DISABLED CHAR (1), OBJECTDATA BLOB, PASSWORD_CHANGED TIMESTAMP, PRIMARY KEY(USER_ID), UNIQUE (LOGIN_NAME) ); # ----------------------------------------------------------------------- # TURBINE_ROLE # ----------------------------------------------------------------------- drop table if exists TURBINE_ROLE; CREATE TABLE TURBINE_ROLE ( ROLE_ID INTEGER NOT NULL AUTO_INCREMENT, ROLE_NAME VARCHAR (99) NOT NULL, OBJECTDATA BLOB, PRIMARY KEY(ROLE_ID), UNIQUE (ROLE_NAME) ); # ----------------------------------------------------------------------- # TURBINE_GROUP # ----------------------------------------------------------------------- drop table if exists TURBINE_GROUP; CREATE TABLE TURBINE_GROUP ( GROUP_ID INTEGER NOT NULL AUTO_INCREMENT, GROUP_NAME VARCHAR (99) NOT NULL, OBJECTDATA BLOB, PRIMARY KEY(GROUP_ID), UNIQUE (GROUP_NAME) ); # ----------------------------------------------------------------------- # TURBINE_PERMISSION # ----------------------------------------------------------------------- drop table if exists TURBINE_PERMISSION; CREATE TABLE TURBINE_PERMISSION ( PERMISSION_ID INTEGER NOT NULL AUTO_INCREMENT, PERMISSION_NAME VARCHAR (99) NOT NULL, OBJECTDATA BLOB, PRIMARY KEY(PERMISSION_ID), UNIQUE (PERMISSION_NAME) ); # ----------------------------------------------------------------------- # TURBINE_ROLE_PERMISSION # ----------------------------------------------------------------------- drop table if exists TURBINE_ROLE_PERMISSION; CREATE TABLE TURBINE_ROLE_PERMISSION ( ROLE_ID INTEGER NOT NULL, PERMISSION_ID INTEGER NOT NULL, PRIMARY KEY(ROLE_ID,PERMISSION_ID), FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID), FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION (PERMISSION_ID) ); # ----------------------------------------------------------------------- # TURBINE_USER_GROUP_ROLE # ----------------------------------------------------------------------- drop table if exists TURBINE_USER_GROUP_ROLE; CREATE TABLE TURBINE_USER_GROUP_ROLE ( USER_ID INTEGER NOT NULL, GROUP_ID INTEGER NOT NULL, ROLE_ID INTEGER NOT NULL, PRIMARY KEY(USER_ID,GROUP_ID,ROLE_ID), FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID), FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID), FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID) ); # ----------------------------------------------------------------------- # JETSPEED_USER_PROFILE # ----------------------------------------------------------------------- drop table if exists JETSPEED_USER_PROFILE; CREATE TABLE JETSPEED_USER_PROFILE ( PSML_ID INTEGER NOT NULL AUTO_INCREMENT, USER_NAME VARCHAR (32) NOT NULL, MEDIA_TYPE VARCHAR (99), LANGUAGE VARCHAR (2), COUNTRY VARCHAR (2), PAGE VARCHAR (99), PROFILE BLOB, PRIMARY KEY(PSML_ID), UNIQUE (USER_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE) ); # ----------------------------------------------------------------------- # JETSPEED_GROUP_PROFILE # ----------------------------------------------------------------------- drop table if exists JETSPEED_GROUP_PROFILE; CREATE TABLE JETSPEED_GROUP_PROFILE ( PSML_ID INTEGER NOT NULL AUTO_INCREMENT, GROUP_NAME VARCHAR (99) NOT NULL, MEDIA_TYPE VARCHAR (99), LANGUAGE VARCHAR (2), COUNTRY VARCHAR (2), PAGE VARCHAR (99), PROFILE BLOB, PRIMARY KEY(PSML_ID), UNIQUE (GROUP_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE) ); # ----------------------------------------------------------------------- # JETSPEED_ROLE_PROFILE # ----------------------------------------------------------------------- drop table if exists JETSPEED_ROLE_PROFILE; CREATE TABLE JETSPEED_ROLE_PROFILE ( PSML_ID INTEGER NOT NULL AUTO_INCREMENT, ROLE_NAME VARCHAR (99) NOT NULL, MEDIA_TYPE VARCHAR (99), LANGUAGE VARCHAR (2), COUNTRY VARCHAR (2), PAGE VARCHAR (99), PROFILE BLOB, PRIMARY KEY(PSML_ID), UNIQUE (ROLE_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE) ); # ----------------------------------------------------------------------- # COFFEES # ----------------------------------------------------------------------- drop table if exists COFFEES; CREATE TABLE COFFEES ( COFFEE_ID INTEGER NOT NULL AUTO_INCREMENT, COFFEE_NAME VARCHAR (50), SUPPLIER_ID INTEGER, PRICE FLOAT, SALES INTEGER, TOTAL INTEGER, PRIMARY KEY(COFFEE_ID) ); ---------------------------------------------------------------------------- - -- EMAIL ---------------------------------------------------------------------------- - CREATE TABLE EMAIL_INBOX ( EMAIL_INBOX_ID integer(11) NOT NULL auto_increment, MESSAGE_ID varchar(255) default NULL, FILENAME varchar(255) default NULL, ATTACHMENT longblob, READFLAG int(11) default NULL, PRIMARY KEY (EMAIL_INBOX_ID) ); ----- populate-mysql.sql ----- INSERT INTO TURBINE_PERMISSION VALUES(1,'view',NULL); INSERT INTO TURBINE_PERMISSION VALUES(2,'customize',NULL); INSERT INTO TURBINE_PERMISSION VALUES(3,'maximize',NULL); INSERT INTO TURBINE_PERMISSION VALUES(4,'minimize',NULL); INSERT INTO TURBINE_PERMISSION VALUES(5,'personalize',NULL); INSERT INTO TURBINE_PERMISSION VALUES(6,'info',NULL); INSERT INTO TURBINE_PERMISSION VALUES(7,'close',NULL); INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL); INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL); INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL); INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL); INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL); INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL); INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin','[EMAIL PROTECTED]', 'CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL); INSERT INTO TURBINE_USER VALUES(2,'turbine','turbine','Tommy','Turbine','[EMAIL PROTECTED]', 'CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL); INSERT INTO TURBINE_USER VALUES(3,'anon','anon','Anonymous','User','[EMAIL PROTECTED]','CONFI RMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,4); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,5); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,6); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,1); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,2); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,3); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,4); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6); INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1); INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1); INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2); INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(3,1,3); INSERT INTO COFFEES VALUES(1,'ColombianGrade',5,7.99,1,2); INSERT INTO COFFEES VALUES(2,'KonaGrade',6,7.99,1,2); INSERT INTO COFFEES VALUES(3,'FrenchRoastGrade',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 COFFEES VALUES(8,'OotyGrade',1,7.99,1,2); INSERT INTO COFFEES VALUES(9,'KenyanGrade',2,7.99,1,2); INSERT INTO COFFEES VALUES(10,'JoeGrade',3,7.99,1,2); INSERT INTO COFFEES VALUES(11,'CantThinkOfAnymoreGrade',4,7.99,1,2); ----- ----- Original Message ----- From: "Maruthi" To: "Jetspeed Users List" Sent: Friday, June 18, 2004 12:16 PM Subject: Hello Stijn..again problems with .sql scripts ( Re: JSP Portlet ->Mysql ->Connection Problem) > Hello Stijn, > > First of all Thanks for your reply and suggestions.As per your suggestion i ran .sql scripts.I got some problems with IDENTITY.I think you too got the same problem once upon a time as i saw your question regarding this one in the mailing list.And as per Michael Muller'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 must be defined as a key > > Errors for Populate-mysql.sql :: > > ERROR 1136: Column count doesn't match value count at row 1 > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > > I am attaching the list ::: > ========================================================================== > Before replacing IDENTITY by AUTO_INCREMENT and BINARY by BLOB in turbine-mysql.sql > ========================================================================== > > ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTITY, > GROUP_NAME VARCHAR (99) NOT NULL, > OBJECTDAT > Query OK, 0 rows affected (0.00 sec) > Query OK, 0 rows affected (0.01 sec) > Records: 0 Duplicates: 0 Warnings: 0 > ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTITY, > LOGIN_NAME VARCHAR (32) NOT NULL, > PASSWORD_ > Query OK, 0 rows affected (0.01 sec) > Query OK, 0 rows affected (0.02 sec) > Records: 0 Duplicates: 0 Warnings: 0 > Query OK, 0 rows affected (0.01 sec) > ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTITY, > COFFEE_NAME VARCHAR (50), > SUPPLIER_ID integ > Query OK, 0 rows affected (0.01 sec) > mysql> \. c:\jetspeed-1.5-src\src\sql\external\populate-mysql.sql > ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_group' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_group' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist > ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.01 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ========================================================================== > After replacing IDENTITY by AUTO_INCREMENT and BINARY by BLOB in turbine-mysql.sql > ========================================================================== > > mysql> \. c:\jetspeed-1.5-src\src\sql\external\turbine-mysql.sql > > Query OK, 0 rows affected (0.00 sec) > Query OK, 0 rows affected (0.00 sec) > Query OK, 0 rows affected (0.00 sec) > Query OK, 0 rows affected (0.00 sec) > Query OK, 0 rows affected (0.01 sec) > > Records: 0 Duplicates: 0 Warnings: 0 > > Query OK, 0 rows affected (0.00 sec) > Query OK, 0 rows affected (0.00 sec) > Query OK, 0 rows affected (0.03 sec) > Records: 0 Duplicates: 0 Warnings: 0 > Query OK, 0 rows affected (0.05 sec) > > ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key > > Query OK, 0 rows affected (0.00 sec) > > > mysql> \. c:\jetspeed-1.5-src\src\sql\external\populate-mysql.sql > > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > > ERROR 1136: Column count doesn't match value count at row 1 > ERROR 1136: Column count doesn't match value count at row 1 > ERROR 1136: Column count doesn't match value count at row 1 > > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.01 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.01 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > Query OK, 1 row affected (0.00 sec) > > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > ERROR 1146: Table 'jetspeed.coffees' doesn't exist > > Please suggest me what to do in this regard. > Thanks for your help, > Maruthi. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Stijn de Witt wrote: > Hello Maruthi, > > It seems that the turbine tables do not exist, as the logging shows: "Table > 'thesiswork.turbine_user' doesn't exist". Have you ran the .sql scripts > needed to create and populate the turbine tables? > Check out src/sql/external/turbine-mysql.sql and > src/sql/external/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 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 > "Thesiswork". > _____________________________________________ > > Error:: > _____________________________________________ > > 17.06.2004 18:26:44 org.apache.torque.util.BasePeer initTableSchema > SCHWERWIEGEND: java.sql.SQLException: [MySQL][ODBC 3.51 > Driver][mysqld-4.0.18-max-nt]Table 'thesiswork.turbine_user' doesn't exist > 17.06.2004 18:26:44 > org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer initClass > SCHWERWIEGEND: A FATAL ERROR has occurred which should not have happened > under any circumstance. Please notify the Torque developers > che.org> and give as many details as possible (including the error stack > trace). > java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): > [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt]Table > 'thesiswork.turbine_user' doesn't exist > _______________________________________________________________________ > > I am attaching my source code,registry file,Property files ....i tried all > the options that i know to solve the problem ...but i couldn't.Any help in > this regard will be greatly appreciated. > > Thanks a lot for your time and patience, > Maruthi. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] === message truncated === --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages!
