CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.2 Release Testing »
  • Error on upgrade to 2.2 Stable
Pages: [1]

Author Topic: Error on upgrade to 2.2 Stable  (Read 3072 times)

Signals

  • I’m new here
  • *
  • Posts: 27
  • Karma: 1
  • Learning CiviCRM for future opportunities
    • Halton-Peel Hispanic Association
Error on upgrade to 2.2 Stable
March 16, 2009, 10:49:00 pm
During the upgrade process, it seemed to upgrade CiviCRM successfully but when I clicked on the link for updating the database, I got the following error:

Code: [Select]
Sorry. A non-recoverable error has occurred. The error trace below might help to resolve the issue
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -24
    [message] => DB Error: connect failed
    [mode] => 16
    [debug_info] =>  [nativecode=mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user: 'hispanic@localhost' (Using password: YES)]
    [type] => DB_Error
    [user_info] =>  [nativecode=mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user: 'hispanic@localhost' (Using password: YES)]
    [to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::handle prefix="" info=" [nativecode=mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user: 'hispanic@localhost' (Using password: YES)]"]
)
Now, CiviCRM is broken and I cannot access any part of it.  Can anyone help me?

Thanks,
Matthew[/code]

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error on upgrade to 2.2 Stable
March 17, 2009, 12:04:38 am
Mathew:

Quote
During the upgrade process, it seemed to upgrade CiviCRM successfully but when I clicked on the link for updating the database, I got the following error:

Can you make sure "hispanic" has rights to access civicrm database. Check your civicrm.settings.php and make sure it has correct CiviCRM DSN

HTh

Kurund
Found this reply helpful? Support CiviCRM

Signals

  • I’m new here
  • *
  • Posts: 27
  • Karma: 1
  • Learning CiviCRM for future opportunities
    • Halton-Peel Hispanic Association
Re: Error on upgrade to 2.2 Stable
March 17, 2009, 12:20:52 am
Kurund,

Thanks for the quick reply.  I am not good with databases, but if I understand the code correctly, the answer would be "yes".

Code: [Select]
define( 'CIVICRM_DSN'          , 'mysql://hispanic:*******@localhost:/tmp/mysql5.sock/hispanic_main?new_link=true' );
Not sure where the ******* comes from, but the rest seems to make sense to me.  Have I got this right?

Matthew
« Last Edit: March 18, 2009, 09:37:44 pm by Signals »

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error on upgrade to 2.2 Stable
March 17, 2009, 12:38:39 am
Matthew:

Quote
define( 'CIVICRM_DSN'          , 'mysql://hispanic:*******@localhost:/tmp/mysql5.sock/hispanic_main?new_link=true' );

haltonpeel  is your password.

Can you try

Quote
define( 'CIVICRM_DSN'          , 'mysql://hispanic:*******@localhost/hispanic_main?new_link=true' );

And recheck if it works.

Kurund
« Last Edit: March 19, 2009, 11:10:38 pm by Kurund Jalmi »
Found this reply helpful? Support CiviCRM

Signals

  • I’m new here
  • *
  • Posts: 27
  • Karma: 1
  • Learning CiviCRM for future opportunities
    • Halton-Peel Hispanic Association
Re: Error on upgrade to 2.2 Stable
March 17, 2009, 12:51:26 am
Yes, I realized after I wrote that post that it was the password.  I feel silly.   ::)

Anyway, I did as you suggested, first for CIVICRM_DSN and then for that and CIVICRM_UF_DSN' (I am using Joomla) but it seems to be the same error.

Going to catch a few Z's but will be back online in 5 hours.  Will check this post first thing.

I appreciate your help.  I really hope to get this resolved as I have a bunch of translated information in the application and don't want to have to start from scratch.

Thanks again!

Matthew

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error on upgrade to 2.2 Stable
March 17, 2009, 01:04:36 am
You will have to change civicrm.settings.php for front-end and also backend. If you are still stuck ping me on #civicrm (irc) or consider hiring someone from http://civicrm.org/professional list

Kurund
Found this reply helpful? Support CiviCRM

Signals

  • I’m new here
  • *
  • Posts: 27
  • Karma: 1
  • Learning CiviCRM for future opportunities
    • Halton-Peel Hispanic Association
Re: Error on upgrade to 2.2 Stable
March 17, 2009, 06:11:01 am
Tried you on IRC but you weren't there.  I am setting up this site as a volunteer to showcase CiviCRM's power.  There is no budget for a professional and there shouldn't be a need for it.  I was trying to avoid uninstalling / re-installing as there was significant configuration done in the previous version but that's what I may have to do.  I will try you on IRC later.  Maybe you can PM me when you are going on?

Thanks,
Matthew

Signals

  • I’m new here
  • *
  • Posts: 27
  • Karma: 1
  • Learning CiviCRM for future opportunities
    • Halton-Peel Hispanic Association
Re: Error on upgrade to 2.2 Stable
March 18, 2009, 09:36:54 pm
RESOLVED (Sort of)

After significant effort on the part of Kurund in IRC (thanks for all your patience and help!), I finally submitted a support ticket to the hosting provider.  They determined that, although the database is listed in the Joomla Global Configuration as "localhost:/tmp/mysql5.sock" with the username as hispanic, it was determined that the DSN lines should show "'mysql://hispanic:*******@s467.sureserver.com:3307/hispanic_main?new_link=true' );" instead of "'mysql://hispanic:*******@localhost:/tmp/mysql5.sock/hispanic_main?new_link=true' );" where ******* is the database password. 

If anyone is using ICDSoft, the support is awesome but you may want to look at this option first.  Database location can be determined in Control Panel.

Matthew

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Error on upgrade to 2.2 Stable
March 19, 2009, 12:58:27 pm
Matthew,

You should change your password if you haven't already, as it's still in the clear on some of these posts. Also, if that password reveals the pattern of your other passwords (or, it's the same one) then your security is compromised.

Ken

Signals

  • I’m new here
  • *
  • Posts: 27
  • Karma: 1
  • Learning CiviCRM for future opportunities
    • Halton-Peel Hispanic Association
Re: Error on upgrade to 2.2 Stable
March 19, 2009, 10:19:18 pm
Ken,

Thanks for the suggestion.  It is already changed and was not set up by me.  It is not a reflection of any other password used in the system.

Cheers,
Matthew
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.2 Release Testing »
  • Error on upgrade to 2.2 Stable

This forum was archived on 2017-11-26.