unable to authenticate using auth_file plugin from command line

Bug #596163 reported by Joe Daly
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)
Changed in drizzle:
importance: Undecided → High
assignee: nobody → Vijay Samuel (vjsamuel)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.