Synchronization with a remote database [#1565502]

It is impossible for me to connect to a LimeSurvey remote database.

The module works fine when Drupal and LimeSurvey have the same database with differents prefixes and the connection to the remote database of LimeSurvey is ok in command line from my server.

My sites/default/settings.php file :

$db_url = 'mysqli://drupal:xxxxx@localhost/drupal';
$db_prefix = '';
$db_url['ls'] = 'mysql://limesurvey:xxxxx@xxx.xxx.xxx.xxx/limesurvey';

Thanks a lot in advance for considering

Comments

Comment #1

thedut commented 7 May 2012 at 15:09

Status:

Active

» Closed (won't fix)

Hi zaml

It is a limitation of the Drupal6 Database abstraction layer : You can not connect to distinct databases type during an unique script execution.
Your Drupal site uses mysqli
and your LimeSurvey site uses mysql.
--> Set the same database type for both sites : it should works.

Note : the next Drupal 6 release of my module already implements a warning message in this situation.
The Drupal 7 version of my module will not meet this limitation.

Comment #2

thedut commented 22 May 2012 at 09:13

Status:

Closed (won't fix)

» Closed (fixed)

Next versions are availables :
- The Drupal 6 version throws a warning message if both database systems are not equal.
- The drupal 7 version can connect to 2 distinct database systems.

You can download them on
http://drupal.org/project/limesurvey_sync