Virtual mail

Discussion in 'Server Operation' started by satimis, Jun 9, 2007.

  1. satimis

    satimis New Member

    Hi folks,

    OpenBSD4.0 amd64
    Postfix_2.4.3
    Mysql
    $ mysql --version
    mysql Ver 14.12 Distrib 5.0.24a, for unknown-openbsd4.0 (x86_64) using readline 4.3

    On running
    $ mysql -u vmailuser -p password123
    Enter password:
    ERROR 1045 (28000): Access denied for user 'vmailuser'@'localhost'
    (using password: YES)

    The password is correct found on ;
    /etc/postfix/mysql-aliases.cf
    /etc/postfix/mysql-client.cf
    /etc/postfix/mysql-recipient.cf
    /etc/postfix/mysql-relocated.cf
    /etc/postfix/mysql-sender.cf
    /etc/postfix/mysql-transport.cf
    /etc/postfix/mysql-domains.cf
    /etc/postfix/mysql-virtual-maps.cf
    /etc/postfix/mysql-virtual.cf
    etc.

    Please help. TIA


    B.R.
    satimis
     
  2. falko

    falko Super Moderator ISPConfig Developer

    You must either use
    Code:
    mysql -u vmailuser -p
    and then type in your ppassword, or

    Code:
    mysql -u vmailuser -ppassword123
    (no space between -p and password123!)
     
  3. satimis

    satimis New Member

    Hi falko,

    $ mysql -u vmailuser -p
    Enter password: (typed ppassword123)
    Code:
    ERROR 1045 (28000): Access denied for user 'vmailuser'@'localhost' (using password: YES)
    
    The password "password123" is correct


    Tried again;

    $ su
    Password:
    # su - _vmail

    $ mysql -u vmailuser -ppassword123
    Code:
    ERROR 1045 (28000): Access denied for user 'vmailuser'@'localhost' (using password: YES)
    
    Same situation


    satimis
     
  4. falko

    falko Super Moderator ISPConfig Developer

    Then the password is wrong, or there is no MySQL user called vmailuser.
    If you have phpMyAdmin installed, you can use it to set a new password.
     
  5. satimis

    satimis New Member

    The password is there.
    $ sudo ls -l /etc/postfix | grep mysql_*cf
    Code:
                                  
    -rw-r-----  1 root  _postfix    142 May 25 15:59 mysql-aliases.cf
    -rw-r-----  1 root  _postfix    183 May 25 16:05 mysql-client.cf
    -rw-r-----  1 root  wheel       153 May 25 16:16 mysql-domains.cf
    -rw-r--r--  1 root  _postfix    194 May 25 16:09 mysql-recipient.cf
    -rw-r-----  1 root  _postfix    146 May 25 16:11 mysql-relocated.cf
    -rw-r-----  1 root  _postfix    183 May 25 16:13 mysql-sender.cf
    -rw-r-----  1 root  _postfix    147 May 25 16:14 mysql-transport.cf
    -rw-r-----  1 root  _postfix    180 May 25 16:19 mysql-virtual-maps.cf
    -rw-r-----  1 root  _postfix    144 May 25 16:21 mysql-virtual.cf
    
    $ sudo cat /etc/postfix/mysql-aliases.cf
    Code:
                                   
    user = vmailuser
    password = password123
    dbname = mail
    table = postfix_alias
    select_field = destination
    where_field = alias
    hosts = localhost
    
    $ sudo cat /etc/postfix/mysql-client.cf
    Code:
    user = vmailuser
    password = password123
    dbname = mail
    table = postfix_access
    select_field = access
    where_field = source
    additional_conditions = and type = 'client'
    hosts = localhost
    
    $ sudo cat /etc/postfix/mysql-domains.cf
    Code:
                                     
    user = vmailuser
    password = password123
    dbname = mail
    table = postfix_virtual_domains
    select_field = destination
    where_field = domain
    hosts = localhost
    
    do cat /etc/postfix/mysql-recipient.cf
    Code:
    user = vmailuser
    password = password123
    dbname = mail
    table = postfix_access
    select_field = access
    where_field = source
    additional_conditions = and type = 'recipient'
    hosts = localhost
    
    $ sudo cat /etc/postfix/mysql-relocated.cf
    Code:
                                      
    user = vmailuser
    password = password123
    dbname = mail
    table = postfix_relocated
    select_field = destination
    where_field = email
    hosts = localhost
    
    $ sudo cat /etc/postfix/mysql-sender.cf
    Code:
    user = vmailuser
    password = password123
    dbname = mail
    table = postfix_access
    select_field = access
    where_field = source
    additional_conditions = and type = 'sender'
    hosts = localhost
    
    $ sudo cat /etc/postfix/mysql-transport.cf
    Code:
    user = vmailuser
    password = password123
    dbname = mail
    table = postfix_transport
    select_field = destination
    where_field = domain
    hosts = localhost
    
    $ sudo cat /etc/postfix/mysql-virtual-maps.cf
    Code:
    user = vmailuser
    password = password123
    dbname = mail
    table = postfix_users
    select_field = maildir
    where_field = email
    additional_conditions = and postfix = 'y'
    hosts = localhost
    
    $ sudo cat /etc/postfix/mysql-virtual-maps.cf
    Code:
    user = vmailuser
    password = password123
    dbname = mail
    table = postfix_users
    select_field = maildir
    where_field = email
    additional_conditions = and postfix = 'y'
    hosts = localhost
    
    $ sudo cat /etc/postfix/mysql-virtual.cf
    Code:
        
    user = vmailuser
    password = password123
    dbname = mail
    table = postfix_virtual
    select_field = destination
    where_field = email
    hosts = localhost
    

    $ which phpmyadmin
    Code:
                     
    phpmyadmin: Command not found.
    $ which phpMyAdmin
    Code:
    phpMyAdmin: Command not found.
    $ sudo pkg_info phpmyadmin
    Password:
    Code:
    Error from ftp://ftp.it.net.au/mirrors/OpenBSD/4.0/packages/amd64/:
    550 phpmyadmin.tgz: No such file or directory
    
    $ sudo pkg_info phpMyAdmin
    Code:
    Error from ftp://ftp.it.net.au/mirrors/OpenBSD/4.0/packages/amd64/:
    550 phpMyAdmin.tgz: No such file or directory
    
    Can't be found on port


    B.R.
    satimis
     
  6. falko

    falko Super Moderator ISPConfig Developer

Share This Page