This website requires JavaScript.
72e7f2a5c5
* Fri Sep 12 2025 Brian Read <brianr@koozali.org > 11.1-10.sme - Fix version and build date from spec file [SME: 13121]
master
11_1-10_el8_sme
Brian Read
2025-09-13 08:56:14 +01:00
248bbed240
* Fri Sep 12 2025 Brian Read <brianr@koozali.org > 11.1-9.sme - Fix version and build date from spec file [SME: 13121]
11_1-9_el8_sme
Brian Read
2025-09-12 18:20:15 +01:00
a9dbafc584
* Fri Sep 12 2025 Brian Read <brianr@koozali.org > 11.1-8.sme - Remove www from systemd-journal group and setuid bit in journal wrapper [SME: 13121]
11_1-8_el8_sme
Brian Read
2025-09-12 12:23:48 +01:00
55cb7a6f05
* Fri Sep 12 2025 Brian Read <brianr@koozali.org > 11.1-7.sme - Truncate Geoip table and add other category [SME: 13121] - Cope with blank data in action1 [SME: 13121]
11_1-7_el8_sme
Brian Read
2025-09-12 11:26:35 +01:00
1b757b1336
* Thu Sep 04 2025 Brian Read <brianr@koozali.org > 11.1-6.sme - Add favicon to mailstats table, summary and detailed pages [SME: 13121] - Bring DB config reading for mailstats itself inline with php summary and detailed logs - using /etc/mailstats/db.php [SME: 13121] - Remove DB config fields from the SM2 config panel {sme: 13121] - Arrange for password to be generated and mailstats user to be set with limited permissions [SME: 13121]
11_1-6_el8_sme
Brian Read
2025-09-08 15:24:18 +01:00
52b33e166a
Sort out DB params access for mailstats, remove DB config from SM2
Brian Read
2025-09-07 09:18:39 +01:00
88bc38adf3
Add favicon to table, summ,ary and details webpages
Brian Read
2025-09-04 19:28:36 +01:00
b070554fdd
Get journal api wrapper working for detailed logs
11_1-5_el8_sme
Brian Read
2025-09-04 13:17:44 +01:00
2dd3d234df
Add in two tables on header, sort out permission and ownership of params file
Brian Read
2025-09-04 10:04:25 +01:00
d94bf8e033
Get detail logs page working - WIP
Brian Read
2025-09-03 11:00:00 +01:00
5deb31cd92
Extra security for php part of mailstats web
Brian Read
2025-09-02 11:23:48 +01:00
f86021b8c9
Fix missing blacklist URLs from report
Brian Read
2025-09-02 10:17:26 +01:00
a77cb094df
Optimise journal access speeding up processing
Brian Read
2025-09-02 08:48:48 +01:00
d81543187f
* Mon Sep 01 2025 Brian Read <brianr@koozali.org > 11.1-4.sme - More fixes for Journal bytes instead of characters [SME: 13117]
11_1-4_el8_sme
Brian Read
2025-09-01 15:29:28 +01:00
76ca0f528c
* Mon Sep 01 2025 Brian Read <brianr@koozali.org > 11.1-3.sme - Sort out ASCII escape codes in return from journalctl API [SME: 13117] - Add in Status enabled t default for mailstats DB [SME: 13118]
11_1-3_el8_sme
Brian Read
2025-09-01 10:37:44 +01:00
1858edc41c
First build with Koji
Brian Read
2025-08-30 11:08:40 +01:00
056992272d
* Sun Apr 06 2025 Brian Read <brianr@koozali.org > 11.1-2.sme - Add in SM2 panel [SME: ]
11_1-2_el8_sme
Brian Read
2025-08-30 11:03:52 +01:00
3de794d90d
Update spec file requires with plotly
Brian Read
2025-08-29 11:44:58 +01:00
34fd81cd51
Fix crash when no emails found
Brian Read
2025-06-18 06:29:38 +01:00
1258b41ad8
Move log to /var/log, make most messages DEBUG and log INFO start and finish
Brian Read
2025-04-12 12:37:09 +01:00
9453031df3
Restore greyed print date (regression)
Brian Read
2025-04-12 12:03:15 +01:00
756e0f94c3
Make text version a bit more readable
Brian Read
2025-04-12 11:52:07 +01:00
f885ab684e
Supress prev and next links when inside iframe
Brian Read
2025-04-10 19:48:59 +01:00
7504f32ce7
Add tooltips to black lists
Brian Read
2025-04-10 12:18:05 +01:00
9dc7d3d7a1
forgot mailstats-custom changes
Brian Read
2025-04-10 09:17:59 +01:00
89475c0aa3
Enable/disable rbl,sbl,uribl setting according to db property
Brian Read
2025-04-10 09:02:57 +01:00
b513dfc9be
Make country codes update respect any extra ones added manaually
Brian Read
2025-04-09 11:00:44 +01:00
32d91c4a24
Sort out text version of table etc
Brian Read
2025-04-08 18:57:30 +01:00
2d1824553b
Typo in TagLevel processing
Brian Read
2025-04-07 18:18:29 +01:00
e610abd351
Fix up various typos caused by global editting
Brian Read
2025-04-07 18:11:31 +01:00
8d8c97d1fa
Get table display by date working on front page of mailstats panel
Brian Read
2025-04-07 14:31:16 +01:00
a58191f667
Update to mailstats panel
Brian Read
2025-04-06 20:32:49 +01:00
7fcdfccfa6
Add in code for mailstats panel in SM2 - not complete
Brian Read
2025-04-05 12:19:40 +01:00
cd4a0b1725
Move to use logging lib for logs, update runmailstats.sh for no manipulation of logs files
Brian Read
2025-04-04 10:20:07 +01:00
3b0b574171
Fix SQL creation of user and move log anaysis to use python systemd - journal lib
Brian Read
2025-04-03 20:15:41 +01:00
da71021889
Switch graphs to matplotlib which does not require internet access
Brian Read
2025-03-31 08:44:27 +01:00
4d29da7f3d
Correct links to mailstats webpage, add -q to pip3 in spec
Brian Read
2025-03-28 12:22:55 +00:00
736315d47e
Add in Blacklist sub report
Brian Read
2025-03-28 11:19:01 +00:00
40daa827c4
Add threshold for subtables
Brian Read
2025-03-28 05:42:48 +00:00
2d54c4f7f5
Sort out switch to pymysql and add SME10 log convert and runmailstats for SME10
Brian Read
2025-01-13 18:50:30 +00:00
fce93e1dcd
Sort out css and html for subtables
Brian Read
2025-01-12 16:38:56 +00:00
eff56815da
Minor change to format for port count label format
Brian Read
2025-01-12 07:30:45 +00:00
d1ddf5d04c
Stremaline some table headings and add counts of port used by incoming email
Brian Read
2025-01-11 16:19:27 +00:00
f2f4078bb8
Comment out W3c icons on table until I've finished and can check it
Brian Read
2025-01-11 11:35:16 +00:00
9bfaa754e6
Take out extraneous characters from python version
Brian Read
2025-01-11 11:29:50 +00:00
9739f78b19
Fix up format according to actual log
Brian Read
2025-01-11 11:12:02 +00:00
d4961059b6
Fix junk mail counts table
Brian Read
2025-01-10 09:30:26 +00:00
93b5eb22ab
Fix virus counts in sub table
Brian Read
2025-01-10 09:18:33 +00:00
f57b0c6e43
Fix recipient email counts
Brian Read
2025-01-09 10:41:12 +00:00
dce1df37db
changes to SMTP connect type stats
Brian Read
2025-01-06 16:48:43 +00:00
e1250779de
Fix up recipient email and qpsmtpd plugin counts
Brian Read
2025-01-05 18:15:42 +00:00
372d2b45dd
Add in recipient email table
Brian Read
2025-01-02 09:50:44 +00:00
9be485a1a9
Add in q/s/u psmtpd counts
Brian Read
2024-12-31 15:51:48 +00:00
9ebe02b80e
More fixes for log format and make perl and python run from same datafile
Brian Read
2024-12-31 13:34:23 +00:00
8be2103dec
Update python requirements in spec file
Brian Read
2024-12-30 16:23:44 +00:00
20a8d3b4ef
Edit python mailstats.py to accomodate new log format
Brian Read
2024-12-30 15:20:28 +00:00
51dd523249
update runmailstats.sh for new log names
Brian Read
2024-12-30 14:29:39 +00:00
a20b570e11
Sort out dates and hours for table
Brian Read
2024-12-30 14:27:35 +00:00
382489ecac
* Mon Dec 30 2024 Brian Read <brianr@koozali.org > 1.1-19.sme - Update mailstats.pl to accomodate change in log format for SME11 [SME: ]
Brian Read
2024-12-30 07:07:45 +00:00
c1c4251361
add pip3 commands to spec file
Brian Read
2024-12-18 11:03:22 +01:00
1fc294e8f6
Update with change in date format in logs
Brian Read
2024-12-18 06:36:42 +01:00
076e844898
Update spec file with python requirements
Brian Read
2024-12-18 06:35:42 +01:00
136a9416ec
Take out patches and add python3-mysql as a requirement
Brian Read
2024-12-17 20:01:57 +01:00
f2f570c87e
Add in uqpsmtpd log directory
Brian Read
2024-12-17 19:40:26 +01:00
1132efb828
Update README with specific Bugzilla links
Brian Read
2024-10-27 15:31:49 +00:00
edb71ad684
revert 8a506beb0f
Brian Read
2024-10-27 16:31:16 +01:00
8a506beb0f
Update README with specific Bugzilla links
Brian Read
2024-10-27 15:05:08 +00:00
c335e93def
Add in php routine to convert Tai64n string to date and time - untested
Brian Read
2024-07-26 06:24:51 +01:00
471cb25ad1
fix click link to stacked bar graph
Brian Read
2024-07-16 08:19:35 +01:00
b661e436fb
grey out web page printed date
Brian Read
2024-07-15 21:59:54 +01:00
3c1dc868aa
Add detailed level of drill down into logs
Brian Read
2024-07-15 16:15:39 +01:00
54ceac1ee8
Adjust summary displays
Brian Read
2024-07-15 11:06:44 +01:00
7eb3ff0048
Ignore the mailstats email
Brian Read
2024-07-15 10:26:52 +01:00
51912e5525
Fix link to underlying summary records for all dates
Brian Read
2024-07-15 09:36:06 +01:00
a1c9a698ee
Arrange to remeber the tab selected in web page
Brian Read
2024-07-15 06:35:15 +01:00
c7cf518477
Fix nav header for email
Brian Read
2024-07-14 12:33:40 +01:00
7ad144e3b0
More refinements to graphs
Brian Read
2024-07-14 12:13:41 +01:00
aa0ebc76e9
Move graph data and nav html inline to template
Brian Read
2024-07-14 08:20:09 +01:00
a9be56deae
Refine the stacked bar graph
Brian Read
2024-07-13 11:12:18 +01:00
e014d91060
derive graphs from main table
Brian Read
2024-07-12 20:09:13 +01:00
ddcde8fa07
Arrange that zero entries are blank
Brian Read
2024-07-12 10:35:44 +01:00
b0c63e61fd
Update comment on front of file
Brian Read
2024-07-01 09:14:22 +01:00
4997bbffa2
more format for the table plus supress links when no database saved
Brian Read
2024-07-01 08:54:19 +01:00
ae0e133918
make counts on main table link to SummaryLogs page - WIP
Brian Read
2024-06-30 15:38:42 +01:00
ce1db0a31b
Delete sql records for current day stats
Brian Read
2024-06-30 12:19:31 +01:00
f4f4c8173e
slight change in the format
Brian Read
2024-06-30 12:10:57 +01:00
61f9872e66
enhance display of summary log line
Brian Read
2024-06-30 12:05:54 +01:00
ebff1f3d78
fix select for all hours on Summary logs page
Brian Read
2024-06-30 09:10:57 +01:00
e94c96cb26
Increase table width to 98%
Brian Read
2024-06-30 08:30:13 +01:00
fcc2a6fce8
update httpd fragment to add in private public option
Brian Read
2024-06-28 14:57:57 +01:00
c5a708a382
Add in soft failure for sql delete
Brian Read
2024-06-28 10:41:04 +01:00
6cb877d358
Allow php execute in mailstats html dir
Brian Read
2024-06-28 05:56:48 +01:00
55575811e7
First shot at php page to drill down to summary logs
Brian Read
2024-06-28 05:30:49 +01:00
906448378f
Option to write out the summary logs to DB
Brian Read
2024-06-27 14:58:38 +01:00
68928375d8
Add in rejected flag in Badcountry table
Brian Read
2024-06-25 14:20:11 +01:00
1ef07f3acc
Typo fix
Brian Read
2024-06-25 12:53:58 +01:00
85dc97aa05
Fix up counts in main table
Brian Read
2024-06-25 12:52:12 +01:00
0947689c0f
FRix counts for naughty failures - dns, karma and helo
Brian Read
2024-06-19 22:44:21 +01:00
44b811d09e
Correct names of fields in summary record
Brian Read
2024-06-19 09:14:57 +01:00
6e81bf1600
Get sort working in saub tables
Brian Read
2024-06-18 16:31:11 +01:00