pier not storing emails

[Former user]

I have been testing Piler over the past few days... and so far have kept hitting a brick wall.

For some reason piler isnt storing the incomming emails.. it did the first 3 but after that stopped...

ERROR: index 'delta1': sql_connect: Access denied for user 'piler'@'localhost' (using password: YES) (DSN=mysql://piler:***@localhost:3306/piler).

yet the passward is correct well the one in /usr/local/etc/piler.conf and the one in the config-site.php are correct.. i can log into the database on a commend line with the same username and password..

I have checked the spinx database and it shows 3 records which is were it stopped..

[Dennis Morgan]

piler 1.1.0, build 884, Janos SUTO [e-mail]

Build Date: Fri Dec 12 20:21:18 UTC 2014 ldd version: ldd (Ubuntu EGLIBC 2.19-0ubuntu6.4) 2.19 gcc version: gcc version 4.8.2 (Ubuntu 4.8.2-19ubuntu1) Configure command: ./configure --localstatedir=/var --with-database=mysql --enable-starttls --enable-tcpwrappers

and access thu the web ui..

40000000548d53103894851c007881a00074: from=[e-mail], size=8701/2328, attachments=0, reference=CANtR4a4GsEFH9-KLpUd1QvwesmAw9aNhF-_6G3iHox1=[e-mail], message-id=CANtR4a5RT2P30nsf9ZYD7+3b7UxCxZ=[e-mail], retention=9999, delay=0.04, delays=0.04/0.00/0.00/0.00/0.00/0.00, status=stored

shown in the mail.log but when i log into piler it doesnt show up..

[Janos SUTO]

Check out sphinx.conf,and verify that the mysql settings, including the password, are correct.

[Dennis Morgan]

i just checked it sphinx.conf in /etc and in /usr/local/etc just to be safe and the password and userid is correct..

could it have been conflicting copies of sphinx.conf??? its behaving now.. thanks for the help..

[Janos SUTO]

yes, it's possible. In /usr/local/libexec/piler/indexer.*.sh you may fix the config file path by adding --config /path/to/your/real/sphinx.conf

[Janos SUTO]

I hope everything is ok by now. Otherwise reopen the issue.

[nitin patil]

I am not found /usr/local/libexec/piler/indexer..sh file on same location. And getting following error ERROR: index 'main1': sql_connect: Access denied for user 'piler'@'localhost' (using password: YES) (DSN=mysql://piler:**@localhost:3306/piler). total 0 docs, 0 bytes

[Janos SUTO]

Perhaps you have an older piler release which doesn't have the indexer.*.sh files. If the sphinx indexer can't connect to mysql, then either the username, or password or the mysql host or socket must be wrong. Anyway why don't you post it to the mailing list since it's obvious it's not a bug in the software.

[nitin patil]

thanks i have raise issue.Issue #655