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
