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

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

Gary Lupyan writes:
 > Markus, I got it to work last night :)  The problem was 
 > several-fold.  First, I created the refdb1 database (as per instructions), 
 > but not the other database.  I realized something was missing when looking 
 > at the logs, I saw it was trying to lock tables that didn't exist.
 >   Secondly, I set serverip to the actual ip of my machine as the readme 
 > file that came with the cygwin release said to do.  Apparently that was the 
 > problem.  When I switched it back to 127.0.0.1, it worked.  I still can't 
 > run mysqlc inside cygwin (although I can run it in DOS when mysqld is 
 > loaded inside cygwin).  The cygwin dll file is in the same place as the 
 > mysql executables.
 > 

Glad it worked out. I'll have to check the serverip thing as I've been
told the opposite previously - I'll check tomorrow what I use at work.

 > I then had some problems with the web interface -- namely the refdbc that 
 > was inside cgi-bin wasn't reading its configuration file, and I couldn't 
 > use the -y switch through the web.  I realized that refdbd, refdba, and the 
 > interactive refdbc all read the config files in my home directory by 
 > default.  This is the precompiled version of refdb I'm talking about-- is 
 > there a way way to change it so that it reads configs from a common 
 > directory?

This is actually the default (/usr/local/etc/refdb/*) but I'm afraid
the prebuilt Cygwin binaries have a problem here. Alan created them
using a virtual root which may have screwed up the compiled-in
defaults. You could try to replace cgi-bin/refdbc with a shell script
that calls refdbc with the appropriate parameter. I've never tried
this, though.

 > Another issue with the web version is that the precompiled .html files had 
 > the wrong links -- I had to add /refdb/ to all the link locations 
 > manually.  That worked fine, but now the only issue is that when I submit a 
 > web request to refdbc, the stuff it prints still has the default links.  Do 
 > you know if I can recompile just refdbc with the appropriate switches?
 > 

This is most likely due to the same problem with the virtual
root. RefDB 0.9.3 and 0.9.4-pre1 build out of the box on Cygwin, so
this might be the cleanest way to fix these things. I'll do another
binary release as soon as time permits.

regards,
Markus

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