Webtop DB Error

Hi,
I have 2 problems with webtop:
1 -> In contacts I get a pop up “DB error”.
In the logs I have the following:

Caused by: org.jooq.exception.DataAccessException: SQL [select “contacts”.“contacts”.“contact_id”, “contacts”.“contacts”.“category_id”, “contacts”.“contacts”.“is_list”, “contacts”.“contacts”.“display_name”, “contacts”.“contacts”.“title”, “contacts”.“contacts”.“firstname”, “contacts”.“contacts”.“lastname”, “contacts”.“contacts”.“display_name”, “contacts”.“contacts”.“nickname”, “contacts”.“contacts”.“company”, “contacts”.“contacts”.“company_master_data_id”, “contacts”.“contacts”.“function”, “contacts”.“contacts”.“work_address”, “contacts”.“contacts”.“work_city”, “contacts”.“contacts”.“work_telephone”, “contacts”.“contacts”.“work_mobile”, “contacts”.“contacts”.“work_email”, “contacts”.“contacts”.“home_telephone”, “contacts”.“contacts”.“home_email”, “contacts”.“categories”.“name” as “category_name”, “contacts”.“categories”.“domain_id” as “category_domain_id”, “contacts”.“categories”.“user_id” as “category_user_id”, “core”.“master_data”.“master_data_id” as “master_data_id”, “core”.“master_data”.“description” as “master_data_description”, case when “contacts”.“contacts_pictures”.“contact_id” is not null then ? else ? end as “has_picture” from “contacts”.“contacts” join “contacts”.“categories” on “contacts”.“contacts”.“category_id” = “contacts”.“categories”.“category_id” left outer join “core”.“master_data” on “contacts”.“contacts”.“company_master_data_id” = “core”.“master_data”.“master_data_id” left outer join “contacts”.“contacts_pictures” on “contacts”.“contacts”.“contact_id” = “contacts”.“contacts_pictures”.“contact_id” where (“contacts”.“contacts”.“category_id” in (?, ?) and “contacts”.“contacts”.“is_list” = true and (“contacts”.“contacts”.“revision_status” = ? or “contacts”.“contacts”.“revision_status” = ?) and 1 = 1) order by “contacts”.“contacts”.“display_name” asc, “contacts”.“contacts”.“company” asc limit ?]; ERROR: column contacts.company_master_data_id does not exist
Position: 1272
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)
… 64 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: column contacts.company_master_data_id does not exist
Position: 1272
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.AbstractResultQuery.execute(AbstractResultQuery.java:247)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:341)
… 64 common frames omitted

2 -> At Nextcloud integration I get an pop up “Error”.
I followed the directions at “https://docs.nethserver.org/en/v7/webtop5.html#nextcloud-integration
In the logs I have the following:

[ERROR] com.sonicle.webtop.vfs.Service - Error in ManageGridFiles
org.apache.commons.vfs2.FileSystemException: Unknown message with code “Root not exist”.
at com.sonicle.webtop.vfs.sfs.StoreFileSystem.resolveRoot(StoreFileSystem.java:102)
at com.sonicle.webtop.vfs.sfs.StoreFileSystem.getRootFileObject(StoreFileSystem.java:82)
at com.sonicle.webtop.vfs.VfsManager.getTargetFileObject(VfsManager.java:1300)
at com.sonicle.webtop.vfs.VfsManager.listStoreFiles(VfsManager.java:609)
at com.sonicle.webtop.vfs.Service.processManageGridFiles(Service.java:860)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sonicle.webtop.core.app.servlet.BaseRequest.invokeMethod(BaseRequest.java:109)
at com.sonicle.webtop.core.app.servlet.PrivateRequest.processRequest(PrivateRequest.java:89)
at com.sonicle.webtop.core.app.servlet.PrivateRequest.doGet(PrivateRequest.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at com.sonicle.webtop.core.app.shiro.filter.GZip.doFilterInternal(GZip.java:60)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:685)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

Regards,
Tiago

Check for Webtop5 updates and tell us what happens.

In Software center I have no updates.

I tried the command yum clean all && yum update \*webtop*\ tomcat8 with no sucsess.

I suggest you to launch signal-event nethserver-webtop5-update command and post here output. You can find the output of this command in /var/log/messages.

Here it is:

Jan 12 17:22:27 mail esmith::event[9252]: Event: nethserver-webtop5-update
Jan 12 17:22:27 mail esmith::event[9252]: Migrating existing database configuration
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database certificates
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database networks
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database routes
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database accounts
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database hosts
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database proxypass
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database fwrules
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database fwservices
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database portforward
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database tc
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database dhcp
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database domains
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database getmail
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database vhosts
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database backups
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database fwtimes
Jan 12 17:22:28 mail esmith::event[9252]: Migrating existing database smarthosts
Jan 12 17:22:28 mail esmith::event[9252]: Action: /etc/e-smith/events/nethserver-webtop5-update/S00initialize-default-databases SUCCESS [0.452148]
Jan 12 17:22:28 mail esmith::event[9252]: expanding /etc/dovecot/dovecot.conf
Jan 12 17:22:28 mail esmith::event[9252]: expanding /etc/httpd/conf.d/default-virtualhost.inc
Jan 12 17:22:28 mail esmith::event[9252]: expanding /etc/httpd/conf.d/webtop.conf
Jan 12 17:22:28 mail esmith::event[9252]: expanding /etc/sysconfig/tomcat8@webtop
Jan 12 17:22:28 mail esmith::event[9252]: expanding /usr/share/webtop/z-push/config.json
Jan 12 17:22:28 mail esmith::event[9252]: expanding /usr/share/webtop/webdav/config.json
Jan 12 17:22:28 mail esmith::event[9252]: expanding /var/lib/tomcats/webtop/webapps/webtop/META-INF/data-sources.xml
Jan 12 17:22:28 mail esmith::event[9252]: expanding /var/lib/tomcats/webtop/webapps/webtop/WEB-INF/classes/logback.xml
Jan 12 17:22:28 mail esmith::event[9252]: Action: /etc/e-smith/events/actions/generic_template_expand SUCCESS [0.227908]
Jan 12 17:22:28 mail su: (to postgres) root on none
Jan 12 17:22:28 mail su: (to postgres) root on none
Jan 12 17:22:29 mail su: (to postgres) root on none
Jan 12 17:22:29 mail esmith::event[9252]: Action: /etc/e-smith/events/nethserver-webtop5-update/S20nethserver-webtop5-conf SUCCESS [0.8196]
Jan 12 17:22:29 mail su: (to postgres) root on none
Jan 12 17:22:30 mail esmith::event[9252]: ERROR: duplicate key value violates unique constraint “settings_pkey”
Jan 12 17:22:30 mail esmith::event[9252]: DETAIL: Key (service_id, key)=(com.sonicle.webtop.contacts, default.showby) already exists.
Jan 12 17:22:30 mail esmith::event[9252]: Action: /etc/e-smith/events/nethserver-webtop5-update/S30nethserver-webtop5-conf-db SUCCESS [0.742822]
Jan 12 17:22:30 mail su: (to postgres) root on none
Jan 12 17:22:30 mail esmith::event[9252]: Action: /etc/e-smith/events/nethserver-webtop5-update/S40nethserver-webtop5-locale-tz SUCCESS [0.49825]
Jan 12 17:22:30 mail esmith::event[9252]: Action: /etc/e-smith/events/nethserver-webtop5-update/S50nethserver-webtop5-clean-logs SUCCESS [0.019459]
Jan 12 17:22:30 mail systemd: Reloading.
Jan 12 17:22:31 mail esmith::event[9252]: [INFO] service dovecot restart
Jan 12 17:22:31 mail systemd: Stopping Dovecot IMAP/POP3 email server…
Jan 12 17:22:31 mail systemd: Stopped Dovecot IMAP/POP3 email server.
Jan 12 17:22:31 mail systemd: Starting Dovecot IMAP/POP3 email server…
Jan 12 17:22:31 mail systemd: Can’t open PID file /var/run/dovecot/master.pid (yet?) after start: No such file or directory
Jan 12 17:22:31 mail systemd: Started Dovecot IMAP/POP3 email server.
Jan 12 17:22:31 mail systemd: Reloading.
Jan 12 17:22:31 mail esmith::event[9252]: [INFO] service httpd reload
Jan 12 17:22:31 mail systemd: Reloading The Apache HTTP Server.
Jan 12 17:22:32 mail systemd: Reloaded The Apache HTTP Server.
Jan 12 17:22:32 mail systemd: Reloading.
Jan 12 17:22:32 mail esmith::event[9252]: [INFO] service tomcat8@webtop restart
Jan 12 17:22:32 mail systemd: Stopping Apache Tomcat 8 Web Application Container…
Jan 12 17:22:33 mail systemd: Stopped Apache Tomcat 8 Web Application Container.
Jan 12 17:22:33 mail systemd: Starting Apache Tomcat 8 Web Application Container…
Jan 12 17:22:33 mail systemd: Started Apache Tomcat 8 Web Application Container.
Jan 12 17:22:33 mail systemd: Reloading.
Jan 12 17:22:33 mail esmith::event[9252]: [INFO] service rh-php72-php-fpm restart
Jan 12 17:22:33 mail systemd: Stopping The PHP FastCGI Process Manager…
Jan 12 17:22:34 mail systemd: Stopped The PHP FastCGI Process Manager.
Jan 12 17:22:34 mail systemd: Starting The PHP FastCGI Process Manager…
Jan 12 17:22:34 mail systemd: Started The PHP FastCGI Process Manager.
Jan 12 17:22:34 mail esmith::event[9252]: Action: /etc/e-smith/events/actions/adjust-services SUCCESS [3.531561]
Jan 12 17:22:34 mail esmith::event[9252]: Event: nethserver-webtop5-update SUCCESS

Jan 12 17:22:30 mail esmith::event[9252]: ERROR: duplicate key value violates unique constraint “settings_pkey”
Jan 12 17:22:30 mail esmith::event[9252]: DETAIL: Key (service_id, key)=(com.sonicle.webtop.contacts, default.showby) already exists.

This is relevant…

If you go under contacts you still get error?

Yes. Same error.

Please, enter as admin in Webtop. Go under Settings (Second icon on left menu) > DB Update and take a screenshot

Maybe @lucag can help you

Thanks for your time.

Hi @Tiago and @federico.ballarini,
from what I read and see from the screenshot it is likely that during a previous upgrade phase something went wrong and no queries were performed on the database.

After making sure you have a database backup :wink: … you can try to run these queries manually and directly on the pgsql console:

su - postgres -c 'psql webtop5'

ALTER TABLE "contacts"."contacts" ADD COLUMN "display_name" varchar(255), ADD COLUMN "company_master_data_id" varchar(36);
UPDATE "contacts"."contacts" SET "display_name" = TRIM(COALESCE("firstname", '') || ' ' || COALESCE("lastname", '')) WHERE "is_list" IS FALSE;
UPDATE "contacts"."contacts" SET "firstname" = "lastname", "display_name" = "lastname" WHERE "is_list" IS TRUE;
DELETE FROM "core"."user_settings" WHERE ("user_settings"."service_id" = 'com.sonicle.webtop.contacts') AND ("user_settings"."key" = 'showby');
DELETE FROM "core"."domain_settings" WHERE ("domain_settings"."service_id" = 'com.sonicle.webtop.contacts') AND ("domain_settings"."key" = 'showby');
DELETE FROM "core"."settings" WHERE ("settings"."service_id" = 'com.sonicle.webtop.contacts') AND ("settings"."key" = 'showby');

\q

Finally, run the event again: signal-event nethserver-webtop5-update
and let me know if it solves the problem :wink:

2 Likes

First problem solved.

Any ideas about problem n.º2 ?

With which user are you trying to connect nextcloud?
Could you post your config without password?

My bad.
I thought that the first problem was solved.
Now I don’t have the pop up, but if I try to create one contact it doesn’t apear.
This is the log from the command

signal-event nethserver-webtop5-update

Jan 14 23:08:15 mail esmith::event[16487]: Event: nethserver-webtop5-update
Jan 14 23:08:15 mail esmith::event[16487]: Migrating existing database configuration
Jan 14 23:08:15 mail esmith::event[16487]: Migrating existing database certificates
Jan 14 23:08:15 mail esmith::event[16487]: Migrating existing database networks
Jan 14 23:08:15 mail esmith::event[16487]: Migrating existing database routes
Jan 14 23:08:15 mail esmith::event[16487]: Migrating existing database accounts
Jan 14 23:08:15 mail esmith::event[16487]: Migrating existing database hosts
Jan 14 23:08:15 mail esmith::event[16487]: Migrating existing database proxypass
Jan 14 23:08:15 mail esmith::event[16487]: Migrating existing database fwrules
Jan 14 23:08:15 mail esmith::event[16487]: Migrating existing database fwservices
Jan 14 23:08:15 mail esmith::event[16487]: Migrating existing database portforward
Jan 14 23:08:16 mail esmith::event[16487]: Migrating existing database tc
Jan 14 23:08:16 mail esmith::event[16487]: Migrating existing database dhcp
Jan 14 23:08:16 mail esmith::event[16487]: Migrating existing database domains
Jan 14 23:08:16 mail esmith::event[16487]: Migrating existing database getmail
Jan 14 23:08:16 mail esmith::event[16487]: Migrating existing database vhosts
Jan 14 23:08:16 mail esmith::event[16487]: Migrating existing database backups
Jan 14 23:08:16 mail esmith::event[16487]: Migrating existing database fwtimes
Jan 14 23:08:16 mail esmith::event[16487]: Migrating existing database smarthosts
Jan 14 23:08:16 mail esmith::event[16487]: Action: /etc/e-smith/events/nethserver-webtop5-update/S00initialize-default-databases SUCCESS [0.524826]
Jan 14 23:08:16 mail esmith::event[16487]: expanding /etc/dovecot/dovecot.conf
Jan 14 23:08:16 mail esmith::event[16487]: expanding /etc/httpd/conf.d/default-virtualhost.inc
Jan 14 23:08:16 mail esmith::event[16487]: expanding /etc/httpd/conf.d/webtop.conf
Jan 14 23:08:16 mail esmith::event[16487]: expanding /etc/sysconfig/tomcat8@webtop
Jan 14 23:08:16 mail esmith::event[16487]: expanding /usr/share/webtop/z-push/config.json
Jan 14 23:08:16 mail esmith::event[16487]: expanding /usr/share/webtop/webdav/config.json
Jan 14 23:08:16 mail esmith::event[16487]: expanding /var/lib/tomcats/webtop/webapps/webtop/META-INF/data-sources.xml
Jan 14 23:08:16 mail esmith::event[16487]: expanding /var/lib/tomcats/webtop/webapps/webtop/WEB-INF/classes/logback.xml
Jan 14 23:08:16 mail esmith::event[16487]: Action: /etc/e-smith/events/actions/generic_template_expand SUCCESS [0.233416]
Jan 14 23:08:16 mail su: (to postgres) root on none
Jan 14 23:08:16 mail su: (to postgres) root on none
Jan 14 23:08:16 mail su: (to postgres) root on none
Jan 14 23:08:17 mail esmith::event[16487]: Action: /etc/e-smith/events/nethserver-webtop5-update/S20nethserver-webtop5-conf SUCCESS [0.830483]
Jan 14 23:08:17 mail su: (to postgres) root on none
Jan 14 23:08:17 mail esmith::event[16487]: ERROR: duplicate key value violates unique constraint “settings_pkey”
Jan 14 23:08:17 mail esmith::event[16487]: DETAIL: Key (service_id, key)=(com.sonicle.webtop.contacts, default.showby) already exists.
Jan 14 23:08:18 mail esmith::event[16487]: Action: /etc/e-smith/events/nethserver-webtop5-update/S30nethserver-webtop5-conf-db SUCCESS [0.884002]
Jan 14 23:08:18 mail su: (to postgres) root on none
Jan 14 23:08:18 mail esmith::event[16487]: Action: /etc/e-smith/events/nethserver-webtop5-update/S40nethserver-webtop5-locale-tz SUCCESS [0.744971]
Jan 14 23:08:18 mail esmith::event[16487]: Action: /etc/e-smith/events/nethserver-webtop5-update/S50nethserver-webtop5-clean-logs SUCCESS [0.019429]
Jan 14 23:08:19 mail systemd: Reloading.
Jan 14 23:08:19 mail esmith::event[16487]: [INFO] service dovecot restart
Jan 14 23:08:19 mail systemd: Stopping Dovecot IMAP/POP3 email server…
Jan 14 23:08:19 mail systemd: Stopped Dovecot IMAP/POP3 email server.
Jan 14 23:08:19 mail systemd: Starting Dovecot IMAP/POP3 email server…
Jan 14 23:08:19 mail systemd: Can’t open PID file /var/run/dovecot/master.pid (yet?) after start: No such file or directory
Jan 14 23:08:19 mail systemd: Started Dovecot IMAP/POP3 email server.
Jan 14 23:08:19 mail systemd: Reloading.
Jan 14 23:08:19 mail esmith::event[16487]: [INFO] service httpd reload
Jan 14 23:08:20 mail systemd: Reloading The Apache HTTP Server.
Jan 14 23:08:20 mail systemd: Reloaded The Apache HTTP Server.
Jan 14 23:08:20 mail systemd: Reloading.
Jan 14 23:08:20 mail esmith::event[16487]: [INFO] service tomcat8@webtop restart
Jan 14 23:08:20 mail systemd: Stopping Apache Tomcat 8 Web Application Container…
Jan 14 23:08:21 mail systemd: Stopped Apache Tomcat 8 Web Application Container.
Jan 14 23:08:21 mail systemd: Starting Apache Tomcat 8 Web Application Container…
Jan 14 23:08:21 mail systemd: Started Apache Tomcat 8 Web Application Container.
Jan 14 23:08:21 mail systemd: Reloading.
Jan 14 23:08:22 mail esmith::event[16487]: [INFO] service rh-php72-php-fpm restart
Jan 14 23:08:22 mail systemd: Stopping The PHP FastCGI Process Manager…
Jan 14 23:08:22 mail systemd: Stopped The PHP FastCGI Process Manager.
Jan 14 23:08:22 mail systemd: Starting The PHP FastCGI Process Manager…
Jan 14 23:08:22 mail systemd: Started The PHP FastCGI Process Manager.
Jan 14 23:08:22 mail esmith::event[16487]: Action: /etc/e-smith/events/actions/adjust-services SUCCESS [3.626204]
Jan 14 23:08:22 mail esmith::event[16487]: Event: nethserver-webtop5-update SUCCESS

The user is the same as the Webtop login.

imagem

I’m still getting the same error. We need to call @lucag again :slight_smile:

EDIT: https://issues.sonicle.com/projects/WTCLOUD/issues/WTCLOUD-22?filter=allopenissues
There is already an opened bug… does your password contains # char?

1 Like

Yes. There is an # on the password.

Could you try to change that password and then retry configuration on Webtop?

I did.
Problem n.º 2 solved.

Now all that remains is the question of not being able to create contacts.