user database is freezing up

[russ]

Hi Dean,

I'm testing my bounce function, so I added a bogus email address to my test list. Sent a test to the list, which it arrived ok, but now I try to go into user database and it won't bring the page up.  I guess it choked on this bounced address or something...?  

I went back in and switched my configuration from "use bounce cgi" to "disabled" and now the user database pops right up.  So I must have something wrong still in my bounce cgi somewhere..  

I have double checked my .qmail-bounce.txt address (/var/www/html/mailer/cgi/bounce.cgi)  

any ideas?

thanks

[DW]

There should be no reason for your database to lock up.  Perhaps the server is under heavy load and it took awhile for it to process the last command (bounce deletion).  Under normal circumstances there should be no delays here.

[russ]

maybe - it's a dual zeon x 2 with nothing else going on at all.  It lets me in now, but the "bad" email addr is still in the active list, even though the bounce is in the email box right now.  

Is it supposed to check automatically?  or do I need to do something to get it to perform the removal?  my config has use bounce.cgi checked.

I repeated the test send, same thing..  bounce message is in the email box bounce@....com, but the bad email addy is still in my list. How do I get it to remove the bounced email?  Also, when it does work properly does it also delete the bounce email from the email box?

thanks

[DW]

When bounce.cgi is enabled you do not, and should not, have an actual mailbox set up with the same name.  What you need is an "email alias" to catch all email sent to a certain address and forward it to the bounce.cgi script.  When you are using the mailbox method of handling bounces dailymail takes care of it.

Help with email aliases can be found at the following URL:
http://www.listmailpro.com/help/7.html

[russ]

What you need is an "email alias" to catch all email sent to a certain address and forward it to the bounce.cgi script.  

can you tell me what the command is to forward the emails to the cgi script?  I know how to do a forward to another email address, but not sure how to forward to cgi..

is it forwarded to bounce.cgi@mydomain.com  ?  or what?

thanks

[DW]

This is explained on the email aliases help page (noted above).

You need something like the following set up which forwards email sent to a certain address to a CGI script:

bounce@yoursite.com forwards to "|/path/to/your/cgi-bin/bounce.cgi"

If you cannot set this type of forward in your control panel you will have to ask your host if they can do it for you.

[russ]

now it gives me this message when I hit user database for any of the lists:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/mailer/edituser.php on line 1449

Also, all the databases have no users in them, they are missing. All of them say "1 of   "     Where did my users go?

[DW]

It's possible that your user database needs to be repaired.  This can happen if your host restarts the MySQL server or resets the server without shutting down properly.

Login to ListMail and browse to the following page:

http://yoursite.com/mail/editconf.php?customcmd=1

This page will let you run a custom MySQL command of your choice.

Enter the following and hit Go:

repair table lm_users;

Now, hit "Back" a couple times to get back into ListMail and you should be ok.

[russ]

I have run that command twice and both times failed - the browser timed out (The page cannot be displayed)

now the user databases are "frozen" again.  I click on any of them and they "green dot freeze".

what next?

[DW]

Do you have access to PhpMyAdmin from your hosting control panel?  If so, try running the repair command in there.

[russ]

my sql guy had a machine w/ linux only and he was able to run that program for me.

Everything seemed to be ok, until I tried to import a list of 50k.  Just like the last time, it gets to 9001 and "freezes".  Now all databases are "green dot frozen" again.  Exactly like last time, before I rebuilt the databases.

one thing that would help would be to be able to rebuild the databases without the browser.  or maybe individually w/ the browser..

anyway, now what sir?

[DW]

Under normal circumstances the databases never need to be repaired.  I agree that it would be useful to have this option via the Config page, however.  I will make note of this for the next release.

I wonder if you are running into a hard drive or host-imposed MySQL database size limitation on your server.  (though, a list of 50,000 shouldn't normally take more than 10MB, depending on the amount of data, custom etc., you store per user.)  It's hard to tell.  I would be willing / able to take a look with FTP access.  Please submit your information securely via the tech support system at the following URL:

http://listmailpro.com/support?t=other

[russ]

I have lists up there currently over 250,000.  It is my server exclusively, so there should be no restrictions.

I reboot and tried to do the repair and rebooted again.  The current message when I hit any user database is

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/mailer/edituser.php on line 1449

and the users are gone again.

Thanks for taking a look at it.