Current User: Guest Login Register
Please consider registering


Register? | Lost Your Password?

Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

Mail Server with MYSQL Postfic

Reply to Post Add a New Topic
UserPost

9:01 am
May 25, 2010


krishna

Member

posts 8

Hi, to all

 

when i installed the postfix with MYSQL suppoted and i followed

setp by http://www.linuxmail.info/mult…..-centos-5/

 

when i used the code i am getting error please help me

postmap -q acme.com mysql:/etc/postfix/mysql-domains.cf

postmap: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

thanks in advance.

 

Krishna.

 

5:10 pm
May 25, 2010


consultant

Admin

posts 341

Hi krishna,

 

You need to do the steps in How to Install Postfix Admin first.

1:31 am
May 26, 2010


krishna

Member

posts 8

Hi,

 

thanks to replay i install the postfix admin it's working fine

after that only i went to this link  http://www.linuxmail.info/mult…..-centos-5/

in the 3 step only i am getting this error  pleas help me.

 

 

regards

Krishna.

 

9:14 am
May 26, 2010


consultant

Admin

posts 341

Is Postfix Admin, MySQL and Postfix located in the same box? If not, adjust the line below accordingly.

host = localhost

6:07 am
May 28, 2010


krishna

Member

posts 8

Hi,

 

      Thanks for your reply i changed the code  it's working fine but iam having one more problem iam not able send a mail from virtual domain and i am not able to recive a mails i am not register a domain i want to use this server as a intranet mail server please help me.

 

Note: i can able to login through SquirrelMail  user@example.com and user@example1.com

but i cont able to send a mail from example1 to example domains please help me

 

Thaks in advance

 

Regards

Krishna.

 

 

1:00 pm
May 28, 2010


consultant

Admin

posts 341

Please post your postfix configuration using the command below

postconf -n

12:59 am
May 29, 2010


krishna

Member

posts 8

 

 

Hi,

 

Thanks for your reply this is my postfix configuration

 

[root@krish ~]# postconf -n
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/libexec/postfix
debug_peer_level = 2
home_mailbox = Maildir/
html_directory = no
inet_interfaces = localhost
mail_owner = postfix
mailq_path = /usr/bin/mailq.postfix
manpage_directory = /usr/share/man
mydestination = $myhostname, localhost.$mydomain, localhost
mynetworks = 192.9.100.86/24, 127.0.0.0/8
newaliases_path = /usr/bin/newaliases.postfix
queue_directory = /var/spool/postfix
readme_directory = /usr/share/doc/postfix-2.3.3/README_FILES  

  virtual_mailbox_domains = mysql:/etc/postfix/mysql-domains.cf       

virtual_mailbox_maps = mysql:/etc/postfix/mysql-users.cf       

virtual_alias_maps = mysql:/etc/postfix/mysql-aliases.cf       

virtual_mailbox_base = /home/vmail
sample_directory = /usr/share/doc/postfix-2.3.3/samples
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
smtpd_recipient_restrictions = permit_mynetworks,     permit_sasl_authenticated, reject_unauth_destination   broken_sasl_auth_clients = yes
smtpd_sasl_auth_enable = yes
smtpd_sasl_path = private/auth
smtpd_sasl_type = dovecot
unknown_local_recipient_reject_code = 550
virtual_uid_maps = static:501       virtual_gid_maps = static:501

 

please help me, thanks in advance.

 

Regards

Krishna.

 

 

1:02 am
May 29, 2010


krishna

Member

posts 8

this is the dovecot configuration

 

[root@krish ~]# dovecot -n
# 1.0.7: /etc/dovecot.conf
login_dir: /var/run/dovecot/login
login_executable(default): /usr/libexec/dovecot/imap-login
login_executable(imap): /usr/libexec/dovecot/imap-login
login_executable(pop3): /usr/libexec/dovecot/pop3-login
mail_location: maildir:~/Maildir
mail_executable(default): /usr/libexec/dovecot/imap
mail_executable(imap): /usr/libexec/dovecot/imap
mail_executable(pop3): /usr/libexec/dovecot/pop3
mail_plugin_dir(default): /usr/lib64/dovecot/imap
mail_plugin_dir(imap): /usr/lib64/dovecot/imap
mail_plugin_dir(pop3): /usr/lib64/dovecot/pop3
imap_client_workarounds(default): delay-newmail outlook-idle netscape-eoh
imap_client_workarounds(imap): delay-newmail outlook-idle netscape-eoh
imap_client_workarounds(pop3): outlook-idle
pop3_client_workarounds(default):
pop3_client_workarounds(imap):
pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
auth default:
  username_format: %Lu
  passdb:
    driver: pam
  passdb:
    driver: sql
    args: /etc/dovecot-mysql.conf
  userdb:
    driver: passwd
  userdb:
    driver: static
    args: uid=501 gid=501 home=/home/vmail/%d/%n

Regards,

Krishna.

8:23 am
May 29, 2010


consultant

Admin

posts 341

I'm assuming example.com and example1.com belongs to the same mail
server. Your configuration looks fine. Please check the /var/log/maillog.

8:37 am
June 1, 2010


krishna

Member

posts 8

thanks for your reply yes this two domains are in same domain only

I dont know were i did a mistake please help me

plese send a configuration how to configure a internal mails server with multiple domains with out  registaration of domain name and with out MX record.

 

 

Regards

Krishna.

9:28 pm
June 1, 2010


consultant

Admin

posts 341

Since the domain map is not working, try to manually specify it instead.

 

virtual_mailbox_domains = example.com, example1.com

3:43 am
June 9, 2010


krishna

Member

posts 8

Solved

 

   Thanks for your help i configured like this Code it's working fine and i want to know why it's not working through

 

MYSQL

 

 

Regards

Krishna.

4:12 am
June 9, 2010


consultant

Admin

posts 341

That's because there is something wrong with your /etc/postfix/mysql-domains.cf. The test below should work first to be able to use mysql.

postmap -q acme.com mysql:/etc/postfix/mysql-domains.cf

Since you were able to get the other mysql maps working, try to check what the configuration looks like on the working maps.

Reply to Post

Reply to Topic:
Mail Server with MYSQL Postfic

Guest Name (Required):

Guest Email (Required):

Smileys
Confused Cool Cry Embarassed Frown Kiss Laugh Smile Surprised Wink Yell
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
3 + 2
   


About the Linux Mail Server Setup and Howto Guide Forum

Forum Timezone: America/New_York

Most Users Ever Online: 60

Currently Online:
15 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 2
Forums: 5
Topics: 326
Posts: 1012

Membership:

There are 928 Members
There have been 84 Guests

There is 1 Admin

Top Posters:

shanmugasundaram s – 45
Kendermin – 15
Ginger – 14
bighorn – 14
iron_michael86 – 12
Raminda – 11

Recent New Members: RaHuL, bikesh, pappy_says, geos, boudi7, dara.hr

Administrators: consultant (341 Posts)