OK, so I have been battling with this for some time now, and for the life
of me I just can't get this to work at all. Mostly this is because of my
serious lack of understanding of how this plugin works and also of sql.
I wish to have this plugin work with my DTC installation. The authers of
DTC tell me that the email users details are stored in the table
pop_access
I have exported the table structure.
--
-- Table structure for table `pop_access`
--
CREATE TABLE IF NOT EXISTS `pop_access` (
`autoinc` int(12) NOT NULL auto_increment,
`id` varchar(32) collate latin1_bin NOT NULL default '',
`uid` int(11) NOT NULL default '1001',
`gid` int(11) NOT NULL default '1001',
`home` varchar(255) collate latin1_bin NOT NULL default '',
`shell` varchar(255) collate latin1_bin NOT NULL default '',
`mbox_host` varchar(120) collate latin1_bin NOT NULL default '',
`crypt` varchar(255) collate latin1_bin NOT NULL default '',
`passwd` varchar(255) collate latin1_bin NOT NULL default '',
`active` int(11) NOT NULL default '1',
`start_date` date NOT NULL default '0000-00-00',
`expire_date` date NOT NULL default '0000-00-00',
`quota_size` int(11) NOT NULL default '500000000',
`quota_files` int(11) NOT NULL default '1000',
`quota_couriermaildrop` varchar(255) collate latin1_bin NOT NULL default
'500000000S,1000C',
`type` varchar(20) collate latin1_bin NOT NULL default 'default',
`memo` text collate latin1_bin,
`du` bigint(20) NOT NULL default '0',
`another_perso` varchar(5) collate latin1_bin NOT NULL default 'no',
`redirect1` varchar(255) collate latin1_bin default NULL,
`redirect2` varchar(255) collate latin1_bin default NULL,
`localdeliver` varchar(10) collate latin1_bin NOT NULL default 'yes',
`pop3_login_count` int(9) NOT NULL default '0',
`pop3_transfered_bytes` int(14) NOT NULL default '0',
`imap_login_count` int(9) NOT NULL default '0',
`imap_transfered_bytes` int(14) NOT NULL default '0',
`last_login` int(14) NOT NULL default '0',
`bounce_msg` text collate latin1_bin NOT NULL,
`spf_protect` enum('yes','no') collate latin1_bin NOT NULL default 'no',
`clamav_protect` enum('yes','no') collate latin1_bin NOT NULL default 'no',
`spam_mailbox_enable` enum('yes','no') collate latin1_bin NOT NULL
default 'no',
`spam_mailbox` varchar(255) collate latin1_bin NOT NULL default 'SPAM',
`pass_next_req` varchar(128) collate latin1_bin NOT NULL default '',
`pass_expire` int(12) NOT NULL default '0',
`vacation_flag` enum('yes','no') collate latin1_bin default 'no',
`vacation_text` text collate latin1_bin NOT NULL,
`iwall_protect` enum('yes','no') collate latin1_bin NOT NULL default 'no',
`fullemail` varchar(255) collate latin1_bin NOT NULL default 'none',
PRIMARY KEY (`autoinc`),
UNIQUE KEY `id` (`id`,`mbox_host`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin
AUTO_INCREMENT=12 ;
id contains the users name left of the @
mbox_host contains the domain name portion (right of the @)
crypt not sure about this
passwd contains the users password in plain text. For some reason the
authers of DTC decided not to store passwords encrypted.
fullemail contains the users full email address.
If someone could explain to me how the configuration lines work it would
help me to understand how it all functions and to be able to resolve this.
Here are my assumptions.
$csp_dsn = 'mysql://dbadmin:dbadminpassword@localhost/dtc';
Not a clue
//$lookup_password_query = '';
// TERRIBLE SECURITY: $lookup_password_query = 'SELECT count(*) FROM users
WHERE username = "%1" AND plain_password = "%5"';
Frankly the rest of it is a clueless operation for me.
I have searched and read, but I can't help but feel that there is a good
level of a presumption of understanding before you start, something I
clearly lack.
Sorry if my question seems mundane, but I am not kidding when I say I have
been working on this for some time. 4 months off and on. Each weekend I
would come back to it.
Some greater wisdom spoken at an introductory level would be most helpfull
to me at this time.
Regards
Fred
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
