Debian 9.4 stretch 32 bit und MariaDB

[MKEurope]

Hallo Leute. Bin neu hier, also verzeiht mir wenn ich eine blöde frage stelle, die evt. schon irgendwo gestellt wurde.
Ich habe versucht KH auf eine virtuellen Xen zu installieren.
Drauf ist Debian 9.4 stertch.
Leider bekomme ich immer den Fehler bei der MariaDB. Dort steht bei der Installation immer ein ERROR.
Dann habe ich versucht die MariaDB per hand zu installieren. Dazu habe ich MYSQL deinstalliert.
Die Installation von MariaDB funktionierte auch einwandfrei.
Bei der Installation von KH kam dann aber der Fehler "kein zugriff auf vorhandene MariaDB"

Ich bin am verzweifeln.
Hat jemand eine Idee ?

[Martin]

Hallo,

welcher genaue Fehler wird in der /var/log/keyhelp/install.log angegeben?

Grundsätzlich ist es empfehlenswert ein 64Bit System zu nutzen.

[MKEurope]

ich füge einfach mal alles an.



(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 44273 files and directories currently installed.)
Preparing to unpack .../00-gawk_1%3a4.1.4+dfsg-1_i386.deb ...
Unpacking gawk (1:4.1.4+dfsg-1) ...
Selecting previously unselected package mysql-common.
Preparing to unpack .../01-mysql-common_5.8+1.0.2_all.deb ...
Unpacking mysql-common (5.8+1.0.2) ...
Selecting previously unselected package mariadb-common.
Preparing to unpack .../02-mariadb-common_10.1.26-0+deb9u1_all.deb ...
Unpacking mariadb-common (10.1.26-0+deb9u1) ...
Selecting previously unselected package galera-3.
Preparing to unpack .../03-galera-3_25.3.19-2_i386.deb ...
Unpacking galera-3 (25.3.19-2) ...
Selecting previously unselected package libdbi-perl.
Preparing to unpack .../04-libdbi-perl_1.636-1+b1_i386.deb ...
Unpacking libdbi-perl (1.636-1+b1) ...
Selecting previously unselected package libaio1:i386.
Preparing to unpack .../05-libaio1_0.3.110-3_i386.deb ...
Unpacking libaio1:i386 (0.3.110-3) ...
Selecting previously unselected package libreadline5:i386.
Preparing to unpack .../06-libreadline5_5.2+dfsg-3+b1_i386.deb ...
Unpacking libreadline5:i386 (5.2+dfsg-3+b1) ...
Selecting previously unselected package mariadb-client-core-10.1.
Preparing to unpack .../07-mariadb-client-core-10.1_10.1.26-0+deb9u1_i386.deb ...
Unpacking mariadb-client-core-10.1 (10.1.26-0+deb9u1) ...
Selecting previously unselected package libjemalloc1.
Preparing to unpack .../08-libjemalloc1_3.6.0-9.1_i386.deb ...
Unpacking libjemalloc1 (3.6.0-9.1) ...
Selecting previously unselected package mariadb-client-10.1.
Preparing to unpack .../09-mariadb-client-10.1_10.1.26-0+deb9u1_i386.deb ...
Unpacking mariadb-client-10.1 (10.1.26-0+deb9u1) ...
Selecting previously unselected package mariadb-server-core-10.1.
Preparing to unpack .../10-mariadb-server-core-10.1_10.1.26-0+deb9u1_i386.deb ...
Unpacking mariadb-server-core-10.1 (10.1.26-0+deb9u1) ...
Selecting previously unselected package socat.
Preparing to unpack .../11-socat_1.7.3.1-2+deb9u1_i386.deb ...
Unpacking socat (1.7.3.1-2+deb9u1) ...
Setting up mysql-common (5.8+1.0.2) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Setting up mariadb-common (10.1.26-0+deb9u1) ...
update-alternatives: using /etc/mysql/mariadb.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mariadb-server-10.1.
(Reading database ...
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 44822 files and directories currently installed.)
Preparing to unpack .../0-mariadb-server-10.1_10.1.26-0+deb9u1_i386.deb ...
Unpacking mariadb-server-10.1 (10.1.26-0+deb9u1) ...
Selecting previously unselected package libcgi-pm-perl.
Preparing to unpack .../1-libcgi-pm-perl_4.35-1_all.deb ...
Unpacking libcgi-pm-perl (4.35-1) ...
Selecting previously unselected package libfcgi-perl.
Preparing to unpack .../2-libfcgi-perl_0.78-2_i386.deb ...
Unpacking libfcgi-perl (0.78-2) ...
Selecting previously unselected package libcgi-fast-perl.
Preparing to unpack .../3-libcgi-fast-perl_1%3a2.12-1_all.deb ...
Unpacking libcgi-fast-perl (1:2.12-1) ...
Selecting previously unselected package libmariadbclient18:i386.
Preparing to unpack .../4-libmariadbclient18_10.1.26-0+deb9u1_i386.deb ...
Unpacking libmariadbclient18:i386 (10.1.26-0+deb9u1) ...
Selecting previously unselected package libdbd-mysql-perl.
Preparing to unpack .../5-libdbd-mysql-perl_4.041-2_i386.deb ...
Unpacking libdbd-mysql-perl (4.041-2) ...
Selecting previously unselected package libhtml-template-perl.
Preparing to unpack .../6-libhtml-template-perl_2.95-2_all.deb ...
Unpacking libhtml-template-perl (2.95-2) ...
Selecting previously unselected package libterm-readkey-perl.
Preparing to unpack .../7-libterm-readkey-perl_2.37-1_i386.deb ...
Unpacking libterm-readkey-perl (2.37-1) ...
Selecting previously unselected package mariadb-server.
Preparing to unpack .../8-mariadb-server_10.1.26-0+deb9u1_all.deb ...
Unpacking mariadb-server (10.1.26-0+deb9u1) ...
Setting up libjemalloc1 (3.6.0-9.1) ...
Setting up socat (1.7.3.1-2+deb9u1) ...
Setting up libmariadbclient18:i386 (10.1.26-0+deb9u1) ...
Setting up gawk (1:4.1.4+dfsg-1) ...
Setting up libterm-readkey-perl (2.37-1) ...
Processing triggers for libc-bin (2.24-11+deb9u3) ...
Setting up libaio1:i386 (0.3.110-3) ...
Setting up galera-3 (25.3.19-2) ...
Processing triggers for systemd (232-25+deb9u2) ...
Setting up libcgi-pm-perl (4.35-1) ...
Processing triggers for man-db (2.7.6.1-2) ...
Setting up libreadline5:i386 (5.2+dfsg-3+b1) ...
Setting up libfcgi-perl (0.78-2) ...
Setting up libdbi-perl (1.636-1+b1) ...
Setting up mariadb-server-core-10.1 (10.1.26-0+deb9u1) ...
Setting up libhtml-template-perl (2.95-2) ...
Setting up mariadb-client-core-10.1 (10.1.26-0+deb9u1) ...
Setting up libcgi-fast-perl (1:2.12-1) ...
Setting up libdbd-mysql-perl (4.041-2) ...
Setting up mariadb-client-10.1 (10.1.26-0+deb9u1) ...
Setting up mariadb-server-10.1 (10.1.26-0+deb9u1) ...
Created symlink /etc/systemd/system/mysql.service → /lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /lib/systemd/system/mariadb.service.
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
mariadb.service couldn't start.
Setting up mariadb-server (10.1.26-0+deb9u1) ...
Processing triggers for libc-bin (2.24-11+deb9u3) ...
Processing triggers for systemd (232-25+deb9u2) ...
files | /home/keyhelp/www/keyhelp/install/config/common/database/tuning_low_mem.cnf => /etc/mysql/mariadb.conf.d/90-tuning.cnf
files | /home/keyhelp/www/keyhelp/install/config/common/database/mariadb.cnf => /etc/mysql/conf.d/mariadb.cnf
exec | service mysql restart
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

>>>>>>>>>>>>>>>>>>>>>>
!!! ERROR DETECTED !!!
<<<<<<<<<<<<<<<<<<<<<<

[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `mysql`.`user` SET `Password` = PASSWORD('***DB_SETUP_PASS***') WHERE `User` = 'root'
[SKIPPED DUE PREVIOUS ERRORS] db | DELETE FROM `mysql`.`user` WHERE `User` = 'root' AND `Host` NOT IN ('localhost', '127.0.0.1', '::1')
[SKIPPED DUE PREVIOUS ERRORS] db | DELETE FROM `mysql`.`user` WHERE `User` = ''
[SKIPPED DUE PREVIOUS ERRORS] db | DROP DATABASE IF EXISTS `test`
[SKIPPED DUE PREVIOUS ERRORS] db | FLUSH PRIVILEGES
[SKIPPED DUE PREVIOUS ERRORS] db | GRANT ALL PRIVILEGES ON *.* TO 'mysqladmin'@'localhost' IDENTIFIED BY '***DB_SETUP_PASS***' WITH GRANT OPTION

[KeyHelp]
exec | chmod 0750 /home/keyhelp
exec | chown keyhelp:keyhelp /home/keyhelp/www/cgi-bin
exec | chown keyhelp:keyhelp /home/keyhelp/www/kh.webstats
exec | chown -h keyhelp:keyhelp /home/keyhelp/www/webmail
exec | chgrp www-data /home/keyhelp
exec | usermod -aG www-data keyhelp
exec | groupadd --force keyhelp_nossh
exec | groupadd --force keyhelp_noftp
exec | groupadd --force kh_suspended
exec | mkdir -p -m 0700 /etc/keyhelp/
exec | mkdir -p -m 0700 /etc/keyhelp/config
exec | mkdir -p -m 0700 /etc/keyhelp/skel
exec | chown keyhelp:keyhelp -R /etc/keyhelp/
exec | mkdir -p -m 0755 /usr/local/keyhelp/
files | /home/keyhelp/www/keyhelp/install/config/common/sudoers/keyhelp => /etc/sudoers.d/keyhelp
files | /home/keyhelp/www/keyhelp/install/config/common/keyhelp/config.json => /etc/keyhelp/config/config.json
files | /home/keyhelp/www/keyhelp/install/config/common/keyhelp/skel.readme => /etc/keyhelp/skel/readme.txt
files | /home/keyhelp/www/keyhelp/install/config/common/bin/call_url => /usr/local/keyhelp/call_url
files | /home/keyhelp/www/keyhelp/install/config/common/bin/anonymize_ip => /usr/local/keyhelp/anonymize_ip
db | DROP DATABASE IF EXISTS `keyhelp`
MySQL - Query Error: ()

>>>>>>>>>>>>>>>>>>>>>>
!!! ERROR DETECTED !!!
<<<<<<<<<<<<<<<<<<<<<<

[SKIPPED DUE PREVIOUS ERRORS] db | CREATE DATABASE `keyhelp`
[SKIPPED DUE PREVIOUS ERRORS] db | GRANT ALL PRIVILEGES ON keyhelp.* TO 'keyhelp'@'localhost' IDENTIFIED BY '***DB_KH_PASS***'
[SKIPPED DUE PREVIOUS ERRORS] db | GRANT ALL PRIVILEGES ON *.* TO 'keyhelp_root'@'localhost' IDENTIFIED BY '***DB_KH_ROOT_PASS***' WITH GRANT OPTION
[SKIPPED DUE PREVIOUS ERRORS] db | FLUSH PRIVILEGES
[SKIPPED DUE PREVIOUS ERRORS] exec | mysql -u'root' 'keyhelp' < /home/keyhelp/www/keyhelp/install/keyhelp.sql
[SKIPPED DUE PREVIOUS ERRORS] exec | chmod 0440 /etc/sudoers.d/keyhelp
[SKIPPED DUE PREVIOUS ERRORS] exec | chmod 0600 /etc/keyhelp/config/config.json
[SKIPPED DUE PREVIOUS ERRORS] exec | chown keyhelp:keyhelp /etc/keyhelp/config/config.json
[SKIPPED DUE PREVIOUS ERRORS] exec | chown keyhelp:keyhelp /etc/keyhelp/skel
[SKIPPED DUE PREVIOUS ERRORS] exec | chmod +x /usr/local/keyhelp/call_url
[SKIPPED DUE PREVIOUS ERRORS] exec | chmod +x /usr/local/keyhelp/anonymize_ip
[SKIPPED DUE PREVIOUS ERRORS] db | INSERT INTO `keyhelp`.`ssl_certificates` (`id`, `name`, `file_name` ) VALUES('1', 'default', 'default');
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = '317477afcb8755180d08f4402c0bf91bf6e1ab2eee4373bb0fb73034fe9f6760c0a09af3290a5b2664d236360729354875f371d05d0f90bdf3cfb707799a9c5c' WHERE `category` = 'general' AND `name` = 'keyhelp_id'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = 'https://***HOSTNAME***' WHERE `category` = 'general' AND `name` = 'panelurl'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = '***HOSTNAME***' WHERE `category` = 'general' AND `name` = 'hostname'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = 'Michael.kailuweit@t-online.de' WHERE `category` = 'general' AND `name` = 'admin_email'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = 'ns.***HOSTNAME***,ns2.***HOSTNAME***' WHERE `category` = 'dns' AND `name` = 'nameserver'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = '***IP_0***,***IP_1***' WHERE `category` = 'dns' AND `name` = 'ips'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = '18.1.1' WHERE `category` = 'sys' AND `name` = 'version'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = 'https://***HOSTNAME***/phpmyadmin/' WHERE `category` = 'phpmyadmin' AND `name` = 'nav_url'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = 'https://***HOSTNAME***/webmail/' WHERE `category` = 'webmail' AND `name` = 'nav_url'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = 'managesieve,password' WHERE `category` = 'roundcube' AND `name` = 'plugins'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = 'de' WHERE `category` = 'general' AND `name` = 'default_language'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = '1' WHERE `category` = 'php' AND `name` = 'uses_fcgid'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = '1' WHERE `category` = 'ssl' AND `name` = 'panel_certificate'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = '1' WHERE `category` = 'ssl' AND `name` = 'ftp_certificate'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = '1' WHERE `category` = 'ssl' AND `name` = 'mail_certificate'
[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`settings` SET `value` = '1' WHERE `category` = 'ssl' AND `name` = 'webmail_certificate'
[SKIPPED DUE PREVIOUS ERRORS] db | INSERT INTO `keyhelp`.`users` ( `username`, `password`, `is_admin`, `is_superadmin`, `email`, `lang` )
VALUES ('mkeurope', '$2a$10$XusqUx8mgWR9CL6d1Ep3NurrrggX0hB2e0ka3/Onbpn4DpIFiUyu.', '1', '1', 'Michael.kailuweit@t-online.de', 'de' )
[SKIPPED DUE PREVIOUS ERRORS] db | INSERT INTO `keyhelp`.`templates_account` (`label`, `diskspace`, `traffic`, `mailaccounts`, `mailaddresses`, `subdomains`, `mysqldbs`, `ftpusers`, `scheduled_tasks`, `ftp`, `php`, `perl`, `ssh`, `backup`, `panel_access`, `domain_security`, `manage_certs`, `dns_editor`, `change_personal_data`, `php_memory_limit`, `php_max_execution_time`, `php_post_max_size`, `php_upload_max_filesize`, `php_open_basedir`, `php_disable_functions`, `php_additional_settings`, `phpfpm_pm`, `phpfpm_max_children`, `phpfpm_max_requests`, `phpfpm_min_spare_servers`, `phpfpm_max_spare_servers`, `phpfpm_status_enabled`, `phpfpm_status_iprestriction`)
VALUES ('Unlimited', -1, -1, -1, -1, -1, -1, -1, -1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, '80M', 60, '72M', '64M', '##DOCROOT##/www:##DOCROOT##/files:##DOCROOT##/tmp', 'dl, disk_free_space, diskfreespace, stream_socket_sendto, proc_get_status, proc_nice, proc_open, proc_terminate, proc_close, popen, curl_multi_exec, pcntl_exec, pcntl_fork, pcntl_setpriority, symlink, link, posix_kill, posix_mkfifo, posix_setsid, posix_setuid, posix_setpgid, posix_getpwuid, show_source, highlight_file, syslog, error_log, openlog, define_syslog_variables, apache_child_terminate, apache_setenv, apache_note, exec, system, shell_exec, passthru', '', 'ondemand', 3, 0, '', '', 0, '');

[Firewall (iptables)]
exec | mkdir -p -m 0700 /etc/keyhelp/iptables/
files | /home/keyhelp/www/keyhelp/install/config/common/iptables/ipv4_wan => /etc/keyhelp/iptables/startup_rules_ipv4
files | /home/keyhelp/www/keyhelp/install/config/common/iptables/ipv6_wan => /etc/keyhelp/iptables/startup_rules_ipv6
files | /home/keyhelp/www/keyhelp/install/config/common/iptables/keyhelp_load_rules => /etc/network/if-pre-up.d/keyhelp_load_rules
exec | chmod 0755 /etc/network/if-pre-up.d/keyhelp_load_rules
db | UPDATE `keyhelp`.`firewall` SET `rules` = '{"INPUT":{"name":"INPUT","comment":"","rules":[{"is_disabled":false,"comment":"","action":"Bogus","params":[]},{"is_disabled":false,"comment":"","action":"Always","params":[]},{"is_disabled":false,"comment":"","action":"Banned","params":[]},{"is_disabled":false,"comment":"","action":"fail2ban","params":[]},{"is_disabled":false,"comment":"","action":"Allow","params":[]}],"policy":"ACCEPT"},"FORWARD":{"name":"FORWARD","comment":"","rules":[{"is_disabled":false,"comment":"","action":"Bogus","params":[]},{"is_disabled":false,"comment":"","action":"Always","params":[]},{"is_disabled":false,"comment":"","action":"Banned","params":[]},{"is_disabled":false,"comment":"","action":"Allow","params":[]}],"policy":"ACCEPT"},"OUTPUT":{"name":"OUTPUT","comment":"","rules":[],"policy":"ACCEPT"},"Allow":{"name":"Allow","comment":"","rules":[{"is_disabled":false,"comment":"","action":"Friend","params":[{"is_inverted":false,"name":"--protocol","value":"icmp"},{"is_inverted":false,"name":"--match","value":"icmp"},{"is_inverted":false,"name":"--icmp-type","value":"8"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"icmp"},{"is_inverted":false,"name":"--match","value":"icmp"},{"is_inverted":false,"name":"--match","value":"limit"},{"is_inverted":false,"name":"--icmp-type","value":"any"},{"is_inverted":false,"name":"--limit","value":"1\/sec"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--protocol","value":"icmp"},{"is_inverted":false,"name":"--match","value":"icmp"},{"is_inverted":false,"name":"--icmp-type","value":"any"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--in-interface","value":"lo"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"53"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"udp"},{"is_inverted":false,"name":"--match","value":"udp"},{"is_inverted":false,"name":"--destination-port","value":"53"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"20"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"21"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"multiport"},{"is_inverted":false,"name":"--destination-ports","value":"30000:30500"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"22"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"80"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"443"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"25"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"587"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"110"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"143"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"993"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"995"}]},{"is_disabled":false,"comment":"","action":"REJECT","params":[{"is_inverted":false,"name":"--reject-with","value":"icmp-port-unreachable"}]}]},"Always":{"name":"Always","comment":"","rules":[{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--in-interface","value":"lo"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--match","value":"state"},{"is_inverted":false,"name":"--state","value":"RELATED,ESTABLISHED"}]},{"is_disabled":false,"comment":"","action":"Friend","params":[]}]},"Banned":{"name":"Banned","comment":"","rules":[]},"Bogus":{"name":"Bogus","comment":"","rules":[{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--tcp-flags","value":"FIN,SYN FIN,SYN"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--tcp-flags","value":"SYN,RST SYN,RST"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--source","value":"169.254.0.0\/16"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--source","value":"172.16.0.0\/12"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--source","value":"192.0.2.0\/24"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--source","value":"192.168.0.0\/16"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--source","value":"10.0.0.0\/8"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--source","value":"127.0.0.0\/8"},{"is_inverted":true,"name":"--in-interface","value":"lo"}]}]},"Friend":{"name":"Friend","comment":"","rules":[{"is_disabled":false,"comment":"","action":"RETURN","params":[]}]},"fail2ban":{"name":"fail2ban","comment":"","rules":[]}}' WHERE `ip_version` = 'ipv4' AND `type` = 'current'
MySQL - Query Error: ()

>>>>>>>>>>>>>>>>>>>>>>
!!! ERROR DETECTED !!!
<<<<<<<<<<<<<<<<<<<<<<

[SKIPPED DUE PREVIOUS ERRORS] db | UPDATE `keyhelp`.`firewall` SET `rules` = '{"INPUT":{"name":"INPUT","comment":"","rules":[{"is_disabled":false,"comment":"","action":"Bogus","params":[]},{"is_disabled":false,"comment":"","action":"Always","params":[]},{"is_disabled":false,"comment":"","action":"Banned","params":[]},{"is_disabled":false,"comment":"","action":"fail2ban","params":[]},{"is_disabled":false,"comment":"","action":"Allow","params":[]}],"policy":"ACCEPT"},"FORWARD":{"name":"FORWARD","comment":"","rules":[{"is_disabled":false,"comment":"","action":"Bogus","params":[]},{"is_disabled":false,"comment":"","action":"Always","params":[]},{"is_disabled":false,"comment":"","action":"Banned","params":[]},{"is_disabled":false,"comment":"","action":"Allow","params":[]}],"policy":"ACCEPT"},"OUTPUT":{"name":"OUTPUT","comment":"","rules":[],"policy":"ACCEPT"},"Allow":{"name":"Allow","comment":"","rules":[{"is_disabled":false,"comment":"","action":"Friend","params":[{"is_inverted":false,"name":"--protocol","value":"ipv6-icmp"},{"is_inverted":false,"name":"--match","value":"icmp6"},{"is_inverted":false,"name":"--icmpv6-type","value":"128"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"ipv6-icmp"},{"is_inverted":false,"name":"--match","value":"limit"},{"is_inverted":false,"name":"--limit","value":"1\/sec"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--protocol","value":"ipv6-icmp"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--in-interface","value":"lo"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"53"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"udp"},{"is_inverted":false,"name":"--match","value":"udp"},{"is_inverted":false,"name":"--destination-port","value":"53"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"20"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"21"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"multiport"},{"is_inverted":false,"name":"--destination-ports","value":"30000:30500"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"22"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"80"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"443"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"25"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"587"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"110"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"143"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"993"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--destination-port","value":"995"}]},{"is_disabled":false,"comment":"","action":"REJECT","params":[{"is_inverted":false,"name":"--reject-with","value":"icmp6-port-unreachable"}]}]},"Always":{"name":"Always","comment":"","rules":[{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--in-interface","value":"lo"}]},{"is_disabled":false,"comment":"","action":"ACCEPT","params":[{"is_inverted":false,"name":"--match","value":"state"},{"is_inverted":false,"name":"--state","value":"RELATED,ESTABLISHED"}]},{"is_disabled":false,"comment":"","action":"Friend","params":[]}]},"Banned":{"name":"Banned","comment":"","rules":[]},"Bogus":{"name":"Bogus","comment":"","rules":[{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--tcp-flags","value":"FIN,SYN FIN,SYN"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--protocol","value":"tcp"},{"is_inverted":false,"name":"--match","value":"tcp"},{"is_inverted":false,"name":"--tcp-flags","value":"SYN,RST SYN,RST"}]},{"is_disabled":false,"comment":"","action":"DROP","params":[{"is_inverted":false,"name":"--source","value":"::1\/128"},{"is_inverted":true,"name":"--in-interface","value":"lo"}]}]},"Friend":{"name":"Friend","comment":"","rules":[{"is_disabled":false,"comment":"","action":"RETURN","params":[]}]},"fail2ban":{"name":"fail2ban","comment":"","rules":[]}}' WHERE `ip_version` = 'ipv6' AND `type` = 'current'

[SSH]
exec | apt-get install -y openssh-server
Reading package lists...
Building dependency tree...
Reading state information...
openssh-server is already the newest version (1:7.4p1-10+deb9u3).
openssh-server set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 37 not upgraded.
exec | grep --quiet "^\s*DenyGroups keyhelp_nossh kh_suspended" /etc/ssh/sshd_config || printf "\n# Limit KeyHelp usergroup\nDenyGroups keyhelp_nossh kh_suspended\n" >> /etc/ssh/sshd_config
exec | service ssh restart

[ProFTPD]
exec | /usr/share/debconf/fix_db.pl
exec | echo "proftpd-basic shared/proftpd/inetd_or_standalone select standalone" | sudo debconf-set-selections
exec | DEBIAN_FRONTEND=noninteractive apt-get install -y proftpd-basic proftpd-mod-mysql
Reading package lists...
Building dependency tree...
Reading state information...
The following additional packages will be installed:
libmemcached11 libmemcachedutil2
Suggested packages:
openbsd-inetd | inet-superserver proftpd-doc proftpd-mod-ldap
proftpd-mod-odbc proftpd-mod-pgsql proftpd-mod-sqlite proftpd-mod-geoip
The following NEW packages will be installed:
libmemcached11 libmemcachedutil2 proftpd-basic proftpd-mod-mysql
0 upgraded, 4 newly installed, 0 to remove and 37 not upgraded.
Need to get 3,130 kB of archives.
After this operation, 5,596 kB of additional disk space will be used.
Get:1 http://cdn-fastly.deb.debian.org/debian stretch/main i386 libmemcached11 i386 1.0.18-4.1 [101 kB]
Get:2 http://cdn-fastly.deb.debian.org/debian stretch/main i386 libmemcachedutil2 i386 1.0.18-4.1 [23.0 kB]
Get:3 http://cdn-fastly.deb.debian.org/debian stretch/main i386 proftpd-basic i386 1.3.5b-4 [2,527 kB]
Get:4 http://cdn-fastly.deb.debian.org/debian stretch/main i386 proftpd-mod-mysql i386 1.3.5b-4 [478 kB]
Fetched 3,130 kB in 0s (4,246 kB/s)
Selecting previously unselected package libmemcached11:i386.
(Reading database ...
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 45057 files and directories currently installed.)
Preparing to unpack .../libmemcached11_1.0.18-4.1_i386.deb ...
Unpacking libmemcached11:i386 (1.0.18-4.1) ...
Selecting previously unselected package libmemcachedutil2:i386.
Preparing to unpack .../libmemcachedutil2_1.0.18-4.1_i386.deb ...
Unpacking libmemcachedutil2:i386 (1.0.18-4.1) ...
Selecting previously unselected package proftpd-basic.
Preparing to unpack .../proftpd-basic_1.3.5b-4_i386.deb ...
Unpacking proftpd-basic (1.3.5b-4) ...
Selecting previously unselected package proftpd-mod-mysql.
Preparing to unpack .../proftpd-mod-mysql_1.3.5b-4_i386.deb ...
Unpacking proftpd-mod-mysql (1.3.5b-4) ...
Setting up libmemcached11:i386 (1.0.18-4.1) ...
Processing triggers for libc-bin (2.24-11+deb9u3) ...
Processing triggers for systemd (232-25+deb9u2) ...
Processing triggers for man-db (2.7.6.1-2) ...
Setting up libmemcachedutil2:i386 (1.0.18-4.1) ...
Setting up proftpd-basic (1.3.5b-4) ...
Warning: The home dir /run/proftpd you specified can't be accessed: No such file or directory
Adding system user `proftpd' (UID 112) ...
Adding new user `proftpd' (UID 112) with group `nogroup' ...
Not creating home directory `/run/proftpd'.
Adding system user `ftp' (UID 113) ...
Adding new user `ftp' (UID 113) with group `nogroup' ...
Creating home directory `/srv/ftp' ...
'/usr/share/proftpd/templates/welcome.msg' -> '/srv/ftp/welcome.msg.proftpd-new'
Setting up proftpd-mod-mysql (1.3.5b-4) ...
Processing triggers for libc-bin (2.24-11+deb9u3) ...
Processing triggers for systemd (232-25+deb9u2) ...
exec | DEBIAN_FRONTEND=dialog
files | /home/keyhelp/www/keyhelp/install/config/common/proftpd/modules.conf => /etc/proftpd/modules.conf
files | /home/keyhelp/www/keyhelp/install/config/common/proftpd/proftpd.conf => /etc/proftpd/proftpd.conf
files | /home/keyhelp/www/keyhelp/install/config/common/proftpd/sql.conf => /etc/proftpd/sql.conf
files | /home/keyhelp/www/keyhelp/install/config/common/proftpd/tls.conf => /etc/proftpd/tls.conf
files | /home/keyhelp/www/keyhelp/install/config/debian_9/proftpd/init.d_proftpd => /etc/init.d/proftpd
exec | chmod 0640 /etc/proftpd/proftpd.conf
exec | chmod 0600 /etc/proftpd/sql.conf
exec | service proftpd stop
Warning: proftpd.service changed on disk. Run 'systemctl daemon-reload' to reload units.
exec | service proftpd start
Warning: proftpd.service changed on disk. Run 'systemctl daemon-reload' to reload units.

[Postfix]
exec | /usr/share/debconf/fix_db.pl
exec | echo "postfix postfix/mailname string ***HOSTNAME***" | sudo debconf-set-selections
exec | echo "postfix postfix/main_mailer_type string 'Internet Site'" | sudo debconf-set-selections
exec | DEBIAN_FRONTEND=noninteractive apt-get install -y postfix postfix-mysql postfix-policyd-spf-python
Reading package lists...
Building dependency tree...
Reading state information...
The following additional packages will be installed:
postfix-sqlite python3-authres python3-dns python3-spf
Suggested packages:
procmail postfix-pgsql postfix-ldap postfix-pcre postfix-lmdb sasl2-bin
dovecot-common resolvconf postfix-cdb ufw postfix-doc python3-yaml
The following packages will be REMOVED:
exim4 exim4-base exim4-config exim4-daemon-light
The following NEW packages will be installed:
postfix postfix-mysql postfix-policyd-spf-python postfix-sqlite
python3-authres python3-dns python3-spf
0 upgraded, 7 newly installed, 4 to remove and 37 not upgraded.
Need to get 2,264 kB of archives.
After this operation, 1,192 kB of additional disk space will be used.
Get:1 http://cdn-fastly.deb.debian.org/debian stretch/main i386 postfix i386 3.1.8-0+deb9u1 [1,471 kB]
Get:2 http://cdn-fastly.deb.debian.org/debian stretch/main i386 postfix-sqlite i386 3.1.8-0+deb9u1 [319 kB]
Get:3 http://cdn-fastly.deb.debian.org/debian stretch/main i386 python3-dns all 3.1.1-1 [27.5 kB]
Get:4 http://cdn-fastly.deb.debian.org/debian stretch/main i386 python3-authres all 0.900-1 [17.5 kB]
Get:5 http://cdn-fastly.deb.debian.org/debian stretch/main i386 python3-spf all 2.0.12t-3 [64.1 kB]
Get:6 http://cdn-fastly.deb.debian.org/debian stretch/main i386 postfix-policyd-spf-python all 2.0.1-1 [43.8 kB]
Get:7 http://cdn-fastly.deb.debian.org/debian stretch/main i386 postfix-mysql i386 3.1.8-0+deb9u1 [322 kB]
Preconfiguring packages ...
Fetched 2,264 kB in 0s (4,949 kB/s)
(Reading database ...
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 45186 files and directories currently installed.)
Removing exim4 (4.89-2+deb9u3) ...
dpkg: exim4-daemon-light: dependency problems, but removing anyway as you requested:
bsd-mailx depends on default-mta | mail-transport-agent; however:
Package default-mta is not installed.
Package exim4-daemon-light which provides default-mta is to be removed.
Package mail-transport-agent is not installed.
Package exim4-daemon-light which provides mail-transport-agent is to be removed.
bsd-mailx depends on default-mta | mail-transport-agent; however:
Package default-mta is not installed.
Package exim4-daemon-light which provides default-mta is to be removed.
Package mail-transport-agent is not installed.
Package exim4-daemon-light which provides mail-transport-agent is to be removed.

Removing exim4-daemon-light (4.89-2+deb9u3) ...
dpkg: exim4-config: dependency problems, but removing anyway as you requested:
exim4-base depends on exim4-config (>= 4.82) | exim4-config-2; however:
Package exim4-config is to be removed.
Package exim4-config-2 is not installed.
Package exim4-config which provides exim4-config-2 is to be removed.
exim4-base depends on exim4-config (>= 4.82) | exim4-config-2; however:
Package exim4-config is to be removed.
Package exim4-config-2 is not installed.
Package exim4-config which provides exim4-config-2 is to be removed.

Removing exim4-config (4.89-2+deb9u3) ...
Selecting previously unselected package postfix.
(Reading database ...
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 45123 files and directories currently installed.)
Preparing to unpack .../postfix_3.1.8-0+deb9u1_i386.deb ...
Unpacking postfix (3.1.8-0+deb9u1) ...
(Reading database ...
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 45310 files and directories currently installed.)
Removing exim4-base (4.89-2+deb9u3) ...
Selecting previously unselected package postfix-sqlite.
(Reading database ...
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 45236 files and directories currently installed.)
Preparing to unpack .../0-postfix-sqlite_3.1.8-0+deb9u1_i386.deb ...
Unpacking postfix-sqlite (3.1.8-0+deb9u1) ...
Selecting previously unselected package python3-dns.
Preparing to unpack .../1-python3-dns_3.1.1-1_all.deb ...
Unpacking python3-dns (3.1.1-1) ...
Selecting previously unselected package python3-authres.
Preparing to unpack .../2-python3-authres_0.900-1_all.deb ...
Unpacking python3-authres (0.900-1) ...
Selecting previously unselected package python3-spf.
Preparing to unpack .../3-python3-spf_2.0.12t-3_all.deb ...
Unpacking python3-spf (2.0.12t-3) ...
Selecting previously unselected package postfix-policyd-spf-python.
Preparing to unpack .../4-postfix-policyd-spf-python_2.0.1-1_all.deb ...
Unpacking postfix-policyd-spf-python (2.0.1-1) ...
Selecting previously unselected package postfix-mysql.
Preparing to unpack .../5-postfix-mysql_3.1.8-0+deb9u1_i386.deb ...
Unpacking postfix-mysql (3.1.8-0+deb9u1) ...
Setting up python3-authres (0.900-1) ...
Setting up python3-dns (3.1.1-1) ...
Processing triggers for systemd (232-25+deb9u2) ...
Processing triggers for man-db (2.7.6.1-2) ...
Setting up postfix-sqlite (3.1.8-0+deb9u1) ...
grep: /etc/postfix/dynamicmaps.cf: No such file or directory
Adding sqlite map entry to /etc/postfix/dynamicmaps.cf
Processing triggers for rsyslog (8.24.0-1) ...
Setting up postfix (3.1.8-0+deb9u1) ...
Created symlink /etc/systemd/system/multi-user.target.wants/postfix.service → /lib/systemd/system/postfix.service.
Adding group `postfix' (GID 119) ...
Done.
Adding system user `postfix' (UID 114) ...
Adding new user `postfix' (UID 114) with group `postfix' ...
Not creating home directory `/var/spool/postfix'.
Adding group `postdrop' (GID 120) ...
Done.
setting myhostname: ***HOSTNAME***
setting alias maps
setting alias database
changing /etc/mailname to ***HOSTNAME***
setting myorigin
setting destinations: $myhostname, ***HOSTNAME***, localhost.customervps.de, localhost
setting relayhost:
setting mynetworks: 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
setting mailbox_size_limit: 0
setting recipient_delimiter: +
setting inet_interfaces: all
setting inet_protocols: all
WARNING: /etc/aliases exists, but does not have a root alias.

Postfix (main.cf) is now set up with a default configuration. If you need to
make changes, edit /etc/postfix/main.cf (and others) as needed. To view
Postfix configuration values, see postconf(1).

After modifying main.cf, be sure to run 'service postfix reload'.

Running newaliases
Setting up python3-spf (2.0.12t-3) ...
Setting up postfix-policyd-spf-python (2.0.1-1) ...
Setting up postfix-mysql (3.1.8-0+deb9u1) ...
Adding mysql map entry to /etc/postfix/dynamicmaps.cf
Processing triggers for systemd (232-25+deb9u2) ...
Processing triggers for rsyslog (8.24.0-1) ...
exec | DEBIAN_FRONTEND=dialog
files | /home/keyhelp/www/keyhelp/install/config/debian_9/postfix/main.cf => /etc/postfix/main.cf
files | /home/keyhelp/www/keyhelp/install/config/debian_9/postfix/master.cf => /etc/postfix/master.cf
files | /home/keyhelp/www/keyhelp/install/config/common/postfix/header_checks => /etc/postfix/header_checks
files | /home/keyhelp/www/keyhelp/install/config/common/postfix/mysql-virtual-mailbox-domains.cf => /etc/postfix/mysql-virtual-mailbox-domains.cf
files | /home/keyhelp/www/keyhelp/install/config/common/postfix/mysql-virtual-mailbox-maps.cf => /etc/postfix/mysql-virtual-mailbox-maps.cf
files | /home/keyhelp/www/keyhelp/install/config/common/postfix/mysql-virtual-alias-maps.cf => /etc/postfix/mysql-virtual-alias-maps.cf
exec | openssl dhparam -out /etc/postfix/dh512.pem 512
Generating DH parameters, 512 bit long safe prime, generator 2
This is going to take a long time
..............+........................................+............+.........................+........................+...+..........................+............................+......++*++*++*++*++*++*
exec | openssl dhparam -out /etc/postfix/dh1024.pem 1024

[Tobi]

Dann mach Mal bitte

Code: Select all

See "systemctl status mariadb.service" and "journalctl -xe" for details.

Und poste das Ergebnis hier.

[MKEurope]

systemctl status mariadb.service


â mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Fri 2018-07-20 10:17:36 UTC; 13min ago
Main PID: 30133 (code=exited, status=227/NO_NEW_PRIVILEGES)

Jul 20 10:17:36 vps230.customervps.de systemd[1]: Starting MariaDB database server...
Jul 20 10:17:36 vps230.customervps.de systemd[30133]: mariadb.service: Failed at step NO_NEW_PRIVILEGES spawning /usr/sbin/mysqld: Invalid argument
Jul 20 10:17:36 vps230.customervps.de systemd[1]: mariadb.service: Main process exited, code=exited, status=227/NO_NEW_PRIVILEGES
Jul 20 10:17:36 vps230.customervps.de systemd[1]: Failed to start MariaDB database server.
Jul 20 10:17:36 vps230.customervps.de systemd[1]: mariadb.service: Unit entered failed state.
Jul 20 10:17:36 vps230.customervps.de systemd[1]: mariadb.service: Failed with result 'exit-code'.



journalctl -x
geht nur per txt weil es soviel ist.

[MKEurope]

habe allerdings jetzt die 64 bit version neu installiert. Doch leider der gleiche Fehler

[Tobi]

Hast du vor der Installation ein
apt-update / upgrade gemacht?

[derFu]

Hallo!

Vielleicht ist der Kernel der Maschine zu alt. Das hatte ich mal bei MariaDB und Debian. Nach Installation eines neueren Kernels lief es problemlos.

[MKEurope]

Hast du vor der Installation ein
apt-update / upgrade gemacht?
Re: Debian 9.4 stretch 32

Ja habe ich

Hallo!

Vielleicht ist der Kernel der Maschine zu alt. Das hatte ich mal bei MariaDB und Debian. Nach Installation eines neueren Kernels lief es problemlos.

Die Maschine ist komplett neu aufgesetzt.
Ich habe keinerlei Ideen woran das liegen kann.

[MKEurope]

ICH WEIß MIR KEINEN RAT MEHR.

Jetzt hat der Provider meinen Server komplett neu aufgesetzt. Mit Komplett meine ich auch Komplett.
Neue Zugangsdaten ect. und und und.
Dennoch macht KH mir diesen Fehler.

HIIIIIILLLLLLFFFEEEEE




MariaDB ... [ERROR]
KeyHelp ...
Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 170

Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 49

Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 50

Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 69

Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 70

Warning: MySQL - Query Error: () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 170
[ERROR]
Firewall (iptables) ...
Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 170

Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 49

Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 50

Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 69

Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 70

Warning: MySQL - Query Error: () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 170
[ERROR]
SSH ...

[derFu]

Hast du vor der Installation ein
apt-update / upgrade gemacht?
Re: Debian 9.4 stretch 32

Ja habe ich

Hallo!

Vielleicht ist der Kernel der Maschine zu alt. Das hatte ich mal bei MariaDB und Debian. Nach Installation eines neueren Kernels lief es problemlos.

Die Maschine ist komplett neu aufgesetzt.
Ich habe keinerlei Ideen woran das liegen kann.

Neu aufgesetzt heißt ja nicht zwingend, dass der aktuelle Distributionskernel genutzt wird. Gerade in Xen-Umgebungen nutzen manche Betreiber eigene Kernel.

[nikko]

Mehr als 1 GB RAM ist aber vorhanden?
KH ist auch für den Einsatz auf Xen nicht vorgesehen. Openvz und KVM, sowie dedizierte Server sind die Umgebungen.

Habe es auch auf Virtuozzo nicht zum Laufen gebracht.

[Daniel]

Hallo,

nur kurz zur Info für mich - welcher Xen-Hypervisor wird eingesetzt (CitrixXen / Xen-Project)?
Und welche Hypervisor Version wird verwendet?

[MKEurope]

nur kurz zur Info für mich - welcher Xen-Hypervisor wird eingesetzt (CitrixXen / Xen-Project)?

Hallo Xen-PV

[Daniel]

Hallo,

steht dieses Thema mit viewtopic.php?f=4&t=1692 in Verbindung?

Wenn nein:
Bitte die Hypervisor Version mit angeben oder ggf. den verwendeten Hostkernel. Das es sich bei "Xen" um eine Paravirtualisation handelt ist soweit bekannt.