[09:42:14]
<centralscrutinizer[m]> hi can someone help with manually editing synapse database, like suggested in this comment?
https://github.com/YunoHost-Apps/synapse-admin_ynh/pull/13#issuecomment-1114269702
[09:48:17]
<tituspijean> centralscrutinizer[m]: cf. https://github.com/YunoHost-Apps/synapse_ynh/blob/7a5a9cc4bf652e11c21389981a3419d82eb3f57b/README.md#set-user-as-admin
[10:16:14]
<Folât> https://forum.yunohost.org/t/jai-installe-synapse-mais-lun-des-services-coturn-synapse-ne-veut-pas-demarrer/21261
[10:16:36]
<Folât> My coturn-synapse won't start.
[10:33:12]
<centralscrutinizer> titus[m] @titus[m]:libera.chat: thanks, the command gives me this result tough:
could not change directory to "/home/admin": Permission denied
UPDATE 1
[10:42:32]
<Folât> centralscrutinizer: I'm not far enough with getting Synapse getting to work myself and have zero experience with psql, but I think I'm knowledgeable enough to can ask 'what can you see in the database itself'?
[10:44:40]
<Folât> Like the command
```
su --command="psql matrix_synapse" postgres <<< "UPDATE users SET admin = 1 WHERE name = '@user_to_be_admin:domain.tld'"
```
can be broken into parts..
```
su
psql matrix_synapse
???? "UPDATE users SET admin = 1 WHERE name = '@user_to_be_admin:domain.tld'"
```
[10:45:48]
<Folât> I would just type 'help' after `psql matrix_synapse` and then look at the commands available to me.
[10:46:00]
<Folât> I would just type `help` after `psql matrix_synapse` and then look at the commands available to me.
[10:58:37]
<tituspijean> > titus[m] @titus[m]:libera.chat: thanks, the command gives me this result tough:
> could not change directory to "/home/admin": Permission denied
> UPDATE 1
Folât is quite right. Though I'm guessing you were not running as root user?
[11:05:13]
<Folât> tituspijean: Any idea on my issue?
[11:06:30]
<centralscrutinizer[m]> > <@titus[m]:libera.chat> > <@centralscrutinizer:novababilonia.me> titus[m] @titus[m]:libera.chat: thanks, the command gives me this result tough:
> > could not change directory to "/home/admin": Permission denied
> > UPDATE 1
>
> Folât is quite right. Though I'm guessing you were not running as root user?
i wad logged in as admin
[11:06:42]
<tituspijean> No sorry. the problem has already been posted on the forum and my proposed fix is not working: https://github.com/YunoHost-Apps/synapse_ynh/pull/333
[11:07:02]
<centralscrutinizer[m]> and then i did sudo su
[11:07:17]
<tituspijean> Ah, Josué is proposing another fix: https://github.com/YunoHost-Apps/synapse_ynh/pull/335
[11:07:33]
<tituspijean> Folât: ^
[11:07:56]
<tituspijean> > <@centralscrutinizer[m]:libera.chat> and then i did sudo su
It looks like I'm missing a message here
[11:08:19]
<tituspijean> btw you should use the #yunohost:matrix.org room, not the one on libera.chat
[11:09:00]
<centralscrutinizer[m]> > <@titus[m]:libera.chat> btw you should use the #yunohost:matrix.org room, not the one on libera.chat
yeah i tried but it kicks me out if I leave thiis room
[11:09:41]
<Folât> centralscrutinizer[m]: sudo su how? `sudo su --command="psql matrix_synapse" postgres <<< "UPDATE users SET admin = 1 WHERE name = '@user_to_be_admin:domain.tld'"` ?
[11:09:49]
<Folât> centralscrutinizer[m]: sudo su how? `sudo su --command="psql matrix_synapse" postgres <<< "UPDATE users SET admin = 1 WHERE name = '@user_to_be_admin:domain.tld'"` <- like that ?
[11:10:13]
<centralscrutinizer[m]> > <@folaht[m]:libera.chat> * centralscrutinizer[m]: sudo su how? `sudo su --command="psql matrix_synapse" postgres <<< "UPDATE users SET admin = 1 WHERE name = '@user_to_be_admin:domain.tld'"` <- like that ?
no i ssh to my server as admin
[11:10:33]
<centralscrutinizer[m]> then sudo su to get root access
[11:10:48]
<Folât> okay
[11:11:34]
<centralscrutinizer[m]> and then `su --command="psql matrix_synapse" postgres <<< "UPDATE users SET admin = 1 WHERE name = '@user_to_be_admin:domain.tld'`
[11:11:40]
<Folât> And then after root access did you do this command? -> `psql matrix_synapse" postgres <<< "UPDATE users SET admin = 1 WHERE name = '@user_to_be_admin:domain.tld'`
[11:12:17]
<Folât> centralscrutinizer[m] You don't need to do `su --command` once you have root access
[11:13:39]
<Folât> centralscrutinizer[m] You don't need to do `su --command` once you have root access, although that shouldn't matter.
[11:15:17]
<centralscrutinizer[m]> i think i am just copying pasting a command with the wrong syntax
[11:15:58]
<Folât> centralscrutinizer[m] You don't need to do `su --command` once you have root access, although that shouldn't matter, because you'd just open and close another shell as root user.
[11:16:06]
<Folât> centralscrutinizer[m] You don't need to do `su --command` once you have root access, although that shouldn't matter, because you'd just open and close another shell as root user with that extra command.
[11:16:17]
<Folât> perhaps
[11:16:35]
<centralscrutinizer[m]> psql matrix_synapse postgres <<< "UPDATE users SET admin = 1 WHERE name = '@centralscrutinizer:novababilonia.me'"
[11:16:39]
<Folât> What happens when as root you do this?
[11:16:47]
<Folât> ```
psql matrix_synapse
help
```
[11:17:09]
<centralscrutinizer[m]> psql: error: FATAL: Peer authentication failed for user "postgres"
[11:19:00]
<centralscrutinizer[m]> > <@folaht[m]:libera.chat> ```
> psql matrix_synapse
> help
> ```
it asks me the root password
[11:19:21]
<Folât> Yeah, I'm doing the same thing at the moment on my end
[11:19:27]
<Folât> Same issue
[11:22:18]
<centralscrutinizer[m]> if instead I give the command with su from admin it asks me for root password, but doesn't give me time to write it
[11:25:45]
<Folât> I'm not getting into psql using any password
[11:27:48]
<Folât> Okay, I'm in!
[11:29:38]
<Folât> `sudo su - postgres`
[11:29:55]
<Folât> ```
sudo su - postgres
psql
```
[11:33:50]
<Folât> ```
sudo su - postgres
psql matrix_synapse
```
[11:35:53]
<Folât> ```
sudo su - postgres
psql matrix_synapse
select * from users;
```
[11:36:12]
<Folât> ```
sudo su - postgres
psql matrix_synapse
UPDATE users SET admin = 1 WHERE name = '@centralscrutinizer:novababilonia.me'
select * from users;
```
[11:36:27]
<Folât> ```
sudo su - postgres
psql matrix_synapse
update users set admin = 1 where name = '@centralscrutinizer:novababilonia.me'
select * from users;
```
[11:37:17]
<Folât> ```
sudo su - postgres
psql matrix_synapse
update users set admin = 1 where name = '@centralscrutinizer:novababilonia.me';
select * from users;
:q
\q
```
[11:38:52]
<Folât> The fourth line is to check if the third command line was carried out succesfully.
[11:39:30]
<Folât> ```
sudo su - postgres
psql matrix_synapse
select * from users;
:q
update users set admin = 1 where name = '@centralscrutinizer:novababilonia.me';
select * from users;
:q
\q
```
[11:39:45]
<Folât> The sxith line is to check if the fifth command line was carried out succesfully.
[11:40:22]
<Folât> And the third line is to check if there isn't already an entry in there.
[11:41:02]
<Folât> The third and sxith line is to check if the fifth command line was carried out succesfully.
[11:44:22]
<Folât> tituspijean: I don't think issue 333/335 is the same error as the one I'm having. I don't have a `status=31/SYS `failure. I have a status=217/USER failure.
[11:47:29]
<tituspijean> Folât: does `/usr/bin/turnserver` exist in your system?
[11:47:41]
<Folât> tituspijean: Yes
[11:49:53]
<tituspijean> what's the output of `id turnserver` ?
[11:50:24]
<Folât> ```
$ id turnserver
id: ‘turnserver’: no such user
```
[11:50:33]
<tituspijean> ha-ha.gif
[11:51:12]
<Folât> What's so funny?
[11:51:55]
<tituspijean> that was more like "found the issue" moment :)
[11:52:57]
<Folât> Oh, I get it now. How would the turnserver id be created though?
[11:53:11]
<Folât> Was that meant to be created automatically, manually?
[11:54:48]
<Folât> I also notice that there's no `/etc/turnserver.conf`. Sholud I have one?
[11:54:51]
<Folât> I also notice that there's no `/etc/turnserver.conf`. Should I have one?
[11:54:54]
<tituspijean> Somehow that user does not exist anymore
[11:55:42]
<tituspijean> Or was never installed? Is your Synapse instance recent, can it be removed?
[11:56:00]
<tituspijean> If it's recent, please share the install log
[11:57:32]
<Folât> Yes, it's recent.
[11:59:05]
<Folât> https://paste.yunohost.org/raw/emevulonof
[12:00:02]
<Folât> I get the feeling that I know what happened.
[12:00:22]
<tituspijean> ```
2022-09-15 06:17:56,406: DEBUG - + adduser turnserver ssl-cert
2022-09-15 06:17:56,662: DEBUG - L'utilisateur « turnserver » appartient déjà au groupe « ssl-cert ».
```
[12:00:24]
<tituspijean> so weird
[12:00:39]
<Folât> I will reinstall synapse.
[12:00:40]
<tituspijean> please explicitate then 😅
[12:00:58]
<tituspijean> yeah I was about to suggest that. but use Josué's branch
[12:01:20]
<tituspijean> `sudo yunohost app install https://github.com/YunoHost-Apps/synapse_ynh/tree/fix_turnserver -f`
[12:01:30]
<Folât> Like I said in the forum, I tried using XMPP + Coturn to get audio/video.
[12:02:02]
<Folât> I then said that I deinstalled coturn and installed synapse.
[12:02:19]
<Folât> But it looks like I installed synapse first and then deinstalled coturn.
[12:02:39]
<Folât> Which could have turnserver deleted.
[12:02:41]
<tituspijean> Ha I see. Indeed that would have broken the instance
[12:03:03]
<centralscrutinizer[m]> mnbm.y
[12:03:23]
<Folât> I don't need to install the seperate coturn package for synapse to work correct?
[12:03:59]
<tituspijean> Folât: yes, it's included
[12:04:50]
<tituspijean> Folât: please don't 😅
[12:05:12]
<Folât> I just don't deinstall it after synapse is installed, but before instead. 😅
[12:25:27]
<Folât> tituspijean: Now I do have the 31/SYS issue.
[12:26:16]
<tituspijean> Folât: logs? :)
[12:26:22]
<dragon> Anyone tried using the ansible playbook to setup matrix, synapse etc and make it work with yunohost?
[12:26:59]
<dragon> Would have to configure the yunohost server config to allow for that. That's probably the most full fledged way to have matrix running on your server
[12:27:30]
<Folât> https://paste.yunohost.org/rozehidopa
[12:27:31]
<tituspijean> dragon: it's pretty advanced stuff for YunoHost. there's a thread about ansible on the forum.
[12:28:02]
<dragon> Is it a thread for ansible in general? Or the matrix ansible playbook?
[12:28:17]
<dragon> I'm talking about this:
https://github.com/spantaleev/matrix-docker-ansible-deploy
[12:28:50]
<dragon> Also, I saw a package which allowed deploying docker containers with yunohost but that's from 2017. Too outdated.
[12:28:53]
<tituspijean> Ah I see. Is it related to the fact you are using Beeper?
[12:29:07]
<dragon> > <@titus:pijean.ovh> Ah I see. Is it related to the fact you are using Beeper?
What?
[12:29:27]
<dragon> Well, I do use beeper but I'd like to have my own matrix server
[12:30:02]
<tituspijean> It's to better understand the context. Is this you? https://forum.yunohost.org/t/docker-docker-containers-and-management-in-yunohost/678/16?u=tituspijean
[12:30:25]
<dragon> No, that is not me :P
[12:30:31]
<dragon> I haven't yet posted on the forum
[12:30:50]
<tituspijean> well, good coincidence you drop by today :)
[12:31:07]
<tituspijean> basically YunoHost tries to avoid containers. Though I do agree that for complex setups there may be an interest
[12:31:50]
<dragon> Yeah, the matrix setup kinda becomes complex if one wants to install bridges, etc and the ansible playbook makes it a breeze to manage stuff
[12:32:25]
<tituspijean> Right now we have separates apps for bridges to connect to Synapse app
[12:32:54]
<dragon> Yup, but all the bridges are not present. For example, instagram or skype. Though could package them and make them work with yuno
[12:33:16]
<tituspijean> > <@dragon:beeper.com> I'm talking about this:
> https://github.com/spantaleev/matrix-docker-ansible-deploy
so regarding your initial question: most likely no, we did not try deploying that playbook, Ansible itself is quite new/little developed for YunoHost
[12:34:04]
<centralscrutinizer[m]> i am trying to enter the matrix room i get this error:
[12:34:04]
<dragon> Hmm, okay. I'll give it a shot and see if I can make it work. Where does yunohost store the SSL certificates?
[12:34:06]
<tituspijean> Instagram one has been started last month, Skype I don't think so
[12:34:33]
<dragon> Btw, does installing synapse automatically also setup coturn on the server?
[12:35:04]
<tituspijean> dragon: `/etc/yunohost/certs`
[12:35:08]
<tituspijean> yes
[12:35:21]
<tituspijean> that's not the case for dendrite though
[12:36:04]
<dragon> Cool, I could then probably just setup synapse and then use the playbook to install and maintain bridges. That would be an easier way.
[12:36:34]
<dragon> > <@titus:pijean.ovh> dragon: `/etc/yunohost/certs`
Great, though this won't be required if I install the yunohost synapse package
[12:37:03]
<dragon> Really want to stick with yuno though, the community is always super helpful and responsive whenever I've reached out here!
[12:37:15]
<dragon> Thanks for your help tituspijean
[12:38:49]
<tituspijean> You're welcome! Do share your findings, even if you fail (hopefully not! 🤞)!
[12:39:21]
<dragon> Haha, fingers crossed
[12:40:05]
<dragon> Btw, the bridges are missing dependencies for enabling e2b
[12:47:20]
<tituspijean> e2e?
[12:47:31]
<dragon> Yeah, end to bridge
[12:47:41]
<tituspijean> It's been quite some time I looked into the bridges... I thought they couldn't handle encryption
[12:47:46]
<tituspijean> that's cool though if they can now
[12:48:05]
<dragon> They can, most of the mautrix bridges at least
[12:48:10]
<tituspijean> (I guess they still can't handle e2e :) )
[12:49:08]
<dragon> Hmm, I guess. Haven't looked into the details and the differences between e2b and e2e
[14:01:38]
<dragon> Anyone have a working setup of seafile and seafdav?
[14:01:53]
<dragon> I can see that yunohost creates the correct configuration but the path does not work. Maybe the port needs to be opened I guess
[14:03:21]
<dragon> I dunno, everything seems to be alright. Nginx config, the seafile config and yet the <domain>/seafdav just does not load at all
[14:22:19]
<tituspijean> OK thanks! Quite simple :)
I will try to integrate it in a next release
[14:22:56]
<dragon> Any idea on how to debug seafile? :P
[14:32:03]
<abwmoatazabwmymy> ل
[14:45:22]
<beelu> Bonjour, j'ai un soucis d'envoi de fichiers ou d'image avec XMPP. Dans le diagnostic, il y a à priori un pb avec le DNS que je n'arrive pas à corriger:
La valeur actuelle est : domain.ynh.fr.ynh.fr.
La valeur attendue est : domain.ynh.fr.
[14:47:02]
<beelu> À savoir que j'y connais rien en conf de domaine 🙃
[14:47:03]
<beelu> C'est arrivé depuis la migration. L'envoi de message se passe bien curieusement
[14:53:29]
<beelu> D'ailleurs est-ce bien la source du pb ?
[14:56:08]
<mose> domain.ynh.fr.ynh.fr ca ressemble a se qui se passe quand on oublie d'ajouter le point final dans la destination d'un CNAME
[15:08:01]
<beelu> J'ai tenté "yunohost dyndns update --force" , mais pas de changement
[15:35:17]
<tituspijean> beelu: non c'est un bug du diagnostic je crois. Ça a été évoqué sur le forum et dans le dépôt YunoHost/issues je crois
[15:40:29]
<beelu> Ok merci tituspijean:
Rien à voir avec mon problème d'envoi de fichiers ou d'images du coup j'imagine ?
[15:59:05]
<centralscrutinizer[m]> folaht[m]: sorry but despite your efforts Istill can't set my user as admin...
I got this far:
sudo su - postgres
psql matrix_synapse
and now I have this prompt:
matrix_synapse-#
[16:00:26]
<Folât> centralscrutinizer[m]:
```
select \* from users;
:q
```
[16:00:34]
<Folât> centralscrutinizer[m]:
```
select * from users;
:q
```
[16:01:01]
<Folât> centralscrutinizer[m]:
```
select * from users;
:q
```
What happens when you do that?
[16:01:16]
<centralscrutinizer[m]> do I have to type: select * ?
[16:01:33]
<Folât> centralscrutinizer[m]:
You're in the prompt, that's good.
```
select * from users;
:q
```
What happens when you do that?
[16:01:53]
<Folât> Yes, you have to type `select * from users;`
[16:02:10]
<Folât> You should be seeing a table when you do that.
[16:02:19]
<centralscrutinizer[m]> ok
[16:02:22]
<Folât> Empty or not.
[16:02:35]
<Folât> `:q` is to get out of the table view
[16:03:47]
<Folât> `update users set admin = 1 where name = '@centralscrutinizer:novababilonia.me';` is to set the user as admin in the users table, which should show in the users table when you do `select * from users;` again.
[16:05:40]
<centralscrutinizer[m]> ok so that ; was indeed important
[16:06:39]
<centralscrutinizer[m]> and the asterix * as well
[16:09:15]
<centralscrutinizer[m]> so aftet exiting the table with q
i am back at the previous prompt and need to type:
* update users set admin = 1 where name = '@centralscrutinizer:nivababilonia.me';
[16:09:35]
<centralscrutinizer[m]> fck ok let me try
[16:10:15]
<centralscrutinizer[m]> * so aftet exiting the table with q
i am back at the previous prompt and need to type:
( * update users set admin = 1 where name = '@centralscrutinizer:nivababilonia.me'; )
[16:15:26]
<centralscrutinizer[m]> no ok the (*) is not right
[16:17:44]
<centralscrutinizer[m]> matrix_synapse=# update users set admin = 1 where name = '@centralscrutinizer:novababilonia.me';
UPDATE 1
[16:18:08]
<centralscrutinizer[m]> i got this UPDATE 1 as result
[16:18:21]
<aedmunds[m]> Hi Everyone, I'm trying to get synapse installed, but I am getting the following error and I am not sure what to try next.
https://paste.yunohost.org/raw/ufizipiguk
[16:18:58]
<centralscrutinizer[m]> do I need to reload synapse?
[16:49:18]
<Lithi> Bonsoir tout le monde ! Je me permets de vous déranger pour avoir un petit coup de main suite à un soucis lors d'un changement de config vpn : j'ai changé de fournisseur et après avoir envoyé le nouveau fichier .ovpn + id + mdp le vpn n'arrive plus à démarrer...
[16:49:34]
<Lithi> au niveau des logs j'ai ceci comme retour : https://paste.yunohost.org/raw/iwalodujom
[18:10:20]
<shahrul> Hi. any step to do before upgrading to version 11?
[18:11:12]
<Folât> shahrul: Back up your stuff, unless you can miss it.
[18:19:00]
<shahrul> ah okey :)
[18:28:24]
<shahrul> https://pastebin.mozilla.org/B7XeYmpj
[18:33:01]
<Justinas> > <@folaht:matrix.org> ```
> sudo su - postgres
> psql matrix_synapse
> select * from users;
> :q
> update users set admin = 1 where name = '@centralscrutinizer:novababilonia.me';
> select * from users;
> :q
> \q
> ```
Thank you, this helped!
[18:34:04]
<Folât> shahrul: Post that issue on the forum.
[18:50:56]
<Folât> shahrul: Can you try this -> https://forum.yunohost.org/t/migration-to-11-x-failed-migration-0021-migrate-to-bullseye-did-not-complete-aborting-error-failed-to-reinstall-mariadb-common/20970/3
[19:03:31]
<shahrul> https://paste.yunohost.org/raw/masoyuzijo
[19:03:35]
<shahrul> seem same
[19:03:59]
<shahrul> on my system, seem dont have /etc/php/7.4/fpm/pool.d/firefly-iii.conf
[19:04:31]
<Folât> Ah
[19:55:50]
<Justinas> finally, matrix chat works on my yunohost! However, audio/video does not. I opened all ports (two for turn server + range for calls) in yunohost and router. Where do I even start troubleshooting then?
[20:37:23]
<Folât> Justinas: There's an update?
[20:38:35]
<Folât> Looks like you don't have the same issue as mine
[20:39:36]
<Justinas> update for synapse? I just installed it today :)
I had a headache logging in via synapse-admin, but managed to do it via database
[20:39:53]
<Folât> On yunohost 11?
[20:40:01]
<Folât> I'll try reinstalling then.
[20:40:07]
<Justinas> nope, 10
[20:40:24]
<Justinas> are you still failing to login?
[20:40:24]
<Folât> Oh, on Debian 10.
[20:40:28]
<Folât> So yunohost 4.
[20:40:50]
<Folât> No, coturn-synapse doesn't run on yunohost 11.
[20:41:21]
<Justinas> oh, then good that my yh update failed (non critically) :)
[20:42:23]
<Folât> The coturn-synapse bug just got fixed, but the code is still in testing phase.
[20:42:31]
<Folât> The coturn-synapse bug just got fixed, but the code is still in testing repository.
[20:43:03]
<Folât> I was hoping it was already in production.
[20:43:15]
<Folât> I guess I'll have to wait a few days.
[22:04:51]
<miro5001[m]> Salut tout le monde,
J'aurais besoin d'une suggestion pour une plate-forme.
Problème : un ami est en train de préparer son CV universitaire (une centaine de pages au format papier) mais la fac voudrait aussi une version CD 💿 😜. Il m'a demandé s'il y avait une plate-forme qui pourrait faire l' affaire. Genre, la page d'accueil avec sa photo les plus grandes lignes de sa carrière, un menu avec sous-menus des différentes catégories de ses travaux et activités, la possibilité d'insérer des pdfs, des images, des vidéos.
J'ai pensé faire un cms puis utiliser httrack pour avoir le contenu html pour pouvoir être consultable sur n'importe quel machine (pour l'instant ça ne doit pas être mis en ligne), mais c'est pas top comme solution. J'ai aussi pensé à un générateur de site statique genre hugo, mais ça dépasse ses compétences et je devrais tout faire moi même.
Si vous avez des idées n'hésitez pas😉
[22:07:23]
<tituspijean> > une version CD
[22:07:27]
<tituspijean> https://aria.im/_matrix/media/v1/download/pijean.ovh/ccce1a7a59442571a483d19821abec164646c43f88616f0be9df63880f81cbd2
[22:08:08]
<tituspijean> (for IRC people, I posted a what_year_is_this.jpg)