Re: AW: [SOGo] Problem with AS

2014-12-15 Thread Szládovics Péter

2014-12-15 17:57 keltezéssel, Thomas Fuehrer írta:

You can try to delete sogo_cache_folder_. This is what resetdevice is 
supposed ... but there seems to be an issue with the delete in the code.
Do a refresh on the device and see whether the problem is fixed.


Thanks, it works! :)


What always should work is toemove the account from the device, delete 
sogo_cache_folder_ and after that recreate the account on the device.


Truncate the table not enough (I tried that first), I needed to drop the 
problematic tables. They are recreated, and everything looks like OK.


--
users@sogo.nu
https://inverse.ca/sogo/lists


AW: [SOGo] Problem with AS

2014-12-15 Thread Thomas Fuehrer


-Ursprüngliche Nachricht-
Von: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] Im Auftrag von 
Szládovics Péter
Gesendet: Montag, 15. Dezember 2014 17:12
An: users@sogo.nu
Betreff: Re: [SOGo] Problem with AS

2014-12-15 16:34 keltezéssel, t...@aon.at írta:
> Ok; I seems that there is a problem with the cache entries for the synced 
> folders.
> I assume that the column c_type has a value 127 which is wrong.

You're absolutely right! All of problematic users have the 127 in the c_type 
field. My wife has 200 and 201 values

> This was caused by a bug which was fixed some time ago, but old cache entries 
> migth still have the wrong value.

How can I purge them with keep the database in consistent state?

> Can you please post the content of the table: sogo_cache_folder_.

Are you sure? My table has 106 columns... But all problematic user has the 
value 127 in c_type column in every row. I checked it.

> You can try to identify the deviceId from sogo.log and then use following 
> command to reset the device:
> sogo-tool manage-eas resetdevice   sogo.log>

I have found my id in my phone, and checked it in the log, and already tried 
this step. It didn't help :(
--
users@sogo.nu
https://inverse.ca/sogo/lists

==
==

You can try to delete sogo_cache_folder_. This is what resetdevice is 
supposed ... but there seems to be an issue with the delete in the code.
Do a refresh on the device and see whether the problem is fixed. 

What always should work is toemove the account from the device, delete 
sogo_cache_folder_ and after that recreate the account on the device.

Regards,
Thomas



-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Problem with AS

2014-12-15 Thread Szládovics Péter

2014-12-15 16:34 keltezéssel, t...@aon.at írta:

Ok; I seems that there is a problem with the cache entries for the synced 
folders.
I assume that the column c_type has a value 127 which is wrong.


You're absolutely right! All of problematic users have the 127 in the 
c_type field. My wife has 200 and 201 values



This was caused by a bug which was fixed some time ago, but old cache entries 
migth still have the wrong value.


How can I purge them with keep the database in consistent state?


Can you please post the content of the table: sogo_cache_folder_.


Are you sure? My table has 106 columns... But all problematic user has 
the value 127 in c_type column in every row. I checked it.



You can try to identify the deviceId from sogo.log and then use following 
command to reset the device:
sogo-tool manage-eas resetdevice  


I have found my id in my phone, and checked it in the log, and already 
tried this step. It didn't help :(

--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Problem with AS

2014-12-15 Thread tfu
2014-12-15 14:27 keltezéssel, t...@aon.at írta:
> Hi Peti!

Hi,

> You can use "sogo-tool manage-eas" to display the which folders are currently 
> managed  for a particular EAS client:
>
> Display all registered devices:
> " sogo-tool manage-eas listdevices"
>
> Display all folders for a particular device:
> " sogo-tool manage-eas listfolders"
>
>
> Please post the result of "listfolders", it might help to understand what is 
> going on ...

Thanks your help, but it doesn't help :(

sogo-tool manage-eas listdevices 

is empty:
<0x0x8ab82bc[SOGoCache]> Cache cleanup interval set every 300.00 seconds
<0x0x8ab82bc[SOGoCache]> Using host(s) 'localhost' as server(s)

My daughter's list empty too...

But my wife's list has the ID:
<0x0x98f82bc[SOGoCache]> Cache cleanup interval set every 300.00 seconds
<0x0x98f82bc[SOGoCache]> Using host(s) 'localhost' as server(s)
*android1388534406700*

I think, these footprints seems good, but we need to know where do they 
go :)

Have you ideas?
How can I register out phones? Mailbox deletion/recreation didn't help.
-- 
users@sogo.nu
https://inverse.ca/sogo/lists




Ok; I seems that there is a problem with the cache entries for the synced 
folders. 
I assume that the column c_type has a value 127 which is wrong.
This was caused by a bug which was fixed some time ago, but old cache entries 
migth still have the wrong value.

Can you please post the content of the table: sogo_cache_folder_.

You can try to identify the deviceId from sogo.log and then use following 
command to reset the device:
sogo-tool manage-eas resetdevice  

Regards,
Thomas
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Problem with AS

2014-12-15 Thread Szládovics Péter

2014-12-15 15:38 keltezéssel, Christian Mack írta:

Hello Szládovics Péter

Am 2014-12-15 um 12:01 schrieb Szládovics Péter:

We have the weird problem with some clients of us.
The problem is exists on my mobile (Android/4.4.2-EAS-1.3) and on my
older daughter's mobile (4.2.2-EAS-1.3) - and doesn't exist on my wife's
mobile (4.2.2-EAS-1.3 too), so I don't know, what is wrong.

When I set up the AS client, the mails/contacts/calendar were
synchronised correctly, but the folders were duplicated on the folder
list. On my daughter's mobile the folders were multiplied (4-5-6 times),
when I changed the period of synchronization. On my mobile always have
max. two copies.
Some times the folder-list seems as normal, but doesn't contain any
mails... When they are multiplied, the first one keeps the mails, the
other ones are empty.

My wife hasn't this problem, and I don't know why - she hasn't any
sub-folder. But my daughter and me have.

This problem has existed since upgraded my system to 2.2.10 - actually
we use 2.2.11a, but the problem still alive.

Other components (Ubuntu 14.04.1 LTS):

apache2-2.4.7-1ubuntu4.1
apache2-bin-2.4.7-1ubuntu4.1
apache2-data-2.4.7-1ubuntu4.1
apache2-mpm-prefork-2.4.7-1ubuntu4.1
apache2-utils-2.4.7-1ubuntu4.1
dovecot-core-1:2.2.9-1ubuntu2.1
dovecot-imapd-1:2.2.9-1ubuntu2.1
dovecot-ldap-1:2.2.9-1ubuntu2.1
dovecot-managesieved-1:2.2.9-1ubuntu2.1
dovecot-pop3d-1:2.2.9-1ubuntu2.1
dovecot-sieve-1:2.2.9-1ubuntu2.1
libapache2-mod-php5-5.5.9+dfsg-1ubuntu4.5
libapache2-mod-wsgi-3.4-4ubuntu2.1.14.04.2
libsope-appserver4.9-4.9.r1664.20141210
libsope-core4.9-4.9.r1664.20141210
libsope-gdl1-4.9-4.9.r1664.20141210
libsope-ldap4.9-4.9.r1664.20141210
libsope-mime4.9-4.9.r1664.20141210
libsope-xml4.9-4.9.r1664.20141210
postfix-2.11.0-1
postfix-ldap-2.11.0-1
python-samba-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-common-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-common-bin-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-dsdb-modules-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-libs:i386-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-vfs-modules-2:4.1.6+dfsg-1ubuntu2.14.04.3
sogo:i386-2.2.11a-1
sogo-activesync-2.2.11a-1
sope4.9-gdl1-mysql-4.9.r1664.20141210
sope4.9-libxmlsaxdriver-4.9.r1664.20141210

Do you know what is wrong? Could you solve this?


As you updated SOGo in between.
Did you try to clear all ActiveSync meta data on the SOGo server with
sogo-tool and resynchronize?

See
sogo-tool manage-eas listdevices ${USER}
sogo-tool manage-eas resetdevice ${USER} ${DEVICEID}


Hi,

This is OK, but I don't see any device-id for my problematic users. How 
can I reset that device what hasn't device-id?


--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Problem with AS

2014-12-15 Thread Szládovics Péter

2014-12-15 14:27 keltezéssel, t...@aon.at írta:

Hi Peti!


Hi,


You can use "sogo-tool manage-eas" to display the which folders are currently 
managed  for a particular EAS client:

Display all registered devices:
" sogo-tool manage-eas listdevices"

Display all folders for a particular device:
" sogo-tool manage-eas listfolders"


Please post the result of "listfolders", it might help to understand what is 
going on ...


Thanks your help, but it doesn't help :(

sogo-tool manage-eas listdevices 

is empty:
<0x0x8ab82bc[SOGoCache]> Cache cleanup interval set every 300.00 seconds
<0x0x8ab82bc[SOGoCache]> Using host(s) 'localhost' as server(s)

My daughter's list empty too...

But my wife's list has the ID:
<0x0x98f82bc[SOGoCache]> Cache cleanup interval set every 300.00 seconds
<0x0x98f82bc[SOGoCache]> Using host(s) 'localhost' as server(s)
*android1388534406700*

I think, these footprints seems good, but we need to know where do they 
go :)


Have you ideas?
How can I register out phones? Mailbox deletion/recreation didn't help.
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Problem with AS

2014-12-15 Thread Christian Mack
Hello Szládovics Péter

Am 2014-12-15 um 12:01 schrieb Szládovics Péter:
> 
> We have the weird problem with some clients of us.
> The problem is exists on my mobile (Android/4.4.2-EAS-1.3) and on my
> older daughter's mobile (4.2.2-EAS-1.3) - and doesn't exist on my wife's
> mobile (4.2.2-EAS-1.3 too), so I don't know, what is wrong.
> 
> When I set up the AS client, the mails/contacts/calendar were
> synchronised correctly, but the folders were duplicated on the folder
> list. On my daughter's mobile the folders were multiplied (4-5-6 times),
> when I changed the period of synchronization. On my mobile always have
> max. two copies.
> Some times the folder-list seems as normal, but doesn't contain any
> mails... When they are multiplied, the first one keeps the mails, the
> other ones are empty.
> 
> My wife hasn't this problem, and I don't know why - she hasn't any
> sub-folder. But my daughter and me have.
> 
> This problem has existed since upgraded my system to 2.2.10 - actually
> we use 2.2.11a, but the problem still alive.
> 
> Other components (Ubuntu 14.04.1 LTS):
> 
>apache2-2.4.7-1ubuntu4.1
>apache2-bin-2.4.7-1ubuntu4.1
>apache2-data-2.4.7-1ubuntu4.1
>apache2-mpm-prefork-2.4.7-1ubuntu4.1
>apache2-utils-2.4.7-1ubuntu4.1
>dovecot-core-1:2.2.9-1ubuntu2.1
>dovecot-imapd-1:2.2.9-1ubuntu2.1
>dovecot-ldap-1:2.2.9-1ubuntu2.1
>dovecot-managesieved-1:2.2.9-1ubuntu2.1
>dovecot-pop3d-1:2.2.9-1ubuntu2.1
>dovecot-sieve-1:2.2.9-1ubuntu2.1
>libapache2-mod-php5-5.5.9+dfsg-1ubuntu4.5
>libapache2-mod-wsgi-3.4-4ubuntu2.1.14.04.2
>libsope-appserver4.9-4.9.r1664.20141210
>libsope-core4.9-4.9.r1664.20141210
>libsope-gdl1-4.9-4.9.r1664.20141210
>libsope-ldap4.9-4.9.r1664.20141210
>libsope-mime4.9-4.9.r1664.20141210
>libsope-xml4.9-4.9.r1664.20141210
>postfix-2.11.0-1
>postfix-ldap-2.11.0-1
>python-samba-2:4.1.6+dfsg-1ubuntu2.14.04.3
>samba-2:4.1.6+dfsg-1ubuntu2.14.04.3
>samba-common-2:4.1.6+dfsg-1ubuntu2.14.04.3
>samba-common-bin-2:4.1.6+dfsg-1ubuntu2.14.04.3
>samba-dsdb-modules-2:4.1.6+dfsg-1ubuntu2.14.04.3
>samba-libs:i386-2:4.1.6+dfsg-1ubuntu2.14.04.3
>samba-vfs-modules-2:4.1.6+dfsg-1ubuntu2.14.04.3
>sogo:i386-2.2.11a-1
>sogo-activesync-2.2.11a-1
>sope4.9-gdl1-mysql-4.9.r1664.20141210
>sope4.9-libxmlsaxdriver-4.9.r1664.20141210
> 
> Do you know what is wrong? Could you solve this?
> 

As you updated SOGo in between.
Did you try to clear all ActiveSync meta data on the SOGo server with
sogo-tool and resynchronize?

See
sogo-tool manage-eas listdevices ${USER}
sogo-tool manage-eas resetdevice ${USER} ${DEVICEID}


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature


Re:[SOGo] Problem with AS

2014-12-15 Thread tfu
Von: "Szládovics Péter" 
Erhalten: 15.12.2014 12:01
An: "SOGo lista" 

Hi Guys,

We have the weird problem with some clients of us.
The problem is exists on my mobile (Android/4.4.2-EAS-1.3) and on my 
older daughter's mobile (4.2.2-EAS-1.3) - and doesn't exist on my wife's 
mobile (4.2.2-EAS-1.3 too), so I don't know, what is wrong.

When I set up the AS client, the mails/contacts/calendar were 
synchronised correctly, but the folders were duplicated on the folder 
list. On my daughter's mobile the folders were multiplied (4-5-6 times), 
when I changed the period of synchronization. On my mobile always have 
max. two copies.
Some times the folder-list seems as normal, but doesn't contain any 
mails... When they are multiplied, the first one keeps the mails, the 
other ones are empty.

My wife hasn't this problem, and I don't know why - she hasn't any 
sub-folder. But my daughter and me have.

This problem has existed since upgraded my system to 2.2.10 - actually 
we use 2.2.11a, but the problem still alive.

Other components (Ubuntu 14.04.1 LTS):

apache2-2.4.7-1ubuntu4.1
apache2-bin-2.4.7-1ubuntu4.1
apache2-data-2.4.7-1ubuntu4.1
apache2-mpm-prefork-2.4.7-1ubuntu4.1
apache2-utils-2.4.7-1ubuntu4.1
dovecot-core-1:2.2.9-1ubuntu2.1
dovecot-imapd-1:2.2.9-1ubuntu2.1
dovecot-ldap-1:2.2.9-1ubuntu2.1
dovecot-managesieved-1:2.2.9-1ubuntu2.1
dovecot-pop3d-1:2.2.9-1ubuntu2.1
dovecot-sieve-1:2.2.9-1ubuntu2.1
libapache2-mod-php5-5.5.9+dfsg-1ubuntu4.5
libapache2-mod-wsgi-3.4-4ubuntu2.1.14.04.2
libsope-appserver4.9-4.9.r1664.20141210
libsope-core4.9-4.9.r1664.20141210
libsope-gdl1-4.9-4.9.r1664.20141210
libsope-ldap4.9-4.9.r1664.20141210
libsope-mime4.9-4.9.r1664.20141210
libsope-xml4.9-4.9.r1664.20141210
postfix-2.11.0-1
postfix-ldap-2.11.0-1
python-samba-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-common-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-common-bin-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-dsdb-modules-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-libs:i386-2:4.1.6+dfsg-1ubuntu2.14.04.3
samba-vfs-modules-2:4.1.6+dfsg-1ubuntu2.14.04.3
sogo:i386-2.2.11a-1
sogo-activesync-2.2.11a-1
sope4.9-gdl1-mysql-4.9.r1664.20141210
sope4.9-libxmlsaxdriver-4.9.r1664.20141210

Do you know what is wrong? Could you solve this?

Thanks,
Peti
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


===
===

Hi Peti!

You can use "sogo-tool manage-eas" to display the which folders are currently 
managed  for a particular EAS client:

Display all registered devices:
" sogo-tool manage-eas listdevices "

Display all folders for a particular device:
" sogo-tool manage-eas listfolders "


Please post the result of "listfolders", it might help to understand what is 
going on ...

Regards,
Thomas
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Problem with AS

2014-12-15 Thread Szládovics Péter

Hi Guys,

We have the weird problem with some clients of us.
The problem is exists on my mobile (Android/4.4.2-EAS-1.3) and on my 
older daughter's mobile (4.2.2-EAS-1.3) - and doesn't exist on my wife's 
mobile (4.2.2-EAS-1.3 too), so I don't know, what is wrong.


When I set up the AS client, the mails/contacts/calendar were 
synchronised correctly, but the folders were duplicated on the folder 
list. On my daughter's mobile the folders were multiplied (4-5-6 times), 
when I changed the period of synchronization. On my mobile always have 
max. two copies.
Some times the folder-list seems as normal, but doesn't contain any 
mails... When they are multiplied, the first one keeps the mails, the 
other ones are empty.


My wife hasn't this problem, and I don't know why - she hasn't any 
sub-folder. But my daughter and me have.


This problem has existed since upgraded my system to 2.2.10 - actually 
we use 2.2.11a, but the problem still alive.


Other components (Ubuntu 14.04.1 LTS):

   apache2-2.4.7-1ubuntu4.1
   apache2-bin-2.4.7-1ubuntu4.1
   apache2-data-2.4.7-1ubuntu4.1
   apache2-mpm-prefork-2.4.7-1ubuntu4.1
   apache2-utils-2.4.7-1ubuntu4.1
   dovecot-core-1:2.2.9-1ubuntu2.1
   dovecot-imapd-1:2.2.9-1ubuntu2.1
   dovecot-ldap-1:2.2.9-1ubuntu2.1
   dovecot-managesieved-1:2.2.9-1ubuntu2.1
   dovecot-pop3d-1:2.2.9-1ubuntu2.1
   dovecot-sieve-1:2.2.9-1ubuntu2.1
   libapache2-mod-php5-5.5.9+dfsg-1ubuntu4.5
   libapache2-mod-wsgi-3.4-4ubuntu2.1.14.04.2
   libsope-appserver4.9-4.9.r1664.20141210
   libsope-core4.9-4.9.r1664.20141210
   libsope-gdl1-4.9-4.9.r1664.20141210
   libsope-ldap4.9-4.9.r1664.20141210
   libsope-mime4.9-4.9.r1664.20141210
   libsope-xml4.9-4.9.r1664.20141210
   postfix-2.11.0-1
   postfix-ldap-2.11.0-1
   python-samba-2:4.1.6+dfsg-1ubuntu2.14.04.3
   samba-2:4.1.6+dfsg-1ubuntu2.14.04.3
   samba-common-2:4.1.6+dfsg-1ubuntu2.14.04.3
   samba-common-bin-2:4.1.6+dfsg-1ubuntu2.14.04.3
   samba-dsdb-modules-2:4.1.6+dfsg-1ubuntu2.14.04.3
   samba-libs:i386-2:4.1.6+dfsg-1ubuntu2.14.04.3
   samba-vfs-modules-2:4.1.6+dfsg-1ubuntu2.14.04.3
   sogo:i386-2.2.11a-1
   sogo-activesync-2.2.11a-1
   sope4.9-gdl1-mysql-4.9.r1664.20141210
   sope4.9-libxmlsaxdriver-4.9.r1664.20141210

Do you know what is wrong? Could you solve this?

Thanks,
Peti
--
users@sogo.nu
https://inverse.ca/sogo/lists