List Info

Thread: send-reminder-digests.pl
send-reminder-digests.pl
user name
 2006-11-28 17:06:32 

  


  

    Hi 
all,

I've been working on 
implementing the send-reminder-digests.pl and I've been running some tests of 
the script trying to get it to send the email but can't get it to. I've modified 
the sql query so that it will only return my email address until I get it set up 
the way I like:


 


SELECT   
maia_users.id, users.email
  FROM   ;  maia_users, 
users
  WHERE ;   users.email = ias.net'">'mitchias.net'
  ;         
AND maia_users.quarantine_digest_interval > 0
  ORDER BY 
maia_users.id ASC;


 


Running that in 
mySQL returns my id and email instead of the list of all the email addresses, so 
that seems to be what I want. When I run the script (as my amavis user or as 
root) nothing happens. Nothing is sent and there are no errors. I checked file 
permissions on the template file and maia.conf - both were set to 640 with the 
group and owner being the amavis user, I changed that to 644 so root could read 
it as well and this didn't make a difference.


 


Is there any kind of 
debugging I could add to this or look at or does anyone have any 
ideas?


 






Best 
regards,


Mitch 
Planck


ias.net

  

  
  
   
     
    

  

    send-reminder-digests.pl
  


  

     user name

     2006-11-28 17:50:04
  


  

    
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Mitch Planck wrote:
> Hi all,
> I've been working on implementing the
send-reminder-digests.pl and I've
> been running some tests of the script trying to get it
to send the email
> but can't get it to. I've modified the sql query so
that it will only
> return my email address until I get it set up the way I
like:
>  
> SELECT   maia_users.id, users.email
>   FROM     maia_users, users
>   WHERE    users.email = 'mitchias.net'
>            AND maia_users.quarantine_digest_interval
> 0
>   ORDER BY maia_users.id ASC;
>  
> Running that in mySQL returns my id and email instead
of the list of all
> the email addresses, so that seems to be what I want.
When I run the
> script (as my amavis user or as root) nothing happens.

Your query doesn't specify how the 'users' and 'maia_users'
table should
be linked.  You're basically missing an 'AND' clause in
there, such as:

  AND users.maia_user_id = maia_users.id

That should get you what you're looking for.

- --
Robert LeBlanc <rjlrenaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamail
guard.com/>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFbHbMGmqOER2NHewRAmWcAJ9NjeOvSi3tnIRsFfz29GE4yQ38gACf
aW7d
d4CxrfjEyPiekyW6Y5GWOeI=
=ZGdt
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users


  


  

    
  

  
  
   
     
    

  

    send-reminder-digests.pl
  


  

     user name

     2006-11-29 16:31:03
  


  

    
I got it so it will now send a message to me (I'm using the
stock SQL query
since I'm the only person with an interval set it just sends
to me) but it
doesn't have the list of items in my cache in it. This is
the extent of the
message:

[Log in] to manage your Maia account 
Maia Mailguard made the following decisions regarding you
email. If it made
a mistake, you may report any email that was presumed good,
but was actually
spam, and release any that were quarantined incorrectly by
clicking the
corresponding link.
[Confirm All Remaining Items]  

I haven't been confirming my items to test this but to no
avail.

Best regards,
Mitch

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users


  


  

    
  

  
  
   
     
    






 [1-3]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )