remote.php errors after upgrade #23610

Activity

1. TheOtterslider commented on Mar 28, 2016

   

   TheOtterslider

   on Mar 28, 2016

   Author

   More actions

   Sorry for the formatting issues. I tried to tweak it, but ended up making it worse and less readable
2. DeepDiver1975 commented on Mar 28, 2016

   

   DeepDiver1975

   on Mar 28, 2016

   Contributor

   More actions

   Looks like the upgrade didn't properly setup remote.PHP.

   Please have a look in the DB - table OC_appconfig for entries which hold the value app/files/appinfo/remote.PHP

   That value has to be changed to
   apps/dav/appinfo/v1/webdav.php
3. TheOtterslider commented on Mar 28, 2016

   

   TheOtterslider

   on Mar 28, 2016

   Author

   More actions

   DeepDiver1975, thanks for the info. Most of this is put here so someone else can see what I did...but I also put it here on the hopes that I'll get some confirmation

   Query:

   select * from oc_appconfig where configvalue like '%appinfo%';
   

   gives me

   +-------+-----------------+-----------------------------+
   | appid | configkey       | configvalue                 |
   +-------+-----------------+-----------------------------+
   | core  | remote_caldav   | calendar/appinfo/remote.php |
   | core  | remote_calendar | calendar/appinfo/remote.php |
   | core  | remote_carddav  | contacts/appinfo/remote.php |
   | core  | remote_contacts | contacts/appinfo/remote.php |
   | core  | remote_dav      | dav/appinfo/v2/remote.php   |
   | core  | remote_files    | files/appinfo/remote.php    |
   | core  | remote_filesync | files/appinfo/filesync.php  |
   | core  | remote_webdav   | files/appinfo/remote.php    |
   +-------+-----------------+-----------------------------+
   8 rows in set (0.00 sec)
   
   

   running query

   select * from oc_appconfig where appid = 'core' and configkey = 'remote_files';
   

   gives me the one row I'm going to update

   +-------+--------------+--------------------------+
   | appid | configkey    | configvalue              |
   +-------+--------------+--------------------------+
   | core  | remote_files | files/appinfo/remote.php |
   +-------+--------------+--------------------------+
   1 row in set (0.00 sec)
   

   now I'll update it

   update oc_appconfig set configvalue = 'dav/appinfo/v1/webdav.php' where appid = 'core' and configkey = 'remote_files';
   Query OK, 1 row affected (0.04 sec)
   Rows matched: 1  Changed: 1  Warnings: 0
   

   confirm the change with

    select * from oc_appconfig where appid = 'core' and configkey = 'remote_files';
   

   I can see the change

   +-------+--------------+---------------------------+
   | appid | configkey    | configvalue               |
   +-------+--------------+---------------------------+
   | core  | remote_files | dav/appinfo/v1/webdav.php |
   +-------+--------------+---------------------------+
   1 row in set (0.00 sec)
   

   Do I need to update anything else in that table?

   Results after testing = I still get the same error when I login. I also get the same errors in the owncloud log.
4. TheOtterslider commented on Mar 28, 2016

   

   TheOtterslider

   on Mar 28, 2016

   Author

   More actions

   @DeepDiver1975 -- can you confirm what the values should be in the table?

   After testing the one entry above and it didn't work, I ran the following queries:

   query 1

   select * from oc_appconfig where configvalue like '%appinfo%';
   

   that gave me

   +-------+-----------------+-----------------------------+
   | appid | configkey       | configvalue                 |
   +-------+-----------------+-----------------------------+
   | core  | remote_caldav   | calendar/appinfo/remote.php |
   | core  | remote_calendar | calendar/appinfo/remote.php |
   | core  | remote_carddav  | contacts/appinfo/remote.php |
   | core  | remote_contacts | contacts/appinfo/remote.php |
   | core  | remote_dav      | dav/appinfo/v2/remote.php   |
   | core  | remote_files    | dav/appinfo/v1/webdav.php   |
   | core  | remote_filesync | files/appinfo/filesync.php  |
   | core  | remote_webdav   | files/appinfo/remote.php    |
   +-------+-----------------+-----------------------------+
   8 rows in set (0.00 sec)
   

   Note the remote_dav and remote_files line. The remote_dav one uses v2 instead of v1 like you had. The remote_files one you gave me ends in webdav.php NOT remote.php like the others in the select.

   I then ran these two update queries (I know you didn't explicitly say, but they made the two rows agree to something). I was just testing a theory here

   update oc_appconfig set configvalue = 'dav/appinfo/v1/remote.php' where appid = 'core' and configkey = 'remote_files';
   Query OK, 1 row affected (0.06 sec)
   Rows matched: 1  Changed: 1  Warnings: 0
   
   update oc_appconfig set configvalue = 'dav/appinfo/v1/remote.php' where appid = 'core' and configkey = 'remote_dav';
   Query OK, 1 row affected (0.03 sec)
   Rows matched: 1  Changed: 1  Warnings: 0
   

   That gave me

    select * from oc_appconfig where configvalue like '%appinfo%';
   +-------+-----------------+-----------------------------+
   | appid | configkey       | configvalue                 |
   +-------+-----------------+-----------------------------+
   | core  | remote_caldav   | calendar/appinfo/remote.php |
   | core  | remote_calendar | calendar/appinfo/remote.php |
   | core  | remote_carddav  | contacts/appinfo/remote.php |
   | core  | remote_contacts | contacts/appinfo/remote.php |
   | core  | remote_dav      | dav/appinfo/v1/remote.php   |
   | core  | remote_files    | dav/appinfo/v1/remote.php   |
   | core  | remote_filesync | files/appinfo/filesync.php  |
   | core  | remote_webdav   | files/appinfo/remote.php    |
   +-------+-----------------+-----------------------------+
   8 rows in set (0.00 sec)
   

   It didn't work so I set the two rows back to what they were before I started:

   select * from oc_appconfig where configvalue like '%appinfo%';
   +-------+-----------------+-----------------------------+
   | appid | configkey       | configvalue                 |
   +-------+-----------------+-----------------------------+
   | core  | remote_caldav   | calendar/appinfo/remote.php |
   | core  | remote_calendar | calendar/appinfo/remote.php |
   | core  | remote_carddav  | contacts/appinfo/remote.php |
   | core  | remote_contacts | contacts/appinfo/remote.php |
   | core  | remote_dav      | dav/appinfo/v2/remote.php   |
   | core  | remote_files    | dav/appinfo/v1/webdav.php   |
   | core  | remote_filesync | files/appinfo/filesync.php  |
   | core  | remote_webdav   | files/appinfo/remote.php    |
   +-------+-----------------+-----------------------------+
   8 rows in set (0.00 sec)
   

   Oh, after the updates but before testing, I bounced apache (just in case)
5. DeepDiver1975 commented on Mar 29, 2016

   

   DeepDiver1975

   on Mar 29, 2016

   Contributor

   More actions

   You have to update the remote_webdav entry as well.
   An also all other entries for calendar and contacts.

   Really strange they did not get updated properly.
6. PVince81 commented on Mar 29, 2016

   

   PVince81

   on Mar 29, 2016

   Contributor

   More actions

   Do you have log entries from the time where you ran the upgrade, in case there were errors ?
7. PVince81

   added

   Type:Bug

   feature:update

   on Mar 29, 2016
8. TheOtterslider commented on Mar 29, 2016

   

   TheOtterslider

   on Mar 29, 2016

   Author

   More actions

   @DeepDiver1975 just to confirm ... all 8 rows shown above should have their configvalue set to dav/appinfo/v1/webdav.php (I hate to have to undo something because I missed something simple)

   edit - see below
9. TheOtterslider commented on Mar 29, 2016

   

   TheOtterslider

   on Mar 29, 2016

   Author

   More actions

   @PVince81 let me check. I know I ran occ with the --verbose flag and didn't get any errors reported to the console.
10. TheOtterslider commented on Mar 29, 2016

    

    TheOtterslider

    on Mar 29, 2016

    Author

    More actions

    @PVince81

    Here's all I find in my owncloud.log file around the upgrade time:

    {"reqId":"homvDxzPuUXtpq0pOnY7","remoteAddr":"","app":"core","message":"starting upgrade from 8.2.3.2 to 9.0.0.19","level":0,"time":"2016-03-27T01:09:20+00:00","method":"--","url":"--"}
    {"reqId":"LuCxm0nMcqgxSquUwRvM","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T01:15:10+00:00","method":"--","url":"--"}
    {"reqId":"FubWzW3twI7CjomtwA3h","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T01:30:07+00:00","method":"--","url":"--"}
    {"reqId":"vq10R+inmnyoTMToctyn","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T01:45:08+00:00","method":"--","url":"--"}
    {"reqId":"zrnxbuqNX+f1HLBZVM6w","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T02:00:13+00:00","method":"--","url":"--"}
    {"reqId":"lwRLfGf\/vdtsUcYrB9TG","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T02:15:05+00:00","method":"--","url":"--"}
    {"reqId":"Zhf5A4YILjPvyBpbcw+3","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T02:30:06+00:00","method":"--","url":"--"}
    {"reqId":"2ePp0+\/\/7sXUngbOzklP","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T02:45:07+00:00","method":"--","url":"--"}
    {"reqId":"7sP7akOC\/+80D6m6S7us","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T03:00:11+00:00","method":"--","url":"--"}
    {"reqId":"7Nnk85K9H0otNnanU\/5Y","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T03:15:04+00:00","method":"--","url":"--"}
    {"reqId":"E85K+Fb4psKfVoaFTiox","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T03:30:04+00:00","method":"--","url":"--"}
    {"reqId":"DqwAf7f8QUlFhCvu8k10","remoteAddr":"","app":"cron","message":"Update required, skipping cron","level":0,"time":"2016-03-27T03:45:07+00:00","method":"--","url":"--"}
    {"reqId":"Jbb3L0oB43Z2CGAfHejy","remoteAddr":"xxx.xxx.xxx.xxx","app":"PHP","message":"require_once(\/var\/www\/html\/owncloud\/apps\/files\/appinfo\/remote.php): failed to open stream: No such file or directory at \/var\/www\/html\/owncloud\/remote.php#138","level":3,"time":"2016-03-27T03:55:38+00:00","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/"}
    

    From looking at my other upgrades in the log, that looks normal. I do see some errors from a previous upgrade so I know errors had been written (I had a mysql problem relating to my lock table size)

    Perhaps there could be an enhancement request made: when occ is run with --verbose, major steps done are written to the owncloud.log file (just like what gets printed to the console...starting/finished type messages)
11. TheOtterslider commented on Mar 29, 2016

    

    TheOtterslider

    on Mar 29, 2016

    Author

    More actions

    after looking through the code, I found what I thought were the correct values here in core/apps/dav/appinfo/info.xml. I updated my table to:

    select * from oc_appconfig where configvalue like '%appinfo%';
    +-------+-----------------+----------------------------+
    | appid | configkey       | configvalue                |
    +-------+-----------------+----------------------------+
    | core  | remote_caldav   | appinfo/v1/caldav.php      |
    | core  | remote_calendar | appinfo/v1/caldav.php      |
    | core  | remote_carddav  | appinfo/v1/carddav.php     |
    | core  | remote_contacts | appinfo/v1/carddav.php     |
    | core  | remote_dav      | dav/appinfo/v2/remote.php  |
    | core  | remote_files    | dav/appinfo/v1/webdav.php  |
    | core  | remote_filesync | files/appinfo/filesync.php |
    | core  | remote_webdav   | dav/appinfo/v1/webdav.php  |
    +-------+-----------------+----------------------------+
    8 rows in set (0.00 sec)
    

    I can login via the web interface now and see files. I also still have my calendar and contacts. My sync client appears to work too. I just checked my android app and all appears ok there. Looks like that resolved it

    edit ... checked my caldav and carddav connections on android after posting. They work too.
12. DeepDiver1975 commented on Apr 5, 2016

    

    DeepDiver1975

    on Apr 5, 2016

    Contributor

    More actions

    @TheOtterslider the table is supposed to look like

    
13. DeepDiver1975

    added a commit that references this issue on Apr 5, 2016

    All webdav endpoints within remote.php are now hardcoded - helps to p…

    ...

    7bdde98
14. DeepDiver1975

    added this to the 9.1-currentThis milestone has been deleted milestone on Apr 5, 2016
15. 3 remaining items

    Load more

16. TheOtterslider commented on Apr 6, 2016

    

    TheOtterslider

    on Apr 6, 2016

    Author

    More actions

    Super. Thanks for all the help.
17. TheOtterslider commented on Apr 6, 2016

    

    TheOtterslider

    on Apr 6, 2016

    Author

    More actions

    By the way, from where I sit the issue is resolved. Should I close it now or wait for someone else to do it after a certain milestone?
18. DeepDiver1975

    closed this as completedon Apr 6, 2016
19. DeepDiver1975 commented on Apr 6, 2016

    

    DeepDiver1975

    on Apr 6, 2016

    Contributor

    More actions

    Super. Thanks for all the help.

    Happy to help out! Take care
20. 88fingerslukee commented on Apr 10, 2016

    

    88fingerslukee

    on Apr 10, 2016

    More actions

    Please help me, I'm getting these same errors but I have no clue how there were solved for TheOtterslider. What commands do I need to issue to alter my DB table?
21. TheOtterslider commented on Apr 12, 2016

    

    TheOtterslider

    on Apr 12, 2016

    Author

    More actions

    @88fingerslukee -- What I did to resolve the problem was update some values in the database. The upgrade should have done it, but it didn't ... for some reason.

    What commands do I need to issue to alter my DB table?

    There is way too much that could go wrong here if done wrong and way too much dependent upon your exact configurations. Here's an outline of what needs done:

    0 - back up your database. Now do it again. Check it. If you hose this, you'll have to restore it. I cheat and cron the mysqldump command for all my active databases every night. Before I do an upgrade, I'll run it manually. You can do this by:

    mysqldump --add-drop-table -u USERNAME -pPASSWORD_NO_SPACE DBNAME | gzip > /PATH/TO/BACKUP/FILE
    

    1 - login to your database. I used the mysql command line version to login as the root user:

    mysql -u root -p
    

    then enter the password when prompted.

    2 - you need to switch to the correct database:

    use DBNAME
    

    3 - run a select to check the values. This depends on the table prefix you used when you installed ownCloud the first time.

    select * from PREFIX_appconfig where configvalue like '%appinfo%';
    

    4 - this will spit out something like this:

    +-------+-----------------+-----------------------------+
    | appid | configkey       | configvalue                 |
    +-------+-----------------+-----------------------------+
    | core  | remote_caldav   | calendar/appinfo/remote.php |
    | core  | remote_calendar | calendar/appinfo/remote.php |
    | core  | remote_carddav  | contacts/appinfo/remote.php |
    | core  | remote_contacts | contacts/appinfo/remote.php |
    | core  | remote_dav      | dav/appinfo/v2/remote.php   |
    | core  | remote_files    | files/appinfo/remote.php    |
    | core  | remote_filesync | files/appinfo/filesync.php  |
    | core  | remote_webdav   | files/appinfo/remote.php    |
    +-------+-----------------+-----------------------------+
    

    5 - compare your values to what the table is supposed to look like (#23610 (comment))

    6 - update anything that needs updated. I did it one at a time by running this query. The generic format for this in SQL is update TABLE set COLUMN = VALUE [WHERE]:

    update PREFIX_appconfig set configvalue = CORRECT_VALUE where appid = 'core' and configkey = CONFIG_KEY_TO_UPDATE;
    

    If done correctly, you should see something that says one row was updated. Once everything is done, you should be good to go.

    If you have mysql, the commands above will give you a good idea where to start. There are easier ways (especially if you are running owncloud on a hosted server that has phpmyadmin), but that's how I did it. They are also the most common denominator provided you have command line access to the server. I personally don't have phpmyadmin installed on my box so I can't help you out there too much.

    Edit for formatting and to say that if you see something IN ALL CAPS above, it needs replaced with your specific values

    👍React with 👍2Reacted by 88fingerslukee and Niedermann IT-Dienstleistungen
22. 88fingerslukee commented on Apr 12, 2016

    

    88fingerslukee

    on Apr 12, 2016

    More actions

    @TheOtterslider
    Brilliant!! Thanks so much!
23. sxdxfan commented on May 5, 2016

    

    sxdxfan

    on May 5, 2016

    Last edited by sxdxfan

    More actions

    Had the same issue, updated MySQL tables, this fixed everything except for the external links

    'Download' button seemed to work, but no files could be seen on the web

    Logs:

    require_once(): Failed opening required '/var/www/html/owncloud/apps/files_sharing/publicwebdav.php' (include_path='/var/www/html/owncloud/3rdparty/pear/console_getopt:/var/www/html/owncloud/3rdparty/pear/pear_exception:/var/www/html/owncloud/3rdparty/pear/pear-core-minimal/src:/var/www/html/owncloud/3rdparty/pear/archive_tar:/var/www/html/owncloud/3rdparty/phpseclib/phpseclib/phpseclib:/var/www/html/owncloud/lib/private:/var/www/html/owncloud/config:/var/www/html/owncloud/3rdparty:/var/www/html/owncloud/apps:.:/usr/share/pear:/usr/share/php:/var/www/html/owncloud') at /var/www/html/owncloud/public.php#74

    SQL entry:

    +-------+---------------+--------------------------------+
    | appid | configkey | configvalue |
    +-------+---------------+--------------------------------+
    | core | public_webdav | files_sharing/publicwebdav.php |
    +-------+---------------+--------------------------------+

    Changed the value to 'dav/appinfo/v1/publicwebdav.php'

    update oc_appconfig set configvalue = 'dav/appinfo/v1/publicwebdav.php' where appid = 'core' and configkey = 'public_webdav';

    This fixed the issue
24. Jas2Ma commented on Jul 6, 2016

    

    Jas2Ma

    on Jul 6, 2016

    Last edited by Jas2Ma

    More actions

    Hi guys, solved the very same issue for me, too.
    One question: I don't have the remote_dav entry at all. Anything bad about this?
25. Finkregh commented on Sep 13, 2016

    

    Finkregh

    on Sep 13, 2016

    Contributor

    More actions

    I hit this issue today, upgrading from 8.1.something to 9.1.0, has this not been patched?
26. Aikhjarto commented on Feb 3, 2017

    

    Aikhjarto

    on Feb 3, 2017

    Last edited by Aikhjarto

    More actions

    Just hit this bug when upgrading from 8.2.10 to 9.0.8.
    Upgraded the database manually with:

    update oc_appconfig set configvalue = 'dav/appinfo/v1/caldav.php' where appid = 'core' and configkey = 'remote_caldav';
    update oc_appconfig set configvalue = 'dav/appinfo/v1/caldav.php' where appid = 'core' and configkey = 'remote_calendar';
    update oc_appconfig set configvalue = 'dav/appinfo/v1/carddav.php' where appid = 'core' and configkey = 'remote_carddav';
    update oc_appconfig set configvalue = 'dav/appinfo/v1/carddav.php' where appid = 'core' and configkey = 'remote_contacts';
    update oc_appconfig set configvalue = 'dav/appinfo/v2/remote.php' where appid = 'core' and configkey = 'remote_dav';
    update oc_appconfig set configvalue = 'dav/appinfo/v1/webdav.php' where appid = 'core' and configkey = 'remote_files';
    update oc_appconfig set configvalue = 'dav/appinfo/v1/webdav.php' where appid = 'core' and configkey = 'remote_webdav';
    update oc_appconfig set configvalue = 'dav/appinfo/v1/publicwebdav.php' where appid = 'core' and configkey = 'public_webdav';
    

    However I had two issues that made me revert to 8.2.10:

    • my calendars were gone afterwards for all users
    • file access was not possible in singleuser mode as admin (but at least possible for other user when singleuser mode was disabled)
27. TheOtterslider commented on Feb 5, 2017

    

    TheOtterslider

    on Feb 5, 2017

    Author

    More actions

    @Aikhjarto -- wasn't the upgrade to 9 when ownCloud made the change that

    1. you had to reactivate non-core apps after the upgrade and
    2. calendar, etc.. were no longer considered part of the core?

    If I'm right, redo the upgrade (all the steps), login as your ownCloud admin user and reactivate the calendar app
28. lock commented on Aug 2, 2019

    

    lockBot

    on Aug 2, 2019

    More actions

    This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.
29. lock

    locked as resolved and limited conversation to collaborators on Aug 2, 2019