Your HostICan Community  


Go Back   Your HostICan Community > Programming & Design > PHP / MySQL Assistance
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

PHP / MySQL Assistance We understand. Not all of you are experienced programmers, but some of you are highly skilled at coding. So we've set aside this forum so you can ask questions, and provide answers to the most commonly asked PHP / MySQL issues.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-16-2007, 11:26 PM
Junior Member
 
Join Date: Oct 2007
Posts: 1
Default PHPlist, queueing, throttling and cronjobs

So I'm using PHPlist. I have 1050 names on one list. HostICan has a limit of 100 messages per hour. So I throttled PHPlist back to send only 90.

The problem is, the cronjob to serially process the queue doesn't seem to be working. At 36 minutes after every hour, it's supposed to re-process the queue, but it doesn't. Here's my cronjob line:

36 * * * * cd '/home/[myusername]/public_html/[mydomainname]/lists/admin/' ; php -q index.php -p processqueue > /dev/null ;


Can anyone shed light on this?

== Steve
Reply With Quote
  #2 (permalink)  
Old 10-17-2007, 12:50 AM
Scott's Avatar
Senior Member
 
Join Date: Sep 2007
Location: hostican-coupon.com
Posts: 1,139
Default

If you have a VPS or dedicated server, you can login to SSH and run the command
Code:
cd '/home/[myusername]/public_html/[mydomainname]/lists/admin/' ; php -q index.php -p processqueue
and see what error you are getting.

Personally, I'd run a simple wget.
Code:
/usr/bin/wget -q -O /dev/null http://www.[mydomainname].com/lists/admin/index.php
I just don't know what you what switch you'd need to execute the "processqueue" part.
__________________
HostICan Discount - New customer? Save $50 on your HostICan hosting purchase!
HostICan Hosting Reviews - See what other customers say about HostICan.
Simple Hosting - Web Hosting Made Simple!
Reply With Quote
  #3 (permalink)  
Old 10-17-2007, 08:54 PM
Shazam's Avatar
Forum Whip-Cracker
 
Join Date: Sep 2007
Posts: 766
Default

Quote:
Originally Posted by Scott View Post
If you have a VPS or dedicated server, you can login to SSH and run the command
Code:
cd '/home/[myusername]/public_html/[mydomainname]/lists/admin/' ; php -q index.php -p processqueue
and see what error you are getting.

Personally, I'd run a simple wget.
Code:
/usr/bin/wget -q -O /dev/null http://www.[mydomainname].com/lists/admin/index.php
I just don't know what you what switch you'd need to execute the "processqueue" part.
Speaking of phpList, Scott, if you're expert at this, I might call upon you to migrate my lists over to it, but its instructions are a little obtuse. Not as horrible as Mailman, but I'd appreciate guidance -- or from anyone else skilled at this.
__________________
Best,
Shazam
HostICan Community Superhero
Reply With Quote
  #4 (permalink)  
Old 10-18-2007, 12:13 AM
Scott's Avatar
Senior Member
 
Join Date: Sep 2007
Location: hostican-coupon.com
Posts: 1,139
Default

Def not an expert at mailing scripts. I just know a lil cron.
__________________
HostICan Discount - New customer? Save $50 on your HostICan hosting purchase!
HostICan Hosting Reviews - See what other customers say about HostICan.
Simple Hosting - Web Hosting Made Simple!
Reply With Quote
  #5 (permalink)  
Old 02-16-2008, 03:18 PM
Junior Member
 
Join Date: Feb 2008
Posts: 1
Default

I am not sure if anyone who was having trouble with PHPList is still watching this thread, but in case you are, I have been able to set up an installation of PHPList on a shared hosting account that has SSH access. The part that I had the most trouble with (3 days!!!) was getting everything straight with the cron job. I finally figured out that with HostICan you MUST make sure that you are running PHP from the correct location and that you are using the correct user information from your PHPList installation. My cron command is pasted below. If you have trouble, send me an email and I might be able to help you out.

This is pasted into the timing section
minute: */15
the rest of them are *

This is pasted into the command part:
nice -n 15 USER=PHPLISTUSER; export USER; /usr/local/bin/php /home/USERNAMEWITHHOSTICAN/public_html/paulandkatie/lists/admin/index.php -p processqueue

*I know that this is not technical cron format, but for the cPanel cron screen, this should do the trick.

Last edited by mastinpe : 02-16-2008 at 03:20 PM.
Reply With Quote
  #6 (permalink)  
Old 02-17-2008, 12:25 AM
lnxcode's Avatar
The British Kid
 
Join Date: Sep 2007
Location: Richmond, VA
Posts: 1,644
Send a message via AIM to lnxcode Send a message via Skype™ to lnxcode
Default

Quote:
Originally Posted by mastinpe View Post
I am not sure if anyone who was having trouble with PHPList is still watching this thread, but in case you are, I have been able to set up an installation of PHPList on a shared hosting account that has SSH access. The part that I had the most trouble with (3 days!!!) was getting everything straight with the cron job. I finally figured out that with HostICan you MUST make sure that you are running PHP from the correct location and that you are using the correct user information from your PHPList installation. My cron command is pasted below. If you have trouble, send me an email and I might be able to help you out.

This is pasted into the timing section
minute: */15
the rest of them are *

This is pasted into the command part:
nice -n 15 USER=PHPLISTUSER; export USER; /usr/local/bin/php /home/USERNAMEWITHHOSTICAN/public_html/paulandkatie/lists/admin/index.php -p processqueue

*I know that this is not technical cron format, but for the cPanel cron screen, this should do the trick.
Hey man,

Thanks for letting us know how to do it!
__________________
Thanks,

Denis Motova
Affiliate / Operations Manager

HostICan Answers | HostICan Newsletter | HostICan Blog | Become a HostICan Affiliate | Create a Support Ticket.
Reply With Quote
  #7 (permalink)  
Old 02-19-2008, 08:59 AM
Senior Member
 
Join Date: Sep 2007
Posts: 238
Default Just a personal rant!

Venting: Just my personal opinion, but cron on the VPS servers is just horrible!
I have 2 right now and have given up on it. When it runs, there are almost always errors (or nothing happens at all). When I use a webcron service and give it the same identical command, things run no problem! The only place I've ever had cron problems is on these VPS servers. Ugh. There! Rant over... Move along... Nothing more to see here...
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 07:07 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0

Copyright © 2003 - 2008 HostICan. All Rights Reserved.