Access denied for user 'piler'@'localhost' (using password: YES) (DSN=mysql://piler:***@localhost:3306/piler)
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)
-
repo owner -
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
-
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
-
repo owner Find me on skype (janos.suto), and I'll help you in a teamviewer session.
-
reporter hi jsuto skype is not allowed here let me know your free time so will share the webx session with you
-
reporter Hi Jsuto, Please help me for it
-
Can you login and run a query as that myself user?
-
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
-
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;"
-
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)
-
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
-
reporter Hi, Can you tell me how to create piler user also how to set password/permissions for that user.
-
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
-
repo owner Dear Lord! Then try using an empty password for the piler user.
-
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';
-
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.
-
repo owner - changed status to resolved
Great! I'm always glad when it turns out it wasn't a major/critical/lethal/... bug.
- Log in to comment
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.