Re: [Refdb-users] could not connect to database server

[<Xia...@gs...>]

Hi, Markus,

Thanks for the response. I finally got refdb to work. I didn't change the 
user name to root when I launched refdba for the first time. I guess it 
would not work if I add user name and passwd through mysql directly. 
Although command line tools work fine now, I got new problem with the web 
service.

Following the instuction, apache server is installed and html files can be 
accessed. refdbc is copied into cgi-bin directory, refdbcgirc file is 
changed accordingly. However, I keep getting internal server error. The 
log file says that incorrect username is entered:

[Mon Jun 03 11:14:28 2002] [error] [client 139.136.86.217] Premature end 
of script headers: refdbc, referer: http://139.136.98.97:8888/refdb/refdbquery.html
[Mon Jun 03 11:14:28 2002] [error] [client 139.136.86.217] incorrect 
username, referer: http://139.136.98.97:8888/refdb/refdbquery.html

With the same user name and passwd, refdbc could be invoked from command 
line correctly.

Could you please help me to look into this problem? Thanks very much.



Below is part of the refdbcgirc file:



# Either the IP address or the hostname of the computer that runs the
# application server refdbd. Use 127.0.0.1 if refdba and refdbd run
# on the same computer
serverip        139.136.98.97

# The port on which the application server refdbd listens
port    9734

# Toggle verbose mode on (t) or off (f)
#verbose        f

# The username for the database access authentication
#username xg18005

# The password for the database access authentication
#passwd

# The default database
defaultdb       bioontology

# The full path of the base directory of your PDF or PostScript offprint
# repository. This path should not rely on shell expansion (don't use ~)
#pdfroot /home/foo/literature/

# The time in seconds which has to elapse before a stalled connection
# to the application server is taken down
 timeout 60

# The full path of a custom log file. This will be used if logdest is
# set accordingly
logfile /home/xg18005/var/log/refdbcgi.log

# The destination of the log information. Uncomment *one* of the
# following definitions. "file" uses the file specified with the
# logfile variable
# logdest syslog
logdest file

# The priority up to which messages are logged. Uncomment *one* of the 
# following definitions. "emerg" will result in the fewest, "debug" in
# the most log messages
#loglevel emerg
#loglevel alert
#loglevel crit
#loglevel err
#loglevel warning
#loglevel notice 
#loglevel info
loglevel debug


# The number of seconds after which the application will destroy itself
# in case it hangs. Set this to zero to switch off autokilling
autokill 1800 

# A list of additional fields which should be displayed by default in the
# reference output. The list is a simple concatenation of the field names
# Possible fields are: N1 N2 AB RP SN UR U1 U2 U3 U4 U5 M1 M2 M3
#fields RPAB

# end of refdbcgirc



The refdb-bug output is:

which: no bib2ris in 
(.:/home/xg18005/bin:/home/xg18005/apache/bin:/usr/kerbero)
cat: /home/xg18005/refdbarc: No such file or directory
cat: /home/xg18005/.refdbarc: No such file or directory
cat: /home/xg18005/refdbcrc: No such file or directory
cat: /home/xg18005/.refdbcrc: No such file or directory
cat: /home/xg18005/refdbibrc: No such file or directory
cat: /home/xg18005/.refdbibrc: No such file or directory
cat: /home/xg18005/nmed2risrc: No such file or directory
cat: /home/xg18005/.nmed2risrc: No such file or directory
cat: /home/xg18005/bib2risrc: No such file or directory
cat: /home/xg18005/.bib2risrc: No such file or directory


I couldn't find the refdbcgi.log file.



Thanks.

Xiang