Hi,

I've just set up the 'Network Manager' module on two different (dedicated) servers, each running a couple of Drupal instances (OS: Debian GNU/Linux "Lenny"). On the first machine, Network Manager recognizes all relevant databases, on the second one it doesn't.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| 1234567_drupal     | 
| 2345_drupal        | 
| 34567_drupal       | 
| mysql              | 
| postfix            | 
| 456789012_drupal   | 
| 5678_drupal        | 
| 678901_drupal      | 
...

There are some non-Drupal databases on this host, e.g. 'mysql' and 'postfix'; those with numbers belong to a Drupal installation. Network Manager doesn't recognize the first three, only the last two ('5678_drupal' and '678901_drupal'; the real databases have different names, but all Drupal database names include the '_drupal' indicator); also, Notwork Manager doesn't show the non-Drupal databases at ./admin/settings/network_manager (I don't know if this is intended behaviour, i.e. Network Manager might make an educated guess here?).

The site where the 'Network Manager' module is installed runs currently with database root privileges, so this most probably is no issue of unsufficient access permissions (btw, I'd strongly support the idea to handle databse access through Network Manager with "normal" Drupal database connections).

Any ideas?

Thanks & greetings, -asb

Comments

asb’s picture

asb commented
Priority: Critical » Normal

Bogus priority, this is a normal issue (sorry).

btopro’s picture

btopro commented

There's a separate issue filed for the creating connections and managing them through a file, it's on my radar and I'd def. accept co-maintainers to help push it there only cause I won't get back to things like that for awhile here. As for the databases, you are correct. Network Manager makes an educated guess based on looking for certain tables as to whether it's a D5, D6 or D7 database. Since all the queries relate directly to Drupal sites that's why I knock out the non-ones. As for it not selecting some others not sure, I haven't seen this behavior before... anyone else able to replicate this?