using drupal 4.6.3 and massmailer cvs after same problems with old massmailer... uninstalled and reinstalled massmailer.

everything seems okay except the messages never leave the queue.. even after clicking submit messages after their time has passed...
phplist file was 0755 now its 0777 just in case..

when viewing message in the queue they say submitted... never "sent"
no email goes out..

really want to get this going!

thanks
ryan grace

Comments

oliver soell’s picture

oliver soell commented

I will second this.. I have massmailer set up alongside phplist, instead of massmailer's crippled version of phplist (I need bounce processing and a few other features), and I cannot get massmailer to process the queue (admin/massmailer/queue).

This is what I get when I click send. The comment, of course, is not shown from massmailer unless you show source. It does show up from the command line.

p = processqueue
c = ../../config.php
d = /drupal/index.php
h = hostname.example.com
<!-- using ../../config.php -->
p = processqueue
c = ../../config.php
d = /drupal/index.php
h = hostname.example.com

All that looks fine, except when I go look at the messages, I still have "submitted" ones when they should be "sent." I can process the queue just fine from the phplist interface. I can also do everything else from massmailer just fine.

I can even run the phplist shellscript from the shell and it returns exactly the same info (after fixing it, of course).

any pointers?

killes@www.drop.org’s picture

killes@www.drop.org commented

Ryan: Did you import the phplist.mysql file? did you read te README in its most recent version?

Oliver: The table definitions from original phplist are a bit different from the ones we use.

oliver soell’s picture

oliver soell commented

Killes, absolutely, I did notice that there are some differences. Other than phplist using more tables, I noticed two differences between the 2.10.1/2 phplist.sql files and the massmailer supplied one - the "private" column in phplist_list table, and the "drupalid" column in the phplist_user_user table. I went through the differences by hand comparing 2.10.1 and massmailer, since the massmailer sql file was against 2.95, so I just wanted to make sure. I altered my tables appropriately, and receive no php errors from within drupal.

Everything else works in massmailer and the phplist engine. I can create lists, create messages, subscribe to lists, and all that, I just can't send (process the queue) without using the phplist interface.

I am not using CiviCRM, though, maybe this makes a difference.

thanks!

killes@www.drop.org’s picture

killes@www.drop.org commented

Oliver: be sure to use the phpmailer backend of phplist. The other backend has some issue with sending utf8 mails.

Veggieryan’s picture

Veggieryan commented

killes: I did add the mysql table as per the instructions. I saw something about phpsusexe or something in a forum post late one night.. could that be it...
really want to get this working...

also curious about using this with the full backend to integrate digests?

will keep cracking at it.
i am on a shared host a hostgator.com until I chose a new dedicated host.. thinking iweb.ca
i am also using FCKeditor as my wysiwyg in the mass mailer as well.
could be a problem?

cool.
ryan.

Veggieryan’s picture

Veggieryan commented

whoa.. just checked the readme from cvs...
is it really civiCRM only?
can i just upgrade from drupal 4.6.3 to civiCRM?

whew..
will do whatever it takes.

thanks
ryan.

Veggieryan’s picture

Veggieryan commented

okay... its late.
civiCRM is not civispace.
stop laughing.
still need help.

killes@www.drop.org’s picture

killes@www.drop.org commented

phpsuexec could be a problem, if only for the reason that I've never tried to install massmailer with it. Ive made some small changes to the phplist.module file, can you install it and look at the admin/settings/massmailer page? It should provide some debug output, please copy and paste it into this issue.

WRT CiviCRM: It is a replacement for the contact_manager module. Massmailer should work without it.

Another option is to install CivicSpace instead of Drupal. It has an installer that makes sure your settings are right.

killes@www.drop.org’s picture

killes@www.drop.org commented

another thing: You did run cron.php or the "send message" link from the menu?

Veggieryan’s picture

Veggieryan commented

hey killes,
I even had the support team at hostgator.com on it for days.
they replied that it should work now.
i have asked them to reply with their findings because it still doesnt work.
i was using poormanscron and pressing send messages manually.

1 thing: why does the time for the message to be sent always come up 8 hours after the current time even though my time zone settings in the system and my user profile are correct? is that normal? i have been changing the send time back to the current time to make it go out sooner.. could that be my problem?

also: can i just install civicspace over my current 4.6.3 drupal and use upgrade.php without problems? are there big differences in the code base that affect massmailer?

also, what is up with drop.org?
thanks bro,
ryan grace.
btw: i was in an arguement with a web consultant who uses plone... she said the devs for drupal were a bunch of hippies and she didnt trust them... then i asked her if plone had built in support to tie content with email like drupal.. she didnt know what that meant... hehe... i love drupal.. so much!!!!!

Veggieryan’s picture

Veggieryan commented

wow.
this is SO fustrating.
i have been at this everyday for over a week.
i give up!
why is it that the rc6 civispace download has no bin folder in the phplist file? its like its an incomplete file or something?
i have followed the directions to a T from scratch and now i get the
You do not have the php command line executable in your system path
and it cannot be located in /usr/bin or /usr/local/bin.
Please edit the modules/massmailer/engines/phplist/bin/phplist file to correct this.
error.
that file is not even included in the release?????!!!!????!!??
and it tries to point to an index.php file which is also not included in the release?!?!?!?!?
why cant all the files we need be where they need to be the first time?
why do i have to pick between so many incomplete and outdated releases to find the correct versions?

im no idiot and yet im beyond stumped on this.
please.
can someone make a tar.gz of a complete and working release so i dont have to piece together files that arent meant to work toghether?

thanks
ryan grace.
www.realenergy.net

killes@www.drop.org’s picture

killes@www.drop.org commented

I've downloaded the rc6 and the phplist file is there together with the bin directory. In fact, the error message is from that phplist file, so it must be somewhere.

do you have shell access on your machine? if yes try executing

which php

the result should be the path to the php command line executable.

PS: Plone sucks. ;)

Veggieryan’s picture

Veggieryan commented

hey,
thats wild.
the error message came up after i copied those files from separate cvs release... to make up for what wasnt there..
ive downloaded it so many times in firefox and ie... it comes up with a corrupt message from winrar but it always extracts without stopping and everything is there execpt those files.. including the index.php file in the admin folder.
did the rc6 come with the complete phplist engine already there?
the universe does not want me to get this working tonight.
maybe i will use a download manager like getright to make sure i get the whole file... its wierd that its the only one that gets this error.

i also put out a forum post and some emails seeking paid help from someone to login to my new host and get this going....

thanks so much...
sorry i was a bit hot in the last post.
ryan.

ps: elaborate on why plone sucks.... other than that drupal is so much cooler.

killes@www.drop.org’s picture

killes@www.drop.org commented

please try to install the CS RC as an install from scratch on the same server if at all possible, The installer will make sure that you either have the correct settings or get appropriate error messages. Afterwards we can secide if your server will be able to run massmailer at all. If you can't install from scratch, you really need to make sure you got all the files in the right directories. The RC from CSL comes with phplist.

Plone is probably quite ok, we just had reports that it would not scale for a larger number of users.

Veggieryan’s picture

Veggieryan commented

did it
fresh rc 6 install of lates cs download.

fresh database deleted entire public_html

now i am further back then before....

now i get the dreaded

You do not have the php command line executable in your system path
and it cannot be located in /usr/bin or /usr/local/bin.
Please edit the modules/massmailer/engines/phplist/bin/phplist file to correct this.

modules/massmailer/engines/phplist/bin/phplist is 757

before CS i was at least getting messages into the queue...
they just got stuck in submit.

cs install said everything was kosher.
oh well.
i am on shared hosting until monday when our new dedicated host will be up.
really need to figure this out...

what do you think?
ryan

joshon’s picture

joshon commented

People following this thread may also find this thread useful: http://drupal.org/node/39394