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.
Closed Thread
 
Thread Tools Display Modes
  #21  
Old 6th March 2006, 18:07
coza coza is offline
Junior Member
 
Join Date: Dec 2005
Location: Johannesburg - South Africa
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Falco,

The difference in the postfix config for 2.2, is the only difference that u need to create a virtual.cf with the following ?

user = <user_name> password = <password> hosts = server dbname = maildb query = SELECT goto FROM virtual WHERE address='%s'

Or do you need to add that to each of the *virtual*.cf files ?

I cant make out if thats what you mean..

Thanks.

CoZa
Sponsored Links
  #22  
Old 6th March 2006, 22:51
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

You have to change the sql queries in all .cf files.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
  #23  
Old 7th March 2006, 11:42
coza coza is offline
Junior Member
 
Join Date: Dec 2005
Location: Johannesburg - South Africa
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks,

I see that in the new format the lines :

table =
select_field =
where_field =

have been replaced with :

query = SELECT goto FROM virtual WHERE address='%s'

What format does this line need to be changed in each of the .cf's ?
Are there any examples of this setup for your howto ?
Thanks in advance,

CoZa
  #24  
Old 7th March 2006, 13:39
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

Quote:
Originally Posted by coza
Thanks,

I see that in the new format the lines :

table =
select_field =
where_field =

have been replaced with :

query = SELECT goto FROM virtual WHERE address='%s'

What format does this line need to be changed in each of the .cf's ?
Are there any examples of this setup for your howto ?
Thanks in advance,

CoZa
In the old format you have something like

Code:
table = virtual
select_field = goto
where_field = address
In the new format you'd replace it with
Code:
query = SELECT goto FROM virtual WHERE address='%s'
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
  #25  
Old 16th March 2006, 11:30
coza coza is offline
Junior Member
 
Join Date: Dec 2005
Location: Johannesburg - South Africa
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default Squirrelmail.

Thanks for that Falko, i finally manaded to change the queries for my Ubuntu server.

I am now however struggling with squirrelmail, Is there any special config changes to squirrelmail, to work with this howto ?

I have installed SM and configured the tables etc.
I have created mailboxes and sent mail to them , creating the actual mailboxes.
Everything seems fine exept....

I cannot loginto squirrlemail.
I get the error : Unknown user or password incorrect.
I have changed the passwords a few times and doesnt help.

syslog says :

Mar 16 12:16:34 localhost imaplogin: Connection, ip=[::ffff:127.0.0.1]
Mar 16 12:16:39 localhost imaplogin: LOGIN FAILED, ip=[::ffff:127.0.0.1]

netstat - tap says :

root@sipho:/etc/postfix# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost.localdo:10024 *:* LISTEN 6469/amavisd (maste
tcp 0 0 localhost.localdo:10025 *:* LISTEN 6787/master
tcp 0 0 localhost.localdo:mysql *:* LISTEN 6674/mysqld
tcp 0 0 *:10000 *:* LISTEN 6978/perl
tcp 0 0 *:smtp *:* LISTEN 6787/master
tcp 0 0 localhost.localdo:mysql localhost.localdo:52235 ESTABLISHED6674/mysqld
tcp 0 0 localhost.localdo:mysql localhost.localdo:35347 ESTABLISHED6674/mysqld
tcp 0 0 localhost.localdo:52148 localhost.localdo:mysql ESTABLISHED6912/amavisd (child
tcp 0 0 localhost.localdo:52235 localhost.localdo:mysql ESTABLISHED6913/amavisd (child
tcp 0 0 localhost.localdo:35347 localhost.localdo:mysql ESTABLISHED6908/apache2
tcp 0 0 localhost.localdo:mysql localhost.localdo:52148 ESTABLISHED6674/mysqld
tcp6 0 0 *:imaps *:* LISTEN 6579/couriertcpd
tcp6 0 0 *op3s *:* LISTEN 6614/couriertcpd
tcp6 0 0 *op3 *:* LISTEN 6594/couriertcpd
tcp6 0 0 *:imap2 *:* LISTEN 6559/couriertcpd
tcp6 0 0 *:www *:* LISTEN 6858/apache2
tcp6 0 0 *:ssh *:* LISTEN 6821/sshd
tcp6 0 2668 sipho.werty.com:ssh ::ffff:192.168.45:54919 ESTABLISHED7095/2
tcp6 0 0 sipho.werty.com:ssh ::ffff:192.168.45:52956 ESTABLISHED7032/1
tcp6 0 0 sipho.werty.com:ssh ::ffff:192.168.45:51802 ESTABLISHED6922/0

Im all out of ideas , can you maybe shed some light on this one for me please ?

Regards,

CoZa
  #26  
Old 16th March 2006, 18:21
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

Did you use the correct username (email address) and password?

There must be some kind of Squirrelmail configuration file. I don't know its correct location, so you must search a little bit for it.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
  #27  
Old 20th March 2006, 10:36
coza coza is offline
Junior Member
 
Join Date: Dec 2005
Location: Johannesburg - South Africa
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default Squirrelmail

Have checked through the Squirrel mail config, and cand find anything..

Has anyone had Squirrelmail up and running with this setup on ubuntu 5.10 ?


Shot,

CoZa
  #28  
Old 20th March 2006, 12:10
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,257
Thanks: 75
Thanked 22 Times in 18 Posts
Default

Quote:
Originally Posted by savkar
I let users change their password using Squirrelmail with teh change_sqlpass plugin. There are multiple ways you could do this...
as we have real system users why not use the change_syste-.passwort squirrelmail plugin? or are there separate passwords for system user and email access? how exactly did you integrate the change_mysql passwd ? anything special to be careful about?
  #29  
Old 20th March 2006, 12:14
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,257
Thanks: 75
Thanked 22 Times in 18 Posts
Default

Quote:
Originally Posted by savkar
Hi.

The tutorial was excellent! I am fully up and running/operational.

one question I have regards spamassassin. I understand that it works best if you train it with ham and spam.

I currently have been collecting from users various emails that have come into one or the other category (ham caught by SA, or spam that was not caught).

What is the best way after setting up amavis-spamassassin with the directions in the tutorial to set up a cron job to automatically train spamassassin?

Do I simply pipe the messages thru sa-learn --spam or sa-learn --ham, or is it more complicated?

When I have looked on the web, I see that people do things like --rebuild and so forth, but I am unsure what this all does.

Also, after I train spamassassin with the spam/ham, do I need to ever retain those messages or can they be disgarded?

Thanks in advance-- would be great if the sa-learn method was added to the tutorial since I got the impression this is such an important part of sa to have it being trained.

Sunil
by the way it looks like you are using only one preference file (db) for all mail users , have you thought about givinf each mail user his own spam and ham db for bayes purposes? it won't take more than 2-3MB / user - if doing so how can one separate the sa-learn scripts so that each users spam gets learned only for himself?

I had a link to a good howto but can't find it anymore...

anyone gotten so far as to have sa with sa-learn and dcc razor2 and pyzor working on a per user basis?

###edit###

I found out you can use: --dbpath

but how would that look like so that I could use a variable and the path gets substituted by the actual user...

p.s. Falko once helped me do this, where would I find these files (I still have a backup of that old system)

Last edited by Ovidiu; 20th March 2006 at 12:17.
  #30  
Old 22nd March 2006, 11:43
coza coza is offline
Junior Member
 
Join Date: Dec 2005
Location: Johannesburg - South Africa
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default Can't log into mailboxes.

Hi guys,

I have discovered that my problem is not only isolated to the webmail interface.

- I am not able to authenticate to any mailbox via a mail client or telnet session either.
- I am 100% that it is not me typing the password incorrectly. and i have re-set it plenty of times. I am using the whole email address as the username.
- I can send mail to the mailboxes and i have seen that the /home/vmail has the directories and new mail folders created.

I am running Ubuntu 5.10 with postfix 2.2 and i have updated the mysql queiries for 2.2

Can anyone help me out ?
Thanks again in advance.

CoZa

Last edited by coza; 22nd March 2006 at 12:24.
Closed Thread

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 (+ SMTP-AUTH, Quota... killfrog HOWTO-Related Questions 3 25th September 2009 21:45
Virtual Users + Domains With Postfix, Courier + MySQL (+SMTP-AUTH, SpamA, ClamAV) brianwc HOWTO-Related Questions 6 9th May 2007 02:44
Virtual Users And Domains With Postfix, Courier And MySQL triak HOWTO-Related Questions 5 23rd January 2006 20:20
Backup the Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Qu rogierbanis HOWTO-Related Questions 1 13th January 2006 09:34
Virtual Users And Domains With Postfix, Courier And MySQL: POP/IMAP authentication SeanG HOWTO-Related Questions 3 1st January 2006 17:08


All times are GMT +2. The time now is 00:05.


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