refdb-users — List for RefDB users

Re: [Refdb-users] Build Debian bin pkg from Ubunt scr pkg

[Torsten B. <br...@ph...>]

Hallöchen!

Stefan Schlee writes:

> [...]
>
> I looked for available packages with "libdbi" in their name and got the
> following listing:
>
> $> aptitude search libdbi                        
>
> p libdbi-doc - DB Independent Abstraction Layer for C -- documentation
> [...]
> p libdbix-xmlmessage-perl - perl module for exchanging XML messages between DBI
> data sources
>
>
> Which of these packages is missing from my installation?

Du you use the latest version on
<https://launchpad.net/~bronger/+ppa-packages>?  I switched to the
SVN version three weeks ago.  It contains

    Depends: ${shlibs:Depends}, ${misc:Depends}, adduser, lsb-base (>= 3.0-6),
     openjade, docbook-dsssl, docbook-xml, jadetex, texlive-base-bin, fop,
     libbtparse0, libtext-iconv-perl, libmarc-record-perl, libxml-parser-perl,
     libcgi-pm-perl, coreutils, libreadline5, libxml2-utils, xml-core, libncurses5,
     libdbi0, libdbd-sqlite, libexpat1
    Recommends: mysql-server (>= 3.23) | postgresql (>= 7.1) | libsqlite0 (>= 2.8) |
     libsqlite3-0 (>= 3), libdbd-mysql | libdbd-pgsql | libdbd-sqlite3

The libdbd* packages are important.

libdbd-sqlite is always installed, however in your case, this was
not enough.  Does anybody have an idea why is this?  Doesn't RefDB
start in Sqlite mode?

We could add *all* libdbd's to the dependencies.

> [...]
>
> PS: Although required the "autoconf" package is not mentioned in
> the "Build-Depends:". clause.  Explicitly listing may only be
> necessary in a Debian context, because this package may be
> automatically installed by other packages in the Ubuntu case - I
> don't know, but you (Torsten) may want to check this.

It is built by Launchpad's build service, which starts with a
minimal Ubuntu, so I think the builddeps are correct for Ubuntu.  I
added it nevertheless.

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

[Refdb-users] Build Debian bin pkg from Ubunt scr pkg

[Stefan S. <ste...@ya...>]

Hallo!

I am trying to build a Debian Lenny package from the Ubuntu
package sources provided by Torsten Bronger.

I am a Debian packaging neophyte but after some struggling I
managed to get something named refdb_<..>.deb.  The only issue
that I encountered was that I had to use the "libltdl3-dev"
instead of the "libltdl7-dev" as proposed in the "Build-Depends:"
clause, because the "libltdl7-dev" is not available in the Debian
Lenny distribution.

Still the build process worked out fine (although I got a lot of warnings concerning pointers, data types etc.)

After I had manually satisfied the package requirements according to the "Depends:" clause, I issued a "dpkg -i refdb_<..>.deb".  Alas the installation process terminated with an error:

...
invoke-rc.d: initscript refdb, action "start" failed.
dpkg: error processing refdb (--install):
 subprocess post-installation script returned error exit status 1
...

This made me include a "set -x" in the "/etc/init.d/refdb" file to get a trace.  The output of the trace was as follows:


+ start_server
+ '[' '!' -d /var/run/refdb ']'
+ '[' -z refdb ']'
+ start-stop-daemon --start --quiet --pidfile /var/run/refdb/refdbd.pid --chuid refdb --exec /usr/sbin/refdbd -- -L /var/log/refdb/refdbd.log -P /var/run/refdb/refdbd.pid
+ errcode=0
+ return 0

+ '[' -n '' ']'
+ running
+ '[' '!' -f /var/run/refdb/refdbd.pid ']'
++ cat /var/run/refdb/refdbd.pid
+ pid=21573
+ running_pid 21573 /usr/sbin/refdbd
+ pid=21573
+ name=/usr/sbin/refdbd
+ '[' -z 21573 ']'
+ '[' '!' -d /proc/21573 ']'
+ return 1


Obviously the refdb server started but terminated prematurely, so I looked into the "/var/log/refdb/refdbd.log" and found the following message:

6:pid=21573:Thu Sep 24 17:41:19 2009:Available libdbi database drivers:
6:pid=21573:Thu Sep 24 17:41:19 2009:sqlite
3:pid=21573:Thu Sep 24 17:41:19 2009:Requested libdbi driver is not present

I looked for available packages with "libdbi" in their name and got the following listing:

$> aptitude search libdbi                        

p   libdbi-doc                        - DB Independent Abstraction Layer for C  -- documentation
p   libdbi-perl                       - Das Perl5-Datenbank-Interface von Tim Bunce
p   libdbi-ruby                       - Datenbank-unabhängige Schnittstelle für Ruby
p   libdbi-ruby1.8                    - Datenbankunabhängige Schnittstelle für Ruby 1.8
i A libdbi0                           - Database Independent Abstraction Layer for C
i   libdbi0-dev                       - DB Independent Abstraction Layer for C  -- development files
p   libdbicx-testdatabase-perl        - Create a temporary database from a DBIx::Class::Schema
p   libdbix-abstract-perl             - DBI-SQL-Abstraktion
p   libdbix-class-datetime-epoch-perl - Automatic inflation/deflation of epoch-based DateTime objects ...
p   libdbix-class-htmlwidget-perl     - Like FromForm but with DBIx::Class and HTML::Widget
p   libdbix-class-perl                - Extensible and flexible object <-> relational mapper
p   libdbix-class-schema-loader-perl  - Dynamic definition of a DBIx::Class::Schema
p   libdbix-contextualfetch-perl      - Add context aware fetches to DBI
p   libdbix-datasource-perl           - Datenbankunabhängige 'create'- und 'drop'-Funktionen
p   libdbix-dbschema-perl             - Database-independent schema objects
p   libdbix-easy-perl                 - Easy to Use DBI Interface
p   libdbix-fulltextsearch-perl       - Indexing documents with MySQL as storage
p   libdbix-password-perl             - Perl module for creating a global password file for DB passwords
p   libdbix-profile-perl              - DBI-ABfrage-Messungen
p   libdbix-recordset-perl            - Perl-Erweiterung für DBI-Satzmengen
p   libdbix-searchbuilder-perl        - Encapsulate SQL queries and rows in simple perl objects
p   libdbix-sequence-perl             - ein einfacher SQL92-ID-Erzeuger
p   libdbix-xml-rdb-perl              - perl module for creating XML from a DBI datasource
p   libdbix-xmlmessage-perl           - perl module for exchanging XML messages between DBI data sources   


Which of these packages is missing from my installation?

Kind regards

Stefan

PS: Although required the "autoconf" package is not mentioned in the "Build-Depends:". clause.  Explicitly listing may only be necessary in a Debian context, because this package may be automatically installed by other packages in the Ubuntu case - I don't know, but you (Torsten) may want to check this.



      

Re: [Refdb-users] Making RefDB cooperating with Zotero

[Torsten B. <br...@ph...>]

Hallöchen!

Markus Hoenicka writes:

> Torsten Bronger writes:
>
>> It could be implemented with URIs:
>> 
>>     addref zotero://login@localhost
>>     getref -o zotero://login@localhost :ID:>0
>
> What is required on RefDB's end to support this URI usage?

It must treat given files which start with "zotero://" specially.
If refdbc hits a "zotero://..." filename, it must call (new)
functions which talk to the Zotero server (through sockets or dbus,
I don't know what it offers).

All I wanted to show is a possibility to realise the semi-automatic
synchronisation with Zotero without adding completely new refdbc
commands.

>> This also means that RefDB must introduce last-modified (and
>> maybe created) fields for its datasets.  [...]
>
> RefDB has an xuser_date field in the t_xuser table. [...] If that
> is not sufficient, I could add a "last fiddled with" field for
> internal purposes.

I save it in Web-frontend data structures, so I don't need it in
RefDB anymore.  Add it only if you think it could be useful for
others.

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

Re: [Refdb-users] Making RefDB cooperating with Zotero

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

Torsten Bronger writes:
 > It could be implemented with URIs:
 > 
 >     addref zotero://login@localhost
 >     getref -o zotero://login@localhost :ID:>0
 > 

What is required on RefDB's end to support this URI usage?

 > 
 > This also means that RefDB must introduce last-modified (and maybe
 > created) fields for its datasets.  This is something that I could
 > use for the Web frontend, too, for easier caching and for presenting
 > newly-added references on the front page.  The last-modified field
 > must be in libinfo because it's user-dependent.
 > 

RefDB has an xuser_date field in the t_xuser table. As per the RIS
spec, this date is used to denote when a reprint was requested (RP =
ON REQUEST), but I don't see any reason why this field shouldn't be
reused for other reprint states. This would require moderate code
changes. If that is not sufficient, I could add a "last fiddled with"
field for internal purposes.

regards,
Markus

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

Re: [Refdb-users] Making RefDB cooperating with Zotero

[Torsten B. <br...@ph...>]

Hallöchen!

Bruce D'Arcus writes:

> [...]
>
> Keep in mind that Zotero is now split between a client, and a
> server.
>
> [...]
>
> Upshot is that I would assume some kind of server API interop
> might be worth exploring.

It could be implemented with URIs:

    addref zotero://login@localhost
    getref -o zotero://login@localhost :ID:>0

Of course, the Zotero server must meet the following requirements:

* serve in RIS format

* serve only datasets that have changed after a certain timestamp
  (namely the last synchronisation)

Zotero's IDs become citation keys in RefDB.

This also means that RefDB must introduce last-modified (and maybe
created) fields for its datasets.  This is something that I could
use for the Web frontend, too, for easier caching and for presenting
newly-added references on the front page.  The last-modified field
must be in libinfo because it's user-dependent.

All this is not very high on my wishlist for RefDB, though.  Manual
synching via RIS with Zotero now and then is fully sufficient for
me.

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

Re: [Refdb-users] Making RefDB cooperating with Zotero

[Bruce D'A. <bda...@gm...>]

On Sun, Aug 23, 2009 at 11:28 AM, Markus
Hoenicka<mar...@mh...> wrote:
> Quoting Bruce D'Arcus <bda...@gm...>:
>
>> On Sat, Aug 22, 2009 at 9:41 PM, Wei-Wei Guo<ww...@gm...> wrote:
>>
>>> RefDB is powerful in managing reference database. If RefDB could
>>> managing the database of Zotero directly, which is a sqlite3 database, it
>>> will boost RefDB a lot.
>>
>> I think the ability to easily move data around between systems is
>> probably the better approach.
>>
>
> I second that. I've had a look at Zotero's internal data model, which isn't
> really documented anywhere except in the SQL script which creates the
> database. At first glance there are so many differences to the data model
> currently used by RefDB that it would come close to rewriting the app in
> order to make it handle Zotero databases. Moreover, the Zotero developers
> discourage external access to the database as Zotero may end up in an
> undefined state if the database is fiddled with while the browser is open.
>
> How good are Zotero's import and export capabilities?

Keep in mind that Zotero is now split between a client, and a server.

The client has supported good import/export of standard formats like
RIS, BibTeX, MODS for awhile. Their primary (e.g. lossless) format is
RDF, which is about to get an upgrade (to the BIBO vocab I've worked
with them and others on), and be accessible via a server API as well.

Upshot is that I would assume some kind of server API interop might be
worth exploring.

Bruce

Re: [Refdb-users] Making RefDB cooperating with Zotero

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

Quoting Bruce D'Arcus <bda...@gm...>:

> On Sat, Aug 22, 2009 at 9:41 PM, Wei-Wei Guo<ww...@gm...> wrote:
>
>> RefDB is powerful in managing reference database. If RefDB could
>> managing the database of Zotero directly, which is a sqlite3  
>> database, it will boost RefDB a lot.
>
> I think the ability to easily move data around between systems is
> probably the better approach.
>

I second that. I've had a look at Zotero's internal data model, which  
isn't really documented anywhere except in the SQL script which  
creates the database. At first glance there are so many differences to  
the data model currently used by RefDB that it would come close to  
rewriting the app in order to make it handle Zotero databases.  
Moreover, the Zotero developers discourage external access to the  
database as Zotero may end up in an undefined state if the database is  
fiddled with while the browser is open.

How good are Zotero's import and export capabilities?

regards,
Markus


-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

Re: [Refdb-users] Making RefDB cooperating with Zotero

[Bruce D'A. <bda...@gm...>]

On Sat, Aug 22, 2009 at 9:41 PM, Wei-Wei Guo<ww...@gm...> wrote:

> I searched the mailing list and found there are some discussions about Zotero years ago. The Zotero becomes very
> popular recently, but, due to my experience, it has a major flaw. The Zotero has limited ability in managing it
> database, since its only an extension of Firefox.

What do you mean by "managing [the] database"? Why is this a "major
flaw"? For whom?

> RefDB is powerful in managing reference database. If RefDB could
> managing the database of Zotero directly, which is a sqlite3 database, it will boost RefDB a lot.

I think the ability to easily move data around between systems is
probably the better approach.

Bruce

[Refdb-users] Making RefDB cooperating with Zotero

[Wei-Wei G. <ww...@gm...>]

Hi Markus,

I searched the mailing list and found there are some discussions about Zotero years ago. The Zotero becomes very
popular recently, but, due to my experience, it has a major flaw. The Zotero has limited ability in managing it 
database, since its only an extension of Firefox. RefDB is powerful in managing reference database. If RefDB could 
managing the database of Zotero directly, which is a sqlite3 database, it will boost RefDB a lot.

It's just my immature thinking. Hope it's not unreality and bother you much.

Best wishes,
Wei-Wei

[Refdb-users] RefDB for Ubuntu

[Torsten B. <br...@ph...>]

Hallöchen!

At https://launchpad.net/~bronger/+archive/ppa you can get RefDB for
Ubuntu Jaunty.  It is possible to add support for Hardy or Intrepid
if someone requests it.

If someone needs support for Debian, he must do it himself.  It
should be very easy since the source of the package is available
there, too.

I packaged only the big rectangle in
<http://refdb.sourceforge.net/refdb-dependencies.png>.  This means
that there are some programs in /usr/bin which won't work.

After installation, there is no configuration file.  The server runs
in Sqlite mode without database, so you must create configuration
files according to the manual.  A slightly modified refdb-init is
available but difficult to use.  For example, refdbd runs as user
"refdb", which must have admin access to PostgreSQL.

There is no refdbctl.  Instead, there is /etc/init.d/refdb with the
usual options.

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

Re: [Refdb-users] RefDB's source code organisation

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

Torsten Bronger writes:
 > Good.  What are the dependencies *within* the above tarballs?  First
 > I though that all tarballs simply depend on refdb, so I packaged it
 > first.  Then, I found an SRU server in refdb-0.9.9.tar.gz, but the
 > Perl code for this is (probably) in RefDB-SRU-0.7.tar.gz.  So what
 > depends on what?
 > 

That wasn't exactly easy to untangle. I've created a graph real quick
showing the dependencies:

http://refdb.sourceforge.net/refdb-dependencies.png

External applications or packages are shown in yellow. Perl modules
are shown in red.

Please correct me if there are any problems.

regards,
Markus

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

Re: [Refdb-users] RefDB's source code organisation

[Torsten B. <br...@ph...>]

Hallöchen!

Markus Hoenicka writes:

> Torsten Bronger writes:
>
> [...]
>
>> I'd like to have preferably only one package containing
>> everything.  Unfortunately, RefDB is split into a couple of
>> tarballs (refdb-0.9.9.tar.gz, RefDB-perlmod-1.2.tar.gz,
>> RefDB-Client-1.18.tar.gz, RefDB-SRU-0.7.tar.gz, and
>> refdb-publist-1.1.tar.gz).  What should be packaged?  Since all
>> except the first package are tiny, what was the rationale to have
>> them separately?
>
> The reason to keep them separately was to avoid unnecessary
> dependencies for packaging efforts. [...] Therefore the most
> "Debianish" way might be to provide separate packages for each
> tarball.

Good.  What are the dependencies *within* the above tarballs?  First
I though that all tarballs simply depend on refdb, so I packaged it
first.  Then, I found an SRU server in refdb-0.9.9.tar.gz, but the
Perl code for this is (probably) in RefDB-SRU-0.7.tar.gz.  So what
depends on what?

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

[Refdb-users] RefDB's source code organisation

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

Torsten Bronger writes:
 > Hallöchen!
 > 
 > I package RefDB for Ubuntu in order to make the server insallation
 > easier.  (Maybe eventually I'll upload it to the official Ubuntu
 > archives if nobody objects.)
 > 

This would be greatly appreciated by many users. I keep getting
requests about the outdated Debian repository that we used to have.

 > Apparatently, there used to be a Debianisation but I cannot find it.
 > Where is the old material for Debian/Ubuntu packaging (i.e. the
 > debian/ directory)?
 > 

I've checked the (usually disabled) CVS repository, but I couldn't
find a debian subdirectory. I faintly recall that the developer who
built the Debian packages did so in a local copy. Unfortunately the
debianization appears to be lost.

 > I'd like to have preferably only one package containing everything.
 > Unfortunately, RefDB is split into a couple of tarballs
 > (refdb-0.9.9.tar.gz, RefDB-perlmod-1.2.tar.gz,
 > RefDB-Client-1.18.tar.gz, RefDB-SRU-0.7.tar.gz, and
 > refdb-publist-1.1.tar.gz).  What should be packaged?  Since all
 > except the first package are tiny, what was the rationale to have
 > them separately?
 > 

The reason to keep them separately was to avoid unnecessary
dependencies for packaging efforts. Most of the Perl modules depend on
other modules, some of which weren't packaged for Debian at that
time. Also, I believe that the Debian packaging philosophy encourages
to provide separate packages if there are even remote chances that
they might be installed separately. RefDB's build system allows to
build separate client and server installations for this
reason. Therefore the most "Debianish" way might be to provide
separate packages for each tarball.

regards,
Markus

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

[Refdb-users] RefDB's source code organisation

[Torsten B. <br...@ph...>]

Hallöchen!

I package RefDB for Ubuntu in order to make the server insallation
easier.  (Maybe eventually I'll upload it to the official Ubuntu
archives if nobody objects.)

Apparatently, there used to be a Debianisation but I cannot find it.
Where is the old material for Debian/Ubuntu packaging (i.e. the
debian/ directory)?

I'd like to have preferably only one package containing everything.
Unfortunately, RefDB is split into a couple of tarballs
(refdb-0.9.9.tar.gz, RefDB-perlmod-1.2.tar.gz,
RefDB-Client-1.18.tar.gz, RefDB-SRU-0.7.tar.gz, and
refdb-publist-1.1.tar.gz).  What should be packaged?  Since all
except the first package are tiny, what was the rationale to have
them separately?

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

Re: [Refdb-users] Python, Django, and RefDB

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

Quoting Torsten Bronger <br...@ph...>:

> Hallöchen!
>
> The Python bindings for RefDB are finished, see
> <https://launchpad.net/pyrefdb> (use the 0.8 release).  It is only
> one module, with the single external dependency that "eenc" must be
> in the path.  The API is not complete yet, but it has already done
> much heavy-duty work, so I think it is sensible to mention it here.
> The interface is very pythonic, leading to well-readable code.
>
> It doesn't rely on the very latest SVN version of RefDB.  In fact, I
> don't use it myself.  Instead, it contains workarounds for two or
> three RefDB bugs that I've found.  As soon as there is a release,
> I'll remove the workarounds.
>
>

It's always nice to see progress in terms of interfaces. The Perl and  
Python modules should cover many needs for interactive application  
development.

BTW "eenc" will no longer be required once the next RefDB release is  
out. You'll be able to configure refdbd to use unencrypted passwords,  
if this is safe in your environment. It should be, in most cases, as  
the password encryption used in RefDB merely scares away casual  
sniffers.

Also, many thanks for testing RefDB quite thoroughly, which resulted  
in a couple of valuable bug reports.

regards,
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

[Refdb-users] Python, Django, and RefDB

[Torsten B. <br...@ph...>]

Hallöchen!

The Python bindings for RefDB are finished, see
<https://launchpad.net/pyrefdb> (use the 0.8 release).  It is only
one module, with the single external dependency that "eenc" must be
in the path.  The API is not complete yet, but it has already done
much heavy-duty work, so I think it is sensible to mention it here.
The interface is very pythonic, leading to well-readable code.

It doesn't rely on the very latest SVN version of RefDB.  In fact, I
don't use it myself.  Instead, it contains workarounds for two or
three RefDB bugs that I've found.  As soon as there is a release,
I'll remove the workarounds.


However, Django-RefDB will still take a while because I went in some
wrong directions and had to throw away code more often than usual.
In particular, additional searchable fields as well as performance
have been issues.  Now, I (ab)use extended notes for additional
fields, and I do aggressive caching.  But it will still take a month
or two.

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

[Refdb-users] About the names of reference lists

[Torsten B. <br...@ph...>]

Hallöchen!

The manual says:

    Advanced use of personal reference lists

    ...

    The title and the key are initially identical and have the
    format <username>-<listname>. The username prefix is used to
    create a separate namespace for each user.

However, I can't see this prefix:

refdbc: pickref -b tolle-liste 11
263:tolle-liste
421:'tolle-liste' -> REFERENCE:Bld2006g
999:1 picked:0 skipped:0 failed
refdbc: getnote -t xnote :NCK:~tolle
<?xml version="1.0" encoding="UTF8"?>
<!DOCTYPE xnoteset PUBLIC "-//Markus Hoenicka//DTD Xnote V1.2//EN" "http://refdb.sourceforge.net/dtd/xnote-1.2/xnote.dtd" [
<!ENTITY lt "&#38;#60;">
<!ENTITY gt "&#62;">
<!ENTITY amp "&#38;#38;">
<!ENTITY mdash "&#x2014;">
<!ENTITY lsquo "&#x2018;">
<!ENTITY rsquo "&#x2019;">
]>
<xnoteset>

  <xnote id="306" citekey="tolle-liste" user="drefdbuser1" date="2009-07-27" share="private">
    <title>tolle-liste</title>

    <link type="reference" target="Bld2006g"/>
  </xnote>


</xnoteset>
999:1 retrieved:0 failed

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

Re: [Refdb-users] refdbd error: "Cannot lock tables"

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

Quoting Torsten Bronger <br...@ph...>:

> Sorry, this was a mistake on my side.

Except for the fact that refdbd should fail gracefully and provide  
useful diagnostics. I'll look into this.

regards,
Markus



-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

Re: [Refdb-users] refdbd error: "Cannot lock tables"

[Torsten B. <br...@ph...>]

Hallöchen!

Torsten Bronger writes:

> I fail to pick references to a references list.  refdbd responds
> with "228: cannot lock tables", and the log ends with the attached
> messages.  Is there a remedy or do I have to reset the database?

Sorry, this was a mistake on my side.  The listname (-b option) was
empty.

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

Re: [Refdb-users] refdbd error: "Cannot lock tables"

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

Quoting Torsten Bronger <br...@ph...>:

> Hallöchen!
>
> I fail to pick references to a references list.  refdbd responds
> with "228: cannot lock tables", and the log ends with the attached
> messages.  Is there a remedy or do I have to reset the database?
>
[...]

> pickref -b  -d biblio -E utf-8 -u drefdbuser1 -w ******* 6

Does it help to specify the listname with the -b option? Otherwise  
refdbd doesn't know which list to use, and probably gets confused.

regards,
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

[Refdb-users] refdbd error: "Cannot lock tables"

[Torsten B. <br...@ph...>]

Hallöchen!

I fail to pick references to a references list.  refdbd responds
with "228: cannot lock tables", and the log ends with the attached
messages.  Is there a remedy or do I have to reset the database?

Tschö,
Torsten.


try to read from client
serving client on fd 5 with protocol version 6
201-69-19-36
send pseudo-random string to client
pickref -b  -d biblio -E utf-8 -u drefdbuser1 -w ******* 6
dbi is up
localhost
drefdbuser1
**********

5432
pgsql
/usr/local/var/lib/refdb/db
UTF-8
refdb
connected to database server using database:
refdb
Main database looks ok:
refdb
localhost
drefdbuser1
********

5432
pgsql
/usr/local/var/lib/refdb/db
UTF-8
refdb
parent removing client on fd 5
server waiting n_max_fd=4
connected to database server using database:
refdb
BEGIN WORK
FEHLER:  Relation »t_refdb« existiert nicht

LOCK TABLE t_refdb IN SHARE MODE
cannot lock tables
child finished client on fd 5
child exited with code 1
server waiting n_max_fd=4

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

Re: [Refdb-users] About result messages

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

Quoting Torsten Bronger <br...@ph...>:

> Hallöchen!
>
> Is the syntax of result messages documented somewhere?  For example,
> after having added a link I get
>
> 421:1:reference:Bld2006
> 406:1:django-refdb-users-with-offprint-Bld2006
> 413:1
>
> and since this part of my code relies exclusively on reverse
> engineering, I try to sort it out once and for all.
>
> Actually, I'm only interested in collecting citation keys of
> updated/added references/notes.  If I remember correctly, this is
> not always the 406 entry.
>

I'm afraid the syntax is not yet documented. However, the result/error  
codes are documented:

http://refdb.sourceforge.net/manual/ch23s03.html#sect-statusmessages

All messages start with the result code, and the fields are separated  
by colons. I'll have to collect the messages of all available commands  
and document what else they return. Your reverse engineering approach  
is likely to work though, as I don't see any reason to change these  
messages, except by appending additional information.

regards,
Markus


-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

[Refdb-users] About result messages

[Torsten B. <br...@ph...>]

Hallöchen!

Is the syntax of result messages documented somewhere?  For example,
after having added a link I get

421:1:reference:Bld2006
406:1:django-refdb-users-with-offprint-Bld2006
413:1

and since this part of my code relies exclusively on reverse
engineering, I try to sort it out once and for all.

Actually, I'm only interested in collecting citation keys of
updated/added references/notes.  If I remember correctly, this is
not always the 406 entry.

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...
                                  or http://bronger-jmp.appspot.com

Re: [Refdb-users] can't install in in debian lenny

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

Quoting Piter_ <x....@gm...>:

> Err http://refdb.sourceforge.net stable/main Packages
>   404 Not Found
> Err http://refdb.sourceforge.net stable/main Packages
>   404 Not Found
>

Hi,

unfortunately our Debian repository has been unmaintained for a while,  
and it would probably be wise to shut it down until someone steps up  
to pick up the pieces. I'm not sufficiently familiar with the Debian  
tools to be sure, but I suspect that apt-get tries to find packages  
for the current Debian version where the repository only has packages  
for 4.0 (or 3.1? not sure how to find out).

In any case the packages are outdated and I don't recommend to use  
them. I've installed RefDB on several versions of Debian in the past  
without problems. I'd suggest to use either the latest source tarball  
or the SVN version and build RefDB from the sources. Let me know if  
you're not familiar with building and installing from the sources. I  
have a Debian box at home with RefDB installed, so I could send you a  
working configure command line.

regards,
Markus


-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

[Refdb-users] can't install in in debian lenny

[Piter_ <x....@gm...>]

Hi all.
I have added this lines into my sources file:

deb http://refdb.sourceforge.net/debian/release *stable* main
deb http://refdb.sourceforge.net/debian/addons *stable* main
And after apt-get update i have this message:

Hit http://ftp.de.debian.org lenny/main Packages
Ign http://refdb.sourceforge.net stable Release.gpg
Hit http://ftp.de.debian.org lenny/non-free Packages
Hit http://ftp.us.debian.org lenny Release
Hit http://ftp.de.debian.org lenny/contrib Packages
Ign http://ftp.us.debian.org lenny/main Packages/DiffIndex
Ign http://ftp.us.debian.org lenny/main Sources/DiffIndex
Hit http://ftp.us.debian.org lenny/main Packages
Hit http://ftp.us.debian.org lenny/main Sources
Ign http://refdb.sourceforge.net stable/main Translation-en_US
Ign http://refdb.sourceforge.net stable Release.gpg
Ign http://refdb.sourceforge.net stable/main Translation-en_US
Ign http://refdb.sourceforge.net stable Release
Ign http://refdb.sourceforge.net stable Release
Ign http://refdb.sourceforge.net stable/main Packages
Ign http://refdb.sourceforge.net stable/main Packages
Ign http://refdb.sourceforge.net stable/main Packages
Ign http://refdb.sourceforge.net stable/main Packages
Err http://refdb.sourceforge.net stable/main Packages
  404 Not Found
Err http://refdb.sourceforge.net stable/main Packages
  404 Not Found

Thanks for help.