http://diymacserver.com/forum/ DIYMacServer: Forum: Postfix - Recent Posts en Fri, 30 Jul 2010 05:38:22 +0000 http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-832 Mon, 07 Jun 2010 23:41:17 +0000 Fred Turner 832@http://diymacserver.com/forum/ <p>Okay, seem to be making progress, although I can't say w/ 100% certainty that I know what the fix was. I went into the 3 mysql_virtual files and changed the "hosts" line from:</p> <p><code>hosts = 127.0.0.1</code></p> <p>as the instructions say, to:</p> <p><code>hosts = localhost</code></p> <p>No idea why that would make a difference-- they should be one and the same. However, things seem to work now w/o the error, and mail gets delivered properly. Would still be interested to hear your thoughts.</p> <p>Now on to the next problem! :-D</p> <p>Thx,<br /> Fred </p> http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-831 Mon, 07 Jun 2010 21:01:00 +0000 Fred Turner 831@http://diymacserver.com/forum/ <p>Can you think of *any* reason why lookups from postfix to mysql would be failing? It seems to me that the critical log entries are:</p> <pre><code>postfix/trivial-rewrite[809]: warning: connect to mysql server 127.0.0.1: Can&#39;t connect to MySQL server on &#39;127.0.0.1&#39; (61) postfix/trivial-rewrite[809]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem</code></pre> <p>Is it something to do w/ the virtual alias maps file? </p> http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-830 Mon, 07 Jun 2010 15:54:14 +0000 Fred Turner 830@http://diymacserver.com/forum/ <p>Thanks, Richard, but I don't have the foggiest idea how to use that. I tried running it on "ib_logfile0" and "ib_logfile1", but only got the following output:</p> <pre><code>Warning: is opened with same process and filenumber Maybe you should use the -P option ?</code></pre> <p>I guess it's a sign you should throw in the towel and do something else when you're not even able to see the logs to tell you what might be going wrong... </p> http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-829 Fri, 04 Jun 2010 19:47:38 +0000 richard 829@http://diymacserver.com/forum/ <p>Think you need to use something like this: <a href="http://dev.mysql.com/doc/refman/5.1/en/myisamlog.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.1/en/myisamlog.html</a> </p> http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-828 Fri, 04 Jun 2010 14:31:37 +0000 Fred Turner 828@http://diymacserver.com/forum/ <p>Okay, I must be dense...what do I need to use to view these logs? Tried 'tail' and I got mostly gibberish over the screen!</p> <p>Thx,<br /> Fred </p> http://diymacserver.com/forum/topic/temporary-lookup-failure#post-827 Tue, 01 Jun 2010 15:09:48 +0000 LarryL 827@http://diymacserver.com/forum/ <p>I've implemented a catchall address to accept all the junk and throw it away hourly. </p> http://diymacserver.com/forum/topic/temporary-lookup-failure#post-825 Mon, 31 May 2010 14:05:45 +0000 richard 825@http://diymacserver.com/forum/ <p>Larry, I have no clue to be honest. Every now and then I clear the queue manually of these things. Has nothing to do with Dovecot, this is postfix realted. </p> http://diymacserver.com/forum/topic/temporary-lookup-failure#post-824 Mon, 24 May 2010 21:55:08 +0000 LarryL 824@http://diymacserver.com/forum/ <p>Hey Richard,</p> <p>I just switched from your Courier setup to the Dovecot setup. I started getting messages like this:</p> <blockquote><p>May 24 16:18:17 autoreply postfix/smtpd[9133]: NOQUEUE: reject: RCPT from itspmx3.zzz.ms.us[999.12.20.50]: 451 4.<br /> 3.0 &lt;bwcassoc.comchad.allen@peer.zzz.ms.us&gt;: Temporary lookup failure; from=&lt;djackson@cvm.tamu.edu&gt; to=&lt;bwcassoc<br /> <a href="mailto:.comchad.allen@peer.zzz.ms.us&gt;">.comchad.allen@peer.zzz.ms.us&gt;</a> proto=ESMTP helo=&lt;itspmx3.zzz.ms.us&gt;</p></blockquote> <p>for each bad address. How can I change the temporary failure to a permanent failure? </p> http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-819 Thu, 13 May 2010 20:24:06 +0000 richard 819@http://diymacserver.com/forum/ <p>They are in /usr/local/mysql/data/ you'll need root access to read them.</p> <p>Are the files readable for postfix.</p> <p>notifications are not yet possible, I need to upgrade the software of the forum to do that. But don't despair Im working on it... </p> http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-818 Thu, 13 May 2010 15:48:43 +0000 Fred Turner 818@http://diymacserver.com/forum/ <p>Uh oh...if you've never seen this, then I'm probably screwed! If you think of anything I can test or check out, I'm all ears. Seems to me like somehow postfix is unable to access info in the auxiliary virtual files. Dumb question: where are the MySQL-specific logs in our DIY installation?</p> <p>Thx,<br /> FT</p> <p>P.S. Is there any way to subscribe to threads here for instant email notification? </p> http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-817 Wed, 12 May 2010 09:27:59 +0000 richard 817@http://diymacserver.com/forum/ <p>I've never seen this error before. I would have to try some stuff to really pinpoint the cause of this. But I'm currently don't have access to a Mac, perhaps later... </p> http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-816 Tue, 11 May 2010 17:40:55 +0000 Fred Turner 816@http://diymacserver.com/forum/ <p>Had everything pretty close to running, aside from the "createmaildir" script not working, but after a reboot of the server, I get this over and over in the logs:</p> <p>postfix/trivial-rewrite[809]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (61)<br /> postfix/trivial-rewrite[809]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem<br /> postfix/smtpd[479]: warning: problem talking to service rewrite: Unknown error: 0<br /> postfix/master[31]: warning: process /usr/libexec/postfix/trivial-rewrite pid 809 exit status 1<br /> postfix/master[31]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling</p> <p>Any idea why it can't connect? I'm assuming that the "table lookup problem" is simply the first mysql lookup that postfix does, and since it is unable to connect, that fails w/ the "lookup problem"...right? I manually ran mysql and connected as user "postfix" w/o issue.</p> <p>Thx,<br /> Fred </p> http://diymacserver.com/forum/topic/log-rotation-too-fasttoo-much-logging#post-779 Tue, 16 Feb 2010 20:43:54 +0000 richard 779@http://diymacserver.com/forum/ <p>For postfix in /etc/postfix/main.cf set debug_peer_level = 0 to keep only the essential stuff. </p> <p>For courier-auth set DEBUG_LOGIN=0</p> <p>This should cut down the logging information. </p> http://diymacserver.com/forum/topic/log-rotation-too-fasttoo-much-logging#post-778 Mon, 15 Feb 2010 06:37:55 +0000 Michael 778@http://diymacserver.com/forum/ <p>thanks, I increased the size of my logfile before rotation. We'll see if that helps. </p> <p>I can see how to increase the log level in postfix for specific domains, but not how to limit it, generally. I have the old (courier+postfix) setup. </p> http://diymacserver.com/forum/topic/log-rotation-too-fasttoo-much-logging#post-775 Sat, 13 Feb 2010 20:47:47 +0000 richard 775@http://diymacserver.com/forum/ <p>To change the logging preferences you need to edit the file /etc/newsyslog.conf</p> <p>You might also change the debug level in postfix to help. </p>