[K12OSN] Postfix Mail Server tutorial

Wed Jun 16 16:59:18 UTC 2004

	When I do "show tables" the result is "Empty set (00.0 sec)" and when you
say run these commands I don't understand, is it all one line? How is each
line seperated? What is the syntax for this command? I've trier everything I
know, I'm sure its simple, but not if you don't know how....   Please
explain....
Rick O'Dell
Net Work Administrator
Bakersfield R4 School Dst.
Phone (417)284-7333 ext 303
rodell at bakersfield.k12.mo.us

-----Original Message-----
From: k12osn-bounces at redhat.com [mailto:k12osn-bounces at redhat.com]On Behalf
Of William J McCloskey
Sent: Wednesday, June 16, 2004 11:20 AM
To: 'Support list for opensource software in schools.'
Subject: RE: [K12OSN] Postfix Mail Server tutorial

Login to mysql.

Mysql> use db;    (replace db with the name of your squirrel mail database)
Mysql> show tables;

This will show a list of tables in that database. You should have one called
"addresses" and one called "userprefs".

If not, run these commands:
CREATE TABLE address (
    owner varchar(128) DEFAULT '' NOT NULL,
    nickname varchar(16) DEFAULT '' NOT NULL,
    firstname varchar(128) DEFAULT '' NOT NULL,
    lastname varchar(128) DEFAULT '' NOT NULL,
    email varchar(128) DEFAULT '' NOT NULL,
    label varchar(255),
    PRIMARY KEY (owner,nickname),
    KEY firstname (firstname,lastname)
  );

CREATE TABLE userprefs (
   user varchar(128) DEFAULT '' NOT NULL,
   prefkey varchar(64) DEFAULT '' NOT NULL,
   prefval BLOB DEFAULT '' NOT NULL,
   PRIMARY KEY (user,prefkey)
 );

I'm not sure, but you might need to flush the permissions table using "FLUSH
PERMISSIONS;" to get the permissions to take effect on the new tables.

That should get ya working though.

William McCloskey

-----Original Message-----
From: k12osn-bounces at redhat.com [mailto:k12osn-bounces at redhat.com] On Behalf
Of Rick O'Dell
Sent: Wednesday, June 16, 2004 9:31 AM
To: Support list for opensource software in schools.
Subject: RE: [K12OSN] Postfix Mail Server tutorial

	How can I check Mysql/Squirrelmail to see if the address table and
the
userprefs table exist??????
Rick O'Dell
Net Work Administrator
Bakersfield R4 School Dst.
Phone (417)284-7333 ext 303
rodell at bakersfield.k12.mo.us

-----Original Message-----
From: k12osn-bounces at redhat.com [mailto:k12osn-bounces at redhat.com]On Behalf
Of William J McCloskey
Sent: Wednesday, June 16, 2004 11:08 AM
To: 'Support list for opensource software in schools.'
Subject: RE: [K12OSN] Postfix Mail Server tutorial

That sounds like a squirrel mail error, Check your Squirrel mail
configuration and mysql settings.

William McCloskey
IT Manager

Timbercon, INC. ~ www.timbercon.com
-----Original Message-----
From: k12osn-bounces at redhat.com [mailto:k12osn-bounces at redhat.com] On Behalf
Of Rick O'Dell
Sent: Wednesday, June 16, 2004 9:18 AM
To: Support list for opensource software in schools.
Subject: RE: [K12OSN] Postfix Mail Server tutorial

	I have tried this, when I attempt to login to Squirrel Mail I get an
error;
(Preference Database error (not found). Exiting abnormally. I don't
understand how to paste the tables into Mysql.....  Please help....
Rick O'Dell
Net Work Administrator
Bakersfield R4 School Dst.
Phone (417)284-7333 ext 303
rodell at bakersfield.k12.mo.us

-----Original Message-----
From: k12osn-bounces at redhat.com [mailto:k12osn-bounces at redhat.com]On Behalf
Of Jim Kronebusch
Sent: Friday, May 21, 2004 11:03 AM
To: k12osn at redhat.com
Subject: [K12OSN] Postfix Mail Server tutorial

I found the following site for any of those who are interested detailing
a complete Postfix + Pop + Imap + Squirrelmail + ClamAV + SpamAssassin
server.  It is easy to follow and no hidden or implied steps.  This is
even written for WBEL 3.  I just ran this as an addon to my file server.
Definitely the quickest and easiest tutorial I found for this setup.

http://www.linuxhelp.ca/forums/index.php?act=ST&f=3&t=3647

_______________________________________________
K12OSN mailing list
K12OSN at redhat.com
https://www.redhat.com/mailman/listinfo/k12osn
For more info see <http://www.k12os.org>
--
Incoming mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.245 / Virus Database: 262.10.2 - Release Date: 5/18/2004

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.251 / Virus Database: 263.3.2 - Release Date: 6/15/2004

_______________________________________________
K12OSN mailing list
K12OSN at redhat.com
https://www.redhat.com/mailman/listinfo/k12osn
For more info see <http://www.k12os.org>

_______________________________________________
K12OSN mailing list
K12OSN at redhat.com
https://www.redhat.com/mailman/listinfo/k12osn
For more info see <http://www.k12os.org>
--
Incoming mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.251 / Virus Database: 263.3.2 - Release Date: 6/15/2004

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.251 / Virus Database: 263.3.2 - Release Date: 6/15/2004

_______________________________________________
K12OSN mailing list
K12OSN at redhat.com
https://www.redhat.com/mailman/listinfo/k12osn
For more info see <http://www.k12os.org>

_______________________________________________
K12OSN mailing list
K12OSN at redhat.com
https://www.redhat.com/mailman/listinfo/k12osn
For more info see <http://www.k12os.org>
--
Incoming mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.251 / Virus Database: 263.3.2 - Release Date: 6/15/2004

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.251 / Virus Database: 263.3.2 - Release Date: 6/15/2004