Piler Export Mail Issue

[Venkateswarlu Dadagopu]

pilerexport -A

cannot open: 415229.eml cannot open: 415951.eml cannot open: 415960.eml cannot open: 416681.eml cannot open: 416683.eml cannot open: 416684.eml cannot open: 416685.eml cannot open: 416686.eml cannot open: 416687.eml cannot open: 416688.eml cannot open: 416689.eml cannot open: 416690.eml cannot open: 416691.eml cannot open: 417034.eml cannot open: 418802.eml cannot open: 419027.eml cannot open: 419474.eml cannot open: 419697.eml cannot open: 419719.eml cannot open: 419756.eml cannot open: 419789.eml cannot open: 419846.eml cannot open: 420818.eml cannot open: 420893.eml cannot open: 420902.eml cannot open: 420910.eml cannot open: 420917.eml cannot open: 422025.eml cannot open: 422026.eml cannot open: 422027.eml cannot open: 422028.eml cannot open: 422029.eml cannot open: 422030.eml cannot open: 422031.eml

[Venkateswarlu Dadagopu]

i went to tmp directory try to export the mail not showing anything

[root@archive tmp]# ll total 0 [root@archive tmp]# pwd /tmp [root@archive tmp]# pilerexport -A [root@archive tmp]#

[Janos SUTO]

Execute "select count(*) from metadata table;" and if it also says you have an unsupported engine type of innodb, then it's time to fix your mysql database first. Also, check the maillog for clues why pilerexport does nothing in the /tmp directory.

[Venkateswarlu Dadagopu]

mysql> select count(*) from metadata table; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table' at line 1

[Venkateswarlu Dadagopu]

mysql> select count() from metadata; +----------+ | count() | +----------+ | 469750 | +----------+ 1 row in set (0.46 sec)

[Venkateswarlu Dadagopu]

mysql> select count() from metadata tables; +----------+ | count() | +----------+ | 469750 | +----------+ 1 row in set (0.17 sec)

[Janos SUTO]

ok, that looks correct. Now go to /tmp, and export today's emails: pilerexport -a 2014.07.30 -b 2014.07.30. Note that "pilerexport -A" takes time

[Venkateswarlu Dadagopu]

Ok But In /tmp directory I don't have that much space I have other new mount point with lot of space Can I use that one

I tried there but is not working only /tmp directory only working how could i use other mount point to export mails.

[Janos SUTO]

Try with /var/tmp or with any directory that piler user has write permissions. As a last resort you may chown a directory to piler:piler temporarily.

[Venkateswarlu Dadagopu]

Ok Thank You

[Venkateswarlu Dadagopu]

While Export Mails using pilerexport -A

I have around 1000000 mails some mail getting error link this.

verification failed

verification FAILED. 321995.eml
verification FAILED. 321996.eml
verification FAILED. 321997.eml
verification FAILED. 322001.eml
verification FAILED. 322003.eml
verification FAILED. 322005.eml
verification FAILED. 322006.eml
verification FAILED. 322007.eml
verification FAILED. 322009.eml
verification FAILED. 322010.eml
verification FAILED. 322158.eml
verification FAILED. 322953.eml
verification FAILED. 322954.eml
verification FAILED. 322981.eml
verification FAILED. 322982.eml
verification FAILED. 322985.eml
verification FAILED. 323005.eml
verification FAILED. 323008.eml
verification FAILED. 323139.eml
verification FAILED. 323141.eml
verification FAILED. 323143.eml
verification FAILED. 323484.eml
verification FAILED. 323671.eml
verification FAILED. 323673.eml
verification FAILED. 323689.eml
verification FAILED. 323699.eml
verification FAILED. 323793.eml
verification FAILED. 323837.eml
verification FAILED. 323838.eml
verification FAILED. 323845.eml
verification FAILED. 323877.eml
verification FAILED. 323879.eml
verification FAILED. 323892.eml
verification FAILED. 323937.eml
verification FAILED. 323946.eml
verification FAILED. 323950.eml
verification FAILED. 323977.eml
verification FAILED. 324001.eml
verification FAILED. 324018.eml
verification FAILED. 324022.eml
verification FAILED. 324024.eml
verification FAILED. 324040.eml
verification FAILED. 324080.eml
verification FAILED. 324265.eml
verification FAILED. 324276.eml
verification FAILED. 325619.eml
verification FAILED. 325629.eml
verification FAILED. 325630.eml
verification FAILED. 325857.eml
verification FAILED. 325880.eml
verification FAILED. 327271.eml

how do i check how many mails verification failed is there any logs to check that.