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 »
  • CiviMail installation and configuration (Moderator: Donald Lobo) »
  • Access Denied error
Pages: [1]

Author Topic: Access Denied error  (Read 4999 times)

Networker

  • Guest
Access Denied error
November 27, 2007, 07:01:15 pm
Hi,
I'm stumped on this error:

 [debug_info] =>  [nativecode=mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'marionde_drupal'@'localhost' (using password: YES)]
[type] => DB_Error


CiviCRM is working normally, and we are trying to get CiviMail to work.  We only have two databases and this user have full rights to both of them.  Username/password is correct (since CiviCRM is working), although I don't know how to check that using phpAdmin.

I'm new at this, so any help will be greatly appreciated.

Networker.

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Access Denied error
November 27, 2007, 10:15:25 pm
Where do you specify this user? Keep in mind that the user/pass specified in AMaViS config is a pair of a Drupal user credentials (a user with CiviMail access rights), and not a MySQL user.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

Networker

  • Guest
Re: Access Denied error
November 28, 2007, 04:05:56 pm
Hi,
I'm sorry I was a bit short on documentation.  (It was late and I was tired.)

We're using email2soap-2.1 and I get this error during soap initialization.  I'll paste the complete error below.
Thanks for pointing out the user having to be in Drupal not in MySQL as I had made that error too.

I am still not sure of this as we have only two users for now, and only two databases.  The error says "Access denied for marionde_drupal @ localhost"  AFAIK, this user needs to work for Drupal to function, and Drupal functions just fine.  So why is access denied here?  marionde_drupal is the only user on marionde_drupal database.



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">

<head>
  <title></title>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <base href="http://www.mariondems.org/modules/civicrm/" />
  <style type="text/css" media="screen">@import url(http://www.mariondems.org/modules/civicrm/css/civicrm.css);</style>
</head>

<body>

<div id="crm-container" lang="en" xml:lang="en">

<div class="messages status">
  <dl>
  <dt><img src="http://www.mariondems.org/modules/civicrm/i/Error.gif" alt="unrecoverable error" /></dt>
  <dd>
      Sorry. A non-recoverable error has occurred.      <p></p>
      <p><a href="http://www.mariondems.org/" title="Main Menu">Return to CiviCRM menu.</a></p>
  </dd>
  </dl>
</div>

</div>
</body>
</html><p>Error Details:</p><p><pre>Array
(
    [callback] =&gt; Array
        (
           
  • =&gt; CRM_Core_Error
    • [1] =&gt; handle
            )

       
Code: [Select]
=&gt; -24
    [message] =&gt; DB Error: connect failed
    [mode] =&gt; 16
    [debug_info] =&gt;  [nativecode=mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Access

denied for user 'marionde_drupal'@'localhost' (using password: YES)]
    [type] =&gt; DB_Error
    [user_info] =&gt;  [nativecode=mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Access

denied for user 'marionde_drupal'@'localhost' (using password: YES)]
    [to_string] =&gt; [db_error: message=&quot;DB Error: connect failed&quot; code=-24 mode=callback callback=CRM_Core_Error::handle

prefix=&quot;&quot; info=&quot; <br>[nativecode=mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]:

Access denied for user 'marionde_drupal'@'localhost' (using password: YES)]&quot;]
)
</pre></p><p></p>

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Access Denied error
November 28, 2007, 06:55:52 pm

note that email2soap.pl OR imap2soap.pl are community contributed (and hence community supported) pieces of code. You might want to contact the author(s) directly via emailif you dont get a response here in a few days

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Access Denied error
November 29, 2007, 03:21:59 am
As Lobo noted, we don’t support (nor use ourselves) email2soap, so we can’t really help you.

The error says clearly that either in one of the places where you have marionde_drupal specified the counterpart password is wrong, or that this user does not have the required access rights to the other database.

If you have two databases, I assume you have Drupal and CiviCRM separated in them; in my vision, email2soap requires access to the CiviCRM database, so maybe marionde_drupal does not have access rights to the CiviCRM database? That would explain why Drupal works with the same credentials.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

Networker

  • Guest
Re: Access Denied error
November 30, 2007, 04:01:46 pm
Thanks guys,
you helped quite a bit.  It was a pretty stupid password mis-match.  Two accounts, two passwords, you'd think I could keep 'em straight :)

Live and learn.  Thanks for taking the time.

Networker.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • CiviMail installation and configuration (Moderator: Donald Lobo) »
  • Access Denied error

This forum was archived on 2017-11-26.