CiviCRM Community Forums (archive)

I have read everything I can find on this issue and still can not get it working. I have a drupal site that uses a drupal database (drpl1_db) and a separate CiviCRM database (civi_db). Basic operations of the Drupal site and the CiviCRM work fine, but CiviCRM does not provide a built-in calendar view. So, I found the instructions to link with the Drupal calendar at http://wiki.civicrm.org/confluence/display/CRMDOC32/Using+Drupal+Calendar+with+CiviEvent. Luckily I already had the Drupal calendar (and views, et al) working with all the latest versions before working with the CiviEvent data.

However, after following all of the steps shown; I get the following error:
user warning: SELECT command denied to user 'user1'@'localhost' for table 'civicrm_event' ...

Before I had fixed some other problems, I was getting an error saying that the table could not be found; so I assume that it is now finding the right database, it just is not allowing my user account to login and access the data. I have already verified that the user has SELECT permissions and I am certain that the password is correct; I have even tried multiple accounts verifying that the rights are set and that the passwords are correct, but I always get the same error - just with the username changing.

My only clue as to what might be wrong is the cryptic statement in the above website that says: "Some hosting platforms might make this difficult." It is unclear if that is something related to merely setting SELECT permissions (which was easy) or if there is some special task that must be performed beyond that.

Looking through the various forum postings it seems like many people just give up and roll the CiviCRM database into the drupal database (despite this being exactly opposite to the configuration that CiviCRM documentation seems to recommend). I am hesitant to do this because I would like to use a shared CiviCRM database among multiple sites; in other words, I am working with several independent groups, each with their own Drupal website, that want to share their CiviCRM data with each other.  So ideally, I would have one CiviCRM database accessed by multiple Drupal databases. Any ideas?

Thanks for the warning; I did not fully recognize the impacts of that... I'll have to think more about how the multiple websites interact...

Yep, I've followed the linkhttp://wiki.civicrm.org/confluence/display/CRMDOC32/Views2+Integration+Module in the 'green tip' at the top of the file:
- Added rows for an array of $db_url (just default and civicrm)
- Added the long array for $db_prefix
- And even followed the instructions at Redspire to add the 'database' => 'civicrm' lines in the civicrm.views.inc file

I also reset the views cache, tried disabling the view and re-enabling it... All sorts of stuff... I was able to see the change in the error from not finding the table in the Drupal database to now just saying that I do not have permission - so I figure the $db_prefix stuff must be working, but for some reason it is either:
- not recognizing my password (which I have checked countless times)
- not allowing the same user log into two databases simultaneously (I tried different accounts on the civicrm side; maybe I should change the drupal one?)
- not recognizing the permissions (but at least one of the accounts is the main one that I use to do everything else on the civi site)
- or ??

Uhg! Stupid me! Computers are so anal! 

My database has a 'feature' that prepends the default account user name to the front of each database name. I forgot to include this in my $db_prefix structure. Upon correcting each row to read "kvaughn_civicrm." rather than "civicrm." everything worked fine. 

An error code that indicated that it could not find the database would have been more useful than permissions being denied for a table; but I guess that is a security issue... At least I got it working. Thanks for all who provided help!