[Refdb-users] refdb/mysql problems under Cygwin -- please help

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

Hi Gary,

Gary Lupyan writes:
 > Hi, I've been struggling to get refdb working under Cygwin.  If anyone 
 > could help me get the following issues resolved, I'd be very appreciative.
 > 
 > The main problem seems to be failure of refdbd to communicate propertly 
 > with mySQL (or to relay information to refdba/refdbc)
 > 

I used to have the Cygwin/MySQL combo at some time at my workplace. It
did work so we should get yours to work too. However, is there any
particular reason why you don't use PostgreSQL which is available as a
Cygwin package? This is what I currently run at work and it was pretty
smooth to set up.

 > The mysql daemon works fine from dos.  I was able to create the initial 
 > table structures from refb.dump.  Although I can run mysqld in cygwin (and 
 > it loads up fine), I can't get the comman-line mysqlc to work under cygwin 
 > (although strangely it works in dos), but I think that's not the main issue.
 > 

I'm afraid it is an issue. The MySQL command-line client is a wrapper
around libmysqlclient which is also used by the libdbi driver. If the
client fails, the libdbi driver is likely to fail too.

 > Finally, I realized that refdbd/a/c weren't reading the configuration files 
 > properly for some reason.  Starting them with the -y switch solved the 
 > problem "-y /usr/local/etc/refdb" I also had to uncomment the dbi_drivedir 
 > option in refdbdcrc :  dbi_driverdir /usr/local/lib/dbd, to get refdbd to 
 > see libdbi.

Which version do you use anyway? I have been told about this problem
with Cygwin previously but I couldn't reproduce this on my setup.

 > 
 > Now when I run refdbc, I get the following errors for the various commands:
 > 
 > refdbc: whichdb
 > cannot get row count
 > 
 > refdbc: getau
 > getfoo failed
 > 
 > refdbc: listdb
 > could not connect to database server
 > 
 > refdbc: getref
 > select failed
 > 
 > 

This is quite inconsistent. Are all results from the same session?
E.g. the whichdb result means that refdbd could connect to mysqld but
got a query error. the listdb result means that refdbd couldn't even
connect to mysqld. This makes me kinda nervous as it should either
work all the time or fail all the time, but never "once in a while".

Keep also in mind that unless you successfully created a reference
database and selected that as your current database, most of the above
commands will fail anyway. A reference database is different from the
refdb1 system database.

 > The serverip in the config files is set to the ip of my machine.  I checked 
 > the mysql user permissions and they seem fine -- I'm trying to log in as a 
 > superuser so that shouldn't be the problem.
 > 

Could you please compile as much debug info as possible and send it to
me via private mail? Things I'm interested in are:

/usr/local/etc/refdbd/*
/var/log/refdb* with a log level set to 7
the mysqld log (wherever that is)
a dump of the mysql.user table
the output of mysql:"SHOW DATABASES"
the output of mysql:"SHOW TABLES" after selecting your reference
database

regards,
Markus

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