CiviCRM Community Forums (archive)

I am using the civimail.cronjob.php posted by Xavier here which only has one line changed, and I am seeing an unusual error. When I first ran it I got:

SELECT u.* FROM users u WHERE LOWER(u.name) = 'civimail' AND u.pass = '4e8baf52aa2d1bcbbd766bce9d47e23d' AND u.status = 1 [nativecode=1146 ** Table 'xxxxx.users' doesn't exist]
I remembered that this Drupal site uses a prefix of default_ so I adjusted that at civicrm/admin/setting/uf?reset=1 and now I get

Site off-line

The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.

If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.

The mysql error was: Access denied for user: 'xxxx_user@localhost' (Using password: YES).

when I run the URL for civimail.cronjob.php directly in the browser.

The rest of the site works fine, however, for both anonymous and logged on users--it's not really offline.

Any ideas how to rectify this?

It's the right place when run from the browser:

if ( php_sapi_name() == "cli" ) {
die ("wrong place");
} else  { //from the webserver
die ("right place");
}
Running it via CLI, after I fixed the syntax and the location etc, it gives no output. Seems that it's running OK.