[SOLVED] Public Share Link Prompts For Password

610Drew · March 13, 2021, 3:10am

I have created a “share link”. I want to be able to give the link to a family member so she can upload photos. I’ve taken a screen shot of the link and page for your reference:

Yet when I go to the page using the link, I get this:

Is this the first time you’ve seen this error? (Y/N): Yes but it’s also the first time I have tried to use this feature.

My issue seems similar to this post.

But this is my own server and space is not an issue:

 # df -h
Filesystem           Size    Used   Avail Capacity  Mounted on
/dev/label/rootfs     29G    8.3G     18G    31%    /
devfs                1.0K    1.0K      0B   100%    /dev
/dev/da2p1           124G     53G     61G    46%    /usr

I cannot figure out what I’m missing. Thanks for any assistance. Please expand the section below for system details.

Cheers,

Drew

Support Info

I have the following versions:

Nextcloud version (eg, 20.0.5): Nextcloud 19.0.1
Operating system and version (eg, Ubuntu 20.04): FreeBSD 12.1-RELEASE-p8 amd64
Apache or nginx version (eg, Apache 2.4.25): apache24-2.4.46
PHP version (eg, 7.4): 7.2.31

The last few lines of my Nextcloud log in Admin > Logging:

{"reqId":"1sMS60gFnNVIolSgYyan","level":3,"time":"2021-03-11T18:03:51+00:00","remoteAddr":"172.69.142.8","user":"drew","app":"PHP","method":"GET","url":"/index.php/core/preview?fileId=1123&c=be1f0295d406dc83e9f82bd3ccb0205a&x=375&y=375&forceIcon=0","message":"Error while sending QUERY packet. PID=54647 at /usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#117","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.72 Safari/537.36","version":"19.0.1.1"}
{"reqId":"1sMS60gFnNVIolSgYyan","level":3,"time":"2021-03-11T18:03:51+00:00","remoteAddr":"172.69.142.8","user":"drew","app":"index","method":"GET","url":"/index.php/core/preview?fileId=1123&c=be1f0295d406dc83e9f82bd3ccb0205a&x=375&y=375&forceIcon=0","message":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing 'SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = ?) AND (`path_hash` = ?)' with params [3, \"0e1f12c2b04f4fa0d4ff9a970273eebf\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":0,"Trace":[{"file":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = ?) AND (`path_hash` = ?)' with params [3, \"0e1f12c2b04f4fa0d4ff9a970273eebf\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away",{"errorInfo":["HY000",2006,"MySQL server has gone away"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":145,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["HY000",2006,"MySQL server has gone away"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"An exception occurred while executing 'SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = ?) AND (`path_hash` = ?)' with params [3, \"0e1f12c2b04f4fa0d4ff9a970273eebf\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away"]},{"file":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":911,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["HY000",2006,"MySQL server has gone away"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = ?) AND (`path_hash` = ?)",{"1":3,"2":"0e1f12c2b04f4fa0d4ff9a970273eebf"}]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/DB/Connection.php","line":194,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = ?) AND (`path_hash` = ?)",[3,"0e1f12c2b04f4fa0d4ff9a970273eebf"],[1,2],null]},{"file":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":200,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)",{"dcValue1":3,"dcValue2":"0e1f12c2b04f4fa0d4ff9a970273eebf"},{"dcValue1":1,"dcValue2":2}]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/DB/QueryBuilder/QueryBuilder.php","line":216,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Cache.php","line":472,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Cache.php","line":487,"function":"getId","class":"OC\\Files\\Cache\\Cache","type":"->","args":["appdata_ocodvf32kecd/preview/2/c/f/d/4/5/6/1123"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Scanner.php","line":177,"function":"getParentId","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Scanner.php","line":338,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameter replaced ***",3,-1,null,false]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Updater.php","line":125,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameter replaced ***",false,3,false]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/View.php","line":323,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/View.php","line":1176,"function":"writeUpdate","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":{"__class__":"OC\\Files\\Cache\\Propagator"},"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\Files_Trashbin\\Storage"},"*** sensitive parameter replaced ***"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/View.php","line":696,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["file_put_contents","/appdata_ocodvf32kecd/preview/2/c/f/d/4/5/6/1123/1024-1024-crop.jpg",["create","write"],null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Node/Folder.php","line":187,"function":"file_put_contents","class":"OC\\Files\\View","type":"->","args":["/appdata_ocodvf32kecd/preview/2/c/f/d/4/5/6/1123/1024-1024-crop.jpg",null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/SimpleFS/NewSimpleFile.php","line":133,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->","args":["1024-1024-crop.jpg",null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Preview/Generator.php","line":427,"function":"putContent","class":"OC\\Files\\SimpleFS\\NewSimpleFile","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Preview/Generator.php","line":183,"function":"generatePreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"},{"__class__":"OCP\\Image"},1024,1024,true,4096,2153,""]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Preview/Generator.php","line":107,"function":"generatePreviews","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},[{"width":375,"height":375,"crop":true,"mode":"fill"}],"image/jpeg"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/PreviewManager.php","line":190,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},375,375,true,"fill",null]},{"file":"/usr/local/www/nextcloud.19.0.1/core/Controller/PreviewController.php","line":170,"function":"getPreview","class":"OC\\PreviewManager","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},375,375,true,"fill"]},{"file":"/usr/local/www/nextcloud.19.0.1/core/Controller/PreviewController.php","line":143,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},375,375,false,false,"fill"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"getPreviewByFileId","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[1123,375,375,false,false,"fill"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreviewByFileId"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/App.php","line":137,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreviewByFileId"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\PreviewController","getPreviewByFileId",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"core.Preview.getPreviewByFileId"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"core.Preview.getPreviewByFileId"}]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Route/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"core.Preview.getPreviewByFileId"}]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/base.php","line":1007,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/core/preview"]},{"file":"/usr/local/www/nextcloud.19.0.1/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":106,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":"HY000","Trace":[{"file":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":903,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/DB/Connection.php","line":194,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = ?) AND (`path_hash` = ?)",[3,"0e1f12c2b04f4fa0d4ff9a970273eebf"],[1,2],null]},{"file":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":200,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)",{"dcValue1":3,"dcValue2":"0e1f12c2b04f4fa0d4ff9a970273eebf"},{"dcValue1":1,"dcValue2":2}]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/DB/QueryBuilder/QueryBuilder.php","line":216,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Cache.php","line":472,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Cache.php","line":487,"function":"getId","class":"OC\\Files\\Cache\\Cache","type":"->","args":["appdata_ocodvf32kecd/preview/2/c/f/d/4/5/6/1123"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Scanner.php","line":177,"function":"getParentId","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Scanner.php","line":338,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameter replaced ***",3,-1,null,false]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Updater.php","line":125,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameter replaced ***",false,3,false]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/View.php","line":323,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/View.php","line":1176,"function":"writeUpdate","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":{"__class__":"OC\\Files\\Cache\\Propagator"},"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\Files_Trashbin\\Storage"},"*** sensitive parameter replaced ***"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/View.php","line":696,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["file_put_contents","/appdata_ocodvf32kecd/preview/2/c/f/d/4/5/6/1123/1024-1024-crop.jpg",["create","write"],null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Node/Folder.php","line":187,"function":"file_put_contents","class":"OC\\Files\\View","type":"->","args":["/appdata_ocodvf32kecd/preview/2/c/f/d/4/5/6/1123/1024-1024-crop.jpg",null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/SimpleFS/NewSimpleFile.php","line":133,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->","args":["1024-1024-crop.jpg",null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Preview/Generator.php","line":427,"function":"putContent","class":"OC\\Files\\SimpleFS\\NewSimpleFile","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Preview/Generator.php","line":183,"function":"generatePreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"},{"__class__":"OCP\\Image"},1024,1024,true,4096,2153,""]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Preview/Generator.php","line":107,"function":"generatePreviews","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},[{"width":375,"height":375,"crop":true,"mode":"fill"}],"image/jpeg"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/PreviewManager.php","line":190,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},375,375,true,"fill",null]},{"file":"/usr/local/www/nextcloud.19.0.1/core/Controller/PreviewController.php","line":170,"function":"getPreview","class":"OC\\PreviewManager","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},375,375,true,"fill"]},{"file":"/usr/local/www/nextcloud.19.0.1/core/Controller/PreviewController.php","line":143,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},375,375,false,false,"fill"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"getPreviewByFileId","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[1123,375,375,false,false,"fill"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreviewByFileId"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/App.php","line":137,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreviewByFileId"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\PreviewController","getPreviewByFileId",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"core.Preview.getPreviewByFileId"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"core.Preview.getPreviewByFileId"}]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Route/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"core.Preview.getPreviewByFileId"}]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/base.php","line":1007,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/core/preview"]},{"file":"/usr/local/www/nextcloud.19.0.1/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":119,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":"HY000","Trace":[{"file":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":117,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":903,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/DB/Connection.php","line":194,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = ?) AND (`path_hash` = ?)",[3,"0e1f12c2b04f4fa0d4ff9a970273eebf"],[1,2],null]},{"file":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":200,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)",{"dcValue1":3,"dcValue2":"0e1f12c2b04f4fa0d4ff9a970273eebf"},{"dcValue1":1,"dcValue2":2}]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/DB/QueryBuilder/QueryBuilder.php","line":216,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Cache.php","line":472,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Cache.php","line":487,"function":"getId","class":"OC\\Files\\Cache\\Cache","type":"->","args":["appdata_ocodvf32kecd/preview/2/c/f/d/4/5/6/1123"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Scanner.php","line":177,"function":"getParentId","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Scanner.php","line":338,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameter replaced ***",3,-1,null,false]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Cache/Updater.php","line":125,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameter replaced ***",false,3,false]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/View.php","line":323,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/View.php","line":1176,"function":"writeUpdate","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":{"__class__":"OC\\Files\\Cache\\Propagator"},"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\Files_Trashbin\\Storage"},"*** sensitive parameter replaced ***"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/View.php","line":696,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["file_put_contents","/appdata_ocodvf32kecd/preview/2/c/f/d/4/5/6/1123/1024-1024-crop.jpg",["create","write"],null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/Node/Folder.php","line":187,"function":"file_put_contents","class":"OC\\Files\\View","type":"->","args":["/appdata_ocodvf32kecd/preview/2/c/f/d/4/5/6/1123/1024-1024-crop.jpg",null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Files/SimpleFS/NewSimpleFile.php","line":133,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->","args":["1024-1024-crop.jpg",null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Preview/Generator.php","line":427,"function":"putContent","class":"OC\\Files\\SimpleFS\\NewSimpleFile","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Preview/Generator.php","line":183,"function":"generatePreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"},{"__class__":"OCP\\Image"},1024,1024,true,4096,2153,""]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Preview/Generator.php","line":107,"function":"generatePreviews","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},[{"width":375,"height":375,"crop":true,"mode":"fill"}],"image/jpeg"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/PreviewManager.php","line":190,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},375,375,true,"fill",null]},{"file":"/usr/local/www/nextcloud.19.0.1/core/Controller/PreviewController.php","line":170,"function":"getPreview","class":"OC\\PreviewManager","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},375,375,true,"fill"]},{"file":"/usr/local/www/nextcloud.19.0.1/core/Controller/PreviewController.php","line":143,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},375,375,false,false,"fill"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"getPreviewByFileId","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[1123,375,375,false,false,"fill"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreviewByFileId"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/App.php","line":137,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreviewByFileId"]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\PreviewController","getPreviewByFileId",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"core.Preview.getPreviewByFileId"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"core.Preview.getPreviewByFileId"}]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/private/Route/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"core.Preview.getPreviewByFileId"}]},{"file":"/usr/local/www/nextcloud.19.0.1/lib/base.php","line":1007,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/core/preview"]},{"file":"/usr/local/www/nextcloud.19.0.1/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":117}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.72 Safari/537.36","version":"19.0.1.1"}
{"reqId":"1sMS60gFnNVIolSgYyan","level":3,"time":"2021-03-11T18:03:51+00:00","remoteAddr":"172.69.142.8","user":"drew","app":"core","method":"GET","url":"/index.php/core/preview?fileId=1123&c=be1f0295d406dc83e9f82bd3ccb0205a&x=375&y=375&forceIcon=0","message":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing 'SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = ?) AND (`path_hash` = ?)' with params [3, \"0e1f12c2b04f4fa0d4ff9a970273eebf\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":0,"Trace":[{"file":"/usr/local/www/nextcloud.19.0.1/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = ?) AND (`path_hash` = ?)' with params [3, \"0e1f12c2b04f4fa0d4ff9a970273eebf\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away",{"errorInfo":["HY000",2006,"MySQL server has gone away"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]$

 # cat config.php
<?php
$CONFIG = array (
  'instanceid' => 'ocodvf32kecd',
  'passwordsalt' => '<removed>',
  'secret' => 'V<removed>',
  'trusted_domains' => 
  array (
    0 => 'localhost',
    1 => 'cloud.drewtomlinson.com',
  ),
  'datadirectory' => '/usr/local/var/nextcloud-data',
  'dbtype' => 'mysql',
  'version' => '19.0.1.1',
  'overwrite.cli.url' => 'http://localhost',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => '<removed>',
  'installed' => true,
  'mail_domain' => 'mykitchentable.net',
  'mail_from_address' => 'drew',
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_smtphost' => 'localhost',
  'mail_smtpport' => '587',
);

The output of your Apache/nginx/system log in /var/log/____:

 # tail -n 5 httpd_cloud-error.log  
[Wed Feb 24 23:47:52.182444 2021] [proxy_fcgi:error] [pid 94207:tid 34385059840] [client 108.162.249.48:21116] AH01071: Got error 'Primary script unknown\n'
[Thu Feb 25 20:28:42.960718 2021] [proxy_fcgi:error] [pid 94207:tid 34382722304] [client 162.158.63.36:44168] AH01071: Got error 'Primary script unknown\n', referer: http://cloud.drewtomlinson.com/wp-login.php
[Thu Feb 25 20:28:43.035414 2021] [proxy_fcgi:error] [pid 94207:tid 34382723584] [client 108.162.219.198:25092] AH01071: Got error 'Primary script unknown\n', referer: http://cloud.drewtomlinson.com/wp-login.php
[Mon Mar 01 08:55:56.032481 2021] [proxy_fcgi:error] [pid 94207:tid 34382729984] [client 162.158.255.172:15226] AH01071: Got error 'Primary script unknown\n'
[Tue Mar 02 20:42:02.678825 2021] [proxy_fcgi:error] [pid 94207:tid 34382732544] [client 162.158.165.210:9872] AH01071: Got error 'Primary script unknown\n'

tflidd · March 13, 2021, 10:47am

Not sure what is happening and if your error messages are related. There you loose the connection to the database. Does this happen often?
Then you don’t use caches (Memory caching — Nextcloud latest Administration Manual latest documentation) which is strongly recommended for performance and it reduces load on your databse (perhaps the reason it failed).

I am not sure if that is linked to your problem, if the password prompt is some fallback because some information couldn’t be gathered from the database. But I’d start with everything a bit unusual. On top of that, your setup is a bit old, there have been a lot of updates and bugfixes on the NC19 branch (perhaps for your problem as well): Changelog – Nextcloud

610Drew · March 13, 2021, 6:32pm

Thanks for your reply. Yes, I have a lot of those messages but they are intermittent and I don’t get new ones when accessing the share link. I didn’t know they existed until I was gathering info for my question. The rest of the system seems to work so I don’t believe that is a significant issue. Also, the same MySQL instance holds a database I use for Joomla and no issues there either. But that’s no excuse and I will look into fixing it.

I’m always reluctant to upgrade until I have several days of free time (which is hard to come by) because I’ve never had a smooth upgrade and always seem to be down for several days until I get all of the issues worked out.

If it matters, this is a small, single server I have in the Azure cloud. I don’t know if that makes any real difference or not.

Is there a SQL query I can run to verify if the share link is properly created in the database? FWIW, I have made share links on other folders as a test and experience the same behavior.

Cheers,

Drew

devnull · March 13, 2021, 9:27pm

I think it is not a normal nextcloud authentication. Use browser network analysis (e.g. F12) to find the object that perhaps needed authentication.

610Drew · March 13, 2021, 11:01pm

Thank you. I’m not exactly sure what I’m looking for. I hit F12 and the console only shows one error:

The content of expanding that error is below.

Thanks for your help!

Cheers,

Drew

VM63:1 GET https://cloud.drewtomlinson.com/ocs/v2.php/apps/text/public/workspace?path=%2F&shareToken=ZRZ7GqHbWemT6LB 404
(anonymous)	@	VM63:1
(anonymous)	@	xhr.js:178
e.exports	@	xhr.js:12
e.exports	@	dispatchRequest.js:50
Promise.then (async)		
s.request	@	Axios.js:61
n.forEach.s.<computed>	@	Axios.js:76
(anonymous)	@	bind.js:9
getFileInfo	@	RichWorkspace.vue:132
(anonymous)	@	RichWorkspace.vue:102
u	@	runtime.js:45
(anonymous)	@	runtime.js:274
forEach.e.<computed>	@	runtime.js:97
u	@	public.js?v=53ebd0ba-0:23
a	@	public.js?v=53ebd0ba-0:23
(anonymous)	@	public.js?v=53ebd0ba-0:23
(anonymous)	@	public.js?v=53ebd0ba-0:23
mounted	@	public.js?v=53ebd0ba-0:23
Ke	@	vue.esm.js:1863
tn	@	vue.esm.js:4228
(anonymous)	@	vue.esm.js:4095
kn.$mount	@	vue.esm.js:9063
kn.$mount	@	vue.esm.js:11974
(anonymous)	@	files.js:192
Promise.then (async)		
render	@	files.js:181
(anonymous)	@	filelist.js?v=53ebd0ba-0:461
setTimeout (async)		
(anonymous)	@	filelist.js?v=53ebd0ba-0:460
initHeadersAndFooters	@	filelist.js?v=53ebd0ba-0:451
initialize	@	filelist.js?v=53ebd0ba-0:439
FileList	@	filelist.js?v=53ebd0ba-0:32
initialize	@	public.js?v=53ebd0ba-0:66
(anonymous)	@	public.js?v=53ebd0ba-0:480
(anonymous)	@	index.js:826
setTimeout (async)		
(anonymous)	@	index.js:825
(anonymous)	@	index.js:115
Se	@	index.js:759
i	@	index.js:790
(anonymous)	@	public.js?v=53ebd0ba-0:479
c	@	jquery.js:3099
fireWith	@	jquery.js:3211
ready	@	jquery.js:3417
P	@	jquery.js:3433

tflidd · March 14, 2021, 9:39am

Upgrades (between major versions) are more tricky, some dependencies or versions might change and it’s good not to do them if you don’t have any time. The normal updates within a major version should be much less problematic and for bugfixes and security fixes, you should install them with not too much delay. If you even have problems with minor version, there is perhaps something to look after in your setup, perhaps you are hitting timeouts, database is too large, …

tflidd · March 14, 2021, 6:29pm

Just thinking, you are not using a textfile that is shared?

610Drew · March 15, 2021, 9:21pm

I don’t think so. This is my own personal server. I am the only user on the server. I only have one Nextcloud instance running. The only way I can imagine it might appear “shared” is I have upgraded Nextcloud a few times to get to my current version.

How can I confirm one way or the other?

Thanks,

Drew

610Drew · March 23, 2021, 9:03pm

I have updated my system to PHP 7.4.16 and Nextcloud 19.0.9. This resolved my previous issues and now share links are working as expected.

However I have a new issue regarding wddx.so. I’ve Googled and it appears wddx is not relevant to PHP 7.4. So what’s trying to load this and how do I make it stop? Here is an example of the error I get when using occ:

PHP Warning:  PHP Startup: Unable to load dynamic library 'wddx.so' (tried: /usr/local/lib/php/20190902/wddx.so (Cannot open "/usr/local/lib/php/20190902/wddx.so"), /usr/local/lib/php/20190902/wddx.so.so (Cannot open "/usr/local/lib/php/20190902/wddx.so.so")) in Unknown on line 0

Thanks for your assistance!

Cheers,

Drew

CFelix · March 24, 2021, 3:27pm

Hi Drew,

something on your server seems to require that library/extension. Is Nextcloud the only thing or do you have any other projects running on that server?

Please could you also list all apps, you are using in Nextcloud?

As per PHP: Introduction - Manual - This extension is DEPRECATED and UNBUNDLED as of PHP 7.4.0.

Since you upgraded your PHP, it probably removed the extension due to the deprecation.

610Drew · March 24, 2021, 5:26pm

I think I have resolved the issue. This is a FreeBSD box which had a list of *.ini files in /usr/local/etc/php. I found this one and renamed it to *.off:

 # ll *wddx.ini*
-rw-r--r--  1 root  wheel  18 Aug 18  2020 ext-30-wddx.ini

Now I no longer receive the error message.

Thanks for everyone’s time!

Cheers,

Drew