CyberHosting

Server Errror 500 after upgrading v.2.0.1

Recently I've upgraded my cyberpanel to version 2.0.1. After that I cannot login to cyberpanel dashboard. It told me "Server Error (500)"
I've changed the password of user 'cyberpanel' and updated in /usr/local/CyberCP/CyberCP/settings.py but no luck.

Here is output of "journalctl -xe", please help me:
Jun 29 19:06:23 xxx pdns_server[11691]: About to create 3 backend threads for UDP
Jun 29 19:06:23 xxx pdns_server[11691]: gmysql Connection failed: Unable to connect to database: ERROR 1045 (28000): Access denied for user 'cyberpanel'@'localhost' (using password: YES)
Jun 29 19:06:23 xxx pdns_server[11691]: Caught an exception instantiating a backend: Unable to launch gmysql connection: Unable to connect to database: ERROR 1045 (28000): Access denied for user 'cyberpanel'@'localhost' (using password: YES)
Jun 29 19:06:23 xxx pdns_server[11691]: Cleaning up
Jun 29 19:06:23 xxx pdns_server[11691]: Distributor caught fatal exception: Unable to launch gmysql connection: Unable to connect to database: ERROR 1045 (28000): Access denied for user 'cyberpanel'@'localhost' (using password: YES)
Jun 29 19:06:23 xxx systemd[1]: pdns.service: main process exited, code=exited, status=1/FAILURE
Jun 29 19:06:23 xxx systemd[1]: Unit pdns.service entered failed state.
Jun 29 19:06:23 phpmyadmin.hungviet-at.vn systemd[1]: pdns.service failed.

Comments

  • run the upgade again
    Cyberpanel Managed & Unmanaged Shared & VPS Hosting by Cyberpanel Experts.
    https://www.cyberhosting.org
    You can now earn with the Cyberhosting affiliate scheme. Join today
    https://www.cyberhosting.org/affiliates/
  • I tried to upgrade again with version 2.0.1 after update cyberpanel user's password but it was still error 500.

    last log after upgrade below:
    #######
    cp: cannot create regular file ‘/usr/local/CyberCP/bin/lswsgi’: Text file busy
    sed: can't read /usr/bin/adminPass: No such file or directory
    chmod: cannot access ‘/usr/bin/adminPass’: No such file or directory
    Loaded plugins: fastestmirror
    Loading mirror speeds from cached hostfile
    * base: mirror.vastspace.net
    * extras: mirror.vastspace.net
    * updates: mirror.vastspace.net
    Installed Packages
    lsphp74-devel.x86_64 7.4.7-2.el7 @litespeed-update
    ###################################################################
    CyberPanel Upgraded
    ###################################################################
  • Is mariadb running and have you attempted to upgrade it?
    Cyberpanel Managed & Unmanaged Shared & VPS Hosting by Cyberpanel Experts.
    https://www.cyberhosting.org
    You can now earn with the Cyberhosting affiliate scheme. Join today
    https://www.cyberhosting.org/affiliates/
  • the mariadb is still running in old version, but I cannot upgrade from v.10.0.38 to 10.1.45. Only cyberpanel dashboard cannot accessed, my websites are still running.
  • systemctl restart lscpd
    Cyberpanel Managed & Unmanaged Shared & VPS Hosting by Cyberpanel Experts.
    https://www.cyberhosting.org
    You can now earn with the Cyberhosting affiliate scheme. Join today
    https://www.cyberhosting.org/affiliates/
  • reboot vps & restart lscpd, still failed with below log:

    ##########
    Jul 01 11:11:04 XXXX pdns_server[31446]: gmysql Connection failed: Unable to connect to database: ERROR 1045 (28000): Access denied for user 'cyberpanel'@'localhost' (using password: YES)
    Jul 01 11:11:04 XXXX pdns_server[31446]: Caught an exception instantiating a backend: Unable to launch gmysql connection: Unable to connect to database: ERROR 1045 (28000): Access denied for user 'cyberpanel'@'localhost' (using password: YES)
    Jul 01 11:11:04 XXXX pdns_server[31446]: Cleaning up
    Jul 01 11:11:04 XXXX pdns_server[31446]: TCP server is unable to launch backends - will try again when questions come in: Unable to launch gmysql connection: Unable to connect to database: ERROR 1045 (28000): Access denied for user 'cyberpanel'@'localhost' (using password: YES)
    Jul 01 11:11:04 XXXX systemd[1]: Started PowerDNS Authoritative Server.
  • That is a powerdns error

    Look in /usr/local/CyberCP/CyberCP/settings.py

    You will see the database user and password

    Double check this in /etc/pdns/pdns.conf

    If they are the same then somehow you have altered the db user password and you will need to reset it.

    You can reset it by using the root user MySQL password

    cat /etc/cyberpanel/mysqlPassword

    change either in phpmyadmin or google how to change it by commandline
    Cyberpanel Managed & Unmanaged Shared & VPS Hosting by Cyberpanel Experts.
    https://www.cyberhosting.org
    You can now earn with the Cyberhosting affiliate scheme. Join today
    https://www.cyberhosting.org/affiliates/
Sign In or Register to comment.
CyberPanel Discord

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion