Webtop DB Error

Tiago · January 12, 2020, 2:26pm

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 “WebTop 5 — NethServer 7 Final”
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

federico.ballarini · January 12, 2020, 3:23pm

Check for Webtop5 updates and tell us what happens.

Tiago · January 12, 2020, 3:48pm

In Software center I have no updates.

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

federico.ballarini · January 12, 2020, 5:12pm

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.

Tiago · January 12, 2020, 5:28pm

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

federico.ballarini · January 12, 2020, 5:29pm

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?

Tiago · January 12, 2020, 5:39pm

Yes. Same error.

federico.ballarini · January 12, 2020, 5:44pm

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

Tiago · January 12, 2020, 5:48pm

federico.ballarini · January 12, 2020, 5:52pm

Maybe @lucag can help you

Tiago · January 12, 2020, 5:58pm

Thanks for your time.

lucag · January 14, 2020, 10:49am

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 … 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

Tiago · January 14, 2020, 10:29pm

First problem solved.

Any ideas about problem n.º2 ?

federico.ballarini · January 14, 2020, 10:58pm

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

Tiago · January 14, 2020, 11:18pm

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

Tiago · January 14, 2020, 11:26pm

The user is the same as the Webtop login.

imagem

federico.ballarini · January 14, 2020, 11:31pm

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

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

Tiago · January 14, 2020, 11:37pm

Yes. There is an # on the password.

federico.ballarini · January 14, 2020, 11:38pm

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

Tiago · January 14, 2020, 11:56pm

I did.
Problem n.º 2 solved.

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