Sirous problems after updating Ispconfig 3.1 to 3.2

Discussion in 'ISPConfig 3 Priority Support' started by virk6, Nov 14, 2020.

  1. virk6

    virk6 Member

    Hello;

    I have just updated Ispconfig 3.1 to 3.2 on debian 9 and nginx but unfortunately I have serious problems:

    1 I can no longer add a domain name for the creation of a site;
    2 The PHP versions that I had added in Ispconfig have all disappeared in the dashboard and cannot be added;
    Here is the error message displayed in the Ispconfig dashboard:

    Unknown column 'server_php_id' in 'field list'


    Help please.
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  3. virk6

    virk6 Member

    Here are the first lines (debian 9 and nginx )
    cat htf_report.txt | more

    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Debian GNU/Linux 9.13 (stretch)

    [INFO] ISPConfig is installed.

    ##### ISPCONFIG #####
    ISPConfig version is 3.2


    ##### VERSION CHECK #####

    [INFO] php (cli) version is 7.4.9

    ##### PORT CHECK #####

    [WARN] Port 22 (SSH server) seems NOT to be listening

    ##### MAIL SERVER CHECK #####


    ##### RUNNING SERVER PROCESSES #####

    [INFO] I found the following web server(s):
    Unknown process (nginx:) (PID 22740)
    [INFO] I found the following mail server(s):
    Postfix (PID 22574)
    [INFO] I found the following pop3 server(s):
    Dovecot (PID 22616)
    [INFO] I found the following imap server(s):
    Dovecot (PID 22616)
    [INFO] I found the following ftp server(s):
    Unknown process (vsftpd) (PID 30240)

    ##### LISTENING PORTS #####
    (seulement ()
    Adresse (distante)
    [anywhere]:143 (22616/dovecot)
    [anywhere]:80 (22740/nginx:)
    [anywhere]:8080 (22740/nginx:)
    [anywhere]:8081 (22740/nginx:)
    [anywhere]:465 (22574/master)
    ......
    ......
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

  5. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Also,
    is not a supported PHP version for Debian 9.
    Change it back to default PHP for your OS with
    Code:
    update-alternatives --config php
    update-alternatives --config php-cgi
     
  6. virk6

    virk6 Member

    I think I know the cause of my problem: I had at one point two Ispconfig databases (dbispconfig and dbispconfig2) during an update the system told me that dbispconfig already exists and I had to create dbispconfig2. In which Ispconfig configuration file should I specify the correct ispconfig database?
     
  7. virk6

    virk6 Member

    I have already installed PHP 7.4 on the server and it was working without problem and when i update Ispconfig from 3.1 to 3.2 the problem comme in.
    Can i come back to Ispconfig 3.1 ?
     
  8. virk6

    virk6 Member


    I changed it from version is 7.4.9 to PHP 7.2 but nothing worg ..
    How and where to tell ispconfig the datable it should use between dbispconfig and dbispconfig2 ?
     
  9. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    That does not help much, since on Debian 9 the default PHP version is 7.0.
    You have not answered the question
    That is suspicious. Thing like that should not happen. Did you follow carefully https://www.howtoforge.com/updating-ispconfig-3-1-to-ispconfig-3-2/
    At what point did the two dbispconfig databases appear?
     
  10. virk6

    virk6 Member

  11. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    You should have one database, check in PHPMyAdmin which one holds the data of your setup. Then run a force update:
    Code:
    cd /tmp
    wget https://www.ispconfig.org/downloads/ISPConfig-3.2.tar.gz
    tar xvfz ISPConfig-3.2.tar.gz
    cd ispconfig3_install/install
    php -q update.php
     
  12. virk6

    virk6 Member

    hello,

    I am trying to follow the link but it is for Apache but my server is nginx what to do ?
    I think dbispconfig2 was the database which holds the data before i start the updating and after update ispconfig 3.1 to 3.2 the database became dbispconfig it why i could not find my additional PHP versions I added before.
     
  13. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Which link do you mean?
     
  14. virk6

    virk6 Member

  15. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Why would it be for apache only? This is both for Apache and NGINX.
     
  16. virk6

    virk6 Member

    Please ! Because of this process :
    Reconfigure Services? (yes,no,selected) [yes]: yes

    Configuring Postfix
    Configuring Dovecot
    Configuring Mailman
    Configuring Spamassassin
    Configuring Amavisd
    Configuring Getmail
    Configuring BIND
    Configuring Pureftpd
    Configuring Apache
    Configuring vlogger
    Configuring Apps vhost
    Configuring Jailkit
    Configuring Ubuntu Firewall
    Configuring Database
    Updating ISPConfig
    ISPConfig Port [8080]: <-- just hit return to accept the default

    Do you think i can change webser from Apache to nginx ?
     
  17. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    If you run it on your server, with nginx installed and not apache, it should say "Configuring nginx". It's just a example in the tutorial.
     
  18. virk6

    virk6 Member

    Ok i am going to do it just now and let you know the result in moment.
    Thanks.
     
  19. virk6

    virk6 Member

    I just started and got this

    ispconfig_update.sh

    There are no updates available for ISPConfig 3.2
    If you are sure you want to update to stable anyway, please use --force parameter
    DOWNGRADING MAY CAUSE ISSUES!
    ...

    and after this
    ispconfig_update.sh --force

    i got the same message ..
     
  20. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    I told you in post #11 how to run a force update.
     

Share This Page