CiviCRM Community Forums (archive)

Godaddy Shared Grid Hosting "SELECT command denied"


user warning: SELECT command denied to user 'dp1026'@'174.201.199.272' for table 'civicrm_event' query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM civicrxxxxxxal.civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0) AND (civicrm_event.is_template = 0)) AND ((DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') <= '2010-11' AND DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') >= '2010-11')) ORDER BY civicrm_event_start_date ASC in /home/content/88/6754888/html/doxxxxxal/sites/all/modules/views/includes/view.inc on line 775.


I'm not sure how to fix it.  I thought bullet point #1 addressed the issue?


"If your CiviCRM install uses a different database to your Drupal install, ensure that your Drupal DB user has SELECT rights to your CiviCRM DB. Some hosting platforms might make this difficult. For more information about setting up Drupal multi-database access: http://drupal.org/node/18429"

The bullet point is what propted me to write the following lines in my php.

$db_url['default'] = 'mysqli://dop1026:Dope3@dop106.db.678.hostedresource.com/dop1026';
 $db_url['mydb'] ='mysql://civicrmdl:Dop@civicrmdl.db.6758.hostedresource.com/civicrmdopl?new_link=true';
$db_prefix = array ('default'=>'drupal_','civicrm_event'=>'','civicrm_activity'=>'','civicrm_contact'=>'','civicrm_address'=>'','civicrm_contribution'=>'');


Possibly there is a mistake in my scripting?  


Which also brings up the issue with the following part of the array:

('default'=>'drupal_','civicrm_event'=>'','civicrm_activity'=>'','civicrm_contact'=>'','civicrm_address'=>'','civicrm_contribution'=>'');

directions are --- NOTE: your prefix may be something other then drupal_, just replace drupal_ with whatever prefix you have configured.

Where do I locate my prefix?      


The prefix is only part of the problem, the other part most likely is the [default], [mydb].

Any idea what the solution is?

This is what I currently have:

$db_url['default'] = 'mysqli://dop1026:Doper3@dop1027756.db.6754888.hostedresource.com/dop101256';
 $db_url['civicrm'] ='mysql://civicrmdl:Doper3@civicral.db.67888.hostedresource.com/civicral';

$db_prefix = array(
  'default'                                  => '',
  'civicrm_acl'                              => 'civicrmdol.',
  'civicrm_acl_cache'                        => 'civicrmdopl.',
  'civicrm_acl_contact_cache'                => 'civicrmdopl.',
  'civicrm_acl_entity_role'                  => 'civicrmdopl.',
  'civicrm_activity'                         => 'civicrmdopl.',
  'civicrm_activity_assignment'              => 'civicrmdol.',
  'civicrm_activity_target'                  => 'civicrmdopl.',

and it goes on.

I have 2 databases

 Drupal =     database name = dop10xxxxxxx56    description = dopexxxxxxpal             
 CIVCRM =   database name = civicrmxxxxxal         named= civicxxxxxdal

I copied the line "$db_url['civicrm'] " from civicrm.settings.php 

I am not advanced enough to understand some of what you are implying.  I believe the database that I need to define that I haven't per your statement is:

"$db_url['civicrm'] ='mysql://civicrmdl:Doper3@civicral.db.67888.hostedresource.com/civicral'"

But I am not sure what to change?

Change has been made per your instructions.  However, I still have same error.

"SELECT command denied to user"
&
sites/all/modules/views/includes/view.inc on line 775

 check out
http://andrewbrookins.com/redspire/civicrm-views-2-integration-remote-civicrm-database  

Look at #2 does that apply to my problem.  If so, I have already tried it and no change.

Prior responce points attention to:

"the select command is looking for a database named "civicrmdal", but you have no such database defined in your $db_url's."

I do not know how to define the database in my $db_url's.  What do I need to change?