thx for this tip, @m.traeumner. So, to sum it up. Advice is to:
I’ll see if I have time for this tonight, otherwise it will be later this week. I’ll report back.
Hi Rolf,
I think you can restore only the dumpfile with commandline. To restore a single file have a look at the documentation:
For restoring the database from dumpfile have a look here:
Before doing the restore, could you please see if is there something relevant inside Tomcat logs:
``
journalctl -u tomcat@webtop
Is this a new installation or an updated one?
@webtop_team what can we inspect?strangely (?) the log doesn’t give any output when trying to logon as admin (19:40 local time):
Nov 05 17:06:04 helium.rolfbakker.nl server[12068]: Nov 05, 2017 5:06:04 PM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 05 17:06:04 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
Nov 05 17:10:02 helium.rolfbakker.nl sudo[10537]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 17:14:50 helium.rolfbakker.nl server[12068]: Nov 05, 2017 5:14:50 PM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 05 17:14:50 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
Nov 05 17:40:47 helium.rolfbakker.nl server[12068]: Nov 05, 2017 5:40:47 PM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 05 17:40:47 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
Nov 05 18:02:54 helium.rolfbakker.nl sudo[14000]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 18:32:05 helium.rolfbakker.nl server[12068]: Nov 05, 2017 6:32:05 PM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 05 18:32:05 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
Nov 05 18:32:25 helium.rolfbakker.nl server[12068]: Nov 05, 2017 6:32:25 PM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 05 18:32:25 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
Nov 05 18:35:35 helium.rolfbakker.nl server[12068]: Nov 05, 2017 6:35:35 PM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 05 18:35:35 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
Nov 05 18:38:24 helium.rolfbakker.nl sudo[17040]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 18:38:29 helium.rolfbakker.nl sudo[17047]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 18:38:29 helium.rolfbakker.nl server[12068]: Nov 05, 2017 6:38:29 PM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 05 18:38:29 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
Nov 05 18:53:36 helium.rolfbakker.nl sudo[19195]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 18:53:40 helium.rolfbakker.nl sudo[19218]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 18:53:53 helium.rolfbakker.nl sudo[19242]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 18:54:34 helium.rolfbakker.nl sudo[19285]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 18:54:38 helium.rolfbakker.nl sudo[19297]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 19:08:10 helium.rolfbakker.nl server[12068]: Nov 05, 2017 7:08:10 PM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 05 19:08:10 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
Nov 05 21:50:45 helium.rolfbakker.nl sudo[30855]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 21:50:49 helium.rolfbakker.nl sudo[30862]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 21:50:59 helium.rolfbakker.nl sudo[30883]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 05 22:19:15 helium.rolfbakker.nl server[12068]: Nov 05, 2017 10:19:15 PM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 05 22:19:15 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
Nov 06 08:13:05 helium.rolfbakker.nl server[12068]: Nov 06, 2017 8:13:05 AM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 06 08:13:05 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
Nov 06 13:10:49 helium.rolfbakker.nl sudo[22204]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 06 13:10:52 helium.rolfbakker.nl sudo[22211]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 06 13:11:04 helium.rolfbakker.nl sudo[22244]: tomcat : TTY=unknown ; PWD=/usr/share/tomcat ; USER=root ; COMMAND=/usr/share/webtop/z-push/z-push-admin.php -a l
Nov 06 14:51:41 helium.rolfbakker.nl server[12068]: Nov 06, 2017 2:51:41 PM org.jivesoftware.smackx.ping.PingManager pingServerIfNecessary
Nov 06 14:51:41 helium.rolfbakker.nl server[12068]: WARNING: XMPPConnection was not authenticated
It’s an updated server, no fresh install.
root@helium:logs> $ rpm -qa|egrep -i ‘webtop|tomcat’
nethserver-webtop5-1.1.5-1.ns7.noarch
tomcat-servlet-3.0-api-7.0.76-3.el7_4.noarch
webtop5-zpush-1.1.1-1.ns7.noarch
webtop5-libs-1.1.4-1.ns7.noarch
webtop5-core-1.1.5-1.1.g015fc4a.ns7.noarch
tomcat-jsp-2.2-api-7.0.76-3.el7_4.noarch
tomcat-lib-7.0.76-3.el7_4.noarch
tomcat-el-2.2-api-7.0.76-3.el7_4.noarch
tomcat-7.0.76-3.el7_4.noarch
any more info needed?
Sorry for the delay, I don’t have any idea 
Did you solve? If not, please feel free to ping again the webtop team group.
Nope, did not solve. No idea. Luckily it isn’t blocking. Just annoying…
OK, after receiving a mail announcing a new webtop release, I bump this topic. Please @webtop_team have a look again.
In the documentation, a fix is mentioned for the blank screen. Execute a sql-statement to update your webtop db.
When I understand the script right, I’m supposed to edit the table core.users_info in such a way that the admin user gets a e-mailaddress @mydomain.tld
When listing the content of that table, the admin users has admin@localhost. So, the problem to be fixed appears to be there.
However, the UPDATE statement doesn’t return any result. I guess because the SELECT is looking for ‘admin’ with domain_id “Nethserver” and on my machine it is “*”.
My core.users_info table look like:
webtop5=# SELECT domain_id, user_id, email FROM core.users_info ;
domain_id | user_id | email
------------±--------±---------------------
NethServer | test | test@mydomain.nl
'* | admin | admin@localhost
NethServer | joris | joris@mydomain.nl
NethServer | rolf | rolf@mydomain.nl
NethServer | judith | judith@mydomain.nl
(5 rows)
<EDIT: made a smaller selection of above table for better readability. quote before * in the admin-line is because the website interpreted the * as a bullet>
Can I edit the sql-script, leave out the “users_info.domain_id = ‘NethServer’” part? Or should I update the domain_id also?
Please advice, keeping in mind that I’m no sql-hero; I feel comfortable enough to play around with SELECT, but I’m a bit nervous when it comes to UPDATE…
thanks!
Hi @rolf,
In this table there should be two different user_id = ‘admin’.
The one with domain_id = ‘*’ which has an email value for defualt = ‘admin @ localhost’ is related to the WebTop admin with which to access the administrative panel, while the domain_id = ‘NethServer’ and email = ’ admin@domain.tld 'is the admin user taken from the system user base.
It’s correct, you do not have to change the update statement.
Your table is missing the system admin user you need to create on the server-manager in users and groups.
The line with user_id = ‘admin’ and ‘domain_id =’ * 'should be left unchanged otherwise you will have difficulty accessing the WebTop admin panel.
What is reported in the manual here refers to any problems of login with the system admin user (admin@domain.tld) in the case in which this user_id results with the empty email field
I hope I managed to clarify the situation of the two admin 
Hi Luca,
thanks for clarifying.
When I look at the admin-panel, section users and groups, I see (apart from myself and my family):
Can you please advice?Should I add the admin@mydomain.tld manually to the webtop db? Or anything else to do?
It’s quite strange, thus if admin WebTop user works, it’s the only one you usually need.
You should not change the db directly, but you could try to resync using:
signal-event nethserver-webtop5-update
thanks.
When applying the signal-event command, nothing changes in the db-table; still the same as my listing in post 15 (5 rows, one admin with a localhost mailaddress.)
So, that didn’t help me.
How can I check if the admin & administrator are OK in the accountsprovider AD in the first place?
When looking in the system-panel, they are both present. But I can’t see many details.
‘admin’ is there, member of no groups (is that correct?)
‘administrator’ is there,mmber of domain admins group.
anything else to check?
Forgive the trivial question 
:
The system admin user has been enabled on server manager?
Is it grayed in the user list?
Can you regularly access the server manager on port 980 with this admin user?
sorry for late reaction: birthday, flu and an extensive course kept me busy.
Yes, the admin-user is active, and I can use it for accessing the managemt-GUI with it.
Hi @rolf,
I’m sorry for the delay in my reply, but I have some news for you 
I happened to find your same problem on an installation.
I realized that there were two different versions of java (1.7.0 and 1.8.0).
You can check if you have this situation in your case:
rpm -qa|grep java
If you find the two versions 1.7.0 and 1.8.0 installed you have to remove 1.8.0:
yum remove java-1.8.0*
then restart the tomcat instance so as to start it with the correct version:
systemctl restart tomcat@webtop
Doing so in my case I solved.
Check to see if this also resolves your problem.
yes, thanks, this was the solution!
(But now I have to think what on my system is depending on java 8…) 
I require java 1.8.0 for the nethserver-savapage package. I tested both, webtop and savapage, and didn’t experience problems. Is it a kind of one time error that happens under special circumstances or does Webtop have problems with java 1.8.0?
It seems that webtop has problems with the java-1.8.0 version.
What do you think @gabriele_bulfon ?
Can you find a way to run webtop 5 regularly even with java-1.8.0 version ?
Hi to all,
read this thread and read about java 1.7 and 1.8 with problems.
What is about java 1.9, version nine was released last year. Somebody tried it?
The centos repos provide openjdk 6 to 8 (1.8.0) actually.