[Refdb-users] Cannot connect to server...

[Juan de la F. <ju...@ca...>]

	Hello,

	I am having some funny behavior. Ok, it is somewhat late.

	It is a refdb 0.8.3 installed on Debian 3.0 unstable/ppc.

I can connect through either refdba or refdbc as root to the mysql
server (say doing a "listdb"). No problem there. But when I try as my
username, I get the "cannot connect to database server". The strange
thing is that using the same user name and password, I can use the
mysql client and list the databases (show databases), or look inside
them (the permissions look ok). For example, the output from status
is:

-------------- 
mysql Ver 11.15 Distrib 3.23.47, for unknown-linux-gnu
(powerpc)

Connection id:          44
Current database:
Current user:           juan@localhost
Current pager:          stdout
Using outfile:          ''
Server version:         3.23.47-log
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 1 hour 14 sec

Threads: 1  Questions: 45  Slow queries: 0  Opens: 7  Flush tables: 1  Open tables: 1 Queries per second avg: 0.012
--------------

	The output of ps ax | grep ref is:
 1432 ?        S      0:00 /usr/local/bin/refdbd
 1563 pts/4    S      0:00 refdbc -u juan -w myspasswd
 1568 pts/2    S      0:00 grep ref

	and the one from ps ax | grep "mysql -u" is:
 1599 pts/3    S      0:00 mysql -u juan --password=x xxxxx
 1606 pts/2    S      0:00 grep mysql -u

	(BTW, the mysql client changes the password to "xxx" when doing the ps ax, but not refdbc. Not a big worry though)

	The variable in the refdbc are:
serverip 127.0.0.1
port 9734
verbose f
pager less
username juan
defaultdb papers
pdfroot /home/juan/papers_bib/PDF/
timeout 60
logfile /var/log/refdbc.log
logdest FILE
loglevel DEBUG
autokill 1800
fields RPAB

	Ok, on this computer I can run it as root. But I am curious...

	I am also including the "refdb-bug" output as an attachment...

	Regards,
	Juan


-- 

----------------------------------------
Juan de La Figuera
Sandia National Laboratories
Mail Stop 9161
Livermore, CA 94550

Fax:    925-294-3231
Phone:	925-294-1201
e-mail: gap...@at...
	ju...@ca...
	jd...@sa...
Web:	http://www.ca.sandia.gov/materials_science
	http://castelar.dhs.org
----------------------------------------