A couple of issues

Good morning,

finally I gave Webtop a try and replaced SoGo. Primary reason has been the general direction of support from Webtop trough Nethesis.

In using I discovered some issues I would like to adress.

EAS and IMAP works flawless. I have tested several platforms for access to Webtop and all works. Outlook 2013,2016 and 365, all with Caldavsynchronizer and Imap.
IPhone and Ipad with EAS and for mails IMAP. All works. Thunderbird. Same story. All works so far.

Despite the in general positive impression there are a couple of things which IMO could be better.

Responsiveness
The viewing on an Ipad (10’) is crap. The folders and Messages and preview are complete messed up. I can manipulate the folder section, but not the others. I have a very narrow section for the mails which gives me no chance to choose one. Here Sogo is far better.

Signatures
The designing of signatures is not difficult as long as I don´t use the above menu in the signature window. Here I can find cryptric Java entry I dont understand. Here should be a more clear labeling without the behind laying code.

Adressbook
The import of adressbooks in xls oder csv format doesn´t work. The entrys are all empty. If I import in vcf format everything is fine. Maybe look into it why the csv (which is not uncommon) doesn´t work.

Besides the above mentioned points Webtop is a very nice software. Though it needs polishing. It works, yes. But for a general acceptance it needs work.

Regards

Thomas

I cannot confirm it (with my 9,7’-iPad). I have 3 columns and can adjust the width flexibly by moving the column separators.
Folders, mail lists and mail previews are well separated and not messed up. I can deal with mails like in desktop browsers.

Signatures: …use the above menu in the signature window. Here I can find cryptric Java entry I dont understand

I did it with Identities–> mail card editor. No problems to create and edit a mail card.

Though it needs polishing.

Thats right. The menu buttons all over there are unfinished, also in mail editor.


image

…the same with all others.
image

Adressbook

I exported an Apple contact list as vcard and imported it:

[INFO] Started at 2021-04-09T15:22:36.667+02:00
[WARN] Problems encountered. No changes have been applied!
[ERROR] Unexpected error. Reason: JOOQ
[INFO] Ended at 2021-04-09T15:22:37.481+02:00

Alternatively i dealt with a single contact vcard - that works.

The most important issue for me: The Import/Synchronization with my NextCloud Contacts (via CardDAV-Link integrated) are not operational.
image

Sincerely, Marko

Hi @capote,

I can assure you that in the 5.11.2 release, currently in testing, all the missing label translations have been added :wink:
Some random screenshots:
Immagine1
Immagine2
Immagine3

this instead seems to be a problem due to the length of some fields that exceed the limit value set on postgresql.
It should report further details in the log /var/log/webtop/webtop.log.
If you understand which field we are talking about you can intervene on the database and increase the default limit to solve :wink:

1 Like

Thnk you for the hint. I found this:

2021-04-12 13:30:41 [ERROR] c.s.w.c.job.RemoteCategorySyncJob - Unable to run remote sync com.sonicle.webtop.core.sdk.WTException: Error importing vCard at com.sonicle.webtop.contacts.ContactsManager.syncRemoteCategory(ContactsManager.java:2059) at com.sonicle.webtop.contacts.job.RemoteCategorySyncJob.internalExecuteWork(RemoteCategorySyncJob.java:100) at com.sonicle.webtop.contacts.job.RemoteCategorySyncJob.executeWork(RemoteCategorySyncJob.java:73) at com.sonicle.webtop.core.sdk.BaseJobServiceTask.execute(BaseJobServiceTask.java:76) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) Caused by: com.sonicle.webtop.core.dal.DAOException: JOOQ at com.sonicle.webtop.core.dal.BaseDAO$DAOExecuteListener.exception(BaseDAO.java:149) at org.jooq.impl.ExecuteListeners.exception(ExecuteListeners.java:232) at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:356) at org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:133) at com.sonicle.webtop.contacts.dal.ContactDAO.insert(ContactDAO.java:696) at com.sonicle.webtop.contacts.ContactsManager.doContactInsert(ContactsManager.java:2247) at com.sonicle.webtop.contacts.ContactsManager.syncRemoteCategory(ContactsManager.java:2035) ... 5 common frames omitted
Caused by: org.jooq.exception.DataAccessException: SQL [insert into "contacts"."contacts" ("contact_id", "category_id", "revision_status", "revision_timestamp", "public_uid", "is_list", "searchfield", "title", "firstname", "lastname", "nickname", "gender", "company", "function", "work_address", "work_city", "work_state", "work_postalcode", "work_country", "work_telephone", "work_telephone2", "work_fax", "work_mobile", "work_pager", "work_email", "work_im", "assistant", "assistant_telephone", "department", "manager", "home_address", "home_city", "home_state", "home_postalcode", "home_country", "home_telephone", "home_telephone2", "home_fax", "home_mobile", "home_pager", "home_email", "home_im", "partner", "birthday", "anniversary", "other_address", "other_city", "other_state", "other_postalcode", "other_country", "other_email", "other_im", "url", "notes", "revision_sequence", "href", "etag", "creation_timestamp", "display_name", "company_master_data_id") values (?, ?, ?, cast(? as timestamp), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, cast(? as date), cast(? as date), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, cast(? as timestamp), ?, ?)]; ERROR: value too long for type character varying(60) at org.jooq.impl.Utils.translate(Utils.java:1553) at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:609) at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:355) ... 9 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(60) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:412) at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:194) at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:409) at org.jooq.impl.AbstractStoreQuery.execute(AbstractStoreQuery.java:320) at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:341) ... 9 common frames omitted

But no idea how to fix it.

1 Like

I’m pretty sure it’s the “Company” field that’s too short for some of the imported data :thinking:

Try increasing its limit from 60 to 200 with this query:

su - postgres -c "psql webtop5 -c \"alter table contacts.contacts alter COLUMN company type character varying(200);\""

After this change try the import again and let me know how it goes :wink:

1 Like

I tried it. If I want to synchronize from Webtop comes agan:

2021-04-12 14:24:35 [ERROR] com.sonicle.webtop.contacts.Service - SyncRemoteCategoryAA failure
com.sonicle.webtop.core.sdk.WTException: Error importing vCard
at com.sonicle.webtop.contacts.ContactsManager.syncRemoteCategory(ContactsManager.java:2059)
at com.sonicle.webtop.contacts.Service$SyncRemoteCategoryAA.executeAction(Service.java:1691)
at com.sonicle.webtop.core.sdk.BaseServiceAsyncAction.run(BaseServiceAsyncAction.java:104)
at org.apache.shiro.subject.support.SubjectRunnable.doRun(SubjectRunnable.java:120)
at org.apache.shiro.subject.support.SubjectRunnable.run(SubjectRunnable.java:108)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.sonicle.webtop.core.dal.DAOException: JOOQ
at com.sonicle.webtop.core.dal.BaseDAO$DAOExecuteListener.exception(BaseDAO.java:149)
at org.jooq.impl.ExecuteListeners.exception(ExecuteListeners.java:232)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:356)
at org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:133)
at com.sonicle.webtop.contacts.dal.ContactDAO.insert(ContactDAO.java:696)
at com.sonicle.webtop.contacts.ContactsManager.doContactInsert(ContactsManager.java:2247)
at com.sonicle.webtop.contacts.ContactsManager.syncRemoteCategory(ContactsManager.java:2035)
… 5 common frames omitted
Caused by: org.jooq.exception.DataAccessException: SQL [insert into “contacts”.“contacts” (“contact_id”, “category_id”, “revision_status”, “revision_timestamp”, “public_uid”, “is_list”, “searchfield”, “title”, “firstname”, “lastname”, “nickname”, “gender”, “company”, “function”, “work_address”, “work_city”, “work_state”, “work_postalcode”, “work_country”, “work_telephone”, “work_telephone2”, “work_fax”, “work_mobile”, “work_pager”, “work_email”, “work_im”, “assistant”, “assistant_telephone”, “department”, “manager”, “home_address”, “home_city”, “home_state”, “home_postalcode”, “home_country”, “home_telephone”, “home_telephone2”, “home_fax”, “home_mobile”, “home_pager”, “home_email”, “home_im”, “partner”, “birthday”, “anniversary”, “other_address”, “other_city”, “other_state”, “other_postalcode”, “other_country”, “other_email”, “other_im”, “url”, “notes”, “revision_sequence”, “href”, “etag”, “creation_timestamp”, “display_name”, “company_master_data_id”) values (?, ?, ?, cast(? as timestamp), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, cast(? as date), cast(? as date), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, cast(? as timestamp), ?, ?)]; ERROR: value too long for type character varying(50)
at org.jooq.impl.Utils.translate(Utils.java:1553)
at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:609)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:355)
… 9 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(50)
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:412)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:194)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:409)
at org.jooq.impl.AbstractStoreQuery.execute(AbstractStoreQuery.java:320)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:341)
… 9 common frames omitted
[root@ns-srv01 ~]#

Thanx, MArko

Hi Marko,
this time it is a different field that exceeds the maximum limit … :thinking:
Fields limited to 50 characters are different.

Proceed like this:

  1. perform a describe of the contacts.contacts table:

     su - postgres -c 'psql webtop5'
     \d contacts.contacts
    

and mark the fields that have the limit of 50 in the Type: character varying(50)

  1. check on the source address book which of these fields could contain values longer than 50 characters

  2. increase the maximum limit of the field identified with a query similar to the one I have already passed to you

My2cents

2 Likes

After changing function the errors are eliminated and I got a status message: “Synchronization finished”

But not a single contact is synchronized :upside_down_face:

1 Like

Hi Mark,
I can suggest you to increase the log level of the com.sonicle.webtop.contacts service to TRACE to have the dump of the single vcards that are transferred during the synchronization.

You can do it easily from the admin interface from here:

Check what is being tracked to you during a sync attempt and let me know :wink:

Thank you for the hint.
Where can I find the trace?
In log viewer I found after changing log level and new synchronization only:

2021-04-13 18:20:12 [DEBUG] c.s.webtop.contacts.ContactsManager - Querying CardDAV endpoint for changes [https://nextcloud.mydomain.tld/remote.php/dav/addressbooks/users/caa85d42-a030-103a-989f-67ba5c0da2e1/contacts/, http://sabre.io/ns/sync/456] 2021-04-13 18:20:12 [DEBUG] c.s.webtop.contacts.ContactsManager - Returned 0 item

Sincerely, Marko

Hi Marko,
out of curiosity I did an internal test by creating two contacts in the Nextcloud address book and synchronizing in CardDAV on WebTop.
Placing the com.sonicle.webtop.contacts log in TRACE I see this:

2021-04-14 12:57:27 [DEBUG] c.s.webtop.contacts.ContactsManager - Retrieving whole list [https://myvm.domain.it/nextcloud/remote.php/dav/addressbooks/users/xxxxxxx-xxxx-103b-8692-49682f633eaa/contacts/]
2021-04-14 12:57:27 [DEBUG] c.s.webtop.contacts.ContactsManager - Endpoint returns 2 item
2021-04-14 12:57:27 [DEBUG] c.s.webtop.contacts.ContactsManager - Processing results...
2021-04-14 12:57:27 [TRACE] c.s.webtop.contacts.ContactsManager - f3acaf40-e653-43ed-8a1c-76a7a76c5211, Name1 Surname1
2021-04-14 12:57:27 [TRACE] c.s.webtop.contacts.ContactsManager - efd1aef9-14df-4147-b356-2590edeef215, Name2 Surname2

Honestly, I can’t explain why in your case no contact is found to synchronize :thinking:

1 Like

@lucag do please a test with non-ASCII characters. Starting from italians specific (accentate) then using umlaut, ç and other non-american/english characters (tilded-ns as spanish or portuguese)

1 Like

@lucag

SNMP (Simple Network Management Protocoll) needs three variables filled out, of these two are considered “comment”, what is in there should NOT matter…

However, my business partner put in “Zürich” in Location, instead of “Zuerich”.

We could NOT get SNMP to work, until I finally saw and also thought of the “Zürich”…
(2 days!).

So even a “comment” field - in some cases - can influence stuff!

My 2 cents
Andy

And I have a lot of with comments and umlauts…

I did this test with 2 names and surnames that contain these characters: üäë èòàù ïÖÜ ËÏ
and I had no problems with CardDAV sync:

2021-04-16 10:17:34 [DEBUG] c.s.webtop.contacts.ContactsManager - Retrieving whole list [https://nsent.mydom.net/nextcloud/remote.php/dav/addressbooks/users/xxxxxxxxx-103a-8484-a55d9fcbd329/contacts/]
2021-04-16 10:17:34 [DEBUG] c.s.webtop.contacts.ContactsManager - Endpoint returns 2 item
2021-04-16 10:17:34 [DEBUG] c.s.webtop.contacts.ContactsManager - Processing results...
2021-04-16 10:17:34 [TRACE] c.s.webtop.contacts.ContactsManager - b9943702-a184-4685-b458-2648c31e87f2, ïÖÜ ËÏ
2021-04-16 10:17:34 [TRACE] c.s.webtop.contacts.ContactsManager - 4841b3ed-16f9-4bc8-a421-13bc39b94ba6, üäë èòàù

This says it hasn’t found anything new to sync … :thinking:

Marko, can you try to delete and recreate the link to the remote address book on WebTop and run a new synchronization and see what the log reports ?

I did it before each new test. I will do it again.

miraculously, it now works.
:woozy_face:
I have no explanation for this

Thank you for your support.

2 Likes

Well known question: did you rebooted? :slight_smile:

no: image

One thing I did… I deactivated Thread Shield because of errors in rspamd history

edited: …But the errors in rspamd history still exists.