nextcloudpi
nextcloudpi copied to clipboard
nextcloud
Installation fails with ERROR 1146 (42S02) at line 1: Table 'nextcloud.appconfig' doesn't exist
Hi, just tried to install ncp on my raspi using curl -sSL https://raw.githubusercontent.com/nextcloud/nextcloudpi/master/install.sh|sudo bash
The script seems to have run through most of it but ended with an error message, I copy here the end of the output:
[...] Nextcloud was successfully installed Set mode for background jobs to 'cron' System config value tempdirectory set to string /var/www/nextcloud/data/tmp System config value mysql.utf8mb4 set to boolean true System config value trusted_domains => 7 set to string nextcloudpi System config value trusted_domains => 5 set to string nextcloudpi.local System config value trusted_domains => 8 set to string nextcloudpi.lan System config value trusted_domains => 3 set to string nextcloudpi.lan System config value mail_smtpmode set to string sendmail System config value mail_smtpauthtype set to string LOGIN System config value mail_from_address set to string noreply System config value mail_domain set to string nextcloudpi.com ERROR 1146 (42S02) at line 1: Table 'nextcloud.appconfig' doesn't exist
I tried to trace the location where this occurred - it seems to be somewhere in nc-init.sh.
I also tried to find out how to fix this. I manually ran ncp-config and had run nc-init which went through without an error. So in addition to reporting this issue it would be nice to know whether I can use the installation and how to start it up safely - if this question should be asked in a forum instead please kindly point me to the right location...
System information
NextcloudPi diagnostics
NextcloudPi version v1.55.4
NextcloudPi image NextcloudPi_05-18-25
OS Raspbian GNU/Linux 12
NCP is not activated yet. Please enter https://nextcloudpi.local or this instance's local IP ***REMOVED SENSITIVE VALUE***
automount no
USB devices sda
datadir /var/www/nextcloud/data
data in SD yes
data filesystem ext2/ext3
data disk usage 8.7G/29G
rootfs usage 8.7G/29G
swapfile /var/swap
dbdir /var/lib/mysql
Nextcloud check ok
Nextcloud version 31.0.2.1
HTTPD service up
PHP service up
MariaDB service up
Redis service up
HPB service down
Postfix service up
Internet check ok
Public IPv4 ***REMOVED SENSITIVE VALUE***
Public IPv6 ***REMOVED SENSITIVE VALUE***
Port 80 closed
Port 443 closed
IP ***REMOVED SENSITIVE VALUE***
Gateway ***REMOVED SENSITIVE VALUE***
Interface wlan0
Certificates ***REMOVED SENSITIVE VALUE***
NAT loopback no
Uptime 14days
Nextcloud configuration
{
"system": {
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": {
"0": "localhost",
"7": "nextcloudpi",
"5": "nextcloudpi.local",
"8": "nextcloudpi.lan",
"3": "nextcloudpi.lan"
},
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "31.0.2.1",
"overwrite.cli.url": "https:\/\/nextcloudpi\/",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"instanceid": "***REMOVED SENSITIVE VALUE***",
"memcache.local": "\\OC\\Memcache\\Redis",
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 0,
"timeout": 0,
"password": "***REMOVED SENSITIVE VALUE***"
},
"tempdirectory": "\/var\/www\/nextcloud\/data\/tmp",
"mail_smtpmode": "sendmail",
"mail_smtpauthtype": "LOGIN",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"preview_max_x": "2048",
"preview_max_y": "2048",
"jpeg_quality": "60",
"overwriteprotocol": "https",
"maintenance": false
}
}
HTTPd logs
[Sun May 18 10:57:52.889767 2025] [mpm_prefork:notice] [pid 12126:tid 12126] AH00163: Apache/2.4.62 (Raspbian) OpenSSL/3.0.16 configured -- resuming normal operations
[Sun May 18 10:57:52.889818 2025] [core:notice] [pid 12126:tid 12126] AH00094: Command line: '/usr/sbin/apache2'
[Sun May 18 10:59:28.233661 2025] [mpm_prefork:notice] [pid 12126:tid 12126] AH00170: caught SIGWINCH, shutting down gracefully
[Sun May 18 10:59:28.390101 2025] [ssl:warn] [pid 15528:tid 15528] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Sun May 18 10:59:28.390725 2025] [ssl:error] [pid 15528:tid 15528] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: CN=arm-build.pitowers.org / issuer: CN=arm-build.pitowers.org / serial: 074F815003413E5A06B32DF98D6C9C4FDE1F6E84 / notbefore: Oct 10 00:16:22 2023 GMT / notafter: Oct 7 00:16:22 2033 GMT]
[Sun May 18 10:59:28.390733 2025] [ssl:error] [pid 15528:tid 15528] AH02604: Unable to configure certificate localhost:443:0 for stapling
[Sun May 18 10:59:28.391573 2025] [security2:notice] [pid 15528:tid 15528] ModSecurity for Apache/2.9.7 (http://www.modsecurity.org/) configured.
[Sun May 18 10:59:28.391580 2025] [security2:notice] [pid 15528:tid 15528] ModSecurity: APR compiled version="1.7.0"; loaded version="1.7.2"
[Sun May 18 10:59:28.391584 2025] [security2:warn] [pid 15528:tid 15528] ModSecurity: Loaded APR do not match with compiled!
[Sun May 18 10:59:28.391587 2025] [security2:notice] [pid 15528:tid 15528] ModSecurity: PCRE2 compiled version="10.42 "; loaded version="10.42 2022-12-11"
[Sun May 18 10:59:28.391590 2025] [security2:notice] [pid 15528:tid 15528] ModSecurity: LUA compiled version="Lua 5.1"
[Sun May 18 10:59:28.391593 2025] [security2:notice] [pid 15528:tid 15528] ModSecurity: YAJL compiled version="2.1.0"
[Sun May 18 10:59:28.391595 2025] [security2:notice] [pid 15528:tid 15528] ModSecurity: LIBXML compiled version="2.9.14"
[Sun May 18 10:59:28.391598 2025] [security2:notice] [pid 15528:tid 15528] ModSecurity: Status engine is currently disabled, enable it by set SecStatusEngine to On.
[Sun May 18 10:59:28.482106 2025] [ssl:warn] [pid 15529:tid 15529] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Sun May 18 10:59:28.482824 2025] [ssl:error] [pid 15529:tid 15529] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: CN=arm-build.pitowers.org / issuer: CN=arm-build.pitowers.org / serial: 074F815003413E5A06B32DF98D6C9C4FDE1F6E84 / notbefore: Oct 10 00:16:22 2023 GMT / notafter: Oct 7 00:16:22 2033 GMT]
[Sun May 18 10:59:28.482835 2025] [ssl:error] [pid 15529:tid 15529] AH02604: Unable to configure certificate localhost:443:0 for stapling
[Sun May 18 10:59:28.482893 2025] [http2:warn] [pid 15529:tid 15529] AH10034: The mpm module (prefork.c) is not supported by mod_http2. The mpm determines how things are processed in your server. HTTP/2 has more demands in this regard and the currently selected mpm will just not do. This is an advisory warning. Your server will continue to work, but the HTTP/2 protocol will be inactive.
[Sun May 18 10:59:28.506843 2025] [mpm_prefork:notice] [pid 15529:tid 15529] AH00163: Apache/2.4.62 (Raspbian) OpenSSL/3.0.16 configured -- resuming normal operations
[Sun May 18 10:59:28.506924 2025] [core:notice] [pid 15529:tid 15529] AH00094: Command line: '/usr/sbin/apache2'
Database logs
tail: cannot open '/var/log/mysql/*.log' for reading: No such file or directory
Nextcloud logs
{"reqId":"2HK17PnswK6h9kQiM0BZ","level":3,"time":"2025-05-18T09:00:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Not installed","userAgent":"--","version":"","exception":{"Exception":"Exception","Message":"Not installed","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/base.php","line":691,"function":"checkInstalled","class":"OC","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1156,"function":"init","class":"OC","type":"::"},{"file":"/var/www/nextcloud/cron.php","line":24,"args":["/var/www/nextcloud/lib/base.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/base.php","Line":228,"message":"Not installed","exception":{},"CustomMessage":"Not installed"}}
{"reqId":"rjFWZgU7AE886hFR91My","level":3,"time":"2025-05-18T09:05:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Not installed","userAgent":"--","version":"","exception":{"Exception":"Exception","Message":"Not installed","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/base.php","line":691,"function":"checkInstalled","class":"OC","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1156,"function":"init","class":"OC","type":"::"},{"file":"/var/www/nextcloud/cron.php","line":24,"args":["/var/www/nextcloud/lib/base.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/base.php","Line":228,"message":"Not installed","exception":{},"CustomMessage":"Not installed"}}
{"reqId":"krklL02zkYiIOyRcwuP8","level":2,"time":"2025-05-18T10:05:02+00:00","remoteAddr":"","user":false,"app":"cron","method":"","url":"--","message":"failed to create instance of background job: OCA\\UpdateNotification\\BackgroundJob\\UpdateAvailableNotifications","userAgent":"--","version":"31.0.2.1","exception":{"Exception":"OC\\AppFramework\\Utility\\QueryNotFoundException","Message":"Could not resolve OCA\\UpdateNotification\\BackgroundJob\\UpdateAvailableNotifications! Class \"OCA\\UpdateNotification\\BackgroundJob\\UpdateAvailableNotifications\" does not exist","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":124,"function":"resolve","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":155,"function":"query","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":42,"function":"query","class":"OC\\ServerContainer","type":"->"},{"file":"/var/www/nextcloud/lib/public/Server.php","line":39,"function":"get","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":288,"function":"get","class":"OCP\\Server","type":"::"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":197,"function":"buildJob","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":152,"function":"getNext","class":"OC\\BackgroundJob\\JobList","type":"->"}],"File":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","Line":113,"message":"failed to create instance of background job: OCA\\UpdateNotification\\BackgroundJob\\UpdateAvailableNotifications","exception":{},"CustomMessage":"failed to create instance of background job: OCA\\UpdateNotification\\BackgroundJob\\UpdateAvailableNotifications"}}
Yes, I think you are better off on help forum with ncp mark. I never used the curl script. What rpi are you running? You are running Raspian Os, updated? It seems you have to activate your instance, https://nextcloudpi[.lan | .local] or https://<ip-number> .
I'm in the same boat. Fresh Debian install on a Lenovo T61 old laptop, the exact same error.
