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 20th February 2007, 23:02
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default Virtual Users And Domains With Postfix,

I have decided to give this howto a try after much trouble with the fedora version. Now I have an even more elementry problem.

How do I get putty to copy/paste?

Currently I can copy from local (fedora machine) but when I goto right click to copy to remote (putty) nothing happens. The remote machine is a debian sarge box.

Regards

Fred
Reply With Quote
Sponsored Links
  #2  
Old 21st February 2007, 00:51
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I pulled out the very old windows laptop and installed putty on that, so I have managed to get putty working so I can continue. I would like to get putty working properly on my fedora machine though.

I have a problem with the very first line of the howto.
apt-get install postfix postfix-mysql postfix-doc mysql-client mysql-server courier-authdaemon courier-authmysql courier-pop courier-pop-ssl courier-imap courier-imap-ssl postfix-tls libsasl2 libsasl2-modules libsasl2-modules-sql sasl2-bin libpam-mysql openssl phpmyadmin

The error I get is:

Reading Package Lists... Done
Building Dependency Tree... Done
Package postfix-mysql is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
E: Package postfix-mysql has no installation candidate


Does anyone have any thoughts.

Regards

Fred
Reply With Quote
  #3  
Old 21st February 2007, 02:31
iverson0881 iverson0881 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 22
Thanks: 1
Thanked 0 Times in 0 Posts
Default

are you using the correct guide?

http://www.howtoforge.com/installing..._fedora_core_6

is the one you should be using if you're trying to work with Fedora Core 6
Reply With Quote
  #4  
Old 21st February 2007, 02:53
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The guide I am using is:
http://www.howtoforge.com/virtual_po..._quota_courier
It says it is a debian guide.
I am installing on Debian Sarge.

The client I am having difficulty using putty with is a FC6 machine. I now have putty operating on an XP laptop.

Regards

Fred
Reply With Quote
  #5  
Old 21st February 2007, 04:29
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well it took a fair bit of sorting out, but I worked out what I hadn't done.

You MUST do a apt-get update before you start to install anything.

Regards

Fred
Reply With Quote
  #6  
Old 21st February 2007, 06:57
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well I got as far as page 4 before I got an error.

I modified the /etc/spamassassin/local.cf as shown.

Ran /etc/init.d/amavis restart

Error:

Stopping amavisd: (not running).
Starting amavisd: Error in config file /etc/amavis/amavisd.conf: syntax error at /etc/amavis/amavisd.conf line 836, near "'SELECT "Y" as local FROM domains WHERE CONCAT("@",domain) IN (%k)';"
(failed).

I re-checked the line and it is as per the instructions.

Does anyone have any thoughts.

Regards

Fred
Reply With Quote
  #7  
Old 21st February 2007, 08:30
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

Quote:
"'SELECT "Y" as local FROM domains WHERE CONCAT("@",domain) IN (%k)';"
You have switched the ; and ' at the end of the statement. The ; is part of the MySQL syntax and should be within the quotes.
Reply With Quote
  #8  
Old 21st February 2007, 09:26
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have altered the line to read as follows:

$sql_select_policy = 'SELECT "Y" as local FROM domains WHERE CONCAT("@",domain) IN (%k);'


I now get the following error:

Stopping amavisd: (not running).
Starting amavisd: Scalar found where operator expected at /etc/amavis/amavisd.conf line 849, near "$sql_select_white_black_list"
(Missing semicolon on previous line?)
Error in config file /etc/amavis/amavisd.conf: syntax error at /etc/amavis/amavisd.conf line 849, near "$sql_select_white_black_list "
(failed).

The line at 849 reads:

$sql_select_white_black_list = undef; # undef disables SQL white/blacklisting


It would have been easier if this howto could have been cut and paste via putty properly. If I pasted from the howto into the remote (putty) it puts it all on one very long line. So it took me some 3 hours to go through it line be line between the howto and what was on the server for that one file.

Anyways, hopefully someone can help further with my problem.

Regards

Fred
Reply With Quote
  #9  
Old 21st February 2007, 11:13
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

Quote:
$sql_select_policy = 'SELECT "Y" as local FROM domains WHERE CONCAT("@",domain) IN (%k);'
You should add another ; at the end of the line (836?). Every command should be terminated with a semicolon also. Sorry, I should have been more careful with my initial response.
Reply With Quote
  #10  
Old 21st February 2007, 19:17
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

I have now altered the line to read:

$sql_select_policy = 'SELECT "Y" as local FROM domains WHERE CONCAT("@",domain) IN (%k);';

The error I how get is:

Stopping amavisd: (not running).
Starting amavisd: Error in config file /etc/amavis/amavisd.conf: syntax error at /etc/amavis/amavisd.conf line 836, near "'SELECT "Y" as local FROM domains WHERE CONCAT("@",domain) IN (%k);';"
(failed).


Regards

Fred
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
Virtual Users And Domains With Postfix, Courier And MySQL Secondary MX acoghlan HOWTO-Related Questions 1 8th March 2008 05:02
Issues with Postfix using "Virtual Users And Domains With Postfix, Courier And MySQL" Kyse HOWTO-Related Questions 15 6th January 2007 15:35
Virtual Users And Domains With Postfix, Courier And MySQL [+ procmail ?] immobilia HOWTO-Related Questions 5 29th June 2006 23:20
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs mholownych HOWTO-Related Questions 10 29th May 2006 03:39
Another Problem: Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP bluegrass Installation/Configuration 24 8th March 2006 01:41


All times are GMT +2. The time now is 06:19.


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