gda-dev does not compile

Mark Johnson mrj001 at shaw.ca
Mon Dec 11 09:58:05 EST 2006


Phil Longstaff wrote:

>I've attached a config file which is in ~/.libgda/config.  If you use
>this, have a MySQL server running with a database named 'gnucash', then
>starting gnucash with URI gda://gnucash will connect to and use that
>database.
>
>I haven't tried with anything other than MySQL though it should, in
>theory, work with postgresql and sqlite with no code changes but with
>config changes.
>
>Phil
>  
>
>------------------------------------------------------------------------
>
><?xml version="1.0"?>
><libgda-config>
>    <section path="/apps/libgda/Datasources/SalesTest">
>        <entry name="DSN" type="string" value="URI=/home/phil/.libgda/sales_test.db"/>
>        <entry name="Description" type="string" value="Test database for a sales department"/>
>        <entry name="Password" type="string" value=""/>
>        <entry name="Provider" type="string" value="SQLite"/>
>        <entry name="Username" type="string" value=""/>
>    </section>
>    <section path="/apps/libgda/Datasources/gnucash">
>        <entry name="Description" type="string" value="Test database for gnucash"/>
>        <entry name="Password"    type="string" value=""/>
>        <entry name="Provider"    type="string" value="MySQL"/>
>        <entry name="User"        type="string" value=""/>
>		<entry name="Host"        type="string" value="localhost"/>
>		<entry name="DSN"         type="string" value="DB_NAME=gnucash"/>
>    </section>
></libgda-config>
>  
>
>  
>
I've modified the config file as follows:
<?xml version="1.0"?>
<libgda-config>
    <section path="/apps/libgda/Datasources/SalesTest">
        <entry name="DSN" type="string" 
value="URI=/home/phil/.libgda/sales_test.db"/>
        <entry name="Description" type="string" value="Test database for 
a sales department"/>
        <entry name="Password" type="string" value=""/>
        <entry name="Provider" type="string" value="SQLite"/>
        <entry name="Username" type="string" value=""/>
    </section>
    <section path="/apps/libgda/Datasources/gnucash">
        <entry name="Description" type="string" value="Test database for 
gnucash"/>
        <entry name="Password"    type="string" value="kirk"/>
        <entry name="Provider"    type="string" value="MySQL"/>
        <entry name="User"        type="string" value="gnucash"/>
        <entry name="Host"        type="string" value="enterprise"/>
        <entry name="DSN"         type="string" value="DB_NAME=gnucash"/>
    </section>
</libgda-config>

I logged into MySql (as root) and created the user and database.  I did 
not create tables, assuming that gnucash would create them.

I started gnucash with:
$ gnucash gda://gnucash
It indicated that the database did not seem to exist and asked if I 
would like to create it.  I clicked yes.  Nothing further happened.

The following was printed on my terminal:
mj at ds9:/opt/gnucash-svn15198/bin$ gnucash gda://gnucash


This is a development version. It may or may not work.
Report bugs and other problems to gnucash-devel at gnucash.org.
You can also lookup and file bug reports at http://bugzilla.gnome.org
The last stable version was GnuCash 2.0.2
The next stable version will be GnuCash 2.2

SQL error: Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (2)
SQL error: Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (2)



The unix socket file is a problem.  It needs a host and port to connect 
to my db server on another machine.  (The default port is what I am 
using here.)  I had thought that the entry name for host above would 
indicate that.

Mark



More information about the gnucash-devel mailing list