unable to authenticate using auth_file plugin from command line

Bug #596163 reported by Joe Daly on 2010-06-19
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
High
Vijay Samuel
Dexter
Fix Released
High
Vijay Samuel

Bug Description

I basically ran the auth_file/tests/t/basic.test using the drizzle client. I was not able to connect using a password on the command line, however I was able to connect using a password if I did not specify a password arg, just put --password. Heres my setup and tests:

* Started the Server
jdaly@rx7:~/drizzle/repos/scoreboard_user_stats/tests> ../drizzled/drizzled --no-defaults --basedir=$PWD --datadir=$PWD/var --plugin-add=auth_file --auth-file-users=/home/jdaly/users.out

* My authentication file
jdaly@rx7:~> cat users.out
root
auth_file
auth_file_password:test_password
jdaly@rx7:~>

* Tried to connect as auth_file that works
jdaly@rx7:~/drizzle/repos/scoreboard_user_stats/tests> ../client/drizzle --user=auth_file
Welcome to the Drizzle client.. Commands end with ; or \g.
Your Drizzle connection id is 68
Server version: 2010.06.1619 Source distribution (scoreboard_user_stats)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

drizzle>

* Tried to connect as auth_file_password that didnt work it should have.

jdaly@rx7:~/drizzle/repos/scoreboard_user_stats/tests> ../client/drizzle --user=auth_file_password --password=test_password
ERROR 1045 (28000): Access denied for user 'auth_file_password'@'::1' (using password: YES)
jdaly@rx7:~/drizzle/repos/scoreboard_user_stats/tests>

* Tried to connect as auth_file_password not specifying the password arg on the command line that worked, I also tried a couple bad passwords and no password those did not work, so it appears there is probably some command line processing going wrong.

jdaly@rx7:~/drizzle/repos/scoreboard_user_stats/tests> ../client/drizzle --user=auth_file_password --password
Enter password: *************
Welcome to the Drizzle client.. Commands end with ; or \g.
Your Drizzle connection id is 69
Server version: 2010.06.1619 Source distribution (scoreboard_user_stats)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

drizzle>

Related branches

Monty Taylor (mordred) on 2010-06-19
Changed in drizzle:
importance: Undecided → High
assignee: nobody → Vijay Samuel (vjsamuel)
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers