Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 01:54
    MarcelBolten synchronize #3890
  • 01:54

    MarcelBolten on marcel-sort-icons-tabular-show-mode

    keep search input (#3891) * ke… allow null value for fullname i… use twig for feeding extended t… and 74 more (compare)

  • 00:19
    MarcelBolten commented #3852
  • Dec 01 23:55
    NicolasCARPi labeled #3954
  • Dec 01 23:55

    NicolasCARPi on hypernext

    adjust comment in api controlle… (compare)

  • Dec 01 23:51

    NicolasCARPi on hypernext

    fix issue with api query parame… (compare)

  • Dec 01 23:00
    NicolasCARPi commented #3954
  • Dec 01 22:55
    jat255 commented #3954
  • Dec 01 22:51
    NicolasCARPi commented #3954
  • Dec 01 22:43
    jat255 commented #3954
  • Dec 01 22:42
    NicolasCARPi labeled #3954
  • Dec 01 22:42
    NicolasCARPi labeled #3954
  • Dec 01 22:40
    NicolasCARPi commented #3954
  • Dec 01 22:33
    jat255 commented #3954
  • Dec 01 22:33
    jat255 commented #3954
  • Dec 01 22:31
    jat255 commented #3954
  • Dec 01 22:25

    NicolasCARPi on ird

    add comment on SITE_URL descrip… Merge branch 'hypernext' into i… (compare)

  • Dec 01 22:25
    jat255 commented #3954
  • Dec 01 22:25

    NicolasCARPi on ird

    fix deadline removal on steps use PDO::FETCH_COLUMN instead o… fix incorrect response when try… and 11 more (compare)

  • Dec 01 22:25
    jat255 commented #3954
Nicolas CARPi
@NicolasCARPi
(and added it later)
alexander-haller
@alexander-haller

it allows deleting a lot of old ugly working code and replace it with fancy buggy code ^^

:-)

Nicolas CARPi
@NicolasCARPi
current commit: 30 files changed, 436 insertions(+), 489 deletions(-)
as long as there are less lines of code at the end of the day I consider this a win
using the public api for internal stuff will be a game changer!
it's also a PITA, basically a superposition of both states
Nicolas CARPi
@NicolasCARPi
@alexander-haller damn users wanting to use windows!!! ;)
we need to show them the light!
alexander-haller
@alexander-haller
:smile: :+1:
Nicolas CARPi
@NicolasCARPi
this could be cool to add: https://github.com/staabm/phpstan-dba
BTW: current state of the APIV2 branch vs hypernext: 243 files changed, 4264 insertions(+), 6300 deletions(-)
nmontua
@nmontua
I have a bit of a Problem using Borgbackup: everything appears to be configured correctly, no error in the terminal or anything. Borg list also shows me that I do have a backup. It is just that elabctl backup only creates the SQLdump but not the uploaded files zip archive anymore :(. Or does the backup process word fundamentally different now?
alexander-haller
@alexander-haller
@nmontua your second guess - backup process works different now. It uses inkremental backups with borg instead of full backups with zips.
alexander-haller
@alexander-haller
just verify that the borg backups contain your newly uploaded files and you should be good
nmontua
@nmontua
@alexander-haller Thank you for reassuring me. I guess I will have to familiarize myself with borg a little better. If the Elabftw docs could reflect the changes in more detail, it would be greatly appreciated. Incremental backups are a great feature though!
paullysa
@paullysa
Hi :) I've heard that you're working on a new API version. Will it be possible to change next_step and locked status of items and add them to blockchain via REST? Kind regards
Nicolas CARPi
@NicolasCARPi
@paullysa yes. You can PATCH api/v2/experiments/257/steps/53 with in the request body an action: finish to toggle the finished step of a step. You can PATCH /items/432 with an action "Lock" to toggle lock and you can PATCH with an action:bloxberg to send it to blockchain. Basically the WEB UI is now using the api directly, so for 99% of actions that can be done through the web interface, they can also be done through the REST API because it's using the same endpoint ;)
paullysa
@paullysa
sounds great, thank you for the quick reply!
trineldave
@trineldave
Hello everyone, I have installed on local server elabftw, also I have to point certificate path with change line /ssl in YAML. The tutorial notice to elabctl restart, I must to stop container before or just restart while container running is enough to take account of modifications ? thanks a lot , i'm not expert in docker ;)
Nicolas CARPi
@NicolasCARPi
@trineldave elabctl restart will take care of stopping containers for you, no worries.
mbqb
@mbqb
Hi everyone! I try to set up eLab for a research lab with different sites. We would like to share some database entries between sites (which means we want to link the same database entry in experiements on each site). At the moment we decided to design a site as a 'team'.
Now it's possible to see details of attached database entries - but it's neither possible to see the database entries from the other team in the database section nor to link them to a an experiment.
Is this a general design decission or did I do something wrong in the setup?
Nicolas CARPi
@NicolasCARPi
Users need to check the box in ucp to see external items.
mbqb
@mbqb
@NicolasCARPi kudos!
trineldave
@trineldave
@NicolasCARPi OK thanks ;)
besselfunct
@besselfunct
Is it possible to get more detail on setting up SMTP in the install guide? I'm running into errors when I try to send the test email even though I've got SMTP2GO set up. I'm fairly certain that the issue is the Sender Address: field, but that's not covered in the install guide
(I'm sure this is probably assumed knowledge for most sysadmins but it's new to me)
There could also be issues related to the University firewall (in fact there are almost certainly issues related to that), but I'm not certain without a bit more detail on the expected config
Nicolas CARPi
@NicolasCARPi
@besselfunct your first step must be to look at the error in the log instead of guessing what could be the issue. See https://doc.elabftw.net/debug.html
sysopls
@sysopls
Hello all! I have a problem updating elab to the latest version.
We are running elabftw in Docker on ubuntu. I did the Update via elabctl update, and it was completet successfully. After that, we needed to add the SITE_URL variable to the docker yml, so that the WEB UI is working again.
The WEB UI shows, that we have to run the "bin/console db:update" command to finish the update, but when run this command on the ubuntu cli, we get the following permission denied error.
"1227 Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABlES_ADMIN privilege(s) for this operation.
Does anyone know whats going on here? Everything is set up with default config.
sakuraabcdef
@sakuraabcdef
I upgraded elabftw from ver 4.2.4 to 4.3.10 in Ubuntu 18.04. In this new version (not in old version), attached files with Japanese filename is downloaded as that a file with "". For example, the filename is changed to "protocol_.docx" (_ should be in Japanese). What's wrong? How can I solve the problem?
alexander-haller
@alexander-haller
@sysopls I think you run into this: https://github.com/elabftw/elabftw/discussions/3592#discussioncomment-3268365 try the solution and report back
2 replies
Nicolas CARPi
@NicolasCARPi
@sakuraabcdef this is because the filename fallback has to contain only ASCII characters. If you want to download with the original name you'll need to export as a zip. In the zip the file will have the correct characters.
@sakuraabcdef Wait, I figured out something. I was not using the filename fallback. Because only the fallback must be ASCII!!! So now the correct filename will be downloaded, and only the fallback filename is in ascii!
Nicolas CARPi
@NicolasCARPi
besselfunct
@besselfunct
Regarding the error logs. I've switched to trying to use the internal SMTP server that the university runs. I get the following (anonymized) error:
2022/09/12 16:57:05 [error] 133#133: *4796 FastCGI sent in stderr: "PHP message: [2022-09-12T18:57:05.871483+02:00] elabftw.ERROR: {"exception":"[object] (Symfony\\Component\\Mailer\\Exception\\TransportException(code: 0): Unable to connect with STARTTLS: stream_socket_enable_crypto(): Peer certificate CN=`*.pphosted.com' did not match expected CN=`relay-hostname' at /elabftw/vendor/symfony/mailer/Transport/Smtp/Stream/SocketStream.php:171)"} []" while reading response header from upstream, client: IPADDRESS, server: hostname, request: "POST /app/controllers/SysconfigAjaxController.php HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm.sock:", host: "hostname"
The SMTP server the university uses for this instance is supposed to allow unauthenticated mail sending from internal IP addresses
besselfunct
@besselfunct
From what I can see, elab is trying to verify the cert of the SMTP relay, but it's not getting the appropriate response. Is there a way to do an unauthenticated send?
Nicolas CARPi
@NicolasCARPi
I don't think so. It's bad practice anyway so this won't be fixed.
besselfunct
@besselfunct
OK. I'm investigating other options on this front within the University network. Hopefully I'll find something that works.
besselfunct
@besselfunct
I managed to figure something out. The University was able to make an authorized SMTP account just for the server
Nicolas CARPi
@NicolasCARPi
great :)
noblelabs1
@noblelabs1
Having trouble with letsencrypt and the yml config file. Now I get this error in the log:

2022/09/22 06:14:41 [emerg] 1462#1462: cannot load certificate "/ssl/live/lab-notebook.nobles.app/fullchain.pem": BIO_new_file() failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/ssl/live/lab-notebook.nobles.app/fullchain.pem','r') error:2006D080:BIO routines:BIO_new_file:no such file)
nginx: [emerg] cannot load certificate "/ssl/live/lab-notebook.nobles.app/fullchain.pem": BIO_new_file() failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/ssl/live/lab-notebook.nobles.app/fullchain.pem','r') error:2006D080:BIO routines:BIO_new_file:no such file)
2022/09/22 06:14:42 [emerg] 1464#1464: cannot load certificate "/ssl/live/lab-notebook.nobles.app/fullchain.pem": BIO_new_file() failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/ssl/live/lab-notebook.nobles.app/fullchain.pem','r') error:2006D080:BIO routines:BIO_new_file:no such file)

Please help
noblelabs1
@noblelabs1
here is the yml config line for the path
  • /etc/letsencrypt/live/lab-notebook.nobles.app:/ssl
@noblelabs1 use a bind mount /etc/letsencrypt:/ssl
besselfunct
@besselfunct
@NicolasCARPi I'm finally at a point where I want to start using the server and pushing data to it, but I'm running into some organizational snags.
  1. Is it possible to tag uploaded files? I see that we can make comments, but is it possible to associate a file with a given type of information, say a UV-Vis spectrum from instance?
  2. Does information have to be within the extra_fields parameter of a JSON in order to be searchable with quick search? We'd like to push metadata to the server for each experiment entry in such a way that it will be searchable, but it's not necessary that it be editable by the end user.
  3. Is there a way to run search queries from the python api? I checked the docs and it seems like there should be, but when I check the function definitions, the get_experiment() function doesn't seem to be able to take a search argument
Nicolas CARPi
@NicolasCARPi
@besselfunct
  1. no but it is an interesting idea.
  2. The quicksearch doesn't search in the metadata column. Searching JSON with mysql is not straightforward. Only on the search page you can search for key/value in extra_fields, and yes it needs to be in extra_fields.
  3. Yes, look at the search paramater in Query parameters https://doc.elabftw.net/api/#api-Entity-GetExperiment
besselfunct
@besselfunct
Hey @NicolasCARPi thanks for the response.
Regarding 1, it would make a lot of what I'm trying to do with elab a lot easier if this was implemented, but I think I might be able to find a workaround
  1. If you can't search JSON, is it possible to add our own mysql columns/data for a given experiment type?
  2. I've tried a couple of different syntax variations, but I still can't determine what's meant by the query parameters. Would you be able to provide a syntax example? I tried the following:
    exp.search("string") exp = manager.get_experiment(id=3, search="string") exp = manager.get_experiment(3, search="string")
Nicolas CARPi
@NicolasCARPi
  1. Absolutely not. Letting users mess the database structure is a recipe for disaster. The better approach would be to add the metadata in the searched columns, but that doesn't seem straightforward to do: https://stackoverflow.com/questions/56753870/mysql-full-text-search-on-extracted-json-column
  1. I'm not sure you can do it with elabapy. But it isn't difficult to bypass it and directly use requests lib to query the endpoint. After all, it really is just a simple GET request with the token as Authorization header.