nss-mysql-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Nss-mysql-users] "select command denied" in logs.


From: Frederic Trudeau
Subject: [Nss-mysql-users] "select command denied" in logs.
Date: Wed, 9 Apr 2003 19:54:42 -0400

Greetings.

I followed the installation instructions step by step in the SHADOW file +
INSTALL file of the 0.43 sources.
I think I configured both config files properlly. I still get this error
message in my logs ;

Apr  9 19:51:51 zesolution nss-mysql[4707]: _nss_mysql_send_query:
mysql_query failed: select command denied to user:
'address@hidden' for column 'user_name' in table 'nss_user'

This error message is pretty straight-forward, however, here is the output
of my columns_priv table :

+-----------+---------+----------------+----------------+-------------+-----
-----------+-------------+
| Host      | Db      | User           | Table_name     | Column_name |
Timestamp      | Column_priv |
+-----------+---------+----------------+----------------+-------------+-----
-----------+-------------+
| localhost | _system | nss_sys_lookup | nss_user       | homedir     |
20030409192029 | Select      |
| localhost | _system | nss_sys_lookup | nss_user       | user_name   |
20030409192029 | Select      |
| localhost | _system | nss_sys_lookup | nss_user       | realname    |
20030409192029 | Select      |
| localhost | _system | nss_sys_lookup | nss_user       | shell       |
20030409192029 | Select      |
| localhost | _system | nss_sys_lookup | nss_user       | gid         |
20030409192029 | Select      |
| localhost | _system | nss_sys_lookup | nss_user       | uid         |
20030409192029 | Select      |
| localhost | _system | nss_sys_lookup | nss_user       | user_id     |
20030409192029 | Select      |
| localhost | _system | nss_sys_lookup | nss_groups     | group_name  |
20030409192051 | Select      |
| localhost | _system | nss_sys_lookup | nss_groups     | group_id    |
20030409192051 | Select      |
| localhost | _system | nss_sys_lookup | nss_groups     | gid         |
20030409192051 | Select      |
| localhost | _system | nss_sys_lookup | nss_user_group | user_id     |
20030409192128 | Select      |
| localhost | _system | nss_sys_lookup | nss_user_group | group_id    |
20030409192128 | Select      |
| localhost | _system | nss_sys_shadow | nss_user       | user_name   |
20030409192307 | Select      |
| localhost | _system | nss_sys_shadow | nss_user       | password    |
20030409192307 | Select      |
| localhost | _system | nss_sys_shadow | nss_user       | user_id     |
20030409192307 | Select      |
| %         | _system | nss_sys_lookup | nss_user       | status      |
20030409195135 | Select      |
+-----------+---------+----------------+----------------+-------------+-----
-----------+-------------+

What could possibly cause this ?

Thanks for any pointers.






reply via email to

[Prev in Thread] Current Thread [Next in Thread]