HumHub - social network software

[doodlemania2]

@atridad what's the location?

[girish]

@atridad yeah, it seems the git repo is a broken link now. What's the new location ?

[Sam_uk]

@girish AFAIK the latest is here: https://github.com/atridadl/cloudron-humhub-app

[A Former User]

@Sam_uk it’s mirrored to the cloudron gitlab just to make it easier to get to as well.

[nebulon]

I have just given it a spin and it seems to work ok.

So far as I can tell, it could make use of a pre-setup admin account, like we have in other apps to skip the "install" wizard, especially since it comes with LDAP setup already.

Further it will need tests (looks like currently those are only copied over from the LAMP app)

Is there anything else I may have missed?

@atridad do you think the admin account pre-setup is doable?

[A Former User]

@nebulon I can add some proper tests for sure. As for initial account setup, this is problematic since it seems humhub requires manual setup to get the DB set up to allow accounts to be made at all. This is why LDAP and email are only working after the first re-start post setup.

[doodlemania2]

@atridad Tried too but got something about a "base table doesn't exist"

[A Former User]

@doodlemania2 O_O where in the process did you encounter this issue? The flow for this app is a bit odd.

1. Install app
2. Go to the app and follow the setup
3. Restart the app
4. Use the app

Also make sure the admin user does not have the same login as any users on your cloudron.

[doodlemania2]

@atridad No worries - wasn't able to get to the initial setup, this was on first run - looks like it was missing a .schema file or something.
Cloned from GitHub and not git.cloudron - should I try git.cloudron instead?

[A Former User]

@doodlemania2 GitHub is where I update things and I have a workflow running to push commits over to Git.cloudron. If that ever fails technically GitHub would be the proper source of truth. But on to that issue, I am doing some updates for @Sam_uk tonight on his instances so if I encounter this I will let you know. If not, perhaps debugging 1-on-1 would be a good next step

[A Former User]

@doodlemania2 So I didn't encounter any issues this time around. I pushed a new version with some misc fixes regardless. Could you give it one more try with this new version? It adds optional SSO.

[doodlemania2]

@atridad 100% doing so now and will capture a full log if it goes boom!

Did you push to github or cloudron? GH still shows Mar 24

[A Former User]

@doodlemania2 HAH so good catch. I legitimately forgot to PUSH my commit. Rookie move. Its pushed and a new release is up.

[doodlemania2]

@atridad Did a git pull, cloudron build, no other changes, then on initial startup of app, things start up great. When I hit the app the first time, here's what goes boom:

2022-04-27 21:51:34,544 INFO success: apache2 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
Apr 27 14:51:40 - - - [27/Apr/2022:21:51:40 +0000] "GET / HTTP/1.1" 302 - "-" "Mozilla (CloudronHealth)"
Apr 27 14:51:50 - - - [27/Apr/2022:21:51:50 +0000] "GET / HTTP/1.1" 302 - "-" "Mozilla (CloudronHealth)"
Apr 27 14:52:00 - - - [27/Apr/2022:21:52:00 +0000] "GET / HTTP/1.1" 302 - "-" "Mozilla (CloudronHealth)"
Apr 27 14:52:10 - - - [27/Apr/2022:21:52:10 +0000] "GET / HTTP/1.1" 302 - "-" "Mozilla (CloudronHealth)"
Apr 27 14:52:20 - - - [27/Apr/2022:21:52:20 +0000] "GET / HTTP/1.1" 302 - "-" "Mozilla (CloudronHealth)"
Apr 27 14:52:30 - - - [27/Apr/2022:21:52:30 +0000] "GET / HTTP/1.1" 302 - "-" "Mozilla (CloudronHealth)"
Apr 27 14:52:32 Exception 'yii\db\Exception' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table '6e6072eed5097268.setting' doesn't exist
Apr 27 14:52:32 The SQL being executed was: SELECT * FROM setting WHERE (module_id='base') AND (name='cronLastHourlyRun')'
Apr 27 14:52:32 in /app/code/protected/vendor/yiisoft/yii2/db/Schema.php:676
Apr 27 14:52:32 Error Info:
Apr 27 14:52:32 Array
Apr 27 14:52:32 (
Apr 27 14:52:32 [0] => 42S02
Apr 27 14:52:32 [1] => 1146
Apr 27 14:52:32 [2] => Table '6e6072eed5097268.setting' doesn't exist
Apr 27 14:52:32 )
Apr 27 14:52:32 Caused by: Exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table '6e6072eed5097268.setting' doesn't exist'
Apr 27 14:52:32 in /app/code/protected/vendor/yiisoft/yii2/db/Command.php:1302
Apr 27 14:52:32 Stack trace:
Apr 27 14:52:32 #0 /app/code/protected/vendor/yiisoft/yii2/db/Command.php(1302): PDOStatement->execute()
Apr 27 14:52:32 #1 /app/code/protected/vendor/yiisoft/yii2/db/Command.php(1168): yii\db\Command->internalExecute()
Apr 27 14:52:32 #2 /app/code/protected/vendor/yiisoft/yii2/db/Command.php(424): yii\db\Command->queryInternal()
Apr 27 14:52:32 #3 /app/code/protected/vendor/yiisoft/yii2/db/Query.php(287): yii\db\Command->queryOne()
Apr 27 14:52:32 #4 /app/code/protected/vendor/yiisoft/yii2/db/ActiveQuery.php(304): yii\db\Query->one()
Apr 27 14:52:32 #5 /app/code/protected/humhub/libs/BaseSettingsManager.php(139): yii\db\ActiveQuery->one()
Apr 27 14:52:32 #6 /app/code/protected/humhub/commands/CronController.php(93): humhub\libs\BaseSettingsManager->getUncached()
Apr 27 14:52:32 #7 /app/code/protected/humhub/commands/CronController.php(54): humhub\commands\CronController->runHourly()
Apr 27 14:52:32 #8 [internal function]: humhub\commands\CronController->actionRun()
Apr 27 14:52:32 #9 /app/code/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
Apr 27 14:52:32 #10 /app/code/protected/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
Apr 27 14:52:32 #11 /app/code/protected/vendor/yiisoft/yii2/console/Controller.php(182): yii\base\Controller->runAction()
Apr 27 14:52:32 #12 /app/code/protected/vendor/yiisoft/yii2/base/Module.php(552): yii\console\Controller->runAction()
Apr 27 14:52:32 #13 /app/code/protected/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction()
Apr 27 14:52:32 #14 /app/code/protected/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction()
Apr 27 14:52:32 #15 /app/code/protected/vendor/yiisoft/yii2/base/Application.php(384): yii\console\Application->handleRequest()
Apr 27 14:52:32 #16 /app/code/protected/yii(29): yii\base\Application->run()
Apr 27 14:52:32 #17 {main}
Apr 27 14:52:40 - - - [27/Apr/2022:21:52:40 +0000] "GET / HTTP/1.1" 302 - "-" "Mozilla (CloudronHealth)"

[A Former User]

@doodlemania2 Weird... I'll test it again. What this looks like to me is the second start where it thinks it has initialized, and it tries to edit DB values before the DB is initialized...

You're certain you didn't restart it after installing? I don't think you're dumb I'm just making absolutely sure because this is something I haven't encountered yet.

[A Former User]

@doodlemania2 Ok, try the new release. I found a way to remove the initial setup restart requirement. The LDAP and SMTP settings are set on a cron job now.

https://github.com/atridadl/cloudron-humhub-app/releases/tag/1.5.0

[Sam_uk]

@atridad said in HumHub - social network software:

The LDAP and SMTP settings are set on a cron job

Would this still be compatible with a 'no sso' install where for example Keycloak is used instead?

[A Former User]

@Sam_uk absolutely! It only sets LDAP settings if SSO is enabled

[girish]

@atridad You probably know better but is it not better to run it in background in start.sh, instead of cronjob ? Like (setup) &. We do this for example here: https://git.cloudron.io/cloudron/kanboard-app/-/blob/master/start.sh#L76

[doodlemania2]

@atridad no worries at all good sir- trying again with your new update! (did not restart, but I can see how that would happen)