View Single Post
  #6  
Old 30th August 2009, 18:13
shayster01 shayster01 is offline
Member
 
Join Date: Jun 2007
Posts: 45
Thanks: 0
Thanked 1 Time in 1 Post
Default

Falko, I followed the same instructions. At what point did it create a table in the DB for the users? If so what is the DB name and table name? I can bring up the squirrelmail page but none of the username and passwords work. I found the following DBs:

information_schema
mysql
dbispconfig


Here is my netstat:

netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost:10024 *:* LISTEN 1970/amavisd (maste
tcp 0 0 localhost:10025 *:* LISTEN 2617/master
tcp 0 0 *:mysql *:* LISTEN 2034/mysqld
tcp 0 0 localhost:719 *:* LISTEN 2663/famd
tcp 0 0 localhost:spamd *:* LISTEN 2101/spamd.pid
tcp 0 0 *:sunrpc *:* LISTEN 1725/portmap
tcp 0 0 *:ftp *:* LISTEN 24538/pure-ftpd (SE
tcp 0 0 www.MYDOMAIN.co:domain *:* LISTEN 2544/mydns
tcp 0 0 localhost:domain *:* LISTEN 2544/mydns
tcp 0 0 *:ssh *:* LISTEN 1942/sshd
tcp 0 0 *:smtp *:* LISTEN 2617/master
tcp 0 0 *:56351 *:* LISTEN 1736/rpc.statd
tcp 0 288 www.MYDOMAIN.com:ssh c-71-198-105-199.:49209 ESTABLISHED 9496/sshd: shawn [p
tcp 0 0 www.MYDOMAIN.com:mysql 173-11-82-156-SFBA:1305 ESTABLISHED 2034/mysqld
tcp 54 0 localhost:54738 localhost:10025 CLOSE_WAIT 2098/amavisd (ch1-a
tcp 0 0 localhost:45956 localhost:mysql ESTABLISHED 2098/amavisd (ch1-a
tcp 0 0 localhost:mysql localhost:45956 ESTABLISHED 2034/mysqld
tcp6 0 0 [::]:imaps [::]:* LISTEN 2521/couriertcpd
tcp6 0 0 [::]op3s [::]:* LISTEN 2539/couriertcpd
tcp6 0 0 [::]op3 [::]:* LISTEN 2527/couriertcpd
tcp6 0 0 [::]:imap2 [::]:* LISTEN 2509/couriertcpd
tcp6 0 0 [::]:http-alt [::]:* LISTEN 2722/apache2
tcp6 0 0 [::]:www [::]:* LISTEN 2722/apache2
tcp6 0 0 [::]:ftp [::]:* LISTEN 24538/pure-ftpd (SE
tcp6 0 0 ip6-localhost:domain [::]:* LISTEN 2544/mydns
tcp6 0 0 [::]:ssh [::]:* LISTEN 1942/sshd
tcp6 0 0 [::]:https [::]:* LISTEN 2722/apache2




main.cnf

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

readme_directory = /usr/share/doc/postfix

# TLS parameters
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = yes
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache

# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.

myhostname = www.DOMAINNAME.com
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = DOMAINNAME.com, localhost, localhost.localdomain
relayhost =
mynetworks = 127.0.0.0/8
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
html_directory = /usr/share/doc/postfix/html
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /var/vmail
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_sasl_authenticated_header = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, reject_unauth_destination
smtpd_tls_security_level = may
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf
virtual_create_maildirsize = yes
virtual_maildir_extended = yes
virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = "The user you are trying to reach is over quota."
virtual_overquota_bounce = yes
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf
smtpd_client_restrictions = check_client_access mysql:/etc/postfix/mysql-virtual_client.cf
maildrop_destination_concurrency_limit = 1
maildrop_destination_recipient_limit = 1
virtual_transport = maildrop
header_checks = regexp:/etc/postfix/header_checks
mime_header_checks = regexp:/etc/postfix/mime_header_checks
nested_header_checks = regexp:/etc/postfix/nested_header_checks
body_checks = regexp:/etc/postfix/body_checks
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings

Last edited by shayster01; 30th August 2009 at 18:18.
Reply With Quote