Drupal 7: Drupal Remote Dashboard Sysadmin Module

David G - DrupalIn running a number of Drupal websites I’ve had the desire to centralize my management or visualization of the status of my various Drupal sites. Oftentimes I rely on Drush and its site aliases feature to query the status of a website. At a local Drupal Users Group meeting I was shown a nice graphical approach to monitoring your Drupal sites with a module called Drupal Remote Dashboard (or DRD for short).

The Drupal Remote Dashboard (DRD) reminds me a lot of a Piwik or Google Analytics dashboard, but instead of showing you user traffic on your website it shows you the health of your Drupal installations.

The DRD admin interface shows you health of Drupal Core installations you have on remote servers. It also can you show you individual domain name reports running on each Drupal Core instance. A Drupal Core instance is the drupal webroot path to Drupal on a server. If you’re running many drupal cores on your webserver in a shared hosting environment then the admin page can get rather messy. But, if you’re running Drupal in a more centralized traditional multi-site setup — then these reports drill down nicely.

From my own DRD installation the main admin page shows you Drupal Cores, eg individual Drupal installations:

Drd drupal core overview page.

Drd drupal core overview page.

Then within each core you can see Domains running within that Drupal instance (this image from the projects homepage). You can also see additional reports typically found in any Drupal website from this handy centralized dashboard:

Example Domain listing for a Drupal Core instance (eg all the subdomains running in a multi-site instance of Drupal)

Example Domain listing for a Drupal Core instance (eg all the subdomains running in a multi-site instance of Drupal)

Example single site report for 1 domain within a Drupal Core instance.

Example single site report for 1 domain within a Drupal Core instance.

Setup and Configuration:

I found installing this module to be tricky. The DRD module is really 2 modules working together:

  1. A dashboard module you install on the computer you want to centralize your monitoring from. So you would install Drupal Remote Dashboard on http://drupal-diagnostics.local as an example. This could be your laptop or at your work location.
  2. A server module installed per Drupal Core you want to monitor, this server module communicates back to the Dashboard for reports and actions. It is called Drupal Remote Dashboard Server.
  3. Both of the above modules also require the AES module for secure communications between these processes.

Once the module(s) are installed you can add a Drupal Core to your dashboard report:

Adding a new Core. Ignore the Key fields as thats filled in by DRD typically automatically in the next step.

Adding a new Core. Ignore the Key fields as that’s filled in by DRD typically automatically in the next step.

After installing the Core typically you’re given the option to Push the Keys from the remote site to the dashboard with a simple URL link you press. If this fails you can log into the remote site manually and retrieve and set the keys here in the Admin panel if you need to.

Then, and here’s the most critical part. For every Core you install you then need to run the following Action(s) from the Core Overview Page. You’ll want to run Update Remote Actions and Update Server Domains:

Note: You must select (check) the Cores you want to run the actions on 1st before selecting the Actions (yea I know, I didn’t write this tool :P).

Update Actions and server Domains. If you don't do this your reports will show nothing!

Update Actions and server Domains. If you don’t do this your reports will show nothing!

Then all the reports and Cores should be reporting their statuses OK. This tool is helpful for a GUI to how your sites health is. You can also issue Drush command graphically but I have not done this yet.

Looking for quality web hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , , , , , , , , , , , , | Posted under Drupal, Drush | RSS 2.0

Author Spotlight

David Gurba

I am a web programmer currently employed at UCSB. I have been developing web applications professionally for 8+ years now. For the last 5 years I’ve been actively developing websites primarily in PHP using Drupal. I have experience using LAMP and developing data driven websites for clients in aviation, higher education and e-commerce. If you’d like to contact me I can be reached at david.gurba@arvixe.com

2 Comments on Drupal 7: Drupal Remote Dashboard Sysadmin Module

  1. Ahmad says:

    Drd works on local machine with on drd server and serveral core installations?
    I have installed the drd on my localhost website but it gives me the following error.

    PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘))’ at line 2: SELECT d.* FROM {drd_domain} d WHERE (d.did IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9, )) ; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => drupaltest.local [:db_condition_placeholder_2] => localhost [:db_condition_placeholder_3] => http [:db_condition_placeholder_4] => 1 [:db_condition_placeholder_5] => -1 [:db_condition_placeholder_6] => 1 [:db_condition_placeholder_7] => drupaltest_local [:db_condition_placeholder_8] => http://drupaltest.local/ [:db_condition_placeholder_9] => 1 ) in drd_domain_load() (line 1602 of /var/www/drupal-test/sites/all/modules/drd/drd.module).

Leave a Reply

Your email address will not be published. Required fields are marked *