[Tickets #11664] Horde ignores custom mysql groups setup

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/11664
------------------------------------------------------------------------------
  Ticket           | 11664
  Erstellt Von     | Steffen.Petrick at gmx.de
  Zusammenfassung  | Horde ignores custom mysql groups setup
  Warteschlange    | Horde Framework Packages
  Version          | Git master
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


Steffen.Petrick at gmx.de (2012-11-07 08:47) hat geschrieben:

conf.php:

...
$conf['sql']['persistent'] = true;
$conf['sql']['username'] = 'horde5';
$conf['sql']['password'] = 'XXXXXX';
$conf['sql']['hostspec'] = 'dbhorde5';
$conf['sql']['port'] = 3306;
$conf['sql']['protocol'] = 'tcp';
$conf['sql']['database'] = 'horde5';
$conf['sql']['charset'] = 'utf-8';
$conf['sql']['ssl'] = false;
$conf['sql']['splitread'] = false;
$conf['sql']['phptype'] = 'mysql';
...
$conf['group']['username'] = 'mygroups';
$conf['group']['password'] = 'XXXXXX';
$conf['group']['hostspec'] = 'rauth-mysql';
$conf['group']['port'] = 3306;
$conf['group']['protocol'] = 'tcp';
$conf['group']['database'] = 'grouptest';
$conf['group']['charset'] = 'utf-8';
$conf['group']['ssl'] = false;
$conf['group']['splitread'] = false;
$conf['group']['phptype'] = 'mysqli';
$conf['group']['driverconfig'] = 'custom';
$conf['group']['driver'] = 'Sql';

When I removed the horde_groups* tables in the horde5 database, the  
following error message come from Horde group setup:

A fatal error has occurred
SQLSTATE[42S02]: Base table or view not found: 1146 Table  
'horde5.horde_groups' doesn't exist

1. Horde_Group_Sql->listAll() /var/www/horde5/admin/groups.php:169
2. Horde_Group_Sql->listAll() /var/www/horde5/admin/groups.php:169
3. Horde_Db_Adapter_Pdo_Base->selectAssoc()  
/usr/share/php/Horde/Group/Sql.php:219
4. Horde_Db_Adapter_Base->execute()  
/usr/share/php/Horde/Db/Adapter/Pdo/Base.php:143
5. Horde_Group_Sql->listAll() /var/www/horde5/admin/groups.php:169
6. Horde_Db_Adapter_Pdo_Base->selectAssoc()  
/usr/share/php/Horde/Group/Sql.php:219
7. Horde_Db_Adapter_Base->execute()  
/usr/share/php/Horde/Db/Adapter/Pdo/Base.php:143
8. PDO->query() /usr/share/php/Horde/Db/Adapter/Base.php:551

Details
The full error message is logged in Horde's log file, and is shown  
below only to administrators. Non-administrative users will not see  
error details.

Horde_Group_Exception Object
(
     [details] =>
     [logged] => 1
     [_logLevel:protected] => 0
     [message:protected] => SQLSTATE[42S02]: Base table or view not  
found: 1146 Table 'horde5.horde_groups' doesn't exist
     [string:Exception:private] =>
     [code:protected] => 42
     [file:protected] => /usr/share/php/Horde/Group/Sql.php
     [line:protected] => 221
     [trace:Exception:private] => Array
         (
             [0] => Array
                 (
                     [file] => /var/www/horde5/admin/groups.php
                     [line] => 169
                     [function] => listAll
                     [class] => Horde_Group_Sql
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )

         )

     [previous:Exception:private] => Horde_Db_Exception Object
         (
             [details] =>
             [logged] =>
             [_logLevel:protected] => 0
             [message:protected] => SQLSTATE[42S02]: Base table or  
view not found: 1146 Table 'horde5.horde_groups' doesn't exist
             [string:Exception:private] =>
             [code:protected] => 42
             [file:protected] => /usr/share/php/Horde/Db/Adapter/Base.php
             [line:protected] => 555
             [trace:Exception:private] => Array
                 (
                     [0] => Array
                         (
                             [file] =>  
/usr/share/php/Horde/Db/Adapter/Pdo/Base.php
                             [line] => 143
                             [function] => execute
                             [class] => Horde_Db_Adapter_Base
                             [type] => ->
                             [args] => Array
                                 (
                                     [0] => SELECT group_uid,  
group_name FROM horde_groups
                                     [1] =>
                                     [2] =>
                                 )

                         )

                     [1] => Array
                         (
                             [file] => /usr/share/php/Horde/Group/Sql.php
                             [line] => 219
                             [function] => selectAssoc
                             [class] => Horde_Db_Adapter_Pdo_Base
                             [type] => ->
                             [args] => Array
                                 (
                                     [0] => SELECT group_uid,  
group_name FROM horde_groups
                                 )

                         )

                     [2] => Array
                         (
                             [file] => /var/www/horde5/admin/groups.php
                             [line] => 169
                             [function] => listAll
                             [class] => Horde_Group_Sql
                             [type] => ->
                             [args] => Array
                                 (
                                 )

                         )

                 )

             [previous:Exception:private] => PDOException Object
                 (
                     [message:protected] => SQLSTATE[42S02]: Base  
table or view not found: 1146 Table 'horde5.horde_groups' doesn't exist
                     [string:Exception:private] =>
                     [code:protected] => 42S02
                     [file:protected] =>  
/usr/share/php/Horde/Db/Adapter/Base.php
                     [line:protected] => 551
                     [trace:Exception:private] => Array
                         (
                             [0] => Array
                                 (
                                     [file] =>  
/usr/share/php/Horde/Db/Adapter/Base.php
                                     [line] => 551
                                     [function] => query
                                     [class] => PDO
                                     [type] => ->
                                     [args] => Array
                                         (
                                             [0] => SELECT group_uid,  
group_name FROM horde_groups
                                         )

                                 )

                             [1] => Array
                                 (
                                     [file] =>  
/usr/share/php/Horde/Db/Adapter/Pdo/Base.php
                                     [line] => 143
                                     [function] => execute
                                     [class] => Horde_Db_Adapter_Base
                                     [type] => ->
                                     [args] => Array
                                         (
                                             [0] => SELECT group_uid,  
group_name FROM horde_groups
                                             [1] =>
                                             [2] =>
                                         )

                                 )

                             [2] => Array
                                 (
                                     [file] =>  
/usr/share/php/Horde/Group/Sql.php
                                     [line] => 219
                                     [function] => selectAssoc
                                     [class] => Horde_Db_Adapter_Pdo_Base
                                     [type] => ->
                                     [args] => Array
                                         (
                                             [0] => SELECT group_uid,  
group_name FROM horde_groups
                                         )

                                 )

                             [3] => Array
                                 (
                                     [file] => /var/www/horde5/admin/groups.php
                                     [line] => 169
                                     [function] => listAll
                                     [class] => Horde_Group_Sql
                                     [type] => ->
                                     [args] => Array
                                         (
                                         )

                                 )

                         )

                     [previous:Exception:private] =>
                     [errorInfo] => Array
                         (
                             [0] => 42S02
                             [1] => 1146
                             [2] => Table 'horde5.horde_groups' doesn't exist
                         )

                 )

         )

)


Steffen Petrick
TU Dresden