<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Can We Connect FA to remote Database]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=7582</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=7582&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Can We Connect FA to remote Database.]]></description>
		<lastBuildDate>Thu, 28 Jun 2018 13:48:06 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Can We Connect FA to remote Database]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32012#p32012</link>
			<description><![CDATA[<p>If I understand what you&#039;re asking, you want one or more companies to be on the local server, and 2 other companies to be on a remote server.</p><p>If you look at the config_db.php file, you&#039;ll see the connection information and company prefix (tbpref) for each company. As apmuthu pointed out, you could use localhost and a forwarded port to securely access a server on a host using SSH to set up port forwarding. You could also just set the host and port to directly access the remote host.</p>]]></description>
			<author><![CDATA[null@example.com (oakstreet1)]]></author>
			<pubDate>Thu, 28 Jun 2018 13:48:06 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32012#p32012</guid>
		</item>
		<item>
			<title><![CDATA[Re: Can We Connect FA to remote Database]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32010#p32010</link>
			<description><![CDATA[<p>You can also create a SSH tunnel to make the remote DB appear as a local one on a different port.</p><p>For a SSH Remote Tunnel visit <a href="https://www.linode.com/docs/databases/mysql/create-an-ssh-tunnel-for-mysql-remote-access/">here</a>, <a href="https://hostpresto.com/community/tutorials/how-to-connect-to-a-remote-mysql-server-via-an-ssh-tunnel/">here</a>, <a href="https://support.cloud.engineyard.com/hc/en-us/articles/205408088-Access-Your-Database-Remotely-Through-an-SSH-Tunnel">here</a> and for CLI visit <a href="https://stackoverflow.com/questions/18373366/mysql-connection-over-ssh-tunnel-how-to-specify-other-mysql-server">here</a>.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Thu, 28 Jun 2018 04:01:36 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32010#p32010</guid>
		</item>
		<item>
			<title><![CDATA[Re: Can We Connect FA to remote Database]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32008#p32008</link>
			<description><![CDATA[<p>You can connect it by using the hostname of remote database.&nbsp; If you are using Cpanel. you can configure the remote Server IP to make it work on.</p><p>If you are using plain VPS without cpanels. try with the server ip address instead of the &quot;localhost&quot;.</p>]]></description>
			<author><![CDATA[null@example.com (kvvaradha)]]></author>
			<pubDate>Thu, 28 Jun 2018 02:43:31 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32008#p32008</guid>
		</item>
		<item>
			<title><![CDATA[Can We Connect FA to remote Database]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32007#p32007</link>
			<description><![CDATA[<p>Is it possible to connect FA to remote Database? I have many companies on my installation but I want only 2 companies to connect to remote database. Is it possible?</p>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Thu, 28 Jun 2018 02:07:11 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32007#p32007</guid>
		</item>
	</channel>
</rss>
