Probleme mit oc_authtoken


#1

Steps to reproduce

  1. WebDav
  2. Cron

Expected behaviour

Tell us what should happen

Actual behaviour

Tell us what happens instead

Server configuration

Operating system:
10.0.10.4
Web server:
Apache2
Database:
MySQL

PHP version:
7.2
ownCloud version: (see ownCloud admin page)

Updated from an older ownCloud or fresh install:

Where did you install ownCloud from:

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

The content of config/config.php:

Log in to the web-UI with an administrator account and click on
'admin' -> 'Generate Config Report' -> 'Download ownCloud config report'
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.

or 

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder

*ATTENTION:* Do not post your config.php file in public as is. Please use one of the above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove *all* host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.

Are you using external storage, if yes which one: local/smb/sftp/…

Are you using encryption: yes/no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…

LDAP configuration (delete this part if not used)

With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your ownCloud installation folder

Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';


Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.

Client configuration

Browser:

Operating system:

Logs

Web server error log

Insert your webserver log here

ownCloud log (data/owncloud.log)

"remoteAddr":"192.168.2.1","user":"admin","app":"webdav","method":"PROPFIND","url":"\/remote.php\/dav\/files\/admin\/","message":"Exception: HTTP\/1.1 503 Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing 'SELECT `id`, `uid`, `login_name`, `password`, `name`, `type`, `token`, `last_activity`, `last_check` FROM `oc_authtoken` WHERE `token` = ?' with params [\"5483183323db6539d9ed06b598bf909affaf4a7473066cc4cd61a34e4704fe5120774dfb1748a302fd911a76b1919b8d989d85d68a0bcf71b31a91e5ddc16c64\"]:\n\nSQLSTATE[HY000]: General error: 1712 Index oc_authtoken is corrupted: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\ServiceUnavailable\",\"Message\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException: An exception occurred while executing 'SELECT `id`, `uid`, `login_name`, `password`, `name`, `type`, `token`, `last_activity`, `last_check` FROM `oc_authtoken` WHERE `token` = ?' with params [\\\"5483183323db6539d9ed06b598bf909affaf4a7473066cc4cd61a34e4704fe5120774dfb1748a302fd911a76b1919b8d989d85d68a0bcf71b31a91e5ddc16c64\\\"]:\\n\\nSQLSTATE[HY000]: General error: 1712 Index oc_authtoken is corrupted\",\"Code\":0,\"Trace\":\"#0 [internal function]: {closure}(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Object(Closure), Array)\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(466): Sabre\\\\Event\\\\EventEmitter->emit('beforeMethod', Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#4 \\\/var\\\/www\\\/owncloud\\\/remote.php(70): Sabre\\\\DAV\\\\Server->exec()\\n#5 \\\/var\\\/www\\\/owncloud\\\/remote.php(167): handleException(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#6 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/remote.php\",\"Line\":68}"}

{"reqId":"cdSA3wJC17mRfTttAVwl","level":3,"time":"2018-11-07T16:14:40+01:00","remoteAddr":"192.168.2.1","user":"admin","app":"PHP","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing 'SELECT `id`, `uid`, `login_name`, `password`, `name`, `type`, `token`, `last_activity`, `last_check` FROM `oc_authtoken` WHERE `token` = ?' with params [\"45bb1fd7366df8cb6f3995b668ddfdaeb807722dd27d4f082a4499f10f12325544fffdb2b0be1cc3e128d8c5927e5817dfe01b9e6c3161826b96de5411ebe483\"]:\n\nSQLSTATE[HY000]: General error: 1712 Index oc_authtoken is corrupted at \/var\/www\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php#115"}

Die letzten Zeilen von
   Zeige nur Zeilen mit dem Text    

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...

#2

Hey,

i did the following search:

https://www.google.com/search?q=“General+error%3A+1712+Index”+“corrupted”

and found various resources like the following below: