I am trying to set up a Drupal 7 multisite install with SSO, sharing users from a shared_tables DB. For directions, I am following http://drupal.org/node/547862.
I am getting the following when I modify sites/site2/settings.php:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'royhink_drpl1'@'localhost' for table 'semaphore': SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /home/royhink/public_html/drupal/includes/lock.inc).
The MOD looks like:
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'royhink_auto',
'username' => 'royhink_drpl1',
'password' => 'password',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
// 'prefix' => '',
'prefix' => array(
'default' => 'drpl1.',
'users' => 'shared_tables.',
'sessions' => 'shared_tables.',
'role' => 'shared_tables.',
'authmap' => 'shared_tables.',
),
),
),
);
I have one user name that I set to all three tables, and I made sure I had full permissions:
Am I missing something obvious?
Using Hostgator CentOS/Drupal7/MySQL/PHP5/cPanel
Comments
With MOD, Now Getting New Error
I am now getting:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'royhink_drpl1'@'localhost' for table 'users': SELECT u.*, s.* FROM {users} u INNER JOIN {sessions} s ON u.uid = s.uid WHERE s.sid = :sid; Array ( [:sid] => 5wEG8TilIp5EE1WiHEz49-4n7qMdfv_e0eKnafh9j0E ) in _drupal_session_read() (line 102 of /home/royhink/public_html/drupal/includes/session.inc).
with these settings:
<?php$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'royhink_auto',
'username' => 'royhink_drpl1',
'password' => 'XXXXXXXXXXXXXXX',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
// 'prefix' => '',
'prefix' => array(
'default' => '',
'users' => 'shared_tables.',
'sessions' => 'shared_tables.',
'role' => 'shared_tables.',
'authmap' => 'shared_tables.',
),
),
),
);
?>
I tried creating a new user and password, and assigned it (in cPanel) to all tables, but it threw the same exception. I would think a syntax error would break the script complete.
Any help greatly appreciated.
Dont Forget Cookie Domain
$cookie_domain = '.thaksin_the_thief';
"Above the Dark Clouds is one Heck of A Blue Sky!"