CiviCRM Community Forums (archive)

I configured CiviMail in April and have successfully sent half a dozen email blast to our members over the past two months.  Yesterday another blast simply sat at "Scheduled" even though the cron job runs every 10 minutes.  Running the curl request from the command line produces
ERROR: Invalid username and/or password
However, I can login to the Joomla backend using the username and password specified in the command.  The site key is correct.  

Also,  the "Send a Test" feature in the wizard sent a test mailing just fine, so the mail set up is correct.  There seems to be an authentication problem with the cronjob and Mailprocessor scripts.

Suggestions about where to look and why it would have stopped working?

does the user name or password contain some non-alphanumeric characters?

lobo

your best bet would be to debug the code at:

CRM/Utils/System/Joomla.php, line 242 onwards (in function authenticate)

thanx

lobo

make sure u put in a good word for civicrm to the delegates at the convention

have fun legislating

lobo

I got 'row empty' in the debug file.  Why would the row be empty?  The member name exists.

Can you check what’s the query in the $sql variable and try to run it against your database?

(My gut feeling is that there might be something with lowercasing and/or escaping the username.)

First, are you sure the file gets created (as opposed to being there from previous runs)? Please try deleting it and then check whether it gets recreated (otherwise it might be that the user running the script cannot write to the file – I’m not sure whether by ‘empty’ you mean there’s ‘$sql =’ in it or not).

Second, you can try writing the $sql variable right after it gets created, in case the query() call munges the string or exits the application:

<?php
# ...
        $sql = 'SELECT u.* FROM ' . $config->userFrameworkUsersTableName .
            " u WHERE LOWER(u.username) = '$name' AND u.block = 0";
        file_put_contents('/joomlaroot/administrator/debug.txt', "\$sql = $sql");
        $query = $dbJoomla->query( $sql );
# ...


Now that I look at it, your fwrite() call was wrong (you passed $sql as a third param, instead of concatenating it to the second). But file_put_contents() is simpler and it wraps the open/write/calls nicely.

OK - password check variables match, so why is the script returning an error message?

[…]

debug.txt contains:

Quote

hash = a hash string
cryptpass = exact same string

Does it also contain ‘hash to cryptpass returned false’? If not, then the function returns false somewhere below, not in the $hash != $cryptpass condition. (The next condition checks whether the associated CiviCRM contact actually exists, and most probably this is where the method returns false if the hashes match.)