[02:02:28]
<Gregory Klyushnikov> Hey. I found this abandoned attempt to package my app: https://github.com/YunoHost-Apps/smithereen_ynh
I want to update it to the current version and fill in everything that's missing in the metadata. However, I'm confused about how databases work in YunoHost. My app uses MySQL. The manifest contains this:
```
[resources.database]
type = "mysql"
```
Which *implies* that the installation sequence should include installing MySQL itself. The documentation isn't very clear on how this works. However, it fails at the database initialization:
```
Info: Installing smithereen…
Info: Provisioning sources...
Info: Provisioning system_user...
Info: Provisioning data_dir...
Info: Provisioning install_dir...
Info: Provisioning apt...
Warning: lsof: WARNING: can't stat() fuse.gvfsd-fuse file system /run/user/1000/gvfs
Warning: Output information may be incomplete.
Warning: lsof: WARNING: can't stat() fuse.portal file system /run/user/1000/doc
Warning: Output information may be incomplete.
Warning: lsof: WARNING: can't stat() fuse.gvfsd-fuse file system /run/user/1000/gvfs
Warning: Output information may be incomplete.
Warning: lsof: WARNING: can't stat() fuse.portal file system /run/user/1000/doc
Warning: Output information may be incomplete.
Warning: lsof: WARNING: can't stat() fuse.gvfsd-fuse file system /run/user/1000/gvfs
Warning: Output information may be incomplete.
Warning: lsof: WARNING: can't stat() fuse.portal file system /run/user/1000/doc
Warning: Output information may be incomplete.
Info: Provisioning database...
sh: 1: mysqlshow: not found
Warning: /usr/share/yunohost/helpers.v2.d/mysql: line 68: mysql: command not found
Error: provision failed for database : An error occured inside the script snippet
Info: The operation 'Install the 'smithereen' app' could not be completed. Please share the full log of this operation using the command 'yunohost log share 20250517-014215-app_install-smithereen' to get help
Warning: Here's an extract of the logs before the crash. It might help debugging the error:
Info: DEBUG - ++ SCRIPT_DIR=/usr/share/yunohost
Info: DEBUG - ++ YNH_HELPERS_VERSION=2
...
```
My YunoHost installation is running in a Debian 12 ARM64 VM in Parallels. And it's probably not helped by the fact that Debian doesn't provide the real MySQL, only MariaDB.
Can someone point me in the right direction about fixing this?
[02:21:22]
<Gregory Klyushnikov> Complete log: https://paste.yunohost.org/raw/ifubojidit
[06:17:16]
<Aleks (he/him/il/lui)> `it's probably not helped by the fact that Debian doesn't provide the real MySQL, only MariaDB.` on debian, "mysql" means mariadb for like, idk, historical reasons
[06:17:16]
<Aleks (he/him/il/lui)> the linter should complain about this
[06:17:16]
<Aleks (he/him/il/lui)> sounds like the apt dependency don't contain the mariadb package
[06:17:16]
<Aleks (he/him/il/lui)> having `type = "mariadb"` would feel confusing idk, to me mariadb is just like a flavor of mysql
[06:18:38]
<Gregory Klyushnikov> Ok so it *does* need to be in the dependencies. I picked a random project that uses MySQL and it does contain `mariadb-server` there: https://github.com/YunoHost-Apps/backdrop_ynh/blob/master/manifest.toml
The problem is, I don't want MariaDB, I want the real MySQL 8. My app uses some features that, as far as I know, aren't available on MariaDB. Is that something I can do?
[06:20:26]
<Yunohost Git/Infra notifications> [synapse_ynh] rosbeef opened [issue #541](https://github.com/YunoHost-Apps/synapse_ynh/issues/541): make selhosted ntfy server work with elementx
[06:20:26]
<Yunohost Git/Infra notifications> [synapse_ynh] rosbeef edited [issue #541](https://github.com/YunoHost-Apps/synapse_ynh/issues/541): make selhosted ntfy server work with f-droid elementx
[06:22:10]
<Gregory Klyushnikov> ...anyway, let's suppose MariaDB works for me (but it'll need some testing). Now I've hit another obstacle that I'm unable to install Java 21. What do people do in this case? Do I download and install a .deb from somewhere else? Do I download a binary distribution of JDK and unpack it somewhere?
Speaking of putting things into places, the "install directory" of /var/www/smithereen isn't an appropriate place to put a Java app, so right now I'm putting the jars and the config into the "data directory". Is this ok or do I need to do something differently? In my normal installation instructions I say to put everything under /opt/smithereen
[08:13:26]
<florent[m]> ## Security fix
Can someone review this PR for Paheko? Its author made a release to fix a critical security issue (RCE kind).
https://github.com/YunoHost-Apps/paheko\_ynh/pull/91
[08:14:02]
<florent[m]> poke rodinux or any people who has the right to merge ⇑
[08:29:47]
<miro5001> > <@Alekswag:matrix.org> Noice 👍️ Only minor comments about sourcing the venv which feels unecessary + PATH tweaking
Yep, you were right
Here is the new PR https://github.com/YunoHost-Apps/pretix_ynh/pull/11
[08:29:53]
<florent[m]> Thanks tituspijean !
[08:44:23]
<tituspijean[m]> @grishk:matrix.org
About Java:
- penpot installs it one way: https://github.com/YunoHost-Apps/penpot_ynh/blob/d0350995bc8fd4849ad5bd9987cee3f45287fc5c/manifest.toml#L52
- airsonic simply adds "openjdk-17-jre" in the apt dependencies
> the "install directory" of /var/www/smithereen isn't an appropriate place to put a Java app
Why? I assume you assume all directories in /var/www are accessible by the www-data user, which is not the case.
If your app runs through a service and does not require NGINX to directly access its files, you can simply do a `chown $app:$app $install_dir -R` and appropriate chmod in the install/upgrade/restore scripts. :)
[16:25:40]
<Yunohost Git/Infra notifications> [stirling-pdf_ynh] fccl-vandoeuvre opened [issue #65](https://github.com/YunoHost-Apps/stirling-pdf_ynh/issues/65): Acces tessdata for Stirling
[21:56:25]
<Yunohost Git/Infra notifications> [apps] zeroheure opened [pull request #2986](https://github.com/YunoHost/apps/pull/2986): move Metabase from monitoring to db
[22:11:14]
<Yunohost Git/Infra notifications> [synapse_ynh] Josue-T closed [issue #541](https://github.com/YunoHost-Apps/synapse_ynh/issues/541): make selhosted ntfy server work with f-droid elementx
[22:11:16]
<Yunohost Git/Infra notifications> [synapse_ynh] Josue-T [commented](https://github.com/YunoHost-Apps/synapse_ynh/issues/541#issuecomment-2888605421) on [issue #541](https://github.com/YunoHost-Apps/synapse_ynh/issues/541) make selhosted ntfy server work with f-droid elementx: Hello,
It was already fixes by https://github.com/YunoHost-Apps/synapse_ynh/pull/540
[22:11:37]
<Yunohost Git/Infra notifications> [synapse_ynh] Josue-T labeled duplicate on [issue #541](https://github.com/YunoHost-Apps/synapse_ynh/issues/541): make selhosted ntfy server work with f-droid elementx
[22:12:10]
<Yunohost Git/Infra notifications> [synapse_ynh] Josue-T labeled feature on [issue #541](https://github.com/YunoHost-Apps/synapse_ynh/issues/541): make selhosted ntfy server work with f-droid elementx
[22:22:38]
<Yunohost Git/Infra notifications> Autoupdater just ran, here are the results:
- 43 pending update PRs
- 9 new apps PRs
- 3 failed apps updates: homebox, khatru-pyramid, swingmusic
See the full log here: https://paste.yunohost.org/raw/yomajovomi
Autoupdate dashboard: https://apps.yunohost.org/dash?filter=autoupdate