Cloudron Forum

malvim

@nebulon yup! I tried it as well, and could not get it to work. building on the pi itself proved to be
the easiest way...

malvim

Sounds awesome! You guys rock.

I've had an interest in multi-host support forever, but haven't been following the discussions as of late. Curious about how billing and support will work.

Is this a single dashboard for multiple cloudrons, so that we'll pay for each one separately? Or is it a single cloudron with multi-host capabilities, so that we just throw a bunch of machines on a single cloudron install and it just does its thing?

Thanks!

malvim

@atrilahiji I used yunohost for a while, and cloudron's ssl certificate stuff and containerization was what got me hooked.

I actually liked yunohost's SSO a bit more (from a user standpoint, can't say about it being well-designed or this kind of thing), because IIRC you could actually sign-in to an app and be already signed into all others that you hosted, which was a nice experience overall.

I still think cloudron is a MUCH better product, which is why I stuck with it and started paying for it. Managing of ssl certificates without intervention and containerization were what got me into it, but great documentation, ease of packaging, support, and a thriving community is what keeps me here. Cloudron rocks.

Edit: Just remembered something else: automatic DNS management, and BACKUPS! Holy moly, automatic off-site backups!

malvim

@girish, maybe I'm sidetracking here, and it's just out of curiosity, I have no horse in this race, but: is there a need for an APP image to be based on Ubuntu?

I understand the need in the base image, lots of libs and binaries and features we need during build time, but what's stopping an app image from, say, using a second FROM statement based off of alpine, for example, and just copying whatever it needs?

malvim

@murgero Whoa, count me in. I'd use this a lot.

malvim

like this:

20:03:36 - In AbstractPostgreSQLDriver.php line 89:
20:03:36 -                                                                                
20:03:36 -   An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients  
20:03:36 -   " DROP CONSTRAINT idx_user_oauth_client':                                    
20:03:36 -                                                                                
20:03:36 -   SQLSTATE[42704]: Undefined object: 7 ERROR:  constraint "idx_user_oauth_cli  
20:03:36 -   ent" of relation "wallabag_oauth2_clients" does not exist                    
20:03:36 -                                                                                
20:03:36 - 
20:03:36 - In PDOConnection.php line 91:
20:03:36 -                                                                                
20:03:36 -   SQLSTATE[42704]: Undefined object: 7 ERROR:  constraint "idx_user_oauth_cli  
20:03:36 -   ent" of relation "wallabag_oauth2_clients" does not exist                    
20:03:36 -                                                                                
20:03:36 - 
20:03:36 - In PDOConnection.php line 86:
20:03:36 -                                                                                
20:03:36 -   SQLSTATE[42704]: Undefined object: 7 ERROR:  constraint "idx_user_oauth_cli  
20:03:36 -   ent" of relation "wallabag_oauth2_clients" does not exist                    
20:03:36 -                                                                                
20:03:36 -

malvim

@nebulon Just updated to 1.5.2 and getting migration problems and such

malvim

@nebulon Great work!

I got really caught up with work and personal stuff over the last weeks, so I was not able to keep on working.

On most addon repos, I was creating arm64 branches as well, but most of them were just a matter of changing the base image to not have the hash. I was using cloudron/baseimage and building it on the pi itself before trying to install cloudron, so I had it tagged locally with that name, and others wouldn't download from docker hub, using the local arm64 one instead.

I'll search for any changes I have made over here, but they're not a lot.

I'll post a suymmary tonight.

malvim

@ctrl Yeah, I think if you run docker ps you'll be able to see what's going on a bit better. The apps use databases like mysql, mongodb, redis; There's also other addons like sftp, mail, turn, and graphite.

malvim

@girish and @Lonk this seems to make sense, but I don't think I can install a first version of cloudron in order to use hotfix, which seems to be how this works, right?

malvim

Not sure this is where I should post this, but...

Well, I'm still working on the raspberry pi thing, and I'd like to try and install Cloudron straight from a box checkout, as it's easier to just change stuff and try again. But cloudron-setup downloads the image from the internet.

I previously just switched the curl line for the copying of an extracted version of the image to the temp source dir. Should I just copy the whole box directory somewhere in this step, or is there an easier way that I can't think of right now? Anyone here with experience working on box code that could chip in with an idea?

malvim

@girish okay, cool, I'll use that. It's good news, then, that the OTHER tests even ran!

So, for what it's worth, the code seemed to fail on the use of EventEmitter. A class was dispatching an event and the corresponding listener was not triggered, so if you ever need to investigate further, maybe that's a start.

malvim

MAN, it seems I'm running into ALL KINDS of weird problems hahaha!

I started going into postgresql node client's code, and it seemed to be some weird behavior of EventEmitter, which was weird...

I installed nvm and tested with older node distributions, and it ran fine on my laptop! So it seems, @girish, that the test code for postgresql-addon does not run with node v14 or later on my machines. Tested with v12 and v13 and it was all fine. What version are you using for tests?

Moving on to the next hurdle, I guess hahah!

malvim

Hey, @Lonk! You mind testing this on your laptop? I'm not getting these errors only on the Pi, I'm getting them on my amd64 laptop and amd64 server as well!

Repo is here: https://git.cloudron.io/cloudron/postgresql-addon, it's just a matter of:

cloning it;
building the image locally (docker build -t cloudron/postgresqladdontest .)
installing dependencies (npm install)
running the test (npm test)

Could you run this somewhere and see if you have the same problem?

Thanks!

malvim

I tried recreating the steps inside the container using node, and could connect. I'm really at a loss here right now...

malvim

Also, it does not seem to be network-related, since I get the same behavior on an ubuntu 20.04 VPS I have...

malvim

Hey,

So I commented out the remove database tests because I had trouble connecting from the container, but the next test, use the database, starts like this:

// psql -h localhost -U usetestuser  -d usetestdatabase
describe('use the database', function () {
    const data = { database: 'usetestdatabase', username: 'usetestuser', password: 'somepassword', locale: 'C' };

    before(function (done) {
        async.series([
            addDatabase.bind(null, data),
            connectClient.bind(null, data)
        ], done);
    });

So I ran "psql -h localhost -U usetestuser -d usetestdatabase", using 'somepassword' as a password, and was able to connect, both from inside the container and from my host machine.

connectClient still doesn't connect, and, I get this on the screen:

    auth
      ✓ fails without access_token
      ✓ fails with invalid access_token
      ✓ succeeds
    use the database
usetestuser somepassword usetestdatabase 172.18.0.2 5432
      1) "before all" hook

  3 passing (2m)
  1 failing

  1) Postgresql Addon
       use the database
         "before all" hook:
     Error: Timeout of 100000ms exceeded. For async tests and hooks, ensure "done()" is called; if returning a Promise, ensure it resolves. (/home/malvim/Projetos/Pi/docker/postgresql-addon/test/test.js)
      at listOnTimeout (internal/timers.js:551:17)
      at processTimers (internal/timers.js:494:7)

   
      2) "after all" hook

malvim

@girish Nope. Ubuntu 20.04 on both my laptop and a server, Ubuntu 18.04 on the raspberry pi. All with the same result.

malvim

Hey, guys.

So, this is what's going on currently:

I was able to build and run tests for, with minimal adaptations, the docker-base-image project, and the following addons:

docker-sftp
mongodb-addon
mysql-addon
redis-addon
turn-addon

That leaves mail-addon, docker-graphite and postgresql-addon

Mail needs more setup as @girish said, so I'm not doing it for now. I was not able to clone the docker-graphite project, as I think I've mentioned before, so still waiting on what to do in this case.

In trying to understand a bit more of what's going on with the postgreql-addon tests hanging, I found it hangs in any test that uses connectClient, like the remove database and use database tests:

describe('remove database', function () {
    const data = { database: 'removetestdatabase', username: 'removetestuser', password: 'somepassword', locale: 'C' };

    before(function (done) {
        addDatabase(data, done);
    });

    it('succeeds', function (done) {
        request.delete(`https://${ip}:3000/databases/${data.database}?access_token=${CLOUDRON_POSTGRESQL_TOKEN}&username=${data.username}`, { rejectUnauthorized: false }, function (error, response, body) {
            expect(error).to.be(null);
            expect(response.statusCode).to.equal(200);

            connectClient(data, function (error) {
                expect(error).to.not.eql(null);
                client.end(done);
            });
        });
    });
});

In this case, addDatabase runs ok, and it makes sense since it is tested before.

The function is called, request.delete is called, the two expects pass, and then the function INSIDE connectClient (with the expect(error) line) never runs.

Can anyone else (besides @girish, who ran the tests and seen them run fine) run this and see what happens? This is happening on my laptop as well, not only on the Pi, but if I can't get this to go, I can't get the tests to pass on the pi, and we won't be able to trust everything runs okay.

malvim

@girish Sounds good, thanks.

Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.

Posts made by malvim