Re: [Refdb-users] Last reference

[Per-Anders G. <PA...@lb...>]

Hi Lazar,

On Sat, Feb 11, 2006 at 06:17:41AM -0800, Z F wrote:
> 
> 
> --- Per-Anders Glans <PA...@lb...> wrote:
> 
> > On Fri, Feb 10, 2006 at 11:46:35PM +0100, Markus Hoenicka wrote:
> > > Hi,
> > > 
> > > Z F writes:
> > >  > When I retrieve citations, the citation with the highest ID
> > number
> > >  > always has "ER -" twice in the body of the reference.
> > >  > 
> > >  > Did anybody notice a similar behavior? I am using refdb V.
> > 0.9.6-pre3
> > >  >
> > > 
> > > Not here on FreeBSD 5.4. Does anyone else see this behaviour? If
> > so,
> > > please indicate your platform, maybe there's a pattern that helps
> > to
> > > find the bug.
> > 
> > I don't see it on Debian testing/unstable, RefDB 0.9.6, MySQL 5.0.18,
> > 
> > libdbi 0.8.1.
> 
> I have very similar setup. Debian unstable with the latest
> packages of mysql5. Anders, I am curious how you installed 
> refdb on your system as I could not install it from the available
> packages, I had to recompile libdbd-mysql driver.

I installed mysql5 from the official debian repository. The libdbi drivers
were installed from the debianised packages on sourceforge. I had 

deb  http://refdb.sourceforge.net/debian/cvs/ testing main
deb  http://refdb.sourceforge.net/debian/cvs/ unstable main

in my sources.list and used apt-get. No tweaks were needed, as far as
I remember. Though after creating a new reference database with refdba,
I had to manually set the user privileges in mysql to be able to access
the database from refdbc. 

refdb was configured with ./configure --sysconfdir=/etc --with-db-server=mysql
then make and make install.

My libdbi:

pergl@chipmunk:~$ dpkg --list | grep libdbi
hi  libdbd-mysql                     0.8.1-1                       MySQL database server driver for libdbi
ii  libdbd-sqlite                    0.8.1-1                       SQLite database server driver for libdbi
ii  libdbi-perl                      1.50-2                        Perl5 database interface by Tim Bunce
hi  libdbi0                          0.8.1-1                       Database Independent Abstraction Layer for C
hi  libdbi0-dev                      0.8.1-1                       Database Independent Abstraction Layer for C


And my mysql:

pergl@chipmunk:~$ dpkg --list | grep mysql 
ii  libapache-mod-auth-mysql         4.3.9-2                       Apache module for MySQL authentication
hi  libdbd-mysql                     0.8.1-1                       MySQL database server driver for libdbi
ii  libdbd-mysql-perl                3.0002-2                      A Perl5 database interface to the MySQL database
ii  libmysqlclient12                 4.0.24-10sarge1               mysql database client library
ii  libmysqlclient14                 4.1.15-1                      mysql database client library
ii  libmysqlclient14-dev             4.1.15-1                      mysql database development files
ii  libmysqlclient15                 5.0.18-7                      mysql database client library
ii  mysql-admin                      1.1.6-1                       GUI tool for intuitive MySQL administration
ii  mysql-admin-common               1.1.6-1                       Architecture independent files for MySQL Administrator
ii  mysql-client-5.0                 5.0.18-7                      mysql database client binaries
ii  mysql-common                     5.0.18-7                      mysql database common files (e.g. /etc/mysql/my.cnf)
rc  mysql-common-4.1                 4.1.11a-4sarge2               mysql database common files (e.g. /etc/mysql/my.cnf)
ii  mysql-query-browser              1.1.17-5                      Official GUI tool to query MySQL database
ii  mysql-query-browser-common       1.1.17-5                      Architecture independent files for MySQL Query Browser
rc  mysql-server-4.1                 4.1.14-6                      mysql database server binaries
ii  mysql-server-5.0                 5.0.18-7                      mysql database server binaries
ii  php4-mysql                       4.4.2-1                       MySQL module for php4


myslq4 has been removed ('rc'), while all versions of libmysqlclient seem
to happily co-exist.

Regards,

Anders