> > The package is installed. To clarify, I mean the accounting page (not
> > statistics, statistics displays correctly, sorry!) shows no e-mails,
> > although all other areas say otherwise.
>
> I see. Please check piler's cron jobs whether it includes something
> like
>
> 30 6 * * * /usr/local/libexec/piler/generate_stats.php
> /srv/www/webui.yourdomain.com <http://www/webui.yourdomain.com>
>
> this script populates the accounting table which is used by the gui.
> Note that you should have admin role/rights to see it.
I have added this to piler's crontab - when I run the command manually (as the
piler user) I get the following output:
/usr/local/libexec/piler/generate_stats.php: line 1: ?php: No such file or
directory
/usr/local/libexec/piler/generate_stats.php: line 2: //: is a directory
/usr/local/libexec/piler/generate_stats.php: line 3: =: command not found
/usr/local/libexec/piler/generate_stats.php: line 4: =: command not found
/usr/local/libexec/piler/generate_stats.php: line 5: =: command not found
/usr/local/libexec/piler/generate_stats.php: line 6: =: command not found
/usr/local/libexec/piler/generate_stats.php: line 7: syntax error near
unexpected token `('
/usr/local/libexec/piler/generate_stats.php: line 7: `$timestart =
microtime(true);'
> > I was about to say that I still get no results on the search page,
> > however upon checking again, I can see 2 e-mails for my user account
> > (funnily enough the confirmation e-mails for this mailing list!)
> > although there were other e-mails processed earlier for the same user
> > account which haven't shown up. Any thoughts?
>
> try to login as an auditor user and check if you can see more emails
> (actually any of your previously imported emails).
>
> For regular users the gui applies a filter on the email address. You
> may
> check it by enabling syslog in config-site.php, and looking your
> maillog.
> Also note that by default your received emails are shown. You have to
> explicitly specify with from: [email protected] if you want to see
> your
> sent emails.
>
> So I suspect that the gui was unable to determine all your addresses.
> Please
> check whether you can see all your email addresses on the settings
> page.
Interesting. On the settings page my e-mail address is shown correctly. I still
only see two e-mails in my archive. However I have now also logged in as an
auditor, and can see all the e-mails. Including one or two to my address that
haven't shown up in my own archive yet??? I'm wondering if this is the same
e-mail address detection issue (re: LDAP - in this case Active Directory) that
was experienced by another user on the mailing list?
> >>> Running a query against sphinxql main1 shows no results. I have
> >>> tried
> >>> re-indexing. Any pointers would be greatly appreciated.
>
> check your cron jobs to have similar like
>
> 5,35 * * * ** /usr/local/bin/indexer --quiet delta1 --rotate && sleep 2
> && \
> /usr/local/bin/indexer --quiet --merge main1 delta1
> --merge-dst-range deleted 0 0 --rotate
>
> you may su to piler, and run manually (make sure you don't run this at
> the
> same time when it's run from crontab).
This is in my crontab, and I have now run manually. I receive no output,
however when running the SphinxQL query against main1 again I get the following:
mysql> select * from main1;
+------+------------+------------+--------+-----------+--------+-------------+
| id | arrived | sent | size | direction | folder | attachments |
+------+------------+------------+--------+-----------+--------+-------------+
| 10 | 1369319294 | 1369319294 | 33333 | 0 | 0 | 0 |
| 11 | 1369319525 | 1369319525 | 33350 | 0 | 0 | 0 |
| 12 | 1369321735 | 1369321735 | 13342 | 0 | 0 | 0 |
| 13 | 1369322151 | 1369322151 | 38124 | 0 | 0 | 0 |
| 14 | 1369322470 | 1369322470 | 14972 | 0 | 0 | 0 |
| 15 | 1369323367 | 1369323367 | 110394 | 0 | 0 | 6 |
| 16 | 1369328262 | 1369328262 | 18099 | 0 | 0 | 0 |
| 17 | 1369328622 | 1369328622 | 36915 | 0 | 0 | 0 |
| 18 | 1369328622 | 1369328622 | 25832 | 0 | 0 | 0 |
| 19 | 1369329126 | 1369329126 | 82211 | 0 | 0 | 0 |
| 20 | 1369331731 | 1369331731 | 20804 | 0 | 0 | 0 |
| 21 | 1369332101 | 1369332101 | 45866 | 0 | 0 | 0 |
| 22 | 1369332242 | 1369332242 | 61537 | 0 | 0 | 0 |
| 23 | 1369333672 | 1369333672 | 45606 | 0 | 0 | 0 |
| 24 | 1369333843 | 1369333843 | 10989 | 0 | 0 | 0 |
| 25 | 1369335071 | 1369335071 | 1852 | 0 | 0 | 0 |
| 26 | 1369335168 | 1369335168 | 1347 | 0 | 0 | 0 |
| 27 | 1369337552 | 1369337552 | 38537 | 0 | 0 | 0 |
| 28 | 1369337837 | 1369337837 | 5754 | 2 | 0 | 0 |
| 29 | 1369340211 | 1369340211 | 3977 | 0 | 0 | 0 |
+------+------------+------------+--------+-----------+--------+-------------+
20 rows in set (0.00 sec)
Does this look about right? The Admin Dashboard stats say 69 e-mails received,
14 duplicates, 55 processed.
Many thanks again for your help with this.
Adam
