CiviCRM Community Forums (archive)

G'Day,

I had to change the username for the mySQL DB user. After changing the J! configuration all is fine (ie yearofthefarmer user can access the DB). However in the back end as soon as I click on Components > CiviCRM I get the following error. Is CiviCRM using a different DB username/password combination to the one that is configured for J!? If so where is the config file that I can change to enter the correct (revised) password?

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => simpleHandler
        )

    [code] => -24
    [message] => DB Error: connect failed
    [mode] => 16
    [debug_info] =>  [nativecode=Access denied for user 'yearofthefarmer'@'localhost' (using password: YES)]
    [type] => DB_Error
    [user_info] =>  [nativecode=Access denied for user 'yearofthefarmer'@'localhost' (using password: YES)]
    [to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=Access denied for user 'yearofthefarmer'@'localhost' (using password: YES)]"]
)

backTrace

/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 235
, simpleHandler,
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 252
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php, connect, 558
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, connect, 2287
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _connect, 2525
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _build_condition, 411
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php, find, 209
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, retrieve, 397
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, _initVariables, 202
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/admin.civicrm.php, singleton, 48
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/admin.civicrm.php, civicrm_init, 59
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/libraries/joomla/application/component/helper.php, require_once, 152
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/includes/application.php, renderComponent, 154
/home/yearofthefarmer/domains/launch.yearofthefarmer.com.au/public_html/administrator/index.php, dispatch, 47


Thanks heaps. That worked a treat.