[wplug-internet] Can I create a new MySQL database?

[Ted Rodgers]

On Mon, Feb 13, 2012 at 1:34 PM, Pat Barron <pat at lectroid.com> wrote:

>  I was thinking of just running GnuCash as a client (on my desktop system
> - or anyone's desktop system that happens to be maintaining WPLUG's books
> at that time...), and just using the database as a back-end data store.  It
> appears to be able to do that - don't think any GnuCash bits actually need
> to be installed on the server.
>
>
An immediate concern with that is opening mysql ports up to the web to be
hit as the storage since we have other items in mysql, too.   Did you have
a security plan in mind to keep it safe?



> I have a prototype set up at home using local storage, but if I go that
> way, I'm the only one who can access it, and handing off the data to a new
> treasurer at some point in the future might be problematic.
>
> --Pat.
>
>
> On 02/13/2012 1:31 PM, Ted Rodgers wrote:
>
> Pat,
>
> Sounds like a pretty neat idea except gnucash may take a bunch of backend
> X libs that may or may not be on the server.
>
> On Mon, Feb 13, 2012 at 1:27 PM, Pat Barron <pat at lectroid.com> wrote:
>
>> I'd like to create a new MySQL database to use as back-end storage for
>> GnuCash, with the idea of setting up a more permanent online accounting
>> system in which to maintain WPLUG's financial records.  My intent would
>> be to access MySQL via an SSH tunnel, so it wouldn't be necessary to
>> open up port 3306 to the Internet.  Postgresql would work too (and to be
>> honest, I actually prefer it...), and it seems to be installed, but
>> doesn't appear to be running.
>>
>> Thoughts?
>>
>> --Pat.
>>
>> _______________________________________________
>> wplug-internet mailing list
>> wplug-internet at wplug.org
>> http://www.wplug.org/mailman/listinfo/wplug-internet
>>
>
>
>
> _______________________________________________
> wplug-internet mailing listwplug-internet at wplug.orghttp://www.wplug.org/mailman/listinfo/wplug-internet
>
>
>
> _______________________________________________
> wplug-internet mailing list
> wplug-internet at wplug.org
> http://www.wplug.org/mailman/listinfo/wplug-internet
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.wplug.org/pipermail/wplug-internet/attachments/20120213/c5e805fb/attachment.html