502 bad gateway when connecting to ispconfig3

Start from the beginning:
https://www.howtoforge.com/community/threads/please-read-before-posting.58408/

 

Ok then i have:
- Debian 8 Jessie
- ISPConfig 3.1.13p1
- for e-mail im using dovecot
- emails are working
- webserver is nginx

The command below give me output

Code:

wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

Code:

Fatal error: Call to undefined function mysqli_connect() in /tmp/ispconfig_setup-master/htf-common-issues.php on line 184

##### SERVER #####
IP-address (as per hostname): ***.***.***.***
IP-address(es) (as per ifconfig): ***.***.***.***
[INFO] ISPConfig is installed.

By checking service mysql status i get

Code:

root@isp:/tmp/ispconfig_setup-master# service mysql status
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: failed (Result: exit-code) since środa 2019-05-01 20:44:06 CEST; 45min ago
  Process: 32319 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
  Process: 32351 ExecStart=/etc/init.d/mysql start (code=exited, status=126)

maj 01 20:44:06 isp.xxxxxxx.pl mysqld[32526]: 190501 20:44:06 [Note] Server socket created on IP: '::'.
maj 01 20:44:06 isp.xxxxxxx.pl mysqld[32526]: 190501 20:44:06 [Note] /usr/sbin/mysqld: ready for connections.
maj 01 20:44:06 isp.xxxxxxx.pl mysqld[32526]: Version: '10.0.38-MariaDB-0+deb8u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
maj 01 20:44:06 isp.xxxxxxx.pl mysql[32351]: Starting MariaDB database server: mysqld.
maj 01 20:44:06 isp.xxxxxxx.pl mysql[32351]: /etc/init.d/mysql: linia 121: /etc/mysql/debian-start: Brak dostępu
maj 01 20:44:06 isp.xxxxxxx.pl systemd[1]: mysql.service: control process exited, code=exited status=126
maj 01 20:44:06 isp.xxxxxxx.pl systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
maj 01 20:44:06 isp.xxxxxxx.pl systemd[1]: Unit mysql.service entered failed state.
maj 01 20:44:34 isp.xxxxxxx.pl mysqld[32526]: 190501 20:44:34 [Warning] Host name 'hostby.fcloud.biz' could not be resolved: Name or service not known
maj 01 20:53:34 isp.xxxxxxx.pl mysqld[32526]: 190501 20:53:34 [Warning] IP address '85.93.20.38' could not be resolved: Name or service not known

 

Thank you for your time, i check the php -v

Code:

root@isp:/tmp/ispconfig_setup-master# php -v
PHP 5.6.33 (cli) (built: May  1 2019 15:59:18)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
root@isp:/tmp/ispconfig_setup-master#

Next step i done is run systemctl status mysql.service i get

Code:

root@isp:/tmp/ispconfig_setup-master# systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: active (running) since śro 2019-05-01 21:56:36 CEST; 4s ago
  Process: 32319 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
  Process: 4613 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/mysql.service
           ├─32375 /bin/bash /usr/bin/mysqld_safe
           ├─32525 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --open-files-limit=1024000 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
           └─32526 logger -t mysqld -p daemon.error

maj 01 21:56:36 isp.xxxxxx.pl mysql[4613]: Starting MariaDB database server: mysqld already running.
maj 01 21:56:36 isp.xxxxxx.pl systemd[1]: Started LSB: Start and stop the mysql database server daemon.

 

Hi still working to fix it i manage to get thing sorted
I followed https://www.howtoforge.com/tutorial/how-to-install-php-7-on-debian-8-jessie/
Nginx is running but im still getting 502 on address where is ISPconfig

Unfortunately my mysql is not working good:

Code:

root@isp:/opt/php-7.0.32/bin# systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: active (running) since śro 2019-05-01 21:56:36 CEST; 3h 7min ago
   CGroup: /system.slice/mysql.service
           ├─32375 /bin/bash /usr/bin/mysqld_safe
           ├─32525 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --open-files-limit=1024000 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
           └─32526 logger -t mysqld -p daemon.error

maj 01 21:56:36 isp.xxxxxxxx.pl mysql[4613]: Starting MariaDB database server: mysqld already running.
maj 01 21:56:36 isp.xxxxxxxx.pl systemd[1]: Started LSB: Start and stop the mysql database server daemon.
maj 02 01:00:53 isp.xxxxxxxx.pl mysqld[32526]: 190502  1:00:53 [Warning] Hostname 'internettl.org' does not resolve to '104.152.52.26'.
maj 02 01:00:53 isp.xxxxxxxx.pl mysqld[32526]: 190502  1:00:53 [Note] Hostname 'internettl.org' has the following IP addresses:
maj 02 01:00:53 isp.xxxxxxxx.pl mysqld[32526]: 190502  1:00:53 [Note]  - 162.255.119.131

 

I as you advise, and after which i get the result:
/usr/bin/php
i run above command and i staking now over 20minutes but i do not know if it should that long

 

ok i think it's done but should i restart something?
there is no effect so far

 

Yes, i try all to get this back, all started when im romove one of the websites,
all went down but is still have ISPconfigi running but some of the website run under php7
so i use one of the tutorials to add it.
I still have the old server running maybe there is somethng i can copy from it and get this fix?

 

You can see from /var/log/dpkg.log what has been installed or removed by APT. That file does not show installs and removals for the PHP versions you installed yourself. But you can check if the original PHP packages are still there, or if they were removed.
If you can remove the PHP stuff you installed yourself, you should get back to a working system, at least after installing original PHP packages back with

Code:

apt-get install --reinstall package1 package2 ...

If the system is beyond repair, install a new Debian and ISPConfig following Perfect Server Guide. I have not compiled PHP myself, I do not trust my knowledge and do not want to mess up production servers. I use other Tutorial, this one which gets PHP packages compiled by an expert in the field: https://www.howtoforge.com/tutorial...fig-3-from-debian-packages-on-debian-8-and-9/

 

I dont wat to sound like - i done as is in tutorial and all go down. I done something wrong.
Can you tell me which version should i install now or what the best solution.
As i said i stll have second server running maybe there is the way to do something.
I run the command on old server which is this one but on diffrent machine
php -v

Code:

PHP 7.0.33-1~dotdeb+8.1 (cli) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
    with Zend OPcache v7.0.33-1~dotdeb+8.1, Copyright (c) 1999-2017, by Zend Technologies

I spend on this day and night,
Till and Telman im really thank you for you time to answer me

 

What you think about,
http://jvdc.me/fix-502-bad-gateway-error-on-nginx-server-after-upgrading-php/


This what i get ps aux | grep php
after

Code:

root     21343  0.0  0.0 203984 11204 ?        Ss   01:13   0:13 php-fpm: master process (/opt/php-7.0.32/etc/php-fpm.conf)

 

My advice is to remove the PHP version or versions you installed yourself. Like I wrote in #33. Does the Makefile have uninstall target?
Is the other server Debian 9.x Strech? How come it has PHP 7?

 

ok tell me after i do this is the comand ./configure wchich like te example below has the all connection.

Code:

./configure --prefix=/opt/php-7.0.32 --with-pdo-pgsql --with-zlib-dir --with-freetype-dir --enable-mbstring --with-libxml-dir=/usr --enable-soap --enable-calendar --with-curl --with-mcrypt --with-zlib --with-gd --with-pgsql --disable-rpath --enable-inline-optimization --with-bz2 --with-zlib --enable-sockets --enable-sysvsem --enable-sysvshm --enable-pcntl --enable-mbregex --enable-exif --enable-bcmath --with-mhash --enable-zip --with-pcre-regex --with-pdo-mysql --with-mysqli --with-mysql-sock=/var/run/mysqld/mysqld.sock --with-jpeg-dir=/usr --with-png-dir=/usr --enable-gd-native-ttf --with-openssl --with-fpm-user=www-data --with-fpm-group=www-data --with-libdir=/lib/x86_64-linux-gnu --enable-ftp --with-imap --with-imap-ssl --with-kerberos --with-gettext --with-xmlrpc --with-xsl --enable-opcache --enable-fpm

After instalation shall i do this
./configure --prefix=/etc/php5

or this will be incuded in this command
install php5 php5-cgi php5-fpm

 

What are you trying to accomplish with the commands in #37? Looks like those would configure the PHP compilation. Are you going to compile it again?
Check where it installs the generated PHP files. Do not let it install /usr/bin.

 

I guys, watch the sky, if you see flames - this is my server.