SSL White screen

Description

hey folks - im trying to generate a new cert for a site, as it seemed to not do it automatically - but when i click generate & install i just get a white page, i enabled debug and i get the following

Steps to Reproduce

I just add the subdomains/wildcard etc, tick agree, click the button

Expected Behavior

Get a new cert

Actual Behavior

0. Error_Reporter::get_debug_bt()
            [/usr/local/apnscp/lib/error_reporter.php:840]
         1. Error_Reporter::print_debug_bt()
            [/usr/local/apnscp/lib/datastream.php:422]
         2. DataStream->pipeline("")
            [/usr/local/apnscp/lib/datastream.php:394]
         3. DataStream->query("letsencrypt_request", ["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false, null)
            [/usr/local/apnscp/lib/Module/Skeleton/Standard.php:200]
         4. Module\Skeleton\Standard->query("letsencrypt_request", ["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false, null)
            [/usr/local/apnscp/lib/modules/letsencrypt.php:292]
         5. Letsencrypt_Module->request(["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false)
            [/usr/local/apnscp/lib/Module/Skeleton/Standard.php:145]
         6. Module\Skeleton\Standard->_invoke("request", [["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false])
            [/usr/local/apnscp/lib/apnscpfunction.php:983]
         7. apnscpFunctionInterceptor->call("letsencrypt_request", [["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false])
            [/usr/local/apnscp/lib/apnscpFunctionInterceptorTrait.php:34]
         8. Page_Container->afiCall("letsencrypt_request", [["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false])
            [/usr/local/apnscp/lib/html/page_container.php:625]
         9. Page_Container->__call("letsencrypt_request", [["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false])
            [/usr/local/apnscp/apps/ssl/ssl.php:373]
        10. apps\ssl\Page->_installLetsEncrypt([["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], subdomain:"*", domain:"zfituk.co.uk", c:"us", l:"", o:"", ou:"", ])
            [/usr/local/apnscp/apps/ssl/ssl.php:138]
        11. apps\ssl\Page->on_postback([["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], subdomain:"*", domain:"zfituk.co.uk", c:"us", l:"", o:"", ou:"", ])
            [/usr/local/apnscp/lib/html/page_container.php:1083]
        12. Page_Container->_processPostback()
            [/usr/local/apnscp/lib/html/page_container.php:1031]
        13. Page_Container->handle_request()
            [/usr/local/apnscp/public/index.php:99]
object(apnscpObject)#218 (8) { ["command"]=> string(19) "letsencrypt_request" ["args"]=> array(3) { [0]=> array(3) { [0]=> string(16) "www.zfituk.co.uk" [1]=> string(14) "*.zfituk.co.uk" [2]=> string(12) "zfituk.co.uk" } [1]=> bool(false) [2]=> NULL } ["error"]=> NULL ["session_id"]=> string(32) "FJG7Ypjm59JyGjeAdFmEGgUgvjZBCiWC" ["returned_data"]=> NULL ["options"]=> NULL ["error_buffer"]=> NULL ["ip":"apnscpObject":private]=> string(14) "86.142.184.255" }
         0. Error_Reporter::trigger_fatal("`letsencrypt_request': crash or other nasty error detected", ["letsencrypt_request"])
            [/usr/local/apnscp/lib/log_wrapper.php:50]
         1. fatal("`%s': crash or other nasty error detected", "letsencrypt_request")
            [/usr/local/apnscp/lib/datastream.php:426]
         2. DataStream->pipeline("")
            [/usr/local/apnscp/lib/datastream.php:394]
         3. DataStream->query("letsencrypt_request", ["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false, null)
            [/usr/local/apnscp/lib/Module/Skeleton/Standard.php:200]
         4. Module\Skeleton\Standard->query("letsencrypt_request", ["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false, null)
            [/usr/local/apnscp/lib/modules/letsencrypt.php:292]
         5. Letsencrypt_Module->request(["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false)
            [/usr/local/apnscp/lib/Module/Skeleton/Standard.php:145]
         6. Module\Skeleton\Standard->_invoke("request", [["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false])
            [/usr/local/apnscp/lib/apnscpfunction.php:983]
         7. apnscpFunctionInterceptor->call("letsencrypt_request", [["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false])
            [/usr/local/apnscp/lib/apnscpFunctionInterceptorTrait.php:34]
         8. Page_Container->afiCall("letsencrypt_request", [["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false])
            [/usr/local/apnscp/lib/html/page_container.php:625]
         9. Page_Container->__call("letsencrypt_request", [["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], false])
            [/usr/local/apnscp/apps/ssl/ssl.php:373]
        10. apps\ssl\Page->_installLetsEncrypt([["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], subdomain:"*", domain:"zfituk.co.uk", c:"us", l:"", o:"", ou:"", ])
            [/usr/local/apnscp/apps/ssl/ssl.php:138]
        11. apps\ssl\Page->on_postback([["www.zfituk.co.uk", "*.zfituk.co.uk", "zfituk.co.uk"], subdomain:"*", domain:"zfituk.co.uk", c:"us", l:"", o:"", ou:"", ])
            [/usr/local/apnscp/lib/html/page_container.php:1083]
        12. Page_Container->_processPostback()
            [/usr/local/apnscp/lib/html/page_container.php:1031]
        13. Page_Container->handle_request()
            [/usr/local/apnscp/public/index.php:99]

Environment

ApisCP version:
revision: 3ec2e7884c258580fa707cfe827a4269861007c6
timestamp: 1730519492
ver_maj: 3
ver_min: 2
ver_patch: 45
ver_pre: ‘’
dirty: false
debug: true

Operating System: 4.18.0-553.36.1.el8_10.x86_64

That’s not a recognized commit. What does upcp report? What does git status within /usr/local/apnscp report?

If you’re using Cloudflare for DNS, likely related to their API deprecation - subdomain/dns (cloudflare) error - #6 by msaladna

Moreover, this is fixed in revision 6e794590.

hey :slight_smile:

[root@cp ~]# upcp 
Enter passphrase for /root/.ssh/id_rsa: 
You have new mail in /root/Mail
[root@cp ~]# cd /usr/local/apnscp/
[root@cp apnscp]# git status
HEAD detached at v3.2.45.2
Untracked files:
  (use "git add <file>..." to include in what will be committed)
        lib/Opcenter/Dns/Providers/Powerdns
        share/
        storage/screenshots/
        storage/themes/apnscp.png
        storage/themes/classic.png
        storage/themes/launchpad.png
        storage/themes/material.png
        storage/themes/obsidian.png

nothing added to commit but untracked files present (use "git add" to track)
[root@cp apnscp]# 

Off branch, see Apache wont Start, error on mod_passenger - #6 by msaladna

cd /usr/local/apnscp
git status
git checkout master
git pull
# if this errors run:
git reset --hard origin/master
# run pending migrations
upcp

Thanks Matt, shows how often i do any admin on it. That’s all gone through, however now when i log in via nexus as the user;

         0. Error_Reporter::add_error("CSRF check failed. Login required.", )
            [/usr/local/apnscp/lib/log_wrapper.php:72]
         1. error("CSRF check failed. Login required.")
            [/usr/local/apnscp/lib/html/page_container.php:1072]
         2. Page_Container->_processPostback()
            [/usr/local/apnscp/lib/html/page_container.php:1031]
         3. Page_Container->handle_request()
            [/usr/local/apnscp/public/index.php:99]

along with

 Action failed

Page_Container::_processPostback(): CSRF check failed. Login required.

Log out, log back in. Ensure you’re using https; https cookie takes precedence over non-secure cookie.

1 Like

For sure, clearing my cache/logging out etc does give me a new error, some db stuff flashed up for a moment & then went away, leaving:

 0. Error_Reporter::merge_buffer([[message:"PostgreSQL::fetch_object(): database connection error - failed to retrieve record", severity:16, caller:"PostgreSQL::fetch_object", bt:"         0. Error_Reporter::add_error("database connection error - failed to retrieve record", )            [/usr/local/apnscp/lib/log_wrapper.php:72]         1. error("database connection error - failed to retrieve record")            [/usr/local/apnscp/lib/postgresql.php:271]         2. PostgreSQL->fetch_object()            [/usr/local/apnscp/lib/Auth/Info/User.php:194]         3. Auth_Info_User::initializeUser("admin", "", "x", "y")            [/usr/local/apn..."]])
            [/usr/local/apnscp/lib/html/page_container.php:152]
         1. Page_Container->__construct()
            [/usr/local/apnscp/apps/dashboard/dashboard.php:25]
         2. apps\dashboard\Page->__construct()
            [/usr/local/apnscp/lib/ContextableTrait.php:41]
         3. Page_Container::instantiateContexted(Auth_Info_User, )
            [/usr/local/apnscp/lib/html/page_container.php:404]
         4. Page_Container::init("\apps\dashboard\Page")
            [/usr/local/apnscp/public/index.php:98]

& on page:

Action failed

Telemetry disabled. Approximating CPU usage for
apps\dashboard\Page::__construct(): PostgreSQL::fetch_object(): database connection error - failed to retrieve record

Ensure upcp completed OK, which includes a database migration. If it completed OK, then PM me the results of:

env DEBUG=1 cpcmd common:whoami

Its kinda mixed messaging

[root@cp apnscp]# upcp
Enter passphrase for /root/.ssh/id_rsa: 
Migrating: 2024_11_22_101048_reseller-schema
Migrated:  2024_11_22_101048_reseller-schema (0.13 seconds)
Migrating: 2024_11_14_162936_platform-tweaks

PLAY [localhost] ***************************************************************
included: /usr/local/apnscp/resources/playbooks/migrations/2024_11_14_162936_platform-tweaks.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/set-configuration.yml for localhostincluded: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/setup-cyrus.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/configure-smarthost.yml for localhost

TASK [mail/configure-postfix : Update master.cf] *******************************
changed: [localhost]
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/register-password.yml for localhost
TASK [mail/configure-postfix : Create Postfix user] ****************************
changed: [localhost]
included: /usr/local/apnscp/resources/playbooks/roles/common/tasks/implicitly-import-overrides.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/set-configuration.yml for localhost
TASK [mail/configure-postfix : {{ item.value | default(false, true) | ternary('Set', 'Remove') }} {{item.key}} => {{ item.value}} in {{ config_file }}] ***
changed: [localhost] => (item=Set defer_transports => maintenance)
changed: [localhost] => (item=Set smtpd_tls_session_cache_database => )
changed: [localhost] => (item=Set smtp_tls_session_cache_database => btree:$data_directory/smtp_scache)
changed: [localhost] => (item=Set smtp_tls_session_cache_timeout => 1h)
changed: [localhost] => (item=Set address_verify_map => btree:/var/lib/postfix/verify_cache)
changed: [localhost] => (item=Set postscreen_cache_map => btree:/var/lib/postfix/postscreen_cache)
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/manage-alias.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/manage-alias.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/create-map.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/create-map.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/create-map.yml for localhost

TASK [software/tmpfiles : Update tmpfiles exclusion list] **********************
changed: [localhost] => (item=Setting /usr/local/apnscp/resources/playbooks/roles/software/tmpfiles/templates/apnscp.conf.j2)

RUNNING HANDLER [common : Restart postfix] *************************************
changed: [localhost]

PLAY RECAP *********************************************************************
localhost                  : ok=42   changed=5    unreachable=0    failed=0    skipped=20   rescued=0    ignored=0   


Migrated:  2024_11_14_162936_platform-tweaks
Migrating: 2024_12_13_145213_pyenv-switch

PLAY [localhost] ***************************************************************
included: /usr/local/apnscp/resources/playbooks/migrations/2024_12_13_145213_pyenv-switch.yml for localhost

TASK [common/migrate : Move reseller_id to id] *********************************
changed: [localhost]

TASK [common/migrate : Rename reseller_id within plans] ************************
changed: [localhost]

TASK [common/migrate : Clobber pyenv git tags] *********************************
changed: [localhost]
included: /usr/local/apnscp/resources/playbooks/roles/software/pyenv/tasks/enable-pyenv.yml for localhost

TASK [/usr/local/apnscp/resources/playbooks/roles/software/pyenv/../pyenv-support : Clone pyenv repository] ***
changed: [localhost]

TASK [software/pyenv : Add /usr/local/share/python/pyenv to wheel] *************
changed: [localhost]

TASK [software/pyenv : Create pyenv.sh] ****************************************
changed: [localhost]
included: /usr/local/apnscp/resources/playbooks/roles/common/tasks/copy-link.yml for localhost

TASK [software/pyenv : Copy /etc/profile.d/pyenv.sh to /home/virtual/FILESYSTEMTEMPLATE/ssh//etc/profile.d/pyenv.sh (cross-link protection)] ***
changed: [localhost]

RUNNING HANDLER [common : Reload filesystem template] **************************
changed: [localhost]

PLAY RECAP *********************************************************************
localhost                  : ok=34   changed=8    unreachable=0    failed=0    skipped=10   rescued=0    ignored=0   


Migrated:  2024_12_13_145213_pyenv-switch
Migrating: 2024_12_26_113057_catchall-transport-delivery

PLAY [localhost] ***************************************************************
included: /usr/local/apnscp/resources/playbooks/migrations/2024_12_26_113057_catchall-transport-delivery.yml for localhost

TASK [apnscp/initialize-filesystem-template : Install lmdb-libs into FST/siteinfo] ***
changed: [localhost]
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/set-configuration.yml for localhostincluded: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/setup-cyrus.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/configure-smarthost.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/register-password.yml for localhost
TASK [mail/configure-postfix : Create Postfix user] ****************************
changed: [localhost]
included: /usr/local/apnscp/resources/playbooks/roles/common/tasks/implicitly-import-overrides.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/set-configuration.yml for localhostincluded: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/manage-alias.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/manage-alias.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/create-map.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/create-map.yml for localhost
included: /usr/local/apnscp/resources/playbooks/roles/mail/configure-postfix/tasks/create-map.yml for localhost

RUNNING HANDLER [common : Reload filesystem template] **************************
changed: [localhost]

PLAY RECAP *********************************************************************
localhost                  : ok=47   changed=3    unreachable=0    failed=0    skipped=28   rescued=0    ignored=0   


Migrated:  2024_12_26_113057_catchall-transport-delivery
Updating to v3.2.45
warning: unable to unlink 'apps/changebilling/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/dashboard/views/partials/gauge-data/memory.blade.php': Permission denied
warning: unable to unlink 'apps/dashboard/views/partials/gauge-data/storage.blade.php': Permission denied
warning: unable to unlink 'apps/mailertable/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/majordomo/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/prlanguages/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/rspamd/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/verco/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/weblogging/views/index.blade.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Admin/Settings/Pagespeed/Enabled.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Admin/Settings/Pagespeed/StoragePersite.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Http/Apache/Maps/HSTS/Mode.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Http/Apache/Maps/Tls.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Mail/Services/Postfix/Maps/Map.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Mail/Services/Postfix/Maps/Transport.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Map/Contracts/RawString.php': Permission denied
Note: switching to 'v3.2.45'.

You are in 'detached HEAD' state. You can look around, make experimental
changes and commit them, and you can discard any commits you make in this
state without impacting any branches by switching back to a branch.

If you want to create a new branch to retain commits you create, you may
do so (now or later) by using -c with the switch command. Example:

  git switch -c <new-branch-name>

Or undo this operation with:

  git switch -

Turn off this advice by setting config variable advice.detachedHead to false

HEAD is now at b36a59c8 CHG: perform second pass scrub on direct filesystem (reissueAllCertificates) CHG: import matching CA into internal Let's Encrypt renweal registry (Formats\Cpanel) CHG: reimport missing Let's Encrypt certificates issued since June (migrations)
Installing dependencies from lock file (including require-dev)
Verifying lock file contents can be installed on current platform.
Nothing to install, update or remove
Package swiftmailer/swiftmailer is abandoned, you should avoid using it. Use symfony/mailer instead.
Package symfony/debug is abandoned, you should avoid using it. Use symfony/error-handler instead.
Package true/punycode is abandoned, you should avoid using it. No replacement was suggested.
Generating autoload files
90 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
Compiled services and packages files removed!
Nothing to migrate.
Nothing to migrate.
Updating to v3.2.45.1
Previous HEAD position was b36a59c8 CHG: perform second pass scrub on direct filesystem (reissueAllCertificates) CHG: import matching CA into internal Let's Encrypt renweal registry (Formats\Cpanel) CHG: reimport missing Let's Encrypt certificates issued since June (migrations)
HEAD is now at 18149118 CHG: callback order cannot be determined. Perform validity self-check before firing cleanup callbacks (Webapps) REM: deprecated utf8_decode usage (License)
Compiled services and packages files removed!
Nothing to migrate.
Nothing to migrate.
Updating to v3.2.45.2
Previous HEAD position was 18149118 CHG: callback order cannot be determined. Perform validity self-check before firing cleanup callbacks (Webapps) REM: deprecated utf8_decode usage (License)
HEAD is now at 3ec2e788 FIX: workaround for X1 intermediate CA expiry. Introduce a 1 in 10 lottery to perform a license renewal whenever an authority is within 30 days of expiration. Coordination policy has changed to introduce a new CA approximately 90 days of expiration. Next CA rotation, X2, will occur before on or before August 2, 2027. Licenses may be renewed before the automated license check using "bin/scripts/license.php renew --force" with ApisCP root. (License)
Compiled services and packages files removed!
Nothing to migrate.
Nothing to migrate.
You have new mail in /root/Mail

And what do all these commands report? upcp would have included the database migration, which does not get replayed once it’s run mentioned above in post #4.

Oh yeah my bad. This all precedes the upcp

[root@cp ~]# cd /usr/local/apnscp/
[root@cp apnscp]# git status
HEAD detached at v3.2.45.2
Untracked files:
  (use "git add <file>..." to include in what will be committed)
        lib/Opcenter/Dns/Providers/Powerdns
        share/
        storage/screenshots/
        storage/themes/apnscp.png
        storage/themes/classic.png
        storage/themes/launchpad.png
        storage/themes/material.png
        storage/themes/obsidian.png

nothing added to commit but untracked files present (use "git add" to track)
[root@cp apnscp]# cd /usr/local/apnscp
You have new mail in /root/Mail
[root@cp apnscp]# git status
HEAD detached at v3.2.45.2
Untracked files:
  (use "git add <file>..." to include in what will be committed)
        lib/Opcenter/Dns/Providers/Powerdns
        share/
        storage/screenshots/
        storage/themes/apnscp.png
        storage/themes/classic.png
        storage/themes/launchpad.png
        storage/themes/material.png
        storage/themes/obsidian.png

nothing added to commit but untracked files present (use "git add" to track)
[root@cp apnscp]# git checkout master
Previous HEAD position was 3ec2e788 FIX: workaround for X1 intermediate CA expiry. Introduce a 1 in 10 lottery to perform a license renewal whenever an authority is within 30 days of expiration. Coordination policy has changed to introduce a new CA approximately 90 days of expiration. Next CA rotation, X2, will occur before on or before August 2, 2027. Licenses may be renewed before the automated license check using "bin/scripts/license.php renew --force" with ApisCP root. (License)
Switched to branch 'master'
Your branch is behind 'origin/master' by 167 commits, and can be fast-forwarded.
  (use "git pull" to update your local branch)
[root@cp apnscp]# git pull
Updating 3bc3620a..6e794590
Fast-forward
 apps/bandwidthstat/views/bandwidth-display.blade.php                       |     4 +-
 apps/changebilling/{changebilling.tpl => views/index.blade.php}            |     4 +-
 apps/changeinfo/application.yml                                            |     5 +-
 apps/changeinfo/changeinfo.css                                             |     9 +
 apps/changeinfo/changeinfo.js                                              |    32 +-
 apps/changeinfo/changeinfo.php                                             |    64 +-
 apps/changeinfo/views/partials/admin.blade.php                             |     2 +-
 apps/changeinfo/views/partials/apps/webapps.blade.php                      |     6 +-
 apps/changeinfo/views/partials/security.blade.php                          |    74 +
 apps/changeinfo/views/partials/ssl.blade.php                               |    76 +-
 apps/changeinfo/views/partials/theme-behavior.blade.php                    |    13 +
 apps/changeinfo/views/partials/totp.blade.php                              |    35 +
 apps/changemysql/mysql_manager.js                                          |    17 +-
 apps/changemysql/views/add.blade.php                                       |     7 +-
 apps/changemysql/views/list.blade.php                                      |     7 +-
 apps/changepgsql/views/add.blade.php                                       |     2 +-
 apps/changepgsql/views/partials/modal.blade.php                            |     6 +-
 apps/crontab/views/partials/jobs/add.blade.php                             |     2 +-
 apps/dashboard/application.yml                                             |     3 +
 apps/dashboard/dashboard.css                                               |     4 +
 apps/dashboard/dashboard.js                                                |     6 +-
 apps/dashboard/dashboard.php                                               |    14 +-
 apps/dashboard/views/glances/rampart.blade.php                             |     4 +-
 apps/dashboard/views/glances/webapps.blade.php                             |     4 +-
 apps/dashboard/views/overview.blade.php                                    |     6 +-
 apps/dashboard/views/partials/crm/ticket-link.blade.php                    |     2 +-
 apps/dashboard/views/partials/gauge-data/memory.blade.php                  |    11 +
 apps/dashboard/views/partials/gauge-data/storage.blade.php                 |     9 +
 apps/dashboard/views/partials/gauge.blade.php                              |     1 +
 apps/dashboard/views/partials/modals/overage.blade.php                     |     6 +-
 apps/diskbd/diskbd.php                                                     |    26 +-
 apps/dns/dns.js                                                            |     7 +-
 apps/dns/dns.php                                                           |     8 +-
 apps/domainmanager/domainmanager.js                                        |     2 +-
 apps/domainmanager/domainmanager.php                                       |     4 +-
 apps/domainmanager/views/partials/add/advanced.blade.php                   |     2 +-
 apps/domainmanager/views/partials/add/preload-options.blade.php            |     2 +-
 apps/domainmanager/views/partials/view-domains.blade.php                   |     4 +-
 apps/error/views/404.blade.php                                             |     4 +-
 apps/filemanager/filemanager.js                                            |     7 +-
 apps/filemanager/filemanager.php                                           |     7 +-
 apps/filemanager/views/index.blade.php                                     |     2 +-
 apps/filemanager/views/partials/commands.blade.php                         |     4 +-
 apps/filemanager/views/partials/protected-resource.blade.php               |     4 +-
 apps/filemanager/views/view-file.blade.php                                 |     4 +-
 apps/horizon/horizon.php                                                   |     2 +
 apps/login/application.yml                                                 |    14 +-
 apps/login/login.css                                                       |     3 +
 apps/login/login.js                                                        |     2 +-
 apps/login/login.php                                                       |    95 +-
 apps/login/views/index.blade.php                                           |    21 +-
 apps/login/views/partials/forms/totp-challenge.blade.php                   |    46 +
 apps/logrotate/logrotate.js                                                |     4 +-
 apps/logrotate/views/index.blade.php                                       |     2 +-
 apps/mailboxcreate/application.yml                                         |     2 +-
 apps/mailboxroutes/application.yml                                         |     2 +-
 apps/mailboxroutes/mailboxroutes.php                                       |     4 +-
 apps/mailboxroutes/views/partials/address-list.blade.php                   |     2 +-
 apps/mailboxroutes/views/partials/create-address.blade.php                 |     4 +-
 apps/mailboxroutes/views/partials/disabled-addresses.blade.php             |     4 +-
 apps/mailboxroutes/views/partials/mailbox-edit-enabled.blade.php           |     2 +-
 apps/mailertable/{mailertable.tpl => views/index.blade.php}                |    61 +-
 apps/majordomo/application.yml                                             |     2 +-
 apps/majordomo/{majordomo.tpl => views/index.blade.php}                    |     8 +-
 apps/mysqlbackup/views/partials/no-databases.blade.php                     |     4 +-
 apps/nexus/application.yml                                                 |     4 +-
 apps/nexus/nexus.php                                                       |    15 +-
 apps/nexus/views/index.blade.php                                           |     2 +-
 apps/nexus/views/new.blade.php                                             |    32 +-
 apps/nexus/views/partials/first-run.blade.php                              |     6 +-
 apps/nexus/views/partials/list-accounts.blade.php                          |     4 +-
 apps/nexus/views/partials/return-overview.blade.php                        |     2 +-
 apps/packman/packman.php                                                   |     4 +-
 apps/packman/views/index.blade.php                                         |     2 +-
 apps/pagespeed/pagespeed.js                                                |     4 +-
 apps/pagespeed/pagespeed.php                                               |     2 +-
 apps/pagespeed/views/index.blade.php                                       |     2 +-
 apps/pagespeed/views/pagespeed-options.blade.php                           |     2 +-
 apps/pagespeed/views/partials/test-results.blade.php                       |     6 +-
 apps/personalities/personalities.php                                       |     2 +-
 apps/personalities/views/partials/actions.blade.php                        |     2 +-
 apps/php-pools/application.yml                                             |     4 +-
 apps/phpmyadmin/views/partials/sso-failed.blade.php                        |     4 +-
 apps/phppgadmin/views/partials/sso-failed.blade.php                        |     2 +-
 apps/prlanguages/{prlanguages.tpl => views/index.blade.php}                |     6 +-
 apps/quotatracker/quotatracker.php                                         |     4 +-
 apps/rspamd/rspamd.php                                                     |     1 -
 apps/rspamd/{rspamd.tpl => views/index.blade.php}                          |     2 +-
 apps/scopes/models/Scope.php                                               |     2 +-
 apps/scopes/models/scopes/Cp/Bootstrapper.php                              |     5 +-
 apps/scopes/models/scopes/Cp/Config.php                                    |     2 +-
 apps/scopes/scopes.js                                                      |     5 +-
 apps/scopes/views/index.blade.php                                          |     2 +-
 apps/scopes/views/partials/scope-edit-form.blade.php                       |     4 +-
 apps/scopes/views/partials/scope-internals/type-array.blade.php            |     3 +
 apps/scopes/views/partials/scope-related.blade.php                         |     2 +-
 apps/scopes/views/partials/scope-scene.blade.php                           |     6 +-
 apps/scopes/views/partials/scope-settings.blade.php                        |     4 +-
 apps/scopes/views/partials/scopes/cp/bootstrapper/scope-scene.blade.php    |     4 +-
 apps/scopes/views/partials/show-all.blade.php                              |     2 +-
 apps/setup/models/Authentication.php                                       |     7 +-
 apps/soapkeys/views/index.blade.php                                        |     2 +-
 apps/spf/spf.php                                                           |    15 +-
 apps/spf/views/index.blade.php                                             |     2 +-
 apps/ssl/Certificate.php                                                   |    66 -
 apps/ssl/CertificateResource.php                                           |    27 +-
 apps/ssl/ssl.js                                                            |     4 +-
 apps/ssl/views/index.blade.php                                             |     2 +-
 apps/subdomains/application.yml                                            |     2 +-
 apps/subdomains/subdomains.js                                              |     2 +-
 apps/subdomains/subdomains.php                                             |    11 +-
 apps/subdomains/views/list-subdomains.blade.php                            |     4 +-
 apps/summary/summary.php                                                   |    17 +-
 apps/template/views/index.blade.php                                        |     7 +-
 apps/terminal/views/index.blade.php                                        |     2 +-
 apps/traceroute/traceroute.php                                             |     5 +-
 apps/useradd/useradd.js                                                    |     4 +-
 apps/useradd/useradd.php                                                   |    26 +-
 apps/useradd/views/index.blade.php                                         |     6 +-
 apps/usermanage/usermanage.php                                             |    19 +-
 apps/usermanage/views/index.blade.php                                      |    12 +-
 apps/verco/{verco.tpl => views/index.blade.php}                            |     2 +-
 apps/webapps/models/AppState.php                                           |    49 +
 apps/webapps/models/InstallableAppSearch.php                               |     5 +
 apps/webapps/views/edit.blade.php                                          |    71 +-
 apps/webapps/views/layout/app-state.blade.php                              |    13 +
 apps/webapps/views/layout/list-actions.blade.php                           |     6 +-
 apps/webapps/views/partials/actions.blade.php                              |     2 +-
 apps/webapps/views/partials/actions/file-manager.blade.php                 |     2 +-
 apps/webapps/views/partials/app-meta.blade.php                             |     2 +-
 apps/webapps/views/partials/detection-required.blade.php                   |    15 +-
 apps/webapps/views/partials/failed-install.blade.php                       |    14 +
 apps/webapps/views/partials/failed-update.blade.php                        |    21 +
 apps/webapps/views/partials/install-app-grid.blade.php                     |     2 +-
 apps/webapps/views/partials/options-wrapper.blade.php                      |     4 +-
 apps/webapps/views/partials/options/global.blade.php                       |     2 +-
 apps/webapps/views/partials/options/install/global.blade.php               |     2 +-
 apps/webapps/webapps.js                                                    |     4 +-
 apps/webapps/webapps.php                                                   |   109 +-
 apps/webdav/views/index.blade.php                                          |     4 +-
 apps/webdav/webdav.js                                                      |     4 +-
 apps/webdisk/webdisk.js                                                    |     6 +-
 apps/weblogging/{weblogging.tpl => views/index.blade.php}                  |    10 +-
 apps/webmail/dummyset.php                                                  |     6 +-
 artisan                                                                    |    33 +-
 bin/ActivateReseller                                                       |    46 +
 bin/AddReseller                                                            |    49 +
 bin/DeleteDomain                                                           |     4 +-
 bin/DeleteReseller                                                         |   121 +
 bin/EditReseller                                                           |   150 +
 bin/SuspendReseller                                                        |    47 +
 bin/scripts/backup_dbs.php                                                 |    21 +-
 bin/scripts/bwcron.php                                                     |     2 +-
 bin/scripts/license.php                                                    |     4 +-
 bin/scripts/mapCheck.php                                                   |   101 +-
 bin/scripts/reissueAllCertificates.php                                     |   173 +-
 bin/scripts/tabulate_bandwidth.php                                         |     2 +-
 bin/scripts/transfersite.php                                               |    23 +-
 build/upcp.sh                                                              |    72 +-
 composer.json                                                              |     8 +-
 composer.lock                                                              |   709 +-
 config/config.ini                                                          |    55 +-
 config/httpd.conf                                                          |    40 +-
 config/php.ini.dist                                                        |     4 +-
 docs/.vuepress/config.js                                                   |     1 +
 docs/FIREWALL.md                                                           |     2 +-
 docs/INSTALL.md                                                            |    29 +-
 docs/PROGRAMMING.md                                                        |    12 +-
 docs/README.md                                                             |    13 +-
 docs/SECURITY.md                                                           |    43 +-
 docs/UPGRADING.md                                                          |    20 +-
 docs/admin/Authentication.md                                               |    25 +-
 docs/admin/Customizing.md                                                  |    15 +
 docs/admin/DNS.md                                                          |     2 +-
 docs/admin/Migrations - server.md                                          |     4 +-
 docs/admin/PHP-FPM.md                                                      |     6 +-
 docs/admin/Plans.md                                                        |    16 +
 docs/admin/Resource enforcement.md                                         |    20 +
 docs/admin/SSL.md                                                          |    19 +-
 docs/admin/Smtp.md                                                         |     4 +
 docs/admin/images/multipath-collision.png                                  |   Bin 0 -> 4209 bytes
 lib/Auth.php                                                               |    17 +-
 lib/Auth/DAV.php                                                           |     8 +-
 lib/Auth/Info/User.php                                                     |    90 +-
 lib/Auth/SOAP.php                                                          |    35 +-
 lib/Auth/Stub.php                                                          |     1 +
 lib/Auth/TOTP.php                                                          |   159 +
 lib/Auth/UI.php                                                            |    92 +-
 lib/BladeLite.php                                                          |     2 +-
 lib/CLI/MockFilesystem.php                                                 |    50 +
 lib/CLI/Shell.php                                                          |     9 +-
 lib/CLI/Shell/Extensions/Colour.php                                        |     4 +-
 lib/CLI/Transfer.php                                                       |   122 +-
 lib/CLI/Transfer/Fixup.php                                                 |     6 +-
 lib/CLI/Transfer/Notify.php                                                |     1 +
 lib/CLI/Yum/Synchronizer.php                                               |     2 +-
 lib/CLI/Yum/Synchronizer/Depends.php                                       |     2 +-
 lib/CLI/Yum/Synchronizer/Plugins/Alternatives.php                          |    48 +-
 lib/CLI/Yum/Synchronizer/Plugins/AlternativesTrigger.php                   |    16 +-
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/Coreutils.php                     |     2 +-
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/ImageMagick.php                   |    75 +
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/ImageMagickLibs.php               |    35 +
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/Php83Runtime.php                  |    25 +
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/Php84Runtime.php                  |    25 +
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/Postgresql16.php                  |    23 +
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/Postgresql16Libs.php              |    22 +
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/Postgresql17.php                  |    23 +
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/Postgresql17Libs.php              |    22 +
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/Timescaledb2Postgresql16.php      |    22 +
 lib/CLI/Yum/Synchronizer/Plugins/Trigger/Timescaledb2Postgresql17.php      |    22 +
 .../Yum/Synchronizer/Plugins/Trigger/TimescaledbPostgresqlAnyVersion.php   |     7 +-
 lib/CLI/Yum/Synchronizer/SynchronizerCache.php                             |     4 +-
 lib/CLI/Yum/Synchronizer/Utils.php                                         |    60 +-
 lib/CLI/cmd.php                                                            |    15 +-
 lib/Cache/Mproxy.php                                                       |     2 +-
 lib/CancellableQueue.php                                                   |    25 +
 lib/Cronus.php                                                             |     8 +-
 lib/Daphnie/Chunker.php                                                    |     2 +-
 lib/Daphnie/Collector.php                                                  |     2 +-
 lib/Daphnie/MetricBroker.php                                               |     2 +-
 lib/Daphnie/Query/Generic.php                                              |     8 +-
 lib/Daphnie/Query/v2.php                                                   |     6 +-
 lib/Dav/Server.php                                                         |     4 +-
 lib/Deferred.php                                                           |     7 +-
 lib/Event/Manager.php                                                      |     3 +
 lib/FilesystemPathTrait.php                                                |    10 +-
 lib/Frontend/Multipath.php                                                 |    50 +
 lib/Frontend/Tour.php                                                      |     4 +-
 lib/HTTP/Cache.php                                                         |     2 +-
 lib/HTTP/Request2/Adapter/Socket.php                                       |     2 +-
 lib/ImpersonableTrait.php                                                  |    22 +-
 lib/Lararia/Console/Commands/ClearCommand.php                              |    36 +
 lib/Lararia/Console/Commands/OpcenterPlanCommand.php                       |   144 +-
 lib/Lararia/Database/Migrations/Creator.php                                |     2 +-
 lib/Lararia/Database/Migrations/DatabaseMigrationRepository.php            |     2 +-
 lib/Lararia/Database/Migrations/PlatformMigrator.php                       |     2 +-
 lib/Lararia/JobDaemon.php                                                  |     3 +-
 lib/Lararia/Jobs/BootstrapperTask.php                                      |     2 +-
 lib/Lararia/Jobs/InstallAppJob.php                                         |     5 +-
 lib/Lararia/Jobs/Job.php                                                   |    15 +-
 lib/Lararia/Providers/AppServiceProvider.php                               |     2 +-
 lib/Lararia/View/ViewServiceProvider.php                                   |    10 +-
 lib/Mail/Mail/smtp.php                                                     |     7 +-
 lib/Mail/Mail/smtpmx.php                                                   |     6 +-
 lib/Module/Provider.php                                                    |     2 +-
 lib/Module/Skeleton/Contracts/Tasking.php                                  |    24 +
 lib/Module/Skeleton/Standard.php                                           |     3 +-
 lib/Module/Support/Auth.php                                                |     3 +-
 lib/Module/Support/Dns.php                                                 |    15 +-
 lib/Module/Support/Letsencrypt.php                                         |    58 +-
 lib/Module/Support/Sql.php                                                 |    29 +-
 lib/Module/Support/Webapps.php                                             |   202 +-
 lib/Module/Support/Webapps/App/Installer.php                               |    14 +-
 lib/Module/Support/Webapps/App/Loader.php                                  |    10 +
 lib/Module/Support/Webapps/App/Reconfigurator.php                          |     1 +
 lib/Module/Support/Webapps/App/Type/Bookstack/module.php                   |     2 +-
 lib/Module/Support/Webapps/App/Type/Discourse/Launcher.php                 |     4 +-
 lib/Module/Support/Webapps/App/Type/Discourse/module.php                   |    60 +-
 .../Support/Webapps/App/Type/Discourse/views/job-installed.blade.php       |     2 +-
 .../Support/Webapps/App/Type/Discourse/views/unicorn-launcher.blade.php    |     4 +-
 lib/Module/Support/Webapps/App/Type/Drupal/module.php                      |    15 +-
 lib/Module/Support/Webapps/App/Type/Ghost/module.php                       |   103 +-
 lib/Module/Support/Webapps/App/Type/Invoiceninja/module.php                |     6 +-
 lib/Module/Support/Webapps/App/Type/Joomla/module.php                      |     5 -
 lib/Module/Support/Webapps/App/Type/Laravel/Messages.php                   |    38 +
 lib/Module/Support/Webapps/App/Type/Laravel/Reconfiguration/Ssl.php        |    11 +-
 lib/Module/Support/Webapps/App/Type/Laravel/Reconfiguration/Verlock.php    |     4 +
 lib/Module/Support/Webapps/App/Type/Laravel/module.php                     |    93 +-
 lib/Module/Support/Webapps/App/Type/Nextcloud/Reconfiguration/Migrate.php  |     2 +-
 lib/Module/Support/Webapps/App/Type/Nextcloud/module.php                   |    10 +-
 lib/Module/Support/Webapps/App/Type/Passenger/Handler.php                  |     4 +-
 lib/Module/Support/Webapps/App/Type/Unknown/Handler.php                    |    33 +-
 lib/Module/Support/Webapps/App/Type/Unknown/Reconfiguration/Fortify.php    |    42 +
 lib/Module/Support/Webapps/App/Type/Unknown/Reconfiguration/Ssl.php        |    28 +-
 lib/Module/Support/Webapps/App/Type/Unknown/Reconfiguration/User.php       |     2 +-
 lib/Module/Support/Webapps/App/Type/Vanilla/module.php                     |     6 +-
 lib/Module/Support/Webapps/App/Type/Wordpress/Reconfiguration/Migrate.php  |     2 +-
 lib/Module/Support/Webapps/App/Type/Wordpress/Reconfiguration/User.php     |    47 +
 lib/Module/Support/Webapps/App/Type/Wordpress/module.php                   |   253 +-
 lib/Module/Support/Webapps/App/UIPanel/Element.php                         |    16 +-
 lib/Module/Support/Webapps/Composer.php                                    |    18 +-
 lib/Module/Support/Webapps/ComposerWrapper.php                             |     2 +-
 lib/Module/Support/Webapps/Messages.php                                    |   138 +
 lib/Module/Support/Webapps/MetaManager/Meta.php                            |    15 +-
 lib/Module/Support/Webapps/Passenger.php                                   |     6 +-
 lib/Module/Support/Webapps/PathManager.php                                 |     2 +-
 lib/Module/Support/Webapps/Traits/WebappUtilities.php                      |     2 +-
 lib/Module/Support/Webapps/UpdateCandidate.php                             |     3 +-
 lib/Module/Support/Webapps/VersionFetcher.php                              |     4 +-
 lib/Module/Support/Webapps/VersionFetcher/Github.php                       |     4 +
 lib/Net/Gethost.php                                                        |     7 +-
 lib/Net/WSDL.php                                                           |    12 +-
 lib/Opcenter.php                                                           |    20 +-
 lib/Opcenter/Account/Bless.php                                             |    35 +
 lib/Opcenter/Account/Create.php                                            |     6 +-
 lib/Opcenter/Account/Delete.php                                            |    11 +-
 lib/Opcenter/Account/DomainOperation.php                                   |     4 +-
 lib/Opcenter/Account/Enumerate.php                                         |     2 +-
 lib/Opcenter/Account/State.php                                             |     2 +-
 lib/Opcenter/Admin/Bootstrapper/Accelerator.php                            |     6 +-
 lib/Opcenter/Admin/Bootstrapper/Config.php                                 |     2 +-
 lib/Opcenter/Admin/Settings/Apache/Mutex.php                               |     4 +-
 lib/Opcenter/Admin/Settings/Apache/Ports.php                               |    10 +-
 lib/Opcenter/Admin/Settings/Cgroup/Version.php                             |     7 +
 lib/Opcenter/Admin/Settings/Cp/Role.php                                    |   127 +
 lib/Opcenter/Admin/Settings/Cp/UpdateOffset.php                            |    67 +
 lib/Opcenter/Admin/Settings/Cp/UpdatePolicy.php                            |     2 +-
 lib/Opcenter/Admin/Settings/Cp/Workers.php                                 |     2 +-
 lib/Opcenter/Admin/Settings/Dns/Ip4Pool.php                                |     2 +-
 lib/Opcenter/Admin/Settings/Messages.php                                   |     7 +
 lib/Opcenter/Admin/Settings/Mysql/BigSelects.php                           |    60 +
 lib/Opcenter/Admin/Settings/Mysql/ListeningIps.php                         |    81 +
 lib/Opcenter/Admin/Settings/Pagespeed/Enabled.php                          |    61 +
 lib/Opcenter/Admin/Settings/Pagespeed/StoragePersite.php                   |    61 +
 lib/Opcenter/Admin/Settings/Pgsql/ListeningIps.php                         |    86 +
 lib/Opcenter/Admin/Settings/Php/Version.php                                |    16 +-
 lib/Opcenter/Admin/Settings/Rampart/Fail2banWhitelist.php                  |    36 +-
 lib/Opcenter/Admin/Settings/Setting.php                                    |     2 +-
 lib/Opcenter/Admin/Settings/System/ProcessLimits.php                       |     9 +-
// lots more file listings

And second half…

# if this errors run:
git reset --hard origin/master
# run pending migrations
upcp

I’d need to know if the aforementioned command completed successfully or errored and if errored, what the results of git reset --hard origin/master is as discussed in the initial post linked…

Apologies, ill try find & update, In meantime:

[root@cp apnscp]# git reset --hard origin/master
HEAD is now at 6e794590 FIX: API deprecation 2024-11-30, "Zone information in individual DNS records" (Cloudflare)
You have new mail in /root/Mail

Should be good to go at this time, assuming upcp now reports nothing of concern.

Thanks for your help, im now getting a db error about reseller. If its any use, I haven’t updated in a very long time.

[root@cp apnscp]# upcp
Enter passphrase for /root/.ssh/id_rsa: 
Updating to v3.2.45
warning: unable to unlink 'apps/changebilling/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/dashboard/views/partials/gauge-data/memory.blade.php': Permission denied
warning: unable to unlink 'apps/dashboard/views/partials/gauge-data/storage.blade.php': Permission denied
warning: unable to unlink 'apps/mailertable/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/majordomo/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/prlanguages/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/rspamd/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/verco/views/index.blade.php': Permission denied
warning: unable to unlink 'apps/weblogging/views/index.blade.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Admin/Settings/Pagespeed/Enabled.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Admin/Settings/Pagespeed/StoragePersite.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Http/Apache/Maps/HSTS/Mode.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Http/Apache/Maps/Tls.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Mail/Services/Postfix/Maps/Map.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Mail/Services/Postfix/Maps/Transport.php': Permission denied
warning: unable to unlink 'lib/Opcenter/Map/Contracts/RawString.php': Permission denied
Previous HEAD position was 6e794590 FIX: API deprecation 2024-11-30, "Zone information in individual DNS records" (Cloudflare)
HEAD is now at b36a59c8 CHG: perform second pass scrub on direct filesystem (reissueAllCertificates) CHG: import matching CA into internal Let's Encrypt renweal registry (Formats\Cpanel) CHG: reimport missing Let's Encrypt certificates issued since June (migrations)
Installing dependencies from lock file (including require-dev)
Verifying lock file contents can be installed on current platform.
Nothing to install, update or remove
Package swiftmailer/swiftmailer is abandoned, you should avoid using it. Use symfony/mailer instead.
Package symfony/debug is abandoned, you should avoid using it. Use symfony/error-handler instead.
Package true/punycode is abandoned, you should avoid using it. No replacement was suggested.
Generating autoload files
90 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
Compiled services and packages files removed!
Nothing to migrate.
Nothing to migrate.
Updating to v3.2.45.1
Previous HEAD position was b36a59c8 CHG: perform second pass scrub on direct filesystem (reissueAllCertificates) CHG: import matching CA into internal Let's Encrypt renweal registry (Formats\Cpanel) CHG: reimport missing Let's Encrypt certificates issued since June (migrations)
HEAD is now at 18149118 CHG: callback order cannot be determined. Perform validity self-check before firing cleanup callbacks (Webapps) REM: deprecated utf8_decode usage (License)
WARNING: pg_query(): Query failed: ERROR:  relation "reseller_info" does not exist
LINE 1: SELECT password FROM reseller_info WHERE username = 'admin'
                             ^ 
[/usr/local/apnscp/lib/postgresql.php:183]

         0. pg_query(PgSql\Connection, "SELECT password FROM reseller_info WHERE username = 'admin'")
            [/usr/local/apnscp/lib/postgresql.php:183]
         1. PostgreSQL->query("SELECT password FROM reseller_info WHERE username = 'admin'")
            [/usr/local/apnscp/lib/Auth/Info/User.php:194]
         2. Auth_Info_User::initializeUser("admin", null, null, "4wItYxqJ9CF2SewuO06gV2Pu43nJHO0k")
            [/usr/local/apnscp/lib/Auth.php:845]
         3. Auth->initializeUser("admin", null, null)
            [/usr/local/apnscp/lib/Auth/CLI.php:49]
         4. Auth_CLI->authenticate()
            [/usr/local/apnscp/lib/Auth.php:61]
         5. Auth::handle()
            [/usr/local/apnscp/artisan:44]
(Exception) INTERNAL REPORT: ERROR:  relation "reseller_info" does not exist
LINE 1: SELECT password FROM reseller_info WHERE username = 'admin'
                             ^ 

         0. Error_Reporter::report("ERROR:  relation "reseller_info" does not existLINE 1: SELECT password FROM reseller_info WHERE username = 'admin'                             ^")
            [/usr/local/apnscp/lib/postgresql.php:187]
         1. PostgreSQL->query("SELECT password FROM reseller_info WHERE username = 'admin'")
            [/usr/local/apnscp/lib/Auth/Info/User.php:194]
         2. Auth_Info_User::initializeUser("admin", null, null, "4wItYxqJ9CF2SewuO06gV2Pu43nJHO0k")
            [/usr/local/apnscp/lib/Auth.php:845]
         3. Auth->initializeUser("admin", null, null)
            [/usr/local/apnscp/lib/Auth/CLI.php:49]
         4. Auth_CLI->authenticate()
            [/usr/local/apnscp/lib/Auth.php:61]
         5. Auth::handle()
            [/usr/local/apnscp/artisan:44]
DEPRECATED: pg_last_error(): Automatic fetching of PostgreSQL connection is deprecated 
[/usr/local/apnscp/lib/postgresql.php:270]

         0. pg_last_error()
            [/usr/local/apnscp/lib/postgresql.php:270]
         1. PostgreSQL->fetch_object()
            [/usr/local/apnscp/lib/Auth/Info/User.php:194]
         2. Auth_Info_User::initializeUser("admin", null, null, "4wItYxqJ9CF2SewuO06gV2Pu43nJHO0k")
            [/usr/local/apnscp/lib/Auth.php:845]
         3. Auth->initializeUser("admin", null, null)
            [/usr/local/apnscp/lib/Auth/CLI.php:49]
         4. Auth_CLI->authenticate()
            [/usr/local/apnscp/lib/Auth.php:61]
         5. Auth::handle()
            [/usr/local/apnscp/artisan:44]
(Exception) INTERNAL REPORT: ERROR:  relation "reseller_info" does not exist
LINE 1: SELECT password FROM reseller_info WHERE username = 'admin'
                             ^ 

         0. Error_Reporter::report("ERROR:  relation "reseller_info" does not existLINE 1: SELECT password FROM reseller_info WHERE username = 'admin'                             ^", )
            [/usr/local/apnscp/lib/log_wrapper.php:191]
         1. report("ERROR:  relation "reseller_info" does not existLINE 1: SELECT password FROM reseller_info WHERE username = 'admin'                             ^")
            [/usr/local/apnscp/lib/postgresql.php:270]
         2. PostgreSQL->fetch_object()
            [/usr/local/apnscp/lib/Auth/Info/User.php:194]
         3. Auth_Info_User::initializeUser("admin", null, null, "4wItYxqJ9CF2SewuO06gV2Pu43nJHO0k")
            [/usr/local/apnscp/lib/Auth.php:845]
         4. Auth->initializeUser("admin", null, null)
            [/usr/local/apnscp/lib/Auth/CLI.php:49]
         5. Auth_CLI->authenticate()
            [/usr/local/apnscp/lib/Auth.php:61]
         6. Auth::handle()
            [/usr/local/apnscp/artisan:44]
ERROR  : PostgreSQL::fetch_object(): database connection error - failed to retrieve record
         0. Error_Reporter::add_error("database connection error - failed to retrieve record", )
            [/usr/local/apnscp/lib/log_wrapper.php:72]
         1. error("database connection error - failed to retrieve record")
            [/usr/local/apnscp/lib/postgresql.php:271]
         2. PostgreSQL->fetch_object()
            [/usr/local/apnscp/lib/Auth/Info/User.php:194]
         3. Auth_Info_User::initializeUser("admin", null, null, "4wItYxqJ9CF2SewuO06gV2Pu43nJHO0k")
            [/usr/local/apnscp/lib/Auth.php:845]
         4. Auth->initializeUser("admin", null, null)
            [/usr/local/apnscp/lib/Auth/CLI.php:49]
         5. Auth_CLI->authenticate()
            [/usr/local/apnscp/lib/Auth.php:61]
         6. Auth::handle()
            [/usr/local/apnscp/artisan:44]
Compiled services and packages files removed!
WARNING: pg_query(): Query failed: ERROR:  relation "reseller_info" does not exist
LINE 1: SELECT password FROM reseller_info WHERE username = 'admin'
                             ^ 
[/usr/local/apnscp/lib/postgresql.php:183]

         0. pg_query(PgSql\Connection, "SELECT password FROM reseller_info WHERE username = 'admin'")
            [/usr/local/apnscp/lib/postgresql.php:183]
         1. PostgreSQL->query("SELECT password FROM reseller_info WHERE username = 'admin'")
            [/usr/local/apnscp/lib/Auth/Info/User.php:194]
         2. Auth_Info_User::initializeUser("admin", null, null, "4wItYxqJ9CF2SewuO06gV2Pu43nJHO0k")
            [/usr/local/apnscp/lib/Auth.php:845]
         3. Auth->initializeUser("admin", null, null)
            [/usr/local/apnscp/lib/Auth/CLI.php:49]
         4. Auth_CLI->authenticate()
            [/usr/local/apnscp/lib/Auth.php:61]
         5. Auth::handle()
            [/usr/local/apnscp/artisan:44]
(Exception) INTERNAL REPORT: ERROR:  relation "reseller_info" does not exist
LINE 1: SELECT password FROM reseller_info WHERE username = 'admin'
                             ^ 

         0. Error_Reporter::report("ERROR:  relation "reseller_info" does not existLINE 1: SELECT password FROM reseller_info WHERE username = 'admin'                             ^")
            [/usr/local/apnscp/lib/postgresql.php:187]
         1. PostgreSQL->query("SELECT password FROM reseller_info WHERE username = 'admin'")
            [/usr/local/apnscp/lib/Auth/Info/User.php:194]
         2. Auth_Info_User::initializeUser("admin", null, null, "4wItYxqJ9CF2SewuO06gV2Pu43nJHO0k")
            [/usr/local/apnscp/lib/Auth.php:845]
         3. Auth->initializeUser("admin", null, null)
            [/usr/local/apnscp/lib/Auth/CLI.php:49]
         4. Auth_CLI->authenticate()
            [/usr/local/apnscp/lib/Auth.php:61]
         5. Auth::handle()
            [/usr/local/apnscp/artisan:44]
string(146) "ERROR:  relation "reseller_info" does not exist
LINE 1: SELECT password FROM reseller_info WHERE username = 'admin'
                             ^"
Query: SELECT password FROM reseller_info WHERE username = 'admin'
DEPRECATED: pg_last_error(): Automatic fetching of PostgreSQL connection is deprecated 
[/usr/local/apnscp/lib/postgresql.php:270]

         0. pg_last_error()
            [/usr/local/apnscp/lib/postgresql.php:270]
         1. PostgreSQL->fetch_object()
            [/usr/local/apnscp/lib/Auth/Info/User.php:194]
         2. Auth_Info_User::initializeUser("admin", null, null, "4wItYxqJ9CF2SewuO06gV2Pu43nJHO0k")
            [/usr/local/apnscp/lib/Auth.php:845]
         3. Auth->initializeUser("admin", null, null)
            [/usr/local/apnscp/lib/Auth/CLI.php:49]
         4. Auth_CLI->authenticate()
            [/usr/local/apnscp/lib/Auth.php:61]
         5. Auth::handle()
            [/usr/local/apnscp/artisan:44]
(Exception) INTERNAL REPORT: ERROR:  relation "reseller_info" does not exist
LINE 1: SELECT password FROM reseller_info WHERE username = 'admin'
                             ^ 

         0. Error_Reporter::report("ERROR:  relation "reseller_info" does not existLINE 1: SELECT password FROM reseller_info WHERE username = 'admin'                             ^", )
            [/usr/local/apnscp/lib/log_wrapper.php:191]
         1. report("ERROR:  relation "reseller_info" does not existLINE 1: SELECT password FROM reseller_info WHERE username = 'admin'                             ^")
            [/usr/local/apnscp/lib/postgresql.php:270]
         2. PostgreSQL->fetch_object()
            [/usr/local/apnscp/lib/Auth/Info/User.php:194]
         3. Auth_Info_User::initializeUser("admin", null, null, "4wItYxqJ9CF2SewuO06gV2Pu43nJHO0k")
            [/usr/local/apnscp/lib/Auth.php:845]
         4. Auth->initializeUser("admin", null, null)
            [/usr/local/apnscp/lib/Auth/CLI.php:49]
         5. Auth_CLI->authenticate()
            [/usr/local/apnscp/lib/Auth.php:61]
         6. Auth::handle()
            [/usr/local/apnscp/artisan:44]
Nothing to migrate.
Nothing to migrate.
Updating to v3.2.45.2
Previous HEAD position was 18149118 CHG: callback order cannot be determined. Perform validity self-check before firing cleanup callbacks (Webapps) REM: deprecated utf8_decode usage (License)
HEAD is now at 3ec2e788 FIX: workaround for X1 intermediate CA expiry. Introduce a 1 in 10 lottery to perform a license renewal whenever an authority is within 30 days of expiration. Coordination policy has changed to introduce a new CA approximately 90 days of expiration. Next CA rotation, X2, will occur before on or before August 2, 2027. Licenses may be renewed before the automated license check using "bin/scripts/license.php renew --force" with ApisCP root. (License)
Compiled services and packages files removed!
Nothing to migrate.
Nothing to migrate.
You have new mail in /root/Mail
[root@cp apnscp]# upcp
Enter passphrase for /root/.ssh/id_rsa: 
Updating to v3.2.45

That’s the problem. What does cpcmd scope:get cp.update-policy report? If edge or edge-major, try these 2 commands:

git reset --hard origin/master
git pull origin/master

If you’re on major, then switch to edge cpcmd scope:set cp.update-policy edge-major as the Cloudflare fix isn’t available yet in a signed release.

1 Like

Thank you, working as expected now on edge. appreciate the help

Hi
i was transferd to this post from Server to server migration fails databaseconnectionerror - #3
still the same error…

Provide all commands that you ran as well as their corresponding output…

Now working, when the server was updated to the latest version :slight_smile: