[freeside] Multiple instances, one database?

[Brian Taber]

>From what I can see, it looks likeIvan anticipated this.  under
/usr/local/etc/freeside, mapsecrets has the username mappings.  that in
turn points to another file with the database info.  You could
technically:

mapsecrets:
user1 secrets
user2 secrets2


secrets:
DBI:Pg:host=localhost;dbname=freeside
dbuser
dbpass


secrets2:
DBI:Pg:host=localhost;dbname=freeside2
dbuser
dbpass



That would allow you to maintail two seperate databases running on the
same server.  It would depend on what username you use to login to which
database you get.  Of course this would be completely seperate, no sharing
of customers or anything....   The other files in the config directory
would be created to match the information in the secrets files.  I am sure
you could figure out the rest....



Brian




-------------------------
Brian Taber
Manager/IT Specialist
Diverse Computer Group
Office: 508-758-4402
Cell: 508-496-9221
btaber at diversecg.com

> Someone may correct me if they wish, but I'd go for a chroot install.
> Ideally
> with two ip addresses, one for each domain. eg, freeside.abc.tld and
> freeside.xyz.tld.  Or run them on two different ports.
>
> I think you could really run them in one instance of apache, but some of
> the
> source is hardcoded to /usr/local/etc/freeside.  I think that's the main
> roadblock you'll encounter if you attempt to run them in the same
> filesystem.
>
> Let us know your adventures.  Someone else is bound to need this in the
> future, say even 5 or more sites all self contained so to speak.
>
> Enjoy,
>
>
> Scott Edwards
> Daxal Communications
>
> On Monday 08 November 2004 01:47 pm, Gerald V. Livingston II wrote:
>> OK, next question as I test this out.
>>
>> We currently have two companies in one building. Due some legal issues
>> we
>> can't fully merge them and absorb the customer base of the second into
>> the
>> first yet, we have to treat them as completely separate even though the
>> owner/employees/physical address are the same.
>>
>> Can one copy of freeside be set up to create different invoices and use
>> different Auth.Net settings based on a domain name suffix on usernames
>> or
>> some other flag?
>>
>> Ie. joe at abc.tld should get all invoice or nitification emails with a
>> support at abc.tld return address and abc.tld template headers .. but
>> joe at xyz.tld should get messages from support at xyz.tld
>>
>> If not, can I run two instances of Freeside on a single machine using a
>> single database with usernames stored with a domain name suffix (there
>> are
>> some duplicates except for the domain name part)?
>>
>> We are trying to merge billing into a single system in preparation for
>> future total merge of the companies.
>>
>> Thanks,
>>
>> Gerald
>>
>>
>
>