General plugins (Local): Moodle Adminer

local_adminer
Maintained by Picture of Andreas Grabs 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, PostgreSQL, Oracle and MSSQL.
1074 sites
634 downloads
23 fans
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 #0
Screenshot #1
Screenshot #2
Screenshot #3
Screenshot #4
Screenshot #5
Screenshot #6
Screenshot #7

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 Boaz Neeman_Golan
    Thu, 16 Jan 2014, 9:00 PM
    I tested it with version 2.6.0, it works okay
  • Picture of Matthew Koelling
    Tue, 1 Jul 2014, 7:29 AM
    Any plans to release this for 2.7
  • Picture of Rusty Hatchett
    Thu, 24 Jul 2014, 9:40 PM
    We have been using it with 2.7 since upgrade from 2.6
  • moi!!! it is what is is...
    Mon, 15 Sep 2014, 8:48 PM
    Andreas, what an excellent tool and can be installed easily. I like that it can only see the database of the Moodle that it is installed in, I don't want people accessing the other Moodles I have on the server, nor the wikimedia, or wordpress and so on...
    I must admit a security issue did come up, but I am hoping it can be fixed so that only the Admin User has rights to access it, if it can be done that way. If it can then I am going to have a discussion with a number of people about how useful it can be. I am thinking here of just how much easier it will be to restore deleted users. Thank you.
  • Picture of Andreas Grabs
    Wed, 19 Nov 2014, 7:01 AM
    Andreas Grabs
    Mi, 19. Nov 2014, 00:01
    Sorry for the long waiting. Now I updated the adminer plugin. The moodle part has no big changes. The adminer now is based on 4.1.0
  • Picture of Orestes Mas
    Mon, 29 Dec 2014, 6:32 AM
    Using this plugin directly from GitHub is awkward, because at present the 'master' branch is empty, and the other branches are such that the code is in local/adminer/xxxxxx. So, if you clone this repo into /local, the adminer is wrongly installed at /local/local/adminer.

    Please check and fix it if appropiate.

    Thanks.
  • Picture of Andreas Grabs
    Mon, 29 Dec 2014, 8:33 AM
    Hi Orestes, I am sorry but submodules are not suitable in the way we work.
    Yet you can simple integrate it in your repository by merging it. Use the steps below:
    1. Go into your moodle repository
    2. # git remote add adminer git://github.com/grabs/moodle-local_adminer.git
    3. # git fetch adminer
    4. # git merge adminer/v_27
    That's it.
    Best regards
    Andreas
  • C'est moi :-)
    Wed, 27 May 2015, 10:56 PM
    Hi Andrea,

    Do you plan to make Adminer officially compatible with Moodle 2.9, so that it can be installed/upgraded via the build in installer?
  • Picture of Andreas Grabs
    Thu, 28 May 2015, 4:30 AM
    Hi Séverin, thanks for reminding me. Now you can find a 2.9 version on this place.
    Best regards Andreas
  • C'est moi :-)
    Mon, 1 Jun 2015, 5:37 PM
    Yes ! Thanks Andreas for the really quick update smile
  • Picture of Christoph Ruda
    Fri, 22 Jan 2016, 11:57 PM
    Hi Andreas,
    Thanks for adminer; for my I prefer it to tools like MySQL workbench for my limited needs to interact with the database directly.
    I've just come across an issue where adminer showed a blank page when launched. Debugging showed that run_adminer.php could access adminer.php. Our anti virus solution had decided that adminer.php was a 'hacking tool' and quarantined it. I suspect it interpreted the name as 'ad miner'. Just in case someone else has this issue.
    Christoph
  • Picture of abhishek bhattacharjee
    Wed, 20 Apr 2016, 11:58 AM
    for moodle 3.0 after i installed i got an error plugin->components not declared in view.php
  • Picture of sue sugizaki
    Fri, 20 May 2016, 5:42 PM
    I installed this at 3.0 and got an error...
  • C'est moi :-)
    Fri, 10 Jun 2016, 4:08 PM
    Hi Andrea,
    Adminer is a really great and useful tool!
    Do you plan to make it officially compatible with Moodle 3.0 and 3.1, so that it can be installed/upgraded via the build in installer?
  • Picture of Andreas Grabs
    Fri, 10 Jun 2016, 6:24 PM
    Hi Séverin,
    I am sorry for the long running. I am very buisy and I wanted the plugin compatible with php7. So it is now.
    Best regards
1 2
Please login to post comments