Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 9th August 2010, 11:03
j.smith1981 j.smith1981 is offline
Member
 
Join Date: Nov 2008
Posts: 63
Thanks: 0
Thanked 3 Times in 3 Posts
Question How to problem regarding Virtual Domains with Postfix, Courier and MySQL etc - Fatal

Hi Everyone.

Having a bit of trouble with postfix and mysql support, here's the tutorial I have been following:

http://howtoforge.org/virtual-users-...os-4.8-i386-p2

Just cant seem to get around this log error with postfix supporting mysql, here's a copy of the direct log as it where, just the error itself, it is sending though via its own localhost, when the system sends an email to the root account, that is working, so it cant be not working, just lacking sql support with mysql.

Here's the copy of the log:

Quote:
Aug 9 09:55:13 centos48 authdaemond: stopping authdaemond children
Aug 9 09:55:13 centos48 authdaemond: modules="authmysql", daemons=5
Aug 9 09:55:13 centos48 authdaemond: Installing libauthmysql
Aug 9 09:55:13 centos48 authdaemond: Installation complete: authmysql
Aug 9 09:55:32 centos48 sendmail[956]: alias database /etc/aliases rebuilt by root
Aug 9 09:55:32 centos48 sendmail[956]: /etc/aliases: 80 aliases, longest 10 bytes, 830 bytes total
Aug 9 09:55:32 centos48 sendmail[961]: starting daemon (8.13.1): SMTP+queueing@01:00:00
Aug 9 09:55:32 centos48 sm-msp-queue[970]: starting daemon (8.13.1): queueing@01:00:00
Aug 9 09:55:33 centos48 sendmail[974]: o798tWMh000974: from=<root@centos48.hsmedia.co.uk>, size=6475, class=0, nrcpts=1, msgid=<201008080302.o78326a8019577@centos48.hsmedi a.co.uk>, proto=ESMTP, daemon=MTA, relay=localhost.localdomain [127.0.0.1]
Aug 9 09:55:33 centos48 sm-msp-queue[971]: o78326a8019577: to=root, ctladdr=root (0/0), delay=1+05:53:27, xdelay=00:00:01, mailer=relay, pri=126167, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (o798tWMh000974 Message accepted for delivery)
Aug 9 09:55:33 centos48 sendmail[974]: o798tWMj000974: from=<root@centos48.hsmedia.co.uk>, size=51442, class=0, nrcpts=1, msgid=<201008090302.o7932ABE017594@centos48.hsmedi a.co.uk>, proto=ESMTP, daemon=MTA, relay=localhost.localdomain [127.0.0.1]
Aug 9 09:55:33 centos48 sm-msp-queue[971]: o7932ABE017594: to=root, ctladdr=root (0/0), delay=05:53:23, xdelay=00:00:00, mailer=relay, pri=171134, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (o798tWMj000974 Message accepted for delivery)
Aug 9 09:55:33 centos48 sendmail[975]: o798tWMh000974: to=<root@centos48.hsmedia.co.uk>, ctladdr=<root@centos48.hsmedia.co.uk> (0/0), delay=00:00:00, xdelay=00:00:00, mailer=local, pri=36714, dsn=2.0.0, stat=Sent
Aug 9 09:55:33 centos48 sendmail[977]: o798tWMj000974: to=<root@centos48.hsmedia.co.uk>, ctladdr=<root@centos48.hsmedia.co.uk> (0/0), delay=00:00:00, xdelay=00:00:00, mailer=local, pri=81681, dsn=2.0.0, stat=Sent
Aug 9 09:55:43 centos48 sendmail[994]: alias database /etc/aliases rebuilt by root
Aug 9 09:55:43 centos48 sendmail[994]: /etc/aliases: 80 aliases, longest 10 bytes, 830 bytes total
Aug 9 09:55:44 centos48 postfix/postfix-script: starting the Postfix mail system
Aug 9 09:55:44 centos48 postfix/master[1040]: daemon started -- version 2.2.10, configuration /etc/postfix
Aug 9 09:56:17 centos48 postfix/proxymap[1072]: fatal: unsupported dictionary type: mysql
Aug 9 09:56:18 centos48 postfix/smtpd[1071]: warning: premature end-of-input on private/proxymap socket while reading input attribute name
Aug 9 09:56:18 centos48 postfix/smtpd[1071]: warning: private/proxymap socket: service dict_proxy_open: Success
Aug 9 09:56:18 centos48 postfix/master[1040]: warning: process /usr/libexec/postfix/proxymap pid 1072 exit status 1
Aug 9 09:56:19 centos48 postfix/proxymap[1074]: fatal: unsupported dictionary type: mysql
Aug 9 09:56:20 centos48 postfix/smtpd[1071]: warning: premature end-of-input on private/proxymap socket while reading input attribute name
Aug 9 09:56:20 centos48 postfix/smtpd[1071]: warning: private/proxymap socket: service dict_proxy_open: Success
Aug 9 09:56:20 centos48 postfix/master[1040]: warning: process /usr/libexec/postfix/proxymap pid 1074 exit status 1
Aug 9 09:56:20 centos48 postfix/master[1040]: warning: /usr/libexec/postfix/proxymap: bad command startup -- throttling
But I have already tried this installation again, I decided to switch back to my own config of my system, as ispconfig 2 just seems to suck up so much processing power at the moment, it has to be that system that caused the reason why Im switching to this.

Plus I prefer this system anyhow, so any suggestions on getting around this?

I have attempted a reinstall of postfix and its still causing this error, any helps appreciated,
Jeremy.

Last edited by j.smith1981; 9th August 2010 at 16:41. Reason: few spelling errors, woops, apologies!
Reply With Quote
Sponsored Links
  #2  
Old 10th August 2010, 10:20
j.smith1981 j.smith1981 is offline
Member
 
Join Date: Nov 2008
Posts: 63
Thanks: 0
Thanked 3 Times in 3 Posts
Lightbulb

Just though I'd reply and end this confusion lol.

I silly me forgot to set mysql to 1 in the *.spec file for postfix, its fine now though, much appreciate anyone looking into this for me.

Explains why no ones replied though, haha, no seriously much appreciated.

Cant believe I forgot that.

Thanks again,
Jeremy
Reply With Quote
The Following User Says Thank You to j.smith1981 For This Useful Post:
falko (10th August 2010)
  #3  
Old 25th August 2010, 11:03
j.smith1981 j.smith1981 is offline
Member
 
Join Date: Nov 2008
Posts: 63
Thanks: 0
Thanked 3 Times in 3 Posts
Question

I got it working perfectly apart from one little feature I would like to get working if you could step me through whats going wrong?

When I try to change my sqlpassword in squirrelmail, it comes up with the following message:

Quote:
ERROR:
Could not make database connection
That is not very descriptive over whats really happening so I went into my web servers logs and I found this error:

Quote:
[Wed Aug 25 09:55:45 2010] [error] [client REMOTE IP ADDRESS] PHP Notice: Undefined variable: charset in /usr/share/squirrelmail/functions/mime.php on line 317, referer: http://mysubdomain.domain.com/src/ri...&mailbox=INBOX
Any suggestions?
Reply With Quote
  #4  
Old 1st September 2010, 15:32
j.smith1981 j.smith1981 is offline
Member
 
Join Date: Nov 2008
Posts: 63
Thanks: 0
Thanked 3 Times in 3 Posts
 
Default

Does anyone know how to correct the above please?
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with quota? Virtual Users And Domains With Postfix, Courier, MySQL And Squirr liberty_nz HOWTO-Related Questions 5 3rd November 2009 01:25
Virtual Users And Domains With Postfix, Courier And MySQL - SASLauthd problem qtx HOWTO-Related Questions 7 22nd May 2007 18:19
Virtual Users And Domains With Postfix, Courier And MySQL wmrwl HOWTO-Related Questions 73 6th October 2006 23:06
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs k1piee HOWTO-Related Questions 14 1st October 2006 13:46
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 02:53


All times are GMT +2. The time now is 14:45.


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