refdb-users — List for RefDB users

[Refdb-users] ANN: refdb-0.9.4-pre5 available

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

Hi all,

the mailing lists seem to be back up again. This gives me a chance to
announce the next prerelease. pre4 had a couple of serious bugs
related to adding notes, plus some serious build problems on
non-Linux/BSD platforms related to the new iconv support. Please
discontinue any tests with that release. Things can only get better.

http://refdb.sourceforge.net/pre/refdb-latest.tar.gz

Otherwise, all things said for pre4 still apply.

Cygwin users please note that pre5 will probably not build on your 
installation. If you get spurious compiler errors, please use the
current configure.in from CVS, run ./autogen.sh, and then the usual
configure && make && make install.

regards,
Markus

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

[Refdb-users] Newbie Question

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

Jochen Witte writes:
 > Hello,
 > 
 > I just play around with refdb using 0.9.4-2 qith mysql as backend.
 > When trying to add entries to the database I get the following in
 > refdb-log (after importing refdb.dump and empty.mysql.dump into the DB)
 > 

First of all I'd ask you to use either 0.9.4-pre1 (essentially a
bugfix for 0.9.3 with no new features) or 0.9.4-pre5. Everything
inbetween is in various stages of being broken.

pre5 is available, as usual, right here:

http://refdb.sourceforge.net/pre/refdb-latest.tar.gz


 > ---snip---
 > /usr/local/refdb-0.94/share/refdb/db
 > connected to database server using database:
 > refdb1
 > SELECT * FROM t_keyword
 > no IDs found for keyword scan
 > child finished client on fd 5
 > child exited with code 0
 > server waiting n_max_fd=4
 > ---snip---
 > 
 > What have I done wrong?
 > 

This depends on the command you've used and on the type of data
(except it's a real bug in pre2). Possible reasons for an addref
failure are:

- You've attempted to add invalid risx data
- You've attempted to add risx data withouth telling refdbc; it will
  assume ris then
- You've found a particular dataset that happens to crash the app

In order to find out what's going wrong, you should always do the
following:

- run refdbd with a log level of 7 (-l 7 on the command line or set
  loglevel in refdbdrc appropriately)

- start with a clean database and try to isolate the minimum amount of
  data to reproduce the problem.

- send the log and the dataset that caused the failure to the list. If
  the mysql log contains suspicious messages, please send these too.

This will give me a chance to reproduce and fix the problem if it is
not a pilot error.

regards,
Markus

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

[Refdb-users] Newbie Question

[Jochen W. <jw...@al...>]

Hello,

I just play around with refdb using 0.9.4-2 qith mysql as backend.
When trying to add entries to the database I get the following in
refdb-log (after importing refdb.dump and empty.mysql.dump into the DB)

---snip---
/usr/local/refdb-0.94/share/refdb/db
connected to database server using database:
refdb1
SELECT * FROM t_keyword
no IDs found for keyword scan
child finished client on fd 5
child exited with code 0
server waiting n_max_fd=4
---snip---

What have I done wrong?

Greetings Jochen
-- 
Jochen Witte <jw...@al...>

[Refdb-users] Mac OS X

[Bruce D'A. <bd...@fa...>]

For anyone out there trying to build RefDB on Mac OS X:

1)  I think better to make sure you're running Panther.

2)  More importantly, install lidbi and driver(s) via Fink.   In fact, 
install everything possible with Fink, including the Perl stuff.  This 
command ought to then work:

./configure --with-libdbi-lib=/sw/local/lib/libdbi.dylib 
--with-expat-lib=/sw/lib 
--with-docbook-xsl=/Users/darcusb/Stylesheets/XSLT/docbook/docbook-xsl 
--with-db-server=sqlite 
--with-tei-xsl=/Users/darcusb/Stylesheets/XSLT/TEI CFLAGS="-L/sw/lib 
-I/sw/include"

SQlite is certainly the easiest route.

Bruce

[Refdb-users] undefined refs to _iconv on Cygwin

[Michael S. <sm...@xm...>]

Hi Markus,

You wrote:

> Hi Mike,
> 
> you're facing two problems:
> 
> - you're using an outdated libdbi version. The whole character
>   conversion stuff relies on a libdbi function that I've added to the
>   latest release only. You'll have to install libdbi-0.7.2 and
>   libdbi-drivers-0.7.1 before RefDB will compile.

Oops -- OK, sorry for the noise about that one. I'll update my kit.

> - for some reason, configure does not perform the libiconv test
>   properly. The ld commands show that there's no attempt to link
>   against libiconv, hence the unresolved iconv* function calls. Could
>   you please check what configure says about libiconv?

I've attached the whole config.log file. The relevant portion seems to be:

  configure:1825: gcc -o conftest  -L/usr/local/lib   conftest.c -lz   1>&5
  configure:1848: checking for library containing iconv
  configure:1866: gcc -o conftest  -L/usr/local/lib   conftest.c  1>&5
  /tmp/ccc0H8V0.o(.text+0x1f):conftest.c: undefined reference to `_iconv'
  collect2: ld returned 1 exit status
  configure: failed program was:
  #line 1855 "configure"
  #include "confdefs.h"
  /* Override any gcc2 internal prototype to avoid an error.  */
  /* We use char because int might match the return type of a gcc2
      builtin and then its argument prototype would still apply.  */
  char iconv();

  int main() {
  iconv()
  ; return 0; }
  configure:1888: gcc -o conftest  -L/usr/local/lib   conftest.c -liconv   1>&5
  /tmp/ccy8e5Fc.o(.text+0x1f):conftest.c: undefined reference to `_iconv'
  collect2: ld returned 1 exit status
  configure: failed program was:
  #line 1877 "configure"
  #include "confdefs.h"
  /* Override any gcc2 internal prototype to avoid an error.  */
  /* We use char because int might match the return type of a gcc2
      builtin and then its argument prototype would still apply.  */
  char iconv();

  int main() {
  iconv()
  ; return 0; }

> I've tested the latest prerelease on FreeBSD 4.7 and Debian 3.0
> without any problems. I hope we can resolve these issues on the other
> platforms asap.

This one definitely seems to be a Cygwin-specific problem. The only
problem I saw on Debian was because I hadn't updated my libdbi install.

  --Mike

> Michael Smith writes:
>  > Markus,
>  > 
>  > I just updated by sandboxes and am now getting similar "undefined
>  > reference to `_libiconv_close'" build errors on Cygwin, along with an
>  > "undefined reference to `_dbi_conn_get_encoding'" on both Cygwin and
>  > Debian ('make' logs attached).
>  > 
>  > On Cygwin, looks like the libiconv library and headers are in the normal
>  > lib and include directories -
>  > 
>  >   /lib/libiconv.a
>  >   /lib/libiconv.dll.a
>  >   /lib/libiconv.la
>  >   /usr/lib/libiconv.a
>  >   /usr/lib/libiconv.dll.a
>  >   /usr/lib/libiconv.la
>  > 
>  >   /usr/include/iconv.h
>  > 
>  > I shouldn't need to tell make to go looking for them there, right?

[Refdb-users] Newbie Question

[Jochen W. <jw...@al...>]

Hello,

I just play around with refdb using 0.9.4-2 qith mysql as backend.
When trying to add entries to the database I get the following in
refdb-log (after importing refdb.dump and empty.mysql.dump into the DB)

---snip---
/usr/local/refdb-0.94/share/refdb/db
connected to database server using database:
refdb1
SELECT * FROM t_keyword
no IDs found for keyword scan
child finished client on fd 5
child exited with code 0
server waiting n_max_fd=4
---snip---

What have I done wrong?

Greetings Jochen

[Refdb-users] forwarded message from Markus Hoenicka

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

[apologies if it's a duplicate, but the list apparently swallowed
yesterday's posts]

[Refdb-users] forwarded message from Markus Hoenicka

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

[apologies if it's a duplicate, but the list apparently swallowed
yesterday's posts]

[Refdb-users] refdbc getref message

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

Diwaker Gupta writes:
 > Hi everyone,
 > 
 > I managed to compile and setup 0.9.4-pre4 on my machine. I've added a 
 > bunch of references as well, and things look fine. However, when I try 
 > to issue a getref ":ID:>0" for instance, I keep getting a "cannot set 
 > conversion descriptor" method
 > 

Ok, we're looking at a brand new feature here, and it might have some
rough edges. Over here things work fine, but perhaps it's just my
weird setup.

My questions:

- What encoding does the database use? If you're not sure, run
  refdbc:whichdb, this will tell you.

- does it help to specifically request an output encoding like this:
  getref :ID:>0 -E UTF-8

If that doesn't get us any further, I'll send you a debug version of
one of the source files to see what happens.

regards,
Markus

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

Re: [Refdb-users] Problems compiling pre4

[Michael S. <sm...@xm...>]

Hi Markus,

You wrote:

> Hi Mike,
> 
> you may have noticed that the SF lists are broke currently. I'm not
> sure whether my previous replies ever made it to your inbox.

At least one did, and I replied, but I guess the list sidelined it.

> In any case, I had a second look at your Cygwin log output and noticed
> something pretty strange:
> 
> refdbdnote.o(.text+0x5926):refdbdnote.c: undefined reference to `_dbi_conn_get_e
> ncoding'
> refdbdnote.o(.text+0x599c):refdbdnote.c: undefined reference to `_libiconv_close
> '
> 
> The first line is ok and looks as expected if a library function is
> missing (you have an old libdbi version). The second line should
> complain about an undefined reference to "_iconv_close", not
> "_libiconv_close". However I could not find any hint in the Cygwin
> mailing lists about any oddities of libiconv on this platform. I'll
> check myself on Monday when I'll get my hands on a Windoze box again.

Attached is a copy of the iconv.h file from my Cygwin environment. If
you look at that, there are some #ifdefs in there like this:

  #ifndef LIBICONV_PLUG
  #define iconv_close libiconv_close
  #endif

I actually tried temporarily replacing the iconv.h with a copy that had
that stuff commented out, but even then refdb wouldn't build.

Also attached is a copy of my config.log for the build. 
> 
> I also ran another test on a Debian box. Linux apparently has the
> iconv stuff built into libc, that's why it is not necessary to link
> against libiconv. RefDB works allright on Debian 3.0 for me.

Yeah, I reckon that once I update my libdbi kit on Debian, I won't have
any problems on Debian either. But the Cygwin stuff still has me stumped.

  --Mike

> Michael Smith writes:
>  > Markus,
>  > 
>  > I just updated by sandboxes and am now getting similar "undefined
>  > reference to `_libiconv_close'" build errors on Cygwin, along with an
>  > "undefined reference to `_dbi_conn_get_encoding'" on both Cygwin and
>  > Debian ('make' logs attached).
>  > 
>  > On Cygwin, looks like the libiconv library and headers are in the normal
>  > lib and include directories -
>  > 
>  >   /lib/libiconv.a
>  >   /lib/libiconv.dll.a
>  >   /lib/libiconv.la
>  >   /usr/lib/libiconv.a
>  >   /usr/lib/libiconv.dll.a
>  >   /usr/lib/libiconv.la
>  > 
>  >   /usr/include/iconv.h
>  > 
>  > I shouldn't need to tell make to go looking for them there, right?

Re: [Refdb-users] ANN: refdb-0.9.4-pre4 available for testing

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

Bruce D'Arcus writes:
 > This never got to the list I guess...
 > 

Yeah, all SourceForge lists seem to be broke since Friday. We'll have
to at least cc to our private addresses until this is fixed.

 > 
 > OK, below's what I get at the end of the build process.
 > 
 > ld: warning prebinding disabled because of undefined symbols
 > ld: Undefined symbols:
 > _dbi_conn_get_encoding

This is due to an outdated libdbi version. For all that fancy encoding
stuff you need the latest libdbi and libdbi-drivers. A quick glance at
Fink tells me that Peter has updated his packages (in
unstable). There's even a sqlite driver available now.
 
 > _libiconv
 > _libiconv_close
 > _libiconv_open
 > make[2]: *** [refdbd] Error 1
 > make[1]: *** [all] Error 2
 > make: *** [all-recursive] Error 1
 > 
 > Here's my config command:
 > 
 > ./configure --with-libdbi-lib=/usr/local/lib/libdbi.0.0.5.dylib 
 > --with-expat-lib=/sw/lib 
 > --with-docbook-xsl=/Users/darcusb/Stylesheets/XSLT/docbook/docbook-xsl 
 > --with-db-server=sqlite 
 > --with-tei-xsl=/Users/darcusb/Stylesheets/XSLT/TEI CFLAGS="-L/sw/lib 
 > -I/sw/include"
 > 
 > What going on?   Maybe it has something to do with this, but I've no 
 > idea how to fix it:
 > 
 > 	checking for library containing iconv... no
 > 
 > I have these files in /sw/lib:
 > 
 > -rw-r--r--  1 root  admin  1112828  3 Dec 10:03 libiconv.2.2.0.dylib
 > -rw-r--r--  1 root  admin  1112828  3 Dec 10:01 libiconv.2.dylib
 > lrwxr-xr-x  1 root  admin       20  3 Dec 09:59 libiconv.dylib -> 
 > libiconv.2.2.0.dylib
 > -rw-r--r--  1 root  admin      785 13 Nov 16:58 libiconv.la
 > 

This looks a bit odd to me. First of all, there is no libiconv.a which
is required to build apps using libiconv. Second, the version number
strikes me odd as well, as all that Fink has to offer is 1.9.1. Please
try to (re-)install the libiconv, libiconv-bin, and libiconv-dev Fink
packages and see whether this helps. Your configure command should be
ok for this as it adds /sw/lib to the linker search path anyway.

regards,
Markus

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

Re: [Refdb-users] ANN: refdb-0.9.4-pre4 available for testing

[Bruce D'A. <bd...@fa...>]

On Jan 22, 2004, at 3:21 PM, Markus Hoenicka wrote:

>> dbd_sqlite.c:446: error: `sqlite' undeclared (first use in this
>> function)
>
> This sounds like the sqlite.h header file is missing or not in the
> compiler search path. How did you install sqlite? As a package or did
> you build it yourself? Can you scan your HD and see whether you've got
> this header in some dusty corner?

I built myself, and made a dumb mistake (was in a hurry).  FYI, this 
command works, using the Fink SQLite installation paths.

./configure --with-sqlite --with-sqlite-dir="/sw/bin" 
--with-sqlite-incdir="/sw/include" --with-sqlite-libdir="/sw/lib"

I've not yet tested the result though.  It's a bit difficult to keep 
up-to-date with these releases when I've got so much else going on...

Bruce

Re: [Refdb-users] cannot add records!

[Bruce D'A. <bd...@fa...>]

Re: this web interface:

On Jan 22, 2004, at 10:08 PM, Matt Price wrote:

> It's more or less live on the web at:
>
> http://www.racesci.org/bibliographies/dataBase/dbQuery.php
>
> you can see there are one or two parsing issues to work out still
> (quotation marks in titles, I notice).  but the code produced here is 
> much
> close to what I want than the html that refdb produces natively...
> hence my attraction.

The underling HTML code is a little ugly, but the outward appearance is 
nice enough.  All you really need is a way to get back some (X)HTML 
code that has formatted references, each of them wrapped in a div 
element with a class attribute.  That way you can do all the styling 
with CSS.  I'm even willing to help there if need be.  I've actually 
been playing with CSS + XSLT rendering of this stuff with the eXist XML 
DB, which uses Cocoon.  They thing is that it is using XSLT to 
transform XML (in this case MODS) into HTML, and then CSS is doing 
almost all the formatting work.

Bruce

PS - The "submit" button at the bottom of the screen is confusing 
(shouldn't it say "view"?).

Re: [Refdb-users] Problems compiling pre4

[Michael S. <sm...@xm...>]

Markus,

I just updated by sandboxes and am now getting similar "undefined
reference to `_libiconv_close'" build errors on Cygwin, along with an
"undefined reference to `_dbi_conn_get_encoding'" on both Cygwin and
Debian ('make' logs attached).

On Cygwin, looks like the libiconv library and headers are in the normal
lib and include directories -

  /lib/libiconv.a
  /lib/libiconv.dll.a
  /lib/libiconv.la
  /usr/lib/libiconv.a
  /usr/lib/libiconv.dll.a
  /usr/lib/libiconv.la

  /usr/include/iconv.h

I shouldn't need to tell make to go looking for them there, right?

  --Mike

Markus Hoenicka <mar...@mh...> writes:

> Diwaker Gupta writes:
>  > undefined reference to `libiconv_close'
>  > collect2: ld returned 1 exit status
> 
> Unfortunately you chopped off the interesting part of the make output
> in your message. It would be helpful to see the linker command that
> make issued at that point as it lists the directories that ld checks
> for development libraries. All these error messages essentially mean
> that ld can't find the libiconv development library. You'll either
> have to fiddle with LD_LIBRARY_PATH and such, or add an appropriate
> LDFLAGS variable to the configure command line. The chapter 4 of the
> manual, section "OS specific hints", has a few examples how to do
> this.
> 
> regards,
> Markus
> 

-- 
Michael Smith
Openwave Systems Japan     +81 90 9148 0269 (mobile)
Nishishinjuku 6-22-1       +81  3 5909 6347 (office)
Tokyo, Japan 163-1117      +81  3 5909 6241 (fax)

[Refdb-users] Re: refdb-mode problems [was: cannot add records!]

[Michael S. <sm...@xm...>]

Hi Matt,

You wrote:

[...]

> speaking of the Emacs front-end -- do you mean refdb-mode?

Yeah, I'm sure that's what Markus was referring to. I take all the blame
for it and hope you can manage to get it working so I can get more
feedback about it :-)

> I haven't for the life of me been able to get it to work, is it
> compatible with 0.9.3-pre3?

No, I don't think it's compatible, though just now I can't remember
exactly why it's not compatible and have never actually tested it with
anything but 0.9.4. Is there any way you can try using refdb-mode with
the latest 0.9.4 pre-release?

> I keep thinking I'm missing something in the 'customize' window, but
> can't figure out what it is.  whenever I try to 'getref' on my
> database, I get the error 'could not connect to database server'...

Hmm, that's bad.

Do you have a password specified in your ‾/.refdcrc file? I'm wondering
if it might be failing because refbdc is emitting an interactive prompt
for a password or something.

Anyway, there's nothing you could change in the refdb-mode customization
to fix that. All that refdb-mode does is call the refdbc command-line
utility. So if you can run refdbc from the command line without getting
errors, it seems like you should be able to get refdb-mode working.

Off the top of my head, other than the password thing, the only other
thing I can think of is maybe a username problem. refdb-mode doesn't run
refdc with the -u <username> option, and doesn't yet actually provide
any way to specify a username (because in my testing, I've never needed to).

> and I can't find any documentation on refdb-mode.

The documentation, such as it is, is in the refdb-mode.el file itself.
But I don't think there's anything there that will help you fix your
problem. There's nothing you can tune within refdb-mode that will
affecte whether or not refdbc connects to refdbd successfully.

> Do you have any advice?

Install the latest 0.9.4 release and test with that ;) Short of that, if
you can send me output of your Emacs *Messages* buffer, that'll show me
what Emacs is trying to do at the point where it fails.

Also, if I knew what OS you're running your Emacs on and what Emacs
version you're running, that might help. I've personally tested it only
on Debian Linux and Cygwin, so there might be some platform-related
problems that nobody else has run into so far.

Anyway, I hope and can manage to help you get it working.

  --Mike

[Refdb-users] refdbc getref message

[Diwaker G. <dg...@cs...>]

Hi everyone,

I managed to compile and setup 0.9.4-pre4 on my machine. I've added a 
bunch of references as well, and things look fine. However, when I try 
to issue a getref ":ID:>0" for instance, I keep getting a "cannot set 
conversion descriptor" method

Any ideas?
Diwaker
-- 
Diwaker Gupta
Graduate Student, Computer Sc. and Engg.
University of California, San Diego
<http://www.cse.ucsd.edu/users/dgupta>

Re: [Refdb-users] cannot add records!

[Matt P. <mat...@ut...>]

On Thu, Jan 22, 2004 at 07:11:49AM -0500, Bruce D'Arcus wrote:
> Actually, if you like PHP, why not port the PerlClient module to PHP?  
> From what I gather from Markus, this ought to be pretty simple to do, 
> and I know a few people who have passed through here have been 
> interested in just that.  Maybe they could help if they're still 
> around?
> 
> Oh, and you should learn XSLT; it's quite useful ;-)

ok, ok, let me just work through php and bask scripting for a little
while first!  

m

Re: [Refdb-users] cannot add records!

[Matt P. <mat...@ut...>]

It's more or less live on the web at: 

http://www.racesci.org/bibliographies/dataBase/dbQuery.php

you can see there are one or two parsing issues to work out still
(quotation marks in titles, I notice).  but the code produced here is much
close to what I want than the html that refdb produces natively...
hence my attraction.  

On the other hand, refdb is way more powerful than this bib, which
works with a 1-table mysql db. 


matt

On Thu, Jan 22, 2004 at 09:26:12PM -0500, Bruce D'Arcus wrote:
> 
> On Jan 22, 2004, at 9:01 PM, Matt Price wrote:
> 
> >The reason I had thought to query directly from php was simply that 
> >the scripts my friend has written make beautiful html for a wide 
> >variety of reference types already...
> 
> Any screenshots available Matt?  Am curious...
> 
> Bruce
> 
> 
> 
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Refdb-users mailing list
> Ref...@li...
> https://lists.sourceforge.net/lists/listinfo/refdb-users
> 

Re: [Refdb-users] cannot add records!

[Bruce D'A. <bd...@fa...>]

On Jan 22, 2004, at 9:01 PM, Matt Price wrote:

> The reason I had thought to query directly from php was simply that 
> the scripts my friend has written make beautiful html for a wide 
> variety of reference types already...

Any screenshots available Matt?  Am curious...

Bruce

Re: [Refdb-users] cannot add records!

[Matt P. <mat...@ut...>]

On Thu, Jan 22, 2004 at 09:16:41PM +0100, Markus Hoenicka wrote: 

> I think I've mentioned it previously, but I wouldn't access the
> database directly from your PHP code. In order to make best use of the
> data you'd have to implement a lot of wacky SQL queries which are now
> nicely encapsulated in refdbd. Instead you should use the Perl client
> library, if possible (can PHP do this?), or call the command-line
> clients from your PHP code via system(). The Emacs front-end does the
> latter btw and works quite well.

weeeellll...  I guess I can just get the info via getref etc.  The
reason I had thought to query directly from php was simply that the
scripts my friend has written make beautiful html for a wide variety
of reference types already; I was hoping to get away with minimal
modification.  But the structure of the refdb database IS pretty
complex, and I guess the SQL wouldn't be all that easy to write.  

so, I will take another look at the getref docs and see what kind of
formats it can write to.  hopefully it will be pretty easy to pass its
output back to php as an array... or I'll see about referencing the
perclient stuff from php.  I think I would just need to write a little
perl script that accepts an array, passes it to refdb, then grabs
something else back...  shouldn't be impossible, anyway.

speaking of the Emacs front-end -- do you mean refdb-mode?  I haven't
for the life of me been able to get it to work, is it compatible with
0.9.3-pre3?  I keep thinking I'm missing something in the 'customize'
window, but can't figure out what it is.  whenever I try to 'getref'
on my database, I get the error 'could not connect to database
server'...  and I can't find any documentation on refdb-mode.  Do you
have any advice?

Anywy, thanks,

matt

> 
> regards,
> Markus
> 

Re: [Refdb-users] ANN: refdb-0.9.4-pre4 available for testing

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

Bruce D'Arcus writes:
 > On Jan 21, 2004, at 8:51 PM, Markus Hoenicka wrote:
 > 
 > > This release requires the brand-new libdbi-0.7.2 and
 > > libdbi-drivers-0.7.1 versions released last weekend.
 > 
 > Markus -- any update on the libdbi situation on OS X?
 > 

I'm sorry about this, but I've forgotten to ping Peter and see whether
he wants to update his fink packages. I sent him a note a couple of
minutes ago, though.

 > I had thought maybe the combination of a new release and a new OS would 
 > solve the problems, but while libdbi itself built fine, I get these 
 > errors when trying to build the drivers:
 > 

Which problems in particular are you talking about?


 > dbd_sqlite.c:446: error: `sqlite' undeclared (first use in this 
 > function)

This sounds like the sqlite.h header file is missing or not in the
compiler search path. How did you install sqlite? As a package or did
you build it yourself? Can you scan your HD and see whether you've got
this header in some dusty corner?

regards,
Markus

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

Re: [Refdb-users] cannot add records!

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

Hi Matt,

Matt Price writes:
 > welll..  I guess I need to figure out whether I most want to learn c, XSLT,
 > or Perl...!  I actually have an interim solution in PHP that I should
 > be able to throw together pretty quickly (stealing someone else's
 > code, and adapting it to the refdb db structure; this will be
 > mysql-specific, but should be readily adaptable to PostgreSQL with a
 > quick pattern-replace on the php code).  When it's more or
 > less working I'll let folks know.   
 > 

I think I've mentioned it previously, but I wouldn't access the
database directly from your PHP code. In order to make best use of the
data you'd have to implement a lot of wacky SQL queries which are now
nicely encapsulated in refdbd. Instead you should use the Perl client
library, if possible (can PHP do this?), or call the command-line
clients from your PHP code via system(). The Emacs front-end does the
latter btw and works quite well.

regards,
Markus

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

[Refdb-users] Problems compiling pre4

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

Diwaker Gupta writes:
 > undefined reference to `libiconv_close'
 > collect2: ld returned 1 exit status

Unfortunately you chopped off the interesting part of the make output
in your message. It would be helpful to see the linker command that
make issued at that point as it lists the directories that ld checks
for development libraries. All these error messages essentially mean
that ld can't find the libiconv development library. You'll either
have to fiddle with LD_LIBRARY_PATH and such, or add an appropriate
LDFLAGS variable to the configure command line. The chapter 4 of the
manual, section "OS specific hints", has a few examples how to do
this.

regards,
Markus

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

Re: [Refdb-users] ANN: refdb-0.9.4-pre4 available for testing

[Bruce D'A. <bd...@fa...>]

On Jan 21, 2004, at 8:51 PM, Markus Hoenicka wrote:

> This release requires the brand-new libdbi-0.7.2 and
> libdbi-drivers-0.7.1 versions released last weekend.

Markus -- any update on the libdbi situation on OS X?

I had thought maybe the combination of a new release and a new OS would 
solve the problems, but while libdbi itself built fine, I get these 
errors when trying to build the drivers:

dbd_sqlite.c:446: error: `sqlite' undeclared (first use in this 
function)
dbd_sqlite.c:446: error: parse error before ')' token
dbd_sqlite.c:458: error: parse error before ')' token
dbd_sqlite.c: In function `find_result_field_types':
dbd_sqlite.c:631: error: `sqlite' undeclared (first use in this 
function)
dbd_sqlite.c:631: error: parse error before ')' token
dbd_sqlite.c:641: error: parse error before ')' token
dbd_sqlite.c: In function `dbd_select_db':
dbd_sqlite.c:832: error: `sqlite' undeclared (first use in this 
function)
dbd_sqlite.c:832: error: parse error before ')' token
dbd_sqlite.c: In function `dbd_get_seq_last':
dbd_sqlite.c:860: error: `sqlite' undeclared (first use in this 
function)
dbd_sqlite.c:860: error: parse error before ')' token
make[3]: *** [dbd_sqlite.lo] Error 1
make[2]: *** [all-recursive] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive-am] Error 2

Re: [Refdb-users] cannot add records!

[Bruce D'A. <bd...@fa...>]

Actually, if you like PHP, why not port the PerlClient module to PHP?  
 From what I gather from Markus, this ought to be pretty simple to do, 
and I know a few people who have passed through here have been 
interested in just that.  Maybe they could help if they're still 
around?

Oh, and you should learn XSLT; it's quite useful ;-)

Bruce

On Jan 22, 2004, at 5:02 AM, Matt Price wrote:

> I guess I need to figure out whether I most want to learn c, XSLT,
> or Perl...!  I actually have an interim solution in PHP that I should
> be able to throw together pretty quickly (stealing someone else's
> code, and adapting it to the refdb db structure; this will be
> mysql-specific, but should be readily adaptable to PostgreSQL with a
> quick pattern-replace on the php code).  When it's more or
> less working I'll let folks know.
>
> Then maybe later I can, like, hire someone to translate it into Perl
> and use the PerlClient functions to interact directly with refdbc.