WebTop4 and Samba4 AD on NS 7

[alefattorini (Alessio Fattorini)]

@GG_jr

I decided to start this topic because of some facts that have happened in the last few months:- The decision made by Inverse regarding SOGo.- The decision made by Nethesis to use WebTop as the main email groupware app on NS 7.- Samba4 Active Directory on NS 7.

Thanks for your help man, your contributions here are huge!
You definitely deserve the Tireless Beta Tester Badge every day

[GG_jr (Gabriel GHEORGHIU)]

Hi @giacomo ,

Do you think I should wait you to try to find a solution for this situation (maybe it could happen again in the future), or can I reinstall NS from scratch to continuing the tests?

Maybe I could avoid to reinstall NS and I could remove WebTop “in all” (webTop and all dependencies) so after that to reinstall it from Software center?

Can you tell me how to do that?
If I remove WebTop from Software center, will remove only WebTop without removing PGSQL, Tomcat, …

TIA,
Gabriel

[giacomo (Giacomo Sanchietti)]

I just created a pull request (and the rpm in testing) which should fix the problem:

Fix domain configuration and avoid errors during db creation.

You can remove webtop4 with the following commands:

systemctl stop tomcat
su - postgres  -c "psql -c 'drop database webtop'"
rpm -e nethserver-webtop4

[GG_jr (Gabriel GHEORGHIU)]

@giacomo

You can remove webtop4 with the following commands:

systemctl stop tomcat
su - postgres -c “psql -c ‘drop database webtop’”
rpm -e nethserver-webtop4

It works!

Thank you!
Now, I can continue the tests!

[giacomo (Giacomo Sanchietti)]

I just released the update, it will be available since tomorrow

[GG_jr (Gabriel GHEORGHIU)]

@giacomo

You don’t need it (@davidep please correct me if I’m wrong).

Indeed, I don’t need it!

EDIT: Some simple send/receive tests, from WAN (outside), with WebTop:

• From WebTop web client: send/receive emails without issues
• Outlook 2013: IMAP/POP3 account: send/receive emails without issues

Errors in /var/log/maillog (the users exist and I can send/receive emails from these accounts):

…
Sep 14 23:25:37 pdc-ad postfix/lmtp[10695]: 2C88F41E72EC: to=test@test.abt.ro, relay=pdc-ad.test.abt.ro[/var/run/dovecot/lmtp], delay=0.32, delays=0.05/0.02/0.06/0.19, dsn=2.0.0, status=sent (250 2.0.0 test@test.abt.ro 1787EUGy2VfIKQAAIdkCLg Saved)
Sep 14 23:25:37 pdc-ad dovecot: lmtp(10696): Disconnect from local: Successful quit
Sep 14 23:25:37 pdc-ad postfix/qmgr[5790]: 2C88F41E72EC: removed
Sep 14 23:25:48 pdc-ad dovecot: auth: Error: userdb(test,127.0.0.1,<EE6eiH089gB/AAAB>): user not found from any userdbs
Sep 14 23:25:48 pdc-ad dovecot: auth: Error: userdb(administrator,127.0.0.1,<W67biH08+AB/AAAB>): user not found from any userdbs
Sep 14 23:27:54 pdc-ad dovecot: auth: Error: userdb(test,127.0.0.1,<JPMikH08DAB/AAAB>): user not found from any userdbs
Sep 14 23:27:54 pdc-ad dovecot: auth: Error: userdb(administrator,127.0.0.1,<tbxgkH08EAB/AAAB>): user not found from any userdbs
Sep 14 23:28:57 pdc-ad postfix/anvil[10683]: statistics: max connection rate 1/60s for (smtp:209.85.214.48) at Sep 14 23:25:34
Sep 14 23:28:57 pdc-ad postfix/anvil[10683]: statistics: max connection count 1 for (smtp:209.85.214.48) at Sep 14 23:25:34
Sep 14 23:28:57 pdc-ad postfix/anvil[10683]: statistics: max cache size 1 at Sep 14 23:25:34
Sep 14 23:30:00 pdc-ad dovecot: auth: Error: userdb(test,127.0.0.1,<i5Oil308JAB/AAAB>): user not found from any userdbs
Sep 14 23:30:00 pdc-ad dovecot: auth: Error: userdb(administrator,127.0.0.1,<E3ngl308JgB/AAAB>): user not found from any userdbs
Sep 14 23:32:06 pdc-ad dovecot: auth: Error: userdb(test,127.0.0.1,<zbUnn308OgB/AAAB>): user not found from any userdbs
Sep 14 23:32:06 pdc-ad dovecot: auth: Error: userdb(administrator,127.0.0.1,<ynxln308PAB/AAAB>): user not found from any userdbs
Sep 14 23:34:12 pdc-ad dovecot: auth: Error: userdb(test,127.0.0.1,<xLOspn08UAB/AAAB>): user not found from any userdbs
Sep 14 23:34:12 pdc-ad dovecot: auth: Error: userdb(administrator,127.0.0.1,<mXrqpn08UgB/AAAB>): user not found from any userdbs
Sep 14 23:35:35 pdc-ad clamd[1087]: SelfCheck: Database status OK.
Sep 14 23:36:18 pdc-ad dovecot: auth: Error: userdb(test,127.0.0.1,<9hEqrn08ZgB/AAAB>): user not found from any userdbs
Sep 14 23:36:18 pdc-ad dovecot: auth: Error: userdb(administrator,127.0.0.1,<P9pnrn08aAB/AAAB>): user not found from any userdbs
…

cc: @gabriele_bulfon

In
WebTop Admin → Domains → NethServer → Users
I can see the users that I have created in NS Samba AD Users and groups
but in
WebTop Admin → Domains → NethServer → Groups
I cannot see the groups that I have created in NS Samba AD Users and groups.

It’s normal?

In WebTop web client, when I compose a new mail, is possible to see in To: drop down list the domain user accounts, automatically, not only the email accounts for already sended emails?

TIA,
Gabriel

[gabriele_bulfon]

Webtop groups are not domain groups, at the moment.
They’re just an internal group management to allow for faster assign of shares and so on.

Also, the recipient suggestion will lookup personal and shared contacts, and autoamtically learned contacts.
The users database is not looked up at the moment.
This will surely be available in WT5, but we’re also considering an update to WT4.5

Gabriele

[GG_jr (Gabriel GHEORGHIU)]

@gabriele_bulfon

Webtop groups are not domain groups, at the moment.They’re just an internal group management to allow for faster assign of shares and so on.

Also, the recipient suggestion will lookup personal and shared contacts, and autoamtically learned contacts.The users database is not looked up at the moment.This will surely be available in WT5, but we’re also considering an update to WT4.5

Gabriele

Thank you Gabriele!

I look forward for WebTop5!

Kind regards,
Gabriel

[davidep (Davide Principi)]

@GG_jr

Error: userdb(administrator,127.0.0.1,): user not found from any userdbs

@gabriele_bulfon I have the same error on my VM here. It seems like a background process tries to authenticate every 2 minutes, but the username is wrong because it is missing the @domain suffix.

On the other hand, if I authenticate on webtop I can read the mailbox without any problem.

[gabriele_bulfon]

Is it always the administrator?

[davidep (Davide Principi)]

No on my machine I have a “davidep” account, similar lines, please note also the managesieve access is correct.

Sep 15 11:39:50 vm5 dovecot: managesieve-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=6152, secured, session=
Sep 15 11:39:50 vm5 dovecot: managesieve(davidep@dpnet.nethesis.it): Disconnected: Logged out bytes=18/98
Sep 15 11:40:05 vm5 dovecot: auth: Error: userdb(davidep,127.0.0.1,): user not found from any userdbs
Sep 15 11:42:11 vm5 dovecot: auth: Error: userdb(davidep,127.0.0.1,<4G21qIg8OgB/AAAB>): user not found from any userdbs
Sep 15 11:44:17 vm5 dovecot: auth: Error: userdb(davidep,127.0.0.1,): user not found from any userdbs
Sep 15 11:46:23 vm5 dovecot: auth: Error: userdb(davidep,127.0.0.1,): user not found from any userdbs
Sep 15 11:48:29 vm5 dovecot: auth: Error: userdb(davidep,127.0.0.1,): user not found from any userdbs
Sep 15 11:50:35 vm5 dovecot: auth: Error: userdb(davidep,127.0.0.1,): user not found from any userdbs
Sep 15 11:52:41 vm5 dovecot: auth: Error: userdb(davidep,127.0.0.1,): user not found from any userdbs
Sep 15 11:54:47 vm5 dovecot: auth: Error: userdb(davidep,127.0.0.1,): user not found from any userdbs
Sep 15 11:56:53 vm5 dovecot: auth: Error: userdb(davidep,127.0.0.1,): user not found from any userdbs
Sep 15 11:58:59 vm5 dovecot: auth: Error: userdb(davidep,127.0.0.1,): user not found from any userdbs

[gabriele_bulfon]

does this happen while the user is logged off or starts once the user logs in?

[davidep (Davide Principi)]

My session seems expired, but those lines still appear…

[GG_jr (Gabriel GHEORGHIU)]

@gabriele_bulfon

does this happen while the user is logged off or starts once the user logs in?

Both situations.

Here, everything was logged off (during night).

[gabriele_bulfon]

I don’t see this happening on the test machine we use in common with Nethesis.
Can you check if this logging stops when you stop tomcat?
We need to be sure it’s coming from tomcat and not another daemon.

[GG_jr (Gabriel GHEORGHIU)]

@gabriele_bulfon

I don’t see this happening on the test machine we use in common with Nethesis.Can you check if this logging stops when you stop tomcat?We need to be sure it’s coming from tomcat and not another daemon.

Please, give me couple of minutes.

In the meantime … (the email error is for @davidep )

[GG_jr (Gabriel GHEORGHIU)]

@gabriele_bulfon

I don’t see this happening on the test machine we use in common with Nethesis.Can you check if this logging stops when you stop tomcat?We need to be sure it’s coming from tomcat and not another daemon.

Done!

I have stopped/started Tomcat service from NS → Services → Tomcat : Stop/Start.

Between these “commands”, there is no error.

[davidep (Davide Principi)]

@gabriele_bulfon

I don’t see this happening on the test machine we use in common with Nethesis.

I guess it is a ns6 installation! On ns7 the Unix (and IMAP) user names have the @domain suffix.

[gabriele_bulfon]

So, looks like it’s not coming from Webtop.

[davidep (Davide Principi)]

@gabriele_bulfon

So, looks like it’s not coming from Webtop.

On the contrary, I confirm the login attempts stop when tomcat is stopped and start again when tomcat is started.

It looks like a “background” worker process…