[Tickets #12679] Re: Provisioning ActiveSync fails with integrity constraint on database

[noreply at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/12679
------------------------------------------------------------------------------
  Ticket             | 12679
  Updated By         | trunet at wsartori.com <trunet at wsartori.com>
  Summary            | Provisioning ActiveSync fails with integrity constraint
                     | on database
  Queue              | Horde Groupware Webmail Edition
  Version            | 5.1.2
  Type               | Bug
  State              | Unconfirmed
  Priority           | 3. High
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


trunet at wsartori.com (2013-09-12 21:57) wrote:

Hi,

I have enabled provisioning of activesync on my horde. I already had  
an iPhone added and after adding the permissions I got on syslog:
Sep 12 18:52:45 hosting HORDE: [horde] SQL QUERY FAILED:  
SQLSTATE[23000]: Integrity constraint violation: 1048 Column  
'device_user' cannot be null  #012#011INSERT INTO  
horde_activesync_device_users (device_id, device_user,#012#011   
device_policykey) VALUES('MY_IPHONE_ID', NULL, 0) [pid 32303 on line  
553 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
Sep 12 18:52:45 hosting HORDE: [horde] Returning HTTP 500 while  
handling Ping command. [pid 32303 on line 156 of  
"/var/www/vhosts/mywebmail.domain.com/rpc.php"]
Sep 12 18:52:45 hosting HORDE: [horde] Error in communicating with  
ActiveSync server: SQLSTATE[23000]: Integrity constraint violation:  
1048 Column 'device_user' cannot be null [pid 32303 on line 160 of  
"/usr/share/php/Horde/Rpc/ActiveSync.php"]
Sep 12 18:52:45 hosting HORDE: [horde] #0  
/usr/share/php/Horde/ActiveSync/Device.php(219):  
Horde_ActiveSync_State_Sql->setDeviceInfo(Object(Horde_ActiveSync_Device))#012#1 /usr/share/php/Horde/ActiveSync.php(804): Horde_ActiveSync_Device->save()#012#2 /usr/share/php/Horde/Rpc/ActiveSync.php(141): Horde_ActiveSync->handleRequest('Ping', 'Appl82948K9Z3NP')#012#3 /var/www/vhosts/mywebmail.domain.com/rpc.php(156): Horde_Rpc_ActiveSync->getResponse(NULL)#012#4 {main} [pid 32303 on line 160 of  
"/usr/share/php/Horde/Rpc/ActiveSync.php"]
Sep 12 18:52:45 hosting HORDE: [horde] Buffer contents:  [pid 32303 on  
line 160 of "/usr/share/php/Horde/Rpc/ActiveSync.php"]