Re: Moving jetspeed to mysql

Jeremy Kuhnash Thu, 13 May 2004 18:01:31 -0700

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

-- MySQL dump 8.22
--
-- Host: localhost    Database: senetrix_jetspeed
---------------------------------------------------------
-- Server version       3.23.52-Max


--
-- Table structure for table 'COFFEES'
--

CREATE TABLE COFFEES (
  COFFEE_ID int(11) NOT NULL auto_increment,
  COFFEE_NAME varchar(50) default NULL,
  SUPPLIER_ID int(11) default NULL,
  PRICE float default NULL,
  SALES int(11) default NULL,
  TOTAL int(11) default NULL,
  PRIMARY KEY  (COFFEE_ID)
) TYPE=MyISAM;

--
-- Dumping data for table 'COFFEES'
--


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);

--
-- Table structure for table 'JETSPEED_GROUP_PROFILE'
--

CREATE TABLE JETSPEED_GROUP_PROFILE (
  PSML_ID int(11) NOT NULL auto_increment,
  GROUP_NAME varchar(99) NOT NULL default '',
  MEDIA_TYPE varchar(99) default NULL,
  LANGUAGE char(2) default NULL,
  COUNTRY char(2) default NULL,
  PAGE varchar(99) default NULL,
  PROFILE blob,
  PRIMARY KEY  (PSML_ID),
  UNIQUE KEY GROUP_NAME (GROUP_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
) TYPE=MyISAM;

--
-- Dumping data for table 'JETSPEED_GROUP_PROFILE'
--



--
-- Table structure for table 'JETSPEED_ROLE_PROFILE'
--

CREATE TABLE JETSPEED_ROLE_PROFILE (
  PSML_ID int(11) NOT NULL auto_increment,
  ROLE_NAME varchar(99) NOT NULL default '',
  MEDIA_TYPE varchar(99) default NULL,
  LANGUAGE char(2) default NULL,
  COUNTRY char(2) default NULL,
  PAGE varchar(99) default NULL,
  PROFILE blob,
  PRIMARY KEY  (PSML_ID),
  UNIQUE KEY ROLE_NAME (ROLE_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
) TYPE=MyISAM;

--
-- Dumping data for table 'JETSPEED_ROLE_PROFILE'
--



--
-- Table structure for table 'JETSPEED_USER_PROFILE'
--

CREATE TABLE JETSPEED_USER_PROFILE (
  PSML_ID int(11) NOT NULL auto_increment,
  USER_NAME varchar(32) NOT NULL default '',
  MEDIA_TYPE varchar(99) default NULL,
  LANGUAGE char(2) default NULL,
  COUNTRY char(2) default NULL,
  PAGE varchar(99) default NULL,
  PROFILE blob,
  PRIMARY KEY  (PSML_ID),
  UNIQUE KEY USER_NAME (USER_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
) TYPE=MyISAM;

--
-- Dumping data for table 'JETSPEED_USER_PROFILE'
--



--
-- Table structure for table 'TURBINE_GROUP'
--

CREATE TABLE TURBINE_GROUP (
  GROUP_ID int(11) NOT NULL auto_increment,
  GROUP_NAME varchar(99) NOT NULL default '',
  OBJECTDATA blob,
  PRIMARY KEY  (GROUP_ID),
  UNIQUE KEY GROUP_NAME (GROUP_NAME)
) TYPE=MyISAM;

--
-- Dumping data for table 'TURBINE_GROUP'
--


INSERT INTO TURBINE_GROUP VALUES (1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES (2,'apache',NULL);

--
-- Table structure for table 'TURBINE_PERMISSION'
--

CREATE TABLE TURBINE_PERMISSION (
  PERMISSION_ID int(11) NOT NULL auto_increment,
  PERMISSION_NAME varchar(99) NOT NULL default '',
  OBJECTDATA blob,
  PRIMARY KEY  (PERMISSION_ID),
  UNIQUE KEY PERMISSION_NAME (PERMISSION_NAME)
) TYPE=MyISAM;

--
-- Dumping data for table 'TURBINE_PERMISSION'
--


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);

--
-- Table structure for table 'TURBINE_ROLE'
--

CREATE TABLE TURBINE_ROLE (
  ROLE_ID int(11) NOT NULL auto_increment,
  ROLE_NAME varchar(99) NOT NULL default '',
  OBJECTDATA blob,
  PRIMARY KEY  (ROLE_ID),
  UNIQUE KEY ROLE_NAME (ROLE_NAME)
) TYPE=MyISAM;

--
-- Dumping data for table 'TURBINE_ROLE'
--


INSERT INTO TURBINE_ROLE VALUES (1,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES (2,'admin',NULL);
INSERT INTO TURBINE_ROLE VALUES (3,'guest',NULL);

--
-- Table structure for table 'TURBINE_ROLE_PERMISSION'
--

CREATE TABLE TURBINE_ROLE_PERMISSION (
  ROLE_ID int(11) NOT NULL default '0',
  PERMISSION_ID int(11) NOT NULL default '0',
  PRIMARY KEY  (ROLE_ID,PERMISSION_ID)
) TYPE=MyISAM;

--
-- Dumping data for table 'TURBINE_ROLE_PERMISSION'
--


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);

--
-- Table structure for table 'TURBINE_USER'
--

CREATE TABLE TURBINE_USER (
  USER_ID int(11) NOT NULL auto_increment,
  LOGIN_NAME varchar(32) NOT NULL default '',
  PASSWORD_VALUE varchar(32) NOT NULL default '',
  FIRST_NAME varchar(99) NOT NULL default '',
  LAST_NAME varchar(99) NOT NULL default '',
  EMAIL varchar(99) default NULL,
  CONFIRM_VALUE varchar(99) default NULL,
  MODIFIED timestamp(14) NOT NULL,
  CREATED timestamp(14) NOT NULL,
  LAST_LOGIN timestamp(14) NOT NULL,
  DISABLED char(1) default NULL,
  OBJECTDATA blob,
  PASSWORD_CHANGED timestamp(14) NOT NULL,
  PRIMARY KEY  (USER_ID),
  UNIQUE KEY LOGIN_NAME (LOGIN_NAME)
) TYPE=MyISAM;

--
-- Dumping data for table 'TURBINE_USER'
--


INSERT INTO TURBINE_USER VALUES (1,'admin','jetspeed','Jetspeed','Admin','[EMAIL 
PROTECTED]','CONFIRMED',20031231005902,20031231005902,20021015184541,'F',NULL,20031231005902);
INSERT INTO TURBINE_USER VALUES (2,'turbine','turbine','Tommy','Turbine','[EMAIL 
PROTECTED]','CONFIRMED',20031231005902,20031231005902,20021015184541,'F',NULL,20031231005902);
INSERT INTO TURBINE_USER VALUES (3,'anon','anon','Anonymous','User','[EMAIL 
PROTECTED]','CONFIRMED',20031231005902,20031231005902,20021015184541,'F',NULL,20031231005902);

--
-- Table structure for table 'TURBINE_USER_GROUP_ROLE'
--

CREATE TABLE TURBINE_USER_GROUP_ROLE (
  USER_ID int(11) NOT NULL default '0',
  GROUP_ID int(11) NOT NULL default '0',
  ROLE_ID int(11) NOT NULL default '0',
  PRIMARY KEY  (USER_ID,GROUP_ID,ROLE_ID)
) TYPE=MyISAM;

--
-- Dumping data for table 'TURBINE_USER_GROUP_ROLE'
--


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 (2,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES (3,1,3);

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Moving jetspeed to mysql

Reply via email to