Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

MariaDB Addon

Scheduled Pinned Locked Moved Feature Requests
3 Posts 2 Posters 79 Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • njN Offline
    njN Offline
    nj
    wrote on last edited by nj
    #1

    Some apps like ERPNext are only optimized for MariaDB and use MariaDB specific features. Slowly MariaDB is getting incompatible with MySQL by adding features like custom sequences not available in MySQL.

    From a Cloudron dev’s POV, adding MariaDB as an addon is a trivial task because MySQL is already there. Please add MariaDB as an addon. Thank you!

    Founder & OpenSource Lover. My Cloudron Apps

    girishG 1 Reply Last reply
    6
  • girishG Offline
    girishG Offline
    girish Staff
    replied to nj on last edited by
    #2

    @nj Thanks for all the hard work on ERPNext - https://forum.cloudron.io/topic/1228/erpnext-cost-effective-erp-solution/ (for others to follow). My understanding is that the app will still need to be an "admin" is it? With the flexibility to create multiple databases.

    We had phabricator which wanted similar support. MySQL addon supports this via multipleDatabases flag . Is this enough ?

    njN 1 Reply Last reply
    1
  • njN Offline
    njN Offline
    nj
    replied to girish on last edited by nj
    #3

    @girish I have figured out a solution that doesn’t require admin permissions to ERPNext. It’s just that they use MariaDB specific commands here and there. That’s why MySQL addon is not useful at all.

    Multiple databases works kinda fine but needs patching the source because ERPNext likes to use the same value for db-user and db-name; in fact there’s no way to give it the db-user. The name of the database is itself is considered username.

    While building this addon, I would recommend setting the user’s name and database the same - ie. without prepending the same string with ‘db’ or ‘user’

    Multiple databases isn’t required as ERPNext doesn’t work really well as a multi-site ERP anyway.

    Founder & OpenSource Lover. My Cloudron Apps

    1 Reply Last reply
    2

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.