Hello,
Just wondering if there is any further configuration needed for bulkmail to work, we are getting and erro similar to the following
------------------------------------------------------------------
Back Trace
0 => array (
"function" => "sq_error_handler",
"args" => array (
0 => 256,
1 => "DB Error: connect failed",
2 => "[SYSTEM_ROOT]/core/include/mysource.inc",
3 => 2141,
4 => array (
[Max Depth Reached]
)
)
),
1 => array (
"file" => "[SYSTEM_ROOT]/core/include/mysource.inc",
"line" => 2141,
"function" => "trigger_error",
"args" => array (
0 => "DB Error: connect failed",
1 => 256
)
),
2 => array (
"file" => "[SYSTEM_ROOT]/core/include/mysource.inc",
"line" => 206,
"function" => "changedatabaseconnection",
"class" => "mysource",
"type" => "->",
"args" => array (
0 => "db"
)
),
3 => array (
"file" => "[SYSTEM_ROOT]/core/include/init.inc",
"line" => 228,
"function" => "init",
"class" => "mysource",
"type" => "->",
"args" => array (
[Empty]
)
),
4 => array (
"file" => "[SYSTEM_ROOT]/core/cron/run.php",
"line" => 36,
"args" => array (
0 => "[SYSTEM_ROOT]/core/include/init.inc"
),
"function" => "require_once"
)
thanks
DB connect failed normally means that (unless your database is down) you have run out of connections. Increase the number of connections allowed at a time - the defaults for postgres are not very high.
We're using Oracle, and I don't think the error is caused from a db connection failure… as we're not seeing the same error elsewhere.
Contact Squiz Support so they can validate your server configuration – it looks like the bulkmail cron script doesn't have the Oracle environment variables set, so it can't connect to the Oracle database.
so it's fair to say that Bulkmail uses a separate DB connection function, compared to the rest of matrix?
No, Bulkmail uses all the same code as Matrix. However, that error is not coming from Bulkmail -- it is coming from the Cron Manager PHP script (core/cron/run.php). This script and the bulkmail PHP script both need to run with the appropriate Oracle environment variables, or else they will not be able to make a connection to Oracle.
Thanks Avi… I have a better understanding now.
Much appreciated.
No worries -- this same issue drove me insane when I first started working with Oracle. :)
Also, just another note: To get Bulk Mail to actually send mail, you do need to have the bulkmail PHP script running via crontab as well as the normal Cron Manager script.
[quote]No worries – this same issue drove me insane when I first started working with Oracle. 
Also, just another note: To get Bulk Mail to actually send mail, you do need to have the bulkmail PHP script running via crontab as well as the normal Cron Manager script.[/quote]
sorry to join this forum a bit late, where do I find the bulkmail php script and also how do you know its running.
cheers
The script is at /path/to/matrix/packages/bulkmail/run.php
There isn't anything that tells you it is running. You need to configure your server cron to run it regularly. So actually, it should start running very often but just not have anything to do.
If you want to know if it is still running, you'll need to check your server processes. If you just want to know if a specific bulkmail job is running, check the Details screen of the job.
[quote]The script is at /path/to/matrix/packages/bulkmail/run.php
There isn't anything that tells you it is running. You need to configure your server cron to run it regularly. So actually, it should start running very often but just not have anything to do.
If you want to know if it is still running, you'll need to check your server processes. If you just want to know if a specific bulkmail job is running, check the Details screen of the job.[/quote]
Thanks Greg
Now we are getting this error. Wondering how do we get it sorted out or what we are missing ??? The image is attached
Picture_1.png (27.1 KB)
You do not have the server requirements to use the bulkmail package. This particular error is telling you that you are missing the PEAR:Mail_Queue package.
How do we attain or activate the missing PEAR:Mail_Queue package?
cheers :rolleyes:
You need a server admin to run: pear install Mail_Queue