provided by Star2Billing S.L.

I've been looking into why the low balance cron job isn't working. Well that's not true, I'm using the cron job as a template to send alerts for my post paid customers when they approach their credit limit, but anyway.

In the cron job, check account, the select statment is thus:


However, when I look at my data in the CC_CARD table, activated = 't' which I'm sure is the 'TRUE' value, but it doesn't tie in with the select statement

I'm not sure what else checks this column value so I'm wary of changing anything else.

Regards

Added after 1 hours 47 minutes:

It's worse than I thought. The check account scripts are brain dead. I'm working on them and will post rewrites shortly. Surprised no one's complained about this before. Customers get really upset if their accounts get suspended without notice


regards

I think the correct way to solve this would be to store this and other similar fields as booleans, as the SQL server should evaluate 't', 'true', 'y' and 'yes' to '1'.
I think the path of least resistance for you would be:but it would obviously be better to track down where it's being set to a bad value.

This grep shows that a2billing_bill_diduse.php is also affected. But people have been reporting that the did cronjob works well. Maybe it isn't working as well as it should or maybe they is more causes behing the a2billing_check_account.php problem.

I have been trying to get low balance mailed to people. so far I have not been successful. I must be doing something wrong. I got to /tmp I do not see a log for cront_check_account.log and no mail is sent I get a system mail

From [email protected] Wed Mar 19 06:00:02 2008
Return-Path: <[email protected]>
Received: from asterisk1.local (localhost [127.0.0.1])
by asterisk1.local (8.13.1/8.13.1) with ESMTP id m2JA01fD019842
for <[email protected]>; Wed, 19 Mar 2008 06:00:02 -0400
Received: (from asterisk@localhost)
by asterisk1.local (8.13.1/8.13.1/Submit) id m2JA01n0019841;
Wed, 19 Mar 2008 06:00:01 -0400
Date: Wed, 19 Mar 2008 06:00:01 -0400
Message-Id: <[email protected]>
From: [email protected] (Cron Daemon)
To: [email protected]
Subject: Cron <asterisk@asterisk1> php /var/lib/asterisk/agi-bin/libs_a2billing/crontjob/a2billing_check_account.php
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/var/lib/asterisk>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=asterisk>
X-Cron-Env: <USER=asterisk>

Content-type: text/html
X-Powered-By: PHP/4.3.11
that is all I get from the system is there something wrong with that part

the othere ones work fine only this one has problem.

any help would be appreciated.

thanks

Try commenting out the 'exit(0)' on line 25. Beware, it seems you're the first to use this code in anger so there may be bugs lurking.

I've completely re-writen this module for post pay and prepay customers. I haven't had a chance to figure out how to make the includes generic yet, in that you need to hard code the paths. The new code uses the updated sendmail functions that tell you if the message bouces as well.

I can post the code if you'd like

regards

Hey Nik. There's some code in another thread on this topic. I'm sure we'd all like to see what progress you've made.