Re: [Refdb-users] Problem to create first refdb user database with mysql

[Markus H. <mar...@mh...>]

Hi,

At 2016-08-05 13:46, anonyme was heard to say:

> Hi,
> 
> I installed by hands my refdb server onto debian Jessie, and the 
> service start without problem. I'm using mysql backend database.
> 
> But below is the bug when attempting to create first refdb user 
> database ... I can't understand because all packages have been 
> installed with debian package manager, so they coul'nt be wrong 
> version... May be a problem with libraries dependecies to refresh but I 
> forgot the command to use... At the end I added my refdbdrc file.
> 
> Thank yoiu for your help !
> Patrick
> 
> ROOT@GELINUX:/USR/SBIN# REFDBD -A -U ROOT -W #######
> libdbi: Failed to load driver: /usr/lib/i386-linux-gnu/libicule.so
> libdbi: Failed to load driver: /usr/lib/i386-linux-gnu/libtxc_dxtn.so
> libdbi: Failed to load driver: /usr/lib/i386-linux-gnu/libnspr4.so

These error messages indicate that libdbi fails to load the given shared 
libs as drivers. This is because it somehow looks into the wrong 
directory. /usr/lib/i386-linux-gnu/ seems to be the directory which 
holds most shared libs on your system. Usually the libdbi drivers are 
installed in a subdirectory of such a directory. By default, the drivers 
are installed in /usr/local/lib/dbd/. I'm not too familiar with Debian, 
but dpkg, apt or synapse, whichever you use, should have methods to 
display where files were installed.

[...]
> 
> refdbdrc file :
> # Specify the directory that contains the libdbi drivers. This is only
> # necessary if you use precompiled libdbi binaries in locations the
> # binaries were not built for
> #dbi_driverdir /usr/local/lib/dbd
> dbi_driverdir /usr/lib/i386-linux-gnu

This entry may be the culprit because it points to a directory 
containing general-purpose shared libs, not to the libdbi driver subdir. 
Usually it is not necessary to set this at all, the libdbi package(s) 
should take care of everything. Try removing this line to see if libdbi 
manages to load the mysql driver.

Also, I assume you are aware that the libdbi package contains only the 
database abstraction framework. Drivers for particular database engines 
need to be installed separately.

best regards,
Markus

-- 
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38



Links:
------
[1] https://lists.sourceforge.net/lists/listinfo/refdb-users
[2] http://refdb.sourceforge.net