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
  #31  
Old 20th November 2008, 09:51
topdog topdog is offline
Senior Member
 
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 153 Times in 150 Posts
Default

Quote:
Originally Posted by space007 View Post
First, Topdog many thanks, you are very helpful
That give an idea, to double check /etc/pam modifications related to imap, there was a typo in the DB pwd..
You r welcome.
Quote:
2. Kmail (on the local box), added IMAP & pop3
a) Imap connected
var log maillog
imap[9707]: accepted connection
master[9726]: about to exec /usr/lib/cyrus-imapd/imapd
imap[9726]: executed
imap[9707]: login: server [10.0.0.1] user@domain.com plaintext User
IMAP does not have default folders in Kmail, when I try to subscribe it crashes it

Do u see the folders in webmail ?
Quote:
b) Pop3 AUTH failed
messages:
pop3[9733]: sql_select option missing
pop3[9733]: auxpropfunc error no mechanism available
var log maillog
pop3[9708]: accepted connection
master[9733]: about to exec /usr/lib/cyrus-imapd/pop3d
pop3[9708]: badlogin: server [10.0.0.1] plaintext user@domain.com invalid user
pop3[9733]: executed
master[9688]: process 9708 exited, status 0
This is because your pop3 is authenticating against the system not against pam_mysql to fix
Code:
cp /etc/pam.d/imap /etc/pam.d/pop3
Quote:
3. Deliver mail to a smarthost with and without auth
Create this above the dnslookup router
Code:
smarthost:
  driver = manualroute
  transport = remote_smtp
  route_list = * mail.smarthost.name
Quote:
4. Somebody mentioned that horde can fetch external pop3, but as Horde is not a daemon, its just triggered when the user logs in (wild guess). So it does ot work for me, I will have some users accessing using IMAP and/or pop3, so I would need something like fetchmail. Will check this after first 3 issues are solved and post back.
Yes its not a daemon so the mail will only be fetched while the user is logged in.
Quote:
P.S. Just to know, got some errors in messages every 5 min. probably when horde and/or Kmail is accessing imap.
imap[9760]: auxpropfunc error no mechanism available
imap[9773]: sql_select option missing
This is not an error related to horde, it is due to the sql plugin of saslauthd to fix it look at this http://www.cyberciti.biz/faq/postfix...ropfunc-error/
__________________
----
http://www.topdog.za.net - Got Linux problems ? - I can help.
http://www.baruwa.org - Try it.
Reply With Quote
Sponsored Links
  #32  
Old 20th November 2008, 13:44
space007 space007 is offline
Junior Member
 
Join Date: Nov 2008
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by topdog View Post
You r welcome.
Do u see the folders in webmail ?
No. In Mail, there is just: Filters, New Message, Search

Quote:
Originally Posted by topdog View Post
This is because your pop3 is authenticating against the system not against pam_mysql to fix
Code:
cp /etc/pam.d/imap /etc/pam.d/pop3
I got pop, put placed also pop3

# cp /etc/pam.d/imap /etc/pam.d/pop
cp: overwrite `/etc/pam.d/pop'? y
# cp /etc/pam.d/imap /etc/pam.d/sieve
cp: overwrite `/etc/pam.d/sieve'? y
# cp /etc/pam.d/imap /etc/pam.d/lmtp
cp: overwrite `/etc/pam.d/lmtp'? y
# cp /etc/pam.d/imap /etc/pam.d/csync
cp: overwrite `/etc/pam.d/csync'? y

restarted sasl and exim
still no luck with pop3

Quote:
Originally Posted by topdog View Post
Create this above the dnslookup router
Code:
smarthost:
  driver = manualroute
  transport = remote_smtp
  route_list = * mail.smarthost.name
Thats cool for smarthost which dont need authentication, any idea if it is required ?

I tried using the one generated on debian:
Code:
remote_smtp_smarthost:
  driver = manualroute
  transport = remote_smtp
  hosts_try_auth = <; ${if exists{/etc/exim/passwd.client} \
        {\
        ${lookup{$host}nwildlsearch{/etc/exim/passwd.client}{$host_address}}\
        }\
        {} \
      }
Where passwd.client stands:
Code:
# password file used when the local exim is authenticating to a remote
# host as a client.
#
# see exim4_passwd_client(5) for more documentation
#
# Example:
### target.mail.server.example:login:password
mail.server.com:login:pwd
but exim doesnt start, it has a problem with "hosts_try_auth"

Quote:
Originally Posted by topdog View Post
Yes its not a daemon so the mail will only be fetched while the user is logged in.
Will check fetchmail then.


Quote:
Originally Posted by topdog View Post
This is not an error related to horde, it is due to the sql plugin of saslauthd to fix it look at this http://www.cyberciti.biz/faq/postfix...ropfunc-error/
done, errors gone!!


thanks

Last edited by space007; 20th November 2008 at 14:07.
Reply With Quote
  #33  
Old 20th November 2008, 14:08
topdog topdog is offline
Senior Member
 
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 153 Times in 150 Posts
Default

Code:
# routers section
smarthost:
  driver = manualroute
  domains = ! +local_domains
  transport = auth_remote
  route_list = * smart_host_name

# transports section
auth_remote:
  driver = smtp
  hosts_require_auth = smart_host_name

# authenticators section
smarthost_remote_login:
  driver = plaintext
  public_name = LOGIN
  client_send = : isp_user_name : isp_password
Use testsaslauthd to debug the pop3 service, as for the folders check the logs to see why the autocreate/autosubscribe options r not working (may be you removed it from the config)
__________________
----
http://www.topdog.za.net - Got Linux problems ? - I can help.
http://www.baruwa.org - Try it.
Reply With Quote
  #34  
Old 21st November 2008, 08:07
gsp gsp is offline
Member
 
Join Date: Oct 2008
Posts: 45
Thanks: 1
Thanked 0 Times in 0 Posts
Default

OK, here i am again, found some little spare time and started over:

CLEAN install CentOS 5.2 , with option Server GUI (and only)

Hostname: mailsrv

- SELinux: Permissive mode (in Enforced mode had many problems with php/apache)

- Started system in GNOME environment and make full yum update...


- Installed firefox, everything is updated and starting step-by-step and copy-paste from how to guide.. (its supposed that all necessary changes are done during transfer of configs(!))

- Configure rpmforge repo -> path not found... should be: http://apt.sw.be/redhat/el5/en/i386/...l5.rf.i386.rpm (hope its right...the same file..)
Result: Retrieving http://apt.sw.be/redhat/el5/en/i386/...l5.rf.i386.rpm
warning: /var/tmp/rpm-xfer.vVnMD4: Header V3 DSA signature: NOKEY, key ID 6b8d79e6
Preparing... ########################################### [100%]
1:rpmforge-release ########################################### [100%]

- Disable the repo... ** path is wrong, on my CentOS 5.2 path is \etc\yum.repos.d

- Installing apache and php (getting some many uknown errors..!)

Installing: php-pear ####################### [ 1/23]
Installing: php-pear-Net-Socket ####################### [ 2/23]
/tmp/glibctestc17Z8U:1:22: error: features.h: No such file or directory
Installing: php-pear-MDB2 ####################### [ 3/23]
/tmp/glibctestLE1x5J:1:22: error: features.h: No such file or directory
Installing: php-pear-Net-URL ####################### [ 4/23]
/tmp/glibctestRasjeX:1:22: error: features.h: No such file or directory
Installing: php-pear-Auth-SASL ####################### [ 5/23]
/tmp/glibctestMcGIcd:1:22: error: features.h: No such file or directory
Installing: php-pear-Net-SMTP ####################### [ 6/23]
/tmp/glibctestrrD0Jw:1:22: error: features.h: No such file or directory
Installing: php-pear-DB ####################### [ 7/23]
/tmp/glibctestHzrksp:1:22: error: features.h: No such file or directory
Installing: libc-client ####################### [ 8/23]
Installing: libmcrypt ####################### [ 9/23]
Installing: php-pdo ####################### [10/23]
Installing: php-mbstring ####################### [11/23]
Installing: php-pear-Net-Sieve ####################### [12/23]
/tmp/glibctest0T2EYG:1:22: error: features.h: No such file or directory
Installing: php-mcrypt ####################### [13/23]
Installing: php-pear-HTTP-Request ####################### [14/23]
/tmp/glibctestOnqEZA:1:22: error: features.h: No such file or directory
Installing: php-pear-Mail ####################### [15/23]
/tmp/glibctests7qLz6:1:22: error: features.h: No such file or directory
Installing: php-pear-Date ####################### [16/23]
/tmp/glibctestKGLHTA:1:22: error: features.h: No such file or directory
Installing: php-mysql ####################### [17/23]
Installing: php-pecl-Fileinfo ####################### [18/23]
Installing: php-xml ####################### [19/23]
Installing: php-pear-Mail-Mime ####################### [20/23]
/tmp/glibctestdeYm48:1:22: error: features.h: No such file or directory
Installing: php-pear-File ####################### [21/23]
/tmp/glibctestRkGCPV:1:22: error: features.h: No such file or directory
Installing: php-imap ####################### [22/23]
Installing: php-pear-Log ####################### [23/23]
/tmp/glibctestlKZx7w:1:22: error: features.h: No such file or directory

- Install Exim and MySQL ---> ALL succesful

Install rest of packages everything went fine.. no errors... so starting configuration..

Last edited by gsp; 21st November 2008 at 11:26.
Reply With Quote
  #35  
Old 21st November 2008, 11:38
gsp gsp is offline
Member
 
Join Date: Oct 2008
Posts: 45
Thanks: 1
Thanked 0 Times in 0 Posts
Default Config part

--Apache config...

i wonder.. now in server name.. should be mailsrv or mailsrv.mydomain.com ?

--Exim configured
copied entire config file from how to..

-- Mysql password

/usr/bin/mysqladmin -u root -h your_host_name password 'new-password' -p

this works ONLY if i set as hostname localhost... any other name fails...

--- Creating turba table

file is turba.mysql.sql and not turba_objects.mysql.sql (not existed something like this...)


-- Horde config

NOW.. in horde config file (which already exist) there are some duplicates with the proposed one.. During last installations remember that was serious problems with this... what should i do, just add in the bottom or replace? (think replacement doesn't work..)

-- Continued until cyrus config (imapd.conf)

Inside this file in admins section its only andrew... should be only this? (cyrus, Administrator?)


-- Continued with the rest of configs...

Starting services got this error:

"Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName"

Anyway, continuing the guide, create admin user and trying to login...

Logins with admin user but left tool bar is just a white area... after refreshing the page appears... (always happening..)

As admin created 2 users test1 and test2, when they are logged in no folders appear... only inbox... this problem in previous installs solved with cyrus user password...(only after set a cyrus password imp could see the folders section....this is what i was saying to topdog)

Trying to send a message from test1 to test2 i get an error that Sent Items folder cannot be created... Test1 receives this mail succesfully


So i stop here, wait for any suggestions how to make all this work..

Thank you

Last edited by gsp; 21st November 2008 at 12:29.
Reply With Quote
  #36  
Old 24th November 2008, 09:55
gsp gsp is offline
Member
 
Join Date: Oct 2008
Posts: 45
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Ok almost works!! (after some changes i have stated...)

Now i have 1-2 minor problems... One is Spamassassin which seems that only rejects spams without sending them in spam folders.. (thinks user nobody... how to fix this?)

And second one, what would be the best way to backup this system? I think that user folders are not enough...

Thanks in advance
Reply With Quote
  #37  
Old 24th November 2008, 10:07
topdog topdog is offline
Senior Member
 
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 153 Times in 150 Posts
Default

Quote:
Originally Posted by gsp View Post
Now i have 1-2 minor problems... One is Spamassassin which seems that only rejects spams without sending them in spam folders.. (thinks user nobody... how to fix this?)
If you do not want spam to be rejected at smtp time, and delivered to a spam folder then you need to comment out the section in you exim conf file
Code:
 drop    condition = ${if >{$spam_score_int}{60} {1}}
        message   = Your message scored $spam_score SpamAssassin point. Report follows:\n\
        $spam_report
You will also need a sieve rule to file the spam tagged mails into the spam folder.

Quote:
And second one, what would be the best way to backup this system? I think that user folders are not enough...
Thanks in advance
You need to backup /var/spool/imap, or if you want to go really funky you can setup imap replication to replicate the mail to another imap server.
__________________
----
http://www.topdog.za.net - Got Linux problems ? - I can help.
http://www.baruwa.org - Try it.
Reply With Quote
  #38  
Old 24th November 2008, 10:17
gsp gsp is offline
Member
 
Join Date: Oct 2008
Posts: 45
Thanks: 1
Thanked 0 Times in 0 Posts
Default

SO, if i only comment this rule in exim.conf, spam should come in INBOX marked as spam? (move to spam folders can be done from horde rules...?)

Because i am not familiar with sieve, i don't know how to do this...


Finally, if i backup /var/spool/imap and i have a system crash how i can restore users? In this way i keep only their folders, right? Users are kept in mysql, or not..?

To be more specific, i would like to have the smallest downtime due to a hardware problem... keep an image of the machine, keep config files and have it back in minutes.. but what about user accounts data?


finally, topdog, a BIG THANK YOU!
Reply With Quote
  #39  
Old 24th November 2008, 10:33
topdog topdog is offline
Senior Member
 
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 153 Times in 150 Posts
Default

Quote:
Originally Posted by gsp View Post
SO, if i only comment this rule in exim.conf, spam should come in INBOX marked as spam? (move to spam folders can be done from horde rules...?)
Yes thats right.
Quote:
Because i am not familiar with sieve, i don't know how to do this...
Its easy to use actually and very powerful, thats one of the reasons for using cyrus. And horde intergrates with sieve quite well so you can create
the rules from with in horde.
Quote:
Finally, if i backup /var/spool/imap and i have a system crash how i can restore users? In this way i keep only their folders, right? Users are kept in mysql, or not..?
My bad for a full recovery you will have to backup much more.
- The configs in /etc
- The mysql database horde
- The horde system
- The mail folders in /var/spool/mail
Quote:
To be more specific, i would like to have the smallest downtime due to a hardware problem... keep an image of the machine, keep config files and have it back in minutes.. but what about user accounts data?
Depending on how mission critical your setup is you could run a hot standby machine using cyrus imap replication / mysql replication. (I have a setup like that running a a large cellphone company)
Quote:
finally, topdog, a BIG THANK YOU!
No problem, hope my xmas present is in the post...... lol just kidding.
__________________
----
http://www.topdog.za.net - Got Linux problems ? - I can help.
http://www.baruwa.org - Try it.
Reply With Quote
  #40  
Old 24th November 2008, 11:05
gsp gsp is offline
Member
 
Join Date: Oct 2008
Posts: 45
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

Thanks also for your very quick answers!

I'll try to do these modifications and i hope that i will have finally this system up and running!
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
Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 Dutchy63 HOWTO-Related Questions 9 9th October 2008 12:50
Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 gueland HOWTO-Related Questions 3 28th August 2008 11:21
User constantly loggin into mail? bswinnerton Installation/Configuration 2 24th March 2008 00:12
Filtering emails using Spamassassin and Clamav for Exchange 2000 Server Rocky Server Operation 19 11th March 2008 08:27
Install ISPConfig on CentOS Server, in brief gfts Tips/Tricks/Mods 11 4th April 2006 08:29


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


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