| View previous topic :: View next topic |
| Author |
Message |
parisien
n00b
Joined: 16 Feb 2009
Posts: 2
|
 Posted: Mon Feb 16, 2009 8:21 pm Post subject: probleme with the postix / mysql intallation |
 |
|
hello
i am trying to install postfix on my gentoo 2008
i readed a lot of time thos how to http://www.gentoo.org/doc/en/virt-mail-howto.xml and i am making it.
since now everything is ok, but i have a probmeme with the mysql part ( 8 ) : http://www.gentoo.org/doc/en/virt-mail-howto.xml#doc_chap8
it is not very clear what i have to put in each database for what result (i don't know if you understand me good, my english is very bad)
i have 2 domaines... exemple : toto.fr and tata.fr
and i have 5 users.
user1@toto.fr
user2@toto.fr
user3@toto.fr
user1@toto.fr
user2@tata.fr
can someone help me to understanf what i have to put in what field if i want that each of these users can receve the mails that are sent to them ?
i really hope someone will help me.
thank you. |
|
| Back to top |
|
 |
nurachi
Tux's lil' helper
Joined: 16 May 2008
Posts: 92
Location: Paris
|
| Posted: Tue Feb 17, 2009 6:19 pm Post subject: |
|
|
| Code: | #create a database named 'mailsql '
mysqladmin -u root -p create mailsql
#import stuff (table structures, insertions, etc) in 'mailsql' database using root account
mysql -u root -p mailsql < genericmailsql.sql
#connect to the console
mysql -u root -p mysql
#create an unprivileged account on this database.
mysql> GRANT SELECT,INSERT,UPDATE,DELETE
-> ON mailsql.*
-> TO mailsql@localhost
-> IDENTIFIED BY '$password';
Query OK, 0 rows affected (0.02 sec)
#clear the authentication cache
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit |
Look in the created tables (alias, relocated, transport, users, virtual) and change them according to your needs. Domains are in virtual, users in users, mail in alias, etc.
Ah, ces parisiens! |
|
| Back to top |
|
|
parisien
n00b
Joined: 16 Feb 2009
Posts: 2
|
| Posted: Tue Feb 17, 2009 6:29 pm Post subject: |
|
|
Thank you for your answer.
i made the database and i open it with phpmyadmin. That part is ok and i saw the sample in it.
The probleme, is that i don't know in what field i have to put the real emails accounts or the mailbox, the domain names, why in some field they put virtual: or local: what domain must be local what must be virtual.why in the alias there is root or postmaster and it is not mail adresses.
I don't know if my english is good enouph but i don't know what information i have to put in wich field of the database to tell postfix that if he receive a mail for this user in this virtual domain, he has to put the mail in the right mailbox.
i hope you will understand what i want to mean.
thank you |
|
| Back to top |
|
|
nurachi
Tux's lil' helper
Joined: 16 May 2008
Posts: 92
Location: Paris
|
| Posted: Tue Feb 17, 2009 6:52 pm Post subject: |
|
|
All of the answers and concepts you need are in the postfix documentation, but:
- local is for local machine delivery.
- postmaster is a general account (set in a RFC) for MTA management the person, you can write for a problem with the MTA.
- see also http://www.postfixvirtual.net/postfixconf.html#mysql for how to manage accounts (A.K.A. "MANAGE POSTFIX"). |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Portage & Programming
