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

Issue #655 resolved
nitin patil created an issue

Hi We are installing piler-0.1.23 after postinstall once we try to run indexer --all that time we are getting following error. Access denied for user 'piler'@'localhost' (using password: YES) (DSN=mysql://piler:***@localhost:3306/piler).

Also we have not found /usr/local/libexec/piler/indexer.*.sh on same location. Please help me.

Comments (17)

  1. Janos SUTO repo owner

    0.1.23 doesn't feature the indexer shell scripts. Running indexer --all is required during the installation process only. Its task is to initialise the sphinx indices. After that you should not run it, unless you were told.

    I'd suggest you to check piler user crontab, 'su' to user piler, and run the delta index, and see if it can read the sph_index table from the piler database. Also double check the connection parameters in sphinx.conf, and I suggest to test it using the mysql utility whether they are ok for connecting.

  2. nitin patil reporter

    Thanks Jsuto.. I have check cronjob but it is showing blank. Also I am new in piler so request you to help me how to run delta index. I run following comman.

    su piler sh-4.1$ reindex -a reindex: error while loading shared libraries: libpiler.so: cannot open shared object file: No such file or directory

  3. nitin patil reporter

    [root@inzimm02 inzimm02.tcszim.com]# service mailpiler start && service searchd start /usr/local/sbin/pilerconf: error while loading shared libraries: libpiler.so: cannot open shared object file: No such file or directory

  4. nitin patil reporter

    hi jsuto skype is not allowed here let me know your free time so will share the webx session with you

  5. nitin patil reporter

    Now piler is started but i am getting following error.

    while trying to telnet mysql

    [root@inzimm02 log]# telnet localhost 3306 Trying ::1... telnet: connect to address ::1: Connection refused Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 4 5.1.73vW22A3yjR>{rK^uU*nnConnection closed by foreign host.

    Error: SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'inzimm02.tcszim.com' (13) on database: piler

  6. eXtremeSHOK

    you don't use telnet to check mysql.

    Use mysql client on the command line ie.

    mysql -u "piler@localhost" -p -d "piler" -e "show tables;"

  7. nitin patil reporter

    thanks.. I run given command and getting following error.

    [root@inzimm02 ~]# mysql -u "piler@localhost" -p "piler" -e "show tables;" Enter password: ERROR 1045 (28000): Access denied for user 'piler@localhost'@'localhost' (using password: YES)

  8. eXtremeSHOK

    This is not a piler issue. You have mysql errors.

    Either you have not created the piler user for mysql or your password/permissions for that user are wrong

  9. nitin patil reporter

    Hi, Can you tell me how to create piler user also how to set password/permissions for that user.

  10. nitin patil reporter

    while postinstall utility for piler i just click enter button for each entry.

    Please enter the webserver groupname [apache]

    Please enter mysql hostname [localhost]

    Please enter mysql database [piler]

    Please enter mysql user name [piler]

    Please enter mysql password for piler []

    Please enter mysql root password [] mysql connection successful

  11. nitin patil reporter

    Sorry Jsuto i am understand your condition. But i have not worked on Linux evn. Also I set mysql password for piler is password, Which is working fine. but not understand why it is showing Access denied for user 'piler@localhost'@'localhost. If i want to create piler user for mysql then how to create it.

    $config['DB_DRIVER'] = 'mysql'; $config['DB_PREFIX'] = ''; $config['DB_HOSTNAME'] = 'inzimm02.tcszim.com'; $config['DB_USERNAME'] = 'piler'; $config['DB_PASSWORD'] = 'password'; $config['DB_DATABASE'] = 'piler';

  12. nitin patil reporter

    Thanks Justo, issue resolved now after recreate piler database. Now piler is working fine. Now i am start working on URL. Thanks for your support. Sincerely appreciate it.

  13. Log in to comment