<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Can We Connect FA to remote Database]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=7582&amp;type=atom" />
	<updated>2018-06-28T13:48:06Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=7582</id>
		<entry>
			<title type="html"><![CDATA[Re: Can We Connect FA to remote Database]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=32012#p32012" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[oakstreet1]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42263</uri>
			</author>
			<updated>2018-06-28T13:48:06Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=32012#p32012</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Can We Connect FA to remote Database]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=32010#p32010" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2018-06-28T04:01:36Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=32010#p32010</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Can We Connect FA to remote Database]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=32008#p32008" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[kvvaradha]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19348</uri>
			</author>
			<updated>2018-06-28T02:43:31Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=32008#p32008</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Can We Connect FA to remote Database]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=32007#p32007" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2018-06-28T02:07:11Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=32007#p32007</id>
		</entry>
</feed>
