Problem with save as mysql

[Geert Janssens]

On Friday 24 January 2014 19:40:28 Momchil Ilkov wrote:
> On 01/24/2014 06:29 PM, Geert Janssens wrote:
> > On Friday 24 January 2014 18:04:25 Momchil Ilkov wrote:
> >  > On 01/24/2014 05:44 PM, John Ralls wrote:
> >  > > On Jan 24, 2014, at 6:39 AM, Momchil Ilkov
> >  > > <chiche at stark-net.net>
> > 
> > wrote:
> >  > >> Hi there
> >  > >> 
> >  > >> i can't save my gnucash using mysql option. I have only xml
> >  > >> option
> >  > >> 
> >  > >> from Data Format drop down box. My configuration is:
> >  > >> 
> >  > >> 
> >  > >> 
> >  > >> Debian unstable
> >  > >> 
> >  > >> Linux zmey 3.2.0-2-amd64 #1 SMP Mon Jun 11 17:24:18 UTC 2012
> >  > >> x86_64
> >  > >> 
> >  > >> GNU/Linux chiche at zmey:~$ gnucash -v
> >  > >> 
> >  > >> GnuCash 2.6.0
> >  > >> 
> >  > >> This copy was built from rev 38a0d33+ on 2014-01-01.
> >  > >> 
> >  > >> 
> >  > >> 
> >  > >> I installed gnucash via apt-get install gnucash. I have
> >  > >> 
> >  > >> libdbd-mysql installed and empty database named gnucash
> >  > >> prepared.>>
> >  > >> 
> >  > >> A debug output file is attached from /tmp/gnucash.trace but i
> > 
> > suspect the problem is here:
> >  > >> * 16:10:47 INFO <gnc.backend.dbi>
> >  > >> [gnc_module_init_backend_dbi]
> >  > >> 
> >  > >> GNC_DBD_DIR not set: using libdbi built-in default * 16:10:47
> >  > >> 
> >  > >> WARN <gnc.backend.dbi> [gnc_module_init_backend_dbi()] No DBD
> >  > >> 
> >  > >> drivers found * 16:10:53 MESSG <gnc.module> Could not locate
> >  > >> 
> >  > >> optional module gnucash/gtkmm interface v.0 * 16:10:53 WARN
> >  > >> 
> >  > >> <gnc.python> Unable to initialize Python module (unable to
> >  > >> open
> >  > >> 
> >  > >> /usr/share/gnucash/python/init.py)>>
> >  > >> 
> >  > >> I google over 3 hours but i could not find a working solution
> >  > >> of
> >  > >> 
> >  > >> my problem.>>
> >  > >> 
> >  > >> Please help.
> >  > > 
> >  > > You need to install libdbi and the libdbi mysql driver. I don't
> >  > > know
> >  > > 
> >  > > off the top of my head what those package names are in Debian.
> >  > > 
> >  > > 
> >  > > 
> >  > > Regards,
> >  > > 
> >  > > John Ralls
> >  > 
> >  > Thanks for the reply, but i think i have it.
> >  > 
> >  > zmey:/tmp# dpkg -l |grep libdbi
> >  > 
> >  > ii libdbd-mysql
> >  > 
> >  > 0.9.0-1 amd64 MySQL database server driver for libdbi
> >  > 
> >  > ii libdbd-sqlite3
> >  > 
> >  > 0.9.0-1 amd64 SQLite3 database driver for libdbi
> >  > 
> >  > ii libdbi-dev
> >  > 
> >  > 0.9.0-1 amd64 DB Independent Abstraction Layer for C --
> >  > 
> >  > development files
> >  > 
> >  > ii libdbi-perl
> >  > 
> >  > 1.630-1 amd64 Perl Database Interface (DBI) ii libdbi1:amd64
> >  > 
> >  > 0.9.0-1 amd64 DB
> >  > 
> >  > Independent Abstraction Layer for C -- shared library
> > 
> > Where is libdbi itself ?
> > 
> > Geert
> 
> I found it there:
> zmey:/tmp# ls -lh /usr/lib/x86_64-linux-gnu/ |grep libdbi
> -rw-r--r--  1 root root   91K Jan 20 23:40 libdbi.a
> lrwxrwxrwx  1 root root    15 Jan 20 23:40 libdbi.so ->
> libdbi.so.1.1.0 lrwxrwxrwx  1 root root    15 Jan 20 23:40
> libdbi.so.1 -> libdbi.so.1.1.0 -rw-r--r--  1 root root   63K Jan 20
> 23:40 libdbi.so.1.1.0

/usr/lib/x86_64-linux-gnu/ doesn't look like default path to me. Perhaps you may want to set 
the GNC_DBD_DIR environment variable to point at the directory where the libdbd-mysql 
shared libraries are stored.

Geert