[horde] About the error "There was an error in the configuration form. Perhaps you left out a required field."

[Jason Wang]

Dear Mike:

  Thanks a lot for your kind support!
  Yes, I want to change the authentication mode to SQL, but after I modify it and want to save it, as you know click the "Generate Horde Configuration" Button, it respond me the error message:" There was an error in the configuration form. Perhaps you left out a required field."
That is to say, I can't modify the configuration.

  But there are really no any asterisk (*) textbox empty!
  Could you please tell me the reason why?
  Thanks a lot very much.

Jason Wang
2007-11-13


-----Original Message-----
From: horde-bounces at lists.horde.org [mailto:horde-bounces at lists.horde.org] On Behalf Of Michael Rubinsky
Sent: Tuesday, November 13, 2007 11:52 AM
To: horde at lists.horde.org
Subject: Re: [horde] About the error "There was an error inthe configuration form. Perhaps you left out a required field."

Quoting Jason Wang <wjs at sha-etech.com>:

> Why I can?t Generate Horde Configuration?
>
> OS : CentOS 5.0 + cyrus-sasl-2.1.22 + postfix-2.4.5 + dovecot-1.0.7
> Database : postgreSQL-8.2.5
> httpd : Apache2.2.6
> PHP : php-5.2.4
>
> My imap server use postgreSQL to authentication, I edit the  
> dovecot-sql.conf as following:
>   connect = host=localhost dbname=horde user=postgres password=postgres_pass
>   password_query = SELECT user_uid as user, user_pass as password,  
> user_uid as userdb_home, 1004 as userdb_uid, 1004 as userdb_gid FROM  
> horde_users WHERE user_uid = '%u'
>   user_query = SELECT user_uid as home, 1004 as uid, 1004 as gid  
> FROM horde_users WHERE userid = '%u'
>
> After install is over, I login to the horde initial setup page  
> successfully and  when I click "Generate Horde Configuration", the  
> system respond me: "There was an error in the configuration form.  
> Perhaps you left out a required field."
>   But I check every tab and no any asterisk textbox empty.
>
> And at the "users" module, it shows me: "Your authentication backend  
> does not support adding users. If you wish to use Horde to  
> administer user accounts, you must use a different authentication  
> backend."
> Which authentication backend will be supported?
> Now at the setup page's Authentication tab: my authenticating users  
> backend is "Let a Horde application handle authentication" and The  
> application is "imp".
>
>
> Thank you very much for your kind support.
>   Best Regards.
>
> Jason Wang
> E-mail : wjs at sha-etech.com

If you want to use horde to manage your users you need to select a  
backend such as SQL that allows you to add/modify users.  If you wish  
to let IMP handle the authentication, then your users will be managed  
by your IMAP server.  I'm not sure what your attempting to do with  
that IMAP/SQL query you listed...but if you are trying to have your  
IMAP server use the horde user table to authenticate against, then you  
must use something like the SQL backend in Horde to handle your horde  
authentication.


Thanks,
mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org

"Time just hates me. That's why it made me an adult." - Josh Joplin