View Single Post
  #3  
Old 1st September 2009, 00:23
Al1937 Al1937 is offline
Member
 
Join Date: Jun 2009
Posts: 89
Thanks: 7
Thanked 0 Times in 0 Posts
Default

/var/log/mail.log

I get prmission denied.

I am logged in as
root@www:/home/albert#
Am I not logged in as root?

Where did I screw up?
-------------------------------------------------------
vi /usr/local/sbin/quota_notify
I edited
my @POSTMASTERS = ('postmaster@bingftp.tld');
my $COADDR = 'postmaster@bingftp.tld';
my $SUADDR = 'postmaster@bingftp.tld';
-------------------------------------------------------

I adjusted excactly in vi config.php


$csp_dsn = 'mysql://mail_admin:mail_admin_password@localhost/mail';

$lookup_password_query = 'SELECT count(*) FROM users WHERE email = "%1" AND password = %4';

$password_update_queries = array('UPDATE users SET password = %4 WHERE email = "%1"');

$password_encryption = 'MYSQLENCRYPT';

$csp_salt_static = 'LEFT(password, 2)';

//$csp_salt_query = 'SELECT salt FROM users WHERE username = "%1"';

$csp_delimiter = '@';
-------------------------------------------------------------------
Next we do some Postfix configuration. Go sure that you replace server1.example.com with a valid FQDN, otherwise your Postfix might not work properly!

postconf -e 'myhostname = www.bingftp.com'
postconf -e 'mydestination = www.bingftp.com, localhost, localhost.localdomain'
-----------------------------------------------------------------------

cd /etc/postfix
openssl req -new -outform PEM -out smtpd.cert -newkey rsa:2048 -nodes -keyout smtpd.key -keyform PEM -days 365 -x509

Email Address []: postmaster@bingftp.com
------------------------------------------------------------------------


vi /etc/courier/authmysqlrc

I added these lines excactly.
Should I have change mail_admin_password to my real password?
Should I ahve changed to 2 occurences of password to my real password?

MYSQL_SERVER localhost
MYSQL_USERNAME mail_admin
MYSQL_PASSWORD mail_admin_password
MYSQL_PORT 0
MYSQL_DATABASE mail
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
#MYSQL_CLEAR_PWFIELD password
MYSQL_UID_FIELD 5000
MYSQL_GID_FIELD 5000
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD "/home/vmail"
MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
#MYSQL_NAME_FIELD
-----------------------------------------------------------------------


vi /etc/aliases
Was edited as:

postmaster: root
root: postmaster@bingftp.tld
-----------------------------------------------------------------------
root@www:/home/albert# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5241
Server version: 5.0.75-0ubuntu10.2 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'my real password';
GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost.localdomain' IDENTIFIED BY 'my real password';
FLUSH PRIVILEGES;
------------------------------------------------------------------------

This is all the info I think may pertain to my problem.
I hope it helps.
Reply With Quote