[horde] How to allow the addition of users?

[William O'Higgins]

On Tue, Jul 19, 2005 at 10:31:49AM -0400, Patrice Levesque wrote:

>> Adding users is disabled.
>> Listing users is disabled.
>> Can anyone point me in the right direction?  Thanks.
>
>To be able to add/list users, your authentication files
>(users/passwords) must be handled by Horde itself (like in SQL auth).
>
>I guess you're using IMAP authentication.

No, but it was a good thought, and it got me started.  I am now using
SQL-based authentication, and it almost works :-)  I've got the tables I
expected in my DB, and yet, when I go the the Administration -> Users
section, I get a "Fatal Error".  I'll put the whole error message at the
bottom of this email, bu the gist is that it wants to find my user
fields in a 'field_list'.  I don't know where that is (I didn't see it
in the list of tables or columns) and I could use a hand with
interpreting the message.  Thanks.

Okay, here's the error:


A fatal error has occurred
DB Error: no such field

[line 236 of /usr/share/horde3/admin/user.php]
Details (also in Horde's logfile):
    
object(db_error)(8) {
  ["error_message_prefix"]=>
  string(0) ""
  ["mode"]=>
  int(1)
  ["level"]=>
  int(1024)
  ["code"]=>
  int(-19)
  ["message"]=>
  string(23) "DB Error: no such field"
  ["userinfo"]=>
  string(93) "SELECT user_id FROM horde_users [nativecode=1054 **
Unknown column 'user_id' in 'field list']"
  ["backtrace"]=>
  array(9) {
    [0]=>
    array(6) {
      ["file"]=>
      string(21) "/usr/share/php/DB.php"
      ["line"]=>
      int(748)
      ["function"]=>
      string(10) "pear_error"
      ["class"]=>
      string(8) "db_error"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(5) {
        [0]=>
        string(23) "DB Error: no such field"
        [1]=>
        int(-19)
        [2]=>
        int(1)
        [3]=>
        int(1024)
        [4]=>
        string(93) "SELECT user_id FROM horde_users [nativecode=1054 **
Unknown column 'user_id' in 'field list']"
      }
    }
    [1]=>
    array(6) {
      ["file"]=>
      string(23) "/usr/share/php/PEAR.php"
      ["line"]=>
      int(536)
      ["function"]=>
      string(8) "db_error"
      ["class"]=>
      string(8) "db_error"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(4) {
        [0]=>
        int(-19)
        [1]=>
        int(1)
        [2]=>
        int(1024)
        [3]=>
        string(93) "SELECT user_id FROM horde_users [nativecode=1054 **
Unknown column 'user_id' in 'field list']"
      }
    }
    [2]=>
    array(6) {
      ["file"]=>
      string(28) "/usr/share/php/DB/common.php"
      ["line"]=>
      int(500)
      ["function"]=>
      string(10) "raiseerror"
      ["class"]=>
      string(4) "pear"
      ["type"]=>
      string(2) "::"
      ["args"]=>
      array(7) {
        [0]=>
        NULL
        [1]=>
        int(-19)
        [2]=>
        NULL
        [3]=>
        NULL
        [4]=>
        string(93) "SELECT user_id FROM horde_users [nativecode=1054 **
Unknown column 'user_id' in 'field list']"
        [5]=>
        string(8) "DB_Error"
        [6]=>
        bool(true)
      }
    }
    [3]=>
    array(6) {
      ["file"]=>
      string(27) "/usr/share/php/DB/mysql.php"
      ["line"]=>
      int(775)
      ["function"]=>
      string(10) "raiseerror"
      ["class"]=>
      string(8) "db_mysql"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(5) {
        [0]=>
        int(-19)
        [1]=>
        NULL
        [2]=>
        NULL
        [3]=>
        NULL
        [4]=>
        string(48) "1054 ** Unknown column 'user_id' in 'field list'"
      }
    }
    [4]=>
    array(6) {
      ["file"]=>
      string(27) "/usr/share/php/DB/mysql.php"
      ["line"]=>
      int(227)
      ["function"]=>
      string(15) "mysqlraiseerror"
      ["class"]=>
      string(8) "db_mysql"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(0) {
      }
    }
    [5]=>
    array(6) {
      ["file"]=>
      string(28) "/usr/share/php/DB/common.php"
      ["line"]=>
      int(1144)
      ["function"]=>
      string(11) "simplequery"
      ["class"]=>
      string(8) "db_mysql"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(31) "SELECT user_id FROM horde_users"
      }
    }
    [6]=>
    array(6) {
      ["file"]=>
      string(28) "/usr/share/php/DB/common.php"
      ["line"]=>
      int(1333)
      ["function"]=>
      string(5) "query"
      ["class"]=>
      string(8) "db_mysql"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(31) "SELECT user_id FROM horde_users"
      }
    }
    [7]=>
    array(6) {
      ["file"]=>
      string(40) "/usr/share/horde3/lib/Horde/Auth/sql.php"
      ["line"]=>
      int(297)
      ["function"]=>
      string(6) "getcol"
      ["class"]=>
      string(8) "db_mysql"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(31) "SELECT user_id FROM horde_users"
      }
    }
    [8]=>
    array(6) {
      ["file"]=>
      string(32) "/usr/share/horde3/admin/user.php"
      ["line"]=>
      int(234)
      ["function"]=>
      string(9) "listusers"
      ["class"]=>
      string(8) "auth_sql"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(0) {
      }
    }
  }
  ["callback"]=>
  NULL
}
-- 

yours,

William

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.horde.org/archives/horde/attachments/20050720/35b924b9/attachment.bin