Moodle Adminer

Maintained by Andreas Grabs

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/MariaDB, PostgreSQL, Oracle and MSSQL.

Free

Download for free

Supports Moodle 2.0-5.2 See all versions

Latest release: 2 months ago

Installations: 5840

Downloads (last 90 days): 1817

Frankenstyle name: local_adminer

Local plugins

Comments are no longer open for new posts. Existing comments remain available to read.

Boaz Neeman_Golan

16 January 2014

I tested it with version 2.6.0, it works okay

merrin fulton

24 September 2013

Under SQL Command, might it be possible to have the data saved as xml?

Andreas Grabs

13 June 2013

done

Best regards
Andreas

Randy Thornton

12 June 2013

Andreas,
This is working great on my 2.4+ site. When do you expect a version out for 2.5?

MIke Buchanon

4 June 2013

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

mark robinson

22 April 2013

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.

Andreas Grabs

16 March 2013

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

David Bezemer

16 March 2013

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????)

Andreas Grabs

9 March 2013

Hi Doug, I think so. I did some simple test and all looked fine.