Can see 13 million emails. But when searching with keyword, it shows Empty Search.

[Ratnateja Thaduri]

Hi, I am having trouble with Search in the GUI. I have reindexed all the emails. I see everything (Even on GUI) but when I try to search with any keyword, I get empty search. But If I select any date range, I get emails between those range.

‌

i am not a database person. It was setup by an engineer before me. i would like to get some help to understand and fix this issue.

‌

Thanks

Ratna

[Ratnateja Thaduri]

FYI - I have searched other resolved issues. Added SPHINX_STRICT_SCHEMA = 0.
Still same issue.

[Janos SUTO]

We are discussing it via skype

[chris]

Just installed a fresh new system, on newest ubuntu, and get the same issue. However I can’t get any search results if I change anything. But I see all my tests counts properly in the admin GUI.

Oct 2 11:01:49 piler01 piler-webui[889]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE sent >= 1633046400 AND sent <= 1633219199 AND MATCH('') ORDER BY sent DESC LIMIT 0,50 OPTION max_matches=1000' in 0.00 s, 0 hits, 0 total found
Oct 2 11:03:56 piler01 piler-webui[888]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE sent >= 1630454400 AND sent <= 1633219199 AND MATCH('') ORDER BY sent DESC LIMIT 0,50 OPTION max_matches=1000' in 0.00 s, 0 hits, 0 total found
Oct 2 11:03:58 piler01 piler-webui[889]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('') ORDER BY sent DESC LIMIT 0,50 OPTION max_matches=1000' in 0.00 s, 0 hits, 0 total found
Oct 2 11:04:09 piler01 piler-webui[888]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE sent >= 1630454400 AND sent <= 1633219199 AND MATCH('') ORDER BY sent DESC LIMIT 0,50 OPTION max_matches=1000' in 0.00 s, 0 hits, 0 total found

[Janos SUTO]

You are narrowing the search to a date range. Don’t. Just hit the search button, and see if you get some search hits. Then type a single word from a subject that you can see in the upper pane, and let’s see what happens.

[chris]

I seem to have fixed it. I deleted the index and redid it many many times, with the different users. Seems like I needed to do it with the piler user.

Thanks for your help. Off topic question, since the documentation for user authentication is very limited. Where can I read up on having 1 user view only their own email? I have it setup for a domain user to see all mail, but I can’t get a single user to see their own mail.

‌

‌

[Janos SUTO]

I’m not sure about the user authentication question. Every user can see his own emails only. Auditor role users can see all emails in the organization.

[chris]

For example I’ve got:

Email addresses: [e-mail]
Username: [e-mail]
Realname: [e-mail]
Domain: domain.com                                       
Search domains*:
Domain(s)**: domain.com

And set to auditor, and it shows all mails from the system.

If I set it to a user, it shows only INBOUND messages, and has a “no permission for ##” error message.

Something needs to be adjusted I think, and its almost there.

‌

[Janos SUTO]

It’s possible. Check the v_messages view for the given message, also check if the “from” or “to” addresses list one of the user’s email addresses that he can see in the user settings.

[chris]

What do you mean by v_messages? The from ONLY shows messages SENT from the mailbox. Nothing shows as TO that mailbox. Shouldn’t it show both in and outbound messages?

But in auditor mode it shows all INBOUND/OUTBOUND mails fine.

[Janos SUTO]

v_messages is a view in the piler database. Show me both the sphinx query logged to the mail log as well as the user’s email addresses shown in the top-right corner settings menu.

[chris]

Query from auditor:

Oct 4 00:09:55 piler01 piler-webui[899]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('') ORDER BY sent DESC LIMIT 0,20 OPTION max_matches=1000' in 0.00 s, 20 hits, 206 total found
Oct 4 00:09:56 piler01 piler-webui[900]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('') ORDER BY sent DESC LIMIT 0,20 OPTION max_matches=1000' in 0.00 s, 20 hits, 206 total found

access settings

You always have access to your own email addresses. For auditor access to specific groups or domains, please contact your archive administrator.

Shows all mail in and out as expected.

‌

Query from user:

Oct 4 00:12:45 piler01 piler-webui[899]: username=[e-mail], event='logged in', ipaddr=126.90.123.210
Oct 4 00:12:46 piler01 piler-webui[899]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH(' ( (@sender testXaccountXca) | (@rcpt testXaccountXca) ) ') ORDER BY sent DESC LIMIT 0,20 OPTION max_matches=1000' in 0.00 s, 4 hits, 4 total found
Oct 4 00:12:46 piler01 piler-webui[900]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH(' ( (@sender testXaccountXca) | (@rcpt testXaccountXca) ) ') ORDER BY sent DESC LIMIT 0,20 OPTION max_matches=1000' in 0.00 s, 4 hits, 4 total found

‌

Shows 4 results which is ONLY mail sent FROM account.

settings

access settings

You always have access to your own email addresses. For auditor access to specific groups or domains, please contact your archive administrator.

‌