Moodle Adminer

General plugins (Local) ::: local_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.

Latest release: 5 months

4254 sites

2k downloads

111 fans

Current versions available: 10

Download

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
MSSQL

Here are some of the key-features:

you can define trigger
you can change the order of fields
you can easy create or alter views
you can create stored procedures
if you rename a database so the database is altered and not copied like phpMyAdmin it does
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 call the notification-page. After the installation you will find a new link "Moodle Adminer" below "Site administration / Server".

Useful links

Source control URL

Bug tracker

Screenshots

Contributors

Andreas Grabs (Lead maintainer)

View other contributions

Please login to view contributors details and/or to contact them

Awards

Automated testing support

Early bird 4.1

Early bird 4.2

Early bird 4.3

Comments

Adam Zapletal
Fri, 13 Jan 2012, 11:24 PM
Thanks for this plugin. Are you hosting it on Github or somewhere similar?
Martin Dougiamas
Thu, 19 Apr 2012, 1:09 PM
Awesome, Andreas - thanks! Bye bye phpmyadmin.
Luis de Vasconcelos
Mon, 23 July 2012, 8:15 PM
New plugin adminer to manage your database
http://moodle.org/mod/forum/discuss.php?d=190265
Séverin Terrier
Mon, 17 Sept 2012, 5:22 PM
Is also works well with Moodle 2.3
Germán Valero
Fri, 28 Sept 2012, 9:27 AM
And it works in many languages too!
Wouldn't it be worth considering for addition to Moodle core ?
Doug Loomer
Tue, 5 Mar 2013, 2:40 PM
Does this work in 2.4?
Andreas Grabs
Sat, 9 Mar 2013, 11:18 PM
Hi Doug, I think so. I did some simple test and all looked fine.
David Bezemer
Sun, 17 Mar 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????)
Andreas Grabs
Sun, 17 Mar 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
mark robinson
Mon, 22 Apr 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.
MIke Buchanon
Wed, 5 June 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