IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Email Stats
jchrastina
post Apr 25 2007, 07:32 PM
Post #1


Senior Member


Group: Members
Posts: 259
Joined: 26-April 03
From: Sellersville, Pennsylvania, USA
Member No.: 135



Main >> Email >> View Mail Statistics

How can I reset the stats for email in WHM? Or do I need to use a command in SSH? If so, what is the command? My email stats have been accumulating since I startted a new VPS in February. Each month, I would like to archive them, clear them out, and start fresh.
Thanks.
Go to the top of the page
 
+Quote Post
Dima
post Apr 26 2007, 06:17 AM
Post #2


Hostony staff


Group: Admin
Posts: 337
Joined: 7-October 04
Member No.: 1106



You can do it using the command /scripts/runweblogs username


--------------------
People are created to help each other. So, if one needs help it's our duty to do everything we can to make this person feel happy.
Go to the top of the page
 
+Quote Post
MarkM
post Apr 26 2007, 06:35 AM
Post #3


Super Moderator


Group: Members
Posts: 420
Joined: 19-December 05
From: Los Angeles, CA
Member No.: 1944



Now that's service! biggrin.gif


--------------------
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
| Mark Mutti [Super Moderator]
| I'm not a HOSTONY Staff Member, but if you need a post moderated or spam
| deleted please let me know.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Go to the top of the page
 
+Quote Post
jchrastina
post Apr 26 2007, 07:02 PM
Post #4


Senior Member


Group: Members
Posts: 259
Joined: 26-April 03
From: Sellersville, Pennsylvania, USA
Member No.: 135



Not so fast on "Now that's service"!
I tried to run that command from SSH and here's what I got:
root@node1 [/scripts]# runweblogs <my username>
-bash: runweblogs: command not found

Yet, if I run a DIR in that directory, I can see that 'runweblogs' is there.

What am I missing?
Go to the top of the page
 
+Quote Post
jchrastina
post Apr 26 2007, 07:14 PM
Post #5


Senior Member


Group: Members
Posts: 259
Joined: 26-April 03
From: Sellersville, Pennsylvania, USA
Member No.: 135



I found a partial answer at webhostingtalk.com
Someone there wrote:

"ok my mistake was entering the directory. If I type /scripts/runweblogs from the command prompt it worked. Thanks guys.
If you are already in the /scripts directory try typing:
./runweblogs"


Now, when I follow these instructions, I get a response from SSH, but I still get all the stats going back to early Feb. I want to CLEAR all the stats and start fresh.

What username should I use? My root? My VPS admin?

How?
Thanks.
Go to the top of the page
 
+Quote Post
MartinB
post Apr 27 2007, 03:06 AM
Post #6


Super Member


Group: Members
Posts: 1804
Joined: 10-March 04
From: Cordoba, Argentina
Member No.: 554



Hi,

To clear the stats monthly you will need to set up a cron job that will empty the tables sends and smtp on the eximstats db. That or you can go in via the WHM phpmyadmin and do it manually each month.


--------------------
Go to the top of the page
 
+Quote Post
jchrastina
post Apr 27 2007, 12:29 PM
Post #7


Senior Member


Group: Members
Posts: 259
Joined: 26-April 03
From: Sellersville, Pennsylvania, USA
Member No.: 135



Thanks MartinB, but I cannot find myphpadmin in WHM anywhere.

Go to the top of the page
 
+Quote Post
MartinB
post Apr 27 2007, 12:47 PM
Post #8


Super Member


Group: Members
Posts: 1804
Joined: 10-March 04
From: Cordoba, Argentina
Member No.: 554



QUOTE(jchrastina @ Apr 27 2007, 09:29 AM) *
Thanks MartinB, but I cannot find myphpadmin in WHM anywhere.


is "phpMyAdmin", and you can found it under the "SQL Services" section of your WHM (remember to login as root) smile.gif


--------------------
Go to the top of the page
 
+Quote Post
jchrastina
post Apr 28 2007, 12:27 AM
Post #9


Senior Member


Group: Members
Posts: 259
Joined: 26-April 03
From: Sellersville, Pennsylvania, USA
Member No.: 135



Thank you, Martin
I found phpMyAdmin right where you said.

In the left column, I chose database "eximstats".
In the right pane I put checkboxes in 'sends' and 'smtp'
Below that, I used the drop down to select [Empty]
I am prompted with 'Do you really want to TRUNCATE sends and smtp. I click [Yes]
Result: Your SQL query has been executed successfully.

Now, when I go back to the Main menu of WHM, select "Email", select "View Mail Statistics", I get:

Exim statistics from 2007-02-12 22:14:10 to 2007-04-28 04:17:04

But I don't WANT statistics since 12-Feb. I want to CLEAR the statistics and start FRESH.
How can I do that?
Thanks for your help.
JimC
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



Lo-Fi Version Time is now: 18th January 2018 - 05:47 PM