pier not storing emails

Issue #459 resolved
Former user created an issue

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..

Comments (8)

  1. Dennis Morgan

    piler 1.1.0, build 884, Janos SUTO sj@acts.hu

    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=dennis.blackbear@gmail.com, size=8701/2328, attachments=0, reference=CANtR4a4GsEFH9-KLpUd1QvwesmAw9aNhF-_6G3iHox1=DfPSeg@mail.gmail.com, message-id=CANtR4a5RT2P30nsf9ZYD7+3b7UxCxZ=mvRTMOh5A+bdreJypMA@mail.gmail.com, 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..

  2. Janos SUTO repo owner

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

  3. 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..

  4. Janos SUTO repo owner

    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

  5. 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

  6. Janos SUTO repo owner

    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.

  7. Log in to comment