Problem with save as mysql [SOLVED]

[Momchil Ilkov]

On 01/24/2014 08:00 PM, Geert Janssens wrote:
> 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
>

Thank you Greet. Run the program with GNC_DBD_DIR=/usr/lib/dbd/ gnucash 
solve the problem.