CiviCRM Community Forums (archive)

Hello,

I'm having problems getting the emailprocessor.php working.  If I go to the following URL, entering the correct credentials for username, password, and mysitekey:

http://example.org/sites/all/modules/civicrm/bin/EmailProcessor.php?name=username&pass=password&key=mysitekey

I get a "DB Error: no such table" as seen in the attached screenshot.  When I try to click on the 'Error Details' nothing happens (this might be a civicrm bug?).  When I view the source, the problem says:

                                        <div class="crm-section">Database Error Code: Table 'caseye_drupal.users' doesn't exist, 1146</div>
                                        <div class="crm-section">Additional Details: <p><pre>Array

The correct table should really be caseye_drupal.drupal_users because the drupal tables are prefixed with drupal_.  I don't know where to define this prefix though.

One other thing, where am I supposed to put this line in my config file?:

define( 'CIVICRM_SITE_KEY', 'mysitekeyhere' );
   

currently I put it right above  the last section of code.  Not sure if this is correct, the manual didn't say:

define( 'CIVICRM_SITE_KEY', '3cx4aNkpQwxmM1hTMVxxx' );

    // FIXME: problem spot for Drupal 5.1 config dir layout
    $conf = "$confdir/default";
    return $conf;
}

include_once civicrm_conf_init( ) . '/civicrm.settings.php';


Anyone have any ideas?  I've quadruple-checked the settings, tried different users, tried different email accounts (all gmail), but nothing works.  I still get the "ERROR: Invalid username and/or password " error.

I did this.  I put a site key that I generated into /sites/default/civicrm.settings.php .  I go to http://www.mysite.org/sites/all/modules/civicrm/bin/EmailProcessor.php?name=mydrupalusername&pass=mydrupalpassword&key=mysitekeyIgenerated

I get "ERROR: Invalid username and/or password".  I've tried this with a specific mailer drupal account I created as well as my own master drupal account.  There are no special characters in either password or username.

It seems to be failing CRM_Utils_System::authenticate( $name, $pass ); in line 476 of sites/all/modules/civicrm/CRM/Utils/System.php.  I have no idea why this is happening.  If I just tell the script to die() right there and print my username and password, they are correct, but $result=bool(false).

The prefix table is set correctly.  I set it at /civicrm/admin/setting/uf?reset=1 to 'drupal_users', which is correct.  Is there someplace else I should be editing this?

I have some authentication plug-ins (e.g. Facebook Sign On) which is the only thing I can think of that might be causing an issue somehow, but I disabled it.

An update: I did a fresh install on a test subdomain and was able to get it working (well, it read and got to the end of the INBOX, so I'm guessing it will work).  Something is probably interfering with the authentication system, so I will have to troubleshoot it.  This isn't going to be fun .

FYI, we are using Google Apps for our domain.  I originally set up a bounce mailbox through our google email system, but this was causing an ezcMailTransportException error when trying to run EmailProcessor.php.  When I changed it to a test account on a different domain the email script worked fine.  I feel like people will definitely run into this problem... it should probably be noted in the documentation somewhere.

CIVICRM_UF_DSN, CIVICRM_DSN settings, plus make sure directory paths are correct for that site  (civicrm_root, CIVICRM_TEMPLATE_COMPILEDIR). Verify Drupal table prefix. Also note that some CiviCRM DB settings are specific to your site's URL and directory location - so if you've moved stuff around you should verify "Base Directory" in DB by navigating to Administer > Configure > Update Directory Path and URL.

adit - ok think i found it:

http://www.example.org.au/civicrm/admin/setting/uf&reset=1