How to Connect to Drupal Content Datasource?

Owned by Sergey Yuryev(gmail)
Last updated: Apr 05, 2018 by Support Ilangl

To find our more about establishing connection to data source, please check How to Connect to Content Data-Source

Drupal MySQL Connection

This connection is a primary connection to export/import content. iLangL Cloud is using this string to connect directly to Microsoft SQL Server database. 

The process requires connection between Ms SQL server, where Drupal content database is hosted, and iLangl Cloud server.


Parameters:

  • Server(Required) - the name or network address of the instance of SQL Server to which to connect;
  • Port(Optional) - a server port that will be added to a server name: 'Server':'Port';
  • User Id(Required) - MySQL account user name;
  • Password(Required) - MySQL account password;
  • Database(Required) - name of a database;
  • Table prefix(Optional) - the database table prefix for your CMS installation (usually empty for Drupal).

Here is what the final connection string generated to Content Provider will look like:

Server=[Server]:[Port];Database=[Database];Uid=[User Id];Pwd=[Password];

Drupal Web Connection

iLangL Cloud imports content to Drupal CMS via MySQL database connection. Drupal is using content cache in order to optimize server workload and increase performance. When content is imported directly to a database, Drupal web application doesn't know about this operation and therefore, keeps old content cached. In order to refresh this content, you have to set up 'Drupal Web Connection'. Once the translated content is imported, our connector will invoke a commit import action which does following: Configuration\Development\Perfomance\'Clear all caches' button click(/admin/config/development/performance).

Parameters:

  • Server(Required) - a web URL of your website(for example company.com);
  • Port (Optional) - website port(for example, when Port=80, requests will be sent to http://company.com:80);
  • Database - you have to provide a cookie name from your website here. You can find out how to obtain a cookie from information below;
  • User Id(Required) -  Drupal account name;
  • Password(Required) - Drupal account password;


All other parameters for 'Drupal Web Connection' will be ignored.

How to Specify a Cookie Name for Your Drupal Website?

To emulate user action 'Clear cache' automatically, Drupal connector has to know a specific cookie name that is different for each website. This cookie starts with the prefix 'SESS' and continues with a list of numbers and letters. In order to see this cookie, you have to log in to a Drupal back-end. Here is an example of cookie name from our demo website: SESS86d043ff92c6eb5d3d448e75f49658e8. You should put this value to the 'Database' field of a 'Drupal web connection'.

How to Find Cookie in Chrome?

For the Actual Page

  1. Press 'F12'

  2. Go to Application > Storage> Cookies

How to Find Cookie in Firefox and Other Browsers?

The article below describes how to get access to a cookie list in different browsers.

How to View Cookies