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) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • DB Error: insufficient permissions
Pages: [1] 2

Author Topic: DB Error: insufficient permissions  (Read 10453 times)

wizard0304

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.10
  • CMS version: joomla 7 1.7.0
  • MySQL version: 5.0.45
  • PHP version: Version 5.2.14
DB Error: insufficient permissions
February 26, 2012, 07:59:15 pm
CiviCRM 4.1.0
Initialization Error

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

       CODE-26
       
[message] => DB Error: insufficient permissions
    [mode] => 16
    [debug_info] =>  [nativecode=1044 ** Access denied for user 'gpbl9930'@'%' to database 'civicrm']
    [type] => DB_Error
    [user_info] =>  [nativecode=1044 ** Access denied for user 'gpbl9930'@'%' to database 'civicrm']
    [to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=1044 ** Access denied for user 'gpbl9930'@'%' to database 'civicrm']"]
)

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: DB Error: insufficient permissions
February 26, 2012, 11:41:58 pm
Hi,

That's a configuration problem and you haven't put the proper login/password user or the database isn't correct.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

wizard0304

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.10
  • CMS version: joomla 7 1.7.0
  • MySQL version: 5.0.45
  • PHP version: Version 5.2.14
Re: DB Error: insufficient permissions
February 27, 2012, 08:03:29 am
The MySQL server host is correct and the database and username and password is correct.

'mysql://cms_db_username:cms_db_password@db_server/cms_database?new_link=true');

'mysql://usr:password@serverhost/databasename?new_link=true' );
Any suggestions?

« Last Edit: February 27, 2012, 08:06:32 am by wizard0304 »

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: DB Error: insufficient permissions
February 27, 2012, 08:10:07 am
Are the user gpbl9930 and db "civicrm" expected and thought to work?

Pretty sure your server is saying they aren't

Access denied for user 'gpbgpbl9930l9930'@'%' to database 'civicrm']
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

wizard0304

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.10
  • CMS version: joomla 7 1.7.0
  • MySQL version: 5.0.45
  • PHP version: Version 5.2.14
Re: DB Error: insufficient permissions
February 27, 2012, 08:20:00 am
'gpbl9930 is the user name the database is the same name

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: DB Error: insufficient permissions
February 27, 2012, 08:31:33 am
Then you have a configuration error (most probably in civicrm.settings.php where the database is wrongly defined as "civicrm"

-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: DB Error: insufficient permissions
February 27, 2012, 08:46:27 am
Hi,

Last try: can your server (web) connect to the db server?

Otherwise don't know, you should start debugging to see where it is stopped.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

wizard0304

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.10
  • CMS version: joomla 7 1.7.0
  • MySQL version: 5.0.45
  • PHP version: Version 5.2.14
Re: DB Error: insufficient permissions
February 27, 2012, 08:52:48 am
Yes, but it says DB Error: insufficient permissions

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: DB Error: insufficient permissions
February 27, 2012, 10:03:45 am
Thats the standard error message saying it can't connect. Your error message mention accessing the db "civicrm" that seems to be incorrect. You might want to investigate that first

Good luck

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

wizard0304

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.10
  • CMS version: joomla 7 1.7.0
  • MySQL version: 5.0.45
  • PHP version: Version 5.2.14
Re: DB Error: insufficient permissions
February 27, 2012, 10:13:54 am
i corrected it now i have a
500 - An error has occurred.

XML data could not be loaded. Make sure you specified the correct path.

Return to Control Panel

wizard0304

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.10
  • CMS version: joomla 7 1.7.0
  • MySQL version: 5.0.45
  • PHP version: Version 5.2.14
Re: DB Error: insufficient permissions
February 27, 2012, 05:17:46 pm
i noticed in other threads that i have to empty the files in templates_c
is this safe to do?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Error: insufficient permissions
February 28, 2012, 03:41:58 am
Yes, it is always safe to empty the files in templates_c
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

wizard0304

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.10
  • CMS version: joomla 7 1.7.0
  • MySQL version: 5.0.45
  • PHP version: Version 5.2.14
Re: DB Error: insufficient permissions
February 28, 2012, 07:04:50 am
Still have a
500 - An error has occurred.

XML data could not be loaded. Make sure you specified the correct path.

Return to Control Panel
At least now is talking to the databas

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Error: insufficient permissions
February 28, 2012, 07:09:47 am
Delete files/civicrm/upload/Config.IDS.ini
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

wizard0304

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.10
  • CMS version: joomla 7 1.7.0
  • MySQL version: 5.0.45
  • PHP version: Version 5.2.14
Re: DB Error: insufficient permissions
February 28, 2012, 07:50:21 am
That helped! I am now logged in to civicrm on the backend of joomla administration but all links give me
CiviCRM-001 -
Sorry. A non-recoverable error has occurred.
You do not have permission to access this page

Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • DB Error: insufficient permissions

This forum was archived on 2017-11-26.