SQL Error in ActiveSQL

Hi,

Yesterday I had a configuration error and my server was filled with error
messages up to the last bit of HDD space. Finally, the database crashed due
to missing disk space.

Now I get the SQL error below.

How can I fix that without crashing ActiveSycnß  

Thanks,

Torben

HORDE: [horde] SQL QUERY FAILED: SQLSTATE[23505]: Unique violation: 7
FEHLER:  doppelter Schlüsselwert verletzt Unique-Constraint
»horde_activesync_state_pkey«#012DETAIL:  Schlüssel
»(sync_key)=({518ff75a-1e4c-48f3-9152-1dda4e2ee3d4}152)« existiert bereits.
#012#011INSERT INTO horde_activesync_state (sync_key, sync_data,
sync_devid,#012#011  sync_time, sync_folderid, sync_user, sync_pending)
VALUES#012#011  ('{518ff75a-1e4c-48f3-9152-1dda4e2ee3d4}152',#012#011
E'\\x433a32383a22486f7264655f41637469766553796e635f466f6c6465725f496d6#012#0
11
170223a313032313a7b613a353a7b733a313a2273223b613a333a7b733a373a2275696#012#0
11
46e657874223b733a353a223431303533223b733a31313a2275696476616c696469747#012#0
11
9223b733a31303a2231313239363531313331223b733a31333a22686967686573746d6#012#0
11
f64736571223b693a303b7d733a313a226d223b613a31383a7b693a32393137353b613#012#0

Windows Phone ActiveSync Issue - no Mailbody displayed

Hi!

We've a problem with a Windows Phone 7.5 device (Nokia Lumia 800)  
connected to Horde (5.0.4) via ActiveSync (Protocol Version 12.1).  
Mails transferred via initial sync are displayed correctly, Mail  
arriving at a later time show headers only.

Unfortunatly I don't have access to the phone and we don't have  
another Windows phone to compare. Android and iOS are working as  
expected.

I've found http://bugs.horde.org/ticket/12203 so it seems that I'm not  
the only one with that problem.

Any hints what to do next?

regards
Lukas

--

-- 
sync mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: sync-unsubscribe <at> lists.horde.org

Add dependency for Horde_ActiveSync-2.4.0beta1

I looks like Horde_ActiveSync-2.4.0beta1 requires the (to be released)  
Horde_Core-2.5.0 because of changes in the interface. It might be  
helpful to add this dependency.
-- 
This message was sent from a mailinglist subscription address.
For off-list replies, you must remove the address extension.

--

-- 
sync mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: sync-unsubscribe <at> lists.horde.org

contact dates of birth are time-shifted by one day to the past when syncing from horde to mobile

Hi,

when horde sents a contact with active sync to my mobile phone, the date
of birth is shifted by one hour into the past.

As we only need the know the date for birthdays, we don't have extra
data like a timestamp stored within the database. But we have a varchar
field with a size of 10 to store iso formatted dates. But thats no
problem, PHP will threat those dates with a timestamp of 00:00:00. All
dates of birth in the database (table `horde_contacts`, fieldname
`object_bday`) are right. But a look into the ActiveSync Log file
offers, that somewhere must be done some date/time calculation magic
that a birthday eg. "1980-03-10" is exported as "1980-03-09T23:00:00.000Z"

But this only occurs, when a contact is synced from horde to my mobile
phone. The other direction works fine, also calendar entries are synced
as expected.

My php default date/time zone is set to 'Europe/Berlin'.

Online research and a lot of debug approaches did not help. Now i'm
unsure if its a horde problem or maybe some misconfiguration in my
installation.

Does anyone has the same or similar problem or knows about this?

Thank you in advance.

Patrick
--

-- 

Client did not provide authentication data (H5 Samsung Galaxy S3 4.1.2/ Nexus 7 4.2.2))

Hello Horde users and developers, 
I can't figure out why I get the error stated in the subject here. 
If I try to connect, I always get the "Incorrect username or password" on my
Android device. 

*Server-Enviroment:*
 Ubuntu 12.04, Apache 2.2, PHP 5.3.10 (CGI/FastCGI)
The Horde-version is the latest stable 5.?.

*ActiveSync settings:*
Enabled email sync EAS 12.1

I should finally mention that I have tried with and without the domainname
in the username, and all the different sync versions. 
Does anyone have any suggestions on how to solve this?

Activesync.txt <http://horde.690.n7.nabble.com/file/n108753/Activesync.txt>  
Androidlog,txt
<http://horde.690.n7.nabble.com/file/n108753/Androidlog%2Ctxt>  
wiresharklog.txt
<http://horde.690.n7.nabble.com/file/n108753/wiresharklog.txt>  

--
View this message in context: http://horde.690.n7.nabble.com/Client-did-not-provide-authentication-data-H5-Samsung-Galaxy-S3-4-1-2-Nexus-7-4-2-2-tp108753.html
Sent from the Horde - Sync mailing list archive at Nabble.com.
--

-- 
sync mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: sync-unsubscribe <at> lists.horde.org

Error in communicating with ActiveSync server: Unknown Error

This might be just noise in the logs, but in case it contains  
something useful, I'll post it anyway:

2013-03-10T08:46:13+01:00 ERR: HORDE [horde] Returning HTTP 500 [pid  
16346 on line 160 of "/usr/share/php5/PEAR/Horde/Rpc/ActiveSync.php"]
2013-03-10T08:46:13+01:00 ERR: HORDE [horde] Error in communicating  
with ActiveSync server: Unknown Error [pid 16346 on line 223 of  
"/usr/share/php5/PEAR/Horde/Rpc/ActiveSync.php"]
2013-03-10T08:46:13+01:00 ERR: HORDE [horde] #0  
/srv/www/htdocs/horde/rpc.php(157):  
Horde_Rpc_ActiveSync->getResponse(NULL)
#1 {main} [pid 16346 on line 224 of  
"/usr/share/php5/PEAR/Horde/Rpc/ActiveSync.php"]
2013-03-10T08:46:13+01:00 ERR: HORDE [horde] Buffer contents:  
^C^Aj^ <at> EN^C4^ <at> ^A^A [pid 16346 on line 225 of  
"/usr/share/php5/PEAR/Horde/Rpc/ActiveSync.php"]
2013-03-10T08:46:15+01:00 ERR: HORDE [horde] Returning HTTP 500 [pid  
16848 on line 160 of "/usr/share/php5/PEAR/Horde/Rpc/ActiveSync.php"]
2013-03-10T08:46:15+01:00 ERR: HORDE [horde] Error in communicating  
with ActiveSync server: Unknown Error [pid 16848 on line 223 of  
"/usr/share/php5/PEAR/Horde/Rpc/ActiveSync.php"]
2013-03-10T08:46:15+01:00 ERR: HORDE [horde] #0  
/srv/www/htdocs/horde/rpc.php(157):  
Horde_Rpc_ActiveSync->getResponse(NULL)
#1 {main} [pid 16848 on line 224 of  
"/usr/share/php5/PEAR/Horde/Rpc/ActiveSync.php"]
2013-03-10T08:46:15+01:00 ERR: HORDE [horde] Buffer contents:  
^C^Aj^ <at> EN^C4^ <at> ^A^A [pid 16848 on line 225 of  
"/usr/share/php5/PEAR/Horde/Rpc/ActiveSync.php"]

PHP errors in logs

Since upgrading to the latest PEAR versions yesterday, I see the  
following message being logged quite regularly:

WARN: HORDE [horde] PHP ERROR: min(): When only one parameter is  
given, it must be an array [pid 14248 on line 262 of  
"/usr/share/php5/PEAR/Horde/ActiveSync/Folder/Imap.php"]

Is this something to worry about, or just log noise?

--

-- 
sync mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: sync-unsubscribe <at> lists.horde.org

PING-SYNC storm

Occasionally I see a significant battery drain on my mobile phone that  
syncs through ActiveSync. I enabled debugging and found that during  
such an event it continuously repeats the same PING-SYNC sycle.

When it PINGs the server, it will get a reply status of 2 and in the  
logs it mentions

2013-02-22T14:36:53+01:00 DEBUG: [29575] Initializing state for  
collection: Commercieel, synckey:  
{512745e0-365c-4a01-9e3f-4202c0a8010a}2
2013-02-22T14:36:53+01:00 DEBUG: [29575] Loading state for synckey  
{512745e0-365c-4a01-9e3f-4202c0a8010a}2
2013-02-22T14:36:53+01:00 DEBUG: [29575] Initializing message diff  
engine for Commercieel
2013-02-22T14:36:53+01:00 DEBUG: [29575]  
Horde_Core_ActiveSync_Driver::getServerChanges(Commercieel,  
1361528289, 1361540213, 0, 1)
2013-02-22T14:36:54+01:00 DEBUG: [29575] Found 1 message changes in  
Commercieel.
2013-02-22T14:36:54+01:00 DEBUG: [29575] No PIM changes present,  
returning all messages.

But when it subsequently attempts to SYNC that folder, no changes are found:

2013-02-22T14:36:56+01:00 DEBUG: [29598] Initializing state for  
collection: Commercieel, synckey:  
{512745e0-365c-4a01-9e3f-4202c0a8010a}2
2013-02-22T14:36:56+01:00 DEBUG: [29598] Loading state for synckey  
{512745e0-365c-4a01-9e3f-4202c0a8010a}2
2013-02-22T14:36:56+01:00 DEBUG: [29598] Initializing message diff  

Excessive logging for ActiveSync

I'm seeing loads of debug messages being logged in /tmp/horde_debug.txt:

[ array dump removed ]

Backtrace:
1. Horde_Rpc_ActiveSync->getResponse() /srv/www/htdocs/horde/rpc.php:157
2. Horde_ActiveSync->handleRequest()  
/usr/share/php5/PEAR/Horde/Rpc/ActiveSync.php:145
3. Horde_ActiveSync_Request_Base->handle()  
/usr/share/php5/PEAR/Horde/ActiveSync.php:639
4. Horde_ActiveSync_Request_Ping->_handle()  
/usr/share/php5/PEAR/Horde/ActiveSync/Request/Base.php:218
5. Horde::debug() /usr/share/php5/PEAR/Horde/ActiveSync/Request/Ping.php:166

Is this debug statement intentional or a left-over from debugging  
during development? Looking at the context, it looks like there is  
nothing abnormal going on, so I suspect the latter. I have commented  
it out for now, to stop this file from growing excessively (it grew to  
100's of megabytes within days of activating e-mail in ActiveSync). I  
don't have debugging enabled by the way...

Best regards, Arjen

--

-- 
sync mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: sync-unsubscribe <at> lists.horde.org

How to sync subfolders?

Currently I have ActiveSync setup to synchronize Calender, Contacts  
and E-mail. This seems works just fine, but it looks like only the  
messages in INBOX are pushed to the client. I receive no notifications  
for messages that are sorted into subfolders (through Sieve). Only  
when opening a subfolder on a client device, the messages are  
synchronized and I also receive a new mail notification on the client  
(so eventually messages are picked up).

If I want to receive new mail notifications for subfolders, is this  
something I need to setup on the client, or is it possible to push  
them from the server as well? I have been looking through the  
preferences, but can't find how to do this.

I'm using the latest stable versions from PEAR by the way.

Best regards, Arjen

--

-- 
sync mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: sync-unsubscribe <at> lists.horde.org

trash folder

Hi *,

maybe this was introduced with the latest code update or is something  
else, but I just noticed that my code to limit ActiveSync to only  
special folders does not longer support my trash folder.

In my personal preferences for IMP, I have deactivated moving deleted  
messages to the trash folder, and therefore have no folder marked as  
"trash folder".

IMP_Mailbox::getSpecialMailboxes() contains:

self::SPECIAL_TRASH => $GLOBALS['prefs']->getValue('use_trash') ?  
self::getPref('trash_folder') : null,

therefore no trash folder is reported.

Now when I sync my remote device, where I have deleted messages, the  
SYNC call returns with HTTP error 500 and an error message in the  
ActiveSync log:

--- cut here ---
2013-02-17T19:26:51+01:00 DEBUG: [30306]  
Horde_Core_ActiveSync_Driver::deleteMessage() INBOX: Array
(
     [0] => 26765
     [1] => 26766
)

2013-02-17T19:26:51+01:00 ERR: Ordner "" konnte nicht geöffnet werden.