Select Moodle version:

General plugins (Local): Moodle Adminer

local_adminer
This plugin is based on the great tool adminer. The main advantage of this plugin is, it can handle different types of database. So it works with MySQL, PostgreSQL, Oracle and MSSQL.
Maintained by: Picture of Andreas Grabs Andreas Grabs
for Moodle
2.0, 2.1, 2.2, 2.3
This plugin is based on the great tool adminer. The main advantage of this plugin is, it can handle different types of database. So it works with MySQL, PostgreSQL, Oracle and MSSQL. Here are some of the key-features: 1) you can define trigger 2) you can change the order of fields 3) you can easy create or alter views 4) you can create stored procedures 5) if you rename a database so the database is altered and not copied like phpMyAdmin it does 6) you can define foreign key with referential integrity To install it you only have to copy it into the "local" folder in your moodle-installation and running the notification-page. After the installation you will find a new link "Moodle Adminer" below "Site administration -> Server".

Screenshots

screenshot
screenshot
screenshot
screenshot
screenshot
screenshot
screenshot
screenshot

Contributors

Picture of Andreas Grabs
Andreas Grabs (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of Adam Zapletal
    Fri, Jan 13, 2012, 11:24 PM
    Thanks for this plugin. Are you hosting it on Github or somewhere similar?
  • Martin in black and white
    Thu, Apr 19, 2012, 1:09 PM
    Awesome, Andreas - thanks! Bye bye phpmyadmin. smile
  • Sketch...
    Mon, Jul 23, 2012, 8:15 PM
    New plugin adminer to manage your database
    http://moodle.org/mod/forum/discuss.php?d=190265
  • C'est moi :-)
    Mon, Sep 17, 2012, 5:22 PM
    Is also works well with Moodle 2.3 smile
  • Picture of German Valero
    Fri, Sep 28, 2012, 9:27 AM
    And it works in many languages too! smile
    Wouldn't it be worth considering for addition to Moodle core ?
  • Picture of Doug Loomer
    Tue, Mar 5, 2013, 2:40 PM
    Does this work in 2.4?
  • Picture of Andreas Grabs
    Sat, Mar 9, 2013, 11:18 PM
    Hi Doug, I think so. I did some simple test and all looked fine.
  • Picture of David Bezemer
    Sun, Mar 17, 2013, 6:57 AM
    The potential security hole in this is huge, which is why I am very hesitant to use this. If any role elevation or exploit is found in this, everything is accessible. PHPMyAdmin has much more possibilities to secure it, including special logins, specific apache config files and multifactor authentication methods. This plugin doesnt even require full admin role, it only requires the modify site permission, which means that role assignment can potentially expose your entire database.

    I think this plugin would need quite a bit more security measures (like additionally/separate login with db credentials) and what I am definitely not confident of, is that this is XSS safe. (what happens if I create a URL that will invoke the command to drop the database????)
  • Picture of Andreas Grabs
    Sun, Mar 17, 2013, 7:28 AM
    Hi David, I can not follow your minds. Adminer does not give you more access rights than phpmyadmin. Adminer has just like phpmyadmin the same right as the user account what is defined for. You are right that this plug-in needs the capability "moodle/site:config" for the system context. But I see no problem with this. I never said you should use this plug-in in all cases. If you are admin of the webspace and admin of the moodle installation so this should be ok. If you have multiple admins and a shared database account you should think about this.
    Can you tell me where you get the information that the currently used Adminer is not xss save?.
    Best regards
    Andreas
  • Picture of mark robinson
    Mon, Apr 22, 2013, 8:18 PM

    I use a free tool Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview at the moment. Does everything you need, and does it very well.
  • Picture of MIke Buchanon
    Wed, Jun 5, 2013, 1:15 AM
    For some reason, we get 'Session expired, please login again.' no matter if we're using the database or files for sessions. Everything else works in our instances and sessions are getting created appropriately by Apache, so, I'm at a loss for why this wouldn't work. Any thoughts? I'd really like to use this Plugin if possible. Thanks!
    /mtb
  • Randy Thornton
    Thu, Jun 13, 2013, 5:57 AM
    Andreas,

    This is working great on my 2.4+ site. When do you expect a version out for 2.5?
  • Picture of Andreas Grabs
    Thu, Jun 13, 2013, 7:51 PM
    done smile
    Best regards
    Andreas
  • Picture of merrin bennett
    Tue, Sep 24, 2013, 2:01 PM
    Under SQL Command, might it be possible to have the data saved as xml?
  • Picture of Boaz Neeman_Golan
    Thu, Jan 16, 2014, 9:00 PM
    I tested it with version 2.6.0, it works okay
Please login to post comments