Hestia Panel + Owncloud

Hi guys,

A pretty wierd thing i’m having : I can’t use at all a Owncloud installation on Hestia Panel.

I’ve used Hestia Panel with no problem since like from the first time i’ve heard of the fork,
so i’m pretty happy with it, i’ve migrated from Vesta Panel to Hestia, with full fresh installs on all my servers.

I’ve tried to install it on Debian 10 , Debian 11 but with no success.
I’m using a hypervisor, Proxmox Ve, which is based on Debian Linux, so it’s ok for this .

I don’t get it, i didn’t had any problems with Hestia Panel and the LXC container and Owncloud,
I’ve tried like n… times to make another server.
I’ve tried it even in production, don’t ask me, if i’m brave :slight_smile: i like to feel the pain if you get my joke,
people calling me and asking me why the server / Owncloud solution is not working at all…

It installs, everything is ok , i modify the upload parameters, for the upload of large files, but when i’m trying to upload files to the server if just hangs, and spits out an error like Error when assembling chunks , status code 500 , i’ve tried all the settings that i know and all the configuration that i could find on the net.

I would like if somebody can tell me with a fresh install of Proxmox VE, an LXC container and
Hestia + Owncloud to make something or if somebody has hit the wall with LXC containers + Hestia + Owncloud.

Best regards,

Puma2001

Probaly related, create a custom theme and try again. We will address this issue in 1.5.2: Tip: create a NGINX template for Nextcloud, to let synchronize files bigger than 10Mb

will give it a try, tomorrow after i’m at home, i still have my virtual instances and i will hit a reply . I like so much Hestia, so i’m like attached to it to work, it’s such a good panel .

Thanks ScIT, hopefull it will work on my server.

Hello, i published 4 days ago the post that @ScIT has mentioned above.

It’s really very simple the problem and the solution, so i recommend to you that read it.

Basically the NGINX default settings BLOCK the access to “hidden” files/directories (those starting with a period), and Nextcloud manage the uploading of big files (files bigger than 9.3Mb!!!) splitting the upload in several chunks of 10000000 bytes, which are re-assembled once uploaded the “last bit” in a file with filename just “.file” (with a period as first character !!!). It probably is a bad decision from the developers of such “chunk” system… i don’t know.

But briefly, the solution consists in add an exception rule in NGINX configuration file to not block the “.file” access… and voilà, your Nextcloud run perfect! then the “.file” file can be moved to their destination user directory without any problem.

In my post i give you the details step by step: it’s recommendable to create a new NGINX template config file, and then assign it as “Proxy template” to the host where you have running Nextcloud. In this way this change will be permanent although you update HestiaCP or its servers (açpache, nginx, etc…) in the future.

Please, comment here if you get it work fine also with Owncloud :wink:

Cheers!

1 Like

I tested the solution in my lab environment, and i can say that this is the solution .

I also tested the solution on the main live hosting environment, and it worked also there, but there’s some problems with another service on that server, and i will make a move to make a clean server install, and i will mess arround with the solution and i will make it permanent.

So in short, it’s working with owncloud also, this is absolutely a fantastic news, now i can make the necessary preparations for the new virtual server and to the new cloud storage server.

Cheers !
Puma2001

1 Like

So, i’ve made today a new fresh server, in production mode, Hestia Panel clean install, all the modifications, and it’ works like a charm.
It’s fast, even faster now than it was when the VM failed, so i’m pretty happy with it.
I made the changes to the Hestia Panel and i’ve worked with the VM with no problems at all .

So it’s for sure a good solution !

best regards,
Puma2001

I got another thing with Hestia and Owncloud, i’m trying to download a file and after 1 Gigabyte of download the download resets and just keeps resetting the download, in a loop. At the start of the installation, everything was working perfectly.

Did somebody hit the same problems with this kind of stuff ??

Thanks guys

As far as i can see when i made the install i had Hestia 1.5.2 and now i have 1.5.4 … so after the automatic update the whole download of files via Owncloud failed … How can i make it work again ?

Check the logs in /var/log/apache2/domains/domain.com.error.log

Hi,
I’ve cheched it, and it does give some errors , but it’s wierd …
I’ve tested the upload and download of files, and it works, if you are in a Owncloud Account, but if you make a public link to share, and give i to somebody or try to download from it it fails, it just keeps resetting the download traffic in a loop . Maybe it’s not from Hestia Panel, i don’t really get the problem, but when i was on 1.5.2 everything was OK .

here are some logs :

[Mon Jan 10 06:23:31.653761 2022] [proxy_fcgi:error] [pid 24935:tid 140286810367744] (70007)The timeout specified has expired: [client 0.0.0.0:0] AH01075: Error dispatching request to : (polling)
[Mon Jan 10 06:40:36.450807 2022] [proxy_fcgi:error] [pid 24935:tid 140286801975040] (70007)The timeout specified has expired: [client 0.0.0.0:0] AH01075: Error dispatching request to : (polling)
[Mon Jan 10 06:52:19.188299 2022] [proxy_fcgi:error] [pid 24934:tid 140286718048000] [client 192.168.101.129:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129\nStack trace:\n#0 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(129): PDOStatement->execute()\n#1 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1073): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /home/owncloud/web/domainname.com/public_html/lib/private/DB/Connection.php(207): Doctrine\DBAL\Connection->executeUpdate()\n#3 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(210): OC\DB\Connection->executeUpdate()\n#4 /home/owncloud/web/domainname.com/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\Quer…’
[Mon Jan 10 07:41:52.538843 2022] [proxy_fcgi:error] [pid 24934:tid 140286953019136] (70007)The timeout specified has expired: [client 0.0.0.0:0] AH01075: Error dispatching request to : (polling)
[Mon Jan 10 07:50:51.265688 2022] [proxy_fcgi:error] [pid 24935:tid 140286827153152] [client 0.0.0.0:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129\nStack trace:\n#0 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(129): PDOStatement->execute()\n#1 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1073): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /home/owncloud/web/domainname.com/public_html/lib/private/DB/Connection.php(207): Doctrine\DBAL\Connection->executeUpdate()\n#3 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(210): OC\DB\Connection->executeUpdate()\n#4 /home/owncloud/web/domainname.com/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\Quer…’
[Mon Jan 10 07:58:21.335472 2022] [proxy_fcgi:error] [pid 24935:tid 140286743226112] [client 0.0.0.0:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129\nStack trace:\n#0 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(129): PDOStatement->execute()\n#1 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1073): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /home/owncloud/web/domainname.com/public_html/lib/private/DB/Connection.php(207): Doctrine\DBAL\Connection->executeUpdate()\n#3 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(210): OC\DB\Connection->executeUpdate()\n#4 /home/owncloud/web/domainname.com/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\Quer…’
[Mon Jan 10 11:00:07.231751 2022] [proxy_fcgi:error] [pid 24934:tid 140286718048000] (70008)Partial results are valid but processing is incomplete: [client 192.168.101.129:0] AH01075: Error dispatching request to : (reading input brigade)
[Wed Jan 12 06:00:27.914854 2022] [proxy_fcgi:error] [pid 19422:tid 140286206387968] (70007)The timeout specified has expired: [client 0…0.0.0:0] AH01075: Error dispatching request to : (polling)
[Wed Jan 12 08:51:44.414857 2022] [proxy_fcgi:error] [pid 19422:tid 140286197995264] (70007)The timeout specified has expired: [client 0.0.0.0:0] AH01075: Error dispatching request to : (polling)
[Wed Jan 12 09:26:43.454220 2022] [proxy_fcgi:error] [pid 19422:tid 140286953019136] [client 0.0.0.0:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129\nStack trace:\n#0 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(129): PDOStatement->execute()\n#1 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1073): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /home/owncloud/web/domainname.com/public_html/lib/private/DB/Connection.php(207): Doctrine\DBAL\Connection->executeUpdate()\n#3 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(210): OC\DB\Connection->executeUpdate()\n#4 /home/owncloud/web/domainname.com/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\Quer…’
[Wed Jan 12 09:26:43.673906 2022] [proxy_fcgi:error] [pid 19421:tid 140286164457216] [client .0.0.0.0:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129\nStack trace:\n#0 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(129): PDOStatement->execute()\n#1 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1073): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /home/owncloud/web/domainname.com/public_html/lib/private/DB/Connection.php(207): Doctrine\DBAL\Connection->executeUpdate()\n#3 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(210): OC\DB\Connection->executeUpdate()\n#4 /home/owncloud/web/domainname.com/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\Quer…’
[Wed Jan 12 09:26:46.045402 2022] [proxy_fcgi:error] [pid 19422:tid 140286818760448] [client 0.0.0.0.0:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129\nStack trace:\n#0 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(129): PDOStatement->execute()\n#1 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1073): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /home/owncloud/web/domainname.com/public_html/lib/private/DB/Connection.php(207): Doctrine\DBAL\Connection->executeUpdate()\n#3 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(210): OC\DB\Connection->executeUpdate()\n#4 /home/owncloud/web/domainname.com/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\Quer…’
[Wed Jan 12 10:05:32.777830 2022] [proxy_fcgi:error] [pid 19422:tid 140286348998400] [client 0.0.0.0:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129\nStack trace:\n#0 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(129): PDOStatement->execute()\n#1 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1073): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /home/owncloud/web/domainname.com/public_html/lib/private/DB/Connection.php(207): Doctrine\DBAL\Connection->executeUpdate()\n#3 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(210): OC\DB\Connection->executeUpdate()\n#4 /home/owncloud/web/domainname.com/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\Quer…’
[Wed Jan 12 11:48:53.586271 2022] [proxy_fcgi:error] [pid 19422:tid 140286953019136] [client 0.0.0.0:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129\nStack trace:\n#0 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(129): PDOStatement->execute()\n#1 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1073): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /home/owncloud/web/domainname.com/public_html/lib/private/DB/Connection.php(207): Doctrine\DBAL\Connection->executeUpdate()\n#3 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(210): OC\DB\Connection->executeUpdate()\n#4 /home/owncloud/web/domainname.com/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\Quer…’
[Wed Jan 12 11:52:34.125122 2022] [proxy_fcgi:error] [pid 19422:tid 140286365783808] (70007)The timeout specified has expired: [client 0.0.0.0:0] AH01075: Error dispatching request to : (polling)
[Wed Jan 12 11:58:22.904025 2022] [proxy_fcgi:error] [pid 19422:tid 140286843938560] [client 0.0.0.0:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129\nStack tra’
[Wed Jan 12 11:58:22.904594 2022] [proxy_fcgi:error] [pid 19422:tid 140286843938560] [client 0.0.0.0:0] AH01071: Got error 'ce:\n#0 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(129): PDOStatement->execute()\n#1 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1073): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /home/owncloud/web/domainname.com/public_html/lib/private/DB/Connection.php(207): Doctrine\DBAL\Connection->executeUpdate()\n#3 /home/owncloud/web/domainname.com/public_html/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(210): OC\DB\Connection->executeUpdate()\n#4 /home/owncloud/web/domainname.com/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\Quer…

Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in

So it seems to be an issue with Mysql probally a time out. We haven’t changed anything regarding Mysql and php it self.

Will make a test install soon …