[freeside] courier-mta table name?

[Kristian Hoffmann]

The easiest way would be just change the courier config file to use user
instead of passwd.  Otherwise, edit sqlmail.pm and change...

%fs_mail_table = ( svc_acct => 'user',
                   svc_domain => 'domain' );

to

%fs_mail_table = ( svc_acct => 'passwd',
                   svc_domain => 'domain' );


Here is the schema we are using for sqlmail:

CREATE TABLE domain (
  domain char(128) NOT NULL default '',
  svcnum int(11) NOT NULL default '0',
  catchall int(11) default NULL,
  PRIMARY KEY  (svcnum)
) TYPE=MyISAM;

--
-- Table structure for table 'user'
--

CREATE TABLE user (
  username char(128) NOT NULL default '',
  _password char(128) NOT NULL default '',
  finger char(128) NOT NULL default '',
  domsvc int(11) NOT NULL default '0',
  svcnum int(11) NOT NULL default '0',
  PRIMARY KEY  (svcnum)
) TYPE=MyISAM;


And the MYSQL_SELECT_CLAUSE we're using for courier:

MYSQL_SELECT_CLAUSE     \
SELECT username, '', _password, [mtauid], [mtagid], CONCAT('/var/spool/courier/', \
'$(domain)', '/'), '$(local_part)', '', finger \
FROM user LEFT JOIN domain ON user.domsvc = domain.svcnum \
WHERE username = '$(local_part)' and domain = '$(domain)'


I have an example exim configuration if you want.

It was done like this so that we could use virtual domain hosting support
in courier.  It keeps a seperate spool directory for each domain.  The
export was intended for use with an MTA as well.  That is why the domain
table is there.  svc_forward support will be added eventually.

-Kristian


On 17 Jul 2002, Vlad Sedov wrote:

> Hello -
>
> How would I change the sqlmail table name from the default 'user' to
> something else? Our courier server stores the usernames in a table
> called 'passwd', and sqlmail.pm wants to update a table called 'user'...
>
>
> Thanks,
>
> Vlad
>
>
>
>