i've solved..
thanks very much.
bur now i'm havin other problem:
Aug 29 12:35:21 ns1 postfix/virtual[5394]: 45C13650242:
to=<[EMAIL PROTECTED]>, relay=virtual, delay=0, status=deferred
(recipient [EMAIL PROTECTED]: bad uid 106 in virtual_uid_maps)
and in my main.cf i have added this lines
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:107
virtual_mailbox_base = /usr/local/virtual
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 1001
virtual_transport = virtual
virtual_uid_maps = static:106
from my pssswd file
postfix:x:106:107::/var/spool/postfix:/bin/false
any ideas?
thanks in advance
manuel
Kevin Coyner wrote:
On Fri, Aug 26, 2005 at 02:03:41PM -0300, Juan Manuel Tato wrote......
kevin, thanks for your help, but is not working..... i'd created
as you told the provider_admin user, into mysql db, user table...
but still the same problems
Aug 24 18:48:08 ns1 postfix/smtpd[3322]: connect from
localhost.localdomain[127.0.0.1]
Aug 24 18:48:40 ns1 postfix/smtpd[3322]: 0DA3465029B:
client=localhost.localdomain[127.0.0.1]
Aug 24 18:48:45 ns1 postfix/cleanup[3469]: 0DA3465029B:
message-id=<[EMAIL PROTECTED]>
Aug 24 18:48:45 ns1 postfix/qmgr[2855]: 0DA3465029B: from=<[EMAIL PROTECTED]>,
size=354, nrcpt=1 (queue active)
Aug 24 18:48:45 ns1 postfix/virtual[3472]: warning: connect to mysql
server 127.0.0.1: Access denied for user 'postfix'@'localhost' (using
Manuel - you still have something wrong with your user. Look at
the line immediately above. It says:
"Access denied for user 'postfix'@'localhost'.
So when postfix/courier is doing a mysql database lookup, it is
presently doing so as user 'postfix'. Yet you state that you've set
up everything to be user 'provider_admin'.
So check your entries in the mysql DB again in the user and db
tables.
Also, in /etc/postfix, you should have something similar to:
mysql-virtual_domains.cf
mysql-virtual_email2email.cf
mysql-virtual_forwardings.cf
mysql-virtual_lists_transport.cf
mysql-virtual_mailboxes.cf
Double check that each of these is correct. For example, my
mysql-virtual_domains.cf file has:
user = vmail
password = xxxxxxx
dbname = provider
table = domains
select_field = transport
where_field = domain
hosts = 127.0.0.1
... and in my mysql db, in the user table, I have a user named
'vmail' that is only allowed to log in from localhost and has no
default priviledges. In the mysql database, db table I have an
entry for User 'vmail', Host 'localhost' and Db 'provider'. And
associated with this entry is where this user gets all the necessary
permissions for accessing the database 'provider'.
vmail is my equivalent of your 'provider_admin'.
You should be able to open up an xterm on the server and type the
following:
$ mysql -u provider_admin -p provider
... and be prompted for the password for provider_admin. If you
cannot do this and gain command line entry to the provider database,
then you still do not have the mysql db entries right for your user.
If you can do this, then I suspect you have an error in your
mysql-virtual_xxxxx.cf files.
Kevin
--
ZONA LIBRE
www.zonalibre.com.uy | Paysandú 976
Teléfono 9012772 | Fax 9016377
E-mail: [EMAIL PROTECTED]
MSN: [EMAIL PROTECTED]
begin:vcard
fn:Juan Manuel Tato
n:;Juan Manuel Tato
org:Zona Libre Trad. Co.
adr;quoted-printable:;;Paysand=C3=BA 976;Montevideo;;11100;Uruguay
email;internet:[EMAIL PROTECTED]
tel;work:9012772
tel;fax:9016377
url:http://www.zonalibre.com.uy
version:2.1
end:vcard
