Thanx for your fast help.
> > Hi, just started with squirrelmail, and i have to say, its a simple and
a
> > good looking application.
>
> Always nice to hear that.
>
> > I have setup postfix and cyrus according the next howto
> >
http://www.delouw.ch/linux/Postfix-Cyrus-Web-cyradm-HOWTO/html/index.html
> >
> > Its a virtual-user setup with users and passwords in Mysql.
>
> Terrible that there is nowhere in that HOWTO that lists the ddl for your
> database, so I have no idea what your DB looks like.
Ok here is my database:
# Database : `mail`
#
CREATE DATABASE `mail`;
USE mail;
# --------------------------------------------------------
#
# Table structure for table `accountuser`
#
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 ;
#
# Dumping data for table `accountuser`
#
INSERT INTO `accountuser` VALUES ('cyrus', 'somepassword', '', '', 0, NULL);
INSERT INTO `accountuser` VALUES ('rosindo.linuxserver.kicks-ass.org',
somepassword', 'linuxserver.kicks-ass.org', 'linuxserver.kicks-ass.org', 1,
NULL);
INSERT INTO `accountuser` VALUES ('sophianum.linuxserver.kicks-ass.org',
'somepassword', 'linuxserver.kicks-ass.org', 'linuxserver.kicks-ass.org', 2,
NULL);
INSERT INTO `accountuser` VALUES ('test.linuxserver.kicks-ass.org',
'somepassword', 'linuxserver.kicks-ass.org', 'linuxserver.kicks-ass.org', 3,
NULL);
# --------------------------------------------------------
#
# Table structure for table `adminuser`
#
CREATE TABLE `adminuser` (
`username` varchar(50) binary NOT NULL default '',
`password` varchar(50) binary NOT NULL default '',
`type` int(11) NOT NULL default '0',
`SID` varchar(255) NOT NULL default '',
`home` varchar(255) NOT NULL default '',
PRIMARY KEY (`username`)
) TYPE=MyISAM;
#
# Dumping data for table `adminuser`
#
INSERT INTO `adminuser` VALUES ('admin', 'somepassword', 0, '', '');
INSERT INTO `adminuser` VALUES ('rosindo', 'somepassword', 0, '', '');
# --------------------------------------------------------
#
# Table structure for table `alias`
#
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;
#
# Dumping data for table `alias`
#
# --------------------------------------------------------
#
# Table structure for table `domain`
#
CREATE TABLE `domain` (
`domain_name` varchar(255) NOT NULL default '',
`prefix` varchar(50) NOT NULL default '',
`maxaccounts` int(11) NOT NULL default '20',
`quota` int(10) NOT NULL default '20000',
`transport` varchar(255) NOT NULL default 'cyrus',
`freenames` enum('YES','NO') NOT NULL default 'NO',
`freeaddress` enum('YES','NO') NOT NULL default 'NO',
PRIMARY KEY (`domain_name`),
UNIQUE KEY `prefix` (`prefix`)
) TYPE=MyISAM;
#
# Dumping data for table `domain`
#
INSERT INTO `domain` VALUES ('linuxserver.kicks-ass.org',
'linuxserver.kicks-ass.org', 100, 20000, 'cyrus', 'NO', 'NO');
# --------------------------------------------------------
#
# Table structure for table `domainadmin`
#
CREATE TABLE `domainadmin` (
`domain_name` varchar(255) NOT NULL default '',
`adminuser` varchar(255) NOT NULL default ''
) TYPE=MyISAM;
#
# Dumping data for table `domainadmin`
#
INSERT INTO `domainadmin` VALUES ('*', 'admin');
INSERT INTO `domainadmin` VALUES ('*', 'rosindo');
# --------------------------------------------------------
#
# Table structure for table `log`
#
CREATE TABLE `log` (
`id` int(11) NOT NULL auto_increment,
`msg` text NOT NULL,
`user` varchar(255) NOT NULL default '',
`host` varchar(255) NOT NULL default '',
`time` datetime NOT NULL default '2000-00-00 00:00:00',
`pid` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2169 ;
#
# Dumping data for table `log`
#
Some stuff
# --------------------------------------------------------
#
# Table structure for table `search`
#
CREATE TABLE `search` (
`search_id` varchar(255) NOT NULL default '',
`search_sql` text NOT NULL,
`perpage` int(11) NOT NULL default '0',
`timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`search_id`),
KEY `search_id` (`search_id`)
) TYPE=MyISAM;
#
# Dumping data for table `search`
#
# --------------------------------------------------------
#
# 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);
>
> > I want to use the plugin changepassword in mysql, but the only thing i
see
> > when i click on the plugin in the options, is a blank page.
>
> Turn up error reporting in php.ini:
>
> display_errors=On
> error_reporting=E_ALL
>
> or look in your apache error log
>
Done: the only thing i see is the following:
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
cant figure out what this is:
imapd[3713]: SQUAT failed to open index file
imapd[3713]: SQUAT failed
> > I checked the plugin, and i see some tables which are used by the plugin
> > which are needed, wittch with my current setup i dont have. I have
> > inserted these tables, without success.
>
> well, you could start by listing what those tables are. you can't just
> put table names in the config file that don't exist in your database. do
> you know how your DB is structured?
>
> > My question is, is there anyone who has got the plugin working, or knows
> > what to do next.
>
> sure, it works for lots of people. don't know what to do next since i
> don't really know what your problem is.
>
> - paul
>
Here is my config of the plugin:
// The MySQL Server that SASL uses
$mysql_server = 'localhost';
// Database and table that SASL uses for auth
$mysql_database = 'mail';
database is mail
$mysql_table = 'accountuser';
table where the passwords and users are stored
// The names of the user ID and password columns
$mysql_userid_field = 'username';
changed to username according my DB
$mysql_password_field ='password';
changed to password according my DB
// 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';
inserted to DB for this configuration, but without result
Hope you can help me more with this info.
Again, thanx for your help.
Robert
-------------------------------------------------------
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=2995
List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
