Hi all,

I have searched email successfully on WebUI.

But when I click on email title, following errors are displayed:

no permission for 5
no permission for 7
...

Maillog does not show anything.

Apr 11 18:10:57 ldap-2 piler-webui[13897]: sphinx query: 'SELECT id FROM main1 WHERE MATCH('(@from & @to viet)') ORDER BY `sent` DESC LIMIT 0,1000 OPTION max_matches=1000' in 0.00 s, 5 hits






I have set Piler's verbosity to 5.

I also tried config Piler to use root user in mysql but no luck.

root@ldap-2:~# mysql -h 127.0.0.1 -u piler -p piler

mysql> select count(*) from metadata;
+----------+
| count(*) |
+----------+
|       10 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from sph_index;
+----------+
| count(*) |
+----------+
|        2 |
+----------+
1 row in set (0.01 sec)



root@ldap-2:~# mysql -h 127.0.0.1 -u piler -p piler --dport 9306

mysql> select * from main1;
+------+------------+------------+-------+-----------+--------+-------------+
| id | arrived | sent | size | direction | folder | attachments |
+------+------------+------------+-------+-----------+--------+-------------+
| 1 | 1365675218 | 1365675218 | 5610 | 0 | 0 | 0 | | 2 | 1365675419 | 1365675419 | 5929 | 0 | 0 | 0 | | 3 | 1365675419 | 1365675419 | 4452 | 0 | 0 | 0 | | 4 | 1365675419 | 1365675419 | 5594 | 0 | 0 | 0 | | 5 | 1365675419 | 1365675419 | 5612 | 0 | 0 | 0 | | 6 | 1365675719 | 1365675719 | 10295 | 0 | 0 | 0 | | 7 | 1365675719 | 1365675719 | 10295 | 0 | 0 | 0 |
+------+------------+------------+-------+-----------+--------+-------------+
7 rows in set (0.00 sec)

root@ldap-2:~#  ls -la /var/piler/sphinx
total 184
drwx------  2 piler piler  4096 Apr 11 17:37 .
drwxr-xr-x 16 piler piler  4096 Apr 11 17:19 ..
-rw-r--r--  1 piler piler     0 Apr 11 17:29 delta1.spa
-rw-r--r--  1 piler piler     1 Apr 11 17:29 delta1.spd
-rw-r--r--  1 piler piler   582 Apr 11 17:29 delta1.sph
-rw-r--r--  1 piler piler     1 Apr 11 17:29 delta1.spi
-rw-r--r--  1 piler piler     0 Apr 11 17:29 delta1.spk
-rw-------  1 piler piler     0 Apr 11 17:37 delta1.spl
-rw-r--r--  1 piler piler     0 Apr 11 17:29 delta1.spm
-rw-r--r--  1 piler piler     1 Apr 11 17:29 delta1.spp
-rw-r--r--  1 piler piler     1 Apr 11 17:29 delta1.sps
-rw-r--r--  1 piler piler   308 Apr 11 17:29 main1.spa
-rw-r--r--  1 piler piler 13657 Apr 11 17:29 main1.spd
-rw-r--r--  1 piler piler   582 Apr 11 17:29 main1.sph
-rw-r--r--  1 piler piler 10261 Apr 11 17:29 main1.spi
-rw-r--r--  1 piler piler     0 Apr 11 17:29 main1.spk
-rw-------  1 piler piler     0 Apr 11 17:37 main1.spl
-rw-r--r--  1 piler piler     0 Apr 11 17:29 main1.spm
-rw-r--r--  1 piler piler 14160 Apr 11 17:29 main1.spp
-rw-r--r--  1 piler piler     1 Apr 11 17:29 main1.sps
-rw-r--r--  1 piler piler     0 Apr 11 10:47 main2.spa
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main2.spd
-rw-r--r--  1 piler piler   582 Apr 11 10:47 main2.sph
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main2.spi
-rw-r--r--  1 piler piler     0 Apr 11 10:47 main2.spk
-rw-------  1 piler piler     0 Apr 11 17:37 main2.spl
-rw-r--r--  1 piler piler     0 Apr 11 10:47 main2.spm
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main2.spp
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main2.sps
-rw-r--r--  1 piler piler     0 Apr 11 10:47 main3.spa
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main3.spd
-rw-r--r--  1 piler piler   582 Apr 11 10:47 main3.sph
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main3.spi
-rw-r--r--  1 piler piler     0 Apr 11 10:47 main3.spk
-rw-------  1 piler piler     0 Apr 11 17:37 main3.spl
-rw-r--r--  1 piler piler     0 Apr 11 10:47 main3.spm
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main3.spp
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main3.sps
-rw-r--r--  1 piler piler     0 Apr 11 10:47 main4.spa
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main4.spd
-rw-r--r--  1 piler piler   582 Apr 11 10:47 main4.sph
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main4.spi
-rw-r--r--  1 piler piler     0 Apr 11 10:47 main4.spk
-rw-------  1 piler piler     0 Apr 11 17:37 main4.spl
-rw-r--r--  1 piler piler     0 Apr 11 10:47 main4.spm
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main4.spp
-rw-r--r--  1 piler piler     1 Apr 11 10:47 main4.sps
-rw-r--r--  1 piler piler     0 Apr 11 17:29 note1.spa
-rw-r--r--  1 piler piler     1 Apr 11 17:29 note1.spd
-rw-r--r--  1 piler piler   289 Apr 11 17:29 note1.sph
-rw-r--r--  1 piler piler     1 Apr 11 17:29 note1.spi
-rw-r--r--  1 piler piler     0 Apr 11 17:29 note1.spk
-rw-------  1 piler piler     0 Apr 11 17:37 note1.spl
-rw-r--r--  1 piler piler     0 Apr 11 17:29 note1.spm
-rw-r--r--  1 piler piler     1 Apr 11 17:29 note1.spp
-rw-r--r--  1 piler piler     1 Apr 11 17:29 note1.sps
-rw-r--r--  1 piler piler     0 Apr 11 17:29 tag1.spa
-rw-r--r--  1 piler piler     1 Apr 11 17:29 tag1.spd
-rw-r--r--  1 piler piler   288 Apr 11 17:29 tag1.sph
-rw-r--r--  1 piler piler     1 Apr 11 17:29 tag1.spi
-rw-r--r--  1 piler piler     0 Apr 11 17:29 tag1.spk
-rw-------  1 piler piler     0 Apr 11 17:37 tag1.spl
-rw-r--r--  1 piler piler     0 Apr 11 17:29 tag1.spm
-rw-r--r--  1 piler piler     1 Apr 11 17:29 tag1.spp
-rw-r--r--  1 piler piler     1 Apr 11 17:29 tag1.sps



Regards,

Viet Hoang


Reply via email to