fixed issue with missing bracket

I just realised that in my last patch a bracket was missing.
Sorry for that - here's the fix for it.

See merge request !512

add suport for Red Hat Software Collections and named-chroot

These patches will add suport for newer Apache webserver from Red Hat Software collections as well as support for running bind in chroot environments.

See merge request !509

revert changes to postfix-config to prevent break the smtp-protocol



See merge request !508

Introduced new -processing- state for remote actions. The -processing- state is set by long running background actions to allow the action procedure to proceed with the next action.

Fixed "Wrong QuerySQL-Query" in aps_installer

`db->queryOneRecord` does add `LIMIT 0,1` to the end of the statement resulting in a syntax error due to the misplaced semicolon:

`Thu Jan 12 21:41:01 CET 2017 12.01.2017-20:41 - WARNING - Falsche Anfrage / Wrong QuerySQL-Query = SELECT VERSION() as ver; LIMIT 0,1 -> 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,1' at line 1)`

See merge request !504

Fixed NameVirtualHost-Info, Normalized Welcome Messages and removed Version infos

Warning:
I think Apache will currently not listen to custom port numbers set in IPs. This is confirmed on my test environment!
This issue also exists in current 3.1 release! (Will open an issue)

See merge request !503

Warning: Please read Merge Request! This might cause Apache not to listen on custom ports!

Fix Issue #4402 - install/update when MySQL server is on custom port



See merge request !502

Kind of Security: Bind9 should not tell its version into public



See merge request !500

interject login button

Submit button should be on the right.

See merge request !499

Autoupgrade switched to apt-get and fixed abug which will likely break this completely on gentoo!

fixed #4397 

One more question... What about RedHat-Derivates?
In current code they would also run apt-get but depend on yum... (nothing changed here)

See merge request !498

prevent duplicate LIMIT in sql-class - Fixes #4384



See merge request !496

Implement Issue #4357

Shows last ip that was used to login successfully with this useraccount.
Logins from admins using loginAs are ignored

Implementiert Issue #4357
Zeigt die IP-Adresse des letzten erfolgreichen Logins auf dem Dashboard an.
Verändert die gespeicherte IP-Adresse nicht, wenn man sich via "Einloggen als" angemeldet hat.

Needed Database-Changes:
```
ALTER TABLE `sys_user` ADD `last_login_ip` VARCHAR(50) NULL AFTER `lost_password_reqtime`;
ALTER TABLE `sys_user` ADD `last_login_at` BIGINT(20) NULL AFTER `last_login_ip`;
```

Tested/Working on Ubuntu 16.04 LTS

See merge request !493

Shows last ip that was used to login successfully with this useraccount.
Logins from admins using loginAs are ignored

Implementiert Issue #4357
Zeigt die IP-Adresse des letzten erfolgreichen Logins auf dem Dashboard an.
Verändert die gespeicherte IP-Adresse nicht, wenn man sich via "Einloggen als" angemeldet hat.

Needed Database-Changes:

ALTER TABLE `sys_user` ADD `last_login_ip` VARCHAR(50) NULL AFTER `lost_password_reqtime`;
ALTER TABLE `sys_user` ADD `last_login_at` BIGINT(20) NULL AFTER `last_login_ip`;

Tested/Working on Ubuntu 16.04 LTS

various fix

fix ipv6 auth compatibility for `attempts_login` table and `auth.log` file (Now ipv6 is supported for attempts login verification and log file (which can be used by fail2ban unstable))

fix XMPP correct nameserver server_id for DNS RR creation/modification

fix XMPP correct Jabber ID field in XMPP Account page

fix XMPP anonymous

-REVERT fix Let's Encrypt web domain alias support

See merge request !486

Letsencrypt enhanced generation and logs

Signed-off-by: Kristián Feldsam <feldsam@gmail.com>

See merge request !491

Signed-off-by: Kristián Feldsam <feldsam@gmail.com>

fixed last commit



See merge request !490

Stable 3.1



See merge request !489