[horde] active sync problem after upgrade Debian stretch to buster

r.j.baart at prompt.nl r.j.baart at prompt.nl
Mon Nov 25 21:52:02 UTC 2019


Hi,

next problem is an active sync problem. For unknown reason the active 
sync validation does not work anymore. The errors:

In the device logfile:

1006][2019-11-25T22:34:53+01:00] INFO: 
----------Horde_Core_ActiveSync_Driver::authenticate() attempt for 
xyz at xx.yy----------
[1006][2019-11-25T22:34:53+01:00] INFO: Access denied for user xyz at xx.yy 
per policy settings.
[1006][2019-11-25T22:34:53+01:00] INFO: ----------SYNC request received 
for user

In horde logfile:

2019-11-25T22:46:16+01:00 ERR: HORDE SQL QUERY FAILED: SQLSTATE[23502]: 
Not null violation: 7 ERROR:  null value in column "device_user" 
violates not-null constraint
DETAIL:  Failing row contains (ANDROIDC729032334, null, 0).
         INSERT INTO horde_activesync_device_users (device_id, device_user,
           device_policykey) VALUES('ANDROIDC729032334', NULL, 0) [pid 
1006 on line 236 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
2019-11-25T22:46:16+01:00 ERR: HORDE Returning HTTP 500 while handling 
FolderSync command. Error is: SQLSTATE[23502]: Not null violation: 7 
ERROR:  null value in column "device_user" violates not-null constraint
DETAIL:  Failing row contains (ANDROIDC729032334, null, 0). [pid 1006 on 
line 160 of "/home/websites/webmail/horde/rpc.php"]
2019-11-25T22:46:16+01:00 ERR: HORDE Error in communicating with 
ActiveSync server: SQLSTATE[23502]: Not null violation: 7 ERROR: null 
value in column "device_user" violates not-null constraint
DETAIL:  Failing row contains (ANDROIDC729032334, null, 0). [pid 1006 on 
line 165 of "/usr/share/php/Horde/Rpc/ActiveSync.php"]
2019-11-25T22:46:16+01:00 ERR: HORDE #0 
/usr/share/php/Horde/ActiveSync/Device.php(397): 
Horde_ActiveSync_State_Sql->setDeviceInfo(Object(Horde_ActiveSync_Device), 
Array)
#1 /usr/share/php/Horde/ActiveSync.php(936): Horde_ActiveSync_Device->save()
#2 /usr/share/php/Horde/ActiveSync.php(794): 
Horde_ActiveSync->_handleDevice('ANDROIDC7290323...')
#3 /usr/share/php/Horde/Rpc/ActiveSync.php(143): 
Horde_ActiveSync->handleRequest('FolderSync', 'ANDROIDC7290323...')
#4 /home/websites/webmail/horde/rpc.php(160): 
Horde_Rpc_ActiveSync->getResponse(NULL)
#5 {main} [pid 1006 on line 165 of 
"/usr/share/php/Horde/Rpc/ActiveSync.php"]
2019-11-25T22:46:16+01:00 ERR: HORDE Buffer contents:  [pid 1006 on line 
165 of "/usr/share/php/Horde/Rpc/ActiveSync.php"]
2019-11-25T22:46:18+01:00 ERR: HORDE SQL QUERY FAILED: SQLSTATE[23502]: 
Not null violation: 7 ERROR:  null value in column "device_user" 
violates not-null constraint
DETAIL:  Failing row contains (ANDROIDC729032334, null, 0).
         INSERT INTO horde_activesync_device_users (device_id, device_user,
           device_policykey) VALUES('ANDROIDC729032334', NULL, 0) [pid 
868 on line 236 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
2019-11-25T22:46:18+01:00 ERR: HORDE Returning HTTP 500 while handling 
Provision command. Error is: SQLSTATE[23502]: Not null violation: 7 
ERROR:  null value in column "device_user" violates not-null constraint
DETAIL:  Failing row contains (ANDROIDC729032334, null, 0). [pid 868 on 
line 160 of "/home/websites/webmail/horde/rpc.php"]
2019-11-25T22:46:18+01:00 ERR: HORDE Error in communicating with 
ActiveSync server: SQLSTATE[23502]: Not null violation: 7 ERROR: null 
value in column "device_user" violates not-null constraint
DETAIL:  Failing row contains (ANDROIDC729032334, null, 0). [pid 868 on 
line 165 of "/usr/share/php/Horde/Rpc/ActiveSync.php"]
2019-11-25T22:46:18+01:00 ERR: HORDE #0 
/usr/share/php/Horde/ActiveSync/Device.php(397): 
Horde_ActiveSync_State_Sql->setDeviceInfo(Object(Horde_ActiveSync_Device), 
Array)
#1 /usr/share/php/Horde/ActiveSync.php(936): Horde_ActiveSync_Device->save()
#2 /usr/share/php/Horde/ActiveSync.php(794): 
Horde_ActiveSync->_handleDevice('ANDROIDC7290323...')
#3 /usr/share/php/Horde/Rpc/ActiveSync.php(143): 
Horde_ActiveSync->handleRequest('Provision', 'ANDROIDC7290323...')
#4 /home/websites/webmail/horde/rpc.php(160): 
Horde_Rpc_ActiveSync->getResponse(NULL)
#5 {main} [pid 868 on line 165 of "/usr/share/php/Horde/Rpc/ActiveSync.php"]
2019-11-25T22:46:18+01:00 ERR: HORDE Buffer contents:  [pid 868 on line 
165 of "/usr/share/php/Horde/Rpc/ActiveSync.php"]

-- 

Cordialement,

R.J. Baart



More information about the horde mailing list