Re: [Refdb-users] can't create database conn struct

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

Hi,

Antti Vanne writes:
 > I tried the 0.9.3-pre5, and got a notch further:
 > 
 > connected to database server using database:
 > refdb1
 > SELECT VERSION()
 > 

Is that really the end of refdbd's log output? This would mean it
crashes right away. The whole log output of a viewstat command looks
like this on my box:

server waiting n_max_fd=4
try to read from client
serving client on fd 5 with protocol version 1
102-86-47-14
send pseudo-random string to client
viewstat  -u root -w 102073083099101051051
dbi_driver_dir went to:

dbi is up using default driver dir
localhost
root
xxx

5432
mysql

connected to database server using database:
refdb1
SELECT VERSION()
command processing done, finish dialog now
child finished client on fd 5
child exited with code 0
server waiting n_max_fd=4


 > this is refdbd's output when viewstat is run and this is from the rfdba 
 > screen:
 > 
 > refdba: viewstat
 > 
 > Connected via mysql driver (dbd_mysql v0.6.7)
 > to: ERROR
 > serverip: localhost
 > timeout: 60
 > dbs_port: 3306
 > logfile: /var/log/refdbd.log
 > logdest: 0
 > loglevel: 7
 > remoteadmin: off
 > pidfile: /var/run/refdbd.pid
 > 
 > So I guess it almost works now :)  However, trying for example 
 > "listword" gives me:
 > 

I beg to differ. The "ERROR" thing above means that libdbi cannot
execute the simple query "SELECT VERSION()" properly. If your make
check results in libdbi wouldn't tell me otherwise, I'd say libdbi is
broke on your box.

 > connected to database server using database:
 > refdb1
 > SELECT DISTINCT name FROM t_journal_words WHERE name RLIKE '.*'
 > 
 > and
 > 
 > refdba: listword
 > ERROR
 > 
 > aborting...
 > could not read from refdbd. Stop
 > 
 > This in the refdba prompt.
 > 

This again would point to a refdbd crash. I've never seen this on any
of my platforms.

 > > As for the failed connection, the most likely reason is that you run
 > > your mysqld with the --skip-networking option (or the corresponding entry
 > > in my.cnf). refdbd always uses TCP/IP even when it talks to a database
 > > server on the local machine.
 > 
 > I start the mysqld from the standard mdk /etc/init.d/mysql, and nmapping 
 > localhost shows that 3306 is open and I can also telnet localhost 3306 
 > just fine. So this is like it should be right?
 > 

Yeah, this looks ok to me.

I'm at a loss how to debug this problem. It just looks weird to
me. Did you build your libdbi from the sources or did you use some
RPM's? Did you try building and installing again from scratch?

regards,
Markus

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