I have a user table all setup in mysql accessed via AuthzTieDBI. I need
to keep the table setup the same, but I'd like to include the role base
type used by turbine. My problem is I need to keep all the table named
as they are because other applications will continue to access this db.
Id like to have both Authz and Flux running side-by-side as I migrate my
site from mod_perl to Turbine/Velocity --
Is there an easy way to do this?
What I've done so far is having both schemes in the same db, and write
custom programs (kludge) to keep them in sync. Is there a better why
by extending TurbineUser? Do the table names have to be "TURBINE_USER",
"TURBINE_GROUPS", etc..... This seems to be my main drawback. Do you
have to keep all the fields in TURBINE_USER?
Here is my user table schema. As I mentioned before, other apps touch
this, so these table names and field names must remain available.
# Host: localhost Database: www_db
#--------------------------------------------------------
# Server version 3.22.32
#
# Table structure for table 'user_info'
#
CREATE TABLE user_info (
id int(11) DEFAULT '0' NOT NULL auto_increment,
domain varchar(50) DEFAULT 'ematic' NOT NULL,
user_name varchar(75) DEFAULT '' NOT NULL,
emailname varchar(128) DEFAULT 'ematic_' NOT NULL,
passwd varchar(13) DEFAULT '' NOT NULL,
level tinyint(4) DEFAULT '0' NOT NULL,
groups varchar(100),
masteremail varchar(50),
createdate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
createdate_int bigint(20) unsigned DEFAULT '0' NOT NULL,
emaildir_max smallint(5) unsigned DEFAULT '25',
homedir_max smallint(5) unsigned DEFAULT '25',
emaildir_size smallint(5) unsigned DEFAULT '0',
homedir_size smallint(5) unsigned DEFAULT '0',
status enum('Y','N') DEFAULT 'Y',
homedir varchar(100),
emaildir varchar(100),
forward varchar(128) DEFAULT '$user',
mailmask varchar(18) DEFAULT '0.0.0.0' NOT NULL,
maildrop varchar(254) DEFAULT '/usr/spool/mail' NOT NULL,
fwd_flag enum('N','Y') DEFAULT 'N' NOT NULL,
free_or_fee enum('N','Y') DEFAULT 'N' NOT NULL,
lists enum('Y','N') DEFAULT 'Y' NOT NULL,
quota varchar(10) DEFAULT '100k',
tempuser enum('N','Y') DEFAULT 'N' NOT NULL,
userClass varchar(50) DEFAULT 'emailuser' NOT NULL,
referedBy varchar(50),
PRIMARY KEY (id),
UNIQUE emailname_idx (emailname),
UNIQUE dom_user_idx (domain,user_name),
KEY fwd_idx (fwd_flag),
UNIQUE free_or_fee_idx (emailname,free_or_fee),
KEY idx_lists (lists)
);
Any help would be greatly appreciated...
Clifford Lang
PXCM, Inc.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
