CiviCRM Community Forums (archive)

I've trying to send a scheduled mailing using civimail installed on Drupal 7.  When I try to run cron through a URL, I get the following Error:
DB Error: No database selected.
I've checked and double-checked civicrm.settings.php, and I'm pretty sure my drupal database in my civicrm databases are both defined properly.
Can anything else be causing this error that I haven't thought of?

This is the URL I used:
http://www.mysite.com/sites/all/modules/civicrm/bin/cron.php?job=process_mailing&name=myname&pass=mypass&key=xxxxxxxxxmykeyxxxxxxxxxxxxxxxxxx

Thanks!

http://www.mysite.com/sites/all/modules/civicrm/bin/cron.php?job=process_mailing&name=myname&pass=mypass&key=xxxxxxxxxmykeyxxxxxxxxxxxxxxxxxx

Perhaps try removing the job=process_mailing& part and see if that helps. A long shot, but it won't hurt.

seems like we might want to deprecate cron.php

I would hesitate to suggest that as it's useful in many cases for debugging--it's easier for some users (and some host setups) to put the URL in the browser and easily see what error message is returned. The other reason to keep it is that I think it's easier for many users to build the URL then to construct the CLI cron job.

Thanks for your suggestions:
(1) I have a control panel with my host provider -- but I don't think I can run command lines directly.  That is why I was trying to use the URL method.
(2) Removing the job=process_mailing& part yields the same result.
(3) My CMS integration settings in CiviCRM matches correctly with my drupal database:   The drupal users table name is "users."  Check.

Also, if I try to Send the scheduled mailings from the Civicrm Administer menu, it returns the below error.  Right now I have no way to send mail using civimail, even brute force.

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 209 of /mypath/mysite.com/includes/session.inc).

Also, if I try to Send the scheduled mailings from the Civicrm Administer menu, it returns the below error.  Right now I have no way to send mail using civimail, even brute force.

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 209 of /mypath/mysite.com/includes/session.inc).

Appears clear now that your host machine is not able to handle this procedure. You should ask them for assistance and if they can't help, you will need to find alternative hosting. The reason you get "No database selected" is because "MySQL server has gone away."  Certainly appears to be anyhow, and this is a hosting problem.