Command denied

[Yvan]

Hi,

I've a strange situation. I installed Chive for my team that need to access to the database. But I don't want that they've the possibility to insert/edit/delete content. So I created an user with the PRIVILEGE SELECT only on two databases.

The both databases are perfectly the same (one prod and another one qa). On the qa database everything works perfectly, the use can navigate and see all data and run select queries.

But for the prod database (that is the same as qa) I've this error :

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1143 SELECT command denied to user ''@'localhost' for column 'nid' in table 'node'

I don't understand why, if my both databases are the same.

Maybe its can help, I'm using Drupal as CMS.

Regards,

-- Yvan

[David Roth (davrot)]

Strange thing, would need your setup to debug it.
I don`t have a clue what that could be atm.

[Yvan (yvmarques)]

Yes sure,

I'm using Ubuntu 11.10 Server with Nginx 1.0.10 compiled with passenger and the packages mysql-server and php5 from the Ubuntu repository.

The strangest thing is in the both databases (staging and prod) and in staging it works perfectly but in prod I've that error.

Thanks

-- Yvan

[Yvan (yvmarques)]

Hi,

Don't look anymore about it, I found the problem.

When you've a VIEW and you use mysqldump, this one add a security command like that

/*!50013 DEFINER=`user_a`@`localhost` SQL SECURITY DEFINER */

Unfortunately the user doesn't match sometimes (specially between staging and prod).

But, it will be great to notice it, instead of this error page for example.

Regards,

-- Yvan

[kenorb (kenorb)]

Related:
http://bugs.mysql.com/bug.php?id=70907