refdb-users

[Refdb-users] can't connect to server

[Michael B. <mb...@an...>]

Hi,

I just installed refdb, but I can't connect to the database:

If I call viewstat in refdba, it says:

could not connect to database server

In the logfile of refdbd, I find messages like this one:

6:pid=340:Sat Dec 14 13:18:23 2002:adding client on fd 6
6:pid=340:Sat Dec 14 13:18:23 2002:server waiting n_max_fd=6
6:pid=812:Sat Dec 14 13:18:23 2002:serving client on fd 6 with
protocol version 
0
4:pid=812:Sat Dec 14 13:18:23 2002:creating database connection
structure failed
6:pid=812:Sat Dec 14 13:18:23 2002:child finished client on fd 6

In mysql, I am able to see the refdb1 database:
~ $mysqlshow refdb1
Database: refdb1
+-----------------+
|     Tables      |
+-----------------+
| CITSTYLE        |
| POSITIONS       |
| REFSTYLE        |
| SEPARATORS      |
| t_journal_words |
+-----------------+

The mysqld and refdbd are listening on the default ports on
localhost, refdba is configured like this:

refdba: set
serverip 127.0.0.1
port 9734
verbose t
pager less
username root
timeout 60
logfile /var/log/refdba.log
logdest FILE
loglevel INFO
refdblib 

/var/log/refdba.log doesn't contain anything.

Any ideas?

Ciao
  Michael

[Refdb-users] can't connect to server

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

Michael Below writes:
 > Hi,
 > 
 > I just installed refdb, but I can't connect to the database:
 > 
 > If I call viewstat in refdba, it says:
 > 
 > could not connect to database server
 > 
 > In the logfile of refdbd, I find messages like this one:
 > 
 > 6:pid=340:Sat Dec 14 13:18:23 2002:adding client on fd 6
 > 6:pid=340:Sat Dec 14 13:18:23 2002:server waiting n_max_fd=6
 > 6:pid=812:Sat Dec 14 13:18:23 2002:serving client on fd 6 with
 > protocol version 
 > 0
 > 4:pid=812:Sat Dec 14 13:18:23 2002:creating database connection
 > structure failed

This error message is caused by the call:

dbi_conn_new(ptr_clrequest->dbserver)

in refdbda.c. There's essentially two possible causes for the failure
of this call:

1) libdbi is not set up correctly. Did you run make check after
   building libdbi? Please also make sure that you built libdbi with
   the --with-mysql switch as this is required to build the MySQL
   driver. Please check also that the driver is in a standard
   location, like /usr/local/lib/dbd/libmysql.so

2) refdbd is configured incorrectly. Please check the settings in
   /usr/local/etc/refdb/refdbdrc and make sure that you selected mysql
   as the dbserver.

regards,
Markus

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

Re: [Refdb-users] can't connect to server

[Michael B. <mb...@an...>]

Hi Markus,

thanks for your quick reply.  Re-building libdbi solved my
problems with refdba, great!

Now the command line interface seems to work well, I managed to
import my current bibtex database into a refdb database. So I
tried the web interface.  As a web server, I have got boa (Debian
stable version). I think I followed the instructions in the
manual, I am able to call the login page, and I get a confirmation
for a successful login. but if I try to do something, I get an
"500 internal server error", the boa error log says:

[15/Dec/2002:22:03:02 +0000] cgi_header: unable to find LFLF

I had a look at the binaries, but I can't see a difference, both
start with some ELF info. For comparison, file says:

man2html: ELF 32-bit LSB executable, Intel 80386, version 1
(SYSV), dynamically linked (uses shared libs), stripped
/usr/lib/cgi-bin $file bib2ris  
bib2ris: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV),
dynamically linked (uses shared libs), not stripped

Now I stripped the refdb binaries, but that doesn't help...

Any ideas? I am using boa only locally, so I don't have much
experience with it, and the manuals don't tell me how CGI binaries
should be...

Michael Below