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

[nitin patil]

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.

[Janos SUTO]

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.

[nitin patil]

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

[nitin patil]

[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

[Janos SUTO]

Find me on skype (janos.suto), and I'll help you in a teamviewer session.

[nitin patil]

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

[nitin patil]

Hi Jsuto, Please help me for it

[eXtremeSHOK]

Can you login and run a query as that myself user?

[nitin patil]

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

[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;"

[nitin patil]

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)

[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

[nitin patil]

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

[nitin patil]

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

[Janos SUTO]

Dear Lord! Then try using an empty password for the piler user.

[nitin patil]

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';

[nitin patil]

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.

[Janos SUTO]

Great! I'm always glad when it turns out it wasn't a major/critical/lethal/... bug.