[Tickets #14639] Re: Primary key on all tables of horde database

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://bugs.horde.org/ticket/14639
------------------------------------------------------------------------------
  Ticket             | 14639
  Updated By         | steveqwe at gmail.com
  Summary            | Primary key on all tables of horde database
  Queue              | Horde Groupware Webmail Edition
  Version            | 5.2.20
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


steveqwe at gmail.com (2024-11-18 11:59) wrote:

Looks like Horde project is dead, php code has plenty of bugs using  
php 8.1 and up, cluster sql server compatibility is not a priority, is  
there anyone still develping Horde ?



> Hello, Horde team
>
> I try to deplo horde on Mysql Innodb cluster or Galera cluster, but  
> these environments require primary key on all database tables. These  
> are the database logs that describe the problem:
>
> 'Table horde_auth_schema_info does not have any PRIMARY KEY. This is  
> not compatible with Group Replication'
> 'Table horde_cache_schema_info does not have any PRIMARY KEY. This  
> is not compatible with Group Replication'
> 'Table horde_core_schema_info does not have any PRIMARY KEY. This is  
> not compatible with Group Replication'
> 'Table horde_dav_schema_info does not have any PRIMARY KEY. This is  
> not compatible with Group Replication'
> 'Table horde_group_schema_info does not have any PRIMARY KEY. This  
> is not compatible with Group Replication'
> 'Table horde_groups_members does not have any PRIMARY KEY. This is  
> not compatible with Group Replication'
> 'Table horde_history_schema_info does not have any PRIMARY KEY. This  
> is not compatible with Group Replication'
> 'Table horde_imap_client_schema_info does not have any PRIMARY KEY.  
> This is not compatible with Group Replication'
> 'Table horde_lock_schema_info does not have any PRIMARY KEY. This is  
> not compatible with Group Replication'
> 'Table horde_perms_schema_info does not have any PRIMARY KEY. This  
> is not compatible with Group Replication
>
> Is it predicted to add primary key to all tables at some subsequent  
> distribution of horde?
>
> If I add a primary key to all the tables, do you think the Horde  
> will work properly or will problems occur?
>
> You can see for this requirement for example  in url:   
> https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/
>
> Thank you.
> Antonis Limperis
>
>
>