> CREATE DATABASE `mail`;
> CREATE TABLE `accountuser` (
> `username` varchar(255) binary NOT NULL default '',
> `password` varchar(30) binary NOT NULL default '',
> `prefix` varchar(50) NOT NULL default '',
> `domain_name` varchar(255) NOT NULL default '',
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> `id` int(11) NOT NULL
> auto_increment,
> <<<<<<<<<<<<<<<<inserted
> myself
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> `passwd_expire` varchar(25)
> default NULL, <<<<<<<<<<<<<<<<inserted
> myself
> PRIMARY KEY (`username`,`id`)
> ) TYPE=MyISAM AUTO_INCREMENT=1 ;
passwd_expire can just be a boolean field, no need to use varchar(25), but
that'll work in any case.
> CREATE TABLE `alias` (
> `alias` varchar(255) NOT NULL default '',
> `dest` longtext,
> `username` varchar(50) NOT NULL default '',
> `status` int(11) NOT NULL default '1',
> PRIMARY KEY (`alias`)
> ) TYPE=MyISAM;
this is a duplicate of the table called "virtual", you should probably
choose one or the other to avoid confustion
> #
> # Table structure for table `virtual`
> #
>
> CREATE TABLE `virtual` (
> `alias` varchar(255) NOT NULL default '',
> `dest` longtext,
> `username` varchar(50) NOT NULL default '',
> `status` int(11) NOT NULL default '1',
> KEY `alias` (`alias`)
> ) TYPE=MyISAM;
>
> #
> # Dumping data for table `virtual`
> #
>
> INSERT INTO `virtual` VALUES ('[EMAIL PROTECTED]',
> 'rosindo.linuxserver.kicks-ass.org', 'rosindo.linuxserver.kicks-ass.org',
> 1);
> INSERT INTO `virtual` VALUES ('[EMAIL PROTECTED]',
> 'sophianum.linuxserver.kicks-ass.org',
> 'sophianum.linuxserver.kicks-ass.org', 1);
> INSERT INTO `virtual` VALUES ('[EMAIL PROTECTED]',
> 'test.linuxserver.kicks-ass.org', 'test.linuxserver.kicks-ass.org', 1);
so what's the difference between the "dest" and "username" fields. I'll
assume "dest" is the one you should be using
> imapd[3713]: SQUAT failed to open index file
> imapd[3713]: SQUAT failed
http://www.irbs.net/internet/info-cyrus/0204/0581.html
> PHP Warning: mysql_result(): Unable to jump to row 0 on MySQL result
> index
> 80 in /srv/www/htdocs/mail/plugins/change_mysqlpass/functions.php on line
> 129, referer: http://linuxserver.kicks-ass.org/mail/src/webmail.php
This is helpful.
Look at the code - it's trying to find your user's "force password change"
field in the database and not finding anything:
SELECT $mysql_password_change_field
FROM $mysql_table
WHERE $mysql_userid_field = $username;
> // The MySQL Server that SASL uses
> $mysql_server = 'localhost';
> // Database and table that SASL uses for auth
> $mysql_database = 'mail';
> $mysql_table = 'accountuser';
> // The names of the user ID and password columns
> $mysql_userid_field = 'username';
> $mysql_password_field ='password';
> // The user to log into MySQL with (must have rights)
> $mysql_manager_id = 'some name';
> $mysql_manager_pw = 'some pass';
> // Force password change field
> $mysql_password_change_field = 'passwd_expire';
You're not done here. Did you populate that column in the database? What
are the config settings for the 'passwd_expire' values
($mysql_password_force, etc)? Do you have the correct password encryption
settings in the config file too?
You might also want to verify that the SM username matches the database. Put
global $username; echo "<HR>$username<HR>";
in one of the files (doesn't really matter where) and verify what it
prints out is what you'd expect for a username from the database.
-------------------------------------------------------
This SF.net email is sponsored by: Perforce Software.
Perforce is the Fast Software Configuration Management System offering
advanced branching capabilities and atomic changes on 50+ platforms.
Free Eval! http://www.perforce.com/perforce/loadprog.html
--
squirrelmail-users mailing list
List Address: [EMAIL PROTECTED]
List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id)95
List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
