ISPConfig 3 With Xeround Cloud Database Service

This tutorial is a companion to any of the Perfect Server tutorials. ISPConfig 3 will not work with the Xeround Cloud database service by default. With minor modifications from this tutorial you will be able to run your Perfect Server without having to manage a database server.
The specific examples below were done on a Debian server with ISPConfig 3 and nginx. The steps should be similar to other distros. As well the instance is hosted in the Rackspace ORD1 datacenter. Instances within an Amazon datacenter may require different configuration. This tutorial comes without warranty of any kind.

Preliminary Note

I created a Xeround instance:
DNS Name:
Internal DNS Name: Clicking DNS Name will take you to phpMyAdmin.
I will use the Internal DNS Name as my server is located within Rackspace ORD1, but if your server is located elsewhere use the DNS Name. This tutorial starts in a Perfect Server tutorial immediately before:

1 Port Forwarding - Source

Xeround does not use the default port of 3306. The simplest way around this is to use port forwarding. This example used rinetd.
To install rinetd, just run
We will forward HTTP traffic from 127.0.0.1 to int.instanceABCD.db.xeround.com.. The default MySQL port is 3306 and our example port is 7126. Localhost will not work in place of 127.0.0.1.

127.0.0.1 3306 int.instanceABCD.db.xeround.com. 7126

Now restart rinetd.
Then run:
rinetd should now be running on port 3306 (mysql).

2 Configure ISPConfig 3

ISPConfig 3 needs a few adjustments to allow itself access to the database server. Using server1.example.com did not work. The remote MySQL host required % for any host.

...Line 184
  if($conf['mysql']['host'] == 'localhost') {
   $from_host = '%';
  } else {
   $from_host = '%';
  }
...Line 1946 (Add second line)
  $content = rf('tpl/mysql_clientdb.conf.master');
  $content = str_replace('localhost',$conf['mysql']['host'],$content);

To allow application access for created databases in ISPConfig 3 run We will use expert install for ISPConfig 3.
Now allow the database links in ISPConfig to link to your Xeround instance. Replace the address below with the one from your Xeround DNS Name.

If using nginx instead of Apache comment out the two lines in the below file. These settings are doubled and will cause a redirect loop.

#               fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
#               fastcgi_param PATH_INFO $fastcgi_script_name;

Finally, return to your Perfect Server tutorial to configure ISPConfig 3.

TERIMA KASIH ATAS KUNJUNGAN SAUDARA
Semoga artikel ini bermanfaat bagi saudara. Jika ingin mengutip, baik itu sebagian atau keseluruhan dari isi artikel ini harap menyertakan link dofollow ke https://androidblackberries.blogspot.com/2012/02/ispconfig-3-with-xeround-cloud-database.html. Terima kasih sudah singgah membaca artikel ini.