Many symbols appear on my logon page and when logged in. Is this a browser related issue or nextcoud related? I’m using Firefox and I am on nextcloudpi 1.13.1 with nextcloud version 15.0.8.1.
Output of logs or ncp-report?
Use pastebin or alike and link here, for long files.
Which logs do you mean and where can I find 'em?
saw this before, it is a missing dependency … asap i remember i come back
1 Like
Here is output of ncp-report:
pi@nextcloudpi:/ $ sudo ncp-report
<–! Paste this in GitHub report -->
NextCloudPi diagnostics
NextCloudPi version v1.13.1
NextCloudPi image NextCloudPi_11-22-18
distribution Raspbian GNU/Linux 9 \n \l
automount yes
USB devices sda
datadir /var/www/nextcloud/data
data in SD yes
data filesystem ext2/ext3
data disk usage 48G/57G
rootfs usage 48G/57G
swapfile /var/swap
dbdir /var/lib/mysql
Nextcloud check ok
Nextcloud version 15.0.8.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 21:24
Nextcloud configuration
{
"system": {
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": {
"0": "localhost",
"5": "nextcloudpi.local",
"7": "nextcloudpi",
"8": "nextcloudpi.lan",
"1": "192.168.188.22",
"4": "mynextcloudpi.feste-ip.net",
"11": "2001:16b8:3027:e300:d4c2:ae0f:c8a6:6248",
"20": "mynextcloudpi.feste-ip.net",
"21": "192.168.188.20"
},
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "15.0.8.1",
"overwrite.cli.url": "https:\/\/mynextcloudpi.feste-ip.net\/",
"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***"
},
"mail_smtpmode": "sendmail",
"mail_smtpauthtype": "LOGIN",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"overwriteprotocol": "https",
"loglevel": "2",
"log_type": "file",
"maintenance": false,
"updater.release.channel": "stable",
"theme": "",
"jpeg_quality": "60"
}
}
HTTPd logs
[Thu Jun 06 06:25:03.092934 2019] [ssl:warn] [pid 985:tid 1996091632] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Thu Jun 06 06:25:04.001297 2019] [mpm_event:notice] [pid 985:tid 1996091632] AH00489: Apache/2.4.25 (Raspbian) OpenSSL/1.0.2r configured -- resuming normal operations
[Thu Jun 06 06:25:04.001453 2019] [core:notice] [pid 985:tid 1996091632] AH00094: Command line: '/usr/sbin/apache2'
[Thu Jun 06 17:07:37.393629 2019] [proxy_fcgi:error] [pid 6655:tid 1682764848] [client 192.168.188.20:1818] AH01071: Got error 'PHP message: PHP Notice: Undefined index: app in /var/www/ncp-web/index.php on line 238\nPHP message: PHP Notice: Undefined index: app in /var/www/ncp-web/index.php on line 244\n'
Database logs
Nextcloud logs
{"reqId":"XPk5w38AAQEAABn@lIoAAAAP","level":2,"time":"2019-06-06T16:05:23+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk54X8AAQEAABn@lIsAAAAQ","level":2,"time":"2019-06-06T16:05:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk5-38AAQEAABn@lIwAAAAR","level":2,"time":"2019-06-06T16:06:23+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk6HX8AAQEAABn-7@cAAABH","level":2,"time":"2019-06-06T16:06:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk6HX8AAQEAABn-7@gAAABL","level":2,"time":"2019-06-06T16:06:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk6O38AAQEAABn@lI0AAAAS","level":2,"time":"2019-06-06T16:07:23+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk6WX8AAQEAABn@lKUAAAAY","level":2,"time":"2019-06-06T16:07:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk6d38AAQEAABn-7-AAAABS","level":2,"time":"2019-06-06T16:08:23+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk6lX8AAQEAABn-7-EAAABT","level":2,"time":"2019-06-06T16:08:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk6s38AAQEAABn@lK4AAAAB","level":2,"time":"2019-06-06T16:09:23+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk60X8AAQEAABn-7-IAAABU","level":2,"time":"2019-06-06T16:09:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk6738AAQEAABn@lLEAAAAA","level":2,"time":"2019-06-06T16:10:23+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk7DX8AAQEAABn-7-MAAABV","level":2,"time":"2019-06-06T16:10:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk7K38AAQEAABn-7-QAAABW","level":2,"time":"2019-06-06T16:11:23+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk7SX8AAQEAABn-7-UAAABX","level":2,"time":"2019-06-06T16:11:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk7SX8AAQEAABn-7-YAAABY","level":2,"time":"2019-06-06T16:11:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk7Z38AAQEAABn@lLIAAAAC","level":2,"time":"2019-06-06T16:12:23+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk7hX8AAQEAABn@lLQAAAAD","level":2,"time":"2019-06-06T16:12:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk7o38AAQEAABn@lLcAAAAE","level":2,"time":"2019-06-06T16:13:23+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
{"reqId":"XPk7wX8AAQEAABn@lLgAAAAF","level":2,"time":"2019-06-06T16:13:53+00:00","remoteAddr":"92.116.145.5","user":"Andy","app":"l10n","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Failed to load \/var\/www\/nextcloud\/apps\/files\/l10n\/de.json - json error code: 4","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"15.0.8.1"}
This bug could be related to utf-8 support for php/mysql or apache2.
- possibility one APACHE2
modify your /etc/apache2.conf or equivalent and add:
AddDefaultCharset ISO-8859-1
or
AddDefaultCharset utf-8
- possibility two; htaccess
edit and add:
IndexOptions +Charset=UTF-8
Also, you may need to modify tour mysql conf. Check you
-
my.cnf
[client] default-character-set = utf8 [mysqld] default-character-set = utf8 default-collation = utf8_unicode_ci character-set-server = utf8 collation-server = utf8_unicode_ci
If your base is already existing, after modification of my.cnf and apache2/mysql restat, you may need to alter your tables
ALTER DATABASE mydatabasename charset=utf8;
PLEASE! REMEMBER TO BACKUP BEFORE ANY MODIFICATIONS !!!
1 Like
Thank you very much.
Where can I find htaccess and mysql.conf?
depending of your server type ( debian, ubuntu or other) the mysql.conf is usually located under
/etc/mysql/conf.d/mysql.conf and my.cnf is usually located under /etc/alternatives/my.cnf
the htaccess is an invisible file, witch is usually located in your /var/www/html
using vi or vim or nano to edit it
you need to type nano ./htaccess inside the good folder files !
REMEMBER TO MAKE BACKUP BEFORE MODIFICATION !!!
I can’t find htaccess file. nano opens an empty file. I ran as sudo.
I am on raspbian.
htaccess is not mandatory. Opening an empty files means you dont have one, witch shoudnot happen in a NC folder as NC install create one.
If your server is nginx based, this is normal as nginx doesnt use htaccess…
My example and ref are from a regular server, based on a debian distro, not a docker or vm
You may want to check this:
http://httpd.apache.org/docs/2.2/en/howto/htaccess.html for apache2 2.2.x deprecated
https://httpd.apache.org/docs/2.4/en/howto/htaccess.html for latest apache2 2.4.x
The most important thing to understant is:
The configuration directives found in a .htaccess file are applied to the directory in which the .htaccess file is found, and to all subdirectories thereof. However, it is important to also remember that there may have been .htaccess files in directories higher up. Directives are applied in the order that they are found. Therefore, a .htaccess file in a particular directory may override directives found in .htaccess files found higher up in the directory tree. And those, in turn, may have overridden directives found yet higher up, or in the main server configuration file itself.
As an exemple, this is my .htaccess file for my nextcloud:
located in /var/www/html/.htaccess
<IfModule mod_headers.c>
<IfModule mod_setenvif.c>
<IfModule mod_fcgid.c>
SetEnvIfNoCase ^Authorization$ "(.+)" XAUTHORIZATION=$1
RequestHeader set XAuthorization %{XAUTHORIZATION}e env=XAUTHORIZATION
</IfModule>
<IfModule mod_proxy_fcgi.c>
SetEnvIfNoCase Authorization "(.+)" HTTP_AUTHORIZATION=$1
</IfModule>
</IfModule>
<IfModule mod_env.c>
# Add security and privacy related headers
Header set X-Content-Type-Options "nosniff"
Header set X-XSS-Protection "1; mode=block"
Header set X-Robots-Tag "none"
Header set X-Download-Options "noopen"
Header set X-Permitted-Cross-Domain-Policies "none"
Header set Referrer-Policy "no-referrer"
SetEnv modHeadersAvailable true
</IfModule>
# Add cache control for static resources
<FilesMatch "\.(css|js|svg|gif)$">
Header set Cache-Control "max-age=15778463"
</FilesMatch>
# Let browsers cache WOFF files for a week
<FilesMatch "\.woff2?$">
Header set Cache-Control "max-age=604800"
</FilesMatch>
</IfModule>
# in case httpd.conf is multi vhosted
<IfModule mod_php7.c>
php_value mbstring.func_overload 0
php_value default_charset 'UTF-8'
php_value output_buffering 0
<IfModule mod_env.c>
SetEnv htaccessWorking true
</IfModule>
</IfModule>
<IfModule mod_rewrite.c>
# my reality sanity check
RewriteEngine on
RewriteCond %{HTTP_USER_AGENT} DavClnt
RewriteRule ^$ /remote.php/webdav/ [L,R=302]
RewriteRule .* - [env=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
RewriteRule ^\.well-known/host-meta /public.php?service=host-meta [QSA,L]
RewriteRule ^\.well-known/host-meta\.json /public.php?service=host-meta-json [QSA,L]
RewriteRule ^\.well-known/webfinger /public.php?service=webfinger [QSA,L]
RewriteRule ^\.well-known/carddav /remote.php/dav/ [R=301,L]
RewriteRule ^\.well-known/caldav /remote.php/dav/ [R=301,L]
RewriteRule ^remote/(.*) remote.php [QSA,L]
RewriteRule ^(?:build|tests|config|lib|3rdparty|templates)/.* - [R=404,L]
RewriteCond %{REQUEST_URI} !^/\.well-known/(acme-challenge|pki-validation)/.*
RewriteRule ^(?:\.|autotest|occ|issue|indie|db_|console).* - [R=404,L]
</IfModule>
<IfModule mod_mime.c>
AddType image/svg+xml svg svgz
AddEncoding gzip svgz
</IfModule>
<IfModule mod_dir.c>
DirectoryIndex index.php index.html
</IfModule>
AddDefaultCharset utf-8
Options -Indexes
<IfModule pagespeed_module>
ModPagespeed Off
</IfModule>
ErrorDocument 403 //
ErrorDocument 404 //
Another .htaccess file is located in /var/www/html/config/.htaccess … and so on
1 Like
NCP has wide char support and it works as far as I know, so I am not sure that is the issue here
I didn’t manage to figure out the problem with the suggested actions. My MariaDB service is down after performing any of the mentioned changes so I ended up reinitializing my nextcloud instance and doing a clean start.
I am on holidays from tomorrow so I need to get it fixed and that’s the fastest way for me.
Thanks all for the help.