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

[Markus H. <hoe...@co...>]

Hi Juan,

Juan de la Figuera writes:
 > 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:

In which databases precisely can you look inside? It might actually be
a problem with your MySQL access rights for the database "refdb" (not
the database with your references). When RefDB tries to connect to
MySQL, it uses the database "refdb" as a dummy. This should no longer
be necessary in MySQL 3.23 and later, but I have to keep it this way
for compatibility with MySQL 3.22. If you do not have sufficient
access rights to refdb (and refdbvar, but this is only used for
bibliographies), you'd get this error.

Could you check your access rights again? Send the contents of your
mysql.db and mysql.user tables if you're not sure. FWIW I use the
following access rights for a test database "lall" and entries to
allow local and remote access:

| Host      | Db       | User   | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------+----------+--------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| %         | refdb    | markus | Y           | Y           | Y           | Y           | N           | N         | N          | N               | N          | N          |
| localhost | refdb    | markus | Y           | Y           | Y           | Y           | N           | N         | N          | N               | N          | N          |
| %         | lall     | markus | Y           | Y           | Y           | Y           | N           | N         | N          | N               | N          | N          |
| %         | refdbvar | markus | Y           | Y           | Y           | Y           | Y           | Y         | N          | Y               | Y          | Y          |
| localhost | refdbvar | markus | Y           | Y           | Y           | Y           | Y           | Y         | N          | Y               | Y          | Y          |
| localhost | lall     | markus | Y           | Y           | Y           | Y           | N           | N         | N          | N               | N          | N          |


NB If you add users with the refdba adduser command, the access rights
should automatically be set correctly for the reference database as
well as for refdb and refdbvar. If this does not work in your case,
then it is a bug.

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

This is very neat, and I believe it is very simple to implement. This
would make things a bit more secure.

regards,
Markus

-- 
Markus Hoenicka
hoe...@co...
http://ourworld.compuserve.com/homepages/hoenicka_markus/