MySQL Error

Discussion in 'Installation/Configuration' started by Nolan, Feb 13, 2011.

  1. Nolan

    Nolan Member

    Hi, I had to reinstall my OS because of a failed upgrade to Debian 6.

    I'm back on Debian 5 again, and I just dragged the contents of my old database folder (/var/lib/mysql) into the new database folder, and I changed the root password back to what it was on the old server. However, I'm getting this error:


    Code:
    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 72
    Here is line 72:
    PHP:
    $this->linkId mysql_connect($this->dbHost$this->dbUser$this->dbPass);
    Here is the information line 72 calls for:
    PHP:
    private $dbHost '';           // hostname of the MySQL server
        
    private $dbName '';           // logical database name on that server
        
    private $dbUser '';           // database authorized user
        
    private $dbPass '';           // user's password
        
    private $dbCharset '';       // what charset comes and goes to mysql: utf8 / latin1
        
    private $linkId 0;           // last result of mysql_connect()
        
    private $queryId 0;           // last result of mysql_query()
        
    private $record    = array();       // last record fetched
        
    private $autoCommit 1;        // Autocommit Transactions
        
    private $currentRow;           // current row number
        
    private $errorNumber 0;       // last error number
        
    public $errorMessage '';       // last error message
        
    private $errorLocation '';   // last error location
        
    public $show_error_messages false;
    I'm not sure if the code is supposed to be ' ' or not, I haven't ever looked on a regular installation.
    I tried filling in my database information in those fields but it still didn't work.
     
    Last edited: Feb 14, 2011
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The code is absolutely ok of course. Please undo all changes that you made to the code.

    Back to your original problem, by copying back the databases you have overwritten the password of the ispconfig user. This password has to be corrected in the mysql database and not the ispconfig files. Did you make a backup of the mysql.mysql database which conatins the users on the new system before youve obvewritten the db with the old database? If yes, then take this backup and get the password lines for the ispconfig users from it from all tables that are in the database and add them to the current mysql user database.
     
  3. Nolan

    Nolan Member

    No, I didn't save a copy of the new users. However the only users created on the new installation of ISPconfig was the admin account, nothing else.
    I didn't set up any other accounts or begin to add a website on the new installation. All I did was change the admin password on the new installation from the default password of admin
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    I'am not atlking about ispconfig users, I talk about mysql users. The ispconfig installer creates a mysql database user name ispconfig and I guess that you have overwritten this user by copying back the old mysql database. The problem that this causes now is that neither the ispconfig nor services like postfix, pure-ftpd or dovecot / courier can connect to mysql anymore.

    Please open the file /usr/local/ispconfig/server/lib/config.inc.php, in this file you find a mysql password. This is the cleartext password of the mysql user. Copy this password (do not chnage it in that file!), then open the mysql database with the name "mysql", find the user table in that database, there you will find a user named "ispconfig". Change the password for that mysql user to the password that you found in the config.inc.php file. Select "password" as encryption method. And then reload or restart the mysql database.
     
  5. Nolan

    Nolan Member

    Hi till, thanks for the response. How would I do this via command line?
     
  6. Nolan

    Nolan Member

    Never mind!
    I got it.

    Code:
    mysql -u root -p
    use mysql;
    mysql> update user set password=PASSWORD("NEWPASSWORD") where User='ispconfig';
    flush privileges;
    quit
    in this case.

    It's able to connect now :D
     
  7. Nolan

    Nolan Member

    I just wanted to double check, after changing the ISPConfig password, my services should all be able to start up again as before, right?
    I mean with the old DNS records, FTP users, etc.

    EDIT: When I go to my site, it tries to load /var/www/ rather than /var/www/clients/client1/web2/
    How do I fix this?

    EDIT 2: Problem Fixed. all I did was disable the site, then enable it again.

    Thanks,

    Nolan
     
    Last edited: Feb 15, 2011
  8. Nolan

    Nolan Member

    Sorry for all the posts in a row. I'm having issues with my email, everything else appears to be functioning correctly :)

    Here is the mail-warn - log:
    Code:
    Feb 14 14:39:28 ct18376 postfix/proxymap[57285]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:39:28 ct18376 postfix/proxymap[57285]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:39:28 ct18376 postfix/trivial-rewrite[57284]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:39:29 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 57284 exit status 1
    Feb 14 14:39:29 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:39:29 ct18376 postfix/qmgr[51154]: warning: problem talking to service rewrite: Success
    Feb 14 14:40:29 ct18376 postfix/proxymap[58598]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:40:29 ct18376 postfix/proxymap[58598]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:40:29 ct18376 postfix/trivial-rewrite[58597]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:40:30 ct18376 postfix/qmgr[51154]: warning: problem talking to service rewrite: Success
    Feb 14 14:40:30 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 58597 exit status 1
    Feb 14 14:40:30 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:41:30 ct18376 postfix/proxymap[58820]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:41:30 ct18376 postfix/proxymap[58820]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:41:30 ct18376 postfix/trivial-rewrite[58819]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:41:31 ct18376 postfix/qmgr[51154]: warning: problem talking to service rewrite: Success
    Feb 14 14:41:31 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 58819 exit status 1
    Feb 14 14:41:31 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:42:29 ct18376 postfix/qmgr[51154]: fatal: watchdog timeout
    Feb 14 14:42:30 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/qmgr pid 51154 exit status 1
    Feb 14 14:42:30 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Feb 14 14:42:31 ct18376 postfix/proxymap[59114]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:42:31 ct18376 postfix/proxymap[59114]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:42:31 ct18376 postfix/trivial-rewrite[59112]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:42:32 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 59112 exit status 1
    Feb 14 14:42:32 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:43:32 ct18376 postfix/proxymap[59188]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:43:32 ct18376 postfix/proxymap[59188]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:43:32 ct18376 postfix/trivial-rewrite[59187]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:43:33 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 59187 exit status 1
    Feb 14 14:43:33 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:44:33 ct18376 postfix/proxymap[59227]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:44:33 ct18376 postfix/proxymap[59227]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:44:33 ct18376 postfix/trivial-rewrite[59226]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:44:34 ct18376 postfix/qmgr[59170]: warning: problem talking to service rewrite: Success
    Feb 14 14:44:34 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 59226 exit status 1
    Feb 14 14:44:34 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:45:34 ct18376 postfix/proxymap[60755]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:45:34 ct18376 postfix/proxymap[60755]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:45:34 ct18376 postfix/trivial-rewrite[60754]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:45:35 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 60754 exit status 1
    Feb 14 14:45:35 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:45:35 ct18376 postfix/qmgr[59170]: warning: problem talking to service rewrite: Success
    Feb 14 14:46:35 ct18376 postfix/proxymap[60970]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:46:35 ct18376 postfix/proxymap[60970]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:46:35 ct18376 postfix/trivial-rewrite[60969]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:46:36 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 60969 exit status 1
    Feb 14 14:46:36 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:46:36 ct18376 postfix/qmgr[59170]: warning: problem talking to service rewrite: Success
    Feb 14 14:47:36 ct18376 postfix/proxymap[61090]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:47:36 ct18376 postfix/proxymap[61090]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:47:36 ct18376 postfix/trivial-rewrite[61089]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:47:37 ct18376 postfix/qmgr[59170]: warning: problem talking to service rewrite: Success
    Feb 14 14:47:37 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 61089 exit status 1
    Feb 14 14:47:37 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:48:37 ct18376 postfix/proxymap[61415]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:48:37 ct18376 postfix/proxymap[61415]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:48:37 ct18376 postfix/trivial-rewrite[61414]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:48:38 ct18376 postfix/qmgr[59170]: warning: problem talking to service rewrite: Success
    Feb 14 14:48:38 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 61414 exit status 1
    Feb 14 14:48:38 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:49:38 ct18376 postfix/proxymap[62490]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:49:38 ct18376 postfix/proxymap[62490]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:49:38 ct18376 postfix/trivial-rewrite[62489]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:49:39 ct18376 postfix/qmgr[59170]: warning: problem talking to service rewrite: Interrupted system call
    Feb 14 14:49:39 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 62489 exit status 1
    Feb 14 14:49:39 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:50:39 ct18376 postfix/proxymap[62766]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:50:39 ct18376 postfix/proxymap[62766]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:50:39 ct18376 postfix/trivial-rewrite[62765]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:50:40 ct18376 postfix/qmgr[59170]: warning: problem talking to service rewrite: Success
    Feb 14 14:50:40 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 62765 exit status 1
    Feb 14 14:50:40 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:51:40 ct18376 postfix/proxymap[63220]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:51:40 ct18376 postfix/proxymap[63220]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:51:40 ct18376 postfix/trivial-rewrite[63219]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:51:41 ct18376 postfix/qmgr[59170]: warning: problem talking to service rewrite: Success
    Feb 14 14:51:41 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 63219 exit status 1
    Feb 14 14:51:41 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:52:41 ct18376 postfix/proxymap[63283]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:52:41 ct18376 postfix/proxymap[63283]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:52:41 ct18376 postfix/trivial-rewrite[63282]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:52:42 ct18376 postfix/qmgr[59170]: warning: problem talking to service rewrite: Success
    Feb 14 14:52:42 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 63282 exit status 1
    Feb 14 14:52:42 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:53:42 ct18376 postfix/proxymap[63422]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:53:42 ct18376 postfix/proxymap[63422]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Feb 14 14:53:42 ct18376 postfix/trivial-rewrite[63421]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb 14 14:53:43 ct18376 postfix/qmgr[59170]: warning: problem talking to service rewrite: Success
    Feb 14 14:53:43 ct18376 postfix/master[13522]: warning: process /usr/lib/postfix/trivial-rewrite pid 63421 exit status 1
    Feb 14 14:53:43 ct18376 postfix/master[13522]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Feb 14 14:54:52 ct18376 amavis[15425]: (15425-01) (!)FWD via SMTP: -> , 451 4.5.0 From MTA([127.0.0.1]:10025) during fwd-connect (Error reading from socket: Connection refused at (eval 84) line 158, line 58.): id=15425-01
    Feb 14 14:54:52 ct18376 amavis[15425]: (15425-01) (!!)TROUBLE in process_request: Error writing a SMTP response to the socket: Broken pipe at (eval 83) line 957, line 31.
    Feb 14 14:54:52 ct18376 amavis[15425]: (15425-01) (!)Requesting process rundown after fatal error
    Feb 14 14:55:15 ct18376 dovecot: Killed with signal 15
    Feb 14 15:01:41 ct18376 dovecot: Killed with signal 15
    Feb 14 15:17:21 ct18376 dovecot: Killed with signal 15
    Feb 14 15:59:21 ct18376 dovecot: Killed with signal 15
    Feb 14 18:54:46 ct18376 postfix/smtpd[7623]: warning: 113.167.111.57: address not listed for hostname localhost
    Feb 14 22:48:47 ct18376 dovecot: Killed with signal 15
    Here is the mail log
    Code:
    Feb 14 22:30:01 ct18376 dovecot: pop3-login: Disconnected: rip=127.0.0.1, lip=127.0.0.1, secured
    Feb 14 22:30:01 ct18376 postfix/smtpd[63368]: connect from localhost.localdomain[127.0.0.1]
    Feb 14 22:30:01 ct18376 postfix/smtpd[63368]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
    Feb 14 22:30:01 ct18376 postfix/smtpd[63368]: disconnect from localhost.localdomain[127.0.0.1]
    Feb 14 22:30:22 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:30:22 ct18376 postfix/smtpd[63368]: connect from ct18376[208.53.183.76]
    Feb 14 22:30:22 ct18376 postfix/anvil[61359]: statistics: max connection rate 3/60s for (smtp:208.53.183.76) at Feb 14 22:27:02
    Feb 14 22:30:22 ct18376 postfix/anvil[61359]: statistics: max connection count 1 for (smtp:208.53.183.76) at Feb 14 22:26:09
    Feb 14 22:30:22 ct18376 postfix/anvil[61359]: statistics: max cache size 1 at Feb 14 22:26:09
    Feb 14 22:30:22 ct18376 postfix/smtpd[63368]: NOQUEUE: reject: RCPT from ct18376[208.53.183.76]: 554 5.7.1 : Relay access denied; from= to= proto=ESMTP helo=
    Feb 14 22:30:22 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:30:22 ct18376 postfix/smtpd[63368]: disconnect from ct18376[208.53.183.76]
    Feb 14 22:30:31 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:30:31 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:30:42 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:30:42 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:30:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:30:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:30:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:30:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:31:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:31:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:32:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:32:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:33:42 ct18376 postfix/anvil[64604]: statistics: max connection rate 1/60s for (smtp:208.53.183.76) at Feb 14 22:30:22
    Feb 14 22:33:42 ct18376 postfix/anvil[64604]: statistics: max connection count 1 for (smtp:208.53.183.76) at Feb 14 22:30:22
    Feb 14 22:33:42 ct18376 postfix/anvil[64604]: statistics: max cache size 1 at Feb 14 22:30:22
    Feb 14 22:33:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:33:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:34:10 ct18376 postfix/qmgr[48132]: C45BE11F44486: from=, size=11782, nrcpt=1 (queue active)
    Feb 14 22:34:10 ct18376 postfix/qmgr[48132]: E6AA011F44487: from=, size=2804, nrcpt=1 (queue active)
    Feb 14 22:34:10 ct18376 postfix/qmgr[48132]: 6596A11F44483: from=, size=3183, nrcpt=1 (queue active)
    Feb 14 22:34:10 ct18376 postfix/smtp[65373]: connect to 127.0.0.1[127.0.0.1]:10024: Connection refused
    Feb 14 22:34:10 ct18376 postfix/smtp[65374]: connect to 127.0.0.1[127.0.0.1]:10024: Connection refused
    Feb 14 22:34:10 ct18376 postfix/smtp[65373]: C45BE11F44486: to=, relay=none, delay=8978, delays=8978/0.01/0/0, dsn=4.4.1, status=deferred (connect to 127.0.0.1[127.0.0.1]:10024: Connection refused)
    Feb 14 22:34:10 ct18376 postfix/smtp[65373]: connect to 127.0.0.1[127.0.0.1]:10024: Connection refused
    Feb 14 22:34:10 ct18376 postfix/smtp[65374]: E6AA011F44487: to=, relay=none, delay=944, delays=944/0.02/0/0, dsn=4.4.1, status=deferred (connect to 127.0.0.1[127.0.0.1]:10024: Connection refused)
    Feb 14 22:34:10 ct18376 postfix/smtp[65373]: 6596A11F44483: to=, relay=none, delay=13163, delays=13163/0.16/0.01/0, dsn=4.4.1, status=deferred (connect to 127.0.0.1[127.0.0.1]:10024: Connection refused)
    Feb 14 22:34:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:34:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:35:01 ct18376 dovecot: pop3-login: Disconnected: rip=127.0.0.1, lip=127.0.0.1, secured
    Feb 14 22:35:01 ct18376 dovecot: imap-login: Disconnected: rip=127.0.0.1, lip=127.0.0.1, secured
    Feb 14 22:35:01 ct18376 postfix/smtpd[65493]: connect from localhost.localdomain[127.0.0.1]
    Feb 14 22:35:01 ct18376 postfix/smtpd[65493]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
    Feb 14 22:35:01 ct18376 postfix/smtpd[65493]: disconnect from localhost.localdomain[127.0.0.1]
    Feb 14 22:35:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:35:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:36:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:36:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:37:30 ct18376 postfix/scache[65377]: statistics: start interval Feb 14 22:34:10
    Feb 14 22:37:30 ct18376 postfix/scache[65377]: statistics: domain lookup hits=0 miss=1 success=0%
    Feb 14 22:37:30 ct18376 postfix/scache[65377]: statistics: address lookup hits=0 miss=1 success=0%
    Feb 14 22:37:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:37:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:38:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:38:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:39:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:39:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:40:01 ct18376 dovecot: imap-login: Disconnected: rip=127.0.0.1, lip=127.0.0.1, secured
    Feb 14 22:40:01 ct18376 dovecot: pop3-login: Disconnected: rip=127.0.0.1, lip=127.0.0.1, secured
    Feb 14 22:40:01 ct18376 postfix/smtpd[3585]: connect from localhost.localdomain[127.0.0.1]
    Feb 14 22:40:01 ct18376 postfix/smtpd[3585]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
    Feb 14 22:40:01 ct18376 postfix/smtpd[3585]: disconnect from localhost.localdomain[127.0.0.1]
    Feb 14 22:40:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:40:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:41:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:41:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:42:43 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:42:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:43:37 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:43:37 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:43:38 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:43:38 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:43:40 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:43:40 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:43:40 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:43:40 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:43:42 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:43:42 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:43:42 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:43:43 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:43:53 ct18376 dovecot: imap-login: Login: user=, method=PLAIN, rip=208.53.183.76, lip=208.53.183.76, secured
    Feb 14 22:43:53 ct18376 postfix/smtpd[5479]: connect from ct18376[208.53.183.76]
    Feb 14 22:43:53 ct18376 postfix/smtpd[5479]: NOQUEUE: reject: RCPT from ct18376[208.53.183.76]: 554 5.7.1 : Relay access denied; from= to= proto=ESMTP helo=
    Feb 14 22:43:53 ct18376 dovecot: IMAP([email protected]): Disconnected: Logged out
    Feb 14 22:43:53 ct18376 postfix/smtpd[5479]: disconnect from ct18376[208.53.183.76]
    Feb 14 22:45:01 ct18376 postfix/smtpd[5479]: connect from localhost.localdomain[127.0.0.1]
    Feb 14 22:45:01 ct18376 postfix/smtpd[5479]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
    Feb 14 22:45:01 ct18376 postfix/smtpd[5479]: disconnect from localhost.localdomain[127.0.0.1]
    Feb 14 22:45:01 ct18376 dovecot: imap-login: Disconnected: rip=127.0.0.1, lip=127.0.0.1, secured
    Feb 14 22:45:01 ct18376 dovecot: pop3-login: Disconnected: rip=127.0.0.1, lip=127.0.0.1, secured
    Feb 14 22:47:29 ct18376 postfix/master[47100]: terminating on signal 15
    Feb 14 22:47:29 ct18376 postfix/master[7360]: daemon started -- version 2.5.5, configuration /etc/postfix
    Feb 14 22:47:55 ct18376 amavis[7550]: starting. /usr/sbin/amavisd-new at ct18376 amavisd-new-2.6.1 (20080629), Unicode aware
    Feb 14 22:47:55 ct18376 amavis[7550]: Perl version 5.010000
    Feb 14 22:48:47 ct18376 dovecot: Killed with signal 15
    Feb 14 22:48:47 ct18376 dovecot: Dovecot v1.0.15 starting up
    Feb 14 22:48:47 ct18376 dovecot: auth-worker(default): mysql: Connected to localhost (dbispconfig)
    Feb 14 22:50:01 ct18376 dovecot: imap-login: Disconnected: rip=127.0.0.1, lip=127.0.0.1, secured
    Feb 14 22:50:01 ct18376 dovecot: pop3-login: Disconnected: rip=127.0.0.1, lip=127.0.0.1, secured
    It seems that amavis does not start. although Im not sure why.
    Thanks for all the help so far! :)
     
  9. falko

    falko Super Moderator ISPConfig Developer

    It seems as if the MySQL login details in /etc/postfix/mysql-virtual_domains.cf are wrong.
     
  10. Nolan

    Nolan Member

    It wouldn't surprise me, the password for MySQL has changed
    I will have a look later.
     
  11. Nolan

    Nolan Member

    The password in /etc/postfix/mysql-virtual_domains.cf matches the password found in /usr/local/ispconfig/server/lib/config.inc.php

    What do you suppose is wrong now?

    EDIT: I'm able to receive emails in roundcube, but not able to send them out... Amavis is able to start now, I had to add the mail server in.

    Here is the Error I'm getting in roundcube when I try to email my yahoo account: SMTP Error (554): Failed to add recipient "[email protected]" (5.7.1 : Relay access denied)
     
    Last edited: Feb 15, 2011
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    Check your roundcube settings, the smtp server that is set in the roundcube must be "localhost" and the smtp username and password has to be empty as no authemtication is nescessary for localhost connections.
     
  13. Nolan

    Nolan Member

    Thanks! that worked :)
    All problems appear to be fixed.

    Thanks,

    Nolan
     
  14. isn

    isn New Member

    This is a good post.

    It assisted in my recovery from a boot disk failure.

    Most of the restore was mundane, installing ispconfig anew and restoring my detailed and often made backups.

    After all that restoring and a conversion to the Galera version of Mariadb I was seeing mysql login rejects in the logs for ispconfig@localhost

    This little procedure hooked me right up and got me operational.
     

Share This Page