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:
[EMAIL PROTECTED]:/opt/gnucash-svn15198/bin$ gnucash gda://gnucash
This is a development version. It may or may not work.
Report bugs and other problems to [EMAIL PROTECTED]
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
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
