[drupal-support] mass mailer says can't fine php executable even though it's in /usr/bin/
I installed the mass mailer module, and can create messages, but no messages are being sent out. Looking in the message queue, I see "You do not have the php executable in your system path and it cannot be located in /usr/bin or usr/local/bin." But php IS in /usr/bin, with 755 for permissions. Why can't it see it? TIA. Petre Scheie
Petre Scheie wrote:
I installed the mass mailer module, and can create messages, but no messages are being sent out.
Petre, I encountered this problem about a month ago. Sadly, I never solved it. I think you're headed for a lot of pain using PHPlist and the mass mailer module. IMHO, PHPlist is very poorly documented and fairly buggy. (I'm clearly not alone in this perception. Google on "phplist" or "phplist (swear word)" and you'll find a lot of unhappy users.) The instructions for mass mailer module were not so great either. Specifically, they didn't make it clear where to install PHPlist so that the Drupal integration would work properly. I spent a few hours fiddling with two seemingly likely answers and neither one worked. (See support request at http://drupal.org/node/21637, filed a month ago, still unanswered.) I eventually gave up and installed Mailman (www.list.org) instead. There's no integration (yet?) with Drupal and it isn't quite what I wanted (PHPlist's feature set is much closer to what I need), but ... Mailman is a very mature piece of software and I was able to get it up and running quickly and easily, despite my complete lack of Python skills. :-) -Eric -- Eric Scouten Photography | www.ericscouten.com (Drupal powered!) Fine art prints from the world of nature
On Mon, 30 May 2005, Eric Scouten wrote:
Petre Scheie wrote:
I installed the mass mailer module, and can create messages, but no messages are being sent out.
Petre,
I encountered this problem about a month ago. Sadly, I never solved it.
I think you're headed for a lot of pain using PHPlist and the mass mailer module. IMHO, PHPlist is very poorly documented and fairly buggy. (I'm clearly not alone in this perception. Google on "phplist" or "phplist (swear word)" and you'll find a lot of unhappy users.)
The instructions for mass mailer module were not so great either. Specifically, they didn't make it clear where to install PHPlist so that the Drupal integration would work properly. I spent a few hours fiddling with two seemingly likely answers and neither one worked. (See support request at http://drupal.org/node/21637, filed a month ago, still unanswered.)
I've never installed phplist, but I've spoken to Aaron Welch (the massmailer developer) and he said that phplist would be fairly stable. I think many people must be using the massmailer, too, as it is shipped with civicspace.
I eventually gave up and installed Mailman (www.list.org) instead. There's no integration (yet?) with Drupal
Mathias and I have been working on it and I can say that it was a most royal PITA. Since mailman uses some python constructs for storing its data, it cannot interface directly with PHP or MySQL and we needed to resort to screenscraping to get the info we needed. We got it somewhat working, but lost interest afterwards. An alternative solution would be to execute the commandline tools that come with mailman from php, but this solution doesn't appeal to me either.
and it isn't quite what I wanted (PHPlist's feature set is much closer to what I need), but ...
What would probably be fairly easy (compared to Mailman) would be integration of Sympa (another mailing list programm). It stores its data in mysql, too, and the data could thus be manipulated from within Drupal. If I'd get some funding, I'd work on it. I've been meaning to set up a reverse bounty for this, but haven't figured out how to do that yet.
Mailman is a very mature piece of software and I was able to get it up and running quickly and easily, despite my complete lack of Python skills. :-)
Mailman has its own issues, believe me. Om occassion some mails with multilingual content still get stuck in the queue for example. Cheers, Gerhard
On May 30, 2005, at 6:21 AM, Gerhard Killesreiter wrote:
If I'd get some funding, I'd work on it. I've been meaning to set up a reverse bounty for this, but haven't figured out how to do that yet.
I wonder if the Drupal community itself could fund some of this work. Suppose 50 people agreed to donate $25 USD to help fund mailing list/Drupal integration? Is that too much? Too little? Could we use the Drupal fund as the fiscal agent for user community projects? Andrew ------------------------------------------------- Andrew Michael Cohill, Ph.D. Information architect Design Nine provides technology master planning services, community network planning, technology audits, and telecommunications project management to communities and organizations trying to make wise technology and telecommunications expenditures. Design Nine represents the interests of the organization or community, rather than the interests of vendors. Visit the Design Nine News page for frequently updated news and commentary on technology issues. http://www.designnine.com/news/ Design Nine, Inc. http://www.designnine.com/ Blacksburg, Virginia Voice: 540.951.4400 Cell: 540.320.4406
On Mon, 30 May 2005, Andrew Cohill wrote:
On May 30, 2005, at 6:21 AM, Gerhard Killesreiter wrote:
If I'd get some funding, I'd work on it. I've been meaning to set up a reverse bounty for this, but haven't figured out how to do that yet.
I wonder if the Drupal community itself could fund some of this work. Suppose 50 people agreed to donate $25 USD to help fund mailing list/Drupal integration? Is that too much? Too little?
I haven't figured out what would be an appropriate amount yet, but that sounds about right.
Could we use the Drupal fund as the fiscal agent for user community projects?
Well, if there were such a fund, we might be able to do so, but there isn't yet. My idea was to use donorge.org for this kind of project as I think Boris Mann has done previously. Cheers, Gerhard
Hi, Hope everybody is doing well. I am racing to get our website up and running. 1. We had the taxonomy menu module installed and now I don't see how to create a link to an outside website from the menu system. How does this work? 2. I am getting this message every other click or so. It works once or twice, then it gives this error. If I try to refresh several times, it usually does the next request. Anybody have any ideas? Warning: mysql_connect(): Unknown MySQL Server Host 'supremeserver22.com' (2) in /home/www/bnmcnews.com/newdrupal/includes/database.mysql.inc on line 31 Unknown MySQL Server Host 'supremeserver22.com' (2) Regards
first of all: please do not reply to an existing message, with a new one, it breaks threading! Op dinsdag 31 mei 2005 06:52, schreef Christopher Taylor:
1. We had the taxonomy menu module installed and now I don't see how to create a link to an outside website from the menu system. How does this work?
This is not (yet) possible
2. I am getting this message every other click or so. It works once or twice, then it gives this error. If I try to refresh several times, it usually does the next request. Anybody have any ideas?
Warning: mysql_connect(): Unknown MySQL Server Host 'supremeserver22.com' (2) in /home/www/bnmcnews.com/newdrupal/includes/database.mysql.inc on line 31 Unknown MySQL Server Host 'supremeserver22.com' (2)
it means that you mysql server is either down of wrongly configured, you should contact your hosting-provider or server maintainer about this. Regards, Bèr -- [ Bèr Kessels | Drupal services www.webschuur.com ]
Well, Are you certain there was no way to have a menu link to an outside web address? I could have sworn I did it once or saw some directions about it. ----- Original Message ----- From: "Bèr Kessels" <berdrupal@tiscali.be> To: <drupal-support@drupal.org> Sent: Tuesday, May 31, 2005 3:25 AM Subject: Re: [drupal-support] strange error and menu question
first of all: please do not reply to an existing message, with a new one, it breaks threading!
Op dinsdag 31 mei 2005 06:52, schreef Christopher Taylor:
1. We had the taxonomy menu module installed and now I don't see how to create a link to an outside website from the menu system. How does this work?
This is not (yet) possible
2. I am getting this message every other click or so. It works once or twice, then it gives this error. If I try to refresh several times, it usually does the next request. Anybody have any ideas?
Warning: mysql_connect(): Unknown MySQL Server Host 'supremeserver22.com' (2) in /home/www/bnmcnews.com/newdrupal/includes/database.mysql.inc on line 31 Unknown MySQL Server Host 'supremeserver22.com' (2)
it means that you mysql server is either down of wrongly configured, you should contact your hosting-provider or server maintainer about this.
Regards, Bèr -- [ Bèr Kessels | Drupal services www.webschuur.com ] -- [ Drupal support list | http://lists.drupal.org/ ]
On 31 May 2005, at 12:55 AM, Christopher Taylor wrote:
Well, Are you certain there was no way to have a menu link to an outside web address? I could have sworn I did it once or saw some directions about it.
Christopher, you can create a new block containing links to an outside site, and position this block to appear above (or below) the existing navigation (menu) block. administer > blocks > add then type the title of the block and hyperlink(s) to the site(s) you want. Save the block and then position it relative to the Navigation block on the administer > blocks page.
2. I am getting this message every other click or so. It works once or twice, then it gives this error. If I try to refresh several times, it usually does the next request. Anybody have any ideas?
Warning: mysql_connect(): Unknown MySQL Server Host
'supremeserver22.com'
(2) in /home/www/bnmcnews.com/newdrupal/includes/database.mysql.inc on line 31 Unknown MySQL Server Host 'supremeserver22.com' (2)
I suspect that something is going wrong with your ISP's name service configuration. Perhaps they have some kind of load balancing, and one of the addresses is not properly configured.
On Tue, 31 May 2005, Christopher Taylor wrote:
Hope everybody is doing well. I am racing to get our website up and running.
1. We had the taxonomy menu module installed and now I don't see how to create a link to an outside website from the menu system. How does this work?
The taxonomy_menu module only creates menus from predefined vocabularies. By this property, all the links are internal.
2. I am getting this message every other click or so. It works once or twice, then it gives this error. If I try to refresh several times, it usually does the next request. Anybody have any ideas?
Warning: mysql_connect(): Unknown MySQL Server Host 'supremeserver22.com' (2) in /home/www/bnmcnews.com/newdrupal/includes/database.mysql.inc on line 31 Unknown MySQL Server Host 'supremeserver22.com' (2)
Well, apparently the server is less than supreme. ;-) If your database is hosted on another server than your webserver and the connection is a bit flaky (as the above message seems to suggest) then it might be worthwhile to change mysql_connect to mysql_pconnect in the function db_connect in the file database.mysql.inc. Cheers, Gerhard
Count me in Ron InterNet Marketing Resource Center A Free Super Mart of Articles, Demos, Tutorials everything you need to Succeed on the net. www.inmrc.com -----Original Message----- From: Andrew Cohill [mailto:cohill@designnine.com] Sent: Monday, May 30, 2005 10:34 AM To: drupal-support@drupal.org Subject: [drupal-support] Mass mailer funding On May 30, 2005, at 6:21 AM, Gerhard Killesreiter wrote:
If I'd get some funding, I'd work on it. I've been meaning to set up a reverse bounty for this, but haven't figured out how to do that yet.
I wonder if the Drupal community itself could fund some of this work. Suppose 50 people agreed to donate $25 USD to help fund mailing list/Drupal integration? Is that too much? Too little? Could we use the Drupal fund as the fiscal agent for user community projects? Andrew ------------------------------------------------- Andrew Michael Cohill, Ph.D. Information architect Design Nine provides technology master planning services, community network planning, technology audits, and telecommunications project management to communities and organizations trying to make wise technology and telecommunications expenditures. Design Nine represents the interests of the organization or community, rather than the interests of vendors. Visit the Design Nine News page for frequently updated news and commentary on technology issues. http://www.designnine.com/news/ Design Nine, Inc. http://www.designnine.com/ Blacksburg, Virginia Voice: 540.951.4400 Cell: 540.320.4406
Andrew Cohill wrote:
On May 30, 2005, at 6:21 AM, Gerhard Killesreiter wrote:
If I'd get some funding, I'd work on it. I've been meaning to set up a reverse bounty for this, but haven't figured out how to do that yet.
I wonder if the Drupal community itself could fund some of this work. Suppose 50 people agreed to donate $25 USD to help fund mailing list/Drupal integration? Is that too much? Too little? Could we use the Drupal fund as the fiscal agent for user community projects?
Count me in as well. I'd be happy to have a better (read: integrated) solution for mailing lists. -Eric -- Eric Scouten Photography | www.ericscouten.com (Drupal powered!) Fine art prints from the world of nature
On Tue, 31 May 2005, Eric Scouten wrote:
Andrew Cohill wrote:
On May 30, 2005, at 6:21 AM, Gerhard Killesreiter wrote:
If I'd get some funding, I'd work on it. I've been meaning to set up a reverse bounty for this, but haven't figured out how to do that yet.
I wonder if the Drupal community itself could fund some of this work. Suppose 50 people agreed to donate $25 USD to help fund mailing list/Drupal integration? Is that too much? Too little? Could we use the Drupal fund as the fiscal agent for user community projects?
Count me in as well. I'd be happy to have a better (read: integrated) solution for mailing lists.
This starts to get interesting from an economic point of view as well. ;-) I'll have a second look at Sympa and draft a proposal. My current idea is to "simply" duplicate most/all of Sympa's user and admin interface in Drupal. That of course assumes that you have set up Sympa already. Does that sound like it would be usefull? Development plattform would be Drupal 4.6 and Sympa 5.0. Depending on how much the database table structure of Sympa changed between releases, earlier versions might be usable, too. I'll need to investigate this. I imagine the installation instructions would be similar to: 1) Install Sympa (pointer to URL) 2) Configure Sympa database in settings.php (the usual Drupal config string becomes $db_url['default'], add $db_url['sympa'] with pass, user, and database for sympa) 3) Install sympa.module by copying it to your modules directory and enabling it in Drupal's config. 4) Visit the Sympa module's settings page, configure permissions, etc. The hardest part would be 1) which would be outside my responsibility. ;) Cheers, Gerhard
his morning i rewrote forummail from CS. I must find out about the licence (it was original under some very odd licence) In any way: it now works nice and dandy with mlmmj and (ez)mmlm At least the first works very fine. Probalby possible to run on more systems, because i made the commandline system flexible (someone should do a security review though :) ) * I invesitgated about 50 tools on fresmeat for mailinglist handling, but they were all either: * In some strange progamming language, unavailable on most v-hosts (think python etc) * Performing bad (rule-of-thumb: scripts are ill-suited for mailinglist managing) * Far too bloated (providing fancy frontends etc) (ez)mlmmj are often used, but require qmail. mlmmj does not require that. In a nutshell: it works, forum integration is possible, with extra modules installed, and basic subscriptions for mailings work. downside: all configuration of mailinglists /must/ be done on the server, its too insecure to make drupal write all the config files no the server, IMO. I want to upload it to my sandbox, once i get the licence issues sorted out. anyone else interested in this path for mass-mailing? Op dinsdag 31 mei 2005 18:45, schreef Gerhard Killesreiter:
On Tue, 31 May 2005, Eric Scouten wrote:
Andrew Cohill wrote:
On May 30, 2005, at 6:21 AM, Gerhard Killesreiter wrote:
If I'd get some funding, I'd work on it. I've been meaning to set up a reverse bounty for this, but haven't figured out how to do that yet.
I wonder if the Drupal community itself could fund some of this work. Suppose 50 people agreed to donate $25 USD to help fund mailing list/Drupal integration? Is that too much? Too little? Could we use the Drupal fund as the fiscal agent for user community projects?
Count me in as well. I'd be happy to have a better (read: integrated) solution for mailing lists.
This starts to get interesting from an economic point of view as well. ;-)
I'll have a second look at Sympa and draft a proposal. My current idea is to "simply" duplicate most/all of Sympa's user and admin interface in Drupal. That of course assumes that you have set up Sympa already. Does that sound like it would be usefull?
Development plattform would be Drupal 4.6 and Sympa 5.0. Depending on how much the database table structure of Sympa changed between releases, earlier versions might be usable, too. I'll need to investigate this.
I imagine the installation instructions would be similar to:
1) Install Sympa (pointer to URL) 2) Configure Sympa database in settings.php (the usual Drupal config string becomes $db_url['default'], add $db_url['sympa'] with pass, user, and database for sympa) 3) Install sympa.module by copying it to your modules directory and enabling it in Drupal's config. 4) Visit the Sympa module's settings page, configure permissions, etc.
The hardest part would be 1) which would be outside my responsibility. ;)
Cheers, Gerhard Regards, Bèr -- [ Bèr Kessels | Drupal services www.webschuur.com ]
On Wed, 1 Jun 2005, [utf-8] Bèr Kessels wrote:
his morning i rewrote forummail from CS. I must find out about the licence (it was original under some very odd licence)
=:)
In any way: it now works nice and dandy with mlmmj and (ez)mmlm At least the first works very fine. Probalby possible to run on more systems, because i made the commandline system flexible (someone should do a security review though :) )
That is why I would exceedingly prefer a module that does not depend on calling anything from the command line. Also, mlmmj and mmlm are even less known than Sympa and thus less likely to be installed anywhere.
* I invesitgated about 50 tools on fresmeat for mailinglist handling, but they were all either:
* In some strange progamming language, unavailable on most v-hosts (think python etc)
Python, isn't _that_ strange. Mailman is in python, too.
* Performing bad (rule-of-thumb: scripts are ill-suited for mailinglist managing)
True. (Although Smartlist is still used)
* Far too bloated (providing fancy frontends etc)
(ez)mlmmj are often used, but require qmail. mlmmj does not require that.
In a nutshell: it works, forum integration is possible, with extra modules installed, and basic subscriptions for mailings work.
downside: all configuration of mailinglists /must/ be done on the server,
I think that is what the people who indicated interest in a sympa.module would like to avoid. I still need to investigate whether this would be possible.
its too insecure to make drupal write all the config files no the server, IMO.
I want to upload it to my sandbox, once i get the licence issues sorted out.
anyone else interested in this path for mass-mailing?
Darix had suggested mlmmj to me as well and I turned him down. My opinion hasn't changed. Even if only the subscriber database for a server-defined mailing list could be managed, integration on the SQL level is a) more elegant and b) more secure. Don't know about mlmmj, but Sympa is also very nicely documented (120 pages). I'll need to read a couple more pages to write the proposal. ;) Cheers, Gerhard
We're already using Mailman. It's great as a standalone mailer, but I'm trying to find something that integrates with a CMS. PHPList sounded ideal because we use the mailer just to send out meeting notices to members of our group, rather than as a means for everyone to send messages to everyone. And PHPList describes itself as more of a broadcast kind of tool. Our website just lists meeting notices, and I was hoping I could craft a system in which the mailer could be used to, say, send out weekly messages listing the meetings planned for the next two weeks. As I said, Mailman's a great tool, but it doesn't play very well with others. Having drupal just call the command-line tools of Mailman would work, even if it's a bit inelegant. Petre Gerhard Killesreiter wrote:
On Mon, 30 May 2005, Eric Scouten wrote:
Petre Scheie wrote:> > I installed the mass mailer module, and can create messages, but no> > messages are being sent out.>> Petre,>> I encountered this problem about a month ago. Sadly, I never solved it.>> I think you're headed for a lot of pain using PHPlist and the mass> mailer module. IMHO, PHPlist is very poorly documented and fairly buggy.> (I'm clearly not alone in this perception. Google on "phplist" or> "phplist (swear word)" and you'll find a lot of unhappy users.)>> The instructions for mass mailer module were not so great either.> Specifically, they didn't make it clear where to install PHPlist so that> the Drupal integration would work properly. I spent a few hours fiddling> with two seemingly likely answers and neither one worked. (See support> request at http://drupal.org/node/21637, filed a month ago, still> unanswered.)
I've never installed phplist, but I've spoken to Aaron Welch (themassmailer developer) and he said that phplist would be fairly stable. Ithink many people must be using the massmailer, too, as it is shippedwith civicspace.
I eventually gave up and installed Mailman (www.list.org) instead.> There's no integration (yet?) with Drupal
Mathias and I have been working on it and I can say that it was a mostroyal PITA. Since mailman uses some python constructs for storing itsdata, it cannot interface directly with PHP or MySQL and we needed toresort to screenscraping to get the info we needed. We got it somewhatworking, but lost interest afterwards. An alternative solution would be to execute the commandline tools thatcome with mailman from php, but this solution doesn't appeal to meeither.
and it isn't quite what I> wanted (PHPlist's feature set is much closer to what I need), but ...
What would probably be fairly easy (compared to Mailman) would beintegration of Sympa (another mailing list programm). It stores itsdata in mysql, too, and the data could thus be manipulated from withinDrupal. If I'd get some funding, I'd work on it.I've been meaning to set up a reverse bounty for this, but haven'tfigured out how to do that yet.
Mailman is a very mature piece of software and I was able to get it up> and running quickly and easily, despite my complete lack of Python> skills. :-)
Mailman has its own issues, believe me. Om occassion some mails withmultilingual content still get stuck in the queue for example. Cheers, Gerhard -- [ Drupal support list | http://lists.drupal.org/ ]
On Mon, 30 May 2005, Petre Scheie wrote:
We're already using Mailman. It's great as a standalone mailer, but I'm trying to find something that integrates with a CMS. PHPList sounded ideal because we use the mailer just to send out meeting notices to members of our group, rather than as a means for everyone to send messages to everyone. And PHPList describes itself as more of a broadcast kind of tool.
If you just need to send mail to a (probably small) number of users you can just use the PHP mail() function. No need for massmailing capabilities. You could even let Drupal send mail to the mailman mailing list. Cheers, Gerhard
I like the idea of integrating Sympa, especially if I can't get the PHPList module working. As I mentioned, we're already using Mailman, but that's only useful for email list management. We also have a separate list of member info, some with email addresses, some without, that we want to merge with the mailing list into a single list. The idea is that we have one system that handles all member info, allows us to send email to the email addresses, send snailmail to those without email addresses, manages the notices we post on the website, and allows the member list to be managed via the website (including allowing people to manage their own ID/email address), so that we can delegate some of those tasks to various people. Drupal with the massmailer, dba, and events modules seems to fit the bill if I can get it all working. As for the number of users, the mailing list has about 1300, while the other member db has about 3000 entries. There's probably some overlap between them but I have no idea how much. I think we could contribute a bit to the bounty funding, too. Petre Gerhard Killesreiter wrote:
On Mon, 30 May 2005, Petre Scheie wrote:
We're already using Mailman. It's great as a standalone mailer, but I'm> trying to find something that integrates with a CMS. PHPList sounded> ideal because we use the mailer just to send out meeting notices to> members of our group, rather than as a means for everyone to send> messages to everyone. And PHPList describes itself as more of a> broadcast kind of tool.
If you just need to send mail to a (probably small) number of users youcan just use the PHP mail() function. No need for massmailingcapabilities. You could even let Drupal send mail to the mailman mailinglist. Cheers, Gerhard -- [ Drupal support list | http://lists.drupal.org/ ]
If I'd get some funding, I'd work on it. I've been meaning to set up a reverse bounty for this, but haven't figured out how to do that yet.
A non-profit I volunteer for would also be interested in this integration, so expect some funding from us if you set up this bounty. álvaro -- The Cocktail wwww -> http://the-cocktail.com blog -> http://furilo.com ring -> +34 91 567 06 05
participants (9)
-
Andrew Cohill -
Bèr Kessels -
Christopher Taylor -
Eric Scouten -
Gerhard Killesreiter -
Petre Scheie -
puregin -
Ron Mahon -
Álvaro Ortiz