GNUCash in 12.04 does not have an SQL option

[Colin Law]

On 16 January 2013 20:35, John D Lamb <J.D.Lamb at btinternet.com> wrote:
> On 16/01/13 01:48, Alan McKay wrote:
>> Hey folks, my gnucash that I installed from apt-get on my 12.04
>> desktop does not seem to have an option to use a SQL (MySQL) database.
>>  It only has XML
>>
>> http://gnucash.org/docs/v2.4/C/gnucash-guide/basics-files1.html
>>
>> That link just sort of assumes you have SQL support and does not tell
>> you how to enable it.
>>
>> Do I have to build this myself with SQL support, or is there a way to
>> add it with apt?
>
> gnucash on 12.04 (now 12.10) works just fine for me with mysql. I
> suspect gnucash checks to see if it can find an available mysql server
> before offering the mysql option: it doesn’t offer me postgresql, which
> I haven’t installed.
>
> I suggest you install
>
> mysql-server
> phpmyadmin

I don't think it is the lack of an sql server, that could be remote so
gnucash has no way of knowing if one is available until you try to use
it.  I think the problem may be that libdbd-mysql is missing.
sudo apt-get install libdbd-mysql

You will need a mysql server of course, but I cannot agree that
phpmyadmin and apache are necessary.  You will only need them if you
want to get in and look at the database with a gui.

Colin