#1  
Old 23rd July 2013, 10:09
sjswarts sjswarts is offline
Senior Member
 
Join Date: May 2011
Location: Australia
Posts: 135
Thanks: 17
Thanked 5 Times in 5 Posts
Default Horde 5.1 backends

G'day guys,

Just wanted to know if this will work, I don't want to try because it might break my system.

Basically I'm using Horde 5 Webmail and I want to utilize the passwd package so that users can change their ISPConfig passwords inside the WebGUI

So far I have gleaned this from previous tutorials (If anyone wants to make a new tutorial - Till? Falko?)

Code:
$backends['sql'] = array (
  'disabled' => false,
  'name' => 'SQL Server',
  'preferred' => '',
  'policy' => array(
    'minLength' => 7,
    'maxLength' => 64,
    'maxSpace' => 0,
    'minNumeric' => 1,
  ),
  'driver' => 'Sql',
  'params' => array(
    'phptype' => 'mysql',
    'hostspec' => 'localhost',
    'username' => 'root',
    'password' => '***',
    'encryption' => 'crypt-md5',
    'database' => 'ISPCONFIG_DATABASE',
    'table' => 'mail_user',
    'user_col' => 'email',
    'pass_col' => 'password',
    'show_encryption' => false
    // The following two settings allow you to specify custom queries for
    // lookup and modify functions if special functions need to be
    // performed. In places where a username or a password needs to be
    // used, refer to this placeholder reference:
    // %d -> gets substituted with the domain
    // %u -> gets substituted with the user
    // %U -> gets substituted with the user without a domain part
    // %p -> gets substituted with the plaintext password
    // %e -> gets substituted with the encrypted password
    //
    // 'query_lookup' => 'SELECT user_pass FROM horde_users WHERE user_uid = %u',
   // 'query_modify' => 'UPDATE horde_users SET user_pass = %e WHERE user_uid = %u',
  ),
);
Will this still work? Is the encryption method still right?
__________________
Regards,
Steven Swarts
Reply With Quote
Sponsored Links
  #2  
Old 23rd July 2013, 10:20
sjswarts sjswarts is offline
Senior Member
 
Join Date: May 2011
Location: Australia
Posts: 135
Thanks: 17
Thanked 5 Times in 5 Posts
Default

Another backend issue is with authentication using IMP

This is my /imp/config/backends.local.php excerpt:

Code:
// IMAP server
$servers['imap'] = array(
    // ENABLED by default; will connect to IMAP port on local server
    'disabled' => false,
    'name' => 'ISPConfig Server',
    'hostspec' => 'localhost',
    'hordeauth' => full,
    'protocol' => 'imap',
    'port' => 993,
    // Plaintext logins are disabled by default on IMAP servers (see RFC 3501
    // [6.2.3]), so TLS is the only guaranteed authentication available by
    // default.
    'secure' => 'tls',
);
However it comes up with "Login Failed"???

Any idea guys
__________________
Regards,
Steven Swarts
Reply With Quote
  #3  
Old 23rd July 2013, 12:15
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,405
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

I'am sorry, I'am not familar enough with horde to help you with this issue.

Quote:
Is the encryption method still right?
yes.

Quote:
However it comes up with "Login Failed"???
Try to not use tls. If horde is installed on the same server that runs the imap daemon and communicates trough localhost, then you dont need any encryption.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 24th July 2013, 17:45
sjswarts sjswarts is offline
Senior Member
 
Join Date: May 2011
Location: Australia
Posts: 135
Thanks: 17
Thanked 5 Times in 5 Posts
Default

I've tried:

port 143 - tls
port 143 - no security
port 993 - ssl

I know that these user accounts have access because I can use the following command to prove that:

openssl s_client -connect mail.example.com:143 -starttls imap

Obviously changing the port to suit.

hmmm, seems odd.
__________________
Regards,
Steven Swarts
Reply With Quote
  #5  
Old 25th July 2013, 12:43
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,405
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

Does the default webmail client which is installed as part of the perfect setup guides for ispconfig (squirrelmail) work?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 25th July 2013, 18:36
sjswarts sjswarts is offline
Senior Member
 
Join Date: May 2011
Location: Australia
Posts: 135
Thanks: 17
Thanked 5 Times in 5 Posts
 
Default Solved

Ok I figured it out.

The issue was that I didn't understand Horde properly - now I understand it a little more.

Horde has under Administration/Horde/Permissions an option to enable or disable (default). Well reading up on Active Sync controls and security I enabled it but as a result the whole permission system for Horde turns on.

Long story short IMP was correctly authenticating via IMAP on port 143 TLS but the user wasn't authorized in Hordes Permission system. As a result the user wasn't authenticated. In essence I guess it had 2 Authentication mechanisms.
__________________
Regards,
Steven Swarts
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
Horde 5.1 and ISPConfig 3 sjswarts ISPConfig 3 Priority Support 24 20th July 2013 05:38
Horde Groupware Webmail Edition ByteMe Networking Tips/Tricks/Mods 17 20th December 2012 10:12
Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 - issue c0mrade HOWTO-Related Questions 25 19th April 2009 18:11
Getting e-mail working hansoffate Installation/Configuration 29 13th August 2008 16:33
Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 bup413 HOWTO-Related Questions 10 30th May 2008 21:28


All times are GMT +2. The time now is 08:11.


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