HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   MySQL Error (http://www.howtoforge.com/forums/showthread.php?t=51421)

Nolan 14th February 2011 00:06

MySQL Error
 
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 Code:

$this->linkId mysql_connect($this->dbHost$this->dbUser$this->dbPass); 

Here is the information line 72 calls for:
PHP Code:

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.

till 14th February 2011 11:08

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.

Nolan 14th February 2011 21:52

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

till 14th February 2011 22:19

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.

Nolan 14th February 2011 22:30

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

Nolan 14th February 2011 22:59

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

Nolan 14th February 2011 23:13

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

Nolan 15th February 2011 06:54

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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): Disconnected: Logged out
Feb 14 22:30:43 ct18376 dovecot: IMAP(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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(nolan@wnolfm.com): 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! :)

falko 15th February 2011 15:52

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

Nolan 15th February 2011 20:48

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


All times are GMT +2. The time now is 22:54.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.