- New Server: Intel Xeon-E2388G 3.2, with 64GB RAM and 2 1TB nvme on soft raid running ubuntu server
- Database Server: 10.4.24-MariaDB-1:10.4.24+maria~focal
- PHP 7.4.30, Memory Limit 512MB
- Drupal 9.4.5, Standard Install
- CiviCRM 5.52.2 Separate database with all permissions on Drupal and CiviCRM DBs and SUPER
- en_GB localisation files installed after cli installation
- No warnings at all on Drupal Status Report
Installed clean installation on the above, composer Drupal, composer CiviCRM as per CLI installer guide. Visiting the /civicrm page for the first time, seen permissions problem but fixed this on /sites/default/files/civicrm/... Refreshed with the problem text gone. Nothing displaying, other than the civicrm footer. No CiviCRM pages at all.
Followed the troubleshooting steps - caches, menu etc. Log file contains the following:
Aug 19 03:12:28 [error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`,
`a`.`description` AS `description`, `a`.`entity_name` AS `entity_name`, `a`.`items` AS `items`
FROM a
ORDER BY `label` ASC
[nativecode=1146 ** Table 'civicrmdb.a' doesn't exist]
[type] => DB_Error
[user_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`description` AS `description`, `a`.`entity_name` AS `entity_name`, `a`.`items` AS `items`
FROM a
ORDER BY `label` ASC
[nativecode=1146 ** Table 'civicrmdb.a' doesn't exist].....
Any ideas? Stuck! Thanks in advance.
Edit after further research: CLI install command used:
cv core:install --cms-base-url="https://example.com" --lang="en_GB" --db="mysql://civicrmuser:password@localhost:3306/civicrmdb" -v
Result of cv:
{
"srcPath": "/var/www/vhosts/example.com/httpdocs/vendor/civicrm/civicrm-core",
"setupPath": "/var/www/vhosts/example.com/httpdocs/vendor/civicrm/civicrm-core/setup",
"settingsPath": "/var/www/vhosts/example.com/httpdocs/web/sites/default/civicrm.settings.php",
"templateCompilePath": "/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/templates_c",
"cms": "Drupal8",
"cmsBaseUrl": "https://example.com",
"db": {
"server": "localhost:3306",
"username": "civicrmuser",
"password": "password",
"database": "civicrmdb",
"ssl_params": []
},
"cmsDb": {
"server": "localhost:3306",
"username": "drupaluser",
"password": "password",
"database": "drupaldb",
"ssl_params": null
},
"siteKey": "mySiteKey",
"credKeys": [
"aes-cbc:hkdf-sha256:myCreds"
],
"signKeys": [
"jwt-hs256:hkdf-sha256:mySign"
],
"loadGenerated": null,
"lang": "en_GB",
"components": [
"CiviEvent",
"CiviContribute",
"CiviMember",
"CiviMail",
"CiviReport"
],
"extensions": [
"org.civicrm.search_kit"
],
"paths": {
"civicrm.files": {
"url": "https://example.com/sites/default/files/civicrm",
"path": "/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm"
}
},
"settings": [],
"mandatorySettings": [],
"extras": []
}
Output from cv vars:show -
{
"CIVI_CORE": "/var/www/vhosts/example.com/httpdocs/vendor/civicrm/civicrm-core/",
"CIVI_DB_ARGS": "-h localhost -u civicrmdb -pcivicrmdb -P 3306 civicrmdb",
"CIVI_DB_DSN": "mysql://civicrmuser:pass@localhost:3306/civicrmdb?new_link=true",
"CIVI_DB_HOST": "localhost",
"CIVI_DB_NAME": "civicrmdb",
"CIVI_DB_PASS": "password",
"CIVI_DB_PORT": 3306,
"CIVI_DB_USER": "civicrmuser",
"CIVI_FILES": "/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/",
"CIVI_LOG": "/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/ConfigAndLog/CiviCRM.random.log",
"CIVI_SETTINGS": "/var/www/vhosts/example.com/httpdocs/web/sites/default/civicrm.settings.php",
"CIVI_SITE_KEY": "mySiteKey",
"CIVI_TEMPLATEC": "/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/templates_c/",
"CIVI_UF": "Drupal8",
"CIVI_URL": "https://example.com/libraries/civicrm/core/",
"CIVI_VERSION": "5.52.2",
"CMS_DB_ARGS": "-h localhost -u drupaluser -pdrupaldb -P 3306 drupaldb",
"CMS_DB_DSN": "mysql://drupaluser:password@localhost:3306/drupaldb?new_link=true",
"CMS_DB_HOST": "localhost",
"CMS_DB_NAME": "drupaldb",
"CMS_DB_PASS": "password",
"CMS_DB_PORT": 3306,
"CMS_DB_USER": "drupaluser",
"CMS_ROOT": "/var/www/vhosts/example.com/httpdocs/web/",
"CMS_URL": "https://example.com/",
"CMS_VERSION": "9.4.5",
"IS_INSTALLED": "1",
"SITE_TYPE": "cv-auto"
}
Contents of vendor/civicrm... appears complete. Contents of web/libraries/civicrm... is definitely incomplete with hundreds of files missing including jquery etc which is obviously why it's no working.
Is the full core and packages required at /libraries/ or should CIVI_URL in cv be something else?