Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      request #39020 Access Tuleap database
    Actions
    Infos
    #39020
    Mehdi Essaid (essaid37)
    2024-08-09 10:28
    2024-08-08 09:57
    40708
    Details
    Access Tuleap database

    Hi, I would like to make my own reports, I exposed then 3306 port of mysql container so I'm able to connect to the "tuleap" database but I find it with some tables and almost all are empty. I can't see any us/bug/sprint/etc... I must be missing something, could you advise please ? Thank you very much,

    Bonjour, Je voudrais faire mes propres états à partir de la base de donnée de tuleap, mais malgré une connexion réussie, je ne vois aucune donnée dans les tables. Pourriez-vous m'aider à trouver où sont enregistrées ces données ? Merci beaucoup,

    Empty
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Closed
    2024-08-08
    Attachments
    Artifact links
    Empty
    Empty
    References
    References list is empty
    Display settings

    Follow-ups

    User avatar
    Mehdi Essaid (essaid37)2024-08-09 10:28

    Hi, May I bother you another time, I have a localhost tuleap instance and I created a X-Auth-AccessKey token, but when I try to make a GET or a POST it always returns me a "404 page not found". Could you advise please ?

    User avatar
    Thomas Gerbet (tgerbet)2024-08-08 16:55

    The issue stays the same, you only excluded the possibility of breaking the app if your setup is correct and you ensure your queries are performant enough to not put an extra load on the DB and DoS it.

    It still breaks the Tuleap permission model and there is still no guarantee on the data model (aka things can change without notice between versions). It is still not advised.

    User avatar
    Mehdi Essaid (essaid37)2024-08-08 16:45

    Hi, What about if I add an user which have only SELECT privileges ? I would like to use ODBC driver, and I checked that with such a user there is no alteration of the database possible.

    User avatar
    Thomas Gerbet (tgerbet)2024-08-08 16:00

    Hello,

    We strongly advise against querying and manipulating the DB directly. It breaks the permission model, there is no guarantee on the data model and incorrect changes might break the app.

    The programmatically interact with data stored into a Tuleap instance the REST API should be used: https://docs.tuleap.org/user-guide/integration/rest.html

    • Status changed from New to Closed
    • Close date set to 2024-08-08
    User avatar
    Mehdi Essaid (essaid37)2024-08-08 14:49

    Sorry I did not noticed that I was applying a filter on my connection in DBeaver !