Nextcloudpi please help

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
1

Hello,

  1. Database
    i read a lot, that gives problems with update 14.0.1
    I get the same picture like here
    Nextcloud suddenly stops working
    I tray the solution like there.
    Can somebody check my “ncp-report” please ? It looks like NCP don`t find the database
NextCloudPi diagnostics 

grep: /etc/mysql/mariadb.conf.d/90-ncp.cnf: No such file or directory
NextCloudPi version  v0.62.6
NextCloudPi image    untagged
distribution         Raspbian GNU/Linux 9 \n \l
automount            yes
USB devices          sda
datadir              /media/USBdrive/ncdata
data in SD           no
data filesystem      ext2/ext3
data disk usage      44G/917G
rootfs usage         2.9G/15G
swapfile             /media/USBdrive/swapfile
dbdir                 (doesn't exist)
Nextcloud check      ok
Nextcloud version    13.0.6.1
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        up
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   ***REMOVED SENSITIVE VALUE***
gateway              ***REMOVED SENSITIVE VALUE***
interface            eth0
certificates         ***REMOVED SENSITIVE VALUE***
NAT loopback         no
uptime               2days

pi@raspberrypi:~ $ sudo grep -r datadir /etc/mysql
/etc/mysql/my.cnf.migrated:datadir = /media/USBdrive/ncdatabase

  1. Is my system on debian 9 ? I read from nachoparker often, that he don`t support debian 8 anymore.

  2. My Cert is finish since 7 a clock in the morning. How i get a new cert? In the moment i only get message that my cert is finish.

In ncp-config i get follow
Launching letsencrypt
./letsencrypt.sh: line 63: letsencrypt: command not found
Done. Press any key…

thx a lot

2

You have a very old image, and you haven’t it upgraded it regularly

I would install the latest version and restore your backup. You have one right?

I suggest you go through the wizard. It will activate autoupgrades and you won’t be in this situation again.

3

thanks nachoparker for response. Only for secure
I follow these steps to backup and don`t change the path from the original config.

  • nc-backup
  • nc-export-ncp

I have all my data on HDD (USBdrive). Can i now take out the SD Card, put the newest NCP image on it and put i t back again ?
I`m not 100% shure, how i handle that, that my data stays on external HDD.
Its everything ok when after fresh installation i put back the backups (tut from site before)
“Restoring a backup including your data” ?
Excuse but for me its not so clear what i need to do for the newest and clearest install.

thx

4

One thing you can do if you only care about data is to replace the SDcard and then modify /var/www/nextcloud/config/config.php to point to the hard drive location, then you can run nc-scan and you should be good.

But if you do it this way you will lose your Nextcloud accounts, calendars and so on, you will have to do that again.

5

thanks again. Maybe i wrote not clearly. Thats the point i don`t want to do.
I also want let the accounts, calendars etc.

I already start with new SD Card but don´t have change it yet.

I have think to put the new one and start to write back “nc-export-ncp” and everything is like before.

Now i know why i scare to do something new with my NCP. I moment the most thing work like before but i also know, thats not my solution and i know the next problems will come again with my old installation.

cYu

6

If you don’t want to lose your calendars and stuff, then just replace the SD card, and restore a backup. You should have the backups in your hard drive /media/USBDrive/ncp-backups or similar

7

Ok. I am back. I made like @nachoparker told me. Everything is like before. 1 thing don’t work like in the tutorial - the WebGui. But this i will ask in a new post.
Here a new nc-report

NextCloudPi diagnostics 

NextCloudPi version  v0.62.6
NextCloudPi image    NextCloudPi_10-05-18
distribution         Raspbian GNU/Linux 9 \n \l
automount            yes
USB devices          sda
datadir              /media/USBdrive/ncdata
data in SD           no
data filesystem      ext2/ext3
data disk usage      44G/917G
rootfs usage         2.2G/15G
swapfile             /media/4cbb233e-2788-47bc-8b73-3ba5f271bfae/swap
dbdir                /var/lib/mysql
Nextcloud check      ok
Nextcloud version    14.0.1.1
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        up
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   ***REMOVED SENSITIVE VALUE***
gateway              ***REMOVED SENSITIVE VALUE***
interface            eth0
certificates         ***REMOVED SENSITIVE VALUE***
NAT loopback         no
uptime               2days
Nextcloud configuration 

{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": {
            "0": "localhost",
            "1": "192.168.178.xx",
            "2": "xxx.spdns.de",
            "4": "xxx.spdns.de",
            "7": "nextcloudpi",
            "8": "nextcloudpi.lan"
        },
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "https:\/\/xxx.spdns.de\/",
        "dbtype": "mysql",
        "version": "14.0.1.1",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "logtimezone": "UTC",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "sendmail",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "mail_smtpauthtype": "LOGIN",
        "theme": "",
        "loglevel": 2,
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "timeout": 0,
            "password": "***REMOVED SENSITIVE VALUE***"
        }
    }
}
HTTPd logs 

[Thu Oct 11 06:25:02.727878 2018] [ssl:warn] [pid 926:tid 1996394880] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Thu Oct 11 06:25:03.000568 2018] [mpm_event:notice] [pid 926:tid 1996394880] AH00489: Apache/2.4.25 (Raspbian) OpenSSL/1.0.2l configured -- resuming normal operations
[Thu Oct 11 06:25:03.000633 2018] [core:notice] [pid 926:tid 1996394880] AH00094: Command line: '/usr/sbin/apache2'
Database logs

@nachoparker: is now everythink like it must be ? I mean up to date etc. that i don’t have any problems in the future ?

thx for watching

8

that looks good! Make sure you have all autoupdates enabled and you will be fine in the future (unattended upgrades, autoupdate-nc, autoupdate-ncp)