Yet another Fresh Install Fails thread...

Support
1

Rocky 10, gets to here and fails.
Attempted to resume and it failed again.

Confirmed both databases appldb in psql and apnscp in mysql exist.

TASK [apnscp/initialize-db : Perform database migration] **********************************************************************************************************************************************************************************************************************************************************
fatal: [localhost]: FAILED! => changed=true 
  cmd: ./artisan migrate --dbonly --force
  delta: '0:00:00.311915'
  end: '2026-02-20 17:50:05.161564'
  msg: non-zero return code
  rc: 255
  start: '2026-02-20 17:50:04.849649'
  stderr: |-
    PHP Fatal error:  Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "reseller_sites" does not exist
    LINE 9:                 LEFT JOIN reseller_sites USING(site_id)
                                      ^ in /usr/local/apnscp/lib/Auth/Info/User.php:310
    Stack trace:
    #0 /usr/local/apnscp/lib/Auth/Info/User.php(310): PDO->query('SELECT username...')
    #1 /usr/local/apnscp/lib/Auth.php(476): Auth_Info_User::factory('A9HG1787ivT8deG...')
    #2 /usr/local/apnscp/lib/Auth.php(450): Auth->__importUser(true)
    #3 /usr/local/apnscp/lib/Auth.php(437): Auth->authInfo(true)
    #4 /usr/local/apnscp/lib/Auth.php(430): Auth->getProfile()
    #5 /usr/local/apnscp/lib/error_reporter.php(1597): Auth::profile()
    #6 /usr/local/apnscp/lib/error_reporter.php(288): Error_Reporter::uuid(Object(PDOException))
    #7 /usr/local/apnscp/lib/error_reporter.php(161): Error_Reporter::handle_error(128, 'SQLSTATE[42P01]...', '/usr/local/apns...', 310, Object(PDOException))
    #8 [internal function]: Error_Reporter::handle_exception(Object(PDOException))
    #9 {main}
      thrown in /usr/local/apnscp/lib/Auth/Info/User.php on line 310
  stderr_lines: <omitted>
  stdout: ''
  stdout_lines: <omitted>

PLAY RECAP ********************************************************************************************************************************************************************************************************************************************************************************************************
localhost                  : ok=748  changed=261  unreachable=0    failed=1    skipped=256  rescued=1    ignored=11
2

Thank you for your feedback.

There’s not enough information to solve this issue as of yet. In order to proceed with resolving this, I will require further information:

  • What’s the version of PostgreSQL, which distribution?
  • What was the install command?
  • What’s the full install log? You may PM or email it (matt@apisnetworks.com), /root/apnscp-bootstrapper.log
  • Was there anything remarkable about this event?

Based upon limited feedback, I am not able to reproduce nor adequately research. I ran a basic install against Rocky 10 on Vultr with default settings:

curl https://raw.githubusercontent.com/apisnetworks/apiscp-bootstrapper/master/bootstrap.sh | bash -s - -s use_robust_dns='true' -s always_permit_panel_login='true' -s php_install_ioncube='true' -s dns_default_provider='null' -s whitelist_ip='64.22.68.9'

This completed without issue. The install is available here: https://96.30.205.20:2083. I’d be more than happy to PM credentials upon request for you to evaluate it.

[[Aroot@vultr:~# grep 'Perform data' -B20 -A20 apnscp-bootstrapper.log
  site_id,
  DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  SUM("in_bytes") AS in_bytes,
  SUM("out_bytes") AS out_bytes,
  SUM("in_bytes"+"out_bytes") AS total
FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
2026-02-20 20:00:25,101 p=1559 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
2026-02-20 20:00:25,256 p=1559 u=root n=ansible | ok: [localhost]
2026-02-20 20:00:25,286 p=1559 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
2026-02-20 20:00:25,423 p=1559 u=root n=ansible | changed: [localhost]
2026-02-20 20:00:25,453 p=1559 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
2026-02-20 20:00:25,482 p=1559 u=root n=ansible | skipping: [localhost]
2026-02-20 20:00:25,506 p=1559 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
2026-02-20 20:00:25,574 p=1559 u=root n=ansible | changed: [localhost]
2026-02-20 20:00:25,595 p=1559 u=root n=ansible | TASK [apnscp/initialize-db : stat] *********************************************
2026-02-20 20:00:25,680 p=1559 u=root n=ansible | ok: [localhost]
2026-02-20 20:00:25,705 p=1559 u=root n=ansible | TASK [apnscp/initialize-db : Query if backend running] *************************
2026-02-20 20:00:25,802 p=1559 u=root n=ansible | changed: [localhost]
2026-02-20 20:00:25,828 p=1559 u=root n=ansible | TASK [apnscp/initialize-db : Start backend to build configuration] *************
2026-02-20 20:00:26,375 p=1559 u=root n=ansible | ok: [localhost]
2026-02-20 20:00:26,402 p=1559 u=root n=ansible | TASK [apnscp/initialize-db : Perform database migration] ***********************
2026-02-20 20:01:12,828 p=1559 u=root n=ansible | changed: [localhost]
2026-02-20 20:01:12,851 p=1559 u=root n=ansible | TASK [apnscp/initialize-db : meta] *********************************************
2026-02-20 20:01:12,900 p=1559 u=root n=ansible | RUNNING HANDLER [common : Reload systemd] **************************************
2026-02-20 20:01:13,527 p=1559 u=root n=ansible | ok: [localhost]
2026-02-20 20:01:13,552 p=1559 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
2026-02-20 20:01:14,370 p=1559 u=root n=ansible | changed: [localhost]
2026-02-20 20:01:14,389 p=1559 u=root n=ansible | RUNNING HANDLER [common : Restart apache] **************************************
2026-02-20 20:01:15,328 p=1559 u=root n=ansible | changed: [localhost]
2026-02-20 20:01:15,354 p=1559 u=root n=ansible | RUNNING HANDLER [common : Restart virtualhosting] ******************************
2026-02-20 20:01:15,567 p=1559 u=root n=ansible | changed: [localhost]
2026-02-20 20:01:15,588 p=1559 u=root n=ansible | RUNNING HANDLER [common : Restart php-fpm] *************************************
2026-02-20 20:01:15,648 p=1559 u=root n=ansible | included: /usr/local/apnscp/resources/playbooks/roles/common/handlers/restart-php-fpm.yml for localhost
2026-02-20 20:01:15,668 p=1559 u=root n=ansible | RUNNING HANDLER [common : Stop php-fpm] ****************************************
2026-02-20 20:01:15,836 p=1559 u=root n=ansible | changed: [localhost]
2026-02-20 20:01:15,859 p=1559 u=root n=ansible | RUNNING HANDLER [common : Start php-fpm] ***************************************
2026-02-20 20:01:16,010 p=1559 u=root n=ansible | changed: [localhost]
2026-02-20 20:01:16,047 p=1559 u=root n=ansible | TASK [apnscp/create-admin : stat] **********************************************
2026-02-20 20:01:16,138 p=1559 u=root n=ansible | ok: [localhost]
2026-02-20 20:01:16,161 p=1559 u=root n=ansible | TASK [apnscp/create-admin : copy] **********************************************

# psql -V
psql (PostgreSQL) 16.12

In order to proceed further with this direct request, I will require additional information to adequately troubleshoot this.

You may consider reaching out to the community for guided support.

3

I’m sure nobody in the “community” would have a clue why this happened or how to fix it.

Incoming