[Vmail-discuss] Help

Wed, 24 Apr 2002 16:50:21 +0200

Hello to all:
I am installing exim + tpop3d + vmail. But to me it does not work.
I have installed the Exim and tpop3d. But I cannot install the Vmail-SQL.
 When I install the vmail gives an error:

Rewriting scripts/VE-domain
Rewriting scripts/VE-forwarder
Rewriting scripts/VE-passwd
Rewriting scripts/VE-popbox
Rewriting web/cgi-bin/login
Rewriting web/cgi-bin/logout
Rewriting web/cgi-bin/passwd_domain
Rewriting web/cgi-bin/passwd_popbox
Rewriting web/cgi-bin/email_setup

(0.4) Database upgrade required
The database format for storing password hashes has changed.  Please revi=
ew and
apply db/upgrade-0.4.sql before using this version of vmail.

(0.5) Database upgrade required
The database tables for popboxes and forwarders are altered slightly for =
this
release. Please review and apply db/upgrade-0.5.sql before using this ver=
sion of
vmail.

(0.5) Exim config update required
The Exim configuration has been altered for this release to support alias=
ing of
domains.  Please see the config in the README file.

Somebody can help me.  Thousand thanks

This is the configuration of the Exim:

######################################################################
#                  Runtime configuration file for Exim               #
######################################################################

# This is a default configuration file which will operate correctly in
# uncomplicated installations. Please see the manual for a complete list
# of all the runtime configuration options that can be included in a
# configuration file. There are many more than are mentioned here. The
# manual is in the file doc/spec.txt in the Exim distribution as a plain
# ASCII file. Other formats (PostScript, Texinfo, HTML, PDF) are availabl=
e
# from the Exim ftp sites. The manual is also online via the Exim web sit=
es.

# This file is divided into several parts, all but the last of which are
# terminated by a line containing the word "end". The parts must appear
# in the correct order, and all must be present (even if some of them are
# in fact empty). Blank lines, and lines starting with # are ignored.

############ IMPORTANT ########## IMPORTANT ########### IMPORTANT #######=
#####
#                                                                        =
    #
# Whenever you change Exim's configuration file, you *must* remember to H=
UP  #
# the Exim daemon, because it will not pick up the new configuration unti=
l   #
# until you do this. It is usually a good idea to test a new configuratio=
n   #
# for syntactic correctness (e.g. using "exim -C /config/file -bV") first=
.   #
#                                                                        =
    #
############ IMPORTANT ########## IMPORTANT ########### IMPORTANT #######=
#####

######################################################################
#                    MAIN CONFIGURATION SETTINGS                     #
######################################################################

received_header_text =3D Received: ${if def:sender_rcvhost {from $sender_=
rcvhost\n        }{${if def:sender_ident {from $sender_ident }}${if def:s=
ender_helo_name {(helo=3D$sender_helo_name)\n   }}}}by ${primary_hostname=
} ${if def:received_protocol {with $received_protocol}} (Correo LESEIN)\n=
    id ${message_id}${if def:received_for {\n       for $received_for}}

# Specify your host's canonical name here. This should normally be the fu=
lly
# qualified "official" name of your host. If this option is not set, the
# uname() function is called to obtain the name.

# primary_hostname =3D

# Specify the domain you want to be added to all unqualified addresses
# here. An unqualified address is one that does not contain an "@" charac=
ter
# followed by a domain. For example, "caesar@rome.ex" is a fully qualifie=
d
# address, but the string "caesar" (i.e. just a login name) is an unquali=
fied
# email address. Unqualified addresses are accepted only from local calle=
rs by
# default. See the receiver_unqualified_{hosts,nets} options if you want
# to permit unqualified addresses from remote sources. If this option is
# not set, the primary_hostname value is used for qualification.

# qualify_domain =3D

# If you want unqualified recipient addresses to be qualified with a diff=
erent
# domain to unqualified sender addresses, specify the recipient domain he=
re.
# If this option is not set, the qualify_domain value is used.

# qualify_recipient =3D

# Specify your local domains as a colon-separated list here. If this opti=
on
# is not set (i.e. not mentioned in the configuration file), the
# qualify_recipient value is used as the only local domain. If you do not=
 want
# to do any local deliveries, uncomment the following line, but do not su=
pply
# any data for it. This sets local_domains to an empty string, which is n=
ot
# the same as not mentioning it at all. An empty string specifies that th=
ere
# are no local domains; not setting it at all causes the default value (t=
he
# setting of qualify_recipient) to be used.

local_domains =3D pepe.es:pepep.com

# If you want to accept mail addressed to your host's literal IP address,=
 for
# example, mail addressed to "user@[111.111.111.111]", then uncomment the
# following line, or supply the literal domain(s) as part of "local_domai=
ns"
# above. You also need to comment "forbid_domain_literals" below. This is=
 not
# recommended for today's Internet.

# local_domains_include_host_literals

# The following line prevents Exim from recognizing addresses of the form
# "user@[111.111.111.111]" that is, with a "domain literal" (an IP addres=
s)
# instead of a named domain. The RFCs still require this form, but it mak=
es
# little sense to permit mail to be sent to specific hosts by their IP ad=
dress
# in the modern Internet, and this ancient format has been used by those
# seeking to abuse hosts by using them for unwanted relaying. If you real=
ly
# do want to support domain literals, remove the following line, and see
# also the "domain_literal" router below.

forbid_domain_literals

# No local deliveries will ever be run under the uids of these users (a c=
olon-
# separated list). An attempt to do so gets changed so that it runs under=
 the
# uid of "nobody" instead. This is a paranoic safety catch. Note the defa=
ult
# setting means you cannot deliver mail addressed to root as if it were a
# normal user. This isn't usually a problem, as most sites have an alias =
for
# root that redirects such mail to a human administrator.

never_users =3D root

# The use of your host as a mail relay by any host, including the local h=
ost
# calling its own SMTP port, is locked out by default. If you want to per=
mit
# relaying from the local host, you should set
#
# host_accept_relay =3D localhost
#
# If you want to permit relaying through your host from certain hosts or =
IP
# networks, you need to set the option appropriately, for example
#
# host_accept_relay =3D my.friends.host : 192.168.0.0/16

host_auth_accept_relay =3D *

#host_accept_relay =3D *
#host_accept_relay =3D 212.0.0.0/8

#
# If you are an MX backup or gateway of some kind for some domains, you m=
ust
# set relay_domains to match those domains. This will allow any host to
# relay through your host to those domains.
#
# relay_domains =3D
#
# See the section of the manual entitled "Control of relaying" for more
# information.

# The setting below causes Exim to do a reverse DNS lookup on all incomin=
g
# IP calls, in order to get the true host name. If you feel this is too
# expensive, you can specify the networks for which a lookup is done, or
# remove the setting entirely.

host_lookup =3D *

# By default, Exim expects all envelope addresses to be fully qualified, =
that
# is, they must contain both a local part and a domain. If you want to ac=
cept
# unqualified addresses (just a local part) from certain hosts, you can s=
pecify
# these hosts by setting one or both of
#
# receiver_unqualified_hosts =3D
# sender_unqualified_hosts =3D
#
# to control sender and receiver addresses, respectively. When this is do=
ne,
# unqualified addresses are qualified using the settings of qualify_domai=
n
# and/or qualify_recipient (see above).

# By default, Exim does not make any checks, other than syntactic ones, o=
n
# incoming addresses during the SMTP dialogue. This reduces delays in SMT=
P
# transactions, but it does mean that you might accept messages with unkn=
own
# recipients, and/or bad senders.

# Uncomment this line if you want incoming recipient addresses to be veri=
fied
# during the SMTP dialogue. Unknown recipients are then rejected at this =
stage,
# and the generation of a failure message is the job of the sending host.

# receiver_verify

# Uncomment this line if you want incoming sender addresses (return-paths=
) to
# be verified during the SMTP dialogue. Verification can normally only ch=
eck
# that the domain exists.

# sender_verify

# Exim contains support for the Realtime Blackhole List (RBL) that is bei=
ng
# maintained as part of the DNS. See http://mail-abuse.org/rbl/ for backg=
round.
# Uncommenting the first line below will make Exim reject mail from any
# host whose IP address is blacklisted in the RBL at blackholes.mail-abus=
e.org.
# Some others have followed the RBL lead and have produced other lists: D=
UL is
# a list of dial-up addresses, and there are also a number of other lists
# of various kinds at orbs.org.

# rbl_domains =3D blackholes.mail-abuse.org
# rbl_domains =3D blackholes.mail-abuse.org:dialups.mail-abuse.org

# If you want Exim to support the "percent hack" for all your local domai=
ns,
# uncomment the following line. This is the feature by which mail address=
ed
# to x%y@z (where z is one of your local domains) is locally rerouted to
# x@y and sent on. Otherwise x%y is treated as an ordinary local part.

# percent_hack_domains =3D *

# When Exim can neither deliver a message nor return it to sender, it "fr=
eezes"
# the delivery error message (aka "bounce message"). There are also other
# circumstances in which messages get frozen. They will stay on the queue=
 for
# ever unless one of the following options is set.

# This option unfreezes unfreezes bounce messages after two days, tries
# once more to deliver them, and ignores any delivery failures.

ignore_errmsg_errors_after =3D 2d

# This option cancels (removes) frozen messages that are older than a wee=
k.

timeout_frozen_after =3D 7d

mysql_servers =3D localhost/vmail/root/pass

spool_directory =3D /var/spool/exim

smtp_banner =3D $primary_hostname ESMTP Correo pepe

end

######################################################################
#                      TRANSPORTS CONFIGURATION                      #
######################################################################
#                       ORDER DOES NOT MATTER                        #
#     Only one appropriate transport is called for each delivery.    #
######################################################################

# A transport is used only when referenced from a director or a router th=
at
# successfully handles an address.

# This transport is used for delivering messages over SMTP connections.

remote_smtp:
  driver =3D smtp

# This transport is to deliver mail going to virtual domains to user
# mailspools in directories under /var/spool/mail/SERVERS/foo/bar; this i=
s
# triggered from a director below.

virtual_localdelivery:
  driver =3D appendfile
  file =3D ${lookup mysql{select path from domain left join domain_alias =
on domain_alias.domain_name =3D domain.domain_name where domain.domain_na=
me =3D '$domain' or domain_alias.alias =3D '$domain'}{$value}fail}/${look=
up mysql{select mbox_name from popbox left join domain_alias on popbox.do=
main_name =3D domain_alias.domain_name where (popbox.domain_name =3D '$do=
main' or domain_alias.alias =3D '$domain') and local_part =3D '$local_par=
t'}{$value}fail}
  delivery_date_add
  envelope_to_add
  return_path_add
  user =3D ${lookup mysql{select unix_user from domain left join domain_a=
lias on domain_alias.domain_name =3D domain.domain_name where domain.doma=
in_name =3D '$domain' or domain_alias.alias =3D '$domain'}{$value}fail}
  mode =3D 0660

# This transport is used for local delivery to user mailboxes in traditio=
nal
# BSD mailbox format. By default it will be run under the uid and gid of =
the
# local user, and requires the sticky bit to be set on the /var/mail dire=
ctory.
# Some systems use the alternative approach of running mail deliveries un=
der a
# particular group instead of using the sticky bit. The commented options=
 below
# show how this can be done.

local_delivery:
  driver =3D appendfile
  file =3D /var/mail/$local_part
  delivery_date_add
  envelope_to_add
  return_path_add
 group =3D mail
 mode =3D 0660

# This transport is used for handling pipe deliveries generated by alias
# or .forward files. If the pipe generates any standard output, it is ret=
urned
# to the sender of the message as a delivery error. Set return_fail_outpu=
t
# instead of return_output if you want this to happen only when the pipe =
fails
# to complete normally. You can set different transports for aliases and
# forwards if you want to - see the references to address_pipe in the dir=
ectors
# section below.

address_pipe:
  driver =3D pipe
  return_output

# This transport is used for handling deliveries directly to files that a=
re
# generated by aliasing or forwarding.

address_file:
  driver =3D appendfile
  delivery_date_add
  envelope_to_add
  return_path_add

# This transport is used for handling autoreplies generated by the filter=
ing
# option of the forwardfile director.

address_reply:
  driver =3D autoreply

end

######################################################################
#                      DIRECTORS CONFIGURATION                       #
#             Specifies how local addresses are handled              #
######################################################################
#                          ORDER DOES MATTER                         #
#   A local address is passed to each in turn until it is accepted.  #
######################################################################

# Local addresses are those with a domain that matches some item in the
# "local_domains" setting above, or those which are passed back from the
# routers because of a "self=3Dlocal" setting (not used in this configura=
tion).

# This director handles aliasing using a traditional /etc/aliases file.
#
##### NB NB You must ensure that /etc/aliases exists. It used to be the c=
ase
##### NB NB that every Unix had that file, because it was the Sendmail de=
fault.
##### NB NB These days, there are systems that don't have it. Your aliase=
s
##### NB NB file should at least contain an alias for "postmaster".
#
# If any of your aliases expand to pipes or files, you will need to set
# up a user and a group for these deliveries to run under. You can do
# this by uncommenting the "user" option below (changing the user name
# as appropriate) and adding a "group" option if necessary. Alternatively=
, you
# can specify "user" on the transports that are used. Note that those
# listed below are the same as are used for .forward files; you might wan=
t
# to set up different ones for pipe and file deliveries from aliases.

# The virtualemail database allows local parts to correspond to remote
# addresses (forwarding), to be aliases for local maildrops, or to be loc=
al
# maildrops. These are expressed in tables forwarder and popbox
# respectively.

# Handle forwarders and aliases (same database table)

virtual_forward:
  driver =3D aliasfile
  search_type =3D mysql
  query =3D "select remote_name from forwarder left join domain_alias on =
domain_alias.domain_name =3D forwarder.domain_name where local_part =3D '=
$local_part' and (forwarder.domain_name =3D '$domain' or alias =3D '$doma=
in')"
  forbid_file =3D true
  forbid_pipe =3D true

# Handle delivery; see sample config C009 for what this is based on; it o=
nly
# handles things for the virtual domains, which are listed in the databas=
e.

virtual_localuser:
  driver =3D aliasfile
  search_type =3D mysql
  query =3D "select mbox_name from popbox left join domain_alias on domai=
n_alias.domain_name =3D popbox.domain_name where local_part =3D '$local_p=
art' and (popbox.domain_name =3D '$domain' or alias =3D '$domain')"
  transport =3D virtual_localdelivery

# deliver any undelivered virtual email according to the _default_ forwar=
der

virtual_defaultuser:
  driver =3D aliasfile
  search_type =3D mysql
  query =3D "select remote_name from forwarder left join domain_alias on =
domain_alias.domain_name =3D forwarder.domain_name where local_part =3D '=
_default_' and (forwarder.domain_name =3D '$domain' or domain_alias.alias=
 =3D '$domain')"
  forbid_file =3D true
  forbid_pipe =3D true

system_aliases:
  driver =3D aliasfile
  file =3D /etc/aliases
  search_type =3D lsearch
# user =3D exim
  file_transport =3D address_file
  pipe_transport =3D address_pipe

# This director handles forwarding using traditional .forward files.
# If you want it also to allow mail filtering when a forward file
# starts with the string "# Exim filter", uncomment the "filter" option.

# The no_verify setting means that this director will be skipped when
# verifying addresses if sender_verify or receiver_verify is set (though
# they are not set by default). Similarly, no_expn means that this direct=
or
# will be skipped if smtp_expn_hosts is set to allow any hosts to use the
# EXPN command.

# The check_ancestor option means that if the forward file generates an
# address that is an ancestor of the current one, the current one gets
# passed on instead. This covers the case where A is aliased to B and B
# has a .forward file pointing to A.

# The three transports specified at the end are those that are used when
# forwarding generates a direct delivery to a file, or to a pipe, or sets
# up an auto-reply, respectively.

userforward:
  driver =3D forwardfile
  file =3D .forward
  no_verify
  no_expn
  check_ancestor
# filter
  file_transport =3D address_file
  pipe_transport =3D address_pipe
  reply_transport =3D address_reply

# This director matches local user mailboxes.

localuser:
  driver =3D localuser
  transport =3D local_delivery

end

######################################################################
#                      ROUTERS CONFIGURATION                         #
#            Specifies how remote addresses are handled              #
######################################################################
#                          ORDER DOES MATTER                         #
#  A remote address is passed to each in turn until it is accepted.  #
######################################################################

# Remote addresses are those with a domain that does not match any item
# in the "local_domains" setting above.

# This router routes to remote hosts over SMTP using a DNS lookup. Any do=
main
# that resolves to an IP address on the loopback interface (127.0.0.0/8) =
is
# treated as if it had no DNS entry.

lookuphost:
  driver =3D lookuphost
  transport =3D remote_smtp
  ignore_target_hosts =3D 127.0.0.0/8

# This router routes to remote hosts over SMTP by explicit IP address,
# when an email address is given in "domain literal" form, for example,
# <user@[192.168.35.64]>. The RFCs require this facility. However, it is
# little-known these days, and has been exploited by evil people seeking
# to abuse SMTP relays. Consequently it is commented out in the default
# configuration. If you uncomment this router, you also need to comment o=
ut
# "forbid_domain_literals" above, so that Exim can recognize the syntax o=
f
# domain literal addresses.

# domain_literal:
#   driver =3D ipliteral
#   transport =3D remote_smtp

end

######################################################################
#                      RETRY CONFIGURATION                           #
######################################################################

# This single retry rule applies to all domains and all errors. It specif=
ies
# retries every 15 minutes for 2 hours, then increasing retry intervals,
# starting at 1 hour and increasing each time by a factor of 1.5, up to 1=
6
# hours, then retries every 8 hours until 4 days have passed since the fi=
rst
# failed delivery.

# Domain               Error       Retries
# ------               -----       -------

*                      *           F,2h,15m; G,16h,1h,1.5; F,4d,8h

end

######################################################################
#                      REWRITE CONFIGURATION                         #
######################################################################

# There are no rewriting specifications in this default configuration fil=
e.

end

######################################################################
#                   AUTHENTICATION CONFIGURATION                     #
######################################################################

plain:
  driver =3D plaintext
  public_name =3D PLAIN
  server_condition =3D "${if crypteq{$3}\
{${lookup mysql{select password_hash from popbox where mbox_name =3D '${l=
ocal_part:$2}' and domain_name =3D'${domain:$2}'}\
{$value}{fail}}}{1}{0}}"
  server_set_id =3D $1

login:
  driver =3D plaintext
  public_name =3D LOGIN
  server_prompts =3D "Username::: Password::"
  server_condition =3D "${if crypteq{$2}\
{${lookup mysql{select password_hash from popbox where mbox_name =3D '${l=
ocal_part:$1}' and domain_name =3D'${domain:$1}'}\
{$value}{fail}}}{1}{0}}"
  server_set_id =3D $1

# End of Exim configuration file

 =20

That I make bad.  Somebody can help me.  Thanks

--=20
Saludos,
 Salom=E9                          mailto:saugusto@lesein.es