Jump to content

goose1701

Members
  • Posts

    10
  • Joined

  • Last visited

Posts posted by goose1701

  1. 1 hour ago, binhex said:

    nothing obviously wrong there, whats the ip of the machine running the web browser? (as in the client pc you are using to attempt connection to the sabnzbd web ui)

    10.0.0.11 primarily, though this happens regardless of device. Should be noted that sabnzbdvpn is still actually working for me, just can't access the webui.

  2. On 6/17/2020 at 7:03 AM, Coolsaber57 said:

    I was reading on reddit that some dude solved this by using Postgres instead of MariaDB, but I'm having trouble creating a user in Postgres to test this: https://old.reddit.com/r/unRAID/comments/fy7na5/nextcloud_login_and_navigation_extremely_slow/

     

    Are you able to try this?

     

    Edit: Fixed!

     

    Ok, I don't know why but the cause of the slowdown was MariaDB.  Following the above reddit post, I downloaded Postgres 11 and set up the db using the following commands:

     

    
    su - postgres
    createuser --interactive --pwprompt
    [enter desired name e.g. nextcloud]
    [enter desired password]
    [confirm desired password]
    [Superuser?: n]
    [create databases?: n]
    [create more roles?: n]
    createdb nextcloud
    psql
    GRANT permissions ON DATABASE nextcloud TO nextcloud

     

    Then selected Postgres on the Nextcloud setup page and entered the details. 

     

    The page actually loads like normal, finally.

    Awesome. If I get time I will be giving this a shot tonight(too bad you have to start over from scratch on the Nextcloud install though), if not definitely this weekend. Glad to at least know what the problem is now.

     

    That indeed worked! Fantastic.

  3. Having some weird issues with the web UI being incredibly slow after the last couple of upgrades. I know it's not bandwidth or speed issues with my server, because for instance my Jellyfin and Airsonic servers are as snappy as ever running on the same machine. I have my own domain of which nextcloud is a sub on going through let's encrypt, but I know that's not an issue either, since the aforementioned Jellyfin and Airsonic servers are also sub domains of the same also through let's encrypt.

     

    Nextcloud docker logs are clean. All checks passed on the Security and Setup section. Though this does pop up in the logging section, not sure if it's related:

     

    Quote

    [core] Error: Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused at <<closure>>

     0. /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 889
        OC\DB\Connection->connect()
     1. /config/www/nextcloud/lib/private/DB/Connection.php line 194
        Doctrine\DBAL\Connection->executeQuery("SELECT * FROM `oc_appconfig`", [], [], null)
     2. /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 200
        OC\DB\Connection->executeQuery("SELECT * FROM `oc_appconfig`", [], [])
     3. /config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 216
        Doctrine\DBAL\Query\QueryBuilder->execute()
     4. /config/www/nextcloud/lib/private/AppConfig.php line 331
        OC\DB\QueryBuilder\QueryBuilder->execute()
     5. /config/www/nextcloud/lib/private/AppConfig.php line 109
        OC\AppConfig->loadConfigValues()
     6. /config/www/nextcloud/lib/private/AppConfig.php line 287
        OC\AppConfig->getApps()
     7. /config/www/nextcloud/lib/private/legacy/OC_App.php line 883
        OC\AppConfig->getValues(false, "installed_version")
     8. /config/www/nextcloud/lib/private/TemplateLayout.php line 164
        OC_App::getAppVersions()
     9. /config/www/nextcloud/lib/private/legacy/OC_Template.php line 185
        OC\TemplateLayout->__construct("error", "")
    10. /config/www/nextcloud/lib/private/Template/Base.php line 132
        OC_Template->fetchPage()
    11. /config/www/nextcloud/lib/private/legacy/OC_Template.php line 334
        OC\Template\Base->printPage()
    12. /config/www/nextcloud/index.php line 63
        OC_Template::printExceptionErrorPage(Doctrine\DBAL\DBALException {}, 500)

    GET /index.php/204
    from 73.169.171.95 at 2020-06-07T07:01:31+00:00

    Thoughts?

  4. 3 hours ago, mkono87 said:

    My container was updated 3 days ago and now all I get is this in the log  Whats going on?? 

    200507 18:44:16 mysqld_safe Logging to syslog.
    200507 18:44:16 mysqld_safe Starting mysqld daemon with databases from /config/databases
    200507 18:44:18 mysqld_safe Logging to syslog.
    200507 18:44:18 mysqld_safe Starting mysqld daemon with databases from /config/databases
    200507 18:44:20 mysqld_safe Logging to syslog.
    200507 18:44:20 mysqld_safe Starting mysqld daemon with databases from /config/databases
    200507 18:44:22 mysqld_safe Logging to syslog.
    200507 18:44:22 mysqld_safe Starting mysqld daemon with databases from /config/databases

     

    EDIT  I had a look at the previous posts and removed Maria DB and appdata folder for it. When I spin it up again I noticed on the docker page the update status read not available instead of up to date.

    I'm getting the exact same thing, which has taken down nextcloud obviously. When I tried to login in I get :

    Quote

    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

     

    EDIT:

    And just like the above, deleting mariadb completely along with the appdata folder, restoring from my last CA backup a few days ago, and then reinstalling the docker container while pointing it to the restored appdata folder fixed the issue.

     

    Thank god for backups, but I really shouldn't had have to use it just because of an update....

  5. Everything working great last night. After updating the docker this morning, now I get

     

    Quote

    Internal Server Error The server encountered an internal error and was unable to complete your request. Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report. More details can be found in the server log.

    Doesn't appear to be anything super obvious in the logs...

     

    Actually disregard, appears to be a Let's Encrypt issue, not a NextCloud issue.

     

    EDIT:

    So actually turns out it was a mariadb issue. Mariadb was updated at the same time and apparently it corrupted my database somehow. So I deleted mariadb completely along with the appdata, restored the appdata from a CA Backup from a couple days ago, and then re-installed mariadb while pointing to the already restored appdata folder. Restarted mariadb and nextcloud and Nextcloud fired right up.

     

    Weird. Huzzah for backups.

    Nextcloud Logs

  6. I was also getting issues with this docker and binhex-delugevpn with torrents starting slow and then immediately stalling using Windscribe. Checked my download mappings and those were fine. I setup Markus' version of qbittorentvpn with the same exact config, same vpn config, same settings, everything identical and absolutely no stalling whatsoever. So there's definitely something going on with the binhex version of these torrent clients. Binhex-sabnzvpn is still working great.

×
×
  • Create New...